Difference between revisions of "Create a new mediawiki instance"

From Biowikifarm Metawiki
Jump to: navigation, search
(Created page with " ==Mysql copy/create wikidb== The sql created by phpmyadmin for creating (as example "filteredpushwiki" from z_en_template) is: CREATE DATABASE `filteredpushwiki` DEFAULT CH...")
 
Line 1: Line 1:
 +
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
 +
sudo chown root:mwadmin /var/www/v-filteredpush/w/LocalSettings.php
 +
sudo chmod g+w /var/www/v-filteredpush/w/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==
 
==Mysql copy/create wikidb==

Revision as of 00:45, 5 January 2013

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 sudo chown root:mwadmin /var/www/v-filteredpush/w/LocalSettings.php sudo chmod g+w /var/www/v-filteredpush/w/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:

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

GRANT SELECT , INSERT , UPDATE , DELETE ON  `filteredpushwiki` . * TO  'wikiuser'@'localhost';
Retrieved from "https://biowikifarm.net/metawiki/index.php?title=Create_a_new_mediawiki_instance&oldid=4231"