root/trunk/midgard/tools/midrepository/i18n.sql

Revision 7101, 10.3 kB (checked in by bergius, 5 years ago)

Initial commit of the MidRepository? workflow extension
Issue number:
Obtained from:
Submitted by:
Reviewed by:

  • Property svn:eol-style set to native
  • Property svn:executable set to *
  • Property svn:keywords set to Author Date Id Revision
Line 
1 DROP TABLE cache;
2
3 CREATE TABLE article_i (
4   id int(11) NOT NULL auto_increment,
5   sid int(11) NOT NULL,
6   title varchar(255) NOT NULL default '',
7   abstract longtext NOT NULL,
8   content longtext NOT NULL,
9   author int(11) NOT NULL default '0',
10   created datetime NOT NULL default '0000-00-00 00:00:00',
11   url varchar(255) NOT NULL default '',
12   lang int(11) NOT NULL default '0',
13   sitegroup int(11) NOT NULL default '0',
14   PRIMARY KEY (id),
15   KEY sid (sid,lang),
16   KEY lang (lang)
17 );
18
19 CREATE TABLE element_i (
20   id int(11) NOT NULL auto_increment,
21   sid int(11) NOT NULL,
22   value longtext NOT NULL,
23   lang int(11) NOT NULL default '0',
24   sitegroup int(11) NOT NULL default '0',
25   PRIMARY KEY (id),
26   KEY sid (sid,lang),
27   KEY lang (lang)
28 );
29
30 CREATE TABLE page_i (
31   id int(11) NOT NULL auto_increment,
32   sid int(11) NOT NULL default '0',
33   title varchar(255) default NULL,
34   content longtext,
35   author int(11) NOT NULL default '0',
36   owner int(11) NOT NULL default '0',
37   lang int(11) NOT NULL default '0',
38   changed date NOT NULL default '0000-00-00',
39   sitegroup int(11) NOT NULL default '0',
40   PRIMARY KEY  (id),
41   KEY sid (sid,lang),
42   KEY lang (lang)
43 );
44
45 CREATE TABLE pageelement_i (
46   id int(11) NOT NULL auto_increment,
47   sid int(11) NOT NULL default '0',
48   value longtext NOT NULL,
49   lang int(11) NOT NULL default '0',
50   sitegroup int(11) NOT NULL default '0',
51   PRIMARY KEY (id),
52   KEY sid (sid,lang),
53   KEY lang (lang)
54 );
55
56 CREATE TABLE snippet_i (
57   id int(11) NOT NULL auto_increment,
58   sid int(11) NOT NULL,
59   code longtext NOT NULL,
60   doc longtext NOT NULL,
61   author longtext NOT NULL,
62   lang int(11) NOT NULL default '0',
63   sitegroup int(11) NOT NULL default '0',
64   PRIMARY KEY (id),
65   KEY sid (sid,lang),
66   KEY lang (lang)
67 )       ;
68
69 CREATE TABLE language (
70   id int(11) NOT NULL auto_increment,
71   code char(2),
72   name varchar(255),
73   sitegroup int(11) NOT NULL default '0',
74   PRIMARY KEY (id) 
75 );
76
77 CREATE TABLE cache (
78    id int DEFAULT '0' NOT NULL,
79    type int DEFAULT '0' NOT NULL,
80    style int DEFAULT '0' NOT NULL,
81    page int DEFAULT '0' NOT NULL,
82    sitegroup int DEFAULT '0' NOT NULL,
83    lang int DEFAULT '0' NOT NULL,
84    PRIMARY KEY (page,type,style,id,lang)
85 );
86
87 INSERT INTO article_i (sid, title, abstract, content, author, created, url, sitegroup) SELECT id, title, abstract, content, author, created, url, sitegroup FROM article;
88 INSERT INTO element_i (sid, value, sitegroup) SELECT id, value, sitegroup FROM element;
89 INSERT INTO page_i (sid, title, content, changed, sitegroup) SELECT id, title, content, changed, sitegroup FROM page;
90 INSERT INTO pageelement_i (sid, value, sitegroup) SELECT id, value, sitegroup FROM pageelement;
91 INSERT INTO snippet_i (sid, code, doc, author, sitegroup) SELECT id, code, doc, author, sitegroup FROM snippet;
92
93 ALTER TABLE article DROP title;
94 ALTER TABLE article DROP abstract;
95 ALTER TABLE article DROP content;
96 ALTER TABLE article DROP url;
97 ALTER TABLE element DROP value;
98 ALTER TABLE page DROP title;
99 ALTER TABLE page DROP content;
100 ALTER TABLE pageelement DROP value;
101 ALTER TABLE snippet DROP code;
102 ALTER TABLE snippet DROP doc;
103 ALTER TABLE snippet DROP author;
104
105 ALTER TABLE page ADD (owner int(11) NOT NULL default '0');
106 ALTER TABLE host ADD (lang int(11) NOT NULL default '0');
107 ALTER TABLE record_extension ADD (lang int(11) NOT NULL default '0');
108 ALTER TABLE blobs ADD (lang int(11) NOT NULL default '0');
109
110 INSERT INTO language VALUES (1,'aa','afar',0);
111 INSERT INTO language VALUES (2,'ab','abkhazian',0);
112 INSERT INTO language VALUES (3,'af','afrikaans',0);
113 INSERT INTO language VALUES (4,'am','amharic',0);
114 INSERT INTO language VALUES (5,'ar','arabic',0);
115 INSERT INTO language VALUES (6,'as','assamese',0);
116 INSERT INTO language VALUES (7,'ay','aymara',0);
117 INSERT INTO language VALUES (8,'az','azerbaijani',0);
118 INSERT INTO language VALUES (9,'ba','bashkir',0);
119 INSERT INTO language VALUES (10,'be','byelorussian',0);
120 INSERT INTO language VALUES (11,'bg','bulgarian',0);
121 INSERT INTO language VALUES (12,'bh','bihari',0);
122 INSERT INTO language VALUES (13,'bi','bislama',0);
123 INSERT INTO language VALUES (14,'bn','bengali',0);
124 INSERT INTO language VALUES (15,'bo','tibetan',0);
125 INSERT INTO language VALUES (16,'br','breton',0);
126 INSERT INTO language VALUES (17,'ca','catalan',0);
127 INSERT INTO language VALUES (18,'co','corsican',0);
128 INSERT INTO language VALUES (19,'cs','czech',0);
129 INSERT INTO language VALUES (20,'cy','welsh',0);
130 INSERT INTO language VALUES (21,'da','danish',0);
131 INSERT INTO language VALUES (22,'de','german',0);
132 INSERT INTO language VALUES (23,'dz','bhutani',0);
133 INSERT INTO language VALUES (24,'el','greek',0);
134 INSERT INTO language VALUES (25,'en','english',0);
135 INSERT INTO language VALUES (26,'eo','esperanto',0);
136 INSERT INTO language VALUES (27,'es','spanish',0);
137 INSERT INTO language VALUES (28,'et','estonian',0);
138 INSERT INTO language VALUES (29,'eu','basque',0);
139 INSERT INTO language VALUES (30,'fa','persian',0);
140 INSERT INTO language VALUES (31,'fi','finnish',0);
141 INSERT INTO language VALUES (32,'fj','fiji',0);
142 INSERT INTO language VALUES (33,'fo','faroese',0);
143 INSERT INTO language VALUES (34,'fr','french',0);
144 INSERT INTO language VALUES (35,'fy','frisian',0);
145 INSERT INTO language VALUES (36,'ga','irish',0);
146 INSERT INTO language VALUES (37,'gd','scots',0);
147 INSERT INTO language VALUES (38,'gl','galician',0);
148 INSERT INTO language VALUES (39,'gn','guarani',0);
149 INSERT INTO language VALUES (40,'gu','gujarati',0);
150 INSERT INTO language VALUES (41,'ha','hausa',0);
151 INSERT INTO language VALUES (42,'he','hebrew',0);
152 INSERT INTO language VALUES (43,'hi','hindi',0);
153 INSERT INTO language VALUES (44,'hr','croatian',0);
154 INSERT INTO language VALUES (45,'hu','hungarian',0);
155 INSERT INTO language VALUES (46,'hy','armenian',0);
156 INSERT INTO language VALUES (47,'ia','interlingua',0);
157 INSERT INTO language VALUES (48,'ie','interlingue',0);
158 INSERT INTO language VALUES (49,'ik','inupiak',0);
159 INSERT INTO language VALUES (50,'id','indonesian',0);
160 INSERT INTO language VALUES (51,'is','icelandic',0);
161 INSERT INTO language VALUES (52,'it','italian',0);
162 INSERT INTO language VALUES (53,'iu','inuktitut',0);
163 INSERT INTO language VALUES (54,'ja','japanese',0);
164 INSERT INTO language VALUES (55,'jv','javanese',0);
165 INSERT INTO language VALUES (56,'ka','georgian',0);
166 INSERT INTO language VALUES (57,'kk','kazakh',0);
167 INSERT INTO language VALUES (58,'kl','greenlandic',0);
168 INSERT INTO language VALUES (59,'km','cambodian',0);
169 INSERT INTO language VALUES (60,'kn','kannada',0);
170 INSERT INTO language VALUES (61,'ko','korean',0);
171 INSERT INTO language VALUES (62,'ks','kashmiri',0);
172 INSERT INTO language VALUES (63,'ku','kurdish',0);
173 INSERT INTO language VALUES (64,'ky','kirghiz',0);
174 INSERT INTO language VALUES (65,'la','latin',0);
175 INSERT INTO language VALUES (66,'ln','lingala',0);
176 INSERT INTO language VALUES (67,'lo','laothian',0);
177 INSERT INTO language VALUES (68,'lt','lithuanian',0);
178 INSERT INTO language VALUES (69,'lv','latvian',0);
179 INSERT INTO language VALUES (70,'mg','malagasy',0);
180 INSERT INTO language VALUES (71,'mi','maori',0);
181 INSERT INTO language VALUES (72,'mk','macedonian',0);
182 INSERT INTO language VALUES (73,'ml','malayalam',0);
183 INSERT INTO language VALUES (74,'mn','mongolian',0);
184 INSERT INTO language VALUES (75,'mo','moldavian',0);
185 INSERT INTO language VALUES (76,'mr','marathi',0);
186 INSERT INTO language VALUES (77,'ms','malay',0);
187 INSERT INTO language VALUES (78,'mt','maltese',0);
188 INSERT INTO language VALUES (79,'my','burmese',0);
189 INSERT INTO language VALUES (80,'na','nauru',0);
190 INSERT INTO language VALUES (81,'ne','nepali',0);
191 INSERT INTO language VALUES (82,'nl','dutch',0);
192 INSERT INTO language VALUES (83,'no','norwegian',0);
193 INSERT INTO language VALUES (84,'oc','occitan',0);
194 INSERT INTO language VALUES (85,'om','afan',0);
195 INSERT INTO language VALUES (86,'or','oriya',0);
196 INSERT INTO language VALUES (87,'pa','punjabi',0);
197 INSERT INTO language VALUES (88,'pl','polish',0);
198 INSERT INTO language VALUES (89,'ps','pashto',0);
199 INSERT INTO language VALUES (90,'pt','portuguese',0);
200 INSERT INTO language VALUES (91,'qu','quechua',0);
201 INSERT INTO language VALUES (92,'rm','rhaeto-romance',0);
202 INSERT INTO language VALUES (93,'rn','kurundi',0);
203 INSERT INTO language VALUES (94,'ro','romanian',0);
204 INSERT INTO language VALUES (95,'ru','russian',0);
205 INSERT INTO language VALUES (96,'rw','kinyarwanda',0);
206 INSERT INTO language VALUES (97,'sa','sanskrit',0);
207 INSERT INTO language VALUES (98,'sd','sindhi',0);
208 INSERT INTO language VALUES (99,'sg','sangho',0);
209 INSERT INTO language VALUES (100,'sh','serbo-croatian',0);
210 INSERT INTO language VALUES (101,'si','singhalese',0);
211 INSERT INTO language VALUES (102,'sk','slovak',0);
212 INSERT INTO language VALUES (103,'sl','slovenian',0);
213 INSERT INTO language VALUES (104,'sm','samoan',0);
214 INSERT INTO language VALUES (105,'sn','shona',0);
215 INSERT INTO language VALUES (106,'so','somali',0);
216 INSERT INTO language VALUES (107,'sq','albanian',0);
217 INSERT INTO language VALUES (108,'sr','serbian',0);
218 INSERT INTO language VALUES (109,'ss','siswati',0);
219 INSERT INTO language VALUES (110,'st','sesotho',0);
220 INSERT INTO language VALUES (111,'su','sundanese',0);
221 INSERT INTO language VALUES (112,'sv','swedish',0);
222 INSERT INTO language VALUES (113,'sw','swahili',0);
223 INSERT INTO language VALUES (114,'ta','tamil',0);
224 INSERT INTO language VALUES (115,'te','telugu',0);
225 INSERT INTO language VALUES (116,'tg','tajik',0);
226 INSERT INTO language VALUES (117,'th','thai',0);
227 INSERT INTO language VALUES (118,'ti','tigrinya',0);
228 INSERT INTO language VALUES (119,'tk','turkmen',0);
229 INSERT INTO language VALUES (120,'tl','tagalog',0);
230 INSERT INTO language VALUES (121,'tn','setswana',0);
231 INSERT INTO language VALUES (122,'to','tonga',0);
232 INSERT INTO language VALUES (123,'tr','turkish',0);
233 INSERT INTO language VALUES (124,'ts','tsonga',0);
234 INSERT INTO language VALUES (125,'tt','tatar',0);
235 INSERT INTO language VALUES (126,'tw','twi',0);
236 INSERT INTO language VALUES (127,'ug','uigur',0);
237 INSERT INTO language VALUES (128,'uk','ukrainian',0);
238 INSERT INTO language VALUES (129,'ur','urdu',0);
239 INSERT INTO language VALUES (130,'uz','uzbek',0);
240 INSERT INTO language VALUES (131,'vi','vietnamese',0);
241 INSERT INTO language VALUES (132,'vo','volapuk',0);
242 INSERT INTO language VALUES (133,'wo','wolof',0);
243 INSERT INTO language VALUES (134,'xh','xhosa',0);
244 INSERT INTO language VALUES (135,'yi','yiddish',0);
245 INSERT INTO language VALUES (136,'yo','yoruba',0);
246 INSERT INTO language VALUES (137,'za','zhuang',0);
247 INSERT INTO language VALUES (138,'zh','chinese',0);
248 INSERT INTO language VALUES (139,'zu','zulu',0);
249
Note: See TracBrowser for help on using the browser.