maintenance/sqlite/tables.sql

   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48 CREATE TABLE /*$wgDBprefix*/user (
  49   user_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  50
  51
  52
  53
  54
  55   user_name varchar(255)   default '',
  56
  57   user_real_name varchar(255)   default '',
  58
  59
  60
  61   user_password tinyblob ,
  62
  63
  64
  65
  66
  67
  68   user_newpassword tinyblob ,
  69
  70
  71   user_newpass_time BLOB,
  72
  73
  74   user_email tinytext ,
  75
  76
  77   user_options blob ,
  78
  79
  80
  81
  82   user_touched BLOB  default '',
  83
  84
  85
  86
  87   user_token BLOB  default '',
  88
  89
  90
  91   user_email_authenticated BLOB,
  92
  93
  94   user_email_token BLOB,
  95
  96   user_email_token_expires BLOB,
  97
  98
  99   user_registration BLOB,
 100
 101
 102
 103
 104
 105
 106
 107
 108
 109
 110   user_editcount int) /*$wgDBTableOptions*/;
 111
 112
 113
 114
 115
 116
 117
 118
 119 CREATE TABLE /*$wgDBprefix*/user_groups (
 120
 121   ug_user INTEGER  default '0',
 122
 123
 124
 125
 126
 127
 128
 129
 130   ug_group varBLOB  default '') /*$wgDBTableOptions*/;
 131
 132
 133 CREATE TABLE /*$wgDBprefix*/user_newtalk (
 134
 135   user_id INTEGER  default '0',
 136
 137
 138   user_ip varBLOB  default '',
 139
 140
 141   user_last_timestamp BLOB  default '') /*$wgDBTableOptions*/;
 142
 143
 144
 145
 146 CREATE TABLE /*$wgDBprefix*/page (
 147
 148
 149   page_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 150
 151
 152
 153   page_namespace INTEGER ,
 154
 155
 156   page_title varchar(255)  ,
 157
 158
 159   page_restrictions tinyblob ,
 160
 161   page_counter bigint  default '0',
 162
 163   page_is_redirect tinyint  default '0',
 164
 165
 166   page_is_new tinyint  default '0',
 167
 168   page_random real ,
 169
 170
 171
 172
 173
 174   page_touched BLOB  default '',
 175
 176
 177
 178   page_latest INTEGER ,
 179
 180   page_len INTEGER ) /*$wgDBTableOptions*/;
 181
 182
 183
 184
 185
 186 CREATE TABLE /*$wgDBprefix*/revision (
 187   rev_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 188
 189   rev_page INTEGER ,
 190
 191
 192
 193
 194   rev_text_id INTEGER ,
 195
 196
 197
 198   rev_comment tinyblob ,
 199
 200
 201   rev_user INTEGER  default '0',
 202
 203   rev_user_text varchar(255)   default '',
 204
 205   rev_timestamp BLOB  default '',
 206
 207
 208   rev_minor_edit tinyint  default '0',
 209
 210   rev_deleted tinyint  default '0',
 211
 212   rev_len int,
 213
 214
 215   rev_parent_id INTEGER default NULL) /*$wgDBTableOptions*/  ;
 216
 217
 218
 219
 220
 221
 222
 223
 224
 225 CREATE TABLE /*$wgDBprefix*/text (
 226
 227
 228
 229
 230
 231   old_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 232
 233
 234   old_text mediumblob ,
 235
 236
 237
 238
 239
 240
 241
 242
 243
 244   old_flags tinyblob ) /*$wgDBTableOptions*/  ;
 245
 246
 247
 248
 249
 250
 251
 252 CREATE TABLE /*$wgDBprefix*/archive (
 253   ar_namespace INTEGER  default '0',
 254   ar_title varchar(255)   default '',
 255
 256
 257
 258
 259
 260
 261   ar_text mediumblob ,
 262
 263   ar_comment tinyblob ,
 264   ar_user INTEGER  default '0',
 265   ar_user_text varchar(255)  ,
 266   ar_timestamp BLOB  default '',
 267   ar_minor_edit tinyint  default '0',
 268
 269   ar_flags tinyblob ,
 270
 271
 272
 273
 274
 275
 276
 277   ar_rev_id int,
 278
 279
 280
 281
 282
 283
 284
 285
 286
 287   ar_text_id int,
 288
 289   ar_deleted tinyint  default '0',
 290
 291   ar_len int,
 292
 293
 294
 295
 296
 297   ar_page_id int,
 298
 299   ar_parent_id INTEGER default NULL) /*$wgDBTableOptions*/;
 300
 301
 302
 303 CREATE TABLE /*$wgDBprefix*/pagelinks (
 304
 305   pl_from INTEGER  default '0',
 306
 307
 308
 309
 310   pl_namespace INTEGER  default '0',
 311   pl_title varchar(255)   default '') /*$wgDBTableOptions*/;
 312
 313
 314
 315 CREATE TABLE /*$wgDBprefix*/templatelinks (
 316
 317   tl_from INTEGER  default '0',
 318
 319
 320
 321
 322   tl_namespace INTEGER  default '0',
 323   tl_title varchar(255)   default '') /*$wgDBTableOptions*/;
 324
 325
 326
 327
 328
 329 CREATE TABLE /*$wgDBprefix*/imagelinks (
 330
 331   il_from INTEGER  default '0',
 332
 333
 334
 335   il_to varchar(255)   default '') /*$wgDBTableOptions*/;
 336
 337
 338
 339
 340
 341 CREATE TABLE /*$wgDBprefix*/categorylinks (
 342
 343   cl_from INTEGER  default '0',
 344
 345
 346
 347   cl_to varchar(255)   default '',
 348
 349
 350
 351
 352
 353
 354
 355
 356   cl_sortkey varchar(70)   default '',
 357
 358
 359   cl_timestamp timestamp ) /*$wgDBTableOptions*/;
 360
 361
 362
 363
 364
 365 CREATE TABLE /*$wgDBprefix*/category (
 366
 367   cat_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 368
 369
 370
 371   cat_title varchar(255)  ,
 372
 373
 374
 375
 376
 377   cat_pages INTEGER signed  default 0,
 378   cat_subcats INTEGER signed  default 0,
 379   cat_files INTEGER signed  default 0,
 380
 381   cat_hidden tinyint  default 0) /*$wgDBTableOptions*/;
 382
 383
 384
 385 CREATE TABLE /*$wgDBprefix*/externallinks (
 386
 387   el_from INTEGER  default '0',
 388
 389   el_to blob ,
 390
 391
 392
 393
 394
 395
 396
 397
 398
 399
 400
 401   el_index blob ) /*$wgDBTableOptions*/;
 402
 403
 404
 405 CREATE TABLE /*$wgDBprefix*/langlinks (
 406
 407   ll_from INTEGER  default '0',
 408
 409   ll_lang varBLOB  default '',
 410
 411   ll_title varchar(255)   default '') /*$wgDBTableOptions*/;
 412
 413
 414
 415
 416 CREATE TABLE /*$wgDBprefix*/site_stats (
 417
 418   ss_row_id INTEGER ,
 419
 420   ss_total_views bigint default '0',
 421
 422   ss_total_edits bigint default '0',
 423
 424
 425
 426
 427
 428   ss_good_articles bigint default '0',
 429
 430   ss_total_pages bigint default '-1',
 431
 432   ss_users bigint default '-1',
 433
 434   ss_admins INTEGER default '-1',
 435
 436   ss_images INTEGER default '0') /*$wgDBTableOptions*/;
 437
 438
 439
 440
 441
 442
 443
 444 CREATE TABLE /*$wgDBprefix*/hitcounter (
 445   hc_id INTEGER
 446 )  ;
 447
 448
 449
 450
 451 CREATE TABLE /*$wgDBprefix*/ipblocks (
 452
 453   ipb_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 454
 455   ipb_address tinyblob ,
 456
 457   ipb_user INTEGER  default '0',
 458
 459   ipb_by INTEGER  default '0',
 460
 461   ipb_by_text varchar(255)   default '',
 462
 463   ipb_reason tinyblob ,
 464
 465
 466   ipb_timestamp BLOB  default '',
 467
 468
 469
 470   ipb_auto bool  default 0,
 471
 472   ipb_anon_only bool  default 0,
 473
 474   ipb_create_account bool  default 1,
 475
 476   ipb_enable_autoblock bool  default '1',
 477
 478
 479   ipb_expiry varBLOB  default '',
 480
 481
 482   ipb_range_start tinyblob ,
 483   ipb_range_end tinyblob ,
 484
 485   ipb_deleted bool  default 0,
 486
 487   ipb_block_email bool  default 0) /*$wgDBTableOptions*/;
 488
 489
 490
 491 CREATE TABLE /*$wgDBprefix*/image (
 492
 493
 494
 495   img_name varchar(255)   default '',
 496
 497   img_size INTEGER  default '0',
 498
 499   img_width INTEGER  default '0',
 500   img_height INTEGER  default '0',
 501
 502   img_metadata mediumblob ,
 503
 504   img_bits INTEGER  default '0',
 505
 506   img_media_type TEXT default NULL,
 507
 508
 509   img_major_mime TEXT  default "unknown",
 510
 511
 512
 513
 514   img_minor_mime varBLOB  default "unknown",
 515
 516
 517   img_description tinyblob ,
 518
 519   img_user INTEGER  default '0',
 520   img_user_text varchar(255)  ,
 521
 522   img_timestamp varBLOB  default '',
 523
 524   img_sha1 varBLOB  default '') /*$wgDBTableOptions*/;
 525
 526
 527
 528
 529
 530 CREATE TABLE /*$wgDBprefix*/oldimage (
 531
 532   oi_name varchar(255)   default '',
 533
 534
 535   oi_archive_name varchar(255)   default '',
 536
 537   oi_size INTEGER  default 0,
 538   oi_width INTEGER  default 0,
 539   oi_height INTEGER  default 0,
 540   oi_bits INTEGER  default 0,
 541   oi_description tinyblob ,
 542   oi_user INTEGER  default '0',
 543   oi_user_text varchar(255)  ,
 544   oi_timestamp BLOB  default '',
 545
 546   oi_metadata mediumblob ,
 547   oi_media_type TEXT default NULL,
 548   oi_major_mime TEXT  default "unknown",
 549   oi_minor_mime varBLOB  default "unknown",
 550   oi_deleted tinyint  default '0',
 551   oi_sha1 varBLOB  default '') /*$wgDBTableOptions*/;
 552
 553
 554
 555 CREATE TABLE /*$wgDBprefix*/filearchive (
 556
 557   fa_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 558
 559   fa_name varchar(255)   default '',
 560
 561   fa_archive_name varchar(255)  default '',
 562
 563
 564
 565   fa_storage_group varBLOB,
 566
 567
 568
 569
 570
 571   fa_storage_key varBLOB default '',
 572
 573   fa_deleted_user int,
 574   fa_deleted_timestamp BLOB default '',
 575   fa_deleted_reason text,
 576
 577   fa_size INTEGER default '0',
 578   fa_width INTEGER default '0',
 579   fa_height INTEGER default '0',
 580   fa_metadata mediumblob,
 581   fa_bits INTEGER default '0',
 582   fa_media_type TEXT default NULL,
 583   fa_major_mime TEXT default "unknown",
 584   fa_minor_mime varBLOB default "unknown",
 585   fa_description tinyblob,
 586   fa_user INTEGER default '0',
 587   fa_user_text varchar(255) ,
 588   fa_timestamp BLOB default '',
 589
 590   fa_deleted tinyint  default '0') /*$wgDBTableOptions*/;
 591
 592
 593
 594
 595
 596 CREATE TABLE /*$wgDBprefix*/recentchanges (
 597   rc_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 598   rc_timestamp varBLOB  default '',
 599   rc_cur_time varBLOB  default '',
 600
 601   rc_user INTEGER  default '0',
 602   rc_user_text varchar(255)  ,
 603
 604   rc_namespace INTEGER  default '0',
 605   rc_title varchar(255)   default '',
 606
 607   rc_comment varchar(255)   default '',
 608   rc_minor tinyint  default '0',
 609
 610
 611
 612   rc_bot tinyint  default '0',
 613
 614   rc_new tinyint  default '0',
 615
 616
 617
 618   rc_cur_id INTEGER  default '0',
 619
 620   rc_this_oldid INTEGER  default '0',
 621
 622   rc_last_oldid INTEGER  default '0',
 623
 624   rc_type tinyint  default '0',
 625   rc_moved_to_ns tinyint  default '0',
 626   rc_moved_to_title varchar(255)   default '',
 627
 628
 629
 630
 631   rc_patrolled tinyint  default '0',
 632
 633
 634   rc_ip varBLOB  default '',
 635
 636
 637   rc_old_len int,
 638   rc_new_len int,
 639
 640   rc_deleted tinyint  default '0',
 641
 642   rc_logid INTEGER  default '0',
 643
 644   rc_log_type varBLOB NULL default NULL,
 645
 646   rc_log_action varBLOB NULL default NULL,
 647
 648   rc_params blob NULL) /*$wgDBTableOptions*/;
 649
 650 CREATE TABLE /*$wgDBprefix*/watchlist (
 651
 652   wl_user INTEGER ,
 653
 654
 655
 656   wl_namespace INTEGER  default '0',
 657   wl_title varchar(255)   default '',
 658
 659
 660   wl_notificationtimestamp varBLOB) /*$wgDBTableOptions*/;
 661
 662
 663
 664
 665 CREATE TABLE /*$wgDBprefix*/math (
 666
 667   math_inputhash varBLOB ,
 668
 669   math_outputhash varBLOB ,
 670
 671
 672   math_html_conservativeness tinyint ,
 673
 674   math_html text,
 675
 676   math_mathml text) /*$wgDBTableOptions*/;
 677
 678
 679
 680
 681
 682
 683
 684
 685 CREATE TABLE /*$wgDBprefix*/searchindex (
 686
 687   si_page INTEGER ,
 688
 689   si_title varchar(255)  default '',
 690
 691   si_text mediumtext ) ;
 692
 693
 694
 695 CREATE TABLE /*$wgDBprefix*/interwiki (
 696
 697   iw_prefix varchar(32) ,
 698
 699
 700
 701   iw_url blob ,
 702
 703
 704   iw_local bool ,
 705
 706   iw_trans tinyint  default 0) /*$wgDBTableOptions*/;
 707
 708
 709
 710 CREATE TABLE /*$wgDBprefix*/querycache (
 711
 712   qc_type varBLOB ,
 713
 714   qc_value INTEGER  default '0',
 715
 716   qc_namespace INTEGER  default '0',
 717   qc_title varchar(255)   default '') /*$wgDBTableOptions*/;
 718
 719
 720
 721 CREATE TABLE /*$wgDBprefix*/objectcache (
 722   keyname varBLOB  default '',
 723   value mediumblob,
 724   exptime datetime) /*$wgDBTableOptions*/;
 725
 726
 727
 728 CREATE TABLE /*$wgDBprefix*/transcache (
 729   tc_url varBLOB ,
 730   tc_contents text,
 731   tc_time INTEGER ) /*$wgDBTableOptions*/;
 732
 733 CREATE TABLE /*$wgDBprefix*/logging (
 734
 735   log_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 736
 737
 738
 739   log_type varBLOB  default '',
 740   log_action varBLOB  default '',
 741
 742   log_timestamp BLOB  default '19700101000000',
 743
 744   log_user INTEGER  default 0,
 745
 746
 747   log_namespace INTEGER  default 0,
 748   log_title varchar(255)   default '',
 749
 750   log_comment varchar(255)  default '',
 751
 752   log_params blob ,
 753
 754   log_deleted tinyint  default '0') /*$wgDBTableOptions*/;
 755
 756 CREATE TABLE /*$wgDBprefix*/trackbacks (
 757   tb_id INTEGER PRIMARY KEY AUTOINCREMENT,
 758   tb_page INTEGER REFERENCES page(page_id) ON DELETE CASCADE,
 759   tb_title varchar(255) ,
 760   tb_url blob ,
 761   tb_ex text,
 762   tb_name varchar(255)) /*$wgDBTableOptions*/;
 763
 764 CREATE TABLE /*$wgDBprefix*/job (
 765   job_id INTEGER  PRIMARY KEY AUTOINCREMENT,
 766
 767
 768   job_cmd varBLOB  default '',
 769
 770
 771   job_namespace INTEGER ,
 772   job_title varchar(255)  ,
 773
 774
 775   job_params blob ) /*$wgDBTableOptions*/;
 776
 777 CREATE TABLE /*$wgDBprefix*/querycache_info (
 778
 779
 780   qci_type varBLOB  default '',
 781
 782   qci_timestamp BLOB  default '19700101000000') /*$wgDBTableOptions*/;
 783
 784 CREATE TABLE /*$wgDBprefix*/redirect (
 785
 786   rd_from INTEGER  default '0',
 787
 788
 789
 790
 791   rd_namespace INTEGER  default '0',
 792   rd_title varchar(255)   default '') /*$wgDBTableOptions*/;
 793
 794 CREATE TABLE /*$wgDBprefix*/querycachetwo (
 795
 796   qcc_type varBLOB ,
 797
 798   qcc_value INTEGER  default '0',
 799
 800   qcc_namespace INTEGER  default '0',
 801   qcc_title varchar(255)   default '',
 802
 803   qcc_namespacetwo INTEGER  default '0',
 804   qcc_titletwo varchar(255)   default '') /*$wgDBTableOptions*/;
 805
 806 CREATE TABLE /*$wgDBprefix*/page_restrictions (
 807
 808   pr_page INTEGER ,
 809
 810   pr_type varBLOB ,
 811
 812   pr_level varBLOB ,
 813
 814   pr_cascade tinyint ,
 815
 816   pr_user INTEGER NULL,
 817
 818   pr_expiry varBLOB NULL,
 819
 820   pr_id INTEGER  PRIMARY KEY AUTOINCREMENT) /*$wgDBTableOptions*/;
 821
 822 CREATE TABLE /*$wgDBprefix*/protected_titles (
 823   pt_namespace INTEGER ,
 824   pt_title varchar(255)  ,
 825   pt_user INTEGER ,
 826   pt_reason tinyblob,
 827   pt_timestamp BLOB ,
 828   pt_expiry varBLOB  default '',
 829   pt_create_perm varBLOB ) /*$wgDBTableOptions*/;
 830
 831 CREATE TABLE /*$wgDBprefix*/page_props (
 832   pp_page INTEGER ,
 833   pp_propname varBLOB ,
 834   pp_value blob ) /*$wgDBTableOptions*/;
 835
 836 CREATE TABLE /*$wgDBprefix*/updatelog (
 837   ul_key varchar(255) ) /*$wgDBTableOptions*/;
 838