# insert the default theme
-INSERT INTO `themes` VALUES ('ATutor', '2.0', 'default', 'Desktop', NOW(), 'This is the default ATutor theme and cannot be deleted as other themes inherit from it. Please do not alter this theme directly as it would complicate upgrading. Instead, create a new theme derived from this one.', 2);
-INSERT INTO `themes` VALUES ('Fluid', '2.0', 'fluid', 'Desktop', NOW(), 'Theme that implements the Fluid reorderer used to drag-and-drop the menu from side-to-side.', 1);
-INSERT INTO `themes` VALUES ('ATutor Classic', '2.0', 'default_classic', 'Desktop', NOW(), 'This is the ATutor Classic theme which makes use of the custom Header and logo images. To customize those images you must edit the <code>theme.cfg.php</code> in this themes directory.', 1);
-INSERT INTO `themes` VALUES ('Blumin', '2.0', 'blumin', 'Desktop', NOW(), 'This is the plone look-alike theme.', 1);
-INSERT INTO `themes` VALUES ('Greenmin', '2.0', 'greenmin', 'Desktop', NOW(), 'This is the plone look-alike theme in green.', 1);
-INSERT INTO `themes` VALUES ('ATutor 1.5', '2.0', 'default15', 'Desktop', NOW(), 'This is the 1.5 series default theme.', 1);
-INSERT INTO `themes` VALUES ('ATutor 1.6', '2.0', 'default16', 'Desktop', NOW(), 'This is the 1.6 series default theme.', 1);
-INSERT INTO `themes` VALUES ('IDI Theme', '2.0', 'idi', 'Desktop', '2010-12-02', 'The theme created for the IDI course server.', '1');
-INSERT INTO `themes` VALUES ('Mobile', '2.0', 'mobile', 'Mobile', NOW(), 'This is the default theme for mobile devices.', 3);
+INSERT INTO `themes` VALUES ('ATutor', '2.0.2', 'default', 'Desktop', NOW(), 'This is the default ATutor theme and cannot be deleted as other themes inherit from it. Please do not alter this theme directly as it would complicate upgrading. Instead, create a new theme derived from this one.', 2);
+INSERT INTO `themes` VALUES ('Fluid', '2.0.2', 'fluid', 'Desktop', NOW(), 'Theme that implements the Fluid reorderer used to drag-and-drop the menu from side-to-side.', 1);
+INSERT INTO `themes` VALUES ('ATutor Classic', '2.0.2', 'default_classic', 'Desktop', NOW(), 'This is the ATutor Classic theme which makes use of the custom Header and logo images. To customize those images you must edit the <code>theme.cfg.php</code> in this themes directory.', 1);
+INSERT INTO `themes` VALUES ('Blumin', '2.0.2', 'blumin', 'Desktop', NOW(), 'This is the plone look-alike theme.', 1);
+INSERT INTO `themes` VALUES ('Greenmin', '2.0.2', 'greenmin', 'Desktop', NOW(), 'This is the plone look-alike theme in green.', 1);
+INSERT INTO `themes` VALUES ('ATutor 1.5', '2.0.2', 'default15', 'Desktop', NOW(), 'This is the 1.5 series default theme.', 1);
+INSERT INTO `themes` VALUES ('ATutor 1.6', '2.0.2', 'default16', 'Desktop', NOW(), 'This is the 1.6 series default theme.', 1);
+INSERT INTO `themes` VALUES ('IDI Theme', '2.0.2', 'idi', 'Desktop', '2010-12-02', 'The theme created for the IDI course server.', '1');
+INSERT INTO `themes` VALUES ('Mobile', '2.0.2', 'mobile', 'Mobile', NOW(), 'This is the default theme for mobile devices.', 3);
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', 'idi', 'Desktop', '2010-12-02', 'The theme created for the IDI course server.', '1');
+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's groups
CREATE TABLE `pa_groups` (