diff options
Diffstat (limited to 'aslo/sql/sugar-stub-data.sql')
-rw-r--r-- | aslo/sql/sugar-stub-data.sql | 21 |
1 files changed, 10 insertions, 11 deletions
diff --git a/aslo/sql/sugar-stub-data.sql b/aslo/sql/sugar-stub-data.sql index 749b4ba..5c13fd4 100644 --- a/aslo/sql/sugar-stub-data.sql +++ b/aslo/sql/sugar-stub-data.sql @@ -20,23 +20,22 @@ INSERT INTO `users` (`id`, `email`, `password`, `firstname`, `lastname`, `nickna (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; +-- Create Sugar application, 19 insert into applications values -(1, '{3ca105e0-2280-4897-99a0-c277d1b733d2}', 50000, NULL, '', 50001, 1, now(), now()) +(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, 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) +(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, 1, '0.82', now(), now()), -(101, 1, '0.84', now(), now()) +(100, 19, '0.82', now(), now()), +(101, 19, '0.84', now(), now()) ; INSERT INTO `platforms` (`id`, `name`, `shortname`, `icondata`, `icontype`, `created`, `modified`) VALUES @@ -54,7 +53,7 @@ INSERT INTO `translations` (`id`, `locale`, `localized_string`, `created`, `modi (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()), +(50000, 'en-US', 'Sugar', now(), now()), (50001, 'en-US', 'sugar', now(), now()), (50002, 'en-US', 'Games', now(), now()), (50003, 'en-US', 'games', now(), now()), |