-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathext_tables.sql
109 lines (89 loc) · 2.64 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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
#
# Table structure for table 'tx_webetatext_text'
#
CREATE TABLE tx_webetatext_text (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
fe_cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
TextID tinytext,
Version int(11) DEFAULT '1' NOT NULL,
Content text,
ContentRaw text,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_webetatext_comment'
#
CREATE TABLE tx_webetatext_comment (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
fe_cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
TextID tinytext,
TextVersion int(11) DEFAULT '0' NOT NULL,
Content text,
CommentedText text,
StartIndex int(11) DEFAULT '0' NOT NULL,
EndIndex int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_webetatext_vote'
#
CREATE TABLE tx_webetatext_vote (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
fe_cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
CommentID int(11) DEFAULT '0' NOT NULL,
Value tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_webetatext_process (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
sort int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
StepIndex varchar(10) DEFAULT '0' NOT NULL,
IsCurrent tinyint(4) DEFAULT '0' NOT NULL,
Content text,
Link text,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_webetatext_logo blob NOT NULL,
tx_webetatext_verified tinyint(4) DEFAULT '0' NOT NULL,
tx_webetatext_verification_requested tinyint(4) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
tx_webetatext_enable tinyint(4) DEFAULT '1' NOT NULL,
tx_webetatext_infomail_to varchar(255) DEFAULT '' NOT NULL,
tx_webetatext_pstep_title varchar(255) DEFAULT '' NOT NULL
);