· 8 years ago · Mar 31, 2018, 12:51 PM
1CREATE TABLE IF NOT EXISTS `episodes_series` (
2 `id` int(6) NOT NULL AUTO_INCREMENT,
3 `category` enum('streaming','telechargement') NOT NULL,
4 `section` enum('serie','manga','documentaire') NOT NULL,
5 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
6 `post_date_gmt2` datetime NOT NULL DEFAULT '2015-01-21 16:57:00',
7 `titre_serie` varchar(255) NOT NULL,
8 `description` longtext NOT NULL,
9 `titre` varchar(100) NOT NULL,
10 `Langue` varchar(255) NOT NULL,
11 `trad` int(1) NOT NULL DEFAULT '0',
12 `hebergeur` int(6) NOT NULL,
13 `saisons` int(6) NOT NULL,
14 `lien` longtext NOT NULL,
15 `protectiframe` longtext NOT NULL,
16 `liendl` varchar(800) NOT NULL,
17 `liendlprotect` varchar(800) NOT NULL,
18 `mdp` varchar(400) NOT NULL,
19 `image` varchar(300) NOT NULL,
20 `pseudo_du_membre` varchar(255) NOT NULL,
21 `pseudo_modif` varchar(255) NOT NULL,
22 `id_du_membre` int(11) NOT NULL,
23 `correspondance_series` int(6) NOT NULL,
24 `categorie` varchar(255) NOT NULL DEFAULT 'streaming',
25 `vue` int(11) NOT NULL,
26 `tag` varchar(255) NOT NULL,
27 `type` varchar(100) NOT NULL,
28 `mort` varchar(255) NOT NULL,
29 `raison_mort` varchar(255) NOT NULL,
30 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
31 `pseudo_mort` varchar(255) NOT NULL,
32 `id_m_mort` int(11) NOT NULL,
33 `vue2` int(11) NOT NULL,
34 `vue3` int(20) NOT NULL,
35 `vue4` int(10) NOT NULL,
36 `valide` int(2) NOT NULL DEFAULT '0',
37 `pseudo_verif` varchar(255) NOT NULL,
38 `majql` int(1) NOT NULL DEFAULT '0',
39 `controlmort` int(1) NOT NULL DEFAULT '0',
40 `share` int(11) NOT NULL,
41 `controlepi` int(1) NOT NULL DEFAULT '0',
42 `majdl` int(1) NOT NULL DEFAULT '0',
43 `faitlink` int(1) NOT NULL DEFAULT '0',
44 PRIMARY KEY (`id`)
45) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=296952 ;
46
47CREATE TABLE IF NOT EXISTS `episodes_telechargement` (
48 `id` int(6) NOT NULL AUTO_INCREMENT,
49 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
50 `titre_serie` varchar(100) NOT NULL,
51 `description` longtext NOT NULL,
52 `titre` varchar(30) NOT NULL,
53 `langue` varchar(255) NOT NULL,
54 `trad` int(1) NOT NULL DEFAULT '0',
55 `hebergeur` int(6) NOT NULL,
56 `saisons` int(6) NOT NULL,
57 `lien` longtext NOT NULL,
58 `lien_origine` varchar(500) NOT NULL,
59 `mdp` varchar(255) NOT NULL,
60 `type` varchar(100) NOT NULL,
61 `pseudo_du_membre` varchar(255) NOT NULL,
62 `pseudo_modif` varchar(255) NOT NULL,
63 `id_du_membre` int(11) NOT NULL,
64 `correspondance_series` int(6) NOT NULL,
65 `categorie` varchar(255) NOT NULL DEFAULT 'telechargement',
66 `vue` int(11) NOT NULL,
67 `vue2` int(20) NOT NULL,
68 `vue3` int(20) NOT NULL,
69 `vue4` int(10) NOT NULL,
70 `mort` varchar(255) NOT NULL,
71 `valide` int(2) NOT NULL DEFAULT '0',
72 `pseudo_verif` varchar(255) NOT NULL,
73 `raison_mort` varchar(255) NOT NULL,
74 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
75 `pseudo_mort` varchar(255) NOT NULL,
76 `id_m_mort` int(11) NOT NULL,
77 `tag` varchar(300) NOT NULL,
78 `underground` int(1) NOT NULL DEFAULT '0',
79 `faitlink` int(1) NOT NULL DEFAULT '0',
80 `share` int(11) NOT NULL,
81 `majdl` int(1) NOT NULL DEFAULT '0',
82 PRIMARY KEY (`id`)
83) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58978 ;
84
85
86CREATE TABLE IF NOT EXISTS `episodes_mangas` (
87 `id` int(6) NOT NULL AUTO_INCREMENT,
88 `category` enum('streaming','telechargement') NOT NULL,
89 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
90 `post_date_gmt2` datetime NOT NULL DEFAULT '2016-02-21 16:57:00',
91 `titre_mangas` varchar(300) NOT NULL,
92 `description` longtext NOT NULL,
93 `titre` varchar(30) NOT NULL,
94 `Langue` varchar(100) NOT NULL,
95 `trad` int(1) NOT NULL DEFAULT '0',
96 `hebergeur` int(6) NOT NULL,
97 `saisons` int(6) NOT NULL,
98 `lien` longtext NOT NULL,
99 `protectiframe` longtext NOT NULL,
100 `liendl` varchar(800) NOT NULL,
101 `liendlprotect` varchar(800) NOT NULL,
102 `mdp` varchar(400) NOT NULL,
103 `qualite` varchar(100) NOT NULL,
104 `pseudo_du_membre` varchar(255) NOT NULL,
105 `pseudo_modif` varchar(255) NOT NULL,
106 `id_du_membre` int(11) NOT NULL,
107 `correspondance_mangas` int(6) NOT NULL,
108 `tag` varchar(400) NOT NULL,
109 `vue` int(11) NOT NULL,
110 `vue3` int(20) NOT NULL,
111 `vue4` int(10) NOT NULL,
112 `mort` varchar(255) NOT NULL,
113 `raison_mort` varchar(255) NOT NULL,
114 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
115 `pseudo_mort` varchar(255) NOT NULL,
116 `id_m_mort` int(11) NOT NULL,
117 `vue2` int(11) NOT NULL,
118 `valide` int(2) NOT NULL DEFAULT '0',
119 `pseudo_verif` varchar(255) NOT NULL,
120 `underground` int(1) NOT NULL DEFAULT '0',
121 `news` int(1) NOT NULL DEFAULT '0',
122 `controlmort` int(1) NOT NULL DEFAULT '0',
123 `controlepi` int(1) NOT NULL DEFAULT '0',
124 `majdl` int(1) NOT NULL DEFAULT '0',
125 `faitlink` int(1) NOT NULL DEFAULT '0',
126 PRIMARY KEY (`id`)
127) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=111985 ;
128
129
130CREATE TABLE IF NOT EXISTS `episodes_mangas_ddl` (
131 `id` int(6) NOT NULL AUTO_INCREMENT,
132 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
133 `mdp` varchar(255) NOT NULL,
134 `titre_mangas` varchar(300) NOT NULL,
135 `description` longtext NOT NULL,
136 `titre` varchar(30) NOT NULL,
137 `langue` varchar(255) NOT NULL,
138 `trad` int(1) NOT NULL DEFAULT '0',
139 `hebergeur` int(6) NOT NULL,
140 `saison` int(6) NOT NULL,
141 `lien` longtext NOT NULL,
142 `lien_origine` varchar(500) NOT NULL,
143 `qualite` varchar(100) NOT NULL,
144 `pseudo_du_membre` varchar(255) NOT NULL,
145 `pseudo_modif` varchar(255) NOT NULL,
146 `id_du_membre` int(11) NOT NULL,
147 `correspondance_mangas` int(6) NOT NULL,
148 `vue` int(11) NOT NULL,
149 `vue2` int(20) NOT NULL,
150 `vue3` int(20) NOT NULL,
151 `vue4` int(20) NOT NULL,
152 `mort` varchar(255) NOT NULL,
153 `raison_mort` varchar(255) NOT NULL,
154 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
155 `pseudo_mort` varchar(255) NOT NULL,
156 `id_m_mort` int(11) NOT NULL,
157 `valide` int(2) NOT NULL DEFAULT '0',
158 `pseudo_verif` varchar(255) NOT NULL,
159 `underground` int(1) NOT NULL DEFAULT '0',
160 `faitlink` int(1) NOT NULL DEFAULT '0',
161 `majdl` int(1) NOT NULL DEFAULT '0',
162 PRIMARY KEY (`id`)
163) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=46862 ;
164
165CREATE TABLE IF NOT EXISTS `episodes_documentaire` (
166 `id` int(6) NOT NULL AUTO_INCREMENT,
167 `category` enum('streaming','telechargement') NOT NULL,
168 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
169 `titre_serie` varchar(255) NOT NULL,
170 `description` longtext NOT NULL,
171 `titre` varchar(100) NOT NULL,
172 `Langue` varchar(255) NOT NULL,
173 `hebergeur` int(6) NOT NULL,
174 `saisons` int(6) NOT NULL,
175 `lien` longtext NOT NULL,
176 `protectiframe` longtext NOT NULL,
177 `liendl` varchar(800) NOT NULL,
178 `liendlprotect` varchar(800) NOT NULL,
179 `mdp` varchar(400) NOT NULL,
180 `type` varchar(100) NOT NULL DEFAULT 'WEBRIP',
181 `trad` int(1) NOT NULL,
182 `pseudo_du_membre` varchar(255) NOT NULL,
183 `pseudo_modif` varchar(255) NOT NULL,
184 `id_du_membre` int(11) NOT NULL,
185 `correspondance_series` int(6) NOT NULL,
186 `vue` int(11) NOT NULL,
187 `raison_mort` varchar(255) NOT NULL,
188 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
189 `mort` varchar(255) NOT NULL,
190 `pseudo_mort` varchar(255) NOT NULL,
191 `id_m_mort` int(11) NOT NULL,
192 `vue2` int(11) NOT NULL,
193 `vue3` int(20) NOT NULL,
194 `vue4` int(6) NOT NULL,
195 `valide` int(2) NOT NULL DEFAULT '0',
196 `pseudo_verif` varchar(255) NOT NULL,
197 `controlepi` int(1) NOT NULL DEFAULT '0',
198 `majdl` int(1) NOT NULL DEFAULT '0',
199 PRIMARY KEY (`id`)
200) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8665 ;
201
202
203
204CREATE TABLE IF NOT EXISTS `episodes_documentaire_ddl` (
205 `id` int(6) NOT NULL AUTO_INCREMENT,
206 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
207 `titre_serie` varchar(255) NOT NULL,
208 `description` longtext NOT NULL,
209 `titre` varchar(100) NOT NULL,
210 `Langue` varchar(255) NOT NULL,
211 `hebergeur` int(6) NOT NULL,
212 `saisons` int(6) NOT NULL,
213 `mdp` varchar(200) NOT NULL,
214 `lien` longtext NOT NULL,
215 `lien_origine` varchar(500) NOT NULL,
216 `type` varchar(10) NOT NULL DEFAULT 'WEBRIP',
217 `trad` int(1) NOT NULL,
218 `pseudo_du_membre` varchar(255) NOT NULL,
219 `pseudo_modif` varchar(255) NOT NULL,
220 `id_du_membre` int(11) NOT NULL,
221 `correspondance_series` int(6) NOT NULL,
222 `vue` int(11) NOT NULL,
223 `vue2` int(20) NOT NULL,
224 `vue3` int(20) NOT NULL,
225 `vue4` int(10) NOT NULL,
226 `mort` varchar(255) NOT NULL,
227 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
228 `raison_mort` varchar(255) NOT NULL,
229 `pseudo_mort` varchar(255) NOT NULL,
230 `id_m_mort` int(11) NOT NULL,
231 `pseudo_verif` varchar(255) NOT NULL,
232 `valide` int(2) NOT NULL DEFAULT '0',
233 `faitlink` int(1) NOT NULL DEFAULT '0',
234 `majdl` int(1) NOT NULL DEFAULT '0',
235 PRIMARY KEY (`id`)
236) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5345 ;
237
238
239
240-- table ou je veux tout transférer
241
242CREATE TABLE IF NOT EXISTS `episodes` (
243 `id` int(6) NOT NULL AUTO_INCREMENT,
244 `category` enum('streaming','telechargement') NOT NULL,
245 `section` enum('serie','manga','documentaire') NOT NULL,
246 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
247 `post_date_gmt2` datetime NOT NULL DEFAULT '2015-01-21 16:57:00',
248 `titre_fiche` varchar(255) NOT NULL,
249 `description` longtext NOT NULL,
250 `titre` varchar(100) NOT NULL,
251 `Langue` varchar(255) NOT NULL,
252 `trad` int(1) NOT NULL DEFAULT '0',
253 `hebergeur` int(6) NOT NULL,
254 `saisons` int(6) NOT NULL,
255 `lien` longtext NOT NULL,
256 `protectiframe` longtext NOT NULL,
257 `liendl` varchar(800) NOT NULL,
258 `liendlprotect` varchar(800) NOT NULL,
259 `mdp` varchar(400) NOT NULL,
260 `image` varchar(300) NOT NULL,
261 `pseudo_du_membre` varchar(255) NOT NULL,
262 `pseudo_modif` varchar(255) NOT NULL,
263 `id_du_membre` int(11) NOT NULL,
264 `correspondance` int(6) NOT NULL,
265 `vue` int(11) NOT NULL,
266 `tag` varchar(255) NOT NULL,
267 `type` varchar(100) NOT NULL,
268 `mort` varchar(255) NOT NULL,
269 `raison_mort` varchar(255) NOT NULL,
270 `verif_mort` date NOT NULL DEFAULT '0000-00-00',
271 `pseudo_mort` varchar(255) NOT NULL,
272 `id_m_mort` int(11) NOT NULL,
273 `vue2` int(11) NOT NULL,
274 `vue3` int(20) NOT NULL,
275 `vue4` int(10) NOT NULL,
276 `valide` int(2) NOT NULL DEFAULT '0',
277 `pseudo_verif` varchar(255) NOT NULL,
278 `majql` int(1) NOT NULL DEFAULT '0',
279 `controlmort` int(1) NOT NULL DEFAULT '0',
280 `share` int(11) NOT NULL,
281 `controlepi` int(1) NOT NULL DEFAULT '0',
282 `majdl` int(1) NOT NULL DEFAULT '0',
283 `faitlink` int(1) NOT NULL DEFAULT '0',
284 `underground` int(1) NOT NULL DEFAULT '0',
285 `news` int(1) NOT NULL DEFAULT '0',
286 PRIMARY KEY (`id`)
287) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=121597 ;