1db0eac634f2921854b9bdb407c5a5a96c616b2e
[Packages/TYPO3.CMS.git] / typo3 / sysext / extbase / Tests / Functional / Fixtures / Extensions / blog_example / ext_tables.sql
1 #
2 # Table structure for table 'tx_blogexample_domain_model_blog'
3 #
4 CREATE TABLE tx_blogexample_domain_model_blog (
5 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
7
8 title varchar(255) DEFAULT '' NOT NULL,
9 description text NOT NULL,
10 logo tinyblob NOT NULL,
11 administrator int(11) DEFAULT '0' NOT NULL,
12
13 posts varchar(255) DEFAULT '' NOT NULL,
14
15 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
16 crdate int(11) unsigned DEFAULT '0' NOT NULL,
17 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
18 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
19 fe_group varchar(100) DEFAULT '0' NOT NULL,
20
21 t3ver_oid int(11) DEFAULT '0' NOT NULL,
22 t3ver_id int(11) DEFAULT '0' NOT NULL,
23 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
24 t3ver_label varchar(30) DEFAULT '' NOT NULL,
25 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
26 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
27 t3ver_count int(11) DEFAULT '0' NOT NULL,
28 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
29 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
30 t3_origuid int(11) DEFAULT '0' NOT NULL,
31
32 sys_language_uid int(11) DEFAULT '0' NOT NULL,
33 l18n_parent int(11) DEFAULT '0' NOT NULL,
34 l18n_diffsource mediumblob,
35
36 PRIMARY KEY (uid),
37 KEY parent (pid),
38 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
39 );
40
41 #
42 # Table structure for table 'tx_blogexample_domain_model_post'
43 #
44 CREATE TABLE tx_blogexample_domain_model_post (
45 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
46 pid int(11) DEFAULT '0' NOT NULL,
47
48 blog int(11) DEFAULT '0' NOT NULL,
49
50 title varchar(255) DEFAULT '' NOT NULL,
51 date int(11) DEFAULT '0' NOT NULL,
52 author int(255) DEFAULT '0' NOT NULL,
53 reviewer int(255) DEFAULT '0' NOT NULL,
54 content text NOT NULL,
55 tags int(11) unsigned DEFAULT '0' NOT NULL,
56 comments int(11) unsigned DEFAULT '0' NOT NULL,
57 related_posts int(11) unsigned DEFAULT '0' NOT NULL,
58
59 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
60 crdate int(11) unsigned DEFAULT '0' NOT NULL,
61 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
62 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
63 sorting tinyint(4) unsigned DEFAULT '0' NOT NULL,
64
65 t3ver_oid int(11) DEFAULT '0' NOT NULL,
66 t3ver_id int(11) DEFAULT '0' NOT NULL,
67 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
68 t3ver_label varchar(30) DEFAULT '' NOT NULL,
69 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
70 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
71 t3ver_count int(11) DEFAULT '0' NOT NULL,
72 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
73 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
74 t3_origuid int(11) DEFAULT '0' NOT NULL,
75
76 sys_language_uid int(11) DEFAULT '0' NOT NULL,
77 l18n_parent int(11) DEFAULT '0' NOT NULL,
78 l18n_diffsource mediumblob,
79
80 PRIMARY KEY (uid),
81 KEY parent (pid),
82 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
83 );
84
85 #
86 # Table structure for table 'tx_blogexample_domain_model_comment'
87 #
88 CREATE TABLE tx_blogexample_domain_model_comment (
89 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
90 pid int(11) DEFAULT '0' NOT NULL,
91
92 post int(11) DEFAULT '0' NOT NULL,
93
94 date datetime,
95 author varchar(255) DEFAULT '' NOT NULL,
96 email varchar(255) DEFAULT '' NOT NULL,
97 content text NOT NULL,
98
99 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
100 crdate int(11) unsigned DEFAULT '0' NOT NULL,
101 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
102 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
103
104 PRIMARY KEY (uid),
105 KEY parent (pid)
106 );
107
108 #
109 # Table structure for table 'tx_blogexample_domain_model_person'
110 #
111 CREATE TABLE tx_blogexample_domain_model_person (
112 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
113 pid int(11) DEFAULT '0' NOT NULL,
114
115 firstname varchar(255) DEFAULT '' NOT NULL,
116 lastname varchar(255) DEFAULT '' NOT NULL,
117 email varchar(255) DEFAULT '' NOT NULL,
118 tags int(11) unsigned DEFAULT '0' NOT NULL,
119 tags_special int(11) unsigned DEFAULT '0' NOT NULL,
120
121 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
122 crdate int(11) unsigned DEFAULT '0' NOT NULL,
123 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
124 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
125
126 t3ver_oid int(11) DEFAULT '0' NOT NULL,
127 t3ver_id int(11) DEFAULT '0' NOT NULL,
128 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
129 t3ver_label varchar(30) DEFAULT '' NOT NULL,
130 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
131 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
132 t3ver_count int(11) DEFAULT '0' NOT NULL,
133 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
134 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
135 t3_origuid int(11) DEFAULT '0' NOT NULL,
136
137 PRIMARY KEY (uid),
138 KEY parent (pid),
139 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
140 );
141
142 #
143 # Table structure for table 'tx_blogexample_domain_model_tag'
144 #
145 CREATE TABLE tx_blogexample_domain_model_tag (
146 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
147 pid int(11) DEFAULT '0' NOT NULL,
148
149 name varchar(255) DEFAULT '' NOT NULL,
150 posts int(11) unsigned DEFAULT '0' NOT NULL,
151
152 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
153 crdate int(11) unsigned DEFAULT '0' NOT NULL,
154 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
155 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
156
157 sys_language_uid int(11) DEFAULT '0' NOT NULL,
158
159 PRIMARY KEY (uid),
160 KEY parent (pid)
161 );
162
163 #
164 # Table structure for table 'tx_blogexample_domain_model_tag_mm'
165 #
166 CREATE TABLE tx_blogexample_domain_model_tag_mm (
167 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
168 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
169 tablenames varchar(255) DEFAULT '' NOT NULL,
170 fieldname varchar(255) DEFAULT '' NOT NULL,
171 sorting int(11) unsigned DEFAULT '0' NOT NULL,
172 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
173
174 KEY uid_local (uid_local),
175 KEY uid_foreign (uid_foreign)
176 );
177
178 #
179 # Table structure for table 'tx_blogexample_post_tag_mm'
180 #
181 CREATE TABLE tx_blogexample_post_tag_mm (
182 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
183 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
184 sorting int(11) unsigned DEFAULT '0' NOT NULL,
185 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
186
187 KEY uid_local (uid_local),
188 KEY uid_foreign (uid_foreign)
189 );
190
191 #
192 # Table structure for table 'tx_blogexample_post_post_mm'
193 #
194 CREATE TABLE tx_blogexample_post_post_mm (
195 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
196 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
197 sorting int(11) unsigned DEFAULT '0' NOT NULL,
198 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
199
200 KEY uid_local (uid_local),
201 KEY uid_foreign (uid_foreign)
202 );
203
204 #
205 # Table structure for table 'tx_blogexample_domain_model_dateexample'
206 #
207 CREATE TABLE tx_blogexample_domain_model_dateexample (
208 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
209 pid int(11) DEFAULT '0' NOT NULL,
210
211 datetime_int int(11) DEFAULT '0' NOT NULL,
212 datetime_text varchar(255) DEFAULT '' NOT NULL,
213 datetime_datetime datetime,
214
215 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
216 crdate int(11) unsigned DEFAULT '0' NOT NULL,
217 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
218 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
219 sys_language_uid int(11) DEFAULT '0' NOT NULL,
220
221 PRIMARY KEY (uid),
222 KEY parent (pid)
223 );