lams / lams_common / db

model

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit:
Commits this week: 0
Total Lines of Code (LoC): 6,127
Net change in LoC this week: 0

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
Thursday 11 May 2006
2:57 pm

fmalikoff

Changing organisation structure to a simple root, course, class structure.

Options
    • -42
    • +2
    ./lams_11.clay
  2. … 37 more files in changeset.
Wednesday 10 May 2006
1:43 pm

fmalikoff

Moving gate and group url support to a lams_system_tool table - the first "inch" towards making these pluggable tools in a later version of LAMS.

Options
    • -5
    • +118
    ./lams_11.clay
  2. … 20 more files in changeset.
Friday 05 May 2006
2:59 pm

fmalikoff

Added chat id to the user table (for the jabber id)

Options
    • -2288
    • +2295
    ./lams_11.clay
  2. … 5 more files in changeset.
Tuesday 21 Mar 2006
9:12 am

fmalikoff

For 1.1 we will have separate theme definitions - Flash will use a handcoded XML file and HTML (jsps) will use a handcoded css file. As these two may not be in sync, we need two entries in the user table to link to themes. The db has been changed to have two entries but none of the java code is changed to match yet.

Options
    • -2280
    • +2300
    ./lams_11.clay
  2. … 3 more files in changeset.
Thursday 09 Mar 2006
8:38 am

steven

Remove nv_id in lams_cr_node table.

Options
    • -2292
    • +2279
    ./lams_11.clay
  2. … 2 more files in changeset.
Wednesday 08 Mar 2006
8:02 pm

fmalikoff

Split learner and export urls (in Tool) to have separate urls for teacher, learner and authoring modes. Added language file columns to activity and tool - this will be used to internationalise the activity and tool name and descriptions that are currently in the database.

Options
    • -2300
    • +2293
    ./lams_11.clay
  2. … 35 more files in changeset.
Thursday 16 Feb 2006
11:53 am

steven

upgrade for MySQL5.x

Options
    • -13
    • +0
    ./lams_11.clay
  2. … 2 more files in changeset.
Wednesday 08 Feb 2006
7:44 am

steven

Persist toolSessionName.

Options
    • -0
    • +7
    ./lams_11.clay
  2. … 3 more files in changeset.
Thursday 02 Feb 2006
1:51 pm

steven

Add group name.

Options
    • -2285
    • +2292
    ./lams_11.clay
  2. … 11 more files in changeset.
Tuesday 31 Jan 2006
8:53 pm

fmalikoff

Changed name of parentLearningDesign to originalLearningDesign. This field links the lesson version of a design back to its original design, but the parent name suggests that the parent learning design contains the child learning design (this is the meaning in the activity table) so the name was changed.

Options
    • -12
    • +5
    ./lams_11.clay
  2. … 9 more files in changeset.
Wednesday 21 Dec 2005
1:25 pm

fmalikoff

Added new column for the default run sequence folder for a workspace.

Options
    • -5
    • +25
    ./lams_11.clay
1:25 pm

fmalikoff

Out of data - to be redrawn if needed.

Options
    • -4668
    • +0
    ./lams_tables.clay
    • -788
    • +0
    ./learning_design.clay
    • -846
    • +0
    ./user_management.clay
Monday 22 Aug 2005
7:47 am

fmalikoff

Added initial Theme support

Options
    • -88
    • +336
    ./lams_11.clay
  2. … 48 more files in changeset.
Friday 17 Jun 2005
9:53 am

fmalikoff

Changed name of constraints - sometimes causes problems with creating the database.

Options
    • -11
    • +11
    ./lams_11.clay
    • -5
    • +5
    ./user_management.clay
  3. … 1 more file in changeset.
Thursday 05 May 2005
11:20 am

mminhas

*** empty log message ***

Options
    • -3
    • +162
    ./lams_11.clay
    • -179
    • +179
    ./lams_tables.clay
  3. … 9 more files in changeset.
Wednesday 06 Apr 2005
11:50 am

fmalikoff

DB Changes:

lams_tool: columns learning_library_id and default_tool_content_id made nullable (C Perfect's request).

lams_user: column user_organisation_id removed (checked with F Yang)

Options
    • -18
    • +5
    ./lams_11.clay
  2. … 4 more files in changeset.
Tuesday 22 Mar 2005
8:40 am

cperfect

Modified table lams_workspace:

made root_folder_id nullable

Options
    • -16
    • +16
    ./lams_11.clay
  2. … 1 more file in changeset.
Friday 18 Mar 2005
12:32 pm

cperfect

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

Options
    • -9
    • +134
    ./lams_11.clay
  2. … 3 more files in changeset.
Tuesday 15 Mar 2005
11:10 am

cperfect

altered table lams_learning_activity:

added apply_grouping_flag

Options
    • -0
    • +13
    ./lams_11.clay
  2. … 1 more file in changeset.
10: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
11: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
7: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
3:35 pm

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
7:47 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
8: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
10: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
1:16 pm

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.
1:02 pm

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.
8: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
8: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.