-
Notifications
You must be signed in to change notification settings - Fork 16
/
Copy pathext_tables.sql
76 lines (68 loc) · 2.22 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
#
# Table structure for table 'tx_jpfaq_domain_model_question'
#
CREATE TABLE tx_jpfaq_domain_model_question (
question varchar(255) DEFAULT '' NOT NULL,
answer text NOT NULL,
additional_content_answer int(11) unsigned DEFAULT '0' NOT NULL,
categories int(11) unsigned DEFAULT '0' NOT NULL,
questioncomment int(11) unsigned DEFAULT '0' NOT NULL,
helpful int(11) unsigned DEFAULT '0' NOT NULL,
nothelpful int(11) unsigned DEFAULT '0' NOT NULL
);
# IRRE Records
CREATE TABLE tt_content (
jpfaq int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_jpfaq_domain_model_category'
#
CREATE TABLE tx_jpfaq_domain_model_category (
category varchar(255) DEFAULT '' NOT NULL,
description text NOT NULL,
categorycomment int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_jpfaq_question_category_mm'
#
CREATE TABLE tx_jpfaq_question_category_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jpfaq_domain_model_questioncomment'
#
CREATE TABLE tx_jpfaq_domain_model_questioncomment (
question int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
comment text NOT NULL,
ip varchar(255) DEFAULT 'local' NOT NULL,
finfo varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_jpfaq_domain_model_categorycomment'
#
CREATE TABLE tx_jpfaq_domain_model_categorycomment (
category int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
comment text NOT NULL,
ip varchar(255) DEFAULT 'local' NOT NULL,
finfo varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_jpfaq_category_comment_mm'
#
CREATE TABLE tx_jpfaq_category_comment_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);