Index: lams_common/db/sql/create_lams_db.sql =================================================================== diff -u -r82e1c646c21417c7d329bc953489458a141168b3 -reb4b64178514bbe639a561a3fb06157bcce7f6f4 --- lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision 82e1c646c21417c7d329bc953489458a141168b3) +++ lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision eb4b64178514bbe639a561a3fb06157bcce7f6f4) @@ -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' ); Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -r052deb1d551e23e002a1d918322e4d883057e2ad -reb4b64178514bbe639a561a3fb06157bcce7f6f4 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 052deb1d551e23e002a1d918322e4d883057e2ad) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision eb4b64178514bbe639a561a3fb06157bcce7f6f4) @@ -46,11 +46,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' );