blob: 700fc4e0326ce5703e178be85c5031937ac8dff0 [file] [log] [blame]
droy27e97e02007-11-27 16:44:19 +00001-- MySQL dump 10.10
2--
3-- Host: localhost Database: babelstg
4-- ------------------------------------------------------
5-- Server version 5.0.18
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
droyd0a9b1a2008-01-29 19:51:46 +000018DROP TABLE IF EXISTS event_log;
droy3e7f3a82007-11-29 19:35:51 +000019CREATE TABLE `event_log` (
20 `event_id` int(10) unsigned NOT NULL auto_increment,
21 `table_name` varchar(100) NOT NULL,
22 `key_name` varchar(100) NOT NULL,
23 `key_value` varchar(100) default NULL,
24 `action` varchar(100) NOT NULL,
25 `userid` mediumint(9) NOT NULL,
26 `created_on` datetime NOT NULL,
27 PRIMARY KEY (`event_id`)
28) ENGINE=MyISAM DEFAULT CHARSET=utf8;
droy27e97e02007-11-27 16:44:19 +000029
droy5d4b64c2008-02-29 15:22:10 +000030DROP TABLE IF EXISTS `file_progress`;
31CREATE TABLE `file_progress` (
32 `file_id` int(10) unsigned NOT NULL,
33 `language_id` smallint(5) unsigned NOT NULL,
34 `pct_complete` float NOT NULL,
35 PRIMARY KEY (`file_id`, `language_id`),
36 CONSTRAINT `file_progress_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `files` (`file_id`) ON UPDATE CASCADE ON DELETE CASCADE,
37 CONSTRAINT `file_progress_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`language_id`) ON UPDATE CASCADE ON DELETE CASCADE
38) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
droy27e97e02007-11-27 16:44:19 +000040DROP TABLE IF EXISTS `files`;
41CREATE TABLE `files` (
droye5c99812007-11-28 21:36:51 +000042 `file_id` int(10) unsigned NOT NULL auto_increment,
droy27e97e02007-11-27 16:44:19 +000043 `project_id` varchar(100) NOT NULL,
droyb9c2cb12008-10-08 13:58:14 +000044 `plugin_id` varchar(100) NOT NULL,
droy44cb1ba2007-12-18 15:19:34 +000045 `version` varchar(64) NOT NULL,
droy27e97e02007-11-27 16:44:19 +000046 `name` text NOT NULL,
47 `is_active` tinyint(3) unsigned NOT NULL default '1',
48 PRIMARY KEY (`file_id`),
49 KEY `project_id` (`project_id`),
droyc081e862007-11-30 16:37:35 +000050 CONSTRAINT `files_ibfk_1` FOREIGN KEY (`project_id`,`version`) REFERENCES `project_versions` (`project_id`,`version`) ON UPDATE CASCADE
droy27e97e02007-11-27 16:44:19 +000051) ENGINE=InnoDB DEFAULT CHARSET=utf8;
droy0757c2c2009-03-31 19:37:36 +000052
53
54SET @OLD_SQL_MODE=@@SQL_MODE;
55DELIMITER ;;
56/*!50003 SET SESSION SQL_MODE="" */;;
57DROP TRIGGER IF EXISTS `upd_is_active`;;
58
59/* This trigger will recursively update the is_active status of the strings of a file */
60CREATE TRIGGER `upd_is_active` AFTER UPDATE ON `files` FOR EACH ROW BEGIN
61 UPDATE strings set is_active = NEW.is_active WHERE strings.file_id = NEW.file_id;
62
63 /* update project_progress table to indicate this proj/lang/vers stats are stale */
64 /* don't know if record is there or not, so do both an insert and an update */
droy2251ca92010-01-20 14:08:49 +000065 /* This portion of the trigger is similar to what is in the translations table */
66 SET @PROJECT=(SELECT project_id FROM files WHERE file_id = NEW.file_id);
67 SET @VERSION=(SELECT version FROM files WHERE file_id = NEW.file_id);
68
droy0757c2c2009-03-31 19:37:36 +000069 UPDATE IGNORE project_progress SET is_stale = 1 where project_id = @PROJECT
droy2251ca92010-01-20 14:08:49 +000070 AND version = @VERSION;
droy0757c2c2009-03-31 19:37:36 +000071END;
72;;
73DELIMITER ;
74/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
75
76
droy27e97e02007-11-27 16:44:19 +000077--
78-- Table structure for table `languages`
79--
80
81DROP TABLE IF EXISTS `languages`;
82CREATE TABLE `languages` (
83 `language_id` smallint(5) unsigned NOT NULL auto_increment,
droyc94a4522008-02-05 15:36:53 +000084 `iso_code` varchar(6) NOT NULL,
droy27e97e02007-11-27 16:44:19 +000085 `locale` varchar(12) default NULL,
86 `name` varchar(50) NOT NULL,
87 `is_active` tinyint(3) unsigned NOT NULL default '1',
88 PRIMARY KEY (`language_id`),
89 KEY `iso_code` (`iso_code`),
90 KEY `locale` (`locale`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
droy3bb0c962008-01-17 20:45:01 +000093--
94-- Table structure for table `map_files`
95--
96
97DROP TABLE IF EXISTS `map_files`;
98CREATE TABLE `map_files` (
99 `project_id` varchar(100) NOT NULL,
100 `version` varchar(64) NOT NULL,
101 `filename` varchar(100) NOT NULL,
102 `location` varchar(255) NOT NULL,
103 `is_active` tinyint(3) unsigned NOT NULL default '1',
kitlod66aa992010-01-22 17:18:19 +0000104 `is_map_file` tinyint(3) unsigned NOT NULL default '1',
droy3bb0c962008-01-17 20:45:01 +0000105 PRIMARY KEY (`project_id`, `version`, `filename`),
106 CONSTRAINT `map_files_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON UPDATE CASCADE ON DELETE CASCADE
107) ENGINE=InnoDB DEFAULT CHARSET=utf8;
108
droy27e97e02007-11-27 16:44:19 +0000109--
kitlod66aa992010-01-22 17:18:19 +0000110-- Table structure for table `plugin_exclude_patterns`
111--
112
113DROP TABLE IF EXISTS `plugin_exclude_patterns`;
114CREATE TABLE `plugin_exclude_patterns` (
115 `project_id` varchar(100) NOT NULL,
116 `version` varchar(64) NOT NULL,
117 `pattern` varchar(128) NOT NULL,
118 PRIMARY KEY (`project_id`, `version`, `pattern`),
119 CONSTRAINT `plugin_exclude_patterns_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON UPDATE CASCADE ON DELETE CASCADE
120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121
122--
droy27e97e02007-11-27 16:44:19 +0000123-- Table structure for table `profiles`
124--
125
126DROP TABLE IF EXISTS `profiles`;
127CREATE TABLE `profiles` (
128 `userid` mediumint(9) NOT NULL auto_increment,
129 `login_name` varchar(255) NOT NULL default '',
130 `cryptpassword` varchar(128) default NULL,
131 `realname` varchar(255) NOT NULL default '',
132 `disabledtext` mediumtext NOT NULL,
133 `mybugslink` tinyint(4) NOT NULL default '1',
134 `extern_id` varchar(64) default NULL,
135 `disable_mail` tinyint(4) NOT NULL default '0',
136 PRIMARY KEY (`userid`),
137 UNIQUE KEY `profiles_login_name_idx` (`login_name`)
138) ENGINE=MyISAM DEFAULT CHARSET=latin1;
139
140--
141-- Table structure for table `projects`
142--
143
144DROP TABLE IF EXISTS `projects`;
145CREATE TABLE `projects` (
146 `project_id` varchar(100) NOT NULL,
147 `is_active` tinyint(3) unsigned NOT NULL default '1',
148 PRIMARY KEY (`project_id`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8;
150
kitloe3fea252010-01-25 02:13:49 +0000151--
152-- Table structure for table `project_progress`
153--
154
droyd664f912008-05-14 15:45:10 +0000155DROP TABLE IF EXISTS `project_progress`;
156CREATE TABLE `project_progress` (
157 `project_id` varchar(100) NOT NULL,
158 `version` varchar(64) NOT NULL,
159 `language_id` smallint(5) unsigned NOT NULL,
160 `pct_complete` float NOT NULL,
droy6e6fb6d2008-05-15 17:11:29 +0000161 `is_stale` tinyint unsigned not null default 0,
droyd664f912008-05-14 15:45:10 +0000162 PRIMARY KEY (`project_id`, `version`, `language_id`),
163 CONSTRAINT `project_progress_ibfk_1` FOREIGN KEY (`project_id`, `version`) REFERENCES `project_versions` (`project_id`, `version`) ON UPDATE CASCADE ON DELETE CASCADE,
164 CONSTRAINT `project_progress_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`language_id`) ON UPDATE CASCADE ON DELETE CASCADE
165) ENGINE=InnoDB DEFAULT CHARSET=utf8;
166
kitloe3fea252010-01-25 02:13:49 +0000167--
168-- Table structure for table `project_versions`
169--
droyd664f912008-05-14 15:45:10 +0000170
droyc081e862007-11-30 16:37:35 +0000171DROP TABLE IF EXISTS `project_versions`;
172CREATE TABLE `project_versions` (
173 `project_id` varchar(100) NOT NULL,
droy44cb1ba2007-12-18 15:19:34 +0000174 `version` varchar(64) NOT NULL,
droyc081e862007-11-30 16:37:35 +0000175 `is_active` tinyint(3) unsigned NOT NULL default '1',
176 PRIMARY KEY (`project_id`, `version`),
177 CONSTRAINT `project_versions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON UPDATE CASCADE ON DELETE CASCADE
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179
droy27e97e02007-11-27 16:44:19 +0000180--
181-- Table structure for table `ratings`
182--
183
184DROP TABLE IF EXISTS `ratings`;
185CREATE TABLE `ratings` (
186 `translation_id` int(10) unsigned NOT NULL,
187 `userid` int(10) unsigned NOT NULL,
188 `rating` tinyint(3) unsigned NOT NULL default '0',
189 `created_on` datetime NOT NULL,
190 PRIMARY KEY (`translation_id`,`userid`),
191 CONSTRAINT `ratings_ibfk_1` FOREIGN KEY (`translation_id`) REFERENCES `translations` (`translation_id`) ON UPDATE CASCADE
192) ENGINE=InnoDB DEFAULT CHARSET=utf8;
193
kitloe3fea252010-01-25 02:13:49 +0000194--
195-- Table structure for table `release_trains`
196--
197
198DROP TABLE IF EXISTS `release_trains`;
199CREATE TABLE `release_trains` (
200 `train_id` varchar(30) NOT NULL,
201 `train_version` varchar(64) NOT NULL,
kitlo29f4a972010-08-08 00:14:04 +0000202 `is_active` tinyint(3) unsigned NOT NULL default '1',
kitloe3fea252010-01-25 02:13:49 +0000203 PRIMARY KEY (`train_id`, `train_version`)
204) ENGINE=InnoDB DEFAULT CHARSET=utf8;
205
206--
207-- Table structure for table `release_train_projects`
208--
209
droy684f2b62008-06-02 20:52:29 +0000210DROP TABLE IF EXISTS `release_train_projects`;
211CREATE TABLE `release_train_projects` (
212 `train_id` varchar(30) NOT NULL,
213 `project_id` varchar(100) NOT NULL,
214 `version` varchar(64) NOT NULL,
215 PRIMARY KEY (`train_id`, `project_id`, `version`),
216 CONSTRAINT `release_train_progress_ibfk_1` FOREIGN KEY (`project_id`, `version`) REFERENCES `project_versions` (`project_id`, `version`) ON UPDATE CASCADE ON DELETE CASCADE
217) ENGINE=InnoDB DEFAULT CHARSET=utf8;
218
droy27e97e02007-11-27 16:44:19 +0000219--
220-- Table structure for table `schema_info`
221--
222
223DROP TABLE IF EXISTS `schema_info`;
224CREATE TABLE `schema_info` (
225 `version` int(11) default NULL
226) ENGINE=MyISAM DEFAULT CHARSET=latin1;
227
228--
229-- Table structure for table `sessions`
230--
231
232DROP TABLE IF EXISTS `sessions`;
233CREATE TABLE `sessions` (
234 `id` int(11) unsigned NOT NULL auto_increment,
235 `userid` int(11) NOT NULL,
236 `gid` char(32) default NULL,
237 `subnet` char(15) default NULL,
238 `updated_at` datetime default NULL,
239 PRIMARY KEY (`id`),
240 KEY `gid` (`gid`),
241 KEY `userid` (`userid`)
242) ENGINE=InnoDB DEFAULT CHARSET=latin1;
243
244--
245-- Table structure for table `strings`
246--
247
droy27e97e02007-11-27 16:44:19 +0000248CREATE TABLE `strings` (
249 `string_id` int(10) unsigned NOT NULL auto_increment,
250 `file_id` int(10) unsigned NOT NULL,
251 `name` text NOT NULL,
252 `value` text NOT NULL,
253 `userid` int(10) unsigned NOT NULL,
254 `created_on` datetime NOT NULL,
255 `is_active` tinyint(1) unsigned default NULL,
droy0e2dff42008-09-24 15:35:34 +0000256 `non_translatable` tinyint(4) default '0',
droy27e97e02007-11-27 16:44:19 +0000257 PRIMARY KEY (`string_id`),
258 KEY `file_id` (`file_id`),
259 KEY `userid` (`userid`),
260 CONSTRAINT `strings_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `files` (`file_id`) ON UPDATE CASCADE,
261 CONSTRAINT `strings_ibfk_2` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON UPDATE CASCADE
atoulmeabd65d52009-01-09 23:47:54 +0000262) ENGINE=InnoDB DEFAULT CHARSET=utf8;
droy27e97e02007-11-27 16:44:19 +0000263
droy68864612009-04-14 15:44:05 +0000264CREATE INDEX idx_value ON strings(value(40));
droy44cb1ba2007-12-18 15:19:34 +0000265
droy44cb1ba2007-12-18 15:19:34 +0000266DELIMITER ;;
267CREATE TRIGGER `upd_string` AFTER UPDATE ON `strings` FOR EACH ROW
268 BEGIN
269 IF(NEW.value <> OLD.value) THEN
270 UPDATE translations SET possibly_incorrect = 1 WHERE string_id = NEW.string_id;
271 END IF;
272 END;
273;;
274DELIMITER ;
275
droy0757c2c2009-03-31 19:37:36 +0000276--
277-- Table structure for table `sys_values`
278--
279DROP TABLE IF EXISTS `sys_values`;
280CREATE TABLE `sys_values` (
281 `itemid` char(6) NOT NULL,
282 `value` text,
283 PRIMARY KEY (`itemid`)
284) ENGINE=InnoDB DEFAULT CHARSET=utf8;
droy44cb1ba2007-12-18 15:19:34 +0000285
droy27e97e02007-11-27 16:44:19 +0000286--
287-- Table structure for table `translation_archives`
288--
289
290DROP TABLE IF EXISTS `translation_archives`;
291CREATE TABLE `translation_archives` (
292 `translation_id` int(10) unsigned NOT NULL,
293 `string_id` int(10) unsigned NOT NULL,
294 `language_id` smallint(5) unsigned NOT NULL,
295 `version` int(10) unsigned NOT NULL default '1',
296 `value` text NOT NULL,
297 `is_active` tinyint(3) unsigned NOT NULL default '1',
298 `userid` int(10) unsigned NOT NULL,
299 `created_on` datetime NOT NULL,
300 PRIMARY KEY (`string_id`,`language_id`,`version`),
301 KEY `language_id` (`language_id`),
302 KEY `userid` (`userid`),
303 CONSTRAINT `translation_archives_ibfk_1` FOREIGN KEY (`string_id`) REFERENCES `strings` (`string_id`) ON UPDATE CASCADE,
304 CONSTRAINT `translation_archives_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`language_id`) ON UPDATE CASCADE,
305 CONSTRAINT `translation_archives_ibfk_3` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON UPDATE CASCADE
306) ENGINE=InnoDB DEFAULT CHARSET=utf8;
307
308--
309-- Table structure for table `translations`
310--
311
312DROP TABLE IF EXISTS `translations`;
313CREATE TABLE `translations` (
314 `translation_id` int(10) unsigned NOT NULL auto_increment,
315 `string_id` int(10) unsigned NOT NULL,
316 `language_id` smallint(5) unsigned NOT NULL,
317 `version` int(10) unsigned NOT NULL default '1',
318 `value` text NOT NULL,
droy44cb1ba2007-12-18 15:19:34 +0000319 `possibly_incorrect` tinyint unsigned NOT NULL default '0',
droy27e97e02007-11-27 16:44:19 +0000320 `is_active` tinyint(3) unsigned NOT NULL default '1',
321 `userid` int(10) unsigned NOT NULL,
322 `created_on` datetime NOT NULL,
323 PRIMARY KEY (`string_id`,`language_id`,`version`),
324 KEY `translation_id` (`translation_id`),
325 KEY `language_id` (`language_id`),
326 KEY `userid` (`userid`),
droyd664f912008-05-14 15:45:10 +0000327 KEY `created_on` (`created_on`),
droy27e97e02007-11-27 16:44:19 +0000328 CONSTRAINT `translations_ibfk_1` FOREIGN KEY (`string_id`) REFERENCES `strings` (`string_id`) ON UPDATE CASCADE,
329 CONSTRAINT `translations_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`language_id`) ON UPDATE CASCADE,
330 CONSTRAINT `translations_ibfk_3` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON UPDATE CASCADE
331) ENGINE=InnoDB DEFAULT CHARSET=utf8;
332
droy5d4b64c2008-02-29 15:22:10 +0000333SET @OLD_SQL_MODE=@@SQL_MODE;
droy27e97e02007-11-27 16:44:19 +0000334DELIMITER ;;
335/*!50003 SET SESSION SQL_MODE="" */;;
droy28b28792008-05-21 20:54:29 +0000336DROP TRIGGER IF EXISTS `ins_version`;;
droy27e97e02007-11-27 16:44:19 +0000337
droy5d4b64c2008-02-29 15:22:10 +0000338/* This trigger sets the version to max(version) + 1. It also updates the file_progress table */
droyd664f912008-05-14 15:45:10 +0000339/* We check IF(NEW.version > 1) to determine if this is a NEW translation or one that replaces an existing one */
droy5d4b64c2008-02-29 15:22:10 +0000340/* (COUNT(t.string_id) + 1) because it's a BEFORE INSERT trigger, the translated str is not in the DB yet */
341/* and without the +1 the percent would always be "one behind" */
342CREATE TRIGGER `ins_version` BEFORE INSERT ON `translations` FOR EACH ROW BEGIN
343 SET NEW.version =
344 (SELECT IFNULL(MAX(version),0)+1 FROM translations
345 WHERE string_id = NEW.string_id and language_id = NEW.language_id);
droyd664f912008-05-14 15:45:10 +0000346
347 /* Define a few fields we need here */
348 SET @FILE_ID=(SELECT file_id FROM strings WHERE string_id = NEW.string_id);
349 SET @PROJECT=(SELECT project_id FROM files WHERE file_id = @FILE_ID);
350 SET @VERSION=(SELECT version FROM files WHERE file_id = @FILE_ID);
droy5d4b64c2008-02-29 15:22:10 +0000351
droyd664f912008-05-14 15:45:10 +0000352
353 /* update this file's progress */
354 DELETE FROM file_progress where file_id = @FILE_ID
droy5d4b64c2008-02-29 15:22:10 +0000355 AND language_id = NEW.language_id;
356
droyd664f912008-05-14 15:45:10 +0000357 /* See notes above for the hairy select */
358 INSERT INTO file_progress SET file_id = @FILE_ID,
droy5d4b64c2008-02-29 15:22:10 +0000359 language_id = NEW.language_id,
360 pct_complete = (
droyd664f912008-05-14 15:45:10 +0000361 SELECT IF(NEW.version > 1,
362 IF(COUNT(s.string_id) > 0, (COUNT(t.string_id))/COUNT(s.string_id)*100,0),
363 IF(COUNT(s.string_id) > 0, (COUNT(t.string_id) + 1)/COUNT(s.string_id)*100,0)
364 ) AS translate_percent
droy5d4b64c2008-02-29 15:22:10 +0000365 FROM files AS f
droyd664f912008-05-14 15:45:10 +0000366 LEFT JOIN strings AS s ON (s.file_id = f.file_id AND s.value <> "" and s.is_active)
droy5d4b64c2008-02-29 15:22:10 +0000367 LEFT JOIN translations AS t ON (s.string_id = t.string_id
368 AND t.language_id = NEW.language_id AND t.is_active = 1)
droyd664f912008-05-14 15:45:10 +0000369 WHERE f.file_id = @FILE_ID
370 );
droy6e6fb6d2008-05-15 17:11:29 +0000371
372
373 /* update project_progress table to indicate this proj/lang/vers stats are stale */
374 /* don't know if record is there or not, so do both an insert and an update */
droy0757c2c2009-03-31 19:37:36 +0000375 /* This portion of the trigger is similar to what is in the files table */
droy6e6fb6d2008-05-15 17:11:29 +0000376 UPDATE IGNORE project_progress SET is_stale = 1 where project_id = @PROJECT
droyd664f912008-05-14 15:45:10 +0000377 AND version = @VERSION
378 AND language_id = NEW.language_id;
droy6e6fb6d2008-05-15 17:11:29 +0000379
380 INSERT IGNORE INTO project_progress SET is_stale = 1, project_id = @PROJECT,
381 version = @VERSION,
382 language_id = NEW.language_id;
droyd664f912008-05-14 15:45:10 +0000383
droy5d4b64c2008-02-29 15:22:10 +0000384END;
385;;
droy27e97e02007-11-27 16:44:19 +0000386DELIMITER ;
387/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
388
389--
390-- Table structure for table `users`
391--
392
393DROP TABLE IF EXISTS `users`;
394CREATE TABLE `users` (
395 `userid` int(10) unsigned NOT NULL,
396 `username` varchar(256) NOT NULL default '',
397 `first_name` varchar(256) NOT NULL default '',
398 `last_name` varchar(256) NOT NULL default '',
399 `email` varchar(256) NOT NULL default '',
400 `primary_language_id` int(11) NOT NULL default '0',
401 `hours_per_week` int(11) NOT NULL default '0',
402 `password_hash` varchar(256) NOT NULL default '',
droy8da30b32007-11-29 21:00:26 +0000403 `is_committer` tinyint unsigned not null default 0,
droy27e97e02007-11-27 16:44:19 +0000404 `updated_on` date NOT NULL,
405 `updated_at` time NOT NULL,
406 `created_on` date NOT NULL,
407 `created_at` time NOT NULL,
408 PRIMARY KEY (`userid`),
409 KEY `primary_language_id` (`primary_language_id`)
410) ENGINE=InnoDB DEFAULT CHARSET=utf8;
droy97c86192007-11-28 22:00:22 +0000411
droy5bb81172008-04-04 19:25:24 +0000412DROP TABLE IF EXISTS `scoreboard`;
413CREATE TABLE `scoreboard` (
414 `id` int unsigned not null auto_increment,
415 `itemid` char(6) NOT NULL,
416 `value` varchar(256) NOT NULL default '',
417 `quantity` double NOT NULL default 0,
418 PRIMARY KEY (`id`),
419 KEY(`quantity`)
420) ENGINE=InnoDB DEFAULT CHARSET=utf8;
421
422
droy97c86192007-11-28 22:00:22 +0000423
424
droy27e97e02007-11-27 16:44:19 +0000425/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
426
427/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
428/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
429/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
430/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
431/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
432/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
433/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
434
droy6426bc02008-02-01 19:35:19 +0000435
436
437
438
439
440/*
441Babel data
442User: babel@eclipse.org
443pass: password
444*/
445
446insert into profiles set login_name = "test", cryptpassword = "", realname = "tester", disabledtext = false, mybugslink = 1, extern_id = 1, disable_mail = false;
droyeccd9832008-07-22 18:04:11 +0000447insert into users set userid = 1, username = "babel@eclipse.org",first_name="babel",last_name="fish",email="babel@eclipse.org",primary_language_id = "",password_hash = "HSD9a.ShTTdvo", is_committer = true, updated_on = NOW(), updated_at='',created_on = NOW(), created_at='';
kitlo32cd7442010-02-15 16:29:22 +0000448insert into users set userid = 2, username = "genie@eclipse.org",first_name="babel",last_name="genie",email="genie@eclipse.org",primary_language_id = "",password_hash = "HSD9a.ShTTdvo", is_committer = true, updated_on = NOW(), updated_at='',created_on = NOW(), created_at='';
449insert into users set userid = 3, username = "syncup@eclipse.org",first_name="babel",last_name="syncup",email="syncup@eclipse.org",primary_language_id = "",password_hash = "HSD9a.ShTTdvo", is_committer = true, updated_on = NOW(), updated_at='',created_on = NOW(), created_at='';
kitlo2e780dc2010-01-12 17:58:32 +0000450
451insert into languages values (1, "en", null, "English", 1);
452insert into languages values (null, "fr", null, "French", 1);
453insert into languages values (null, "de", null, "German", 1);
454insert into languages values (null, "es", null, "Spanish", 1);
455insert into languages values (null, "it", null, "Italian", 1);
456insert into languages values (null, "ja", null, "Japanese", 1);
457insert into languages values (null, "ko", null, "Korean", 1);
458insert into languages values (null, "pt_BR", "Brazilian", "Portuguese", 1);
459insert into languages values (null, "zh", "Simplified", "Chinese", 1);
460insert into languages values (null, "zh_TW", "Traditional", "Chinese", 1);
461insert into languages values (null, "cs", null, "Czech", 1);
462insert into languages values (null, "hu", null, "Hungarian", 1);
463insert into languages values (null, "pl", null, "Polish", 1);
464insert into languages values (null, "ru", null, "Russian", 1);
465insert into languages values (null, "da", null, "Danish", 1);
466insert into languages values (null, "nl", null, "Dutch", 1);
467insert into languages values (null, "fi", null, "Finnish", 1);
468insert into languages values (null, "el", null, "Greek", 1);
469insert into languages values (null, "no", null, "Norwegian", 1);
470insert into languages values (null, "pt", null, "Portuguese", 1);
471insert into languages values (null, "sv", null, "Swedish", 1);
472insert into languages values (null, "tr", null, "Turkish", 1);
473insert into languages values (null, "ar", null, "Arabic", 1);
474insert into languages values (null, "iw", null, "Hebrew", 1);
475insert into languages values (null, "hi", null, "Hindi", 1);
476insert into languages values (null, "ro", null, "Romanian", 1);
477insert into languages values (null, "uk", null, "Ukrainian", 1);
478insert into languages values (null, "ca", null, "Catalan", 1);
479insert into languages values (null, "et", null, "Estonian", 1);
480insert into languages values (null, "en_CA", "Canadian", "English", 1);
481insert into languages values (null, "en_AU", "Australian", "English", 1);
482insert into languages values (null, "mn", null, "Mongolian", 1);
483insert into languages values (null, "id", null, "Indonesian", 1);
484insert into languages values (null, "bg", null, "Bulgarian", 1);
kitlo396bcca2010-02-11 20:03:25 +0000485insert into languages values (null, "sl", null, "Slovenian", 1);
kitlof7ec1e82010-07-31 18:42:23 +0000486insert into languages values (null, "fa", null, "Persian", 1);
kitlo98f08072010-12-14 06:09:23 +0000487insert into languages values (null, "sq", null, "Albanian", 1);
kitlo9b409252011-06-16 00:44:29 +0000488insert into languages values (null, "ku", null, "Kurdish", 1);
kitlof7ec1e82010-07-31 18:42:23 +0000489
kitlo2e780dc2010-01-12 17:58:32 +0000490insert into languages values (null, "tl", null, "Klingon", 1);
491
droy6426bc02008-02-01 19:35:19 +0000492insert into projects set project_id = 'eclipse', is_active = 1 ;
droy2df74062008-07-03 12:45:46 +0000493
kitlof134ee82011-07-03 18:54:53 +0000494insert into project_versions set project_id = "eclipse", version = "3.3", is_active = 1;
droy6426bc02008-02-01 19:35:19 +0000495insert into project_versions set project_id = "eclipse", version = "3.4", is_active = 1;
kitlo2e780dc2010-01-12 17:58:32 +0000496insert into project_versions set project_id = "eclipse", version = "3.5", is_active = 1;
kitlo2e780dc2010-01-12 17:58:32 +0000497insert into project_versions set project_id = "eclipse", version = "3.6", is_active = 1;
kitlo98f08072010-12-14 06:09:23 +0000498insert into project_versions set project_id = "eclipse", version = "3.7", is_active = 1;
kitlof134ee82011-07-03 18:54:53 +0000499insert into project_versions set project_id = "eclipse", version = "4.1", is_active = 1;
kitlo98f08072010-12-14 06:09:23 +0000500
kitlof134ee82011-07-03 18:54:53 +0000501insert into release_trains values ('europa', '3.3.0', 1);
kitlo29f4a972010-08-08 00:14:04 +0000502insert into release_trains values ('ganymede', '3.4.0', 1);
503insert into release_trains values ('galileo', '3.5.0', 1);
504insert into release_trains values ('helios', '3.6.0', 1);
kitlo98f08072010-12-14 06:09:23 +0000505insert into release_trains values ('indigo', '3.7.0', 1);
kitlo2e780dc2010-01-12 17:58:32 +0000506
kitlof134ee82011-07-03 18:54:53 +0000507insert into release_train_projects values ('europa', 'eclipse', '3.3');
508insert into release_train_projects values ('ganymede', 'eclipse', '3.4');
509insert into release_train_projects values ('galileo', 'eclipse', '3.5');
510insert into release_train_projects values ('helios', 'eclipse', '3.6');
511insert into release_train_projects values ('indigo', 'eclipse', '3.7');
512insert into release_train_projects values ('indigo', 'eclipse', '4.1');
kitlo98f08072010-12-14 06:09:23 +0000513
droy6426bc02008-02-01 19:35:19 +0000514/* MAP INPUTS */
kitlof134ee82011-07-03 18:54:53 +0000515insert into map_files values ("eclipse", "3.3", "ant.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ant.map?view=co&pathrev=R3_3", 1, 1);
516insert into map_files values ("eclipse", "3.3", "base.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/base.map?view=co&pathrev=R3_3", 1, 1);
517insert into map_files values ("eclipse", "3.3", "compare.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/compare.map?view=co&pathrev=R3_3", 1, 1);
518insert into map_files values ("eclipse", "3.3", "core-hpux.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-hpux.map?view=co&pathrev=R3_3", 1, 1);
519insert into map_files values ("eclipse", "3.3", "core-macosx.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-macosx.map?view=co&pathrev=R3_3", 1, 1);
520insert into map_files values ("eclipse", "3.3", "core-qnx.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-qnx.map?view=co&pathrev=R3_3", 1, 1);
521insert into map_files values ("eclipse", "3.3", "core-variables.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-variables.map?view=co&pathrev=R3_3", 1, 1);
522insert into map_files values ("eclipse", "3.3", "core.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core.map?view=co&pathrev=R3_3", 1, 1);
523insert into map_files values ("eclipse", "3.3", "doc.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/doc.map?view=co&pathrev=R3_3", 1, 1);
524insert into map_files values ("eclipse", "3.3", "equinox-incubator.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/equinox-incubator.map?view=co&pathrev=R3_3", 1, 1);
525insert into map_files values ("eclipse", "3.3", "feature.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/feature.map?view=co&pathrev=R3_3", 1, 1);
526insert into map_files values ("eclipse", "3.3", "jdtapt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtapt.map?view=co&pathrev=R3_3", 1, 1);
527insert into map_files values ("eclipse", "3.3", "jdtcore.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtcore.map?view=co&pathrev=R3_3", 1, 1);
528insert into map_files values ("eclipse", "3.3", "jdtdebug.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtdebug.map?view=co&pathrev=R3_3", 1, 1);
529insert into map_files values ("eclipse", "3.3", "jdtui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtui.map?view=co&pathrev=R3_3", 1, 1);
530insert into map_files values ("eclipse", "3.3", "orbit.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/orbit.map?view=co&pathrev=R3_3", 1, 1);
531insert into map_files values ("eclipse", "3.3", "pde.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/pde.map?view=co&pathrev=R3_3", 1, 1);
532insert into map_files values ("eclipse", "3.3", "rcp.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/rcp.map?view=co&pathrev=R3_3", 1, 1);
533insert into map_files values ("eclipse", "3.3", "releng.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/releng.map?view=co&pathrev=R3_3", 1, 1);
534insert into map_files values ("eclipse", "3.3", "swt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/swt.map?view=co&pathrev=R3_3", 1, 1);
535insert into map_files values ("eclipse", "3.3", "team.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/team.map?view=co&pathrev=R3_3", 1, 1);
536insert into map_files values ("eclipse", "3.3", "testframework.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/testframework.map?view=co&pathrev=R3_3", 1, 1);
537insert into map_files values ("eclipse", "3.3", "text.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/text.map?view=co&pathrev=R3_3", 1, 1);
538insert into map_files values ("eclipse", "3.3", "ui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ui.map?view=co&pathrev=R3_3", 1, 1);
539insert into map_files values ("eclipse", "3.3", "update.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/update.map?view=co&pathrev=R3_3", 1, 1);
540insert into map_files values ("eclipse", "3.3", "userassist.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/userassist.map?view=co&pathrev=R3_3", 1, 1);
541insert into map_files values ("eclipse", "3.4", "ant.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ant.map?view=co&pathrev=R3_4", 1, 1);
542insert into map_files values ("eclipse", "3.4", "base.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/base.map?view=co&pathrev=R3_4", 1, 1);
543insert into map_files values ("eclipse", "3.4", "compare.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/compare.map?view=co&pathrev=R3_4", 1, 1);
544insert into map_files values ("eclipse", "3.4", "core-hpux.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-hpux.map?view=co&pathrev=R3_4", 1, 1);
545insert into map_files values ("eclipse", "3.4", "core-macosx.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-macosx.map?view=co&pathrev=R3_4", 1, 1);
546insert into map_files values ("eclipse", "3.4", "core-qnx.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-qnx.map?view=co&pathrev=R3_4", 1, 1);
547insert into map_files values ("eclipse", "3.4", "core-variables.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-variables.map?view=co&pathrev=R3_4", 1, 1);
548insert into map_files values ("eclipse", "3.4", "core.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core.map?view=co&pathrev=R3_4", 1, 1);
549insert into map_files values ("eclipse", "3.4", "doc.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/doc.map?view=co&pathrev=R3_4", 1, 1);
550insert into map_files values ("eclipse", "3.4", "equinox-incubator.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/equinox-incubator.map?view=co&pathrev=R3_4", 1, 1);
551insert into map_files values ("eclipse", "3.4", "feature.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/feature.map?view=co&pathrev=R3_4", 1, 1);
552insert into map_files values ("eclipse", "3.4", "jdtapt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtapt.map?view=co&pathrev=R3_4", 1, 1);
553insert into map_files values ("eclipse", "3.4", "jdtcore.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtcore.map?view=co&pathrev=R3_4", 1, 1);
554insert into map_files values ("eclipse", "3.4", "jdtdebug.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtdebug.map?view=co&pathrev=R3_4", 1, 1);
555insert into map_files values ("eclipse", "3.4", "jdtui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtui.map?view=co&pathrev=R3_4", 1, 1);
556insert into map_files values ("eclipse", "3.4", "orbit.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/orbit.map?view=co&pathrev=R3_4", 1, 1);
557insert into map_files values ("eclipse", "3.4", "pde.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/pde.map?view=co&pathrev=R3_4", 1, 1);
558insert into map_files values ("eclipse", "3.4", "rcp.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/rcp.map?view=co&pathrev=R3_4", 1, 1);
559insert into map_files values ("eclipse", "3.4", "releng.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/releng.map?view=co&pathrev=R3_4", 1, 1);
560insert into map_files values ("eclipse", "3.4", "swt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/swt.map?view=co&pathrev=R3_4", 1, 1);
561insert into map_files values ("eclipse", "3.4", "team.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/team.map?view=co&pathrev=R3_4", 1, 1);
562insert into map_files values ("eclipse", "3.4", "testframework.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/testframework.map?view=co&pathrev=R3_4", 1, 1);
563insert into map_files values ("eclipse", "3.4", "text.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/text.map?view=co&pathrev=R3_4", 1, 1);
564insert into map_files values ("eclipse", "3.4", "ui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ui.map?view=co&pathrev=R3_4", 1, 1);
565insert into map_files values ("eclipse", "3.4", "update.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/update.map?view=co&pathrev=R3_4", 1, 1);
566insert into map_files values ("eclipse", "3.4", "userassist.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/userassist.map?view=co&pathrev=R3_4", 1, 1);
567insert into map_files values ("eclipse", "3.5", "eclipse-3.5-update-site", "http://download.eclipse.org/eclipse/updates/3.5/R-3.5-200906111540", 1, 0);
568insert into map_files values ("eclipse", "3.6", "eclipse-3.6-update-site", "http://download.eclipse.org/eclipse/updates/3.6/R-3.6-201006080911", 1, 0);
569insert into map_files values ("eclipse", "3.7", "eclipse-3.7-update-site", "http://download.eclipse.org/eclipse/updates/3.7/R-3.7-201106131736", 1, 0);
570insert into map_files values ("eclipse", "4.1", "eclipse-4.1-update-site", "http://download.eclipse.org/e4/sdk/drops/R-4.1-201106201631/repository", 1, 0);
droybafb7c42008-02-29 18:24:38 +0000571
kitlof134ee82011-07-03 18:54:53 +0000572insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^com\\.ibm\\.icu.*$/");
kitlo9b409252011-06-16 00:44:29 +0000573insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^com\\.jcraft\\..*$/");
574insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^javax\\..*$/");
575insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.apache\\..*$/");
576insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.hamcrest\\..*$/");
577insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.junit.*$/");
578insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.mortbay\\..*$/");
579insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.objectweb\\..*$/");
580insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.sat4j\\..*$/");
kitlof134ee82011-07-03 18:54:53 +0000581insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^org\\.w3c\\..*$/");
582insert into plugin_exclude_patterns values ("eclipse", "3.5", "/^.*\\/jface\\/resource\\/.*$/");
kitloe3fea252010-01-25 02:13:49 +0000583
kitlof134ee82011-07-03 18:54:53 +0000584insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^com\\.ibm\\.icu.*$/");
kitlo82d198f2010-02-11 22:31:35 +0000585insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^com\\.jcraft\\..*$/");
586insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^javax\\..*$/");
587insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.apache\\..*$/");
588insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.hamcrest\\..*$/");
589insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.junit.*$/");
590insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.mortbay\\..*$/");
591insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.objectweb\\..*$/");
592insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.sat4j\\..*$/");
kitlof134ee82011-07-03 18:54:53 +0000593insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^org\\.w3c\\..*$/");
594insert into plugin_exclude_patterns values ("eclipse", "3.6", "/^.*\\/jface\\/resource\\/.*$/");
kitloe3fea252010-01-25 02:13:49 +0000595
kitlof134ee82011-07-03 18:54:53 +0000596insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^com\\.ibm\\.icu.*$/");
kitlo9b409252011-06-16 00:44:29 +0000597insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^com\\.jcraft\\..*$/");
598insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^javax\\..*$/");
599insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.apache\\..*$/");
600insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.hamcrest\\..*$/");
601insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.junit.*$/");
602insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.mortbay\\..*$/");
603insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.objectweb\\..*$/");
604insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.sat4j\\..*$/");
kitlof134ee82011-07-03 18:54:53 +0000605insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^org\\.w3c\\..*$/");
606insert into plugin_exclude_patterns values ("eclipse", "3.7", "/^.*\\/jface\\/resource\\/.*$/");
607
608insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^com\\.ibm\\.icu.*$/");
609insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^com\\.jcraft\\..*$/");
610insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^javax\\..*$/");
611insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.apache\\..*$/");
612insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.hamcrest\\..*$/");
613insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.junit.*$/");
614insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.mortbay\\..*$/");
615insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.objectweb\\..*$/");
616insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.sat4j\\..*$/");
617insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^org\\.w3c\\..*$/");
618insert into plugin_exclude_patterns values ("eclipse", "4.1", "/^.*\\/jface\\/resource\\/.*$/");
kitlo9b409252011-06-16 00:44:29 +0000619
droybafb7c42008-02-29 18:24:38 +0000620/* populate file_progress table */
droydc294842008-05-21 17:38:57 +0000621/* See also: dbmaintenance_15min.php */
droybafb7c42008-02-29 18:24:38 +0000622truncate table file_progress;
623INSERT INTO file_progress
droyc2c26102008-05-21 16:01:40 +0000624select f.file_id, l.language_id, IF(COUNT(s.string_id) > 0, COUNT(t.string_id)/COUNT(s.string_id)*100,100) AS translate_percent
droybafb7c42008-02-29 18:24:38 +0000625FROM files AS f
626 INNER JOIN languages as l ON l.is_active = 1
droy45413ea2008-07-28 14:36:23 +0000627 LEFT JOIN strings as s ON (s.file_id = f.file_id AND s.is_active AND s.value <> "" AND s.non_translatable = 0)
droybafb7c42008-02-29 18:24:38 +0000628 LEFT JOIN translations AS t ON (s.string_id = t.string_id
629 AND t.language_id = l.language_id AND t.is_active = 1)
630WHERE f.is_active = 1
631GROUP BY f.file_id, l.language_id;
droy5bb81172008-04-04 19:25:24 +0000632DELETE FROM file_progress WHERE pct_complete = 0;
633
droyd664f912008-05-14 15:45:10 +0000634/* populate project_progress table */
635truncate table project_progress;
636INSERT INTO project_progress
637SELECT
638 p.project_id,
639 v.version,
640 l.language_id,
droyb156beb2008-05-15 17:16:44 +0000641 IF(COUNT(s.string_id) > 0, ROUND(COUNT(t.string_id)/COUNT(s.string_id) * 100, 2), 0) AS pct_complete,
642 0
droyd664f912008-05-14 15:45:10 +0000643FROM projects as p
644 INNER JOIN project_versions AS v ON v.project_id = p.project_id
645 INNER JOIN files AS f
646 ON (f.project_id = p.project_id AND f.version = v.version AND f.is_active)
647 INNER JOIN strings AS s
648 ON (s.file_id = f.file_id AND s.is_active)
649 INNER JOIN languages AS l
650 LEFT JOIN translations AS t
651 ON (t.string_id = s.string_id AND t.language_id = l.language_id AND t.is_active)
652WHERE
653 s.value <> ""
droy45413ea2008-07-28 14:36:23 +0000654 AND s.non_translatable = 0
droyd664f912008-05-14 15:45:10 +0000655 AND p.is_active
656GROUP BY p.project_id, v.version, l.language_id;
657
droy5bb81172008-04-04 19:25:24 +0000658/* populate scoreboard */
659truncate table scoreboard;
660INSERT INTO scoreboard SELECT NULL, "LANGPR", CONCAT(b.name,IF(ISNULL(b.locale),"",CONCAT(" ", b.locale))), count(*) as StringCount from translations as a inner join languages as b on b.language_id = a.language_id where a.value <> '' and a.is_active = 1 group by a.language_id order by StringCount desc;
661INSERT INTO scoreboard SELECT NULL, "TOPTR", CONCAT(first_name, IF(ISNULL(last_name),"",CONCAT(" ", last_name))), count(translations.string_id) as cnt from translations inner join users on users.userid = translations.userid where is_active=1 group by first_name, last_name order by cnt desc limit 20;
droy0757c2c2009-03-31 19:37:36 +0000662INSERT INTO scoreboard SELECT NULL, "LASGEN", "Scoreboard Last Generated", MAX(translation_id) FROM translations;
663
664/* create a holding record for the MOTD */
kitloe3fea252010-01-25 02:13:49 +0000665INSERT INTO sys_values VALUES ("MOTD", NULL);