summaryrefslogtreecommitdiff
path: root/maintenance/build-intl-wiki.sql
blob: f094c8b788fc4cca84b34d8ae94a08e097fd2838 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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;