Skip to content
Newer
Older
100644 258 lines (219 sloc) 8.34 KB
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
1 #
2 # Table structure for table 'tx_podcast_domain_model_podcast'
3 #
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
4 CREATE TABLE tx_podcast_domain_model_podcast (
5 uid int(11) NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
7
8
9 title varchar(255) DEFAULT '' NOT NULL,
10 subtitle varchar(255) DEFAULT '' NOT NULL,
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
11 description text,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
12 copyright varchar(255) DEFAULT '' NOT NULL,
89a195d Added Category with subcategory
Noël Bossart authored Jan 23, 2012
13 image varchar(255) DEFAULT '' NOT NULL,
4ce15eb Add iTunes Flag, Add MIME Type and duration calclulation
Noël Bossart authored Jan 23, 2012
14 itunes tinyint(1) unsigned DEFAULT '0' NOT NULL,
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
15 itunesblock tinyint(1) unsigned DEFAULT '0' NOT NULL,
16 explicit varchar(16) DEFAULT '' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
17 categories int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
18 episodes int(11) unsigned DEFAULT '0' NOT NULL,
19 author int(11) unsigned DEFAULT '0',
20 technical_contact int(11) unsigned DEFAULT '0',
21 website int(11) unsigned DEFAULT '0',
22
23 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
24 crdate int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
25 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
26 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
27 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
28 starttime int(11) unsigned DEFAULT '0' NOT NULL,
29 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
30
31 t3ver_oid int(11) DEFAULT '0' NOT NULL,
32 t3ver_id int(11) DEFAULT '0' NOT NULL,
33 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
34 t3ver_label varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
35 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
36 t3ver_stage int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
37 t3ver_count int(11) DEFAULT '0' NOT NULL,
38 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
39 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
40 t3_origuid int(11) DEFAULT '0' NOT NULL,
41
42 sys_language_uid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
43 l10n_parent int(11) DEFAULT '0' NOT NULL,
44 l10n_diffsource mediumblob,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
45
46 PRIMARY KEY (uid),
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
47 KEY parent (pid),
48 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
49 KEY language (l10n_parent,sys_language_uid)
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
50 );
51
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
52 #
53 # Table structure for table 'tx_podcast_domain_model_episode'
54 #
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
55 CREATE TABLE tx_podcast_domain_model_episode (
56 uid int(11) NOT NULL auto_increment,
57 pid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
58
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
59 podcast int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
60
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
61 title varchar(255) DEFAULT '' NOT NULL,
62 itunesblock tinyint(1) unsigned DEFAULT '0' NOT NULL,
87cb9d6 Added Subtitle for Episodes
Noël Bossart authored Jan 24, 2012
63 subtitle varchar(255) DEFAULT '' NOT NULL,
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
64 description text,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
65 file varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
66 publication_date int(11) DEFAULT '0' NOT NULL,
67 duration int(11) DEFAULT '0' NOT NULL,
4ce15eb Add iTunes Flag, Add MIME Type and duration calclulation
Noël Bossart authored Jan 23, 2012
68 mime varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
69 website int(11) unsigned DEFAULT '0',
70 author int(11) unsigned DEFAULT '0',
71
72 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
73 crdate int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
74 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
75 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
76 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
77 starttime int(11) unsigned DEFAULT '0' NOT NULL,
78 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
79
80 t3ver_oid int(11) DEFAULT '0' NOT NULL,
81 t3ver_id int(11) DEFAULT '0' NOT NULL,
82 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
83 t3ver_label varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
84 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
85 t3ver_stage int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
86 t3ver_count int(11) DEFAULT '0' NOT NULL,
87 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
88 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
89 t3_origuid int(11) DEFAULT '0' NOT NULL,
90
91 sys_language_uid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
92 l10n_parent int(11) DEFAULT '0' NOT NULL,
93 l10n_diffsource mediumblob,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
94
95 PRIMARY KEY (uid),
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
96 KEY parent (pid),
97 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
98 KEY language (l10n_parent,sys_language_uid)
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
99 );
100
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
101 #
102 # Table structure for table 'tx_podcast_domain_model_category'
103 #
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
104 CREATE TABLE tx_podcast_domain_model_category (
105 uid int(11) NOT NULL auto_increment,
106 pid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
107
108 title varchar(255) DEFAULT '' NOT NULL,
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
109 subcategory int(11) unsigned DEFAULT '0' NOT NULL,
110 parentcategory int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
111
112 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
113 crdate int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
114 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
115 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
116 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
117 starttime int(11) unsigned DEFAULT '0' NOT NULL,
118 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
119
120 t3ver_oid int(11) DEFAULT '0' NOT NULL,
121 t3ver_id int(11) DEFAULT '0' NOT NULL,
122 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
123 t3ver_label varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
124 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
125 t3ver_stage int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
126 t3ver_count int(11) DEFAULT '0' NOT NULL,
127 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
128 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
129 t3_origuid int(11) DEFAULT '0' NOT NULL,
130
131 sys_language_uid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
132 l10n_parent int(11) DEFAULT '0' NOT NULL,
133 l10n_diffsource mediumblob,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
134
135 PRIMARY KEY (uid),
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
136 KEY parent (pid),
137 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
138 KEY language (l10n_parent,sys_language_uid)
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
139 );
140
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
141 #
142 # Table structure for table 'tx_podcast_domain_model_person'
143 #
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
144 CREATE TABLE tx_podcast_domain_model_person (
145 uid int(11) NOT NULL auto_increment,
146 pid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
147
148
149 name varchar(255) DEFAULT '' NOT NULL,
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
150 email varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
151
152 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
153 crdate int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
154 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
155 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
156 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
157 starttime int(11) unsigned DEFAULT '0' NOT NULL,
158 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
159
160 t3ver_oid int(11) DEFAULT '0' NOT NULL,
161 t3ver_id int(11) DEFAULT '0' NOT NULL,
162 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
163 t3ver_label varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
164 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
165 t3ver_stage int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
166 t3ver_count int(11) DEFAULT '0' NOT NULL,
167 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
168 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
169 t3_origuid int(11) DEFAULT '0' NOT NULL,
170
171 sys_language_uid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
172 l10n_parent int(11) DEFAULT '0' NOT NULL,
173 l10n_diffsource mediumblob,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
174
175 PRIMARY KEY (uid),
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
176 KEY parent (pid),
177 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
178 KEY language (l10n_parent,sys_language_uid)
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
179 );
180
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
181 #
182 # Table structure for table 'tx_podcast_domain_model_website'
183 #
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
184 CREATE TABLE tx_podcast_domain_model_website (
185 uid int(11) NOT NULL auto_increment,
186 pid int(11) DEFAULT '0' NOT NULL,
187
188
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
189 title varchar(255) DEFAULT '' NOT NULL,
80a66c2 Added Website Link
Noël Bossart authored Jan 24, 2012
190 link varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
191
192 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
193 crdate int(11) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
194 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
195 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
196 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
197 starttime int(11) unsigned DEFAULT '0' NOT NULL,
198 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
199
200 t3ver_oid int(11) DEFAULT '0' NOT NULL,
201 t3ver_id int(11) DEFAULT '0' NOT NULL,
202 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
203 t3ver_label varchar(255) DEFAULT '' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
204 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
205 t3ver_stage int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
206 t3ver_count int(11) DEFAULT '0' NOT NULL,
207 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
208 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
209 t3_origuid int(11) DEFAULT '0' NOT NULL,
210
211 sys_language_uid int(11) DEFAULT '0' NOT NULL,
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
212 l10n_parent int(11) DEFAULT '0' NOT NULL,
213 l10n_diffsource mediumblob,
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
214
215 PRIMARY KEY (uid),
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
216 KEY parent (pid),
217 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
218 KEY language (l10n_parent,sys_language_uid)
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
219 );
220
221 #
222 # Table structure for table 'tx_podcast_podcast_category_mm'
223 #
224 CREATE TABLE tx_podcast_podcast_episode_mm (
225 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
226 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
227 sorting int(11) unsigned DEFAULT '0' NOT NULL,
228 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
229
230 KEY uid_local (uid_local),
231 KEY uid_foreign (uid_foreign)
39c6ac1 Updated to new Version of Typo3 and ext base
Noël Bossart authored Jan 23, 2012
232 );
233
234 #
235 # Table structure for table 'tx_podcast_podcast_category_mm'
236 #
237 CREATE TABLE tx_podcast_podcast_category_mm (
238 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
239 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
240 sorting int(11) unsigned DEFAULT '0' NOT NULL,
241 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
242
243 KEY uid_local (uid_local),
244 KEY uid_foreign (uid_foreign)
c91c76e Release 0.3.3
Noël Bossart authored Jan 27, 2012
245 );
246
247 #
248 # Table structure for table 'tx_podcast_podcast_category_mm'
249 #
250 CREATE TABLE tx_podcast_category_category_mm (
251 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
252 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
253 sorting int(11) unsigned DEFAULT '0' NOT NULL,
254 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
255
256 KEY uid_local (uid_local),
257 KEY uid_foreign (uid_foreign)
65f4158 @noelboss Initial Upload
authored Jul 21, 2011
258 );
Something went wrong with that request. Please try again.