drop_lams_11_tables.sql

  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
LDEV-3776: Remove $Id CVS keyword.

  1. … 1074 more files in changeset.
LDEV-2903: Delete lams_lesson_learner table.

  1. … 3 more files in changeset.
LDEV-2544 Default Timezones

*merge from lams2_3_release

  1. … 35 more files in changeset.
LDEV-2420 Removing uneccessary data structures and tables from the db, as well as implementing the same theme settings for flash themes

  1. … 49 more files in changeset.
LDEV-1998: Added Pedagogical Planner editor with add/edit node functionality.

  1. … 46 more files in changeset.
Added event notification service.

  1. … 17 more files in changeset.
Added cvs id - preparing for porting to postgreSQL

  1. … 8 more files in changeset.
Add drop instructions for Quartz tables.

Added initial Theme support

  1. … 48 more files in changeset.
*** empty log message ***

  1. … 10 more files in changeset.
get rid of comments that cause the failure of ant run

removed the "use lams" clause: makes testing very difficult

table names alphabetically sorted

added table lams_log_event_type

added table lams_log_event (includes fk to lams_log_event_type)

modified table lams_tool:

added create_date_time

modified insert_types_data.sql:

added values for lasm_log_event_type

  1. … 3 more files in changeset.
Added table:

lams_grouping_support_type

Modified table lams_tool:

added supports_contribution_flag

added supports_moderation_flag

added grouping_support_type_id (fk to lams_grouping_support_type)

Modifed table lams_learning_activity:

added online_instructions

added grouping_support_type_id (fk to lams_grouping_support_type)

Modified insert_types_data.sql to include 3 values for lams_grouping_support: NONE, OPTIONAL, REQUIRED

  1. … 3 more files in changeset.
added table lams_workspace_folder_type (and values for it to insert_types sql)

|

lams_workspace_folder:

added user_id (implicit fk to user table)

added create_date_time

added last_modified_date_time

added lams_workspace_folder_type_id (fk to lasm_workspace_folder_type)

|

lams_learning_library:

added valid flag

|

lams_tool:

added valid_flag

added learning_library_id (fk to lams_learning_library)

|

lams_learning_design:

added last_modified_date_time

|

lams_lesson:

made name mandatory

|

lams_learner_progress

added requires_restart_flag

|

other: added values for workspace type to insert types

|

other moved values for auth method and activity category from insert test data to insert types data

  1. … 3 more files in changeset.
Added content repository tables

made from_ui_id and to_ui_id in transition table nullable

  1. … 3 more files in changeset.
get rid of the # comment which make ant call failure

added changes for monitoring to gate activities (gate_open, gate_start_date_time, gate_end_date_time), plus changed lesson_copy_flag to copy_type_id and added lams_copy_type table, added help_text to lams_activity table, added supports_moderation_flag and contribute_url lams_tool table

  1. … 3 more files in changeset.
added set foreign_key_checks

added license table and fields in ld table

  1. … 2 more files in changeset.
add IF EXISTS to ensure it is always working

*** empty log message ***

*** empty log message ***

  1. … 2 more files in changeset.
fk activity id in tool_session

  1. … 3 more files in changeset.
correct the drop script - two drop statements are missing.

changed the lesson state type data

  1. … 1 more file in changeset.
Altered LessonProgress:

has a set of completed activities

a set of attempted activities

and one current activity

  1. … 2 more files in changeset.
updated db

  1. … 2 more files in changeset.
Changed PKs to auto generate for dymanic tables, add lams_tool_content table

  1. … 2 more files in changeset.