lams / lams_common

db

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit:
Commits this week: 0
Total Lines of Code (LoC): 9,011
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
Wednesday 06 Apr 2005
5: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
    ./model/lams_11.clay
    • -5
    • +9
    ./sql/create_lams_11_tables.sql
    • -3
    • +3
    ./sql/insert_test_data.sql
  4. … 2 more files in changeset.
Thursday 31 Mar 2005
2:47 am

jfang

change some grouping data to make more sense.

Options
    • -2
    • +2
    ./sql/insert_test_data.sql
Sunday 27 Mar 2005
4:58 pm

yoichi

table names alphabetically sorted

Options
    • -36
    • +40
    ./sql/drop_lams_11_tables.sql
4:32 pm

yoichi

create tables and insert statementsd are out of date and removed

Options
    • -526
    • +0
    ./sql/create_lams_11_db.sql
12:37 pm

yoichi

DEFAULT CHARACTER SET utf8 is added to CREATE DATABASE

DEFAULT 0 is removed from AUTO_INCREMENT

Options
    • -18
    • +19
    ./sql/create_lams_11_db.sql
Tuesday 22 Mar 2005
2:30 am

jfang

update apply grouping flag test data

Options
    • -11
    • +11
    ./sql/insert_test_data.sql
1:40 am

cperfect

Modified table lams_workspace:

made root_folder_id nullable

Options
    • -16
    • +16
    ./model/lams_11.clay
    • -1
    • +1
    ./sql/create_lams_11_tables.sql
Monday 21 Mar 2005
7:34 am

jfang

update java code against change in database

Options
    • -2
    • +2
    ./sql/create_lams_11_tables.sql
    • -104
    • +176
    ./sql/insert_test_data.sql
  3. … 4 more files in changeset.
Friday 18 Mar 2005
5:32 am

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
    ./model/lams_11.clay
    • -53
    • +73
    ./sql/create_lams_11_tables.sql
    • -0
    • +10
    ./sql/drop_lams_11_tables.sql
    • -1
    • +12
    ./sql/insert_types_data.sql
Wednesday 16 Mar 2005
1:20 am

jfang

change survey tool to real url

add test user to group

Options
    • -1
    • +2
    ./sql/insert_test_data.sql
Tuesday 15 Mar 2005
4:10 am

cperfect

altered table lams_learning_activity:

added apply_grouping_flag

Options
    • -0
    • +13
    ./model/lams_11.clay
    • -0
    • +2
    ./sql/create_lams_11_tables.sql
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
    ./model/lams_11.clay
    • -2
    • +17
    ./sql/create_lams_11_tables.sql
    • -0
    • +5
    ./sql/drop_lams_11_tables.sql
    • -0
    • +8
    ./sql/insert_types_data.sql
Monday 14 Mar 2005
11:50 pm

jfang

remove the default timestamp value 0000-00-00 generated by clay

Options
    • -6
    • +6
    ./sql/create_lams_11_tables.sql
Sunday 13 Mar 2005
11:38 pm

mminhas

*** empty log message ***

Options
    • -28
    • +31
    ./sql/insert_test_data.sql
    • -24
    • +0
    ./sql/insert_types_data.sql
Friday 11 Mar 2005
1:44 am

mminhas

got rid of Duplicate column name 'lesson_name' in lams_learning_design

Options
    • -1
    • +0
    ./sql/create_lams_11_tables.sql
Thursday 10 Mar 2005
7:15 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
    • -609
    • +605
    ./sql/insert_test_data.sql
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
    ./model/lams_11.clay
    • -36
    • +59
    ./sql/create_lams_11_tables.sql
    • -0
    • +5
    ./sql/drop_lams_11_tables.sql
    • -0
    • +31
    ./sql/insert_types_data.sql
Monday 07 Mar 2005
3:56 am

jfang

added new lesson field and modify the problematic test data

Options
    • -5
    • +5
    ./sql/insert_test_data.sql
    • -8
    • +7
    ./sql/insert_types_data.sql
Friday 04 Mar 2005
4:57 am

mminhas

*** empty log message ***

Options
    • -14
    • +14
    ./sql/insert_test_data.sql
  2. … 2 more files in changeset.
1:23 am

mminhas

lesson_name field added to learning_design

Options
    • -0
    • +1
    ./sql/create_lams_11_tables.sql
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
    ./model/lams_11.clay
    • -8
    • +11
    ./sql/create_lams_11_tables.sql
Tuesday 01 Mar 2005
12:12 am

mminhas

test data for transition modified

Options
    • -1
    • +1
    ./sql/insert_test_data.sql
Monday 28 Feb 2005
11:10 pm

jfang

fix up the truncation error caused by new MySql connector

Options
    • -1
    • +1
    ./sql/create_lams_11_tables.sql
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
    ./model/lams_11.clay
8:08 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
    • -16
    • +87
    ./sql/create_lams_11_tables.sql
8:06 am

fmalikoff

Added content repository tables

Options
    • -0
    • +6
    ./sql/drop_lams_11_tables.sql
7:01 am

jfang

upgrade mysql connector to 3.1.7

Options
    • -1
    • +1
    ./sql/create_lams_11_tables.sql
    • -4
    • +4
    ./sql/insert_test_data.sql
    • -7
    • +7
    ./sql/insert_types_data.sql
  4. … 3 more files in changeset.
12:47 am

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -1
    • +54
    ./model/lams_11.clay
    • -0
    • +10
    ./sql/create_lams_11_tables.sql
    • -0
    • +1
    ./sql/drop_lams_11_tables.sql
    • -0
    • +7
    ./sql/insert_test_data.sql
Friday 25 Feb 2005
1:16 am

cperfect

added waiting flag to progress table

Options
    • -9
    • +22
    ./model/lams_11.clay
    • -0
    • +1
    ./sql/create_lams_11_tables.sql
Thursday 24 Feb 2005
7:42 am

mminhas

Transitions for childActivities of ComplexActivities removed.

Options
    • -14
    • +17
    ./sql/insert_test_data.sql