Page MenuHomePhabricator

development-wiki-database-schema-1.32.0-2019-09-27.sql

Authored By
Jukeboksi
Sep 27 2019, 10:20 AM
Size
86 KB
Referenced Files
None
Subscribers
None

development-wiki-database-schema-1.32.0-2019-09-27.sql

-- MySQL dump 10.16 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: mediawiki_developwiki
-- ------------------------------------------------------
-- Server version 10.1.41-MariaDB-0+deb9u1
/*!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 utf8mb4 */;
/*!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 `abuse_filter`
--
DROP TABLE IF EXISTS `abuse_filter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abuse_filter` (
`af_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`af_pattern` blob NOT NULL,
`af_user` bigint(20) unsigned NOT NULL,
`af_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`af_timestamp` binary(14) NOT NULL,
`af_enabled` tinyint(1) NOT NULL DEFAULT '1',
`af_comments` blob,
`af_public_comments` tinyblob,
`af_hidden` tinyint(1) NOT NULL DEFAULT '0',
`af_hit_count` bigint(20) NOT NULL DEFAULT '0',
`af_throttled` tinyint(1) NOT NULL DEFAULT '0',
`af_deleted` tinyint(1) NOT NULL DEFAULT '0',
`af_actions` varchar(255) NOT NULL DEFAULT '',
`af_global` tinyint(1) NOT NULL DEFAULT '0',
`af_group` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'default',
PRIMARY KEY (`af_id`),
KEY `af_user` (`af_user`),
KEY `af_group` (`af_group`,`af_enabled`,`af_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `abuse_filter_action`
--
DROP TABLE IF EXISTS `abuse_filter_action`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abuse_filter_action` (
`afa_filter` bigint(20) unsigned NOT NULL,
`afa_consequence` varchar(255) NOT NULL,
`afa_parameters` tinyblob NOT NULL,
PRIMARY KEY (`afa_filter`,`afa_consequence`),
KEY `afa_consequence` (`afa_consequence`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `abuse_filter_history`
--
DROP TABLE IF EXISTS `abuse_filter_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abuse_filter_history` (
`afh_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`afh_filter` bigint(20) unsigned NOT NULL,
`afh_user` bigint(20) unsigned NOT NULL,
`afh_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`afh_timestamp` binary(14) NOT NULL,
`afh_pattern` blob NOT NULL,
`afh_comments` blob NOT NULL,
`afh_flags` tinyblob NOT NULL,
`afh_public_comments` tinyblob,
`afh_actions` blob,
`afh_deleted` tinyint(1) NOT NULL DEFAULT '0',
`afh_changed_fields` varchar(255) NOT NULL DEFAULT '',
`afh_group` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
PRIMARY KEY (`afh_id`),
KEY `afh_filter` (`afh_filter`),
KEY `afh_user` (`afh_user`),
KEY `afh_user_text` (`afh_user_text`),
KEY `afh_timestamp` (`afh_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `abuse_filter_log`
--
DROP TABLE IF EXISTS `abuse_filter_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abuse_filter_log` (
`afl_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`afl_filter` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`afl_user` bigint(20) unsigned NOT NULL,
`afl_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`afl_ip` varchar(255) NOT NULL,
`afl_action` varbinary(255) NOT NULL,
`afl_actions` varbinary(255) NOT NULL,
`afl_var_dump` blob NOT NULL,
`afl_timestamp` binary(14) NOT NULL,
`afl_namespace` int(11) NOT NULL,
`afl_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`afl_wiki` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`afl_deleted` tinyint(1) NOT NULL DEFAULT '0',
`afl_patrolled_by` int(10) unsigned DEFAULT NULL,
`afl_rev_id` int(10) unsigned DEFAULT NULL,
`afl_log_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`afl_id`),
KEY `filter_timestamp` (`afl_filter`,`afl_timestamp`),
KEY `user_timestamp` (`afl_user`,`afl_user_text`,`afl_timestamp`),
KEY `afl_timestamp` (`afl_timestamp`),
KEY `page_timestamp` (`afl_namespace`,`afl_title`,`afl_timestamp`),
KEY `ip_timestamp` (`afl_ip`,`afl_timestamp`),
KEY `afl_rev_id` (`afl_rev_id`),
KEY `afl_log_id` (`afl_log_id`),
KEY `wiki_timestamp` (`afl_wiki`,`afl_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `account_credentials`
--
DROP TABLE IF EXISTS `account_credentials`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_credentials` (
`acd_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`acd_user_id` int(10) unsigned NOT NULL,
`acd_real_name` varbinary(255) NOT NULL DEFAULT '',
`acd_email` tinyblob NOT NULL,
`acd_email_authenticated` varbinary(14) DEFAULT NULL,
`acd_bio` mediumblob NOT NULL,
`acd_notes` mediumblob NOT NULL,
`acd_urls` mediumblob NOT NULL,
`acd_ip` varbinary(255) DEFAULT '',
`acd_xff` varbinary(255) DEFAULT '',
`acd_agent` varbinary(255) DEFAULT '',
`acd_filename` varbinary(255) DEFAULT NULL,
`acd_storage_key` varbinary(64) DEFAULT NULL,
`acd_areas` mediumblob NOT NULL,
`acd_registration` varbinary(14) NOT NULL,
`acd_accepted` varbinary(14) DEFAULT NULL,
`acd_user` int(10) unsigned NOT NULL DEFAULT '0',
`acd_comment` varbinary(255) NOT NULL DEFAULT '',
PRIMARY KEY (`acd_id`),
UNIQUE KEY `acd_user_id` (`acd_user_id`,`acd_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `account_requests`
--
DROP TABLE IF EXISTS `account_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_requests` (
`acr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`acr_name` varbinary(255) NOT NULL DEFAULT '',
`acr_real_name` varbinary(255) NOT NULL DEFAULT '',
`acr_email` varbinary(255) NOT NULL,
`acr_email_authenticated` varbinary(14) DEFAULT NULL,
`acr_email_token` binary(32) DEFAULT NULL,
`acr_email_token_expires` varbinary(14) DEFAULT NULL,
`acr_bio` mediumblob NOT NULL,
`acr_notes` mediumblob NOT NULL,
`acr_urls` mediumblob NOT NULL,
`acr_ip` varbinary(255) DEFAULT '',
`acr_xff` varbinary(255) DEFAULT '',
`acr_agent` varbinary(255) DEFAULT '',
`acr_filename` varbinary(255) DEFAULT NULL,
`acr_storage_key` varbinary(64) DEFAULT NULL,
`acr_type` tinyint(255) unsigned NOT NULL DEFAULT '0',
`acr_areas` mediumblob NOT NULL,
`acr_registration` varbinary(14) NOT NULL,
`acr_deleted` tinyint(1) NOT NULL,
`acr_rejected` varbinary(14) DEFAULT NULL,
`acr_held` varbinary(14) DEFAULT NULL,
`acr_user` int(10) unsigned NOT NULL DEFAULT '0',
`acr_comment` varbinary(255) NOT NULL DEFAULT '',
PRIMARY KEY (`acr_id`),
UNIQUE KEY `acr_name` (`acr_name`),
KEY `acr_email` (`acr_email`),
KEY `acr_email_token` (`acr_email_token`),
KEY `acr_type_del_reg` (`acr_type`,`acr_deleted`,`acr_registration`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `actor`
--
DROP TABLE IF EXISTS `actor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ar_comment` varbinary(767) NOT NULL DEFAULT '',
`ar_comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`ar_user` int(5) unsigned NOT NULL DEFAULT '0',
`ar_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ar_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`ar_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ar_minor_edit` tinyint(1) 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_format` varbinary(64) DEFAULT NULL,
`ar_content_model` varbinary(32) DEFAULT NULL,
PRIMARY KEY (`ar_id`),
UNIQUE KEY `ar_revid_uniq` (`ar_rev_id`),
KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`),
KEY `ar_actor_timestamp` (`ar_actor`,`ar_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=33782 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `babel`
--
DROP TABLE IF EXISTS `babel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `babel` (
`babel_user` int(10) unsigned NOT NULL,
`babel_lang` varbinary(10) NOT NULL,
`babel_level` varbinary(2) NOT NULL,
PRIMARY KEY (`babel_user`,`babel_lang`),
KEY `babel_lang_level` (`babel_lang`,`babel_level`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `blobs`
--
DROP TABLE IF EXISTS `blobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blobs` (
`blob_index` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`blob_data` longblob NOT NULL,
UNIQUE KEY `blob_index` (`blob_index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `bot_passwords`
--
DROP TABLE IF EXISTS `bot_passwords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `brokenlinks`
--
DROP TABLE IF EXISTS `brokenlinks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brokenlinks` (
`bl_from` int(8) unsigned NOT NULL DEFAULT '0',
`bl_to` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
UNIQUE KEY `bl_from` (`bl_from`,`bl_to`),
KEY `bl_to` (`bl_to`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_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=42 DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`cl_to` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`cl_sortkey` varbinary(230) NOT NULL DEFAULT '',
`cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cl_sortkey_prefix` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`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_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_type`,`cl_sortkey`,`cl_from`),
KEY `cl_collation_ext` (`cl_collation`,`cl_to`,`cl_type`,`cl_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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_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` varchar(255) NOT NULL DEFAULT '',
`ct_params` blob,
`ct_tag_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`ct_id`),
UNIQUE KEY `change_tag_rc_tag_id` (`ct_rc_id`,`ct_tag_id`),
UNIQUE KEY `change_tag_log_tag_id` (`ct_log_id`,`ct_tag_id`),
UNIQUE KEY `change_tag_rev_tag_id` (`ct_rev_id`,`ct_tag_id`),
KEY `change_tag_tag_id` (`ct_tag`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`),
KEY `change_tag_tag_id_id` (`ct_tag_id`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`),
KEY `change_tag_rc_tag_nonuniq` (`ct_rc_id`,`ct_tag`),
KEY `change_tag_log_tag_nonuniq` (`ct_log_id`,`ct_tag`),
KEY `change_tag_rev_tag_nonuniq` (`ct_rev_id`,`ct_tag`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `change_tag_def`
--
DROP TABLE IF EXISTS `change_tag_def`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `change_tag_def` (
`ctd_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ctd_name` varbinary(255) NOT NULL,
`ctd_user_defined` tinyint(1) NOT NULL,
`ctd_count` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ctd_id`),
UNIQUE KEY `ctd_name` (`ctd_name`),
KEY `ctd_count` (`ctd_count`),
KEY `ctd_user_defined` (`ctd_user_defined`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `comment`
--
DROP TABLE IF EXISTS `comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comment` (
`comment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_hash` int(11) NOT NULL,
`comment_text` blob NOT NULL,
`comment_data` blob,
PRIMARY KEY (`comment_id`),
KEY `comment_hash` (`comment_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `content`
--
DROP TABLE IF EXISTS `content`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=48759 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `content_models`
--
DROP TABLE IF EXISTS `content_models`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cur`
--
DROP TABLE IF EXISTS `cur`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cur` (
`cur_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`cur_namespace` tinyint(2) unsigned NOT NULL DEFAULT '0',
`cur_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`cur_text` mediumtext NOT NULL,
`cur_comment` tinyblob NOT NULL,
`cur_user` int(5) unsigned NOT NULL DEFAULT '0',
`cur_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`cur_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`cur_restrictions` tinyblob NOT NULL,
`cur_counter` bigint(20) unsigned NOT NULL DEFAULT '0',
`cur_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cur_minor_edit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cur_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cur_random` double unsigned NOT NULL DEFAULT '0',
`inverse_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`cur_touched` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
UNIQUE KEY `cur_id` (`cur_id`),
KEY `cur_namespace` (`cur_namespace`),
KEY `cur_title` (`cur_title`(20)),
KEY `cur_timestamp` (`cur_timestamp`),
KEY `cur_random` (`cur_random`),
KEY `name_title_timestamp` (`cur_namespace`,`cur_title`,`inverse_timestamp`),
KEY `user_timestamp` (`cur_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`cur_user_text`,`inverse_timestamp`),
KEY `id_title_ns_red` (`cur_id`,`cur_title`,`cur_namespace`,`cur_is_redirect`)
) ENGINE=MyISAM AUTO_INCREMENT=3746 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `external_user`
--
DROP TABLE IF EXISTS `external_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `external_user` (
`eu_local_id` int(10) unsigned NOT NULL,
`eu_external_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
PRIMARY KEY (`eu_local_id`),
UNIQUE KEY `eu_external_id` (`eu_external_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`el_to` blob NOT NULL,
`el_index` blob NOT NULL,
`el_index_60` varbinary(60) 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)),
KEY `el_index_60` (`el_index_60`,`el_id`),
KEY `el_from_index_60` (`el_from`,`el_index_60`,`el_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16470 DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`fa_archive_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_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` 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 NULL,
`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` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin 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 '',
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)),
KEY `fa_actor_timestamp` (`fa_actor`,`fa_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`img_size` int(8) unsigned NOT NULL DEFAULT '0',
`img_description` varbinary(767) NOT NULL DEFAULT '',
`img_description_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`img_user` int(5) unsigned NOT NULL DEFAULT '0',
`img_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`img_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`img_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`img_width` int(5) NOT NULL DEFAULT '0',
`img_height` int(5) NOT NULL DEFAULT '0',
`img_bits` int(5) NOT NULL DEFAULT '0',
`img_metadata` mediumblob NOT NULL,
`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') DEFAULT NULL,
`img_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
`img_sha1` varbinary(32) NOT NULL DEFAULT '',
PRIMARY KEY (`img_name`),
KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_sha1` (`img_sha1`),
KEY `img_media_mime` (`img_media_type`,`img_major_mime`,`img_minor_mime`),
KEY `img_user_timestamp` (`img_user`,`img_timestamp`),
KEY `img_actor_timestamp` (`img_actor`,`img_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `image_comment_temp`
--
DROP TABLE IF EXISTS `image_comment_temp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`il_to` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`il_from_namespace` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`il_from`,`il_to`),
KEY `il_backlinks_namespace` (`il_to`,`il_from_namespace`,`il_from`),
KEY `il_to` (`il_to`,`il_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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` char(32) NOT NULL DEFAULT '',
`iw_url` char(127) NOT NULL DEFAULT '',
`iw_local` tinyint(1) NOT NULL DEFAULT '0',
`iw_trans` tinyint(1) NOT NULL DEFAULT '0',
`iw_api` blob NOT NULL,
`iw_wikiid` varchar(64) NOT NULL,
PRIMARY KEY (`iw_prefix`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ip_changes`
--
DROP TABLE IF EXISTS `ip_changes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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;
/*!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 latin1 COLLATE latin1_bin 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,
`ipb_sitewide` tinyint(1) NOT NULL DEFAULT '1',
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 AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ipblocks_old`
--
DROP TABLE IF EXISTS `ipblocks_old`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblocks_old` (
`ipb_id` int(8) NOT NULL AUTO_INCREMENT,
`ipb_address` varchar(40) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ipb_user` int(8) unsigned NOT NULL DEFAULT '0',
`ipb_by` int(8) unsigned NOT NULL DEFAULT '0',
`ipb_reason` tinyblob NOT NULL,
`ipb_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ipb_auto` tinyint(1) NOT NULL DEFAULT '0',
`ipb_expiry` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`ipb_range_start` varchar(32) NOT NULL DEFAULT '',
`ipb_range_end` varchar(32) NOT NULL DEFAULT '',
UNIQUE KEY `ipb_id` (`ipb_id`),
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8))
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ipblocks_restrictions`
--
DROP TABLE IF EXISTS `ipblocks_restrictions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblocks_restrictions` (
`ir_ipb_id` int(11) NOT NULL,
`ir_type` tinyint(4) NOT NULL,
`ir_value` int(11) NOT NULL,
PRIMARY KEY (`ir_ipb_id`,`ir_type`,`ir_value`),
KEY `ir_type_value` (`ir_type`,`ir_value`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!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 latin1 COLLATE latin1_bin 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=latin1;
/*!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(9) unsigned NOT NULL AUTO_INCREMENT,
`job_cmd` varchar(255) NOT NULL DEFAULT '',
`job_namespace` int(11) NOT NULL DEFAULT '0',
`job_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`job_params` blob NOT NULL,
`job_timestamp` varbinary(14) DEFAULT NULL,
`job_random` 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 '',
`job_attempts` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`job_id`),
KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`),
KEY `job_timestamp` (`job_timestamp`),
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`)
) ENGINE=MyISAM AUTO_INCREMENT=34005 DEFAULT CHARSET=latin1;
/*!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,
PRIMARY KEY (`lc_lang`,`lc_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
PRIMARY KEY (`ll_from`,`ll_lang`),
KEY `ll_lang` (`ll_lang`,`ll_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `links`
--
DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
`l_from` int(8) unsigned NOT NULL DEFAULT '0',
`l_to` int(8) unsigned NOT NULL DEFAULT '0',
KEY `l_to` (`l_to`),
KEY `l_from` (`l_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `linkscc`
--
DROP TABLE IF EXISTS `linkscc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `linkscc` (
`lcc_pageid` int(10) unsigned NOT NULL DEFAULT '0',
`lcc_cacheobj` mediumblob NOT NULL,
UNIQUE KEY `lcc_pageid` (`lcc_pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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',
PRIMARY KEY (`ls_field`,`ls_value`,`ls_log_id`),
KEY `ls_log_id` (`ls_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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_type` varbinary(32) NOT NULL,
`log_action` varbinary(32) NOT NULL,
`log_timestamp` varchar(14) NOT NULL DEFAULT '19700101000000',
`log_user` int(10) unsigned NOT NULL DEFAULT '0',
`log_namespace` int(11) NOT NULL DEFAULT '0',
`log_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`log_comment` varbinary(767) NOT NULL DEFAULT '',
`log_comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`log_params` blob NOT NULL,
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
`log_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`log_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`log_page` int(10) unsigned DEFAULT NULL,
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 `log_user_text_type_time` (`log_user_text`,`log_type`,`log_timestamp`),
KEY `log_user_text_time` (`log_user_text`,`log_timestamp`),
KEY `actor_time` (`log_actor`,`log_timestamp`),
KEY `log_actor_type_time` (`log_actor`,`log_type`,`log_timestamp`),
KEY `log_type_action` (`log_type`,`log_action`,`log_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=7325 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `math`
--
DROP TABLE IF EXISTS `math`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `math` (
`math_inputhash` varchar(16) NOT NULL DEFAULT '',
`math_outputhash` varchar(16) NOT NULL DEFAULT '',
`math_html_conservativeness` tinyint(1) NOT NULL DEFAULT '0',
`math_html` text,
`math_mathml` text,
UNIQUE KEY `math_inputhash` (`math_inputhash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mathoid`
--
DROP TABLE IF EXISTS `mathoid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mathoid` (
`math_inputhash` varbinary(16) NOT NULL,
`math_input` text NOT NULL,
`math_tex` text,
`math_mathml` text,
`math_svg` text,
`math_style` tinyint(4) DEFAULT NULL,
`math_input_type` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`math_inputhash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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,
PRIMARY KEY (`md_module`,`md_skin`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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=MyISAM DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`oi_archive_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`oi_size` int(8) unsigned NOT NULL DEFAULT '0',
`oi_description` varbinary(767) NOT NULL DEFAULT '',
`oi_description_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`oi_user` int(5) unsigned NOT NULL DEFAULT '0',
`oi_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`oi_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`oi_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`oi_width` int(5) NOT NULL DEFAULT '0',
`oi_height` int(5) NOT NULL DEFAULT '0',
`oi_bits` int(3) NOT NULL DEFAULT '0',
`oi_metadata` mediumblob NOT NULL,
`oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') DEFAULT NULL,
`oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') DEFAULT NULL,
`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_name_timestamp` (`oi_name`,`oi_timestamp`),
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_sha1` (`oi_sha1`),
KEY `oi_actor_timestamp` (`oi_actor`,`oi_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!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(8) unsigned NOT NULL AUTO_INCREMENT,
`page_namespace` int(11) NOT NULL DEFAULT '0',
`page_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`page_restrictions` tinyblob NOT NULL,
`page_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0',
`page_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
`page_random` double unsigned NOT NULL DEFAULT '0',
`page_touched` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`page_latest` int(8) unsigned NOT NULL DEFAULT '0',
`page_len` int(8) unsigned NOT NULL DEFAULT '0',
`page_content_model` varbinary(32) DEFAULT NULL,
`page_links_updated` varbinary(14) 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=MyISAM AUTO_INCREMENT=6495 DEFAULT CHARSET=latin1;
/*!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,
PRIMARY KEY (`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=latin1;
/*!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_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(10) unsigned DEFAULT NULL,
`pr_expiry` varbinary(14) DEFAULT NULL,
`pr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`pr_page`,`pr_type`),
UNIQUE KEY `pr_id` (`pr_id`),
KEY `pr_page` (`pr_page`),
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
) ENGINE=InnoDB AUTO_INCREMENT=3068 DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`pl_namespace` int(11) NOT NULL DEFAULT '0',
`pl_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`pl_from_namespace` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pl_from`,`pl_namespace`,`pl_title`),
KEY `pl_backlinks_namespace` (`pl_namespace`,`pl_title`,`pl_from_namespace`,`pl_from`),
KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL,
`pt_user` int(10) unsigned NOT NULL,
`pt_reason` varbinary(767) DEFAULT '',
`pt_reason_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`pt_timestamp` binary(14) NOT NULL,
`pt_expiry` varbinary(14) NOT NULL DEFAULT '',
`pt_create_perm` varbinary(60) NOT NULL,
PRIMARY KEY (`pt_namespace`,`pt_title`),
KEY `pt_timestamp` (`pt_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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` char(32) NOT NULL DEFAULT '',
`qc_value` int(5) unsigned NOT NULL DEFAULT '0',
`qc_namespace` int(11) NOT NULL DEFAULT '0',
`qc_title` char(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
KEY `qc_type` (`qc_type`,`qc_value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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',
PRIMARY KEY (`qci_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`qcc_namespacetwo` int(11) NOT NULL DEFAULT '0',
`qcc_titletwo` varchar(255) CHARACTER SET latin1 COLLATE latin1_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=latin1;
/*!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_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rc_user` int(10) unsigned NOT NULL DEFAULT '0',
`rc_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rc_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
`rc_namespace` int(11) NOT NULL DEFAULT '0',
`rc_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rc_comment` varbinary(767) NOT NULL DEFAULT '',
`rc_comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`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_ip` varbinary(40) NOT NULL DEFAULT '',
`rc_id` int(8) NOT NULL AUTO_INCREMENT,
`rc_patrolled` tinyint(3) unsigned NOT NULL DEFAULT '0',
`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 NOT NULL,
`rc_source` varbinary(16) NOT NULL DEFAULT '',
PRIMARY KEY (`rc_id`),
KEY `rc_timestamp` (`rc_timestamp`),
KEY `rc_cur_id` (`rc_cur_id`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`),
KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
KEY `rc_name_type_patrolled_timestamp` (`rc_namespace`,`rc_type`,`rc_patrolled`,`rc_timestamp`),
KEY `rc_ns_actor` (`rc_namespace`,`rc_actor`),
KEY `rc_actor` (`rc_actor`,`rc_timestamp`),
KEY `rc_namespace_title_timestamp` (`rc_namespace`,`rc_title`,`rc_timestamp`),
KEY `rc_this_oldid` (`rc_this_oldid`)
) ENGINE=MyISAM AUTO_INCREMENT=48199 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!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 latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rd_interwiki` varchar(32) DEFAULT NULL,
`rd_fragment` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
PRIMARY KEY (`rd_from`),
KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL AUTO_INCREMENT,
`rev_page` int(8) unsigned NOT NULL DEFAULT '0',
`rev_comment` varbinary(767) NOT NULL DEFAULT '',
`rev_user` int(5) unsigned NOT NULL DEFAULT '0',
`rev_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rev_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`rev_minor_edit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rev_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rev_text_id` int(8) 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_format` varbinary(64) DEFAULT NULL,
`rev_content_model` varbinary(32) DEFAULT NULL,
PRIMARY KEY (`rev_page`,`rev_id`),
UNIQUE KEY `rev_id` (`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=MyISAM AUTO_INCREMENT=49385 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `revision_actor_temp`
--
DROP TABLE IF EXISTS `revision_actor_temp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `revision_actor_temp` (
`revactor_rev` int(10) unsigned NOT NULL,
`revactor_actor` bigint(20) unsigned NOT NULL,
`revactor_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`revactor_page` int(10) unsigned NOT NULL,
PRIMARY KEY (`revactor_rev`,`revactor_actor`),
UNIQUE KEY `revactor_rev` (`revactor_rev`),
KEY `actor_timestamp` (`revactor_actor`,`revactor_timestamp`),
KEY `page_actor_timestamp` (`revactor_page`,`revactor_actor`,`revactor_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `revision_comment_temp`
--
DROP TABLE IF EXISTS `revision_comment_temp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `revision_comment_temp` (
`revcomment_rev` int(10) unsigned NOT NULL,
`revcomment_comment_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`revcomment_rev`,`revcomment_comment_id`),
UNIQUE KEY `revcomment_rev` (`revcomment_rev`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`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=latin1 PACK_KEYS=1;
/*!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,
PRIMARY KEY (`si_type`,`si_key`),
KEY `site_ids_site` (`si_site`),
KEY `site_ids_key` (`si_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`ss_total_edits` bigint(20) unsigned DEFAULT NULL,
`ss_good_articles` bigint(20) unsigned DEFAULT NULL,
`ss_total_pages` bigint(20) unsigned DEFAULT NULL,
`ss_users` bigint(20) unsigned DEFAULT NULL,
`ss_images` bigint(20) unsigned DEFAULT NULL,
`ss_active_users` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`ss_row_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `slot_roles`
--
DROP TABLE IF EXISTS `slot_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slot_roles` (
`role_id` smallint(6) NOT NULL AUTO_INCREMENT,
`role_name` varbinary(64) NOT NULL,
PRIMARY KEY (`role_id`),
UNIQUE KEY `role_name` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `slots`
--
DROP TABLE IF EXISTS `slots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slots` (
`slot_revision_id` bigint(20) unsigned NOT NULL,
`slot_role_id` smallint(5) unsigned NOT NULL,
`slot_content_id` bigint(20) unsigned NOT NULL,
`slot_origin` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`slot_revision_id`,`slot_role_id`),
KEY `slot_revision_origin_role` (`slot_revision_id`,`slot_origin`,`slot_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_concept_cache`
--
DROP TABLE IF EXISTS `smw_concept_cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_concept_cache` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned NOT NULL,
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_blob`
--
DROP TABLE IF EXISTS `smw_di_blob`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_blob` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_bool`
--
DROP TABLE IF EXISTS `smw_di_bool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_bool` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_value` tinyint(1) DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_value`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_coords`
--
DROP TABLE IF EXISTS `smw_di_coords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_coords` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_lat` double DEFAULT NULL,
`o_lon` double DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_serialized`),
KEY `o_lat` (`o_lat`,`o_lon`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_number`
--
DROP TABLE IF EXISTS `smw_di_number`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_number` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_time`
--
DROP TABLE IF EXISTS `smw_di_time`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_time` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_uri`
--
DROP TABLE IF EXISTS `smw_di_uri`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_uri` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_serialized` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_serialized`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_di_wikipage`
--
DROP TABLE IF EXISTS `smw_di_wikipage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_di_wikipage` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_ask`
--
DROP TABLE IF EXISTS `smw_fpt_ask`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_ask` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_askde`
--
DROP TABLE IF EXISTS `smw_fpt_askde`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_askde` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_askdu`
--
DROP TABLE IF EXISTS `smw_fpt_askdu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_askdu` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_askfo`
--
DROP TABLE IF EXISTS `smw_fpt_askfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_askfo` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_askpa`
--
DROP TABLE IF EXISTS `smw_fpt_askpa`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_askpa` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_asksi`
--
DROP TABLE IF EXISTS `smw_fpt_asksi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_asksi` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_askst`
--
DROP TABLE IF EXISTS `smw_fpt_askst`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_askst` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_conc`
--
DROP TABLE IF EXISTS `smw_fpt_conc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_conc` (
`s_id` int(8) unsigned NOT NULL,
`concept_txt` mediumblob,
`concept_docu` mediumblob,
`concept_features` int(11) DEFAULT NULL,
`concept_size` int(11) DEFAULT NULL,
`concept_depth` int(11) DEFAULT NULL,
`cache_date` int(8) unsigned DEFAULT NULL,
`cache_count` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_conv`
--
DROP TABLE IF EXISTS `smw_fpt_conv`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_conv` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_dtitle`
--
DROP TABLE IF EXISTS `smw_fpt_dtitle`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_dtitle` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_impo`
--
DROP TABLE IF EXISTS `smw_fpt_impo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_impo` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_inst`
--
DROP TABLE IF EXISTS `smw_fpt_inst`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_inst` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_lcode`
--
DROP TABLE IF EXISTS `smw_fpt_lcode`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_lcode` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_list`
--
DROP TABLE IF EXISTS `smw_fpt_list`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_list` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_mdat`
--
DROP TABLE IF EXISTS `smw_fpt_mdat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_mdat` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_pplb`
--
DROP TABLE IF EXISTS `smw_fpt_pplb`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_pplb` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_prec`
--
DROP TABLE IF EXISTS `smw_fpt_prec`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_prec` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_pval`
--
DROP TABLE IF EXISTS `smw_fpt_pval`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_pval` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_redi`
--
DROP TABLE IF EXISTS `smw_fpt_redi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_redi` (
`s_title` varbinary(255) NOT NULL,
`s_namespace` int(11) NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_title` (`s_title`,`s_namespace`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_serv`
--
DROP TABLE IF EXISTS `smw_fpt_serv`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_serv` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_sobj`
--
DROP TABLE IF EXISTS `smw_fpt_sobj`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_sobj` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_subc`
--
DROP TABLE IF EXISTS `smw_fpt_subc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_subc` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_subp`
--
DROP TABLE IF EXISTS `smw_fpt_subp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_subp` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_text`
--
DROP TABLE IF EXISTS `smw_fpt_text`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_text` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_type`
--
DROP TABLE IF EXISTS `smw_fpt_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_type` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_serialized` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_serialized` (`o_serialized`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_unit`
--
DROP TABLE IF EXISTS `smw_fpt_unit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_unit` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_hash` (`o_hash`),
KEY `s_id_2` (`s_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_fpt_uri`
--
DROP TABLE IF EXISTS `smw_fpt_uri`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_fpt_uri` (
`s_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_serialized` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_serialized` (`o_serialized`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_ft_search`
--
DROP TABLE IF EXISTS `smw_ft_search`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_ft_search` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_text` text,
`o_sort` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `p_id` (`p_id`),
KEY `o_sort` (`o_sort`),
FULLTEXT KEY `o_text` (`o_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_object_ids`
--
DROP TABLE IF EXISTS `smw_object_ids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_object_ids` (
`smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`smw_namespace` int(11) NOT NULL,
`smw_title` varbinary(255) NOT NULL,
`smw_iw` varbinary(32) NOT NULL,
`smw_subobject` varbinary(255) NOT NULL,
`smw_sortkey` varbinary(255) NOT NULL,
`smw_proptable_hash` mediumblob,
PRIMARY KEY (`smw_id`),
KEY `smw_id` (`smw_id`,`smw_sortkey`),
KEY `smw_iw` (`smw_iw`),
KEY `smw_title` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`),
KEY `smw_sortkey` (`smw_sortkey`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_prop_stats`
--
DROP TABLE IF EXISTS `smw_prop_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_prop_stats` (
`p_id` int(8) unsigned DEFAULT NULL,
`usage_count` int(8) unsigned DEFAULT NULL,
UNIQUE KEY `p_id` (`p_id`),
KEY `usage_count` (`usage_count`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `smw_query_links`
--
DROP TABLE IF EXISTS `smw_query_links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `smw_query_links` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned NOT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`),
KEY `s_id_2` (`s_id`,`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
/*!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_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ts_rc_id` int(11) DEFAULT NULL,
`ts_log_id` int(10) unsigned DEFAULT NULL,
`ts_rev_id` int(10) unsigned DEFAULT NULL,
`ts_tags` blob NOT NULL,
PRIMARY KEY (`ts_id`),
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 AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL DEFAULT '0',
`tl_namespace` int(11) NOT NULL DEFAULT '0',
`tl_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`tl_from_namespace` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`tl_from`,`tl_namespace`,`tl_title`),
KEY `tl_backlinks_namespace` (`tl_namespace`,`tl_title`,`tl_from_namespace`,`tl_from`),
KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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(8) unsigned NOT NULL AUTO_INCREMENT,
`old_namespace` tinyint(2) unsigned NOT NULL DEFAULT '0',
`old_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`old_text` mediumtext NOT NULL,
`old_comment` tinyblob NOT NULL,
`old_user` int(5) unsigned NOT NULL DEFAULT '0',
`old_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`old_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`old_minor_edit` tinyint(1) NOT NULL DEFAULT '0',
`old_flags` tinyblob NOT NULL,
`inverse_timestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
PRIMARY KEY (`old_id`),
KEY `old_namespace` (`old_namespace`,`old_title`(20)),
KEY `old_timestamp` (`old_timestamp`),
KEY `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`),
KEY `user_timestamp` (`old_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`old_user_text`,`inverse_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=49087 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `trackbacks`
--
DROP TABLE IF EXISTS `trackbacks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trackbacks` (
`tb_id` int(11) NOT NULL AUTO_INCREMENT,
`tb_page` int(11) DEFAULT NULL,
`tb_title` varchar(255) NOT NULL DEFAULT '',
`tb_url` varchar(255) NOT NULL DEFAULT '',
`tb_ex` text,
`tb_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`tb_id`),
KEY `tb_page` (`tb_page`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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` varchar(255) NOT NULL DEFAULT '',
`tc_contents` text,
`tc_time` binary(14) DEFAULT NULL,
PRIMARY KEY (`tc_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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=latin1;
/*!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_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','3D') 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,
`us_chunk_inx` int(10) unsigned DEFAULT NULL,
`us_props` blob,
PRIMARY KEY (`us_id`),
UNIQUE KEY `us_key` (`us_key`),
KEY `us_user` (`us_user`),
KEY `us_timestamp` (`us_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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(5) unsigned NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`user_password` tinyblob NOT NULL,
`user_newpassword` tinyblob NOT NULL,
`user_email` tinytext NOT NULL,
`user_touched` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`user_real_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`user_token` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`user_email_authenticated` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`user_email_token` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`user_email_token_expires` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`user_registration` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`user_newpass_time` binary(14) DEFAULT NULL,
`user_editcount` int(11) DEFAULT NULL,
`user_password_expires` varbinary(14) DEFAULT NULL,
UNIQUE KEY `user_id` (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
KEY `user_email_token` (`user_email_token`),
KEY `user_email` (`user_email`(50))
) ENGINE=MyISAM AUTO_INCREMENT=68734 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!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 '',
PRIMARY KEY (`ufg_user`,`ufg_group`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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(5) unsigned NOT NULL DEFAULT '0',
`ug_group` varbinary(255) NOT NULL DEFAULT '',
`ug_expiry` varbinary(14) DEFAULT NULL,
PRIMARY KEY (`ug_user`,`ug_group`),
KEY `ug_group` (`ug_group`),
KEY `ug_expiry` (`ug_expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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(10) unsigned NOT NULL DEFAULT '0',
`user_ip` varchar(40) NOT NULL DEFAULT '',
`user_last_timestamp` varbinary(14) DEFAULT NULL,
KEY `user_id` (`user_id`),
KEY `user_ip` (`user_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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(10) unsigned NOT NULL,
`up_property` varbinary(255) NOT NULL DEFAULT '',
`up_value` blob,
PRIMARY KEY (`up_user`,`up_property`),
KEY `user_properties_property` (`up_property`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `user_rights`
--
DROP TABLE IF EXISTS `user_rights`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_rights` (
`ur_user` int(5) unsigned NOT NULL DEFAULT '0',
`ur_rights` tinyblob NOT NULL,
UNIQUE KEY `ur_user` (`ur_user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!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=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `validate`
--
DROP TABLE IF EXISTS `validate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `validate` (
`val_user` int(11) NOT NULL DEFAULT '0',
`val_page` int(11) unsigned NOT NULL DEFAULT '0',
`val_revision` int(11) unsigned NOT NULL DEFAULT '0',
`val_type` int(11) unsigned NOT NULL DEFAULT '0',
`val_value` int(11) DEFAULT '0',
`val_comment` varchar(255) NOT NULL DEFAULT '',
`val_ip` varchar(20) NOT NULL DEFAULT '',
KEY `val_user` (`val_user`,`val_revision`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!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_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`wl_user` int(5) unsigned NOT NULL DEFAULT '0',
`wl_namespace` int(11) NOT NULL DEFAULT '0',
`wl_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`wl_notificationtimestamp` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
PRIMARY KEY (`wl_id`),
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=MyISAM AUTO_INCREMENT=5847 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*!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 2019-09-27 9:27:09

File Metadata

Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8041604
Default Alt Text
development-wiki-database-schema-1.32.0-2019-09-27.sql (86 KB)

Event Timeline