Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/add_workspace_tables.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/create_lams_db.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/create_learning_design_tables.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/create_user_management_tables.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/drop_learning_design_tables.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/drop_user_management_tables.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag c24a03c2ae20976d4a1126c3a2927b19aa552762 refers to a dead (removed) revision in file `lams_common/db/sql/insert_user_management_data.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_common/db/sql/old/create_lams_db.sql =================================================================== diff -u -r84be344bfb89ab3182fc4abda27266eddd7662fe -rc24a03c2ae20976d4a1126c3a2927b19aa552762 --- lams_common/db/sql/old/create_lams_db.sql (.../create_lams_db.sql) (revision 84be344bfb89ab3182fc4abda27266eddd7662fe) +++ lams_common/db/sql/old/create_lams_db.sql (.../create_lams_db.sql) (revision c24a03c2ae20976d4a1126c3a2927b19aa552762) @@ -5,8 +5,8 @@ -- 13/DEC/2004 SET FOREIGN_KEY_CHECKS=0; -DROP DATABASE IF EXISTS lams; -CREATE DATABASE lams; +DROP DATABASE IF EXISTS lams1; +CREATE DATABASE lams1; SET FOREIGN_KEY_CHECKS=1; USE mysql; @@ -35,7 +35,7 @@ FLUSH PRIVILEGES; -USE lams; +USE lams1; -- Drop, Create and Populate LAMS Tables @@ -553,11 +553,9 @@ INSERT INTO lams_gate_activity_level VALUES (2, 'GROUP'); INSERT INTO lams_gate_activity_level VALUES (3, 'CLASS'); -INSERT INTO lams_tool_session_state VALUES (1, 'STARTED'); -INSERT INTO lams_tool_session_state VALUES (2, 'FINISHED'); -INSERT INTO lams_tool_session_state VALUES (3, 'SUSPENDED'); -INSERT INTO lams_tool_session_state VALUES (4, 'RESUMED'); -INSERT INTO lams_tool_session_state VALUES (5, 'ERROR'); +INSERT INTO lams_tool_session_state VALUES (1, 'NOT ATTEMPTED'); +INSERT INTO lams_tool_session_state VALUES (2, 'INCOMPLETE'); +INSERT INTO lams_tool_session_state VALUES (3, 'COMPLETED'); INSERT INTO lams_user_tool_session_state VALUES (1, 'JOINED'); INSERT INTO lams_user_tool_session_state VALUES (2, 'LEFT' );