1083 lines
42 KiB
SQL
1083 lines
42 KiB
SQL
-- MySQL dump 10.13 Distrib 5.5.44, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: wiki
|
|
-- ------------------------------------------------------
|
|
-- Server version 5.5.44-0+deb8u1-log
|
|
|
|
/*!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 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `archive`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `archive`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `archive` (
|
|
`ar_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`ar_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`ar_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`ar_text` mediumblob NOT NULL,
|
|
`ar_comment` tinyblob NOT NULL,
|
|
`ar_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`ar_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`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_flags` tinyblob NOT NULL,
|
|
`ar_rev_id` int(10) unsigned DEFAULT NULL,
|
|
`ar_text_id` int(10) unsigned DEFAULT NULL,
|
|
`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,
|
|
PRIMARY KEY (`ar_id`),
|
|
KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
|
|
KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`),
|
|
KEY `ar_revid` (`ar_rev_id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `category`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `category`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `category` (
|
|
`cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`cat_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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',
|
|
PRIMARY KEY (`cat_id`),
|
|
UNIQUE KEY `cat_title` (`cat_title`),
|
|
KEY `cat_pages` (`cat_pages`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `categorylinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `categorylinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `categorylinks` (
|
|
`cl_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`cl_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`cl_sortkey` varbinary(230) NOT NULL DEFAULT '',
|
|
`cl_sortkey_prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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',
|
|
UNIQUE KEY `cl_from` (`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` (`cl_collation`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `change_tag`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `change_tag`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `change_tag` (
|
|
`ct_rc_id` int(11) DEFAULT NULL,
|
|
`ct_log_id` int(11) DEFAULT NULL,
|
|
`ct_rev_id` int(11) DEFAULT NULL,
|
|
`ct_tag` varchar(255) NOT NULL,
|
|
`ct_params` blob,
|
|
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=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `externallinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `externallinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `externallinks` (
|
|
`el_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`el_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`el_to` blob NOT NULL,
|
|
`el_index` blob NOT NULL,
|
|
PRIMARY KEY (`el_id`),
|
|
KEY `el_from` (`el_from`,`el_to`(40)),
|
|
KEY `el_to` (`el_to`(60),`el_from`),
|
|
KEY `el_index` (`el_index`(60))
|
|
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `filearchive`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `filearchive`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `filearchive` (
|
|
`fa_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fa_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`fa_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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` text,
|
|
`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') 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` tinyblob,
|
|
`fa_user` int(10) unsigned DEFAULT '0',
|
|
`fa_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
|
`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 '',
|
|
PRIMARY KEY (`fa_id`),
|
|
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_sha1` (`fa_sha1`(10))
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `hitcounter`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `hitcounter`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `hitcounter` (
|
|
`hc_id` int(10) unsigned NOT NULL
|
|
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=25000;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `image`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `image`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `image` (
|
|
`img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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') 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` tinyblob NOT NULL,
|
|
`img_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`img_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`img_timestamp` varbinary(14) NOT NULL DEFAULT '',
|
|
`img_sha1` varbinary(32) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`img_name`),
|
|
KEY `img_usertext_timestamp` (`img_user_text`,`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=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `imagelinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `imagelinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `imagelinks` (
|
|
`il_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`il_from_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`il_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
UNIQUE KEY `il_from` (`il_from`,`il_to`),
|
|
KEY `il_to` (`il_to`,`il_from`),
|
|
KEY `il_backlinks_namespace` (`il_to`,`il_from_namespace`,`il_from`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `interwiki`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `interwiki`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `interwiki` (
|
|
`iw_prefix` varchar(32) NOT NULL,
|
|
`iw_url` blob NOT NULL,
|
|
`iw_api` blob NOT NULL,
|
|
`iw_wikiid` varchar(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=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ipblocks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ipblocks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `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` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`ipb_reason` tinyblob NOT NULL,
|
|
`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,
|
|
PRIMARY KEY (`ipb_id`),
|
|
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=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `iwlinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `iwlinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `iwlinks` (
|
|
`iwl_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`iwl_prefix` varbinary(20) NOT NULL DEFAULT '',
|
|
`iwl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
UNIQUE KEY `iwl_from` (`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=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `job`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `job`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `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` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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 '',
|
|
PRIMARY KEY (`job_id`),
|
|
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 AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `l10n_cache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `l10n_cache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `l10n_cache` (
|
|
`lc_lang` varbinary(32) NOT NULL,
|
|
`lc_key` varchar(255) NOT NULL,
|
|
`lc_value` mediumblob NOT NULL,
|
|
KEY `lc_lang_key` (`lc_lang`,`lc_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `langlinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `langlinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `langlinks` (
|
|
`ll_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`ll_lang` varbinary(20) NOT NULL DEFAULT '',
|
|
`ll_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
|
|
KEY `ll_lang` (`ll_lang`,`ll_title`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `log_search`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `log_search`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `log_search` (
|
|
`ls_field` varbinary(32) NOT NULL,
|
|
`ls_value` varchar(255) NOT NULL,
|
|
`ls_log_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
UNIQUE KEY `ls_field_val` (`ls_field`,`ls_value`,`ls_log_id`),
|
|
KEY `ls_log_id` (`ls_log_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `logging`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logging`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `logging` (
|
|
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`log_type` varbinary(32) NOT NULL DEFAULT '',
|
|
`log_action` varbinary(32) NOT NULL DEFAULT '',
|
|
`log_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
|
|
`log_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`log_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`log_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`log_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`log_page` int(10) unsigned DEFAULT NULL,
|
|
`log_comment` varchar(255) NOT NULL DEFAULT '',
|
|
`log_params` blob NOT NULL,
|
|
`log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`log_id`),
|
|
KEY `type_time` (`log_type`,`log_timestamp`),
|
|
KEY `user_time` (`log_user`,`log_timestamp`),
|
|
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
|
|
KEY `times` (`log_timestamp`),
|
|
KEY `log_user_type_time` (`log_user`,`log_type`,`log_timestamp`),
|
|
KEY `log_page_id_time` (`log_page`,`log_timestamp`),
|
|
KEY `type_action` (`log_type`,`log_action`,`log_timestamp`),
|
|
KEY `log_user_text_type_time` (`log_user_text`,`log_type`,`log_timestamp`),
|
|
KEY `log_user_text_time` (`log_user_text`,`log_timestamp`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `module_deps`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `module_deps`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `module_deps` (
|
|
`md_module` varbinary(255) NOT NULL,
|
|
`md_skin` varbinary(32) NOT NULL,
|
|
`md_deps` mediumblob NOT NULL,
|
|
UNIQUE KEY `md_module_skin` (`md_module`,`md_skin`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `msg_resource`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `msg_resource`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `msg_resource` (
|
|
`mr_resource` varbinary(255) NOT NULL,
|
|
`mr_lang` varbinary(32) NOT NULL,
|
|
`mr_blob` mediumblob NOT NULL,
|
|
`mr_timestamp` binary(14) NOT NULL,
|
|
UNIQUE KEY `mr_resource_lang` (`mr_resource`,`mr_lang`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `msg_resource_links`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `msg_resource_links`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `msg_resource_links` (
|
|
`mrl_resource` varbinary(255) NOT NULL,
|
|
`mrl_message` varbinary(255) NOT NULL,
|
|
UNIQUE KEY `mrl_message_resource` (`mrl_message`,`mrl_resource`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `objectcache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `objectcache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `objectcache` (
|
|
`keyname` varbinary(255) NOT NULL DEFAULT '',
|
|
`value` mediumblob,
|
|
`exptime` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`keyname`),
|
|
KEY `exptime` (`exptime`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `oldimage`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `oldimage`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `oldimage` (
|
|
`oi_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`oi_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`oi_size` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`oi_width` int(11) NOT NULL DEFAULT '0',
|
|
`oi_height` int(11) NOT NULL DEFAULT '0',
|
|
`oi_bits` int(11) NOT NULL DEFAULT '0',
|
|
`oi_description` tinyblob NOT NULL,
|
|
`oi_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`oi_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`oi_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
|
|
`oi_metadata` mediumblob NOT NULL,
|
|
`oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
|
|
`oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') NOT NULL DEFAULT 'unknown',
|
|
`oi_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
|
|
`oi_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`oi_sha1` varbinary(32) NOT NULL DEFAULT '',
|
|
KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
|
|
KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
|
|
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
|
|
KEY `oi_sha1` (`oi_sha1`(10))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `page`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `page`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `page` (
|
|
`page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`page_namespace` int(11) NOT NULL,
|
|
`page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`page_restrictions` tinyblob NOT NULL,
|
|
`page_counter` bigint(20) unsigned NOT NULL DEFAULT '0',
|
|
`page_is_redirect` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`page_is_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`page_random` double unsigned NOT NULL,
|
|
`page_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
|
|
`page_links_updated` varbinary(14) DEFAULT NULL,
|
|
`page_latest` int(10) unsigned NOT NULL,
|
|
`page_len` int(10) unsigned NOT NULL,
|
|
`page_content_model` varbinary(32) DEFAULT NULL,
|
|
`page_lang` varbinary(35) DEFAULT NULL,
|
|
PRIMARY KEY (`page_id`),
|
|
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
|
|
KEY `page_random` (`page_random`),
|
|
KEY `page_len` (`page_len`),
|
|
KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `page_props`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `page_props`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `page_props` (
|
|
`pp_page` int(11) NOT NULL,
|
|
`pp_propname` varbinary(60) NOT NULL,
|
|
`pp_value` blob NOT NULL,
|
|
`pp_sortkey` float DEFAULT NULL,
|
|
UNIQUE KEY `pp_page_propname` (`pp_page`,`pp_propname`),
|
|
UNIQUE KEY `pp_propname_page` (`pp_propname`,`pp_page`),
|
|
UNIQUE KEY `pp_propname_sortkey_page` (`pp_propname`,`pp_sortkey`,`pp_page`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `page_restrictions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `page_restrictions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `page_restrictions` (
|
|
`pr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`pr_page` int(11) NOT NULL,
|
|
`pr_type` varbinary(60) NOT NULL,
|
|
`pr_level` varbinary(60) NOT NULL,
|
|
`pr_cascade` tinyint(4) NOT NULL,
|
|
`pr_user` int(11) DEFAULT NULL,
|
|
`pr_expiry` varbinary(14) DEFAULT NULL,
|
|
PRIMARY KEY (`pr_id`),
|
|
UNIQUE KEY `pr_pagetype` (`pr_page`,`pr_type`),
|
|
KEY `pr_typelevel` (`pr_type`,`pr_level`),
|
|
KEY `pr_level` (`pr_level`),
|
|
KEY `pr_cascade` (`pr_cascade`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `pagelinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `pagelinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `pagelinks` (
|
|
`pl_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`pl_from_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`pl_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`pl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
|
|
KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`),
|
|
KEY `pl_backlinks_namespace` (`pl_namespace`,`pl_title`,`pl_from_namespace`,`pl_from`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `protected_titles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `protected_titles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `protected_titles` (
|
|
`pt_namespace` int(11) NOT NULL,
|
|
`pt_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`pt_user` int(10) unsigned NOT NULL,
|
|
`pt_reason` tinyblob,
|
|
`pt_timestamp` binary(14) NOT NULL,
|
|
`pt_expiry` varbinary(14) NOT NULL DEFAULT '',
|
|
`pt_create_perm` varbinary(60) NOT NULL,
|
|
UNIQUE KEY `pt_namespace_title` (`pt_namespace`,`pt_title`),
|
|
KEY `pt_timestamp` (`pt_timestamp`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `querycache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `querycache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `querycache` (
|
|
`qc_type` varbinary(32) NOT NULL,
|
|
`qc_value` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`qc_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`qc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
KEY `qc_type` (`qc_type`,`qc_value`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `querycache_info`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `querycache_info`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `querycache_info` (
|
|
`qci_type` varbinary(32) NOT NULL DEFAULT '',
|
|
`qci_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
|
|
UNIQUE KEY `qci_type` (`qci_type`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `querycachetwo`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `querycachetwo`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `querycachetwo` (
|
|
`qcc_type` varbinary(32) NOT NULL,
|
|
`qcc_value` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`qcc_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`qcc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`qcc_namespacetwo` int(11) NOT NULL DEFAULT '0',
|
|
`qcc_titletwo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
KEY `qcc_type` (`qcc_type`,`qcc_value`),
|
|
KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
|
|
KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `recentchanges`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `recentchanges`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `recentchanges` (
|
|
`rc_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`rc_timestamp` varbinary(14) NOT NULL DEFAULT '',
|
|
`rc_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rc_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|
`rc_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`rc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`rc_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`rc_minor` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_bot` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_cur_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rc_this_oldid` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rc_last_oldid` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rc_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_source` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`rc_patrolled` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_ip` varbinary(40) NOT NULL DEFAULT '',
|
|
`rc_old_len` int(11) DEFAULT NULL,
|
|
`rc_new_len` int(11) DEFAULT NULL,
|
|
`rc_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rc_logid` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rc_log_type` varbinary(255) DEFAULT NULL,
|
|
`rc_log_action` varbinary(255) DEFAULT NULL,
|
|
`rc_params` blob,
|
|
PRIMARY KEY (`rc_id`),
|
|
KEY `rc_timestamp` (`rc_timestamp`),
|
|
KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
|
|
KEY `rc_cur_id` (`rc_cur_id`),
|
|
KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
|
|
KEY `rc_ip` (`rc_ip`),
|
|
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
|
|
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `redirect`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `redirect`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `redirect` (
|
|
`rd_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rd_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`rd_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`rd_interwiki` varchar(32) DEFAULT NULL,
|
|
`rd_fragment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
|
PRIMARY KEY (`rd_from`),
|
|
KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `revision`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `revision`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `revision` (
|
|
`rev_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`rev_page` int(10) unsigned NOT NULL,
|
|
`rev_text_id` int(10) unsigned NOT NULL,
|
|
`rev_comment` tinyblob NOT NULL,
|
|
`rev_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`rev_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`rev_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
|
|
`rev_minor_edit` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rev_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`rev_len` int(10) unsigned DEFAULT NULL,
|
|
`rev_parent_id` int(10) unsigned DEFAULT NULL,
|
|
`rev_sha1` varbinary(32) NOT NULL DEFAULT '',
|
|
`rev_content_model` varbinary(32) DEFAULT NULL,
|
|
`rev_content_format` varbinary(64) DEFAULT NULL,
|
|
PRIMARY KEY (`rev_id`),
|
|
UNIQUE KEY `rev_page_id` (`rev_page`,`rev_id`),
|
|
KEY `rev_timestamp` (`rev_timestamp`),
|
|
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
|
|
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
|
|
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`),
|
|
KEY `page_user_timestamp` (`rev_page`,`rev_user`,`rev_timestamp`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=395 DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `searchindex`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `searchindex`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `searchindex` (
|
|
`si_page` int(10) unsigned NOT NULL,
|
|
`si_title` varchar(255) NOT NULL DEFAULT '',
|
|
`si_text` mediumtext NOT NULL,
|
|
UNIQUE KEY `si_page` (`si_page`),
|
|
FULLTEXT KEY `si_title` (`si_title`),
|
|
FULLTEXT KEY `si_text` (`si_text`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `site_identifiers`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `site_identifiers`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `site_identifiers` (
|
|
`si_site` int(10) unsigned NOT NULL,
|
|
`si_type` varbinary(32) NOT NULL,
|
|
`si_key` varbinary(32) NOT NULL,
|
|
UNIQUE KEY `site_ids_type` (`si_type`,`si_key`),
|
|
KEY `site_ids_site` (`si_site`),
|
|
KEY `site_ids_key` (`si_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `site_stats`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `site_stats`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `site_stats` (
|
|
`ss_row_id` int(10) unsigned NOT NULL,
|
|
`ss_total_views` bigint(20) unsigned DEFAULT '0',
|
|
`ss_total_edits` bigint(20) unsigned DEFAULT '0',
|
|
`ss_good_articles` bigint(20) unsigned DEFAULT '0',
|
|
`ss_total_pages` bigint(20) DEFAULT '-1',
|
|
`ss_users` bigint(20) DEFAULT '-1',
|
|
`ss_active_users` bigint(20) DEFAULT '-1',
|
|
`ss_images` int(11) DEFAULT '0',
|
|
UNIQUE KEY `ss_row_id` (`ss_row_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sites`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sites`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sites` (
|
|
`site_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`site_global_key` varbinary(32) NOT NULL,
|
|
`site_type` varbinary(32) NOT NULL,
|
|
`site_group` varbinary(32) NOT NULL,
|
|
`site_source` varbinary(32) NOT NULL,
|
|
`site_language` varbinary(32) NOT NULL,
|
|
`site_protocol` varbinary(32) NOT NULL,
|
|
`site_domain` varchar(255) NOT NULL,
|
|
`site_data` blob NOT NULL,
|
|
`site_forward` tinyint(1) NOT NULL,
|
|
`site_config` blob NOT NULL,
|
|
PRIMARY KEY (`site_id`),
|
|
UNIQUE KEY `sites_global_key` (`site_global_key`),
|
|
KEY `sites_type` (`site_type`),
|
|
KEY `sites_group` (`site_group`),
|
|
KEY `sites_source` (`site_source`),
|
|
KEY `sites_language` (`site_language`),
|
|
KEY `sites_protocol` (`site_protocol`),
|
|
KEY `sites_domain` (`site_domain`),
|
|
KEY `sites_forward` (`site_forward`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `tag_summary`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tag_summary`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `tag_summary` (
|
|
`ts_rc_id` int(11) DEFAULT NULL,
|
|
`ts_log_id` int(11) DEFAULT NULL,
|
|
`ts_rev_id` int(11) DEFAULT NULL,
|
|
`ts_tags` blob NOT NULL,
|
|
UNIQUE KEY `tag_summary_rc_id` (`ts_rc_id`),
|
|
UNIQUE KEY `tag_summary_log_id` (`ts_log_id`),
|
|
UNIQUE KEY `tag_summary_rev_id` (`ts_rev_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `templatelinks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `templatelinks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `templatelinks` (
|
|
`tl_from` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`tl_from_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`tl_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`tl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
|
|
KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`),
|
|
KEY `tl_backlinks_namespace` (`tl_namespace`,`tl_title`,`tl_from_namespace`,`tl_from`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `text`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `text`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `text` (
|
|
`old_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`old_text` mediumblob NOT NULL,
|
|
`old_flags` tinyblob NOT NULL,
|
|
PRIMARY KEY (`old_id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `transcache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `transcache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `transcache` (
|
|
`tc_url` varbinary(255) NOT NULL,
|
|
`tc_contents` text,
|
|
`tc_time` binary(14) NOT NULL,
|
|
UNIQUE KEY `tc_url_idx` (`tc_url`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `updatelog`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `updatelog`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `updatelog` (
|
|
`ul_key` varchar(255) NOT NULL,
|
|
`ul_value` blob,
|
|
PRIMARY KEY (`ul_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `uploadstash`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `uploadstash`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `uploadstash` (
|
|
`us_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`us_user` int(10) unsigned NOT NULL,
|
|
`us_key` varchar(255) NOT NULL,
|
|
`us_orig_path` varchar(255) NOT NULL,
|
|
`us_path` varchar(255) NOT NULL,
|
|
`us_source_type` varchar(50) DEFAULT NULL,
|
|
`us_timestamp` varbinary(14) NOT NULL,
|
|
`us_status` varchar(50) NOT NULL,
|
|
`us_chunk_inx` int(10) unsigned DEFAULT NULL,
|
|
`us_props` blob,
|
|
`us_size` int(10) unsigned NOT NULL,
|
|
`us_sha1` varchar(31) NOT NULL,
|
|
`us_mime` varchar(255) DEFAULT NULL,
|
|
`us_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
|
|
`us_image_width` int(10) unsigned DEFAULT NULL,
|
|
`us_image_height` int(10) unsigned DEFAULT NULL,
|
|
`us_image_bits` smallint(5) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`us_id`),
|
|
UNIQUE KEY `us_key` (`us_key`),
|
|
KEY `us_user` (`us_user`),
|
|
KEY `us_timestamp` (`us_timestamp`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `user`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `user` (
|
|
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`user_real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`user_password` tinyblob NOT NULL,
|
|
`user_newpassword` tinyblob NOT NULL,
|
|
`user_newpass_time` binary(14) DEFAULT NULL,
|
|
`user_email` tinytext NOT NULL,
|
|
`user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
|
|
`user_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',
|
|
`user_email_authenticated` binary(14) DEFAULT NULL,
|
|
`user_email_token` binary(32) DEFAULT NULL,
|
|
`user_email_token_expires` binary(14) DEFAULT NULL,
|
|
`user_registration` binary(14) DEFAULT NULL,
|
|
`user_editcount` int(11) DEFAULT NULL,
|
|
`user_password_expires` varbinary(14) DEFAULT NULL,
|
|
PRIMARY KEY (`user_id`),
|
|
UNIQUE KEY `user_name` (`user_name`),
|
|
KEY `user_email_token` (`user_email_token`),
|
|
KEY `user_email` (`user_email`(50))
|
|
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `user_former_groups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user_former_groups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `user_former_groups` (
|
|
`ufg_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`ufg_group` varbinary(255) NOT NULL DEFAULT '',
|
|
UNIQUE KEY `ufg_user_group` (`ufg_user`,`ufg_group`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `user_groups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user_groups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `user_groups` (
|
|
`ug_user` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`ug_group` varbinary(255) NOT NULL DEFAULT '',
|
|
UNIQUE KEY `ug_user_group` (`ug_user`,`ug_group`),
|
|
KEY `ug_group` (`ug_group`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `user_newtalk`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user_newtalk`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `user_newtalk` (
|
|
`user_id` int(11) NOT NULL DEFAULT '0',
|
|
`user_ip` varbinary(40) NOT NULL DEFAULT '',
|
|
`user_last_timestamp` varbinary(14) DEFAULT NULL,
|
|
KEY `user_id` (`user_id`),
|
|
KEY `user_ip` (`user_ip`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `user_properties`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user_properties`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `user_properties` (
|
|
`up_user` int(11) NOT NULL,
|
|
`up_property` varbinary(255) NOT NULL,
|
|
`up_value` blob,
|
|
UNIQUE KEY `user_properties_user_property` (`up_user`,`up_property`),
|
|
KEY `user_properties_property` (`up_property`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `valid_tag`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `valid_tag`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `valid_tag` (
|
|
`vt_tag` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`vt_tag`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `watchlist`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `watchlist`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `watchlist` (
|
|
`wl_user` int(10) unsigned NOT NULL,
|
|
`wl_namespace` int(11) NOT NULL DEFAULT '0',
|
|
`wl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
|
`wl_notificationtimestamp` varbinary(14) DEFAULT NULL,
|
|
UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
|
|
KEY `namespace_title` (`wl_namespace`,`wl_title`),
|
|
KEY `wl_user_notificationtimestamp` (`wl_user`,`wl_notificationtimestamp`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2017-01-11 11:06:40
|