UNIQUE INDEX user_name (user_name),
INDEX (user_email_token)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- User permissions have been broken out to a separate table;
PRIMARY KEY (ug_user,ug_group),
KEY (ug_group)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
-- Stores notifications of user talk page changes, for the display
-- of the "you have new messages" box
INDEX (page_random),
INDEX (page_len)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Every edit of a page creates also a revision row.
INDEX user_timestamp (rev_user,rev_timestamp),
INDEX usertext_timestamp (rev_user_text,rev_timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
PRIMARY KEY old_id (old_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Holding area for deleted articles, which may be viewed
KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
UNIQUE KEY pl_from(pl_from,pl_namespace,pl_title),
KEY (pl_namespace,pl_title)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
UNIQUE KEY tl_from(tl_from,tl_namespace,tl_title),
KEY (tl_namespace,tl_title)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Track links to images *used inline*
UNIQUE KEY il_from(il_from,il_to),
KEY (il_to)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Track category inclusions *used inline*
-- Not really used?
KEY cl_timestamp(cl_to,cl_timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Track links to external URLs
KEY (el_from, el_to(40)),
KEY (el_to(60), el_from),
KEY (el_index(60))
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Contains a single row with some aggregate info
UNIQUE KEY ss_row_id (ss_row_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Stores an ID for every time any article is visited;
--
CREATE TABLE /*$wgDBprefix*/hitcounter (
hc_id INTEGER UNSIGNED NOT NULL
-) TYPE=HEAP MAX_ROWS=25000;
+) ENGINE=HEAP MAX_ROWS=25000;
--
INDEX ipb_user (ipb_user),
INDEX ipb_range (ipb_range_start(8), ipb_range_end(8))
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Used by Special:Newimages and Special:Imagelist
INDEX img_timestamp (img_timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Previous revisions of uploaded files.
INDEX oi_name (oi_name(10))
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
INDEX new_name_timestamp(rc_new,rc_namespace,rc_timestamp),
INDEX rc_ip (rc_ip)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
CREATE TABLE /*$wgDBprefix*/watchlist (
-- Key to user.user_id
UNIQUE KEY (wl_user, wl_namespace, wl_title),
KEY namespace_title (wl_namespace,wl_title)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
UNIQUE KEY math_inputhash (math_inputhash)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- When using the default MySQL search backend, page titles
FULLTEXT si_title (si_title),
FULLTEXT si_text (si_text)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Recognized interwiki link prefixes
UNIQUE KEY iw_prefix (iw_prefix)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Used for caching expensive grouped queries
KEY (qc_type,qc_value)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- For a few generic cache operations if not using Memcached
unique key (keyname),
key (exptime)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
--
-- Cache of interwiki transclusion
tc_contents TEXT,
tc_time INT NOT NULL,
UNIQUE INDEX tc_url_idx(tc_url)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
-- For article validation
CREATE TABLE /*$wgDBprefix*/validate (
val_comment varchar(255) NOT NULL default '',
val_ip varchar(20) NOT NULL default '',
KEY val_user (val_user,val_revision)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
CREATE TABLE /*$wgDBprefix*/logging (
KEY page_time (log_namespace, log_title, log_timestamp),
KEY times (log_timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
CREATE TABLE /*$wgDBprefix*/trackbacks (
tb_id integer AUTO_INCREMENT PRIMARY KEY,
tb_name varchar(255),
INDEX (tb_page)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
-- Jobs performed by parallel apache threads or a command-line daemon
PRIMARY KEY job_id (job_id),
KEY (job_cmd, job_namespace, job_title)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;