Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
CREATE TABLE mytable_i18n (
2 
  id TEXT NOT NULL,
3 
  page_id varchar(100),
4 
  en text,
5 
  de text,
6 
  es text,
7 
  fr text,
8 
  it text
9 
);
10 
 
11 
CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (id(16), page_id);
12 
 
13 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_01", "calendar", "january", NULL, NULL, NULL, "gennaio");
14 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_02", "calendar", "february", NULL, NULL, NULL, "febbraio");
15 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_03", "calendar", "march", NULL, NULL, NULL, "marzo");
16 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_04", "calendar", "april", NULL, NULL, NULL, "aprile");
17 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_05", "calendar", "may", NULL, NULL, NULL, "maggio");
18 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_06", "calendar", "june", NULL, NULL, NULL, "giugno");
19 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_07", "calendar", "july", NULL, NULL, NULL, "luglio");
20 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_08", "calendar", "august", NULL, NULL, NULL, "agosto");
21 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_09", "calendar", "september", NULL, NULL, NULL, "settembre");
22 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_10", "calendar", "october", NULL, NULL, NULL, "ottobre");
23 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_11", "calendar", "november", NULL, NULL, NULL, "novembre");
24 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_12", "calendar", "december", NULL, NULL, NULL, "dicembre");
25 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_0", "calendar", "sunday", NULL, NULL, NULL, "domenica");
26 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_1", "calendar", "monday", NULL, NULL, NULL, "lunedì");
27 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_2", "calendar", "tuesday", NULL, NULL, NULL, "martedì");
28 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_3", "calendar", "wednesday", NULL, NULL, NULL, "mercoledì");
29 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_4", "calendar", "thursday", NULL, NULL, NULL, "giovedì");
30 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_5", "calendar", "friday", NULL, NULL, NULL, "venerdì");
31 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_6", "calendar", "saturday", NULL, NULL, NULL, "sabato");
32 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_english", NULL, "only english text", NULL, NULL, NULL, NULL);
33 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_italian", NULL, NULL, NULL, NULL, NULL, "testo solo in italiano");
34 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("hello_user", NULL, "hello &&user&&, today is &&weekday&&, &&day&&th &&month&& &&year&&", NULL, NULL, NULL, "ciao, &&user&&, oggi è il &&day&& &&month&& &&year&& (&&weekday&&)");
35 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("alone", "alone", "all alone", NULL, NULL, NULL, "solo soletto");
36 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("isempty", NULL, NULL, "this string is empty in English and Italian, but not in German!", NULL, NULL, NULL);
37 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", "in_page", "conflicting text - in page", NULL, NULL, NULL, "testo con conflitto - in page");
38 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", NULL, "conflicting text - Global", NULL, NULL, NULL, "testo con conflitto - globale");
39 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("page_id_vuoto", "", "string with empty page_id (i.e. NOT NULL)", NULL, NULL, NULL, "stringa con page_id vuoto ma non nullo");
40 
INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("test", NULL, "this is a test string", NULL, NULL, NULL, "stringa di prova");
41 
 
42 
 
43 
CREATE TABLE mytable_langs_avail (
44 
  id varchar(10) NOT NULL,
45 
  name varchar(200),
46 
  meta text,
47 
  error_text varchar(250),
48 
  encoding varchar(16) NOT NULL DEFAULT 'iso-8859-1'
49 
);
50 
 
51 
CREATE UNIQUE INDEX mytable_langs_avail_id_index ON mytable_langs_avail (id);
52 
 
53 
 
54 
INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("en", "english", "my meta info", "not available", "iso-8859-1");
55 
INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("de", "deutsch", "iso-8859-1", "kein Text auf Deutsch verfügbar", "iso-8859-1");
56 
INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("it", "italiano", "charset=iso-8859-1", "non disponibile", "iso-8859-1");