INSERT INTO lams_theme VALUES
(1,'defaultHTML','Default HTML style','css'),
(2,'purple','Purple Theme','css');

INSERT INTO lams_workspace_folder VALUES
(1,NULL,'ROOT',1,1,NOW(),NOW(),1),
(2,1,'Developers Playpen',1,2,NOW(),NOW(),1),
(3,1,'MATH111',1,4,NOW(),NOW(),1),
(4,NULL,'Mary Morgan',4,NULL,NOW(),NOW(),1),
(5,NULL,'One Test',5,NULL,NOW(),NOW(),1),
(6,NULL,'Two Test',6,NULL,NOW(),NOW(),1),
(7,NULL,'Three Test',7,NULL,NOW(),NOW(),1),
(8,NULL,'Four Test',8,NULL,NOW(),NOW(),1),
(22,2,'Lesson Sequence Folder',1,2,NOW(),NOW(),2),
(23,3,'Lesson Sequence Folder',1,4,NOW(),NOW(),2),
(40,1,'Moodle Test',1,7,NOW(),NOW(),2),
(41,40,'Lesson Sequence Folder',1,7,NOW(),NOW(),2),
(45,NULL,'System Administrator',1,NULL,NOW(),NOW(),1),
(46,1,'Public Folder',1,NULL,NOW(),NOW(),3);

INSERT INTO lams_organisation VALUES
(1,'Root',NULL,'Root Organisation',NULL,1,NOW(),1,1,0,0,0,0,0,0,1,1,0,NULL,NULL),
(2,'Playpen','PP101','Developers Playpen',1,2,NOW(),1,1,0,0,0,0,1,1,1,1,0,NULL,NULL),
(3,'Everybody',NULL,'All People In Course',2,3,NOW(),1,1,0,0,0,0,0,0,1,1,0,NULL,NULL),
(4,'Mathematics 1','MATH111','Mathematics 1',1,2,NOW(),1,1,0,0,0,0,1,1,1,1,0,NULL,NULL),
(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,NOW(),1,1,0,0,0,0,0,0,1,1,0,NULL,NULL),
(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,NOW(),1,1,0,0,0,0,0,0,1,1,0,NULL,NULL),
(7,'Moodle','Moodle','Moodle Test',1,2,NOW(),1,2,0,0,0,0,0,0,1,1,0,NULL,NULL);

INSERT INTO lams_user VALUES 
(1,'sysadmin','a159b7ae81ba3552af61e9731b20870515944538',NULL,0,NULL,NULL,'System','Administrator','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'sysadmin@lams.sg',1,0,NOW(),1,45,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(2,'test','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',NULL,0,NULL,NULL,'Testing','LDAP','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'test@lams.sg',1,0,NOW(),3,NULL,1,3,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(4,'mmm','91223fd10ce86fc852b449583aa2196c304bf6e0',NULL,0,NULL,NULL,'Mary','Morgan','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'mmmmmmm@lams.sg',1,0,NOW(),1,4,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(5,'test1','b444ac06613fc8d63795be9ad0beaf55011936ac',NULL,0,NULL,NULL,'One','Test','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'test1@lams.sg',1,0,NOW(),1,5,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(6,'test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f',NULL,0,NULL,NULL,'Two','Test','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'test2@lams.sg',1,0,NOW(),1,6,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(7,'test3','3ebfa301dc59196f18593c45e519287a23297589',NULL,0,NULL,NULL,'Three','Test','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'test3@lams.sg',1,0,NOW(),1,7,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL), 
(8,'test4','1ff2b3704aede04eecb51e50ca698efd50a1379b',NULL,0,NULL,NULL,'Four','Test','42 Wallaby Way',NULL,NULL,'Sydney','NSW',NULL,'AU',NULL,NULL,NULL,NULL,'test4@lams.sg',1,0,NOW(),1,8,1,1,NULL,NULL,0,'Australia/Sydney',1,NULL,NULL,NULL,NULL);

INSERT INTO lams_user_organisation VALUES
(1,1,1),
(2,2,2),
(4,2,4),
(5,2,5),
(6,2,6),
(7,2,7),
(8,2,8),
(9,3,2),
(11,3,4),
(12,3,5),
(13,3,6),
(14,3,7),
(15,3,8),
(16,4,2),
(18,4,4),
(19,4,5),
(20,4,6),
(21,4,7),
(22,4,8),
(23,5,2),
(25,5,4),
(26,5,5),
(27,5,6),
(28,6,7),
(29,6,8);

INSERT INTO lams_user_organisation_role VALUES
(1,1,1),
(2,2,3),
(4,4,3),
(5,5,3),
(6,6,3),
(7,7,3),
(8,8,3),
(9,2,4),
(11,4,4),
(12,5,4),
(13,6,4),
(14,7,4),
(15,8,4),
(16,2,5),
(18,4,5),
(19,5,5),
(20,6,5),
(21,7,5),
(22,8,5),
(23,9,4),
(25,11,4),
(26,12,4),
(27,13,4),
(28,14,4),
(29,16,4),
(30,9,5),
(32,11,5),
(33,12,5),
(34,13,5),
(35,14,5),
(36,15,5),
(37,22,2),
(38,16,3),
(40,18,3),
(41,19,3),
(42,20,3),
(43,21,3),
(44,22,3),
(47,18,4),
(48,19,4),
(49,20,4),
(50,21,4),
(51,22,4),
(52,16,5),
(54,18,5),
(55,19,5),
(56,20,5),
(57,21,5),
(58,22,5),
(60,23,4),
(62,25,4),
(63,26,4),
(64,27,4),
(65,28,4),
(66,29,4),
(67,23,5),
(69,25,5),
(70,26,5),
(71,27,5),
(72,28,5),
(73,29,5),
(74,18,2),
(75,1,7);