D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
softaculous
/
mw
/
Filename :
mw.sql
back
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `mediawiki1277` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]archive` -- CREATE TABLE `[[dbprefix]]archive` ( `ar_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ar_namespace` int(11) NOT NULL DEFAULT '0', `ar_title` varbinary(255) NOT NULL DEFAULT '', `ar_text` mediumblob NOT NULL, `ar_comment` varbinary(767) NOT NULL, `ar_user` int(10) unsigned NOT NULL DEFAULT '0', `ar_user_text` varbinary(255) NOT NULL, `ar_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `ar_minor_edit` tinyint(4) NOT NULL DEFAULT '0', `ar_flags` tinyblob NOT NULL, `ar_rev_id` int(10) unsigned DEFAULT NULL, `ar_text_id` int(10) unsigned DEFAULT NULL, `ar_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `ar_len` int(10) unsigned DEFAULT NULL, `ar_page_id` int(10) unsigned DEFAULT NULL, `ar_parent_id` int(10) unsigned DEFAULT NULL, `ar_sha1` varbinary(32) NOT NULL DEFAULT '', `ar_content_model` varbinary(32) DEFAULT NULL, `ar_content_format` varbinary(64) DEFAULT NULL, PRIMARY KEY (`ar_id`), KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`), KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`), KEY `ar_revid` (`ar_rev_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bot_passwords` -- CREATE TABLE `[[dbprefix]]bot_passwords` ( `bp_user` int(11) NOT NULL, `bp_app_id` varbinary(32) NOT NULL, `bp_password` tinyblob NOT NULL, `bp_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `bp_restrictions` blob NOT NULL, `bp_grants` blob NOT NULL, PRIMARY KEY (`bp_user`,`bp_app_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]category` -- CREATE TABLE `[[dbprefix]]category` ( `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cat_title` varbinary(255) NOT NULL, `cat_pages` int(11) NOT NULL DEFAULT '0', `cat_subcats` int(11) NOT NULL DEFAULT '0', `cat_files` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`cat_id`), UNIQUE KEY `cat_title` (`cat_title`), KEY `cat_pages` (`cat_pages`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]categorylinks` -- CREATE TABLE `[[dbprefix]]categorylinks` ( `cl_from` int(10) unsigned NOT NULL DEFAULT '0', `cl_to` varbinary(255) NOT NULL DEFAULT '', `cl_sortkey` varbinary(230) NOT NULL DEFAULT '', `cl_sortkey_prefix` varbinary(255) NOT NULL DEFAULT '', `cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `cl_collation` varbinary(32) NOT NULL DEFAULT '', `cl_type` enum('page','subcat','file') NOT NULL DEFAULT 'page', UNIQUE KEY `cl_from` (`cl_from`,`cl_to`), KEY `cl_sortkey` (`cl_to`,`cl_type`,`cl_sortkey`,`cl_from`), KEY `cl_timestamp` (`cl_to`,`cl_timestamp`), KEY `cl_collation_ext` (`cl_collation`,`cl_to`,`cl_type`,`cl_from`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]change_tag` -- CREATE TABLE `[[dbprefix]]change_tag` ( `ct_rc_id` int(11) DEFAULT NULL, `ct_log_id` int(11) DEFAULT NULL, `ct_rev_id` int(11) DEFAULT NULL, `ct_tag` varbinary(255) NOT NULL, `ct_params` blob, UNIQUE KEY `change_tag_rc_tag` (`ct_rc_id`,`ct_tag`), UNIQUE KEY `change_tag_log_tag` (`ct_log_id`,`ct_tag`), UNIQUE KEY `change_tag_rev_tag` (`ct_rev_id`,`ct_tag`), KEY `change_tag_tag_id` (`ct_tag`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]externallinks` -- CREATE TABLE `[[dbprefix]]externallinks` ( `el_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `el_from` int(10) unsigned NOT NULL DEFAULT '0', `el_to` blob NOT NULL, `el_index` blob NOT NULL, PRIMARY KEY (`el_id`), KEY `el_from` (`el_from`,`el_to`(40)), KEY `el_to` (`el_to`(60),`el_from`), KEY `el_index` (`el_index`(60)) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]filearchive` -- CREATE TABLE `[[dbprefix]]filearchive` ( `fa_id` int(11) NOT NULL AUTO_INCREMENT, `fa_name` varbinary(255) NOT NULL DEFAULT '', `fa_archive_name` varbinary(255) DEFAULT '', `fa_storage_group` varbinary(16) DEFAULT NULL, `fa_storage_key` varbinary(64) DEFAULT '', `fa_deleted_user` int(11) DEFAULT NULL, `fa_deleted_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `fa_deleted_reason` varbinary(767) DEFAULT '', `fa_size` int(10) unsigned DEFAULT '0', `fa_width` int(11) DEFAULT '0', `fa_height` int(11) DEFAULT '0', `fa_metadata` mediumblob, `fa_bits` int(11) DEFAULT '0', `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL, `fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') DEFAULT 'unknown', `fa_minor_mime` varbinary(100) DEFAULT 'unknown', `fa_description` varbinary(767) DEFAULT NULL, `fa_user` int(10) unsigned DEFAULT '0', `fa_user_text` varbinary(255) DEFAULT NULL, `fa_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `fa_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `fa_sha1` varbinary(32) NOT NULL DEFAULT '', PRIMARY KEY (`fa_id`), KEY `fa_name` (`fa_name`,`fa_timestamp`), KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`), KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`), KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`), KEY `fa_sha1` (`fa_sha1`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]image` -- CREATE TABLE `[[dbprefix]]image` ( `img_name` varbinary(255) NOT NULL DEFAULT '', `img_size` int(10) unsigned NOT NULL DEFAULT '0', `img_width` int(11) NOT NULL DEFAULT '0', `img_height` int(11) NOT NULL DEFAULT '0', `img_metadata` mediumblob NOT NULL, `img_bits` int(11) NOT NULL DEFAULT '0', `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL, `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') NOT NULL DEFAULT 'unknown', `img_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown', `img_description` varbinary(767) NOT NULL, `img_user` int(10) unsigned NOT NULL DEFAULT '0', `img_user_text` varbinary(255) NOT NULL, `img_timestamp` varbinary(14) NOT NULL DEFAULT '', `img_sha1` varbinary(32) NOT NULL DEFAULT '', PRIMARY KEY (`img_name`), KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`), KEY `img_size` (`img_size`), KEY `img_timestamp` (`img_timestamp`), KEY `img_sha1` (`img_sha1`(10)), KEY `img_media_mime` (`img_media_type`,`img_major_mime`,`img_minor_mime`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]imagelinks` -- CREATE TABLE `[[dbprefix]]imagelinks` ( `il_from` int(10) unsigned NOT NULL DEFAULT '0', `il_from_namespace` int(11) NOT NULL DEFAULT '0', `il_to` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `il_from` (`il_from`,`il_to`), KEY `il_to` (`il_to`,`il_from`), KEY `il_backlinks_namespace` (`il_from_namespace`,`il_to`,`il_from`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]interwiki` -- CREATE TABLE `[[dbprefix]]interwiki` ( `iw_prefix` varbinary(32) NOT NULL, `iw_url` blob NOT NULL, `iw_api` blob NOT NULL, `iw_wikiid` varbinary(64) NOT NULL, `iw_local` tinyint(1) NOT NULL, `iw_trans` tinyint(4) NOT NULL DEFAULT '0', UNIQUE KEY `iw_prefix` (`iw_prefix`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -- Dumping data for table `[[dbprefix]]interwiki` -- INSERT INTO `[[dbprefix]]interwiki` VALUES ('acronym', 'http://www.acronymfinder.com/~/search/af.aspx?string=exact&Acronym=$1', '', '', 0, 0), ('advogato', 'http://www.advogato.org/$1', '', '', 0, 0), ('arxiv', 'http://www.arxiv.org/abs/$1', '', '', 0, 0), ('c2find', 'http://c2.com/cgi/wiki?FindPage&value=$1', '', '', 0, 0), ('cache', 'http://www.google.com/search?q=cache:$1', '', '', 0, 0), ('commons', 'https://commons.wikimedia.org/wiki/$1', 'https://commons.wikimedia.org/w/api.php', '', 0, 0), ('dictionary', 'http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1', '', '', 0, 0), ('docbook', 'http://wiki.docbook.org/$1', '', '', 0, 0), ('doi', 'http://dx.doi.org/$1', '', '', 0, 0), ('drumcorpswiki', 'http://www.drumcorpswiki.com/$1', 'http://drumcorpswiki.com/api.php', '', 0, 0), ('dwjwiki', 'http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1', '', '', 0, 0), ('elibre', 'http://enciclopedia.us.es/index.php/$1', 'http://enciclopedia.us.es/api.php', '', 0, 0), ('emacswiki', 'http://www.emacswiki.org/cgi-bin/wiki.pl?$1', '', '', 0, 0), ('foldoc', 'http://foldoc.org/?$1', '', '', 0, 0), ('foxwiki', 'http://fox.wikis.com/wc.dll?Wiki~$1', '', '', 0, 0), ('freebsdman', 'http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1', '', '', 0, 0), ('gej', 'http://www.esperanto.de/dej.malnova/aktivikio.pl?$1', '', '', 0, 0), ('gentoo-wiki', 'http://gentoo-wiki.com/$1', '', '', 0, 0), ('google', 'http://www.google.com/search?q=$1', '', '', 0, 0), ('googlegroups', 'http://groups.google.com/groups?q=$1', '', '', 0, 0), ('hammondwiki', 'http://www.dairiki.org/HammondWiki/$1', '', '', 0, 0), ('hrwiki', 'http://www.hrwiki.org/wiki/$1', 'http://www.hrwiki.org/w/api.php', '', 0, 0), ('imdb', 'http://www.imdb.com/find?q=$1&tt=on', '', '', 0, 0), ('jargonfile', 'http://sunir.org/apps/meta.pl?wiki=JargonFile&redirect=$1', '', '', 0, 0), ('kmwiki', 'http://kmwiki.wikispaces.com/$1', '', '', 0, 0), ('linuxwiki', 'http://linuxwiki.de/$1', '', '', 0, 0), ('lojban', 'http://www.lojban.org/tiki/tiki-index.php?page=$1', '', '', 0, 0), ('lqwiki', 'http://wiki.linuxquestions.org/wiki/$1', '', '', 0, 0), ('lugkr', 'http://www.lug-kr.de/wiki/$1', '', '', 0, 0), ('meatball', 'http://www.usemod.com/cgi-bin/mb.pl?$1', '', '', 0, 0), ('mediawikiwiki', 'https://www.mediawiki.org/wiki/$1', 'https://www.mediawiki.org/w/api.php', '', 0, 0), ('mediazilla', 'https://bugzilla.wikimedia.org/$1', '', '', 0, 0), ('memoryalpha', 'http://en.memory-alpha.org/wiki/$1', 'http://en.memory-alpha.org/api.php', '', 0, 0), ('metawiki', 'http://sunir.org/apps/meta.pl?$1', '', '', 0, 0), ('metawikimedia', 'https://meta.wikimedia.org/wiki/$1', 'https://meta.wikimedia.org/w/api.php', '', 0, 0), ('mozillawiki', 'http://wiki.mozilla.org/$1', 'https://wiki.mozilla.org/api.php', '', 0, 0), ('mw', 'https://www.mediawiki.org/wiki/$1', 'https://www.mediawiki.org/w/api.php', '', 0, 0), ('oeis', 'http://oeis.org/$1', '', '', 0, 0), ('openwiki', 'http://openwiki.com/ow.asp?$1', '', '', 0, 0), ('ppr', 'http://c2.com/cgi/wiki?$1', '', '', 0, 0), ('pythoninfo', 'http://wiki.python.org/moin/$1', '', '', 0, 0), ('rfc', 'http://www.rfc-editor.org/rfc/rfc$1.txt', '', '', 0, 0), ('s23wiki', 'http://s23.org/wiki/$1', 'http://s23.org/w/api.php', '', 0, 0), ('seattlewireless', 'http://seattlewireless.net/$1', '', '', 0, 0), ('senseislibrary', 'http://senseis.xmp.net/?$1', '', '', 0, 0), ('shoutwiki', 'http://www.shoutwiki.com/wiki/$1', 'http://www.shoutwiki.com/w/api.php', '', 0, 0), ('sourcewatch', 'http://www.sourcewatch.org/index.php?title=$1', 'http://www.sourcewatch.org/api.php', '', 0, 0), ('squeak', 'http://wiki.squeak.org/squeak/$1', '', '', 0, 0), ('tejo', 'http://www.tejo.org/vikio/$1', '', '', 0, 0), ('theopedia', 'http://www.theopedia.com/$1', '', '', 0, 0), ('tmbw', 'http://www.tmbw.net/wiki/$1', 'http://tmbw.net/wiki/api.php', '', 0, 0), ('tmnet', 'http://www.technomanifestos.net/?$1', '', '', 0, 0), ('twiki', 'http://twiki.org/cgi-bin/view/$1', '', '', 0, 0), ('uea', 'http://uea.org/vikio/index.php/$1', 'http://uea.org/vikio/api.php', '', 0, 0), ('uncyclopedia', 'http://en.uncyclopedia.co/wiki/$1', 'http://en.uncyclopedia.co/w/api.php', '', 0, 0), ('unreal', 'http://wiki.beyondunreal.com/$1', 'http://wiki.beyondunreal.com/w/api.php', '', 0, 0), ('usemod', 'http://www.usemod.com/cgi-bin/wiki.pl?$1', '', '', 0, 0), ('webseitzwiki', 'http://webseitz.fluxent.com/wiki/$1', '', '', 0, 0), ('wiki', 'http://c2.com/cgi/wiki?$1', '', '', 0, 0), ('wikia', 'http://www.wikia.com/wiki/$1', '', '', 0, 0), ('wikibooks', 'https://en.wikibooks.org/wiki/$1', 'https://en.wikibooks.org/w/api.php', '', 0, 0), ('wikif1', 'http://www.wikif1.org/$1', '', '', 0, 0), ('wikihow', 'http://www.wikihow.com/$1', 'http://www.wikihow.com/api.php', '', 0, 0), ('wikimedia', 'https://wikimediafoundation.org/wiki/$1', 'https://wikimediafoundation.org/w/api.php', '', 0, 0), ('wikinews', 'https://en.wikinews.org/wiki/$1', 'https://en.wikinews.org/w/api.php', '', 0, 0), ('wikinfo', 'http://wikinfo.co/English/index.php/$1', '', '', 0, 0), ('wikipedia', 'https://en.wikipedia.org/wiki/$1', 'https://en.wikipedia.org/w/api.php', '', 0, 0), ('wikiquote', 'https://en.wikiquote.org/wiki/$1', 'https://en.wikiquote.org/w/api.php', '', 0, 0), ('wikisource', 'https://wikisource.org/wiki/$1', 'https://wikisource.org/w/api.php', '', 0, 0), ('wikispecies', 'https://species.wikimedia.org/wiki/$1', 'https://species.wikimedia.org/w/api.php', '', 0, 0), ('wikiversity', 'https://en.wikiversity.org/wiki/$1', 'https://en.wikiversity.org/w/api.php', '', 0, 0), ('wikivoyage', 'https://en.wikivoyage.org/wiki/$1', 'https://en.wikivoyage.org/w/api.php', '', 0, 0), ('wikt', 'https://en.wiktionary.org/wiki/$1', 'https://en.wiktionary.org/w/api.php', '', 0, 0), ('wiktionary', 'https://en.wiktionary.org/wiki/$1', 'https://en.wiktionary.org/w/api.php', '', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]ipblocks` -- CREATE TABLE `[[dbprefix]]ipblocks` ( `ipb_id` int(11) NOT NULL AUTO_INCREMENT, `ipb_address` tinyblob NOT NULL, `ipb_user` int(10) unsigned NOT NULL DEFAULT '0', `ipb_by` int(10) unsigned NOT NULL DEFAULT '0', `ipb_by_text` varbinary(255) NOT NULL DEFAULT '', `ipb_reason` varbinary(767) NOT NULL, `ipb_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `ipb_auto` tinyint(1) NOT NULL DEFAULT '0', `ipb_anon_only` tinyint(1) NOT NULL DEFAULT '0', `ipb_create_account` tinyint(1) NOT NULL DEFAULT '1', `ipb_enable_autoblock` tinyint(1) NOT NULL DEFAULT '1', `ipb_expiry` varbinary(14) NOT NULL DEFAULT '', `ipb_range_start` tinyblob NOT NULL, `ipb_range_end` tinyblob NOT NULL, `ipb_deleted` tinyint(1) NOT NULL DEFAULT '0', `ipb_block_email` tinyint(1) NOT NULL DEFAULT '0', `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '0', `ipb_parent_block_id` int(11) DEFAULT NULL, PRIMARY KEY (`ipb_id`), UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`), KEY `ipb_user` (`ipb_user`), KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)), KEY `ipb_timestamp` (`ipb_timestamp`), KEY `ipb_expiry` (`ipb_expiry`), KEY `ipb_parent_block_id` (`ipb_parent_block_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]iwlinks` -- CREATE TABLE `[[dbprefix]]iwlinks` ( `iwl_from` int(10) unsigned NOT NULL DEFAULT '0', `iwl_prefix` varbinary(20) NOT NULL DEFAULT '', `iwl_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `iwl_from` (`iwl_from`,`iwl_prefix`,`iwl_title`), KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`), KEY `iwl_prefix_from_title` (`iwl_prefix`,`iwl_from`,`iwl_title`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]job` -- CREATE TABLE `[[dbprefix]]job` ( `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `job_cmd` varbinary(60) NOT NULL DEFAULT '', `job_namespace` int(11) NOT NULL, `job_title` varbinary(255) NOT NULL, `job_timestamp` varbinary(14) DEFAULT NULL, `job_params` blob NOT NULL, `job_random` int(10) unsigned NOT NULL DEFAULT '0', `job_attempts` int(10) unsigned NOT NULL DEFAULT '0', `job_token` varbinary(32) NOT NULL DEFAULT '', `job_token_timestamp` varbinary(14) DEFAULT NULL, `job_sha1` varbinary(32) NOT NULL DEFAULT '', PRIMARY KEY (`job_id`), KEY `job_sha1` (`job_sha1`), KEY `job_cmd_token` (`job_cmd`,`job_token`,`job_random`), KEY `job_cmd_token_id` (`job_cmd`,`job_token`,`job_id`), KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`,`job_params`(128)), KEY `job_timestamp` (`job_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]l10n_cache` -- CREATE TABLE `[[dbprefix]]l10n_cache` ( `lc_lang` varbinary(32) NOT NULL, `lc_key` varbinary(255) NOT NULL, `lc_value` mediumblob NOT NULL, KEY `lc_lang_key` (`lc_lang`,`lc_key`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]langlinks` -- CREATE TABLE `[[dbprefix]]langlinks` ( `ll_from` int(10) unsigned NOT NULL DEFAULT '0', `ll_lang` varbinary(20) NOT NULL DEFAULT '', `ll_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`), KEY `ll_lang` (`ll_lang`,`ll_title`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]logging` -- CREATE TABLE `[[dbprefix]]logging` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `log_type` varbinary(32) NOT NULL DEFAULT '', `log_action` varbinary(32) NOT NULL DEFAULT '', `log_timestamp` binary(14) NOT NULL DEFAULT '19700101000000', `log_user` int(10) unsigned NOT NULL DEFAULT '0', `log_user_text` varbinary(255) NOT NULL DEFAULT '', `log_namespace` int(11) NOT NULL DEFAULT '0', `log_title` varbinary(255) NOT NULL DEFAULT '', `log_page` int(10) unsigned DEFAULT NULL, `log_comment` varbinary(767) NOT NULL DEFAULT '', `log_params` blob NOT NULL, `log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`log_id`), KEY `type_time` (`log_type`,`log_timestamp`), KEY `user_time` (`log_user`,`log_timestamp`), KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`), KEY `times` (`log_timestamp`), KEY `log_user_type_time` (`log_user`,`log_type`,`log_timestamp`), KEY `log_page_id_time` (`log_page`,`log_timestamp`), KEY `type_action` (`log_type`,`log_action`,`log_timestamp`), KEY `log_user_text_type_time` (`log_user_text`,`log_type`,`log_timestamp`), KEY `log_user_text_time` (`log_user_text`,`log_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_search` -- CREATE TABLE `[[dbprefix]]log_search` ( `ls_field` varbinary(32) NOT NULL, `ls_value` varbinary(255) NOT NULL, `ls_log_id` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `ls_field_val` (`ls_field`,`ls_value`,`ls_log_id`), KEY `ls_log_id` (`ls_log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]module_deps` -- CREATE TABLE `[[dbprefix]]module_deps` ( `md_module` varbinary(255) NOT NULL, `md_skin` varbinary(32) NOT NULL, `md_deps` mediumblob NOT NULL, UNIQUE KEY `md_module_skin` (`md_module`,`md_skin`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]objectcache` -- CREATE TABLE `[[dbprefix]]objectcache` ( `keyname` varbinary(255) NOT NULL DEFAULT '', `value` mediumblob, `exptime` datetime DEFAULT NULL, PRIMARY KEY (`keyname`), KEY `exptime` (`exptime`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -- Dumping data for table `[[dbprefix]]objectcache` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]oldimage` -- CREATE TABLE `[[dbprefix]]oldimage` ( `oi_name` varbinary(255) NOT NULL DEFAULT '', `oi_archive_name` varbinary(255) NOT NULL DEFAULT '', `oi_size` int(10) unsigned NOT NULL DEFAULT '0', `oi_width` int(11) NOT NULL DEFAULT '0', `oi_height` int(11) NOT NULL DEFAULT '0', `oi_bits` int(11) NOT NULL DEFAULT '0', `oi_description` varbinary(767) NOT NULL, `oi_user` int(10) unsigned NOT NULL DEFAULT '0', `oi_user_text` varbinary(255) NOT NULL, `oi_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `oi_metadata` mediumblob NOT NULL, `oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL, `oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') NOT NULL DEFAULT 'unknown', `oi_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown', `oi_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `oi_sha1` varbinary(32) NOT NULL DEFAULT '', KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`), KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`), KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)), KEY `oi_sha1` (`oi_sha1`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]page` -- CREATE TABLE `[[dbprefix]]page` ( `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `page_namespace` int(11) NOT NULL, `page_title` varbinary(255) NOT NULL, `page_restrictions` tinyblob NOT NULL, `page_is_redirect` tinyint(3) unsigned NOT NULL DEFAULT '0', `page_is_new` tinyint(3) unsigned NOT NULL DEFAULT '0', `page_random` double unsigned NOT NULL, `page_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `page_links_updated` varbinary(14) DEFAULT NULL, `page_latest` int(10) unsigned NOT NULL, `page_len` int(10) unsigned NOT NULL, `page_content_model` varbinary(32) DEFAULT NULL, `page_lang` varbinary(35) DEFAULT NULL, PRIMARY KEY (`page_id`), UNIQUE KEY `name_title` (`page_namespace`,`page_title`), KEY `page_random` (`page_random`), KEY `page_len` (`page_len`), KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]page` -- INSERT INTO `[[dbprefix]]page` VALUES (1, 0, 'Main_Page', '', 0, 1, [[page_random]], '[[touched]]', NULL, 1, 687, 'wikitext', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]pagelinks` -- CREATE TABLE `[[dbprefix]]pagelinks` ( `pl_from` int(10) unsigned NOT NULL DEFAULT '0', `pl_from_namespace` int(11) NOT NULL DEFAULT '0', `pl_namespace` int(11) NOT NULL DEFAULT '0', `pl_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`), KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`), KEY `pl_backlinks_namespace` (`pl_from_namespace`,`pl_namespace`,`pl_title`,`pl_from`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]page_props` -- CREATE TABLE `[[dbprefix]]page_props` ( `pp_page` int(11) NOT NULL, `pp_propname` varbinary(60) NOT NULL, `pp_value` blob NOT NULL, `pp_sortkey` float DEFAULT NULL, UNIQUE KEY `pp_page_propname` (`pp_page`,`pp_propname`), UNIQUE KEY `pp_propname_page` (`pp_propname`,`pp_page`), UNIQUE KEY `pp_propname_sortkey_page` (`pp_propname`,`pp_sortkey`,`pp_page`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]page_restrictions` -- CREATE TABLE `[[dbprefix]]page_restrictions` ( `pr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pr_page` int(11) NOT NULL, `pr_type` varbinary(60) NOT NULL, `pr_level` varbinary(60) NOT NULL, `pr_cascade` tinyint(4) NOT NULL, `pr_user` int(11) DEFAULT NULL, `pr_expiry` varbinary(14) DEFAULT NULL, PRIMARY KEY (`pr_id`), UNIQUE KEY `pr_pagetype` (`pr_page`,`pr_type`), KEY `pr_typelevel` (`pr_type`,`pr_level`), KEY `pr_level` (`pr_level`), KEY `pr_cascade` (`pr_cascade`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]protected_titles` -- CREATE TABLE `[[dbprefix]]protected_titles` ( `pt_namespace` int(11) NOT NULL, `pt_title` varbinary(255) NOT NULL, `pt_user` int(10) unsigned NOT NULL, `pt_reason` varbinary(767) DEFAULT NULL, `pt_timestamp` binary(14) NOT NULL, `pt_expiry` varbinary(14) NOT NULL DEFAULT '', `pt_create_perm` varbinary(60) NOT NULL, UNIQUE KEY `pt_namespace_title` (`pt_namespace`,`pt_title`), KEY `pt_timestamp` (`pt_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]querycache` -- CREATE TABLE `[[dbprefix]]querycache` ( `qc_type` varbinary(32) NOT NULL, `qc_value` int(10) unsigned NOT NULL DEFAULT '0', `qc_namespace` int(11) NOT NULL DEFAULT '0', `qc_title` varbinary(255) NOT NULL DEFAULT '', KEY `qc_type` (`qc_type`,`qc_value`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]querycachetwo` -- CREATE TABLE `[[dbprefix]]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` varbinary(255) NOT NULL DEFAULT '', `qcc_namespacetwo` int(11) NOT NULL DEFAULT '0', `qcc_titletwo` varbinary(255) 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=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]querycache_info` -- CREATE TABLE `[[dbprefix]]querycache_info` ( `qci_type` varbinary(32) NOT NULL DEFAULT '', `qci_timestamp` binary(14) NOT NULL DEFAULT '19700101000000', UNIQUE KEY `qci_type` (`qci_type`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]recentchanges` -- CREATE TABLE `[[dbprefix]]recentchanges` ( `rc_id` int(11) NOT NULL AUTO_INCREMENT, `rc_timestamp` varbinary(14) NOT NULL DEFAULT '', `rc_user` int(10) unsigned NOT NULL DEFAULT '0', `rc_user_text` varbinary(255) NOT NULL, `rc_namespace` int(11) NOT NULL DEFAULT '0', `rc_title` varbinary(255) NOT NULL DEFAULT '', `rc_comment` varbinary(767) NOT NULL DEFAULT '', `rc_minor` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_bot` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_new` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_cur_id` int(10) unsigned NOT NULL DEFAULT '0', `rc_this_oldid` int(10) unsigned NOT NULL DEFAULT '0', `rc_last_oldid` int(10) unsigned NOT NULL DEFAULT '0', `rc_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_source` varbinary(16) NOT NULL DEFAULT '', `rc_patrolled` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_ip` varbinary(40) NOT NULL DEFAULT '', `rc_old_len` int(11) DEFAULT NULL, `rc_new_len` int(11) DEFAULT NULL, `rc_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `rc_logid` int(10) unsigned NOT NULL DEFAULT '0', `rc_log_type` varbinary(255) DEFAULT NULL, `rc_log_action` varbinary(255) DEFAULT NULL, `rc_params` blob, PRIMARY KEY (`rc_id`), KEY `rc_timestamp` (`rc_timestamp`), KEY `rc_namespace_title` (`rc_namespace`,`rc_title`), KEY `rc_cur_id` (`rc_cur_id`), KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`), KEY `rc_ip` (`rc_ip`), KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`), KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]redirect` -- CREATE TABLE `[[dbprefix]]redirect` ( `rd_from` int(10) unsigned NOT NULL DEFAULT '0', `rd_namespace` int(11) NOT NULL DEFAULT '0', `rd_title` varbinary(255) NOT NULL DEFAULT '', `rd_interwiki` varbinary(32) DEFAULT NULL, `rd_fragment` varbinary(255) DEFAULT NULL, PRIMARY KEY (`rd_from`), KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]revision` -- CREATE TABLE `[[dbprefix]]revision` ( `rev_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `rev_page` int(10) unsigned NOT NULL, `rev_text_id` int(10) unsigned NOT NULL, `rev_comment` varbinary(767) NOT NULL, `rev_user` int(10) unsigned NOT NULL DEFAULT '0', `rev_user_text` varbinary(255) NOT NULL DEFAULT '', `rev_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `rev_minor_edit` tinyint(3) unsigned NOT NULL DEFAULT '0', `rev_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', `rev_len` int(10) unsigned DEFAULT NULL, `rev_parent_id` int(10) unsigned DEFAULT NULL, `rev_sha1` varbinary(32) NOT NULL DEFAULT '', `rev_content_model` varbinary(32) DEFAULT NULL, `rev_content_format` varbinary(64) DEFAULT NULL, PRIMARY KEY (`rev_id`), UNIQUE KEY `rev_page_id` (`rev_page`,`rev_id`), KEY `rev_timestamp` (`rev_timestamp`), KEY `page_timestamp` (`rev_page`,`rev_timestamp`), KEY `user_timestamp` (`rev_user`,`rev_timestamp`), KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`), KEY `page_user_timestamp` (`rev_page`,`rev_user`,`rev_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary MAX_ROWS=10000000 AVG_ROW_LENGTH=1024 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]revision` -- INSERT INTO `[[dbprefix]]revision` VALUES (1, 1, 1, '', 0, 'MediaWiki default', '[[touched]]', 0, 0, 687, 0, 'd8wxfy88z1e4to5a0a0iwrfhw943fet', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]searchindex` -- CREATE TABLE `[[dbprefix]]searchindex` ( `si_page` int(10) unsigned NOT NULL, `si_title` varchar(255) NOT NULL DEFAULT '', `si_text` mediumtext NOT NULL, UNIQUE KEY `si_page` (`si_page`), FULLTEXT KEY `si_title` (`si_title`), FULLTEXT KEY `si_text` (`si_text`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sites` -- CREATE TABLE `[[dbprefix]]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` varbinary(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=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_identifiers` -- CREATE TABLE `[[dbprefix]]site_identifiers` ( `si_site` int(10) unsigned NOT NULL, `si_type` varbinary(32) NOT NULL, `si_key` varbinary(32) NOT NULL, UNIQUE KEY `site_ids_type` (`si_type`,`si_key`), KEY `site_ids_site` (`si_site`), KEY `site_ids_key` (`si_key`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_stats` -- CREATE TABLE `[[dbprefix]]site_stats` ( `ss_row_id` int(10) unsigned NOT NULL, `ss_total_edits` bigint(20) unsigned DEFAULT '0', `ss_good_articles` bigint(20) unsigned DEFAULT '0', `ss_total_pages` bigint(20) DEFAULT '-1', `ss_users` bigint(20) DEFAULT '-1', `ss_active_users` bigint(20) DEFAULT '-1', `ss_images` int(11) DEFAULT '0', UNIQUE KEY `ss_row_id` (`ss_row_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -- Dumping data for table `[[dbprefix]]site_stats` -- INSERT INTO `[[dbprefix]]site_stats` VALUES (1, 0, 0, 0, 1, -1, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tag_summary` -- CREATE TABLE `[[dbprefix]]tag_summary` ( `ts_rc_id` int(11) DEFAULT NULL, `ts_log_id` int(11) DEFAULT NULL, `ts_rev_id` int(11) DEFAULT NULL, `ts_tags` blob NOT NULL, UNIQUE KEY `tag_summary_rc_id` (`ts_rc_id`), UNIQUE KEY `tag_summary_log_id` (`ts_log_id`), UNIQUE KEY `tag_summary_rev_id` (`ts_rev_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]templatelinks` -- CREATE TABLE `[[dbprefix]]templatelinks` ( `tl_from` int(10) unsigned NOT NULL DEFAULT '0', `tl_from_namespace` int(11) NOT NULL DEFAULT '0', `tl_namespace` int(11) NOT NULL DEFAULT '0', `tl_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`), KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`), KEY `tl_backlinks_namespace` (`tl_from_namespace`,`tl_namespace`,`tl_title`,`tl_from`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]text` -- CREATE TABLE `[[dbprefix]]text` ( `old_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `old_text` mediumblob NOT NULL, `old_flags` tinyblob NOT NULL, PRIMARY KEY (`old_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary MAX_ROWS=10000000 AVG_ROW_LENGTH=10240 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]text` -- INSERT INTO `[[dbprefix]]text` VALUES (1, '<strong>MediaWiki has been installed.</strong>\n\nConsult the [//meta.wikimedia.org/wiki/Help:Contents User''s Guide] for information on using the wiki software.\n\n== Getting started ==\n* [//www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]\n* [//www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]\n* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]\n* [//www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]\n* [//www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]', 'utf-8'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]transcache` -- CREATE TABLE `[[dbprefix]]transcache` ( `tc_url` varbinary(255) NOT NULL, `tc_contents` blob, `tc_time` binary(14) NOT NULL, UNIQUE KEY `tc_url_idx` (`tc_url`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]updatelog` -- CREATE TABLE `[[dbprefix]]updatelog` ( `ul_key` varbinary(255) NOT NULL, `ul_value` blob, PRIMARY KEY (`ul_key`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -- Dumping data for table `[[dbprefix]]updatelog` -- INSERT INTO `[[dbprefix]]updatelog` VALUES ('filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql', NULL), ('image-img_major_mime-patch-img_major_mime-chemical.sql', NULL), ('oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', NULL), ('user_former_groups-ufg_group-patch-ufg_group-length-increase-255.sql', NULL), ('user_groups-ug_group-patch-ug_group-length-increase-255.sql', NULL), ('user_properties-up_property-patch-up_property.sql', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]uploadstash` -- CREATE TABLE `[[dbprefix]]uploadstash` ( `us_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `us_user` int(10) unsigned NOT NULL, `us_key` varbinary(255) NOT NULL, `us_orig_path` varbinary(255) NOT NULL, `us_path` varbinary(255) NOT NULL, `us_source_type` varbinary(50) DEFAULT NULL, `us_timestamp` varbinary(14) NOT NULL, `us_status` varbinary(50) NOT NULL, `us_chunk_inx` int(10) unsigned DEFAULT NULL, `us_props` blob, `us_size` int(10) unsigned NOT NULL, `us_sha1` varbinary(31) NOT NULL, `us_mime` varbinary(255) DEFAULT NULL, `us_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL, `us_image_width` int(10) unsigned DEFAULT NULL, `us_image_height` int(10) unsigned DEFAULT NULL, `us_image_bits` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`us_id`), UNIQUE KEY `us_key` (`us_key`), KEY `us_user` (`us_user`), KEY `us_timestamp` (`us_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user` -- CREATE TABLE `[[dbprefix]]user` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_name` varbinary(255) NOT NULL DEFAULT '', `user_real_name` varbinary(255) NOT NULL DEFAULT '', `user_password` tinyblob NOT NULL, `user_newpassword` tinyblob NOT NULL, `user_newpass_time` binary(14) DEFAULT NULL, `user_email` tinyblob NOT NULL, `user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `user_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `user_email_authenticated` binary(14) DEFAULT NULL, `user_email_token` binary(32) DEFAULT NULL, `user_email_token_expires` binary(14) DEFAULT NULL, `user_registration` binary(14) DEFAULT NULL, `user_editcount` int(11) DEFAULT NULL, `user_password_expires` varbinary(14) DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`), KEY `user_email_token` (`user_email_token`), KEY `user_email` (`user_email`(50)) ) ENGINE=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user` -- INSERT INTO `[[dbprefix]]user` VALUES (1, '[[admin_username]]', '', '[[admin_pass]]', '', NULL, '[[wiki_mail]]', '[[touched]]', '[[token]]', NULL, NULL, NULL, '[[touched]]', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_former_groups` -- CREATE TABLE `[[dbprefix]]user_former_groups` ( `ufg_user` int(10) unsigned NOT NULL DEFAULT '0', `ufg_group` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `ufg_user_group` (`ufg_user`,`ufg_group`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_groups` -- CREATE TABLE `[[dbprefix]]user_groups` ( `ug_user` int(10) unsigned NOT NULL DEFAULT '0', `ug_group` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `ug_user_group` (`ug_user`,`ug_group`), KEY `ug_group` (`ug_group`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -- Dumping data for table `[[dbprefix]]user_groups` -- INSERT INTO `[[dbprefix]]user_groups` VALUES (1, 'bureaucrat'), (1, 'sysop'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_newtalk` -- CREATE TABLE `[[dbprefix]]user_newtalk` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `user_ip` varbinary(40) NOT NULL DEFAULT '', `user_last_timestamp` varbinary(14) DEFAULT NULL, KEY `user_id` (`user_id`), KEY `user_ip` (`user_ip`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_properties` -- CREATE TABLE `[[dbprefix]]user_properties` ( `up_user` int(11) NOT NULL, `up_property` varbinary(255) NOT NULL, `up_value` blob, UNIQUE KEY `user_properties_user_property` (`up_user`,`up_property`), KEY `user_properties_property` (`up_property`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]valid_tag` -- CREATE TABLE `[[dbprefix]]valid_tag` ( `vt_tag` varbinary(255) NOT NULL, PRIMARY KEY (`vt_tag`) ) ENGINE=InnoDB DEFAULT CHARSET=binary; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]watchlist` -- CREATE TABLE `[[dbprefix]]watchlist` ( `wl_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `wl_user` int(10) unsigned NOT NULL, `wl_namespace` int(11) NOT NULL DEFAULT '0', `wl_title` varbinary(255) NOT NULL DEFAULT '', `wl_notificationtimestamp` varbinary(14) 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=InnoDB DEFAULT CHARSET=binary AUTO_INCREMENT=1 ; /*!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 */;