Index: lams_common/db/sql/insert_lams_users.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_lams_users.sql,v diff -u -r1.2.8.1 -r1.2.8.2 --- lams_common/db/sql/insert_lams_users.sql 1 Mar 2010 04:54:32 -0000 1.2.8.1 +++ lams_common/db/sql/insert_lams_users.sql 3 Mar 2010 23:39:38 -0000 1.2.8.2 @@ -5,7 +5,8 @@ -- themes and styles INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (1, "default", "Default Flash style", null, 2); INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (2, "defaultHTML", "Default HTML style", "css", 1); - +INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (3, "highContrast", "High contrast HTML theme", "css", 1); + insert into lams_workspace (workspace_id, name, default_fld_id) values(1,'ROOT',1); insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(2,'Developers Playpen',2,22); insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(3,'MATH111',3,23); Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030402.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030402.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030402.sql 3 Mar 2010 12:51:20 -0000 1.1.2.2 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030402.sql 3 Mar 2010 23:39:38 -0000 1.1.2.3 @@ -24,6 +24,7 @@ INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (1, "default", "Default Flash style", null, 2); INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (2, "defaultHTML", "Default HTML style", "css", 1); +INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (3, "highContrast", "High contrast HTML theme", "css", 1); ALTER TABLE lams_user ADD CONSTRAINT FK_lams_user_4 FOREIGN KEY (flash_theme_id) REFERENCES lams_theme (theme_id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE lams_user ADD CONSTRAINT FK_lams_user_5 FOREIGN KEY (html_theme_id) REFERENCES lams_theme (theme_id) ON DELETE NO ACTION ON UPDATE NO ACTION;