1 CREATE TABLE /*_*/site_identifiers (
4 si_site INTEGER NOT NULL,
5 PRIMARY KEY(si_type, si_key)
7 CREATE INDEX si_site ON /*_*/site_identifiers (si_site);
8 CREATE INDEX si_key ON /*_*/site_identifiers (si_key);
10 CREATE TABLE /*_*/updatelog (
12 ul_value BLOB DEFAULT NULL,
16 CREATE TABLE /*_*/actor (
17 actor_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
18 actor_user INTEGER DEFAULT NULL,
19 actor_name BLOB NOT NULL
21 CREATE UNIQUE INDEX actor_user ON /*_*/actor (actor_user);
22 CREATE UNIQUE INDEX actor_name ON /*_*/actor (actor_name);
24 CREATE TABLE /*_*/user_former_groups (
25 ufg_user INTEGER DEFAULT 0 NOT NULL,
26 ufg_group BLOB DEFAULT '' NOT NULL,
27 PRIMARY KEY(ufg_user, ufg_group)
30 CREATE TABLE /*_*/bot_passwords (
31 bp_user INTEGER NOT NULL,
32 bp_app_id BLOB NOT NULL,
33 bp_password BLOB NOT NULL,
34 bp_token BLOB DEFAULT '' NOT NULL,
35 bp_restrictions BLOB NOT NULL,
36 bp_grants BLOB NOT NULL,
37 PRIMARY KEY(bp_user, bp_app_id)
40 CREATE TABLE /*_*/comment (
41 comment_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
42 comment_hash INTEGER NOT NULL, comment_text BLOB NOT NULL,
43 comment_data BLOB DEFAULT NULL
45 CREATE INDEX comment_hash ON /*_*/comment (comment_hash);
47 CREATE TABLE /*_*/slots (
48 slot_revision_id INTEGER NOT NULL,
49 slot_role_id INTEGER NOT NULL,
50 slot_content_id INTEGER NOT NULL,
51 slot_origin INTEGER NOT NULL,
52 PRIMARY KEY(slot_revision_id, slot_role_id)
54 CREATE INDEX slot_revision_origin_role ON /*_*/slots (
55 slot_revision_id, slot_origin, slot_role_id
58 CREATE TABLE /*_*/site_stats (
59 ss_row_id INTEGER UNSIGNED NOT NULL,
60 ss_total_edits INTEGER DEFAULT NULL,
61 ss_good_articles INTEGER DEFAULT NULL,
62 ss_total_pages INTEGER DEFAULT NULL,
63 ss_users INTEGER DEFAULT NULL,
64 ss_active_users INTEGER DEFAULT NULL,
65 ss_images INTEGER DEFAULT NULL,
66 PRIMARY KEY(ss_row_id)
69 CREATE TABLE /*_*/user_properties (
70 up_user INTEGER NOT NULL,
71 up_property BLOB NOT NULL,
72 up_value BLOB DEFAULT NULL,
73 PRIMARY KEY(up_user, up_property)
75 CREATE INDEX up_property ON /*_*/user_properties (up_property);
77 CREATE TABLE /*_*/log_search (
78 ls_field BLOB NOT NULL,
79 ls_value TEXT NOT NULL,
80 ls_log_id INTEGER DEFAULT 0 NOT NULL,
81 PRIMARY KEY(ls_field, ls_value, ls_log_id)
83 CREATE INDEX ls_log_id ON /*_*/log_search (ls_log_id);
85 CREATE TABLE /*_*/change_tag (
86 ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
87 ct_rc_id INTEGER DEFAULT NULL,
88 ct_log_id INTEGER DEFAULT NULL,
89 ct_rev_id INTEGER DEFAULT NULL,
90 ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER NOT NULL
92 CREATE UNIQUE INDEX change_tag_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id);
93 CREATE UNIQUE INDEX change_tag_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id);
94 CREATE UNIQUE INDEX change_tag_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id);
95 CREATE INDEX change_tag_tag_id_id ON /*_*/change_tag (
96 ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id
99 CREATE TABLE /*_*/content (
100 content_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
101 content_size INTEGER NOT NULL,
102 content_sha1 BLOB NOT NULL, content_model INTEGER NOT NULL,
103 content_address BLOB NOT NULL
106 CREATE TABLE /*_*/l10n_cache (
107 lc_lang BLOB NOT NULL,
108 lc_key TEXT NOT NULL,
109 lc_value BLOB NOT NULL,
110 PRIMARY KEY(lc_lang, lc_key)
113 CREATE TABLE /*_*/module_deps (
114 md_module BLOB NOT NULL,
115 md_skin BLOB NOT NULL,
116 md_deps BLOB NOT NULL,
117 PRIMARY KEY(md_module, md_skin)
120 CREATE TABLE /*_*/redirect (
121 rd_from INTEGER DEFAULT 0 NOT NULL,
122 rd_namespace INTEGER DEFAULT 0 NOT NULL,
123 rd_title BLOB DEFAULT '' NOT NULL,
124 rd_interwiki TEXT DEFAULT NULL,
125 rd_fragment BLOB DEFAULT NULL,
128 CREATE INDEX rd_ns_title ON /*_*/redirect (rd_namespace, rd_title, rd_from);
130 CREATE TABLE /*_*/pagelinks (
131 pl_from INTEGER DEFAULT 0 NOT NULL,
132 pl_namespace INTEGER DEFAULT 0 NOT NULL,
133 pl_title BLOB DEFAULT '' NOT NULL,
134 pl_from_namespace INTEGER DEFAULT 0 NOT NULL,
135 PRIMARY KEY(pl_from, pl_namespace, pl_title)
137 CREATE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
138 CREATE INDEX pl_backlinks_namespace ON /*_*/pagelinks (
139 pl_from_namespace, pl_namespace,
143 CREATE TABLE /*_*/templatelinks (
144 tl_from INTEGER DEFAULT 0 NOT NULL,
145 tl_namespace INTEGER DEFAULT 0 NOT NULL,
146 tl_title BLOB DEFAULT '' NOT NULL,
147 tl_from_namespace INTEGER DEFAULT 0 NOT NULL,
148 PRIMARY KEY(tl_from, tl_namespace, tl_title)
150 CREATE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from);
151 CREATE INDEX tl_backlinks_namespace ON /*_*/templatelinks (
152 tl_from_namespace, tl_namespace,
156 CREATE TABLE /*_*/imagelinks (
157 il_from INTEGER DEFAULT 0 NOT NULL,
158 il_to BLOB DEFAULT '' NOT NULL,
159 il_from_namespace INTEGER DEFAULT 0 NOT NULL,
160 PRIMARY KEY(il_from, il_to)
162 CREATE INDEX il_to ON /*_*/imagelinks (il_to, il_from);
163 CREATE INDEX il_backlinks_namespace ON /*_*/imagelinks (
164 il_from_namespace, il_to, il_from
167 CREATE TABLE /*_*/langlinks (
168 ll_from INTEGER DEFAULT 0 NOT NULL,
169 ll_lang BLOB DEFAULT '' NOT NULL,
170 ll_title BLOB DEFAULT '' NOT NULL,
171 PRIMARY KEY(ll_from, ll_lang)
173 CREATE INDEX ll_lang ON /*_*/langlinks (ll_lang, ll_title);
175 CREATE TABLE /*_*/iwlinks (
176 iwl_from INTEGER DEFAULT 0 NOT NULL,
177 iwl_prefix BLOB DEFAULT '' NOT NULL,
178 iwl_title BLOB DEFAULT '' NOT NULL,
179 PRIMARY KEY(iwl_from, iwl_prefix, iwl_title)
181 CREATE INDEX iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from);
182 CREATE INDEX iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);
184 CREATE TABLE /*_*/category (
185 cat_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
186 cat_title BLOB NOT NULL, cat_pages INTEGER DEFAULT 0 NOT NULL,
187 cat_subcats INTEGER DEFAULT 0 NOT NULL,
188 cat_files INTEGER DEFAULT 0 NOT NULL
190 CREATE UNIQUE INDEX cat_title ON /*_*/category (cat_title);
191 CREATE INDEX cat_pages ON /*_*/category (cat_pages);
193 CREATE TABLE /*_*/watchlist_expiry (
194 we_item INTEGER UNSIGNED NOT NULL,
195 we_expiry BLOB NOT NULL,
198 CREATE INDEX we_expiry ON /*_*/watchlist_expiry (we_expiry);
200 CREATE TABLE /*_*/change_tag_def (
201 ctd_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
202 ctd_name BLOB NOT NULL, ctd_user_defined INTEGER NOT NULL,
203 ctd_count INTEGER DEFAULT 0 NOT NULL
205 CREATE UNIQUE INDEX ctd_name ON /*_*/change_tag_def (ctd_name);
206 CREATE INDEX ctd_count ON /*_*/change_tag_def (ctd_count);
207 CREATE INDEX ctd_user_defined ON /*_*/change_tag_def (ctd_user_defined);
209 CREATE TABLE /*_*/ipblocks_restrictions (
210 ir_ipb_id INTEGER NOT NULL,
211 ir_type INTEGER NOT NULL,
212 ir_value INTEGER NOT NULL,
213 PRIMARY KEY(ir_ipb_id, ir_type, ir_value)
215 CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value);
217 CREATE TABLE /*_*/querycache (
218 qc_type BLOB NOT NULL, qc_value INTEGER DEFAULT 0 NOT NULL,
219 qc_namespace INTEGER DEFAULT 0 NOT NULL,
220 qc_title BLOB DEFAULT '' NOT NULL
222 CREATE INDEX qc_type ON /*_*/querycache (qc_type, qc_value);
224 CREATE TABLE /*_*/querycachetwo (
225 qcc_type BLOB NOT NULL, qcc_value INTEGER DEFAULT 0 NOT NULL,
226 qcc_namespace INTEGER DEFAULT 0 NOT NULL,
227 qcc_title BLOB DEFAULT '' NOT NULL,
228 qcc_namespacetwo INTEGER DEFAULT 0 NOT NULL,
229 qcc_titletwo BLOB DEFAULT '' NOT NULL
231 CREATE INDEX qcc_type ON /*_*/querycachetwo (qcc_type, qcc_value);
232 CREATE INDEX qcc_title ON /*_*/querycachetwo (
233 qcc_type, qcc_namespace, qcc_title
235 CREATE INDEX qcc_titletwo ON /*_*/querycachetwo (
236 qcc_type, qcc_namespacetwo, qcc_titletwo
239 CREATE TABLE /*_*/page_restrictions (
240 pr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
241 pr_page INTEGER NOT NULL, pr_type BLOB NOT NULL,
242 pr_level BLOB NOT NULL, pr_cascade INTEGER NOT NULL,
243 pr_user INTEGER DEFAULT NULL,
244 pr_expiry BLOB DEFAULT NULL
246 CREATE UNIQUE INDEX pr_pagetype ON /*_*/page_restrictions (pr_page, pr_type);
247 CREATE INDEX pr_typelevel ON /*_*/page_restrictions (pr_type, pr_level);
248 CREATE INDEX pr_level ON /*_*/page_restrictions (pr_level);
249 CREATE INDEX pr_cascade ON /*_*/page_restrictions (pr_cascade);
251 CREATE TABLE /*_*/user_groups (
252 ug_user INTEGER DEFAULT 0 NOT NULL,
253 ug_group BLOB DEFAULT '' NOT NULL,
254 ug_expiry BLOB DEFAULT NULL,
255 PRIMARY KEY(ug_user, ug_group)
257 CREATE INDEX ug_group ON /*_*/user_groups (ug_group);
258 CREATE INDEX ug_expiry ON /*_*/user_groups (ug_expiry);
260 CREATE TABLE /*_*/querycache_info (
261 qci_type BLOB DEFAULT '' NOT NULL,
262 qci_timestamp BLOB DEFAULT '19700101000000' NOT NULL,
263 PRIMARY KEY(qci_type)
266 CREATE TABLE /*_*/watchlist (
267 wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
268 wl_user INTEGER NOT NULL,
269 wl_namespace INTEGER DEFAULT 0 NOT NULL,
270 wl_title BLOB DEFAULT '' NOT NULL, wl_notificationtimestamp BLOB DEFAULT NULL
272 CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title);
273 CREATE INDEX wl_namespace_title ON /*_*/watchlist (wl_namespace, wl_title);
274 CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist (
275 wl_user, wl_notificationtimestamp
278 CREATE TABLE /*_*/sites (
279 site_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
280 site_global_key BLOB NOT NULL,
281 site_type BLOB NOT NULL,
282 site_group BLOB NOT NULL,
283 site_source BLOB NOT NULL,
284 site_language BLOB NOT NULL,
285 site_protocol BLOB NOT NULL,
286 site_domain TEXT NOT NULL,
287 site_data BLOB NOT NULL,
288 site_forward INTEGER NOT NULL,
289 site_config BLOB NOT NULL
291 CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key);
292 CREATE INDEX site_type ON /*_*/sites (site_type);
293 CREATE INDEX site_group ON /*_*/sites (site_group);
294 CREATE INDEX site_source ON /*_*/sites (site_source);
295 CREATE INDEX site_language ON /*_*/sites (site_language);
296 CREATE INDEX site_protocol ON /*_*/sites (site_protocol);
297 CREATE INDEX site_domain ON /*_*/sites (site_domain);
298 CREATE INDEX site_forward ON /*_*/sites (site_forward);
300 CREATE TABLE /*_*/user_newtalk (
301 user_id INTEGER DEFAULT 0 NOT NULL,
302 user_ip BLOB DEFAULT '' NOT NULL, user_last_timestamp BLOB DEFAULT NULL
304 CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id);
305 CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip);
307 CREATE TABLE /*_*/interwiki (
308 iw_prefix TEXT NOT NULL,
309 iw_url BLOB NOT NULL,
310 iw_api BLOB NOT NULL,
311 iw_wikiid TEXT NOT NULL,
312 iw_local INTEGER NOT NULL,
313 iw_trans INTEGER DEFAULT 0 NOT NULL,
314 PRIMARY KEY(iw_prefix)
317 CREATE TABLE /*_*/protected_titles (
318 pt_namespace INTEGER NOT NULL,
319 pt_title BLOB NOT NULL,
320 pt_user INTEGER NOT NULL,
321 pt_reason_id INTEGER NOT NULL,
322 pt_timestamp BLOB NOT NULL,
323 pt_expiry BLOB NOT NULL,
324 pt_create_perm BLOB NOT NULL,
325 PRIMARY KEY(pt_namespace, pt_title)
327 CREATE INDEX pt_timestamp ON /*_*/protected_titles (pt_timestamp);
329 CREATE TABLE /*_*/externallinks (
330 el_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
331 el_from INTEGER DEFAULT 0 NOT NULL,
332 el_to BLOB NOT NULL, el_index BLOB NOT NULL,
333 el_index_60 BLOB NOT NULL
335 CREATE INDEX el_from ON /*_*/externallinks (el_from, el_to);
336 CREATE INDEX el_to ON /*_*/externallinks (el_to, el_from);
337 CREATE INDEX el_index ON /*_*/externallinks (el_index);
338 CREATE INDEX el_index_60 ON /*_*/externallinks (el_index_60, el_id);
339 CREATE INDEX el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id);
341 CREATE TABLE /*_*/ip_changes (
342 ipc_rev_id INTEGER DEFAULT 0 NOT NULL,
343 ipc_rev_timestamp BLOB NOT NULL,
344 ipc_hex BLOB DEFAULT '' NOT NULL,
345 PRIMARY KEY(ipc_rev_id)
347 CREATE INDEX ipc_rev_timestamp ON /*_*/ip_changes (ipc_rev_timestamp);
348 CREATE INDEX ipc_hex_time ON /*_*/ip_changes (ipc_hex, ipc_rev_timestamp);
350 CREATE TABLE /*_*/revision_comment_temp (
351 revcomment_rev INTEGER NOT NULL,
352 revcomment_comment_id INTEGER NOT NULL,
354 revcomment_rev, revcomment_comment_id
357 CREATE UNIQUE INDEX revcomment_rev ON /*_*/revision_comment_temp (revcomment_rev);
359 CREATE TABLE /*_*/revision_actor_temp (
360 revactor_rev INTEGER NOT NULL,
361 revactor_actor INTEGER NOT NULL,
362 revactor_timestamp BLOB NOT NULL,
363 revactor_page INTEGER NOT NULL,
364 PRIMARY KEY(revactor_rev, revactor_actor)
366 CREATE UNIQUE INDEX revactor_rev ON /*_*/revision_actor_temp (revactor_rev);
367 CREATE INDEX actor_timestamp ON /*_*/revision_actor_temp (
368 revactor_actor, revactor_timestamp
370 CREATE INDEX page_actor_timestamp ON /*_*/revision_actor_temp (
371 revactor_page, revactor_actor, revactor_timestamp
374 CREATE TABLE /*_*/page_props (
375 pp_page INTEGER NOT NULL,
376 pp_propname BLOB NOT NULL,
377 pp_value BLOB NOT NULL,
378 pp_sortkey REAL DEFAULT NULL,
379 PRIMARY KEY(pp_page, pp_propname)
381 CREATE UNIQUE INDEX pp_propname_page ON /*_*/page_props (pp_propname, pp_page);
382 CREATE UNIQUE INDEX pp_propname_sortkey_page ON /*_*/page_props (pp_propname, pp_sortkey, pp_page);
384 CREATE TABLE /*_*/job (
385 job_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
386 job_cmd BLOB DEFAULT '' NOT NULL, job_namespace INTEGER NOT NULL,
387 job_title BLOB NOT NULL, job_timestamp BLOB DEFAULT NULL,
388 job_params BLOB NOT NULL, job_random INTEGER DEFAULT 0 NOT NULL,
389 job_attempts INTEGER DEFAULT 0 NOT NULL,
390 job_token BLOB DEFAULT '' NOT NULL,
391 job_token_timestamp BLOB DEFAULT NULL,
392 job_sha1 BLOB DEFAULT '' NOT NULL
394 CREATE INDEX job_sha1 ON /*_*/job (job_sha1);
395 CREATE INDEX job_cmd_token ON /*_*/job (job_cmd, job_token, job_random);
396 CREATE INDEX job_cmd_token_id ON /*_*/job (job_cmd, job_token, job_id);
397 CREATE INDEX job_cmd ON /*_*/job (
398 job_cmd, job_namespace, job_title,
401 CREATE INDEX job_timestamp ON /*_*/job (job_timestamp);
403 CREATE TABLE /*_*/slot_roles (
404 role_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
405 role_name BLOB NOT NULL
407 CREATE UNIQUE INDEX role_name ON /*_*/slot_roles (role_name);
409 CREATE TABLE /*_*/content_models (
410 model_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
411 model_name BLOB NOT NULL
413 CREATE UNIQUE INDEX model_name ON /*_*/content_models (model_name);
415 CREATE TABLE /*_*/categorylinks (
416 cl_from INTEGER DEFAULT 0 NOT NULL,
417 cl_to BLOB DEFAULT '' NOT NULL,
418 cl_sortkey BLOB DEFAULT '' NOT NULL,
419 cl_sortkey_prefix BLOB DEFAULT '' NOT NULL,
420 cl_timestamp TEXT NOT NULL,
421 cl_collation BLOB DEFAULT '' NOT NULL,
422 cl_type TEXT DEFAULT 'page' NOT NULL,
423 PRIMARY KEY(cl_from, cl_to)
425 CREATE INDEX cl_sortkey ON /*_*/categorylinks (
426 cl_to, cl_type, cl_sortkey, cl_from
428 CREATE INDEX cl_timestamp ON /*_*/categorylinks (cl_to, cl_timestamp);
429 CREATE INDEX cl_collation_ext ON /*_*/categorylinks (
430 cl_collation, cl_to, cl_type, cl_from
433 CREATE TABLE /*_*/logging (
434 log_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
435 log_type BLOB DEFAULT '' NOT NULL, log_action BLOB DEFAULT '' NOT NULL,
436 log_timestamp BLOB DEFAULT '19700101000000' NOT NULL,
437 log_actor INTEGER NOT NULL,
438 log_namespace INTEGER DEFAULT 0 NOT NULL,
439 log_title BLOB DEFAULT '' NOT NULL,
440 log_page INTEGER DEFAULT NULL,
441 log_comment_id INTEGER NOT NULL,
442 log_params BLOB NOT NULL, log_deleted INTEGER DEFAULT 0 NOT NULL
444 CREATE INDEX log_type_time ON /*_*/logging (log_type, log_timestamp);
445 CREATE INDEX log_actor_time ON /*_*/logging (log_actor, log_timestamp);
446 CREATE INDEX log_page_time ON /*_*/logging (
447 log_namespace, log_title, log_timestamp
449 CREATE INDEX log_times ON /*_*/logging (log_timestamp);
450 CREATE INDEX log_actor_type_time ON /*_*/logging (
451 log_actor, log_type, log_timestamp
453 CREATE INDEX log_page_id_time ON /*_*/logging (log_page, log_timestamp);
454 CREATE INDEX log_type_action ON /*_*/logging (
455 log_type, log_action, log_timestamp
458 CREATE TABLE /*_*/uploadstash (
459 us_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
460 us_user INTEGER NOT NULL,
461 us_key TEXT NOT NULL,
462 us_orig_path TEXT NOT NULL,
463 us_path TEXT NOT NULL,
464 us_source_type TEXT DEFAULT NULL,
465 us_timestamp BLOB NOT NULL,
466 us_status TEXT NOT NULL,
467 us_chunk_inx INTEGER DEFAULT NULL,
468 us_props BLOB DEFAULT NULL,
469 us_size INTEGER NOT NULL,
470 us_sha1 TEXT NOT NULL,
471 us_mime TEXT DEFAULT NULL,
472 us_media_type TEXT DEFAULT NULL,
473 us_image_width INTEGER DEFAULT NULL,
474 us_image_height INTEGER DEFAULT NULL,
475 us_image_bits INTEGER DEFAULT NULL
477 CREATE INDEX us_user ON /*_*/uploadstash (us_user);
478 CREATE UNIQUE INDEX us_key ON /*_*/uploadstash (us_key);
479 CREATE INDEX us_timestamp ON /*_*/uploadstash (us_timestamp);
481 CREATE TABLE /*_*/filearchive (
482 fa_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
483 fa_name BLOB DEFAULT '' NOT NULL, fa_archive_name BLOB DEFAULT '',
484 fa_storage_group BLOB DEFAULT NULL,
485 fa_storage_key BLOB DEFAULT '', fa_deleted_user INTEGER DEFAULT NULL,
486 fa_deleted_timestamp BLOB DEFAULT NULL,
487 fa_deleted_reason_id INTEGER NOT NULL,
488 fa_size INTEGER DEFAULT 0,
489 fa_width INTEGER DEFAULT 0, fa_height INTEGER DEFAULT 0,
490 fa_metadata BLOB DEFAULT NULL, fa_bits INTEGER DEFAULT 0,
491 fa_media_type TEXT DEFAULT NULL, fa_major_mime TEXT DEFAULT 'unknown',
492 fa_minor_mime BLOB DEFAULT 'unknown',
493 fa_description_id INTEGER NOT NULL,
494 fa_actor INTEGER NOT NULL,
495 fa_timestamp BLOB DEFAULT NULL, fa_deleted INTEGER DEFAULT 0 NOT NULL,
496 fa_sha1 BLOB DEFAULT '' NOT NULL
498 CREATE INDEX fa_name ON /*_*/filearchive (fa_name, fa_timestamp);
499 CREATE INDEX fa_storage_group ON /*_*/filearchive (
500 fa_storage_group, fa_storage_key
502 CREATE INDEX fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp);
503 CREATE INDEX fa_actor_timestamp ON /*_*/filearchive (fa_actor, fa_timestamp);
504 CREATE INDEX fa_sha1 ON /*_*/filearchive (fa_sha1);
506 CREATE TABLE /*_*/text (
507 old_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
508 old_text BLOB NOT NULL, old_flags BLOB NOT NULL
511 CREATE TABLE /*_*/oldimage (
512 oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL,
513 oi_size INTEGER DEFAULT 0 NOT NULL,
514 oi_width INTEGER DEFAULT 0 NOT NULL,
515 oi_height INTEGER DEFAULT 0 NOT NULL,
516 oi_bits INTEGER DEFAULT 0 NOT NULL,
517 oi_description_id INTEGER NOT NULL,
518 oi_actor INTEGER NOT NULL,
519 oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL,
520 oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL,
521 oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL,
522 oi_deleted INTEGER DEFAULT 0 NOT NULL,
523 oi_sha1 BLOB DEFAULT '' NOT NULL
525 CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp);
526 CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp);
527 CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name);
528 CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1);
530 CREATE TABLE /*_*/objectcache (
531 keyname BLOB DEFAULT '' NOT NULL,
532 value BLOB DEFAULT NULL,
533 exptime BLOB NOT NULL,
536 CREATE INDEX exptime ON /*_*/objectcache (exptime);
538 CREATE TABLE /*_*/ipblocks (
539 ipb_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
540 ipb_address BLOB NOT NULL, ipb_user INTEGER DEFAULT 0 NOT NULL,
541 ipb_by_actor INTEGER NOT NULL,
542 ipb_reason_id INTEGER NOT NULL,
543 ipb_timestamp BLOB NOT NULL, ipb_auto INTEGER DEFAULT 0 NOT NULL,
544 ipb_anon_only INTEGER DEFAULT 0 NOT NULL,
545 ipb_create_account INTEGER DEFAULT 1 NOT NULL,
546 ipb_enable_autoblock INTEGER DEFAULT 1 NOT NULL,
547 ipb_expiry BLOB NOT NULL, ipb_range_start BLOB NOT NULL,
548 ipb_range_end BLOB NOT NULL, ipb_deleted INTEGER DEFAULT 0 NOT NULL,
549 ipb_block_email INTEGER DEFAULT 0 NOT NULL,
550 ipb_allow_usertalk INTEGER DEFAULT 0 NOT NULL,
551 ipb_parent_block_id INTEGER DEFAULT NULL,
552 ipb_sitewide INTEGER DEFAULT 1 NOT NULL
554 CREATE UNIQUE INDEX ipb_address_unique ON /*_*/ipblocks (ipb_address, ipb_user, ipb_auto);
555 CREATE INDEX ipb_user ON /*_*/ipblocks (ipb_user);
556 CREATE INDEX ipb_range ON /*_*/ipblocks (ipb_range_start, ipb_range_end);
557 CREATE INDEX ipb_timestamp ON /*_*/ipblocks (ipb_timestamp);
558 CREATE INDEX ipb_expiry ON /*_*/ipblocks (ipb_expiry);
559 CREATE INDEX ipb_parent_block_id ON /*_*/ipblocks (ipb_parent_block_id);
561 CREATE TABLE /*_*/image (
562 img_name BLOB DEFAULT '' NOT NULL,
563 img_size INTEGER DEFAULT 0 NOT NULL,
564 img_width INTEGER DEFAULT 0 NOT NULL,
565 img_height INTEGER DEFAULT 0 NOT NULL,
566 img_metadata BLOB NOT NULL,
567 img_bits INTEGER DEFAULT 0 NOT NULL,
568 img_media_type TEXT DEFAULT NULL,
569 img_major_mime TEXT DEFAULT 'unknown' NOT NULL,
570 img_minor_mime BLOB DEFAULT 'unknown' NOT NULL,
571 img_description_id INTEGER NOT NULL,
572 img_actor INTEGER NOT NULL,
573 img_timestamp BLOB NOT NULL,
574 img_sha1 BLOB DEFAULT '' NOT NULL,
575 PRIMARY KEY(img_name)
577 CREATE INDEX img_actor_timestamp ON /*_*/image (img_actor, img_timestamp);
578 CREATE INDEX img_size ON /*_*/image (img_size);
579 CREATE INDEX img_timestamp ON /*_*/image (img_timestamp);
580 CREATE INDEX img_sha1 ON /*_*/image (img_sha1);
581 CREATE INDEX img_media_mime ON /*_*/image (
582 img_media_type, img_major_mime, img_minor_mime
585 CREATE TABLE /*_*/recentchanges (
586 rc_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
587 rc_timestamp BLOB NOT NULL, rc_actor INTEGER NOT NULL,
588 rc_namespace INTEGER DEFAULT 0 NOT NULL,
589 rc_title BLOB DEFAULT '' NOT NULL, rc_comment_id INTEGER NOT NULL,
590 rc_minor INTEGER DEFAULT 0 NOT NULL,
591 rc_bot INTEGER DEFAULT 0 NOT NULL,
592 rc_new INTEGER DEFAULT 0 NOT NULL,
593 rc_cur_id INTEGER DEFAULT 0 NOT NULL,
594 rc_this_oldid INTEGER DEFAULT 0 NOT NULL,
595 rc_last_oldid INTEGER DEFAULT 0 NOT NULL,
596 rc_type INTEGER DEFAULT 0 NOT NULL,
597 rc_source BLOB DEFAULT '' NOT NULL,
598 rc_patrolled INTEGER DEFAULT 0 NOT NULL,
599 rc_ip BLOB DEFAULT '' NOT NULL, rc_old_len INTEGER DEFAULT NULL,
600 rc_new_len INTEGER DEFAULT NULL, rc_deleted INTEGER DEFAULT 0 NOT NULL,
601 rc_logid INTEGER DEFAULT 0 NOT NULL,
602 rc_log_type BLOB DEFAULT NULL, rc_log_action BLOB DEFAULT NULL,
603 rc_params BLOB DEFAULT NULL
605 CREATE INDEX rc_timestamp ON /*_*/recentchanges (rc_timestamp);
606 CREATE INDEX rc_namespace_title_timestamp ON /*_*/recentchanges (
607 rc_namespace, rc_title, rc_timestamp
609 CREATE INDEX rc_cur_id ON /*_*/recentchanges (rc_cur_id);
610 CREATE INDEX rc_new_name_timestamp ON /*_*/recentchanges (
611 rc_new, rc_namespace, rc_timestamp
613 CREATE INDEX rc_ip ON /*_*/recentchanges (rc_ip);
614 CREATE INDEX rc_ns_actor ON /*_*/recentchanges (rc_namespace, rc_actor);
615 CREATE INDEX rc_actor ON /*_*/recentchanges (rc_actor, rc_timestamp);
616 CREATE INDEX rc_name_type_patrolled_timestamp ON /*_*/recentchanges (
617 rc_namespace, rc_type, rc_patrolled,
620 CREATE INDEX rc_this_oldid ON /*_*/recentchanges (rc_this_oldid);
622 CREATE TABLE /*_*/archive (
623 ar_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
624 ar_namespace INTEGER DEFAULT 0 NOT NULL,
625 ar_title BLOB DEFAULT '' NOT NULL, ar_comment_id INTEGER NOT NULL,
626 ar_actor INTEGER NOT NULL,
627 ar_timestamp BLOB NOT NULL, ar_minor_edit INTEGER DEFAULT 0 NOT NULL,
628 ar_rev_id INTEGER NOT NULL,
629 ar_deleted INTEGER DEFAULT 0 NOT NULL,
630 ar_len INTEGER DEFAULT NULL,
631 ar_page_id INTEGER DEFAULT NULL,
632 ar_parent_id INTEGER DEFAULT NULL,
633 ar_sha1 BLOB DEFAULT '' NOT NULL
635 CREATE INDEX ar_name_title_timestamp ON /*_*/archive (
636 ar_namespace, ar_title, ar_timestamp
638 CREATE INDEX ar_actor_timestamp ON /*_*/archive (ar_actor, ar_timestamp);
639 CREATE UNIQUE INDEX ar_revid_uniq ON /*_*/archive (ar_rev_id);
641 CREATE TABLE /*_*/page (
642 page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
643 page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL,
644 page_restrictions BLOB DEFAULT NULL,
645 page_is_redirect INTEGER DEFAULT 0 NOT NULL,
646 page_is_new INTEGER DEFAULT 0 NOT NULL,
647 page_random REAL NOT NULL,
648 page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL,
649 page_latest INTEGER NOT NULL,
650 page_len INTEGER NOT NULL,
651 page_content_model BLOB DEFAULT NULL,
652 page_lang BLOB DEFAULT NULL
654 CREATE UNIQUE INDEX name_title ON /*_*/page (page_namespace, page_title);
655 CREATE INDEX page_random ON /*_*/page (page_random);
656 CREATE INDEX page_len ON /*_*/page (page_len);
657 CREATE INDEX page_redirect_namespace_len ON /*_*/page (
658 page_is_redirect, page_namespace,
661 CREATE TABLE /*_*/user (
662 user_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
663 user_name BLOB NOT NULL default '',
664 user_real_name BLOB NOT NULL default '',
665 user_password BLOB NOT NULL,
666 user_newpassword BLOB NOT NULL,
667 user_newpass_time BLOB,
668 user_email TEXT NOT NULL,
669 user_touched BLOB NOT NULL,
670 user_token BLOB NOT NULL default '',
671 user_email_authenticated BLOB,
672 user_email_token BLOB,
673 user_email_token_expires BLOB,
674 user_registration BLOB,
675 user_editcount INTEGER,
676 user_password_expires BLOB DEFAULT NULL
677 ) /*$wgDBTableOptions*/;
678 CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name);
679 CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token);
680 CREATE INDEX /*i*/user_email ON /*_*/user (user_email);
681 CREATE TABLE /*_*/revision (
682 rev_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
683 rev_page INTEGER NOT NULL,
684 rev_comment_id INTEGER NOT NULL default 0,
685 rev_actor INTEGER NOT NULL default 0,
686 rev_timestamp BLOB NOT NULL default '',
687 rev_minor_edit INTEGER NOT NULL default 0,
688 rev_deleted INTEGER NOT NULL default 0,
690 rev_parent_id INTEGER default NULL,
691 rev_sha1 BLOB NOT NULL default ''
692 ) /*$wgDBTableOptions*/;
694 CREATE INDEX /*i*/rev_page_id ON /*_*/revision (rev_page, rev_id);
695 CREATE INDEX /*i*/rev_timestamp ON /*_*/revision (rev_timestamp);
696 CREATE INDEX /*i*/page_timestamp ON /*_*/revision (rev_page,rev_timestamp);
697 CREATE INDEX /*i*/rev_actor_timestamp ON /*_*/revision (rev_actor,rev_timestamp,rev_id);
698 CREATE INDEX /*i*/rev_page_actor_timestamp ON /*_*/revision (rev_page,rev_actor,rev_timestamp);
700 CREATE TABLE /*_*/searchindex (
701 si_page INTEGER NOT NULL,
702 si_title TEXT NOT NULL default '',
703 si_text TEXT NOT NULL
705 CREATE UNIQUE INDEX /*i*/si_page ON /*_*/searchindex (si_page);
706 CREATE INDEX /*i*/si_title ON /*_*/searchindex (si_title);
707 CREATE INDEX /*i*/si_text ON /*_*/searchindex (si_text);