Difference between revisions of "Create a new mediawiki instance"

From Biowikifarm Metawiki
Jump to: navigation, search
(Debugging)
m (added Category:MediaWiki using HotCat)
 
(3 intermediate revisions by 2 users not shown)
Line 22: Line 22:
  
 
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 725: Line 727:
 
  sudo /usr/sbin/apache2ctl -k graceful  && sudo service nginx restart && sudo service php5-fpm restart
 
  sudo /usr/sbin/apache2ctl -k graceful  && sudo service nginx restart && sudo service php5-fpm restart
  
===Debugging===
+
[[Category:MediaWiki]]
If it doesn't work, you can enable logging:
+
 
+
In LocalSettings.php, add:
+
$wgDebugLogFile = "$IP/debug.log";
+
 
+
In the wiki's directory, do
+
touch debug.log
+
chown www-data:www-data debug.log
+
 
+
To see log output, do
+
tail -n300 -f debug.log
+

Latest revision as of 16:34, 10 November 2017

THESE ARE PRELIMINARY NOTES!

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
  1. REM: for restoring existing wiki:
  2. REM db, e.g.: mysql -u root -p filteredpush < wikidb.dump
  3. where filteredpush is name of existing db to be overwritten
  4. REM images, e.g.:
  5. sudo cp /home/ram/wikidump/images/* /var/www/v-filteredpush/w/media -pr
  6. 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