SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]actor`
CREATE TABLE `[[dbprefix]]actor` (
`actor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`actor_user` int(10) unsigned DEFAULT NULL,
`actor_name` varbinary(255) NOT NULL,
PRIMARY KEY (`actor_id`),
UNIQUE KEY `actor_name` (`actor_name`),
UNIQUE KEY `actor_user` (`actor_user`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]archive`
CREATE TABLE `[[dbprefix]]archive` (
`ar_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ar_namespace` int(11) NOT NULL DEFAULT '0',
`ar_title` varbinary(255) NOT NULL DEFAULT '',
`ar_comment` varbinary(767) NOT NULL DEFAULT '',
`ar_comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`ar_user` int(10) unsigned NOT NULL DEFAULT '0',
`ar_user_text` varbinary(255) NOT NULL DEFAULT '',
`ar_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`ar_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ar_minor_edit` tinyint(4) NOT NULL DEFAULT '0',
`ar_rev_id` int(10) unsigned NOT NULL,
`ar_text_id` int(10) unsigned NOT NULL DEFAULT '0',
`ar_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ar_len` int(10) unsigned DEFAULT NULL,
`ar_page_id` int(10) unsigned DEFAULT NULL,
`ar_parent_id` int(10) unsigned DEFAULT NULL,
`ar_sha1` varbinary(32) NOT NULL DEFAULT '',
`ar_content_model` varbinary(32) DEFAULT NULL,
`ar_content_format` varbinary(64) DEFAULT NULL,
KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
KEY `ar_usertext_timestamp` (`ar_user_text`,`ar_timestamp`),
KEY `ar_actor_timestamp` (`ar_actor`,`ar_timestamp`),
KEY `ar_revid` (`ar_rev_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]bot_passwords`
CREATE TABLE `[[dbprefix]]bot_passwords` (
`bp_user` int(10) unsigned NOT NULL,
`bp_app_id` varbinary(32) NOT NULL,
`bp_password` tinyblob NOT NULL,
`bp_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`bp_restrictions` blob NOT NULL,
`bp_grants` blob NOT NULL,
PRIMARY KEY (`bp_user`,`bp_app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]category`
CREATE TABLE `[[dbprefix]]category` (
`cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cat_title` varbinary(255) NOT NULL,
`cat_pages` int(11) NOT NULL DEFAULT '0',
`cat_subcats` int(11) NOT NULL DEFAULT '0',
`cat_files` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `cat_title` (`cat_title`),
KEY `cat_pages` (`cat_pages`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]categorylinks`
CREATE TABLE `[[dbprefix]]categorylinks` (
`cl_from` int(10) unsigned NOT NULL DEFAULT '0',
`cl_to` varbinary(255) NOT NULL DEFAULT '',
`cl_sortkey` varbinary(230) NOT NULL DEFAULT '',
`cl_sortkey_prefix` varbinary(255) NOT NULL DEFAULT '',
`cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cl_collation` varbinary(32) NOT NULL DEFAULT '',
`cl_type` enum('page','subcat','file') NOT NULL DEFAULT 'page',
PRIMARY KEY (`cl_from`,`cl_to`),
KEY `cl_sortkey` (`cl_to`,`cl_type`,`cl_sortkey`,`cl_from`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_collation_ext` (`cl_collation`,`cl_to`,`cl_type`,`cl_from`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]change_tag`
CREATE TABLE `[[dbprefix]]change_tag` (
`ct_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ct_rc_id` int(11) DEFAULT NULL,
`ct_log_id` int(10) unsigned DEFAULT NULL,
`ct_rev_id` int(10) unsigned DEFAULT NULL,
`ct_tag` varbinary(255) NOT NULL,
UNIQUE KEY `change_tag_rc_tag` (`ct_rc_id`,`ct_tag`),
UNIQUE KEY `change_tag_log_tag` (`ct_log_id`,`ct_tag`),
UNIQUE KEY `change_tag_rev_tag` (`ct_rev_id`,`ct_tag`),
KEY `change_tag_tag_id` (`ct_tag`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]comment`
CREATE TABLE `[[dbprefix]]comment` (
`comment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_hash` int(11) NOT NULL,
`comment_text` blob NOT NULL,
PRIMARY KEY (`comment_id`),
KEY `comment_hash` (`comment_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content`
CREATE TABLE `[[dbprefix]]content` (
`content_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`content_size` int(10) unsigned NOT NULL,
`content_sha1` varbinary(32) NOT NULL,
`content_model` smallint(5) unsigned NOT NULL,
`content_address` varbinary(255) NOT NULL,
PRIMARY KEY (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content_models`
CREATE TABLE `[[dbprefix]]content_models` (
`model_id` smallint(6) NOT NULL AUTO_INCREMENT,
`model_name` varbinary(64) NOT NULL,
PRIMARY KEY (`model_id`),
UNIQUE KEY `model_name` (`model_name`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]externallinks`
CREATE TABLE `[[dbprefix]]externallinks` (
`el_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`el_from` int(10) unsigned NOT NULL DEFAULT '0',
`el_index` blob NOT NULL,
`el_index_60` varbinary(60) NOT NULL DEFAULT '',
KEY `el_from` (`el_from`,`el_to`(40)),
KEY `el_to` (`el_to`(60),`el_from`),
KEY `el_index` (`el_index`(60)),
KEY `el_index_60` (`el_index_60`,`el_id`),
KEY `el_from_index_60` (`el_from`,`el_index_60`,`el_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]filearchive`
CREATE TABLE `[[dbprefix]]filearchive` (
`fa_id` int(11) NOT NULL AUTO_INCREMENT,
`fa_name` varbinary(255) NOT NULL DEFAULT '',
`fa_archive_name` varbinary(255) DEFAULT '',
`fa_storage_group` varbinary(16) DEFAULT NULL,
`fa_storage_key` varbinary(64) DEFAULT '',
`fa_deleted_user` int(11) DEFAULT NULL,
`fa_deleted_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted_reason` varbinary(767) DEFAULT '',
`fa_deleted_reason_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`fa_size` int(10) unsigned DEFAULT '0',
`fa_width` int(11) DEFAULT '0',
`fa_height` int(11) DEFAULT '0',
`fa_metadata` mediumblob,
`fa_bits` int(11) DEFAULT '0',
`fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') DEFAULT NULL,
`fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') DEFAULT 'unknown',
`fa_minor_mime` varbinary(100) DEFAULT 'unknown',
`fa_description` varbinary(767) DEFAULT '',
`fa_description_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`fa_user` int(10) unsigned DEFAULT '0',
`fa_user_text` varbinary(255) DEFAULT '',
`fa_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`fa_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
`fa_sha1` varbinary(32) NOT NULL DEFAULT '',
KEY `fa_name` (`fa_name`,`fa_timestamp`),
KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`),
KEY `fa_actor_timestamp` (`fa_actor`,`fa_timestamp`),
KEY `fa_sha1` (`fa_sha1`(10))
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]image`
CREATE TABLE `[[dbprefix]]image` (
`img_name` varbinary(255) NOT NULL DEFAULT '',
`img_size` int(10) unsigned NOT NULL DEFAULT '0',
`img_width` int(11) NOT NULL DEFAULT '0',
`img_height` int(11) NOT NULL DEFAULT '0',
`img_metadata` mediumblob NOT NULL,
`img_bits` int(11) NOT NULL DEFAULT '0',
`img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') DEFAULT NULL,
`img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') NOT NULL DEFAULT 'unknown',
`img_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
`img_description` varbinary(767) NOT NULL DEFAULT '',
`img_description_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`img_user` int(10) unsigned NOT NULL DEFAULT '0',
`img_user_text` varbinary(255) NOT NULL DEFAULT '',
`img_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`img_timestamp` varbinary(14) NOT NULL DEFAULT '',
`img_sha1` varbinary(32) NOT NULL DEFAULT '',
PRIMARY KEY (`img_name`),
KEY `img_user_timestamp` (`img_user`,`img_timestamp`),
KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_actor_timestamp` (`img_actor`,`img_timestamp`),
KEY `img_size` (`img_size`),
KEY `img_timestamp` (`img_timestamp`),
KEY `img_sha1` (`img_sha1`(10)),
KEY `img_media_mime` (`img_media_type`,`img_major_mime`,`img_minor_mime`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]imagelinks`
CREATE TABLE `[[dbprefix]]imagelinks` (
`il_from` int(10) unsigned NOT NULL DEFAULT '0',
`il_from_namespace` int(11) NOT NULL DEFAULT '0',
`il_to` varbinary(255) NOT NULL DEFAULT '',
PRIMARY KEY (`il_from`,`il_to`),
KEY `il_to` (`il_to`,`il_from`),
KEY `il_backlinks_namespace` (`il_from_namespace`,`il_to`,`il_from`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]image_comment_temp`
CREATE TABLE `[[dbprefix]]image_comment_temp` (
`imgcomment_name` varbinary(255) NOT NULL,
`imgcomment_description_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`imgcomment_name`,`imgcomment_description_id`),
UNIQUE KEY `imgcomment_name` (`imgcomment_name`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]interwiki`
CREATE TABLE `[[dbprefix]]interwiki` (
`iw_prefix` varbinary(32) NOT NULL,
`iw_wikiid` varbinary(64) NOT NULL,
`iw_local` tinyint(1) NOT NULL,
`iw_trans` tinyint(4) NOT NULL DEFAULT '0',
UNIQUE KEY `iw_prefix` (`iw_prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- Dumping data for table `[[dbprefix]]interwiki`
INSERT INTO `[[dbprefix]]interwiki` VALUES
('acronym', 'https://www.acronymfinder.com/~/search/af.aspx?string=exact&Acronym=$1', '', '', 0, 0),
('advogato', 'http://www.advogato.org/$1', '', '', 0, 0),
('arxiv', 'https://www.arxiv.org/abs/$1', '', '', 0, 0),
('c2find', 'http://c2.com/cgi/wiki?FindPage&value=$1', '', '', 0, 0),
('cache', 'https://www.google.com/search?q=cache:$1', '', '', 0, 0),
('commons', 'https://commons.wikimedia.org/wiki/$1', 'https://commons.wikimedia.org/w/api.php', '', 0, 0),
('dictionary', 'http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1', '', '', 0, 0),
('doi', 'https://dx.doi.org/$1', '', '', 0, 0),
('drumcorpswiki', 'http://www.drumcorpswiki.com/$1', 'http://drumcorpswiki.com/api.php', '', 0, 0),
('dwjwiki', 'http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1', '', '', 0, 0),
('elibre', 'http://enciclopedia.us.es/index.php/$1', 'http://enciclopedia.us.es/api.php', '', 0, 0),
('emacswiki', 'https://www.emacswiki.org/cgi-bin/wiki.pl?$1', '', '', 0, 0),
('foldoc', 'https://foldoc.org/?$1', '', '', 0, 0),
('foxwiki', 'https://fox.wikis.com/wc.dll?Wiki~$1', '', '', 0, 0),
('freebsdman', 'https://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1', '', '', 0, 0),
('gentoo-wiki', 'http://gentoo-wiki.com/$1', '', '', 0, 0),
('google', 'https://www.google.com/search?q=$1', '', '', 0, 0),
('googlegroups', 'https://groups.google.com/groups?q=$1', '', '', 0, 0),
('hammondwiki', 'http://www.dairiki.org/HammondWiki/$1', '', '', 0, 0),
('hrwiki', 'http://www.hrwiki.org/wiki/$1', 'http://www.hrwiki.org/w/api.php', '', 0, 0),
('imdb', 'http://www.imdb.com/find?q=$1&tt=on', '', '', 0, 0),
('kmwiki', 'https://kmwiki.wikispaces.com/$1', '', '', 0, 0),
('linuxwiki', 'http://linuxwiki.de/$1', '', '', 0, 0),
('lojban', 'https://mw.lojban.org/papri/$1', '', '', 0, 0),
('lqwiki', 'http://wiki.linuxquestions.org/wiki/$1', '', '', 0, 0),
('meatball', 'http://www.usemod.com/cgi-bin/mb.pl?$1', '', '', 0, 0),
('mediawikiwiki', 'https://www.mediawiki.org/wiki/$1', 'https://www.mediawiki.org/w/api.php', '', 0, 0),
('memoryalpha', 'http://en.memory-alpha.org/wiki/$1', 'http://en.memory-alpha.org/api.php', '', 0, 0),
('metawiki', 'http://sunir.org/apps/meta.pl?$1', '', '', 0, 0),
('metawikimedia', 'https://meta.wikimedia.org/wiki/$1', 'https://meta.wikimedia.org/w/api.php', '', 0, 0),
('mozillawiki', 'https://wiki.mozilla.org/$1', 'https://wiki.mozilla.org/api.php', '', 0, 0),
('mw', 'https://www.mediawiki.org/wiki/$1', 'https://www.mediawiki.org/w/api.php', '', 0, 0),
('oeis', 'https://oeis.org/$1', '', '', 0, 0),
('openwiki', 'http://openwiki.com/ow.asp?$1', '', '', 0, 0),
('pmid', 'https://www.ncbi.nlm.nih.gov/pubmed/$1?dopt=Abstract', '', '', 0, 0),
('pythoninfo', 'https://wiki.python.org/moin/$1', '', '', 0, 0),
('rfc', 'https://tools.ietf.org/html/rfc$1', '', '', 0, 0),
('s23wiki', 'http://s23.org/wiki/$1', 'http://s23.org/w/api.php', '', 0, 0),
('seattlewireless', 'http://seattlewireless.net/$1', '', '', 0, 0),
('senseislibrary', 'https://senseis.xmp.net/?$1', '', '', 0, 0),
('shoutwiki', 'http://www.shoutwiki.com/wiki/$1', 'http://www.shoutwiki.com/w/api.php', '', 0, 0),
('squeak', 'http://wiki.squeak.org/squeak/$1', '', '', 0, 0),
('theopedia', 'https://www.theopedia.com/$1', '', '', 0, 0),
('tmbw', 'http://www.tmbw.net/wiki/$1', 'http://tmbw.net/wiki/api.php', '', 0, 0),
('tmnet', 'http://www.technomanifestos.net/?$1', '', '', 0, 0),
('twiki', 'http://twiki.org/cgi-bin/view/$1', '', '', 0, 0),
('uncyclopedia', 'https://en.uncyclopedia.co/wiki/$1', 'https://en.uncyclopedia.co/w/api.php', '', 0, 0),
('unreal', 'https://wiki.beyondunreal.com/$1', 'https://wiki.beyondunreal.com/w/api.php', '', 0, 0),
('usemod', 'http://www.usemod.com/cgi-bin/wiki.pl?$1', '', '', 0, 0),
('wiki', 'http://c2.com/cgi/wiki?$1', '', '', 0, 0),
('wikia', 'http://www.wikia.com/wiki/$1', '', '', 0, 0),
('wikibooks', 'https://en.wikibooks.org/wiki/$1', 'https://en.wikibooks.org/w/api.php', '', 0, 0),
('wikidata', 'https://www.wikidata.org/wiki/$1', 'https://www.wikidata.org/w/api.php', '', 0, 0),
('wikif1', 'http://www.wikif1.org/$1', '', '', 0, 0),
('wikihow', 'https://www.wikihow.com/$1', 'https://www.wikihow.com/api.php', '', 0, 0),
('wikimedia', 'https://wikimediafoundation.org/wiki/$1', 'https://wikimediafoundation.org/w/api.php', '', 0, 0),
('wikinews', 'https://en.wikinews.org/wiki/$1', 'https://en.wikinews.org/w/api.php', '', 0, 0),
('wikinfo', 'http://wikinfo.co/English/index.php/$1', '', '', 0, 0),
('wikipedia', 'https://en.wikipedia.org/wiki/$1', 'https://en.wikipedia.org/w/api.php', '', 0, 0),
('wikiquote', 'https://en.wikiquote.org/wiki/$1', 'https://en.wikiquote.org/w/api.php', '', 0, 0),
('wikisource', 'https://wikisource.org/wiki/$1', 'https://wikisource.org/w/api.php', '', 0, 0),
('wikispecies', 'https://species.wikimedia.org/wiki/$1', 'https://species.wikimedia.org/w/api.php', '', 0, 0),
('wikiversity', 'https://en.wikiversity.org/wiki/$1', 'https://en.wikiversity.org/w/api.php', '', 0, 0),
('wikivoyage', 'https://en.wikivoyage.org/wiki/$1', 'https://en.wikivoyage.org/w/api.php', '', 0, 0),
('wikt', 'https://en.wiktionary.org/wiki/$1', 'https://en.wiktionary.org/w/api.php', '', 0, 0),
('wiktionary', 'https://en.wiktionary.org/wiki/$1', 'https://en.wiktionary.org/w/api.php', '', 0, 0);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]ipblocks`
CREATE TABLE `[[dbprefix]]ipblocks` (
`ipb_id` int(11) NOT NULL AUTO_INCREMENT,
`ipb_address` tinyblob NOT NULL,
`ipb_user` int(10) unsigned NOT NULL DEFAULT '0',
`ipb_by` int(10) unsigned NOT NULL DEFAULT '0',
`ipb_by_text` varbinary(255) NOT NULL DEFAULT '',
`ipb_by_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`ipb_reason` varbinary(767) NOT NULL DEFAULT '',
`ipb_reason_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`ipb_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipb_auto` tinyint(1) NOT NULL DEFAULT '0',
`ipb_anon_only` tinyint(1) NOT NULL DEFAULT '0',
`ipb_create_account` tinyint(1) NOT NULL DEFAULT '1',
`ipb_enable_autoblock` tinyint(1) NOT NULL DEFAULT '1',
`ipb_expiry` varbinary(14) NOT NULL DEFAULT '',
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
`ipb_deleted` tinyint(1) NOT NULL DEFAULT '0',
`ipb_block_email` tinyint(1) NOT NULL DEFAULT '0',
`ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '0',
`ipb_parent_block_id` int(11) DEFAULT NULL,
UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
KEY `ipb_user` (`ipb_user`),
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
KEY `ipb_timestamp` (`ipb_timestamp`),
KEY `ipb_expiry` (`ipb_expiry`),
KEY `ipb_parent_block_id` (`ipb_parent_block_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]ip_changes`
CREATE TABLE `[[dbprefix]]ip_changes` (
`ipc_rev_id` int(10) unsigned NOT NULL DEFAULT '0',
`ipc_rev_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipc_hex` varbinary(35) NOT NULL DEFAULT '',
PRIMARY KEY (`ipc_rev_id`),
KEY `ipc_rev_timestamp` (`ipc_rev_timestamp`),
KEY `ipc_hex_time` (`ipc_hex`,`ipc_rev_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]iwlinks`
CREATE TABLE `[[dbprefix]]iwlinks` (
`iwl_from` int(10) unsigned NOT NULL DEFAULT '0',
`iwl_prefix` varbinary(20) NOT NULL DEFAULT '',
`iwl_title` varbinary(255) NOT NULL DEFAULT '',
PRIMARY KEY (`iwl_from`,`iwl_prefix`,`iwl_title`),
KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`),
KEY `iwl_prefix_from_title` (`iwl_prefix`,`iwl_from`,`iwl_title`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]job`
CREATE TABLE `[[dbprefix]]job` (
`job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`job_cmd` varbinary(60) NOT NULL DEFAULT '',
`job_namespace` int(11) NOT NULL,
`job_title` varbinary(255) NOT NULL,
`job_timestamp` varbinary(14) DEFAULT NULL,
`job_params` blob NOT NULL,
`job_random` int(10) unsigned NOT NULL DEFAULT '0',
`job_attempts` int(10) unsigned NOT NULL DEFAULT '0',
`job_token` varbinary(32) NOT NULL DEFAULT '',
`job_token_timestamp` varbinary(14) DEFAULT NULL,
`job_sha1` varbinary(32) NOT NULL DEFAULT '',
KEY `job_sha1` (`job_sha1`),
KEY `job_cmd_token` (`job_cmd`,`job_token`,`job_random`),
KEY `job_cmd_token_id` (`job_cmd`,`job_token`,`job_id`),
KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`,`job_params`(128)),
KEY `job_timestamp` (`job_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ;
-- Dumping data for table `[[dbprefix]]job`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]l10n_cache`
CREATE TABLE `[[dbprefix]]l10n_cache` (
`lc_lang` varbinary(32) NOT NULL,
`lc_key` varbinary(255) NOT NULL,
`lc_value` mediumblob NOT NULL,
PRIMARY KEY (`lc_lang`,`lc_key`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
-- --------------------------------------------------------
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
