| Index: trunk/phase3/maintenance/build-intl-wiki.sql |
| — | — | @@ -1,31 +0,0 @@ |
| 2 | | - |
| 3 | | -CREATE DATABASE intl; |
| 4 | | - |
| 5 | | -GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* |
| 6 | | -TO wikiuser@'%' IDENTIFIED BY 'userpass'; |
| 7 | | -GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* |
| 8 | | -TO wikiuser@localhost IDENTIFIED BY 'userpass'; |
| 9 | | -GRANT DELETE,INSERT,SELECT,UPDATE ON intl.* |
| 10 | | -TO wikiuser@localhost.localdomain IDENTIFIED BY 'userpass'; |
| 11 | | - |
| 12 | | -USE intl; |
| 13 | | - |
| 14 | | -CREATE TABLE ilinks ( |
| 15 | | - lang_from varchar(5) default NULL, |
| 16 | | - lang_to varchar(5) default NULL, |
| 17 | | - title_from tinyblob, |
| 18 | | - title_to tinyblob, |
| 19 | | - target_exists tinyint(1) default NULL |
| 20 | | -) TYPE=MyISAM; |
| 21 | | - |
| 22 | | -CREATE TABLE recentchanges ( |
| 23 | | - user_name tinyblob, |
| 24 | | - user_lang varchar(5) default NULL, |
| 25 | | - date timestamp(14) NOT NULL, |
| 26 | | - message tinyblob |
| 27 | | -) TYPE=MyISAM; |
| 28 | | - |
| 29 | | - |