drop_lams_11_tables.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
LDEV-4180: Make DB patches produce up-to-date structure during build instead of applying multiple patches. Get rid of unnecessary tables and keys. Modify boolean columns to tinyint(1) Simplify patches where possible.

  1. … 223 more files in changeset.
LDEV-3776: Remove $Id CVS keyword.

  1. … 1074 more files in changeset.
LDEV-3776: Remove $Id CVS keyword.

  1. … 782 more files in changeset.
LDEV-3633: Allow specyfing port which MySQL runs on. Disable SSL for building LAMS as it generates a warning message. New MySQL does not accept ALTER IGNORE TABLE statements.

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

  1. … 2 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. … 13 more files in changeset.
*** empty log message ***

  1. … 33 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 ***

  1. … 1 more file in changeset.
*** empty log message ***

  1. … 1 more file in changeset.
fk activity id in tool_session

  1. … 3 more files in changeset.