diff options
Diffstat (limited to 'maintenance/build-intl-wiki.sql')
| -rw-r--r-- | maintenance/build-intl-wiki.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/maintenance/build-intl-wiki.sql b/maintenance/build-intl-wiki.sql new file mode 100644 index 00000000..f094c8b7 --- /dev/null +++ b/maintenance/build-intl-wiki.sql @@ -0,0 +1,31 @@ +-- Experimental: create shared international database +-- for new interlinking code. +-- + +CREATE DATABASE intl; + +GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* +TO wikiuser@'%' IDENTIFIED BY 'userpass'; +GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* +TO wikiuser@localhost IDENTIFIED BY 'userpass'; +GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* +TO wikiuser@localhost.localdomain IDENTIFIED BY 'userpass'; + +USE intl; + +CREATE TABLE ilinks ( + lang_from varchar(5) default NULL, + lang_to varchar(5) default NULL, + title_from tinyblob, + title_to tinyblob, + target_exists tinyint(1) default NULL +) TYPE=MyISAM; + +CREATE TABLE recentchanges ( + user_name tinyblob, + user_lang varchar(5) default NULL, + date timestamp(14) NOT NULL, + message tinyblob +) TYPE=MyISAM; + + |