From b856b889e39f8cda2372688f74781f0ac80c4af8 Mon Sep 17 00:00:00 2001
From: Aran Dunkley <nad@users.mediawiki.org>
Date: Sat, 10 May 2008 07:16:13 +0000
Subject: [PATCH] Functional but no indexes yet

---
 maintenance/mssql/tables.sql | 395 +++++++++++++++++++++++++++++++++++
 1 file changed, 395 insertions(+)
 create mode 100644 maintenance/mssql/tables.sql

diff --git a/maintenance/mssql/tables.sql b/maintenance/mssql/tables.sql
new file mode 100644
index 0000000000..b662ab9efe
--- /dev/null
+++ b/maintenance/mssql/tables.sql
@@ -0,0 +1,395 @@
+CREATE TABLE /*$wgDBprefix*/user (
+  user_id int NOT NULL IDENTITY(1,1),
+  user_name varchar(255) NOT NULL default '',
+  user_real_name varchar(255) NOT NULL default '',
+  user_password text NOT NULL,
+  user_newpassword text NOT NULL,
+  user_newpass_time binary(14),
+  user_email text NOT NULL,
+  user_options text NOT NULL,
+  user_touched binary(14) NOT NULL default 0,
+  user_token binary(32) NOT NULL default 0,
+  user_email_authenticated binary(14),
+  user_email_token binary(32),
+  user_email_token_expires binary(14),
+  user_registration binary(14),
+  user_editcount int,
+  PRIMARY KEY (user_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/user_groups (
+  ug_user int NOT NULL default '0',
+  ug_group varbinary(16) NOT NULL default 0,
+  PRIMARY KEY (ug_user,ug_group)
+);
+
+CREATE TABLE /*$wgDBprefix*/user_newtalk (
+  user_id int NOT NULL default '0',
+  user_ip varbinary(40) NOT NULL default 0,
+  user_last_timestamp binary(14) NOT NULL default 0
+);
+
+CREATE TABLE /*$wgDBprefix*/page (
+  page_id int NOT NULL IDENTITY(1,1),
+  page_namespace int NOT NULL,
+  page_title varchar(255) NOT NULL,
+  page_restrictions text NOT NULL,
+  page_counter bigint NOT NULL default '0',
+  page_is_redirect tinyint NOT NULL default '0',
+  page_is_new tinyint NOT NULL default '0',
+  page_random real NOT NULL,
+  page_touched binary(14) NOT NULL default 0,
+  page_latest int NOT NULL,
+  page_len int NOT NULL,
+  PRIMARY KEY (page_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/revision (
+  rev_id int NOT NULL IDENTITY(1,1),
+  rev_page int NOT NULL,
+  rev_text_id int NOT NULL,
+  rev_comment text NOT NULL,
+  rev_user int NOT NULL default '0',
+  rev_user_text varchar(255) NOT NULL default '',
+  rev_timestamp binary(14) NOT NULL default 0,
+  rev_minor_edit tinyint NOT NULL default '0',
+  rev_deleted tinyint NOT NULL default '0',
+  rev_len int,
+  rev_parent_id int default NULL,
+  PRIMARY KEY (rev_page, rev_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/text (
+  old_id int NOT NULL IDENTITY(1,1),
+  old_text text NOT NULL,
+  old_flags text NOT NULL,
+  PRIMARY KEY (old_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/archive (
+  ar_namespace int NOT NULL default '0',
+  ar_title varchar(255) NOT NULL default '',
+  ar_text text NOT NULL,
+  ar_comment text NOT NULL,
+  ar_user int NOT NULL default '0',
+  ar_user_text varchar(255) NOT NULL,
+  ar_timestamp binary(14) NOT NULL default 0,
+  ar_minor_edit tinyint NOT NULL default '0',
+  ar_flags text NOT NULL,
+  ar_rev_id int,
+  ar_text_id int,
+  ar_deleted tinyint NOT NULL default '0',
+  ar_len int,
+  ar_page_id int,
+  ar_parent_id int default NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/pagelinks (
+  pl_from int NOT NULL default '0',
+  pl_namespace int NOT NULL default '0',
+  pl_title varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/templatelinks (
+  tl_from int NOT NULL default '0',
+  tl_namespace int NOT NULL default '0',
+  tl_title varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/imagelinks (
+  il_from int NOT NULL default '0',
+  il_to varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/categorylinks (
+  cl_from int NOT NULL default '0',
+  cl_to varchar(255) NOT NULL default '',
+  cl_sortkey varchar(70) NOT NULL default '',
+  cl_timestamp timestamp NOT NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/category (
+  cat_id int NOT NULL IDENTITY(1,1),
+  cat_title varchar(255) NOT NULL,
+  cat_pages int NOT NULL default 0,
+  cat_subcats int NOT NULL default 0,
+  cat_files int NOT NULL default 0,
+  cat_hidden tinyint NOT NULL default 0,
+  PRIMARY KEY (cat_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/externallinks (
+  el_from int NOT NULL default '0',
+  el_to text NOT NULL,
+  el_index text NOT NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/langlinks (
+  ll_from int NOT NULL default '0',
+  ll_lang varbinary(20) NOT NULL default 0,
+  ll_title varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/site_stats (
+  ss_row_id int NOT NULL,
+  ss_total_views bigint default '0',
+  ss_total_edits bigint default '0',
+  ss_good_articles bigint default '0',
+  ss_total_pages bigint default '-1',
+  ss_users bigint default '-1',
+  ss_admins int default '-1',
+  ss_images int default '0'
+);
+
+CREATE TABLE /*$wgDBprefix*/hitcounter (
+  hc_id int NOT NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/ipblocks (
+  ipb_id int NOT NULL IDENTITY(1,1),
+  ipb_address text NOT NULL,
+  ipb_user int NOT NULL default '0',
+  ipb_by int NOT NULL default '0',
+  ipb_by_text varchar(255) NOT NULL default '',
+  ipb_reason text NOT NULL,
+  ipb_timestamp binary(14) NOT NULL default 0,
+  ipb_auto bit NOT NULL default 0,
+  ipb_anon_only bit NOT NULL default 0,
+  ipb_create_account bit NOT NULL default 1,
+  ipb_enable_autoblock bit NOT NULL default '1',
+  ipb_expiry varbinary(14) NOT NULL default 0,
+  ipb_range_start text NOT NULL,
+  ipb_range_end text NOT NULL,
+  ipb_deleted bit NOT NULL default 0,
+  ipb_block_email bit NOT NULL default 0,
+  PRIMARY KEY (ipb_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/image (
+  img_name varchar(255) NOT NULL default '',
+  img_size int NOT NULL default '0',
+  img_width int NOT NULL default '0',
+  img_height int NOT NULL default '0',
+  img_metadata text NOT NULL,
+  img_bits int NOT NULL default '0',
+  img_media_type TEXT default NULL,
+  img_major_mime TEXT NOT NULL default "unknown",
+  img_minor_mime varbinary(32) NOT NULL default 0,
+  img_description text NOT NULL,
+  img_user int NOT NULL default '0',
+  img_user_text varchar(255) NOT NULL,
+  img_timestamp varbinary(14) NOT NULL default 0,
+  img_sha1 varbinary(32) NOT NULL default 0,
+  PRIMARY KEY (img_name)
+);
+
+CREATE TABLE /*$wgDBprefix*/oldimage (
+  oi_name varchar(255) NOT NULL default '',
+  oi_archive_name varchar(255) NOT NULL default '',
+  oi_size int NOT NULL default 0,
+  oi_width int NOT NULL default 0,
+  oi_height int NOT NULL default 0,
+  oi_bits int NOT NULL default 0,
+  oi_description text NOT NULL,
+  oi_user int NOT NULL default '0',
+  oi_user_text varchar(255) NOT NULL,
+  oi_timestamp binary(14) NOT NULL default 0,
+  oi_metadata text NOT NULL,
+  oi_media_type TEXT default NULL,
+  oi_major_mime TEXT NOT NULL default "unknown",
+  oi_minor_mime varbinary(32) NOT NULL default 0,
+  oi_deleted tinyint NOT NULL default '0',
+  oi_sha1 varbinary(32) NOT NULL default 0
+);
+
+CREATE TABLE /*$wgDBprefix*/filearchive (
+  fa_id int NOT NULL IDENTITY(1,1),
+  fa_name varchar(255) NOT NULL default '',
+  fa_archive_name varchar(255) default '',
+  fa_storage_group varbinary(16),
+  fa_storage_key varbinary(64) default 0,
+  fa_deleted_user int,
+  fa_deleted_timestamp binary(14) default 0,
+  fa_deleted_reason text,
+  fa_size int default '0',
+  fa_width int default '0',
+  fa_height int default '0',
+  fa_metadata text,
+  fa_bits int default '0',
+  fa_media_type TEXT default NULL,
+  fa_major_mime TEXT default "unknown",
+  fa_minor_mime varbinary(32) default 0,
+  fa_description text,
+  fa_user int default '0',
+  fa_user_text varchar(255),
+  fa_timestamp binary(14) default 0,
+  fa_deleted tinyint NOT NULL default '0',
+  PRIMARY KEY (fa_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/recentchanges (
+  rc_id int NOT NULL IDENTITY(1,1),
+  rc_timestamp varbinary(14) NOT NULL default 0,
+  rc_cur_time varbinary(14) NOT NULL default 0,
+  rc_user int NOT NULL default '0',
+  rc_user_text varchar(255) NOT NULL,
+  rc_namespace int NOT NULL default '0',
+  rc_title varchar(255) NOT NULL default '',
+  rc_comment varchar(255) NOT NULL default '',
+  rc_minor tinyint NOT NULL default '0',
+  rc_bot tinyint NOT NULL default '0',
+  rc_new tinyint NOT NULL default '0',
+  rc_cur_id int NOT NULL default '0',
+  rc_this_oldid int NOT NULL default '0',
+  rc_last_oldid int NOT NULL default '0',
+  rc_type tinyint NOT NULL default '0',
+  rc_moved_to_ns tinyint NOT NULL default '0',
+  rc_moved_to_title varchar(255) NOT NULL default '',
+  rc_patrolled tinyint NOT NULL default '0',
+  rc_ip varbinary(40) NOT NULL default 0,
+  rc_old_len int,
+  rc_new_len int,
+  rc_deleted tinyint NOT NULL default '0',
+  rc_logid int NOT NULL default '0',
+  rc_log_type varbinary(255) NULL default NULL,
+  rc_log_action varbinary(255) NULL default NULL,
+  rc_params text NULL,
+  PRIMARY KEY (rc_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/watchlist (
+  wl_user int NOT NULL,
+  wl_namespace int NOT NULL default '0',
+  wl_title varchar(255) NOT NULL default '',
+  wl_notificationtimestamp varbinary(14)
+);
+
+CREATE TABLE /*$wgDBprefix*/math (
+  math_inputhash varbinary(16) NOT NULL,
+  math_outputhash varbinary(16) NOT NULL,
+  math_html_conservativeness tinyint NOT NULL,
+  math_html text,
+  math_mathml text
+);
+
+CREATE TABLE /*$wgDBprefix*/searchindex (
+  si_page int NOT NULL,
+  si_title varchar(255) NOT NULL default '',
+  si_text text NOT NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/interwiki (
+  iw_prefix varchar(32) NOT NULL,
+  iw_url text NOT NULL,
+  iw_local bit NOT NULL,
+  iw_trans tinyint NOT NULL default 0
+);
+
+CREATE TABLE /*$wgDBprefix*/querycache (
+  qc_type varbinary(32) NOT NULL,
+  qc_value int NOT NULL default '0',
+  qc_namespace int NOT NULL default '0',
+  qc_title varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/objectcache (
+  keyname varbinary(255) NOT NULL default 0,
+  value text,
+  exptime datetime
+);
+
+CREATE TABLE /*$wgDBprefix*/transcache (
+  tc_url varbinary(255) NOT NULL,
+  tc_contents text,
+  tc_time int NOT NULL
+);
+
+CREATE TABLE /*$wgDBprefix*/logging (
+  log_id int NOT NULL IDENTITY(1,1),
+  log_type varbinary(10) NOT NULL default 0,
+  log_action varbinary(10) NOT NULL default 0,
+  log_timestamp binary(14) NOT NULL default 0,
+  log_user int NOT NULL default 0,
+  log_namespace int NOT NULL default 0,
+  log_title varchar(255) NOT NULL default '',
+  log_comment varchar(255) NOT NULL default '',
+  log_params text NOT NULL,
+  log_deleted tinyint NOT NULL default '0',
+  PRIMARY KEY (log_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/trackbacks (
+  tb_id int IDENTITY(1,1),
+  tb_page int REFERENCES /*$wgDBprefix*/page(page_id) ON DELETE CASCADE,
+  tb_title varchar(255) NOT NULL,
+  tb_url text NOT NULL,
+  tb_ex text,
+  tb_name varchar(255),
+  PRIMARY KEY (tb_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/job (
+  job_id int NOT NULL IDENTITY(1,1),
+  job_cmd varbinary(60) NOT NULL default 0,
+  job_namespace int NOT NULL,
+  job_title varchar(255) NOT NULL,
+  job_params text NOT NULL,
+  PRIMARY KEY (job_id)
+);
+
+CREATE TABLE /*$wgDBprefix*/querycache_info (
+  qci_type varbinary(32) NOT NULL default 0,
+  qci_timestamp binary(14) NOT NULL default 0
+);
+
+CREATE TABLE /*$wgDBprefix*/redirect (
+  rd_from int NOT NULL default '0',
+  rd_namespace int NOT NULL default '0',
+  rd_title varchar(255) NOT NULL default '',
+  PRIMARY KEY (rd_from)
+);
+
+CREATE TABLE /*$wgDBprefix*/querycachetwo (
+  qcc_type varbinary(32) NOT NULL,
+  qcc_value int NOT NULL default '0',
+  qcc_namespace int NOT NULL default '0',
+  qcc_title varchar(255) NOT NULL default '',
+  qcc_namespacetwo int NOT NULL default '0',
+  qcc_titletwo varchar(255) NOT NULL default ''
+);
+
+CREATE TABLE /*$wgDBprefix*/page_restrictions (
+  pr_page int NOT NULL,
+  pr_type varbinary(60) NOT NULL,
+  pr_level varbinary(60) NOT NULL,
+  pr_cascade tinyint NOT NULL,
+  pr_user int NULL,
+  pr_expiry varbinary(14) NULL,
+  pr_id int NOT NULL IDENTITY(1,1),
+  PRIMARY KEY (pr_page,pr_type)
+);
+
+CREATE TABLE /*$wgDBprefix*/protected_titles (
+  pt_namespace int NOT NULL,
+  pt_title varchar(255) NOT NULL,
+  pt_user int NOT NULL,
+  pt_reason text,
+  pt_timestamp binary(14) NOT NULL,
+  pt_expiry varbinary(14) NOT NULL default 0,
+  pt_create_perm varbinary(60) NOT NULL,
+  PRIMARY KEY (pt_namespace,pt_title)
+);
+
+CREATE TABLE /*$wgDBprefix*/page_props (
+  pp_page int NOT NULL,
+  pp_propname varbinary(60) NOT NULL,
+  pp_value text NOT NULL,
+  PRIMARY KEY (pp_page,pp_propname)
+);
+
+CREATE TABLE /*$wgDBprefix*/updatelog (
+  ul_key varchar(255) NOT NULL,
+  PRIMARY KEY (ul_key)
+);
+
+
-- 
2.20.1