-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathext_tables.sql
178 lines (148 loc) · 4.48 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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
#
# Table structure for table 'tx_oelib_test'
#
CREATE TABLE tx_oelib_test (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
object_type int(11) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext,
friend int(11) unsigned DEFAULT '0' NOT NULL,
owner int(11) unsigned DEFAULT '0' NOT NULL,
children tinytext,
related_records int(11) unsigned DEFAULT '0' NOT NULL,
bidirectional int(11) unsigned DEFAULT '0' NOT NULL,
composition int(11) unsigned DEFAULT '0' NOT NULL,
composition2 int(11) unsigned DEFAULT '0' NOT NULL,
float_data float(9,6) DEFAULT '0.000000' NOT NULL,
decimal_data decimal(10,3) DEFAULT '0.000' NOT NULL,
string_data tinytext,
header tinytext,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record),
KEY object_type (object_type)
);
#
# Table structure for table 'tx_oelib_testchild'
#
CREATE TABLE tx_oelib_testchild (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title tinytext,
parent int(11) unsigned DEFAULT '0' NOT NULL,
tx_oelib_parent2 int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_oelib_test_article_mm'
#
CREATE TABLE tx_oelib_test_article_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,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'be_users'
#
CREATE TABLE be_users (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'fe_groups'
#
CREATE TABLE fe_groups (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_template'
#
CREATE TABLE sys_template (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_file'
#
CREATE TABLE sys_file (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_file_collection'
#
CREATE TABLE sys_file_collection (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_file_reference'
#
CREATE TABLE sys_file_reference (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_category'
#
CREATE TABLE sys_category (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);
#
# Table structure for table 'sys_category_record_mm'
#
CREATE TABLE sys_category_record_mm (
tx_oelib_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY dummy (tx_oelib_is_dummy_record)
);