lams-github / lams_common / db

model

Clone Tools

Stats

Commits this week: 0
Total Committers: 7
Last Commit:
Commits this week: 0

Lines of code count not available

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 15 Mar 2005
3:54 am

cperfect

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

Options
    • -6
    • +98
    ./lams_11.clay
  2. … 3 more files in changeset.
Thursday 10 Mar 2005
4:26 am

cperfect

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

Options
    • -12
    • +169
    ./lams_11.clay
  2. … 3 more files in changeset.
Friday 04 Mar 2005
12:53 am

cperfect

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

Options
    • -21
    • +78
    ./lams_11.clay
  2. … 1 more file in changeset.
Monday 28 Feb 2005
8:35 am

fmalikoff

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.

Options
    • -6
    • +426
    ./lams_11.clay
12:52 am

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -1
    • +54
    ./lams_11.clay
  2. … 3 more files in changeset.
Friday 25 Feb 2005
1:16 am

cperfect

added waiting flag to progress table

Options
    • -9
    • +22
    ./lams_11.clay
  2. … 1 more file in changeset.
Tuesday 22 Feb 2005
3:30 am

cperfect

added run_offline_flag to activity table

Options
    • -40
    • +53
    ./lams_11.clay
  2. … 1 more file in changeset.
Wednesday 16 Feb 2005
6:16 am

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -2
    • +2
    ./lams_11.clay
  2. … 1 more file in changeset.
6:02 am

cperfect

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

Options
    • -18
    • +95
    ./lams_11.clay
  2. … 3 more files in changeset.
1:49 am

cperfect

added previous_activity_id to LearnerProgress

Options
    • -0
    • +20
    ./lams_11.clay
  2. … 1 more file in changeset.
Tuesday 15 Feb 2005
1:51 am

cperfect

updated license table to match lams community version, fixed typos/naming conventions. Added licenses to insert types

Options
    • -17
    • +11
    ./lams_11.clay
  2. … 2 more files in changeset.
1:12 am

cperfect

added license table and fields in ld table

Options
    • -2
    • +101
    ./lams_11.clay
  2. … 2 more files in changeset.
Monday 14 Feb 2005
11:59 pm

cperfect

added latest column changes from discussion with Dave, fixed create script to work with MySQL 4.1 (removed defaults)

Options
    • -100
    • +199
    ./lams_11.clay
  2. … 1 more file in changeset.
Tuesday 08 Feb 2005
5:32 am

cperfect

changed the class_name field in the lams_tool_table to service_name

Options
    • -2
    • +2
    ./lams_11.clay
  2. … 1 more file in changeset.
Monday 07 Feb 2005
3:34 am

cperfect

altered transition table so that from and to activity id are nullable

Options
    • -4
    • +4
    ./lams_11.clay
  2. … 1 more file in changeset.
1:33 am

cperfect

fk activity id in tool_session

Options
    • -43
    • +63
    ./lams_11.clay
  2. … 3 more files in changeset.
12:57 am

cperfect

changed tool session

Options
    • -111
    • +142
    ./lams_11.clay
Monday 31 Jan 2005
7:22 am

cperfect

fixed some defualt 0 for nullable fks in activity table

Options
    • -6
    • +6
    ./lams_11.clay
  2. … 1 more file in changeset.
2:22 am

cperfect

changed authentication method table to match Fei's changes

Options
    • -4
    • +9
    ./lams_11.clay
  2. … 1 more file in changeset.
Tuesday 25 Jan 2005
12:24 am

cperfect

changes for lessons

Options
    • -35
    • +62
    ./lams_11.clay
  2. … 2 more files in changeset.
Friday 14 Jan 2005
12:29 am

cperfect

Altered LessonProgress: has a set of completed activities a set of attempted activities and one current activity

Options
    • -2
    • +22
    ./lams_11.clay
  2. … 2 more files in changeset.
Tuesday 11 Jan 2005
3:39 am

cperfect

updated db

Options
    • -9
    • +102
    ./lams_11.clay
  2. … 2 more files in changeset.
Wednesday 15 Dec 2004
4:44 am

cperfect

Added library_activity_ui_image to lams_learning_activity and max_no_of_groups to lams_grouping

Options
    • -0
    • +20
    ./lams_11.clay
  2. … 1 more file in changeset.
Tuesday 14 Dec 2004
6:57 am

cperfect

Changed PKs to auto generate for dymanic tables, add lams_tool_content table

Options
    • -87
    • +122
    ./lams_11.clay
  2. … 2 more files in changeset.
Monday 06 Dec 2004
6:42 am

cperfect

Updated DB design: changes to lesson realted tables. lams_tool_content table removed. Added nee columns to lams_tool table.

Options
    • -121
    • +148
    ./lams_11.clay
  2. … 2 more files in changeset.
Wednesday 01 Dec 2004
3:36 am

cperfect

added lesson state

Options
    • -3
    • +56
    ./lams_11.clay
Monday 29 Nov 2004
4:32 am

cperfect

no message

Options
    • -1
    • +54
    ./lams_11.clay
  2. … 1 more file in changeset.
Friday 26 Nov 2004
1:16 am

cperfect

no message

Options
    • -344
    • +159
    ./lams_11.clay
    • -1
    • +1
    ./learning_design.clay
  3. … 2 more files in changeset.
12:08 am

cperfect

no message

Options
    • -99
    • +757
    ./lams_11.clay
Tuesday 23 Nov 2004
6:32 am

cperfect

no message

Options
    • -0
    • +2140
    ./lams_11.clay
    • -0
    • +788
    ./learning_design.clay
    • -3
    • +20
    ./user_management.clay
  4. … 7 more files in changeset.