[BUGFIX] fix missing l18n fields in blog tag table
[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 l18n_parent int(11) DEFAULT '0' NOT NULL,
159 l18n_diffsource mediumblob,
160
161 PRIMARY KEY (uid),
162 KEY parent (pid)
163 );
164
165 #
166 # Table structure for table 'tx_blogexample_domain_model_tag_mm'
167 #
168 CREATE TABLE tx_blogexample_domain_model_tag_mm (
169 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
170 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
171 tablenames varchar(255) DEFAULT '' NOT NULL,
172 fieldname varchar(255) DEFAULT '' NOT NULL,
173 sorting int(11) unsigned DEFAULT '0' NOT NULL,
174 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
175
176 KEY uid_local (uid_local),
177 KEY uid_foreign (uid_foreign)
178 );
179
180 #
181 # Table structure for table 'tx_blogexample_post_tag_mm'
182 #
183 CREATE TABLE tx_blogexample_post_tag_mm (
184 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
185 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
186 sorting int(11) unsigned DEFAULT '0' NOT NULL,
187 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
188
189 KEY uid_local (uid_local),
190 KEY uid_foreign (uid_foreign)
191 );
192
193 #
194 # Table structure for table 'tx_blogexample_post_post_mm'
195 #
196 CREATE TABLE tx_blogexample_post_post_mm (
197 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
198 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
199 sorting int(11) unsigned DEFAULT '0' NOT NULL,
200 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
201
202 KEY uid_local (uid_local),
203 KEY uid_foreign (uid_foreign)
204 );
205
206 #
207 # Table structure for table 'tx_blogexample_domain_model_dateexample'
208 #
209 CREATE TABLE tx_blogexample_domain_model_dateexample (
210 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
211 pid int(11) DEFAULT '0' NOT NULL,
212
213 datetime_int int(11) DEFAULT '0' NOT NULL,
214 datetime_text varchar(255) DEFAULT '' NOT NULL,
215 datetime_datetime datetime,
216
217 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
218 crdate int(11) unsigned DEFAULT '0' NOT NULL,
219 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
220 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
221 sys_language_uid int(11) DEFAULT '0' NOT NULL,
222
223 PRIMARY KEY (uid),
224 KEY parent (pid)
225 );