-- 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