Difference between revisions of "Create a new mediawiki instance"
From Biowikifarm Metawiki
m (→Mysql copy/create wikidb: +syntaxhighlight) |
m (added Category:MediaWiki using HotCat) |
||
| (14 intermediate revisions by 5 users not shown) | |||
| Line 4: | Line 4: | ||
"XXX" is the example name of the new virtual wiki site. | "XXX" is the example name of the new virtual wiki site. | ||
| − | + | cd /var/www/ | |
| − | cd /var/www/ | + | sudo cp /var/www/v-ztemplate /var/www/v-XXX -pr |
| − | sudo cp /var/www/v-ztemplate /var/www/v-XXX -pr | + | sudo chown www-data:www-data /var/www/v-XXX/w/media/* -R |
| − | sudo chown www-data:www-data /var/www/v-XXX/w/media/* -R | + | cd /var/www/v-XXX/w/ |
| − | + | sudo chown root:mwadmin LocalSettings.php | |
| − | sudo chmod g+w | + | sudo chmod g+w LocalSettings.php |
| + | sudo chmod o+r LocalSettings.php | ||
# REM: for restoring existing wiki: | # REM: for restoring existing wiki: | ||
| Line 17: | Line 18: | ||
# sudo cp /home/ram/wikidump/images/* /var/www/v-filteredpush/w/media -pr | # sudo cp /home/ram/wikidump/images/* /var/www/v-filteredpush/w/media -pr | ||
# sudo chown www-data:www-data /var/www/v-filteredpush/w/media/* -R | # sudo chown www-data:www-data /var/www/v-filteredpush/w/media/* -R | ||
| − | |||
==Mysql copy/create wikidb== | ==Mysql copy/create wikidb== | ||
The sql created by phpmyadmin for creating (as example "filteredpushwiki" from z_en_template) is: | The sql created by phpmyadmin for creating (as example "filteredpushwiki" from z_en_template) is: | ||
| + | |||
| + | ALTERNATIVE TO SCRIPT BELOW IS: use phpmyadmin and copy the template DB! | ||
<syntaxhighlight lang="mysql" style="border-left:1px solid gray;padding-left:1em;"> | <syntaxhighlight lang="mysql" style="border-left:1px solid gray;padding-left:1em;"> | ||
| Line 715: | Line 717: | ||
GRANT SELECT , INSERT , UPDATE , DELETE , DROP , INDEX ,CREATE TEMPORARY TABLES ON `openmedia` . * TO 'wikiuser'@'localhost'; | GRANT SELECT , INSERT , UPDATE , DELETE , DROP , INDEX ,CREATE TEMPORARY TABLES ON `openmedia` . * TO 'wikiuser'@'localhost'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | |||
| + | Run database update.php: | ||
| + | cd /var/www/v-XXX/w; sudo -u www-data php ./maintenance/update.php --quick --conf ./LocalSettings.php | ||
| + | |||
| + | ==Update and test nginx config== | ||
| + | go to the nginx config (quick symlink in /var) and copy and modify a similar existing config. Test the config: | ||
| + | sudo nginx -t | ||
| + | # if ok, run: | ||
| + | sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart | ||
| + | |||
| + | [[Category:MediaWiki]] | ||
Latest revision as of 16:34, 10 November 2017
THESE ARE PRELIMINARY NOTES!
Contents
1. Copy the folder, using a template (here a template for 1.20)/create wikidb
"XXX" is the example name of the new virtual wiki site.
cd /var/www/ sudo cp /var/www/v-ztemplate /var/www/v-XXX -pr sudo chown www-data:www-data /var/www/v-XXX/w/media/* -R cd /var/www/v-XXX/w/ sudo chown root:mwadmin LocalSettings.php sudo chmod g+w LocalSettings.php sudo chmod o+r LocalSettings.php
- REM: for restoring existing wiki:
- REM db, e.g.: mysql -u root -p filteredpush < wikidb.dump
- where filteredpush is name of existing db to be overwritten
- REM images, e.g.:
- sudo cp /home/ram/wikidump/images/* /var/www/v-filteredpush/w/media -pr
- sudo chown www-data:www-data /var/www/v-filteredpush/w/media/* -R
Mysql copy/create wikidb
The sql created by phpmyadmin for creating (as example "filteredpushwiki" from z_en_template) is:
ALTERNATIVE TO SCRIPT BELOW IS: use phpmyadmin and copy the template DB!
CREATE DATABASE `filteredpushwiki` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE `filteredpushwiki`.`archive` ( `ar_namespace` int( 11 ) NOT NULL DEFAULT '0',
`ar_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`ar_text` mediumblob NOT NULL ,
`ar_comment` tinyblob NOT NULL ,
`ar_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ar_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`ar_timestamp` binary( 14 ) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ar_minor_edit` tinyint( 4 ) NOT NULL DEFAULT '0',
`ar_flags` tinyblob NOT NULL ,
`ar_rev_id` int( 10 ) unsigned DEFAULT NULL ,
`ar_text_id` int( 10 ) unsigned DEFAULT NULL ,
`ar_deleted` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`ar_len` int( 10 ) unsigned DEFAULT NULL ,
`ar_page_id` int( 10 ) unsigned DEFAULT NULL ,
`ar_parent_id` int( 10 ) unsigned DEFAULT NULL ,
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 = utf8;
INSERT INTO `filteredpushwiki`.`archive` SELECT * FROM `z_en_template`.`archive`;
CREATE TABLE `filteredpushwiki`.`category` ( `cat_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`cat_pages` int( 11 ) NOT NULL DEFAULT '0',
`cat_subcats` int( 11 ) NOT NULL DEFAULT '0',
`cat_files` int( 11 ) NOT NULL DEFAULT '0',
`cat_hidden` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( `cat_id` ) ,
UNIQUE KEY `cat_title` ( `cat_title` ) ,
KEY `cat_pages` ( `cat_pages` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`category` SELECT * FROM `z_en_template`.`category`;
CREATE TABLE `filteredpushwiki`.`categorylinks` ( `cl_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`cl_to` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`cl_sortkey` varbinary( 230 ) NOT NULL DEFAULT '',
`cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`cl_sortkey_prefix` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`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_timestamp` ( `cl_to` , `cl_timestamp` ) ,
KEY `cl_collation` ( `cl_collation` ) ,
KEY `cl_sortkey` ( `cl_to` , `cl_type` , `cl_sortkey` , `cl_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`categorylinks` SELECT * FROM `z_en_template`.`categorylinks`;
CREATE TABLE `filteredpushwiki`.`change_tag` ( `ct_rc_id` int( 11 ) DEFAULT NULL ,
`ct_log_id` int( 11 ) DEFAULT NULL ,
`ct_rev_id` int( 11 ) DEFAULT NULL ,
`ct_tag` varchar( 255 ) NOT NULL ,
`ct_params` blob,
UNIQUE KEY `change_tag_rc_tag` ( `ct_rc_id` , `ct_tag` ) ,
UNIQUE KEY `change_tag_log_tag` ( `ct_log_id` , `ct_tag` ) ,
UNIQUE KEY `change_tag_rev_tag` ( `ct_rev_id` , `ct_tag` ) ,
KEY `change_tag_tag_id` ( `ct_tag` , `ct_rc_id` , `ct_rev_id` , `ct_log_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`change_tag` SELECT * FROM `z_en_template`.`change_tag`;
CREATE TABLE `filteredpushwiki`.`config` ( `cf_name` varbinary( 255 ) NOT NULL ,
`cf_value` blob NOT NULL ,
PRIMARY KEY ( `cf_name` ) ,
KEY `cf_name_value` ( `cf_name` , `cf_value` ( 255 ) ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`config` SELECT * FROM `z_en_template`.`config`;
CREATE TABLE `filteredpushwiki`.`externallinks` ( `el_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`el_to` blob NOT NULL ,
`el_index` blob NOT NULL ,
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 = utf8;
INSERT INTO `filteredpushwiki`.`externallinks` SELECT * FROM `z_en_template`.`externallinks`;
CREATE TABLE `filteredpushwiki`.`external_user` ( `eu_local_id` int( 10 ) unsigned NOT NULL ,
`eu_external_id` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
PRIMARY KEY ( `eu_local_id` ) ,
UNIQUE KEY `eu_external_id` ( `eu_external_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`external_user` SELECT * FROM `z_en_template`.`external_user`;
CREATE TABLE `filteredpushwiki`.`filearchive` ( `fa_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`fa_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`fa_archive_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`fa_storage_group` varbinary( 16 ) DEFAULT NULL ,
`fa_storage_key` varbinary( 64 ) DEFAULT '',
`fa_deleted_user` int( 11 ) DEFAULT NULL ,
`fa_deleted_timestamp` binary( 14 ) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted_reason` text,
`fa_size` int( 10 ) unsigned DEFAULT '0',
`fa_width` int( 11 ) DEFAULT '0',
`fa_height` int( 11 ) DEFAULT '0',
`fa_metadata` mediumblob,
`fa_bits` int( 11 ) DEFAULT '0',
`fa_media_type` enum( 'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO', 'VIDEO', 'MULTIMEDIA', 'OFFICE', 'TEXT', 'EXECUTABLE', 'ARCHIVE' ) DEFAULT NULL ,
`fa_major_mime` enum( 'unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart' ) DEFAULT 'unknown',
`fa_minor_mime` varbinary( 100 ) DEFAULT 'unknown',
`fa_description` tinyblob,
`fa_user` int( 10 ) unsigned DEFAULT '0',
`fa_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL ,
`fa_timestamp` binary( 14 ) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
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` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`filearchive` SELECT * FROM `z_en_template`.`filearchive`;
CREATE TABLE `filteredpushwiki`.`globalimagelinks` ( `gil_wiki` varchar( 32 ) NOT NULL ,
`gil_page` int( 10 ) unsigned NOT NULL ,
`gil_page_namespace_id` int( 11 ) NOT NULL ,
`gil_page_namespace` varchar( 255 ) NOT NULL ,
`gil_page_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`gil_to` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
UNIQUE KEY `globalimagelinks_to_wiki_page` ( `gil_to` , `gil_wiki` , `gil_page` ) ,
KEY `globalimagelinks_wiki` ( `gil_wiki` , `gil_page` ) ,
KEY `globalimagelinks_wiki_nsid_title` ( `gil_wiki` , `gil_page_namespace_id` , `gil_page_title` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`globalimagelinks` SELECT * FROM `z_en_template`.`globalimagelinks`;
CREATE TABLE `filteredpushwiki`.`hitcounter` ( `hc_id` int( 10 ) unsigned NOT NULL ) ENGINE = MEMORY DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci MAX_ROWS =25000;
INSERT INTO `filteredpushwiki`.`hitcounter` SELECT * FROM `z_en_template`.`hitcounter`;
CREATE TABLE `filteredpushwiki`.`image` ( `img_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`img_size` int( 10 ) unsigned NOT NULL DEFAULT '0',
`img_width` int( 11 ) NOT NULL DEFAULT '0',
`img_height` int( 11 ) NOT NULL DEFAULT '0',
`img_metadata` mediumblob NOT NULL ,
`img_bits` int( 11 ) NOT NULL DEFAULT '0',
`img_media_type` enum( 'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO', 'VIDEO', 'MULTIMEDIA', 'OFFICE', 'TEXT', 'EXECUTABLE', 'ARCHIVE' ) DEFAULT NULL ,
`img_major_mime` enum( 'unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart' ) NOT NULL DEFAULT 'unknown',
`img_minor_mime` varbinary( 100 ) NOT NULL DEFAULT 'unknown',
`img_description` tinyblob NOT NULL ,
`img_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`img_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`img_timestamp` varbinary( 14 ) NOT NULL DEFAULT '',
`img_sha1` varbinary( 32 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `img_name` ) ,
KEY `img_usertext_timestamp` ( `img_user_text` , `img_timestamp` ) ,
KEY `img_size` ( `img_size` ) ,
KEY `img_timestamp` ( `img_timestamp` ) ,
KEY `img_sha1` ( `img_sha1` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`image` SELECT * FROM `z_en_template`.`image`;
CREATE TABLE `filteredpushwiki`.`imagelinks` ( `il_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`il_to` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
UNIQUE KEY `il_from` ( `il_from` , `il_to` ) ,
UNIQUE KEY `il_to` ( `il_to` , `il_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`imagelinks` SELECT * FROM `z_en_template`.`imagelinks`;
CREATE TABLE `filteredpushwiki`.`interwiki` ( `iw_prefix` varchar( 32 ) NOT NULL ,
`iw_url` blob NOT NULL ,
`iw_local` tinyint( 1 ) NOT NULL ,
`iw_trans` tinyint( 4 ) NOT NULL DEFAULT '0',
UNIQUE KEY `iw_prefix` ( `iw_prefix` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`interwiki` SELECT * FROM `z_en_template`.`interwiki`;
CREATE TABLE `filteredpushwiki`.`ipblocks` ( `ipb_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`ipb_address` tinyblob NOT NULL ,
`ipb_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ipb_by` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ipb_by_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`ipb_reason` tinyblob NOT NULL ,
`ipb_timestamp` binary( 14 ) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipb_auto` tinyint( 1 ) NOT NULL DEFAULT '0',
`ipb_anon_only` tinyint( 1 ) NOT NULL DEFAULT '0',
`ipb_create_account` tinyint( 1 ) NOT NULL DEFAULT '1',
`ipb_enable_autoblock` tinyint( 1 ) NOT NULL DEFAULT '1',
`ipb_expiry` varbinary( 14 ) NOT NULL DEFAULT '',
`ipb_range_start` tinyblob NOT NULL ,
`ipb_range_end` tinyblob NOT NULL ,
`ipb_deleted` tinyint( 1 ) NOT NULL DEFAULT '0',
`ipb_block_email` tinyint( 1 ) NOT NULL DEFAULT '0',
`ipb_allow_usertalk` tinyint( 1 ) NOT NULL DEFAULT '0',
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` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`ipblocks` SELECT * FROM `z_en_template`.`ipblocks`;
CREATE TABLE `filteredpushwiki`.`iwlinks` ( `iwl_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`iwl_prefix` varbinary( 20 ) NOT NULL DEFAULT '',
`iwl_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
UNIQUE KEY `iwl_from` ( `iwl_from` , `iwl_prefix` , `iwl_title` ) ,
UNIQUE KEY `iwl_prefix_title_from` ( `iwl_prefix` , `iwl_title` , `iwl_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`iwlinks` SELECT * FROM `z_en_template`.`iwlinks`;
CREATE TABLE `filteredpushwiki`.`job` ( `job_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`job_cmd` varbinary( 60 ) NOT NULL DEFAULT '',
`job_namespace` int( 11 ) NOT NULL ,
`job_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`job_params` blob NOT NULL ,
PRIMARY KEY ( `job_id` ) ,
KEY `job_cmd` ( `job_cmd` , `job_namespace` , `job_title` , `job_params` ( 128 ) ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`job` SELECT * FROM `z_en_template`.`job`;
CREATE TABLE `filteredpushwiki`.`l10n_cache` ( `lc_lang` varbinary( 32 ) NOT NULL ,
`lc_key` varchar( 255 ) NOT NULL ,
`lc_value` mediumblob NOT NULL ,
KEY `lc_lang_key` ( `lc_lang` , `lc_key` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`l10n_cache` SELECT * FROM `z_en_template`.`l10n_cache`;
CREATE TABLE `filteredpushwiki`.`langlinks` ( `ll_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ll_lang` varbinary( 20 ) NOT NULL DEFAULT '',
`ll_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
UNIQUE KEY `ll_from` ( `ll_from` , `ll_lang` ) ,
KEY `ll_lang` ( `ll_lang` , `ll_title` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`langlinks` SELECT * FROM `z_en_template`.`langlinks`;
CREATE TABLE `filteredpushwiki`.`logging` ( `log_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`log_type` varbinary( 32 ) NOT NULL DEFAULT '',
`log_action` varbinary( 32 ) NOT NULL DEFAULT '',
`log_timestamp` binary( 14 ) NOT NULL DEFAULT '19700101000000',
`log_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`log_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`log_namespace` int( 11 ) NOT NULL DEFAULT '0',
`log_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`log_page` int( 10 ) unsigned DEFAULT NULL ,
`log_comment` varchar( 255 ) NOT NULL DEFAULT '',
`log_params` blob NOT NULL ,
`log_deleted` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( `log_id` ) ,
KEY `type_time` ( `log_type` , `log_timestamp` ) ,
KEY `user_time` ( `log_user` , `log_timestamp` ) ,
KEY `page_time` ( `log_namespace` , `log_title` , `log_timestamp` ) ,
KEY `times` ( `log_timestamp` ) ,
KEY `log_user_type_time` ( `log_user` , `log_type` , `log_timestamp` ) ,
KEY `log_page_id_time` ( `log_page` , `log_timestamp` ) ,
KEY `type_action` ( `log_type` , `log_action` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`logging` SELECT * FROM `z_en_template`.`logging`;
CREATE TABLE `filteredpushwiki`.`log_search` ( `ls_field` varbinary( 32 ) NOT NULL ,
`ls_value` varchar( 255 ) NOT NULL ,
`ls_log_id` int( 10 ) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `ls_field_val` ( `ls_field` , `ls_value` , `ls_log_id` ) ,
KEY `ls_log_id` ( `ls_log_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`log_search` SELECT * FROM `z_en_template`.`log_search`;
CREATE TABLE `filteredpushwiki`.`math` ( `math_inputhash` varbinary( 16 ) NOT NULL ,
`math_outputhash` varbinary( 16 ) NOT NULL ,
`math_html_conservativeness` tinyint( 4 ) NOT NULL ,
`math_html` text,
`math_mathml` text,
UNIQUE KEY `math_inputhash` ( `math_inputhash` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`math` SELECT * FROM `z_en_template`.`math`;
CREATE TABLE `filteredpushwiki`.`module_deps` ( `md_module` varbinary( 255 ) NOT NULL ,
`md_skin` varbinary( 32 ) NOT NULL ,
`md_deps` mediumblob NOT NULL ,
UNIQUE KEY `md_module_skin` ( `md_module` , `md_skin` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`module_deps` SELECT * FROM `z_en_template`.`module_deps`;
CREATE TABLE `filteredpushwiki`.`msg_resource` ( `mr_resource` varbinary( 255 ) NOT NULL ,
`mr_lang` varbinary( 32 ) NOT NULL ,
`mr_blob` mediumblob NOT NULL ,
`mr_timestamp` binary( 14 ) NOT NULL ,
UNIQUE KEY `mr_resource_lang` ( `mr_resource` , `mr_lang` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`msg_resource` SELECT * FROM `z_en_template`.`msg_resource`;
CREATE TABLE `filteredpushwiki`.`msg_resource_links` ( `mrl_resource` varbinary( 255 ) NOT NULL ,
`mrl_message` varbinary( 255 ) NOT NULL ,
UNIQUE KEY `mrl_message_resource` ( `mrl_message` , `mrl_resource` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`msg_resource_links` SELECT * FROM `z_en_template`.`msg_resource_links`;
CREATE TABLE `filteredpushwiki`.`objectcache` ( `keyname` varbinary( 255 ) NOT NULL DEFAULT '',
`value` mediumblob,
`exptime` datetime DEFAULT NULL ,
PRIMARY KEY ( `keyname` ) ,
KEY `exptime` ( `exptime` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`objectcache` SELECT * FROM `z_en_template`.`objectcache`;
CREATE TABLE `filteredpushwiki`.`oldimage` ( `oi_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`oi_archive_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`oi_size` int( 10 ) unsigned NOT NULL DEFAULT '0',
`oi_width` int( 11 ) NOT NULL DEFAULT '0',
`oi_height` int( 11 ) NOT NULL DEFAULT '0',
`oi_bits` int( 11 ) NOT NULL DEFAULT '0',
`oi_description` tinyblob NOT NULL ,
`oi_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`oi_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`oi_timestamp` binary( 14 ) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`oi_metadata` mediumblob NOT NULL ,
`oi_media_type` enum( 'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO', 'VIDEO', 'MULTIMEDIA', 'OFFICE', 'TEXT', 'EXECUTABLE', 'ARCHIVE' ) DEFAULT NULL ,
`oi_major_mime` enum( 'unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart' ) 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` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`oldimage` SELECT * FROM `z_en_template`.`oldimage`;
CREATE TABLE `filteredpushwiki`.`page` ( `page_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`page_namespace` int( 11 ) NOT NULL ,
`page_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`page_restrictions` tinyblob NOT NULL ,
`page_counter` bigint( 20 ) unsigned NOT NULL DEFAULT '0',
`page_is_redirect` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`page_is_new` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`page_random` double unsigned NOT NULL ,
`page_touched` binary( 14 ) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`page_latest` int( 10 ) unsigned NOT NULL ,
`page_len` int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( `page_id` ) ,
UNIQUE KEY `name_title` ( `page_namespace` , `page_title` ) ,
KEY `page_random` ( `page_random` ) ,
KEY `page_len` ( `page_len` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;
INSERT INTO `filteredpushwiki`.`page` SELECT * FROM `z_en_template`.`page`;
CREATE TABLE `filteredpushwiki`.`pagelinks` ( `pl_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`pl_namespace` int( 11 ) NOT NULL DEFAULT '0',
`pl_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
UNIQUE KEY `pl_from` ( `pl_from` , `pl_namespace` , `pl_title` ) ,
UNIQUE KEY `pl_namespace` ( `pl_namespace` , `pl_title` , `pl_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`pagelinks` SELECT * FROM `z_en_template`.`pagelinks`;
CREATE TABLE `filteredpushwiki`.`page_props` ( `pp_page` int( 11 ) NOT NULL ,
`pp_propname` varbinary( 60 ) NOT NULL ,
`pp_value` blob NOT NULL ,
UNIQUE KEY `pp_page_propname` ( `pp_page` , `pp_propname` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`page_props` SELECT * FROM `z_en_template`.`page_props`;
CREATE TABLE `filteredpushwiki`.`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( 11 ) DEFAULT NULL ,
`pr_expiry` varbinary( 14 ) DEFAULT NULL ,
`pr_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `pr_id` ) ,
UNIQUE KEY `pr_pagetype` ( `pr_page` , `pr_type` ) ,
KEY `pr_typelevel` ( `pr_type` , `pr_level` ) ,
KEY `pr_level` ( `pr_level` ) ,
KEY `pr_cascade` ( `pr_cascade` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`page_restrictions` SELECT * FROM `z_en_template`.`page_restrictions`;
CREATE TABLE `filteredpushwiki`.`protected_titles` ( `pt_namespace` int( 11 ) NOT NULL ,
`pt_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`pt_user` int( 10 ) unsigned NOT NULL ,
`pt_reason` tinyblob,
`pt_timestamp` binary( 14 ) NOT NULL ,
`pt_expiry` varbinary( 14 ) NOT NULL DEFAULT '',
`pt_create_perm` varbinary( 60 ) NOT NULL ,
UNIQUE KEY `pt_namespace_title` ( `pt_namespace` , `pt_title` ) ,
KEY `pt_timestamp` ( `pt_timestamp` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`protected_titles` SELECT * FROM `z_en_template`.`protected_titles`;
CREATE TABLE `filteredpushwiki`.`querycache` ( `qc_type` varbinary( 32 ) NOT NULL ,
`qc_value` int( 10 ) unsigned NOT NULL DEFAULT '0',
`qc_namespace` int( 11 ) NOT NULL DEFAULT '0',
`qc_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
KEY `qc_type` ( `qc_type` , `qc_value` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`querycache` SELECT * FROM `z_en_template`.`querycache`;
CREATE TABLE `filteredpushwiki`.`querycachetwo` ( `qcc_type` varbinary( 32 ) NOT NULL ,
`qcc_value` int( 10 ) unsigned NOT NULL DEFAULT '0',
`qcc_namespace` int( 11 ) NOT NULL DEFAULT '0',
`qcc_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`qcc_namespacetwo` int( 11 ) NOT NULL DEFAULT '0',
`qcc_titletwo` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
KEY `qcc_type` ( `qcc_type` , `qcc_value` ) ,
KEY `qcc_title` ( `qcc_type` , `qcc_namespace` , `qcc_title` ) ,
KEY `qcc_titletwo` ( `qcc_type` , `qcc_namespacetwo` , `qcc_titletwo` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`querycachetwo` SELECT * FROM `z_en_template`.`querycachetwo`;
CREATE TABLE `filteredpushwiki`.`querycache_info` ( `qci_type` varbinary( 32 ) NOT NULL DEFAULT '',
`qci_timestamp` binary( 14 ) NOT NULL DEFAULT '19700101000000',
UNIQUE KEY `qci_type` ( `qci_type` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`querycache_info` SELECT * FROM `z_en_template`.`querycache_info`;
CREATE TABLE `filteredpushwiki`.`recentchanges` ( `rc_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`rc_timestamp` varbinary( 14 ) NOT NULL DEFAULT '',
`rc_cur_time` varbinary( 14 ) NOT NULL DEFAULT '',
`rc_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rc_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`rc_namespace` int( 11 ) NOT NULL DEFAULT '0',
`rc_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`rc_comment` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`rc_minor` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_bot` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_new` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_cur_id` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rc_this_oldid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rc_last_oldid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rc_type` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_moved_to_ns` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_moved_to_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`rc_patrolled` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_ip` varbinary( 40 ) NOT NULL DEFAULT '',
`rc_old_len` int( 11 ) DEFAULT NULL ,
`rc_new_len` int( 11 ) DEFAULT NULL ,
`rc_deleted` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rc_logid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rc_log_type` varbinary( 255 ) DEFAULT NULL ,
`rc_log_action` varbinary( 255 ) DEFAULT NULL ,
`rc_params` blob,
PRIMARY KEY ( `rc_id` ) ,
KEY `rc_timestamp` ( `rc_timestamp` ) ,
KEY `rc_namespace_title` ( `rc_namespace` , `rc_title` ) ,
KEY `rc_cur_id` ( `rc_cur_id` ) ,
KEY `new_name_timestamp` ( `rc_new` , `rc_namespace` , `rc_timestamp` ) ,
KEY `rc_ip` ( `rc_ip` ) ,
KEY `rc_ns_usertext` ( `rc_namespace` , `rc_user_text` ) ,
KEY `rc_user_text` ( `rc_user_text` , `rc_timestamp` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`recentchanges` SELECT * FROM `z_en_template`.`recentchanges`;
CREATE TABLE `filteredpushwiki`.`redirect` ( `rd_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rd_namespace` int( 11 ) NOT NULL DEFAULT '0',
`rd_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`rd_interwiki` varchar( 32 ) DEFAULT NULL ,
`rd_fragment` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL ,
PRIMARY KEY ( `rd_from` ) ,
KEY `rd_ns_title` ( `rd_namespace` , `rd_title` , `rd_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`redirect` SELECT * FROM `z_en_template`.`redirect`;
CREATE TABLE `filteredpushwiki`.`revision` ( `rev_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`rev_page` int( 10 ) unsigned NOT NULL ,
`rev_text_id` int( 10 ) unsigned NOT NULL ,
`rev_comment` tinyblob NOT NULL ,
`rev_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`rev_user_text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`rev_timestamp` binary( 14 ) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`rev_minor_edit` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rev_deleted` tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
`rev_len` int( 10 ) unsigned DEFAULT NULL ,
`rev_parent_id` int( 10 ) unsigned DEFAULT NULL ,
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` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 MAX_ROWS =10000000 AVG_ROW_LENGTH =1024 AUTO_INCREMENT =2;
INSERT INTO `filteredpushwiki`.`revision` SELECT * FROM `z_en_template`.`revision`;
CREATE TABLE `filteredpushwiki`.`searchindex` ( `si_page` int( 10 ) unsigned NOT NULL ,
`si_title` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`si_text` mediumtext COLLATE utf8_unicode_ci 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 COLLATE = utf8_unicode_ci;
INSERT INTO `filteredpushwiki`.`searchindex` SELECT * FROM `z_en_template`.`searchindex`;
CREATE TABLE `filteredpushwiki`.`site_stats` ( `ss_row_id` int( 10 ) unsigned NOT NULL ,
`ss_total_views` bigint( 20 ) unsigned DEFAULT '0',
`ss_total_edits` bigint( 20 ) unsigned DEFAULT '0',
`ss_good_articles` bigint( 20 ) unsigned DEFAULT '0',
`ss_total_pages` bigint( 20 ) DEFAULT '-1',
`ss_users` bigint( 20 ) DEFAULT '-1',
`ss_active_users` bigint( 20 ) DEFAULT '-1',
`ss_admins` int( 11 ) DEFAULT '-1',
`ss_images` int( 11 ) DEFAULT '0',
UNIQUE KEY `ss_row_id` ( `ss_row_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`site_stats` SELECT * FROM `z_en_template`.`site_stats`;
CREATE TABLE `filteredpushwiki`.`smw_atts2` ( `s_id` int( 8 ) unsigned NOT NULL ,
`p_id` int( 8 ) unsigned NOT NULL ,
`value_xsd` varbinary( 255 ) DEFAULT NULL ,
`value_num` double DEFAULT NULL ,
KEY `s_id` ( `s_id` ) ,
KEY `p_id` ( `p_id` ) ,
KEY `value_num` ( `value_num` ) ,
KEY `value_xsd` ( `value_xsd` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`smw_atts2` SELECT * FROM `z_en_template`.`smw_atts2`;
CREATE TABLE `filteredpushwiki`.`smw_conc2` ( `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 = utf8;
INSERT INTO `filteredpushwiki`.`smw_conc2` SELECT * FROM `z_en_template`.`smw_conc2`;
CREATE TABLE `filteredpushwiki`.`smw_conccache` ( `s_id` int( 8 ) unsigned NOT NULL ,
`o_id` int( 8 ) unsigned NOT NULL ,
KEY `o_id` ( `o_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`smw_conccache` SELECT * FROM `z_en_template`.`smw_conccache`;
CREATE TABLE `filteredpushwiki`.`smw_ids` ( `smw_id` int( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`smw_namespace` int( 11 ) NOT NULL ,
`smw_title` varbinary( 255 ) NOT NULL ,
`smw_iw` varchar( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`smw_subobject` varchar( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`smw_sortkey` varbinary( 255 ) NOT NULL ,
PRIMARY KEY ( `smw_id` ) ,
KEY `smw_title` ( `smw_title` , `smw_namespace` , `smw_iw` ) ,
KEY `smw_title_2` ( `smw_title` , `smw_namespace` , `smw_iw` , `smw_subobject` ) ,
KEY `smw_sortkey` ( `smw_sortkey` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`smw_ids` SELECT * FROM `z_en_template`.`smw_ids`;
CREATE TABLE `filteredpushwiki`.`smw_inst2` ( `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 = utf8;
INSERT INTO `filteredpushwiki`.`smw_inst2` SELECT * FROM `z_en_template`.`smw_inst2`;
CREATE TABLE `filteredpushwiki`.`smw_redi2` ( `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 = utf8;
INSERT INTO `filteredpushwiki`.`smw_redi2` SELECT * FROM `z_en_template`.`smw_redi2`;
CREATE TABLE `filteredpushwiki`.`smw_rels2` ( `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` ) ,
KEY `p_id` ( `p_id` ) ,
KEY `o_id` ( `o_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`smw_rels2` SELECT * FROM `z_en_template`.`smw_rels2`;
CREATE TABLE `filteredpushwiki`.`smw_spec2` ( `s_id` int( 8 ) unsigned NOT NULL ,
`p_id` int( 8 ) unsigned NOT NULL ,
`value_string` varbinary( 255 ) DEFAULT NULL ,
KEY `s_id` ( `s_id` ) ,
KEY `p_id` ( `p_id` ) ,
KEY `s_id_2` ( `s_id` , `p_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`smw_spec2` SELECT * FROM `z_en_template`.`smw_spec2`;
CREATE TABLE `filteredpushwiki`.`smw_subp2` ( `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 = utf8;
INSERT INTO `filteredpushwiki`.`smw_subp2` SELECT * FROM `z_en_template`.`smw_subp2`;
CREATE TABLE `filteredpushwiki`.`smw_subs2` ( `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 = utf8;
INSERT INTO `filteredpushwiki`.`smw_subs2` SELECT * FROM `z_en_template`.`smw_subs2`;
CREATE TABLE `filteredpushwiki`.`smw_text2` ( `s_id` int( 8 ) unsigned NOT NULL ,
`p_id` int( 8 ) unsigned NOT NULL ,
`value_blob` mediumblob,
KEY `s_id` ( `s_id` ) ,
KEY `p_id` ( `p_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`smw_text2` SELECT * FROM `z_en_template`.`smw_text2`;
CREATE TABLE `filteredpushwiki`.`sm_coords` ( `s_id` int( 8 ) unsigned NOT NULL ,
`p_id` int( 8 ) unsigned NOT NULL ,
`lat` double DEFAULT NULL ,
`lon` double DEFAULT NULL ,
KEY `s_id` ( `s_id` ) ,
KEY `p_id` ( `p_id` ) ,
KEY `lat` ( `lat` ) ,
KEY `lon` ( `lon` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`sm_coords` SELECT * FROM `z_en_template`.`sm_coords`;
CREATE TABLE `filteredpushwiki`.`tag_summary` ( `ts_rc_id` int( 11 ) DEFAULT NULL ,
`ts_log_id` int( 11 ) DEFAULT NULL ,
`ts_rev_id` int( 11 ) DEFAULT NULL ,
`ts_tags` blob NOT NULL ,
UNIQUE KEY `tag_summary_rc_id` ( `ts_rc_id` ) ,
UNIQUE KEY `tag_summary_log_id` ( `ts_log_id` ) ,
UNIQUE KEY `tag_summary_rev_id` ( `ts_rev_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`tag_summary` SELECT * FROM `z_en_template`.`tag_summary`;
CREATE TABLE `filteredpushwiki`.`templatelinks` ( `tl_from` int( 10 ) unsigned NOT NULL DEFAULT '0',
`tl_namespace` int( 11 ) NOT NULL DEFAULT '0',
`tl_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
UNIQUE KEY `tl_from` ( `tl_from` , `tl_namespace` , `tl_title` ) ,
UNIQUE KEY `tl_namespace` ( `tl_namespace` , `tl_title` , `tl_from` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`templatelinks` SELECT * FROM `z_en_template`.`templatelinks`;
CREATE TABLE `filteredpushwiki`.`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 = utf8 MAX_ROWS =10000000 AVG_ROW_LENGTH =10240 AUTO_INCREMENT =2;
INSERT INTO `filteredpushwiki`.`text` SELECT * FROM `z_en_template`.`text`;
CREATE TABLE `filteredpushwiki`.`titlekey` ( `tk_page` int( 10 ) unsigned NOT NULL ,
`tk_namespace` int( 11 ) NOT NULL ,
`tk_key` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
PRIMARY KEY ( `tk_page` ) ,
KEY `name_key` ( `tk_namespace` , `tk_key` ) ) ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
INSERT INTO `filteredpushwiki`.`titlekey` SELECT * FROM `z_en_template`.`titlekey`;
CREATE TABLE `filteredpushwiki`.`trackbacks` ( `tb_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`tb_page` int( 11 ) DEFAULT NULL ,
`tb_title` varchar( 255 ) NOT NULL ,
`tb_url` blob NOT NULL ,
`tb_ex` text,
`tb_name` varchar( 255 ) DEFAULT NULL ,
PRIMARY KEY ( `tb_id` ) ,
KEY `tb_page` ( `tb_page` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`trackbacks` SELECT * FROM `z_en_template`.`trackbacks`;
CREATE TABLE `filteredpushwiki`.`transcache` ( `tc_url` varbinary( 255 ) NOT NULL ,
`tc_contents` text,
`tc_time` binary( 14 ) DEFAULT NULL ,
UNIQUE KEY `tc_url_idx` ( `tc_url` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`transcache` SELECT * FROM `z_en_template`.`transcache`;
CREATE TABLE `filteredpushwiki`.`updatelog` ( `ul_key` varchar( 255 ) NOT NULL ,
`ul_value` blob,
PRIMARY KEY ( `ul_key` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`updatelog` SELECT * FROM `z_en_template`.`updatelog`;
CREATE TABLE `filteredpushwiki`.`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' ) DEFAULT NULL ,
`us_image_width` int( 10 ) unsigned DEFAULT NULL ,
`us_image_height` int( 10 ) unsigned DEFAULT NULL ,
`us_image_bits` smallint( 5 ) unsigned DEFAULT NULL ,
PRIMARY KEY ( `us_id` ) ,
UNIQUE KEY `us_key` ( `us_key` ) ,
KEY `us_user` ( `us_user` ) ,
KEY `us_timestamp` ( `us_timestamp` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
INSERT INTO `filteredpushwiki`.`uploadstash` SELECT * FROM `z_en_template`.`uploadstash`;
CREATE TABLE `filteredpushwiki`.`user` ( `user_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`user_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`user_real_name` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`user_password` tinyblob NOT NULL ,
`user_newpassword` tinyblob NOT NULL ,
`user_newpass_time` binary( 14 ) DEFAULT NULL ,
`user_email` tinytext NOT NULL ,
`user_options` blob 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 ,
PRIMARY KEY ( `user_id` ) ,
UNIQUE KEY `user_name` ( `user_name` ) ,
KEY `user_email_token` ( `user_email_token` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;
INSERT INTO `filteredpushwiki`.`user` SELECT * FROM `z_en_template`.`user`;
CREATE TABLE `filteredpushwiki`.`user_former_groups` ( `ufg_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ufg_group` varbinary( 16 ) NOT NULL DEFAULT '',
UNIQUE KEY `ufg_user_group` ( `ufg_user` , `ufg_group` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`user_former_groups` SELECT * FROM `z_en_template`.`user_former_groups`;
CREATE TABLE `filteredpushwiki`.`user_groups` ( `ug_user` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ug_group` varbinary( 16 ) NOT NULL DEFAULT '',
UNIQUE KEY `ug_user_group` ( `ug_user` , `ug_group` ) ,
KEY `ug_group` ( `ug_group` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`user_groups` SELECT * FROM `z_en_template`.`user_groups`;
CREATE TABLE `filteredpushwiki`.`user_newtalk` ( `user_id` int( 11 ) NOT NULL DEFAULT '0',
`user_ip` varbinary( 40 ) NOT NULL DEFAULT '',
`user_last_timestamp` varbinary( 14 ) DEFAULT NULL ,
KEY `user_id` ( `user_id` ) ,
KEY `user_ip` ( `user_ip` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`user_newtalk` SELECT * FROM `z_en_template`.`user_newtalk`;
CREATE TABLE `filteredpushwiki`.`user_openid` ( `uoi_openid` varchar( 255 ) COLLATE utf8_unicode_ci NOT NULL ,
`uoi_user` int( 5 ) unsigned NOT NULL ,
PRIMARY KEY ( `uoi_openid` ) ,
KEY `user_openid_user` ( `uoi_user` ) ) ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
INSERT INTO `filteredpushwiki`.`user_openid` SELECT * FROM `z_en_template`.`user_openid`;
CREATE TABLE `filteredpushwiki`.`user_properties` ( `up_user` int( 11 ) NOT NULL ,
`up_property` varbinary( 255 ) DEFAULT NULL ,
`up_value` blob,
UNIQUE KEY `user_properties_user_property` ( `up_user` , `up_property` ) ,
KEY `user_properties_property` ( `up_property` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`user_properties` SELECT * FROM `z_en_template`.`user_properties`;
CREATE TABLE `filteredpushwiki`.`valid_tag` ( `vt_tag` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `vt_tag` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`valid_tag` SELECT * FROM `z_en_template`.`valid_tag`;
CREATE TABLE `filteredpushwiki`.`watchlist` ( `wl_user` int( 10 ) unsigned NOT NULL ,
`wl_namespace` int( 11 ) NOT NULL DEFAULT '0',
`wl_title` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`wl_notificationtimestamp` varbinary( 14 ) DEFAULT NULL ,
UNIQUE KEY `wl_user` ( `wl_user` , `wl_namespace` , `wl_title` ) ,
KEY `namespace_title` ( `wl_namespace` , `wl_title` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `filteredpushwiki`.`watchlist` SELECT * FROM `z_en_template`.`watchlist`;
Mysql grant wikidb rights
-- DROP , INDEX ,CREATE TEMPORARY TABLES seems necessary only for Semantic MediaWiki Wikis or maybe only Semantic Forms
GRANT SELECT , INSERT , UPDATE , DELETE , DROP , INDEX ,CREATE TEMPORARY TABLES ON `openmedia` . * TO 'wikiuser'@'localhost';
Run database update.php:
cd /var/www/v-XXX/w; sudo -u www-data php ./maintenance/update.php --quick --conf ./LocalSettings.php
Update and test nginx config
go to the nginx config (quick symlink in /var) and copy and modify a similar existing config. Test the config:
sudo nginx -t # if ok, run: sudo /usr/sbin/apache2ctl -k graceful && sudo service nginx restart && sudo service php5-fpm restart
