lams_11.clay

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
DB cahnges base don discussions about monitoring with james: learning design table: added columns: lesson_org_id lesson_org_name lesson_id lesson_start_date_time lesson_name (all implicit fks to org or lesson table) lesson table: added columns: schedule start date time schedule end date time modified: organisation_id now nullable class_grouping_id now nullable

  1. … 1 more file in changeset.
Added content repository tables. There are a couple of other changes but these appear to be earlier changes to the clay model which haven't appeared in the create_tables_11: create_date in lams_role and activity_category_id in lams_learning_activity. lams_grouping has also changed location in the file.

made from_ui_id and to_ui_id in transition table nullable

  1. … 3 more files in changeset.
added waiting flag to progress table

  1. … 1 more file in changeset.
added run_offline_flag to activity table

  1. … 1 more file in changeset.
made from_ui_id and to_ui_id in transition table nullable

  1. … 1 more file in changeset.
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 previous_activity_id to LearnerProgress

  1. … 1 more file in changeset.
updated license table to match lams community version, fixed typos/naming conventions. Added licenses to insert types

  1. … 2 more files in changeset.
added license table and fields in ld table

  1. … 2 more files in changeset.
added latest column changes from discussion with Dave, fixed create script to work with MySQL 4.1 (removed defaults)

  1. … 1 more file in changeset.
changed the class_name field in the lams_tool_table to service_name

  1. … 1 more file in changeset.
altered transition table so that from and to activity id are nullable

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

  1. … 3 more files in changeset.
changed tool session

fixed some defualt 0 for nullable fks in activity table

  1. … 1 more file in changeset.
changed authentication method table to match Fei's changes

  1. … 1 more file in changeset.
changes for lessons

  1. … 2 more files 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.
Added library_activity_ui_image to lams_learning_activity and max_no_of_groups to lams_grouping

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

  1. … 2 more files in changeset.
Updated DB design: changes to lesson realted tables. lams_tool_content table removed. Added nee columns to lams_tool table.

  1. … 2 more files in changeset.
added lesson state

no message

  1. … 1 more file in changeset.
no message

  1. … 3 more files in changeset.
no message

no message

    • -0
    • +2140
    ./lams_11.clay
  1. … 9 more files in changeset.