Index: lams_common/db/sql/drop_lams_11_tables.sql =================================================================== diff -u -r84861fe0f6370b07582541e94edaa156fab08694 -r30f0dc9c0ccc658a39c3ecf7bc11657f72f7f0f1 --- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 84861fe0f6370b07582541e94edaa156fab08694) +++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 30f0dc9c0ccc658a39c3ecf7bc11657f72f7f0f1) @@ -1,84 +1,38 @@ -DROP INDEX PRIMARY ON lams_gate_activity_level; -DROP INDEX PRIMARY ON lams_grouping_type; -DROP INDEX PRIMARY ON lams_learning_activity_type; -DROP INDEX PRIMARY ON lams_learning_library; -DROP INDEX PRIMARY ON lams_organisation_type; -DROP INDEX UQ_lams_organisation_type_name ON lams_organisation_type; -DROP INDEX PRIMARY ON lams_role; -DROP INDEX gname ON lams_role; -DROP INDEX PRIMARY ON lams_authentication_method_type; -DROP INDEX PRIMARY ON lams_authentication_method; -DROP INDEX authentication_method_type_id ON lams_authentication_method; -DROP INDEX PRIMARY ON lams_workspace_folder; -DROP INDEX parent_folder_id ON lams_workspace_folder; -DROP INDEX PRIMARY ON lams_workspace; -DROP INDEX root_folder_id ON lams_workspace; -DROP INDEX PRIMARY ON lams_grouping; -DROP INDEX idx_grouping_grouping_type ON lams_grouping; -DROP INDEX PRIMARY ON lams_organisation; -DROP INDEX organisation_type_id ON lams_organisation; -DROP INDEX workspace_id ON lams_organisation; -DROP INDEX parent_organisation_id ON lams_organisation; -DROP INDEX PRIMARY ON lams_user; -DROP INDEX UQ_lams_user_login ON lams_user; -DROP INDEX authentication_method_id ON lams_user; -DROP INDEX workspace_id ON lams_user; -DROP INDEX login ON lams_user; -DROP INDEX PRIMARY ON lams_learning_design; -DROP INDEX idx_design_parent_id ON lams_learning_design; -DROP INDEX idx_design_user_id ON lams_learning_design; -DROP INDEX idx_design_first_act ON lams_learning_design; -DROP INDEX PRIMARY ON lams_group; -DROP INDEX idx_group_grouping ON lams_group; -DROP INDEX PRIMARY ON lams_user_organisation; -DROP INDEX user_id ON lams_user_organisation; -DROP INDEX organisation_id ON lams_user_organisation; -DROP INDEX PRIMARY ON lams_learning_activity; -DROP INDEX idx_activity_library_id ON lams_learning_activity; -DROP INDEX idx_activity_design_id ON lams_learning_activity; -DROP INDEX idx_activity_grouping_id ON lams_learning_activity; -DROP INDEX idx_activity_activity_type_id ON lams_learning_activity; -DROP INDEX idx_activity_parent_id ON lams_learning_activity; -DROP INDEX PRIMARY ON lams_user_organisation_role; -DROP INDEX role_id ON lams_user_organisation_role; -DROP INDEX user_organisation_id ON lams_user_organisation_role; -DROP INDEX PRIMARY ON lams_learning_transition; -DROP INDEX ldId ON lams_learning_transition; -DROP INDEX idx_transition_to_activity ON lams_learning_transition; -DROP INDEX idx_transition_from_activity ON lams_learning_transition; +DROP TABLE IF EXISTS lams_learning_transition; +DROP TABLE IF EXISTS lams_activity_learners; +DROP TABLE IF EXISTS lams_tool_content; +DROP TABLE IF EXISTS lams_user_group; +DROP TABLE IF EXISTS lams_user_tool_session; +DROP TABLE IF EXISTS lams_progress_attempted; +DROP TABLE IF EXISTS lams_progress_completed; +DROP TABLE IF EXISTS lams_user_organisation_role; +DROP TABLE IF EXISTS lams_tool_session; +DROP TABLE IF EXISTS lams_learner_progress; +DROP TABLE IF EXISTS lams_learning_activity; +DROP TABLE IF EXISTS lams_lesson_learner; +DROP TABLE IF EXISTS lams_lesson; +DROP TABLE IF EXISTS lams_user_organisation; +DROP TABLE IF EXISTS lams_group; +DROP TABLE IF EXISTS lams_learning_design; +DROP TABLE IF EXISTS lams_user; +DROP TABLE IF EXISTS lams_organisation; +DROP TABLE IF EXISTS lams_grouping; +DROP TABLE IF EXISTS lams_workspace; +DROP TABLE IF EXISTS lams_workspace_folder; +DROP TABLE IF EXISTS lams_authentication_method; +DROP TABLE IF EXISTS lams_authentication_method_type; +DROP TABLE IF EXISTS lams_lesson_state; +DROP TABLE IF EXISTS lams_user_tool_session_state; +DROP TABLE IF EXISTS lams_tool_session_state; +DROP TABLE IF EXISTS lams_tool; +DROP TABLE IF EXISTS lams_role; +DROP TABLE IF EXISTS lams_organisation_type; +DROP TABLE IF EXISTS lams_learning_library; +DROP TABLE IF EXISTS lams_learning_activity_type; +DROP TABLE IF EXISTS lams_grouping_type; +DROP TABLE IF EXISTS lams_gate_activity_level; +DROP TABLE IF EXISTS lams_tool_session_type; -DROP TABLE lams_learning_transition; -DROP TABLE lams_activity_learners; -DROP TABLE lams_tool_content; -DROP TABLE lams_user_group; -DROP TABLE lams_user_tool_session; -DROP TABLE lams_progress_attempted; -DROP TABLE lams_progress_completed; -DROP TABLE lams_user_organisation_role; -DROP TABLE lams_tool_session; -DROP TABLE lams_learner_progress; -DROP TABLE lams_learning_activity; -DROP TABLE lams_lesson; -DROP TABLE lams_user_organisation; -DROP TABLE lams_group; -DROP TABLE lams_learning_design; -DROP TABLE lams_user; -DROP TABLE lams_organisation; -DROP TABLE lams_grouping; -DROP TABLE lams_workspace; -DROP TABLE lams_workspace_folder; -DROP TABLE lams_authentication_method; -DROP TABLE lams_authentication_method_type; -DROP TABLE lams_lesson_state; -DROP TABLE lams_user_tool_session_state; -DROP TABLE lams_tool_session_state; -DROP TABLE lams_tool; -DROP TABLE lams_role; -DROP TABLE lams_organisation_type; -DROP TABLE lams_learning_library; -DROP TABLE lams_learning_activity_type; -DROP TABLE lams_grouping_type; -DROP TABLE lams_gate_activity_level; @@ -110,5 +64,3 @@ - - Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -rbf3d839b523336d9b97a1b135a358d898605d6be -r30f0dc9c0ccc658a39c3ecf7bc11657f72f7f0f1 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision bf3d839b523336d9b97a1b135a358d898605d6be) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 30f0dc9c0ccc658a39c3ecf7bc11657f72f7f0f1) @@ -61,11 +61,12 @@ INSERT INTO lams_tool_session_type VALUES (1, 'GROUPED'); INSERT INTO lams_tool_session_type VALUES (2, 'NON_GROUPED'); -INSERT INTO lams_lesson_state VALUES (1, 'NOT_STARTED'); -INSERT INTO lams_lesson_state VALUES (2, 'STARTED'); -INSERT INTO lams_lesson_state VALUES (3, 'SUSPENDED'); -INSERT INTO lams_lesson_state VALUES (4, 'FINISHED'); -INSERT INTO lams_lesson_state VALUES (5, 'ARCHIVED'); +INSERT INTO lams_lesson_state VALUES (1, 'CREATED'); +INSERT INTO lams_lesson_state VALUES (2, 'NOT_STARTED'); +INSERT INTO lams_lesson_state VALUES (3, 'STARTED'); +INSERT INTO lams_lesson_state VALUES (4, 'SUSPENDED'); +INSERT INTO lams_lesson_state VALUES (5, 'FINISHED'); +INSERT INTO lams_lesson_state VALUES (6, 'ARCHIVED');