| 1 |
lars |
1 |
CREATE TABLE i18n_de (
|
|
|
2 |
string_id varchar(100) NOT NULL DEFAULT '',
|
|
|
3 |
page_id varchar(100) DEFAULT NULL,
|
|
|
4 |
string text,
|
|
|
5 |
UNIQUE KEY id (string_id,page_id)
|
|
|
6 |
);
|
|
|
7 |
|
|
|
8 |
CREATE TABLE i18n_en (
|
|
|
9 |
string_id varchar(100) NOT NULL DEFAULT '',
|
|
|
10 |
page_id varchar(100) DEFAULT NULL,
|
|
|
11 |
string text,
|
|
|
12 |
UNIQUE KEY id (string_id,page_id)
|
|
|
13 |
);
|
|
|
14 |
|
|
|
15 |
CREATE TABLE i18n_it (
|
|
|
16 |
string_id varchar(100) NOT NULL DEFAULT '',
|
|
|
17 |
page_id varchar(100) DEFAULT NULL,
|
|
|
18 |
string text,
|
|
|
19 |
UNIQUE KEY id (string_id,page_id)
|
|
|
20 |
);
|
|
|
21 |
|
|
|
22 |
INSERT INTO i18n_en (string_id, page_id, string) VALUES ('smallTest',NULL,'very small test');
|
|
|
23 |
INSERT INTO i18n_de (string_id, page_id, string) VALUES ('smallTest',NULL,'kinder');
|
|
|
24 |
INSERT INTO i18n_it (string_id, page_id, string) VALUES ('smallTest',NULL,'piccolissimo test');
|
|
|
25 |
|
|
|
26 |
|
|
|
27 |
CREATE TABLE langs_avail (
|
|
|
28 |
id varchar(10) NOT NULL DEFAULT '',
|
|
|
29 |
name varchar(200) DEFAULT NULL,
|
|
|
30 |
meta text,
|
|
|
31 |
error_text varchar(250) DEFAULT NULL,
|
|
|
32 |
encoding varchar(16) DEFAULT NULL,
|
|
|
33 |
UNIQUE KEY ID (id)
|
|
|
34 |
);
|
|
|
35 |
INSERT INTO langs_avail (id, name, meta, error_text, encoding) VALUES ('it','italiano','charset: UTF-8','non disponibile in Italiano','UTF-8');
|
|
|
36 |
INSERT INTO langs_avail (id, name, meta, error_text, encoding) VALUES ('en','english','my meta info','not available in English','UTF-8');
|
|
|
37 |
INSERT INTO langs_avail (id, name, meta, error_text, encoding) VALUES ('de','deutsch','charset: UTF-8','kein Text auf Deutsch verfügbar','UTF-8');
|