# set the type of the mobile theme
UPDATE `themes` SET `type` = 'Mobile' WHERE `dir_name` = 'mobile';

# add the Vimeo module 
INSERT INTO `modules` (`dir_name`, `status`, `privilege`, `admin_privilege`, `cron_interval`, `cron_last_run`) VALUES('_standard/vimeo', 2, 0, 1, 0, 0);

# add the IDI Default theme
INSERT INTO `themes` VALUES ('IDI Theme', '2.0.2', 'idi', 'Desktop', '2010-12-02', 'The theme created for the IDI course server.', '1');
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'ATutor';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'Fluid';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'ATutor Classic';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'Blumin';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'Greenmin';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'ATutor 1.5';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'Mobile';
UPDATE `themes` SET `version` = '2.0.2' WHERE `title` = 'ATutor 1.6';

# A mapping table between photo album and atutor groups
CREATE TABLE `pa_groups` (
  `group_id` INTEGER UNSIGNED NOT NULL,
  `album_id` INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY (`group_id`, `album_id`)
) ENGINE = MyISAM;

