[Summary view] [Print] [Text view]

   1  define mw_prefix='{$wgDBprefix}';
   2  
   3  ALTER TABLE &mw_prefix.archive MODIFY ar_user DEFAULT 0 NOT NULL;
   4  ALTER TABLE &mw_prefix.archive MODIFY ar_deleted CHAR(1);
   5  CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id);
   6  
   7  ALTER TABLE &mw_prefix.page MODIFY page_is_redirect default '0';
   8  ALTER TABLE &mw_prefix.page MODIFY page_is_new default '0';
   9  ALTER TABLE &mw_prefix.page MODIFY page_latest default 0;
  10  ALTER TABLE &mw_prefix.page MODIFY page_len default 0;
  11  
  12  ALTER TABLE &mw_prefix.categorylinks MODIFY cl_sortkey VARCHAR2(230);
  13  ALTER TABLE &mw_prefix.categorylinks ADD cl_sortkey_prefix VARCHAR2(255) DEFAULT '' NOT NULL;
  14  ALTER TABLE &mw_prefix.categorylinks ADD cl_collation VARCHAR2(32) DEFAULT '' NOT NULL;
  15  ALTER TABLE &mw_prefix.categorylinks ADD cl_type VARCHAR2(6) DEFAULT 'page' NOT NULL;
  16  DROP INDEX &mw_prefix.categorylinks_i01;
  17  CREATE INDEX &mw_prefix.categorylinks_i01 ON &mw_prefix.categorylinks (cl_to,cl_type,cl_sortkey,cl_from);
  18  CREATE INDEX &mw_prefix.categorylinks_i03 ON &mw_prefix.categorylinks (cl_collation);
  19  
  20  ALTER TABLE &mw_prefix.filearchive MODIFY fa_deleted_user DEFAULT 0 NOT NULL;
  21  ALTER TABLE &mw_prefix.filearchive MODIFY fa_size DEFAULT 0;
  22  ALTER TABLE &mw_prefix.filearchive MODIFY fa_width DEFAULT 0;
  23  ALTER TABLE &mw_prefix.filearchive MODIFY fa_height DEFAULT 0;
  24  ALTER TABLE &mw_prefix.filearchive MODIFY fa_bits DEFAULT 0 NOT NULL;
  25  ALTER TABLE &mw_prefix.filearchive MODIFY fa_user DEFAULT 0 NOT NULL;
  26  ALTER TABLE &mw_prefix.filearchive MODIFY fa_deleted DEFAULT 0;
  27  
  28  ALTER TABLE &mw_prefix.image MODIFY img_size DEFAULT 0;
  29  ALTER TABLE &mw_prefix.image MODIFY img_width DEFAULT 0;
  30  ALTER TABLE &mw_prefix.image MODIFY img_height DEFAULT 0;
  31  ALTER TABLE &mw_prefix.image MODIFY img_bits DEFAULT 0 NOT NULL;
  32  ALTER TABLE &mw_prefix.image MODIFY img_user DEFAULT 0 NOT NULL;
  33  
  34  ALTER TABLE &mw_prefix.interwiki ADD iw_api BLOB DEFAULT EMPTY_BLOB();
  35  ALTER TABLE &mw_prefix.interwiki MODIFY iw_api DEFAULT NULL NOT NULL;
  36  ALTER TABLE &mw_prefix.interwiki ADD iw_wikiid VARCHAR2(64);
  37  
  38  ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_user DEFAULT 0 NOT NULL;
  39  ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_by DEFAULT 0;
  40  
  41  CREATE TABLE &mw_prefix.iwlinks (
  42    iwl_from NUMBER DEFAULT 0 NOT NULL,
  43    iwl_prefix VARCHAR2(20) DEFAULT '' NOT NULL,
  44    iwl_title VARCHAR2(255) DEFAULT '' NOT NULL
  45  );
  46  CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui01 ON &mw_prefix.iwlinks (iwl_from, iwl_prefix, iwl_title);
  47  CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui02 ON &mw_prefix.iwlinks (iwl_prefix, iwl_title, iwl_from);
  48  
  49  ALTER TABLE &mw_prefix.logging MODIFY log_user DEFAULT 0 NOT NULL;
  50  ALTER TABLE &mw_prefix.logging MODIFY log_deleted CHAR(1);
  51  
  52  CREATE TABLE &mw_prefix.module_deps (
  53    md_module VARCHAR2(255) NOT NULL,
  54    md_skin VARCHAR2(32) NOT NULL,
  55    md_deps BLOB NOT NULL
  56  );
  57  CREATE UNIQUE INDEX &mw_prefix.module_deps_u01 ON &mw_prefix.module_deps (md_module, md_skin);
  58  
  59  CREATE TABLE &mw_prefix.msg_resource_links (
  60    mrl_resource VARCHAR2(255) NOT NULL,
  61    mrl_message VARCHAR2(255) NOT NULL
  62  );
  63  CREATE UNIQUE INDEX &mw_prefix.msg_resource_links_u01 ON &mw_prefix.msg_resource_links (mrl_message, mrl_resource);
  64  
  65  CREATE TABLE &mw_prefix.msg_resource (
  66    mr_resource VARCHAR2(255) NOT NULL,
  67    mr_lang varchar2(32) NOT NULL,
  68    mr_blob BLOB NOT NULL,
  69    mr_timestamp TIMESTAMP(6) WITH TIME ZONE NOT NULL
  70  );
  71  CREATE UNIQUE INDEX &mw_prefix.msg_resource_u01 ON &mw_prefix.msg_resource (mr_resource, mr_lang);
  72  
  73  ALTER TABLE &mw_prefix.oldimage MODIFY oi_name DEFAULT 0;
  74  ALTER TABLE &mw_prefix.oldimage MODIFY oi_size DEFAULT 0;
  75  ALTER TABLE &mw_prefix.oldimage MODIFY oi_width DEFAULT 0;
  76  ALTER TABLE &mw_prefix.oldimage MODIFY oi_height DEFAULT 0;
  77  ALTER TABLE &mw_prefix.oldimage MODIFY oi_bits DEFAULT 0;
  78  ALTER TABLE &mw_prefix.oldimage MODIFY oi_user DEFAULT 0 NOT NULL;
  79  
  80  ALTER TABLE &mw_prefix.querycache MODIFY qc_value DEFAULT 0;
  81  
  82  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_user DEFAULT 0 NOT NULL;
  83  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_cur_id DEFAULT 0 NOT NULL;
  84  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_this_oldid DEFAULT 0;
  85  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_last_oldid DEFAULT 0;
  86  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_moved_to_ns DEFAULT 0 NOT NULL;
  87  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_deleted CHAR(1);
  88  ALTER TABLE &mw_prefix.recentchanges MODIFY rc_logid DEFAULT 0;
  89  
  90  ALTER TABLE &mw_prefix.revision MODIFY rev_page NOT NULL;
  91  ALTER TABLE &mw_prefix.revision MODIFY rev_user DEFAULT 0;
  92  
  93  ALTER TABLE &mw_prefix.updatelog ADD ul_value BLOB;
  94  
  95  ALTER TABLE &mw_prefix.user_groups MODIFY ug_user DEFAULT 0 NOT NULL;
  96  
  97  ALTER TABLE &mw_prefix.user_newtalk MODIFY user_id DEFAULT 0;
  98