maintenance/mssql/tables.sql

   1 CREATE TABLE /*$wgDBprefix*/user (
   2   user_id int NOT NULL IDENTITY(1,1),
   3   user_name varchar(255) NOT NULL default '',
   4   user_real_name varchar(255) NOT NULL default '',
   5   user_password text NOT NULL,
   6   user_newpassword text NOT NULL,
   7   user_newpass_time varchar(5) NULL,
   8   user_email text NOT NULL,
   9   user_options text NOT NULL,
  10   user_touched varchar(5) NOT NULL default '',
  11   user_token varchar(10) NOT NULL default '',
  12   user_email_authenticated varchar(5) NULL,
  13   user_email_token varchar(10) NULL,
  14   user_email_token_expires varchar(5) NULL,
  15   user_registration varchar(5) NULL,
  16   user_editcount int,
  17   PRIMARY KEY (user_id)
  18 );
  19
  20 CREATE TABLE /*$wgDBprefix*/user_groups (
  21   ug_user int NOT NULL default '0',
  22   ug_group varchar(5) NOT NULL default '',
  23   PRIMARY KEY (ug_user,ug_group)
  24 );
  25
  26 CREATE TABLE /*$wgDBprefix*/user_newtalk (
  27   user_id int NOT NULL default '0',
  28   user_ip varchar(13) NOT NULL default '',
  29   user_last_timestamp varchar(5) NOT NULL default ''
  30 );
  31
  32 CREATE TABLE /*$wgDBprefix*/page (
  33   page_id int NOT NULL IDENTITY(1,1),
  34   page_namespace int NOT NULL,
  35   page_title varchar(255) NOT NULL,
  36   page_restrictions text NOT NULL,
  37   page_counter bigint NOT NULL default '0',
  38   page_is_redirect tinyint NOT NULL default '0',
  39   page_is_new tinyint NOT NULL default '0',
  40   page_random real NOT NULL,
  41   page_touched varchar(5) NOT NULL default '',
  42   page_latest int NOT NULL,
  43   page_len int NOT NULL,
  44   PRIMARY KEY (page_id)
  45 );
  46
  47 CREATE TABLE /*$wgDBprefix*/revision (
  48   rev_id int NOT NULL IDENTITY(1,1),
  49   rev_page int NOT NULL,
  50   rev_text_id int NOT NULL,
  51   rev_comment text NOT NULL,
  52   rev_user int NOT NULL default '0',
  53   rev_user_text varchar(255) NOT NULL default '',
  54   rev_timestamp varchar(5) NOT NULL default '',
  55   rev_minor_edit tinyint NOT NULL default '0',
  56   rev_deleted tinyint NOT NULL default '0',
  57   rev_len int,
  58   rev_parent_id int default NULL,
  59   PRIMARY KEY (rev_page, rev_id)
  60 );
  61
  62 CREATE TABLE /*$wgDBprefix*/text (
  63   old_id int NOT NULL IDENTITY(1,1),
  64   old_text text NOT NULL,
  65   old_flags text NOT NULL,
  66   PRIMARY KEY (old_id)
  67 );
  68
  69 CREATE TABLE /*$wgDBprefix*/archive (
  70   ar_namespace int NOT NULL default '0',
  71   ar_title varchar(255) NOT NULL default '',
  72   ar_text text NOT NULL,
  73   ar_comment text NOT NULL,
  74   ar_user int NOT NULL default '0',
  75   ar_user_text varchar(255) NOT NULL,
  76   ar_timestamp varchar(5) NOT NULL default '',
  77   ar_minor_edit tinyint NOT NULL default '0',
  78   ar_flags text NOT NULL,
  79   ar_rev_id int,
  80   ar_text_id int,
  81   ar_deleted tinyint NOT NULL default '0',
  82   ar_len int,
  83   ar_page_id int,
  84   ar_parent_id int default NULL
  85 );
  86
  87 CREATE TABLE /*$wgDBprefix*/pagelinks (
  88   pl_from int NOT NULL default '0',
  89   pl_namespace int NOT NULL default '0',
  90   pl_title varchar(255) NOT NULL default ''
  91 );
  92
  93 CREATE TABLE /*$wgDBprefix*/templatelinks (
  94   tl_from int NOT NULL default '0',
  95   tl_namespace int NOT NULL default '0',
  96   tl_title varchar(255) NOT NULL default ''
  97 );
  98
  99 CREATE TABLE /*$wgDBprefix*/imagelinks (
 100   il_from int NOT NULL default '0',
 101   il_to varchar(255) NOT NULL default ''
 102 );
 103
 104 CREATE TABLE /*$wgDBprefix*/categorylinks (
 105   cl_from int NOT NULL default '0',
 106   cl_to varchar(255) NOT NULL default '',
 107   cl_sortkey varchar(70) NOT NULL default '',
 108   cl_timestamp timestamp NOT NULL
 109 );
 110
 111 CREATE TABLE /*$wgDBprefix*/category (
 112   cat_id int NOT NULL IDENTITY(1,1),
 113   cat_title varchar(255) NOT NULL,
 114   cat_pages int NOT NULL default 0,
 115   cat_subcats int NOT NULL default 0,
 116   cat_files int NOT NULL default 0,
 117   cat_hidden tinyint NOT NULL default 0,
 118   PRIMARY KEY (cat_id)
 119 );
 120
 121 CREATE TABLE /*$wgDBprefix*/externallinks (
 122   el_from int NOT NULL default '0',
 123   el_to text NOT NULL,
 124   el_index text NOT NULL
 125 );
 126
 127 CREATE TABLE /*$wgDBprefix*/langlinks (
 128   ll_from int NOT NULL default '0',
 129   ll_lang varchar(7) NOT NULL default '',
 130   ll_title varchar(255) NOT NULL default ''
 131 );
 132
 133 CREATE TABLE /*$wgDBprefix*/site_stats (
 134   ss_row_id int NOT NULL,
 135   ss_total_views bigint default '0',
 136   ss_total_edits bigint default '0',
 137   ss_good_articles bigint default '0',
 138   ss_total_pages bigint default '-1',
 139   ss_users bigint default '-1',
 140   ss_admins int default '-1',
 141   ss_images int default '0'
 142 );
 143
 144 CREATE TABLE /*$wgDBprefix*/hitcounter (
 145   hc_id int NOT NULL
 146 );
 147
 148 CREATE TABLE /*$wgDBprefix*/ipblocks (
 149   ipb_id int NOT NULL IDENTITY(1,1),
 150   ipb_address text NOT NULL,
 151   ipb_user int NOT NULL default '0',
 152   ipb_by int NOT NULL default '0',
 153   ipb_by_text varchar(255) NOT NULL default '',
 154   ipb_reason text NOT NULL,
 155   ipb_timestamp varchar(5) NOT NULL default '',
 156   ipb_auto bit NOT NULL default 0,
 157   ipb_anon_only bit NOT NULL default 0,
 158   ipb_create_account bit NOT NULL default 1,
 159   ipb_enable_autoblock bit NOT NULL default '1',
 160   ipb_expiry varchar(5) NOT NULL default '',
 161   ipb_range_start text NOT NULL,
 162   ipb_range_end text NOT NULL,
 163   ipb_deleted bit NOT NULL default 0,
 164   ipb_block_email bit NOT NULL default 0,
 165   PRIMARY KEY (ipb_id)
 166 );
 167
 168 CREATE TABLE /*$wgDBprefix*/image (
 169   img_name varchar(255) NOT NULL default '',
 170   img_size int NOT NULL default '0',
 171   img_width int NOT NULL default '0',
 172   img_height int NOT NULL default '0',
 173   img_metadata text NOT NULL,
 174   img_bits int NOT NULL default '0',
 175   img_media_type TEXT default NULL,
 176   img_major_mime TEXT NOT NULL default "unknown",
 177   img_minor_mime varchar(10) NOT NULL default "unknown",
 178   img_description text NOT NULL,
 179   img_user int NOT NULL default '0',
 180   img_user_text varchar(255) NOT NULL,
 181   img_timestamp varchar(5) NOT NULL default '',
 182   img_sha1 varchar(10) NOT NULL default '',
 183   PRIMARY KEY (img_name)
 184 );
 185
 186 CREATE TABLE /*$wgDBprefix*/oldimage (
 187   oi_name varchar(255) NOT NULL default '',
 188   oi_archive_name varchar(255) NOT NULL default '',
 189   oi_size int NOT NULL default 0,
 190   oi_width int NOT NULL default 0,
 191   oi_height int NOT NULL default 0,
 192   oi_bits int NOT NULL default 0,
 193   oi_description text NOT NULL,
 194   oi_user int NOT NULL default '0',
 195   oi_user_text varchar(255) NOT NULL,
 196   oi_timestamp varchar(5) NOT NULL default '',
 197   oi_metadata text NOT NULL,
 198   oi_media_type TEXT default NULL,
 199   oi_major_mime TEXT NOT NULL default "unknown",
 200   oi_minor_mime varchar(10) NOT NULL default "unknown",
 201   oi_deleted tinyint NOT NULL default '0',
 202   oi_sha1 varchar(10) NOT NULL default ''
 203 );
 204
 205 CREATE TABLE /*$wgDBprefix*/filearchive (
 206   fa_id int NOT NULL IDENTITY(1,1),
 207   fa_name varchar(255) NOT NULL default '',
 208   fa_archive_name varchar(255) NULL default '',
 209   fa_storage_group varchar(5) NULL,
 210   fa_storage_key varchar(17) NULL default '',
 211   fa_deleted_user int,
 212   fa_deleted_timestamp varchar(5) NULL default '',
 213   fa_deleted_reason text,
 214   fa_size int default '0',
 215   fa_width int default '0',
 216   fa_height int default '0',
 217   fa_metadata text,
 218   fa_bits int default '0',
 219   fa_media_type TEXT default NULL,
 220   fa_major_mime TEXT default "unknown",
 221   fa_minor_mime varchar(10) NULL default "unknown",
 222   fa_description text,
 223   fa_user int default '0',
 224   fa_user_text varchar(255) NULL,
 225   fa_timestamp varchar(5) NULL default '',
 226   fa_deleted tinyint NOT NULL default '0',
 227   PRIMARY KEY (fa_id)
 228 );
 229
 230 CREATE TABLE /*$wgDBprefix*/recentchanges (
 231   rc_id int NOT NULL IDENTITY(1,1),
 232   rc_timestamp varchar(5) NOT NULL default '',
 233   rc_cur_time varchar(5) NOT NULL default '',
 234   rc_user int NOT NULL default '0',
 235   rc_user_text varchar(255) NOT NULL,
 236   rc_namespace int NOT NULL default '0',
 237   rc_title varchar(255) NOT NULL default '',
 238   rc_comment varchar(255) NOT NULL default '',
 239   rc_minor tinyint NOT NULL default '0',
 240   rc_bot tinyint NOT NULL default '0',
 241   rc_new tinyint NOT NULL default '0',
 242   rc_cur_id int NOT NULL default '0',
 243   rc_this_oldid int NOT NULL default '0',
 244   rc_last_oldid int NOT NULL default '0',
 245   rc_type tinyint NOT NULL default '0',
 246   rc_moved_to_ns tinyint NOT NULL default '0',
 247   rc_moved_to_title varchar(255) NOT NULL default '',
 248   rc_patrolled tinyint NOT NULL default '0',
 249   rc_ip varchar(13) NOT NULL default '',
 250   rc_old_len int,
 251   rc_new_len int,
 252   rc_deleted tinyint NOT NULL default '0',
 253   rc_logid int NOT NULL default '0',
 254   rc_log_type varchar(17) NULL default NULL,
 255   rc_log_action varchar(17) NULL default NULL,
 256   rc_params text NULL,
 257   PRIMARY KEY (rc_id)
 258 );
 259
 260 CREATE TABLE /*$wgDBprefix*/watchlist (
 261   wl_user int NOT NULL,
 262   wl_namespace int NOT NULL default '0',
 263   wl_title varchar(255) NOT NULL default '',
 264   wl_notificationtimestamp varchar(5) NULL
 265 );
 266
 267 CREATE TABLE /*$wgDBprefix*/math (
 268   math_inputhash varchar(5) NOT NULL,
 269   math_outputhash varchar(5) NOT NULL,
 270   math_html_conservativeness tinyint NOT NULL,
 271   math_html text,
 272   math_mathml text
 273 );
 274
 275 CREATE TABLE /*$wgDBprefix*/searchindex (
 276   si_page int NOT NULL,
 277   si_title varchar(255) NOT NULL default '',
 278   si_text text NOT NULL
 279 );
 280
 281 CREATE TABLE /*$wgDBprefix*/interwiki (
 282   iw_prefix varchar(32) NOT NULL,
 283   iw_url text NOT NULL,
 284   iw_local bit NOT NULL,
 285   iw_trans tinyint NOT NULL default 0
 286 );
 287
 288 CREATE TABLE /*$wgDBprefix*/querycache (
 289   qc_type varchar(10) NOT NULL,
 290   qc_value int NOT NULL default '0',
 291   qc_namespace int NOT NULL default '0',
 292   qc_title varchar(255) NOT NULL default ''
 293 );
 294
 295 CREATE TABLE /*$wgDBprefix*/objectcache (
 296   keyname varchar(17) NOT NULL default '',
 297   value text,
 298   exptime datetime
 299 );
 300
 301 CREATE TABLE /*$wgDBprefix*/transcache (
 302   tc_url varchar(17) NOT NULL,
 303   tc_contents text,
 304   tc_time int NOT NULL
 305 );
 306
 307 CREATE TABLE /*$wgDBprefix*/logging (
 308   log_id int NOT NULL IDENTITY(1,1),
 309   log_type varchar(4) NOT NULL default '',
 310   log_action varchar(4) NOT NULL default '',
 311   log_timestamp varchar(5) NOT NULL default '19700101000000',
 312   log_user int NOT NULL default 0,
 313   log_namespace int NOT NULL default 0,
 314   log_title varchar(255) NOT NULL default '',
 315   log_comment varchar(255) NOT NULL default '',
 316   log_params text NOT NULL,
 317   log_deleted tinyint NOT NULL default '0',
 318   PRIMARY KEY (log_id)
 319 );
 320
 321 CREATE TABLE /*$wgDBprefix*/trackbacks (
 322   tb_id int IDENTITY(1,1),
 323   tb_page int REFERENCES /*$wgDBprefix*/page(page_id) ON DELETE CASCADE,
 324   tb_title varchar(255) NOT NULL,
 325   tb_url text NOT NULL,
 326   tb_ex text,
 327   tb_name varchar(255) NULL,
 328   PRIMARY KEY (tb_id)
 329 );
 330
 331 CREATE TABLE /*$wgDBprefix*/job (
 332   job_id int NOT NULL IDENTITY(1,1),
 333   job_cmd varchar(17) NOT NULL default '',
 334   job_namespace int NOT NULL,
 335   job_title varchar(255) NOT NULL,
 336   job_params text NOT NULL,
 337   PRIMARY KEY (job_id)
 338 );
 339
 340 CREATE TABLE /*$wgDBprefix*/querycache_info (
 341   qci_type varchar(10) NOT NULL default '',
 342   qci_timestamp varchar(5) NOT NULL default '19700101000000'
 343 );
 344
 345 CREATE TABLE /*$wgDBprefix*/redirect (
 346   rd_from int NOT NULL default '0',
 347   rd_namespace int NOT NULL default '0',
 348   rd_title varchar(255) NOT NULL default '',
 349   PRIMARY KEY (rd_from)
 350 );
 351
 352 CREATE TABLE /*$wgDBprefix*/querycachetwo (
 353   qcc_type varchar(10) NOT NULL,
 354   qcc_value int NOT NULL default '0',
 355   qcc_namespace int NOT NULL default '0',
 356   qcc_title varchar(255) NOT NULL default '',
 357   qcc_namespacetwo int NOT NULL default '0',
 358   qcc_titletwo varchar(255) NOT NULL default ''
 359 );
 360
 361 CREATE TABLE /*$wgDBprefix*/page_restrictions (
 362   pr_page int NOT NULL,
 363   pr_type varchar(17) NOT NULL,
 364   pr_level varchar(17) NOT NULL,
 365   pr_cascade tinyint NOT NULL,
 366   pr_user int NULL,
 367   pr_expiry varchar(5) NULL,
 368   pr_id int NOT NULL IDENTITY(1,1),
 369   PRIMARY KEY (pr_page,pr_type)
 370 );
 371
 372 CREATE TABLE /*$wgDBprefix*/protected_titles (
 373   pt_namespace int NOT NULL,
 374   pt_title varchar(255) NOT NULL,
 375   pt_user int NOT NULL,
 376   pt_reason text,
 377   pt_timestamp varchar(5) NOT NULL,
 378   pt_expiry varchar(5) NOT NULL default '',
 379   pt_create_perm varchar(17) NOT NULL,
 380   PRIMARY KEY (pt_namespace,pt_title)
 381 );
 382
 383 CREATE TABLE /*$wgDBprefix*/page_props (
 384   pp_page int NOT NULL,
 385   pp_propname varchar(17) NOT NULL,
 386   pp_value text NOT NULL,
 387   PRIMARY KEY (pp_page,pp_propname)
 388 );
 389
 390 CREATE TABLE /*$wgDBprefix*/updatelog (
 391   ul_key varchar(255) NOT NULL,
 392   PRIMARY KEY (ul_key)
 393 );
 394
 395