forked from oliverklee/ext-phpunit
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
165 lines (134 loc) · 4.1 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
#
# Table structure for table 'tx_phpunit_test'
#
CREATE TABLE tx_phpunit_test (
uid int(11) unsigned 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,
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 varchar(255) DEFAULT '' NOT NULL,
related_records int(11) unsigned DEFAULT '0' NOT NULL,
bidirectional int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY phpunit_dummy (is_dummy_record)
);
#
# Table structure for table 'tx_phpunit_testchild'
#
CREATE TABLE tx_phpunit_testchild (
uid int(11) unsigned 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,
PRIMARY KEY (uid),
KEY parent (pid),
KEY phpunit_dummy (is_dummy_record)
);
#
# Table structure for table 'tx_phpunit_test_article_mm'
#
CREATE TABLE tx_phpunit_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 phpunit_dummy (is_dummy_record)
);
#
# Table structure for table 'be_users'
#
CREATE TABLE be_users (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'fe_groups'
#
CREATE TABLE fe_groups (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_template'
#
CREATE TABLE sys_template (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_file'
#
CREATE TABLE sys_file (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_file_collection'
#
CREATE TABLE sys_file_collection (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_file_reference'
#
CREATE TABLE sys_file_reference (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_category'
#
CREATE TABLE sys_category (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);
#
# Table structure for table 'sys_category_record_mm'
#
CREATE TABLE sys_category_record_mm (
tx_phpunit_is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
KEY phpunit_dummy (tx_phpunit_is_dummy_record)
);