54c183e414af21c9a0e044558c3626010144c70c
[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 varchar(255) DEFAULT '',
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
20 t3ver_oid int(11) DEFAULT '0' NOT NULL,
21 t3ver_id int(11) DEFAULT '0' NOT NULL,
22 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
23 t3ver_label varchar(30) DEFAULT '' NOT NULL,
24 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
25 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
26 t3ver_count int(11) DEFAULT '0' NOT NULL,
27 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
28 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
29 t3_origuid int(11) DEFAULT '0' NOT NULL,
30
31 sys_language_uid int(11) DEFAULT '0' NOT NULL,
32 l18n_parent int(11) DEFAULT '0' NOT NULL,
33 l18n_diffsource mediumblob NOT NULL,
34
35 PRIMARY KEY (uid),
36 KEY parent (pid),
37 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
38 );
39
40 #
41 # Table structure for table 'tx_blogexample_domain_model_post'
42 #
43 CREATE TABLE tx_blogexample_domain_model_post (
44 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
45 pid int(11) DEFAULT '0' NOT NULL,
46
47 blog int(11) DEFAULT '0' NOT NULL,
48
49 title varchar(255) DEFAULT '' NOT NULL,
50 date int(11) DEFAULT '0' NOT NULL,
51 author int(255) DEFAULT '0' NOT NULL,
52 content text NOT NULL,
53 tags int(11) unsigned DEFAULT '0' NOT NULL,
54 comments int(11) unsigned DEFAULT '0' NOT NULL,
55 related_posts int(11) unsigned DEFAULT '0' NOT NULL,
56
57 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
58 crdate int(11) unsigned DEFAULT '0' NOT NULL,
59 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
60 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
61 sorting tinyint(4) unsigned DEFAULT '0' NOT NULL,
62
63 t3ver_oid int(11) DEFAULT '0' NOT NULL,
64 t3ver_id int(11) DEFAULT '0' NOT NULL,
65 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
66 t3ver_label varchar(30) DEFAULT '' NOT NULL,
67 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
68 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
69 t3ver_count int(11) DEFAULT '0' NOT NULL,
70 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
71 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
72 t3_origuid int(11) DEFAULT '0' NOT NULL,
73
74 sys_language_uid int(11) DEFAULT '0' NOT NULL,
75 l18n_parent int(11) DEFAULT '0' NOT NULL,
76 l18n_diffsource mediumblob NOT NULL,
77
78 PRIMARY KEY (uid),
79 KEY parent (pid),
80 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
81 );
82
83 #
84 # Table structure for table 'tx_blogexample_domain_model_comment'
85 #
86 CREATE TABLE tx_blogexample_domain_model_comment (
87 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
88 pid int(11) DEFAULT '0' NOT NULL,
89
90 post int(11) DEFAULT '0' NOT NULL,
91
92 date int(11) DEFAULT '0' NOT NULL,
93 author varchar(255) DEFAULT '' NOT NULL,
94 email varchar(255) DEFAULT '' NOT NULL,
95 content text NOT NULL,
96
97 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
98 crdate int(11) unsigned DEFAULT '0' NOT NULL,
99 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
100 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
101
102 PRIMARY KEY (uid),
103 KEY parent (pid),
104 );
105
106 #
107 # Table structure for table 'tx_blogexample_domain_model_person'
108 #
109 CREATE TABLE tx_blogexample_domain_model_person (
110 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
111 pid int(11) DEFAULT '0' NOT NULL,
112
113 firstname varchar(255) DEFAULT '' NOT NULL,
114 lastname varchar(255) DEFAULT '' NOT NULL,
115 email varchar(255) DEFAULT '' NOT NULL,
116
117 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
118 crdate int(11) unsigned DEFAULT '0' NOT NULL,
119 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
120 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
121
122 t3ver_oid int(11) DEFAULT '0' NOT NULL,
123 t3ver_id int(11) DEFAULT '0' NOT NULL,
124 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
125 t3ver_label varchar(30) DEFAULT '' NOT NULL,
126 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
127 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
128 t3ver_count int(11) DEFAULT '0' NOT NULL,
129 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
130 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
131 t3_origuid int(11) DEFAULT '0' NOT NULL,
132
133 PRIMARY KEY (uid),
134 KEY parent (pid),
135 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
136 );
137
138 #
139 # Table structure for table 'tx_blogexample_domain_model_tag'
140 #
141 CREATE TABLE tx_blogexample_domain_model_tag (
142 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
143 pid int(11) DEFAULT '0' NOT NULL,
144
145 name varchar(255) DEFAULT '' NOT NULL,
146 posts int(11) unsigned DEFAULT '0' NOT NULL,
147
148 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
149 crdate int(11) unsigned DEFAULT '0' NOT NULL,
150 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
151 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
152
153 sys_language_uid int(11) DEFAULT '0' NOT NULL,
154 l18n_parent int(11) DEFAULT '0' NOT NULL,
155 l18n_diffsource mediumblob NOT NULL,
156
157 PRIMARY KEY (uid),
158 KEY parent (pid),
159 );
160
161 #
162 # Table structure for table 'tx_blogexample_post_tag_mm'
163 #
164 CREATE TABLE tx_blogexample_post_tag_mm (
165 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
166 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
167 sorting int(11) unsigned DEFAULT '0' NOT NULL,
168 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
169
170 KEY uid_local (uid_local),
171 KEY uid_foreign (uid_foreign)
172 );
173
174 #
175 # Table structure for table 'tx_blogexample_post_post_mm'
176 #
177 CREATE TABLE tx_blogexample_post_post_mm (
178 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
179 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
180 sorting int(11) unsigned DEFAULT '0' NOT NULL,
181 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
182
183 KEY uid_local (uid_local),
184 KEY uid_foreign (uid_foreign)
185 );