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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE users ADD (
notifybroadcast tinyint(1) unsigned NOT NULL default '0',
KEY notifybroadcast (notifybroadcast)
);
INSERT INTO `groups` (`id`, `name`, `rules`, `created`, `modified`) VALUES
(1, 'Admins', '*:*', '2007-02-10 13:29:03', '2007-02-10 16:57:10'),
(2, 'Editors', 'Editors:*', '2007-02-10 16:32:21', '2007-02-10 16:32:21');
INSERT INTO `groups_users` (`group_id`, `user_id`) VALUES
(1, 1),
(2, 1),
(2, 2);
-- Add root@sugarlabs.org user with password "test"
INSERT INTO `users` (`id`, `email`, `password`, `firstname`, `lastname`, `nickname`, `emailhidden`, `sandboxshown`, `homepage`, `confirmationcode`, `created`, `modified`, `notes`) VALUES
(1, 'admin@sugarlabs.org', '098f6bcd4621d373cade4e832627b4f6', 'root', 'root', 'root', 0, 1, 'http://wiki.sugarlabs.org', '', now(), now(), NULL),
(2, 'editor@sugarlabs.org', '098f6bcd4621d373cade4e832627b4f6', 'editor', 'editor', 'editor', 0, 1, 'http://wiki.sugarlabs.org', '', now(), now(), NULL),
(3, 'developer@sugarlabs.org', '098f6bcd4621d373cade4e832627b4f6', 'developer', 'developer', 'developer', 0, 1, 'http://wiki.sugarlabs.org', '', now(), now(), NULL);
-- Create Sugar application, 1
DELETE from applications;
insert into applications values
(1, '{3ca105e0-2280-4897-99a0-c277d1b733d2}', 50000, NULL, '', 50001, 1, now(), now())
;
INSERT INTO tags (id, name, description, addontype_id, application_id, created, modified, weight) VALUES
(100, 50002, 50003, 1, 1, now(), now(), 0),
(101, 50004, 50005, 1, 1, now(), now(), 0),
(102, 50006, 50007, 1, 1, now(), now(), 0),
(103, 50008, 50009, 1, 1, now(), now(), 0),
(104, 50010, 50011, 1, 1, now(), now(), 0)
;
INSERT INTO `appversions` (`id`, `application_id`, `version`, `created`, `modified`) VALUES
(100, 1, '0.82', now(), now()),
(101, 1, '0.84', now(), now())
;
INSERT INTO `platforms` (`id`, `name`, `shortname`, `icondata`, `icontype`, `created`, `modified`) VALUES
(1, 114, 115, NULL, '', now(), now()),
(2, 116, 117, NULL, '', now(), now()),
(3, 118, 119, NULL, '', now(), now()),
(4, 120, 121, NULL, '', now(), now());
INSERT INTO `translations` (`id`, `locale`, `localized_string`, `created`, `modified`) VALUES
(114, 'en-US', 'ALL', now(), now()),
(115, 'en-US', '', now(), now()),
(116, 'en-US', 'x86', now(), now()),
(117, 'en-US', 'x86', now(), now()),
(118, 'en-US', 'MIPS', now(), now()),
(119, 'en-US', 'mips', now(), now()),
(120, 'en-US', 'ARM', now(), now()),
(121, 'en-US', 'arm', now(), now()),
(50000, 'en-US', 'Sugar Platform', now(), now()),
(50001, 'en-US', 'sugar', now(), now()),
(50002, 'en-US', 'Games', now(), now()),
(50003, 'en-US', 'games', now(), now()),
(50004, 'en-US', 'Drawing', now(), now()),
(50005, 'en-US', 'drawing', now(), now()),
(50006, 'en-US', 'Maths & Science', now(), now()),
(50007, 'en-US', 'maths', now(), now()),
(50008, 'en-US', 'Communication', now(), now()),
(50009, 'en-US', 'communication', now(), now()),
(50010, 'en-US', 'Art', now(), now()),
(50011, 'en-US', 'art', now(), now())
;
SET FOREIGN_KEY_CHECKS=1;
|
