Configuration data specific to Sugar

1 files changed, 41 insertions, 0 deletions

diff --git a/site/app/tests/data/sugar-test-data.sql b/site/app/tests/data/sugar-test-data.sql
new file mode 100644
index 0000000..5933b4c
--- /dev/null
+++ b/site/app/tests/data/sugar-test-data.sql
@@ -0,0 +1,41 @@
+-- All users will have the password "mecmec"
+update users set password='913026c7754df0fbdc89b75007ad5a66';
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- Create activity addontype, 9
+insert into addontypes values (9, now(), now());
+
+-- 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, 9, 19, now(), now(), 0),
+(101, 50004, 50005, 9, 19, now(), now(), 0),
+(102, 50006, 50007, 9, 19, now(), now(), 0),
+(103, 50008, 50009, 9, 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 `translations` (`id`, `locale`, `localized_string`, `created`, `modified`) VALUES
+(50000, 'en-US', 'Sugar', now(), now()),
+(50001, 'en-US', 'Sugar', now(), now()),
+(50002, 'en-US', 'Games', now(), now()),
+(50003, 'en-US', '', now(), now()),
+(50004, 'en-US', 'Drawing', now(), now()),
+(50005, 'en-US', '', now(), now()),
+(50006, 'en-US', 'Maths & Science', now(), now()),
+(50007, 'en-US', '', now(), now()),
+(50008, 'en-US', 'Communication', now(), now()),
+(50009, 'en-US', '', now(), now())
+;
+
+SET FOREIGN_KEY_CHECKS=1;
+