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
|
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, 19
insert into applications values
(19, '{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, 19, now(), now(), 0),
(101, 50004, 50005, 1, 19, now(), now(), 0),
(102, 50006, 50007, 1, 19, now(), now(), 0),
(103, 50008, 50009, 1, 19, now(), now(), 0),
(104, 50010, 50011, 1, 19, now(), now(), 0)
;
INSERT INTO `appversions` (`id`, `application_id`, `version`, `created`, `modified`) VALUES
(100, 19, '0.82', now(), now()),
(101, 19, '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', 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;
|