lams-github / lams_common / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 26
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
6:50 am

jfang

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

Options
    • -6
    • +6
    ./create_lams_11_tables.sql
Monday 14 Mar 2005
6:39 am

mminhas

*** empty log message ***

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

mminhas

got rid of Duplicate column name 'lesson_name' in lams_learning_design

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
Thursday 10 Mar 2005
2:15 pm

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
    ./insert_test_data.sql
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
    • -36
    • +59
    ./create_lams_11_tables.sql
    • -0
    • +5
    ./drop_lams_11_tables.sql
    • -0
    • +31
    ./insert_types_data.sql
  4. … 1 more file in changeset.
Monday 07 Mar 2005
10:56 am

jfang

added new lesson field and modify the problematic test data

Options
    • -5
    • +5
    ./insert_test_data.sql
    • -8
    • +7
    ./insert_types_data.sql
Friday 04 Mar 2005
12:00 pm

mminhas

*** empty log message ***

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

mminhas

lesson_name field added to learning_design

Options
    • -0
    • +1
    ./create_lams_11_tables.sql
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
    • -8
    • +11
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Tuesday 01 Mar 2005
7:12 am

mminhas

test data for transition modified

Options
    • -1
    • +1
    ./insert_test_data.sql
6:10 am

jfang

fix up the truncation error caused by new MySql connector

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
Monday 28 Feb 2005
3:08 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
    • -16
    • +87
    ./create_lams_11_tables.sql
3:06 pm

fmalikoff

Added content repository tables

Options
    • -0
    • +6
    ./drop_lams_11_tables.sql
2:03 pm

jfang

upgrade mysql connector to 3.1.7

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

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -0
    • +10
    ./create_lams_11_tables.sql
    • -0
    • +1
    ./drop_lams_11_tables.sql
    • -0
    • +7
    ./insert_test_data.sql
  4. … 1 more file in changeset.
Friday 25 Feb 2005
8:16 am

cperfect

added waiting flag to progress table

Options
    • -0
    • +1
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Thursday 24 Feb 2005
2:42 pm

mminhas

Transitions for childActivities of ComplexActivities removed.

Options
    • -14
    • +17
    ./insert_test_data.sql
9:29 am

jfang

activity strategy for calculating children activity completion status implemented and tested

Options
    • -1
    • +1
    ./insert_test_data.sql
  2. … 10 more files in changeset.
Wednesday 23 Feb 2005
3:05 pm

jfang

fix up the broken tool session code. As the new lesson attribute can not be null, it should go into the constructor

Options
    • -0
    • +7
    ./insert_test_data.sql
  2. … 5 more files in changeset.
8:58 am

mminhas

Additional test-data for lams_learning_activity ,lams_learning_transition and lams_tool_content added

Options
    • -22
    • +155
    ./insert_test_data.sql
Tuesday 22 Feb 2005
2:30 pm

jfang

add test data for random grouping and fixed some broken test case due to the code merge

Options
    • -3
    • +7
    ./insert_test_data.sql
  2. … 1 more file in changeset.
12:57 pm

mminhas

Test data provided for additional columns help_text and run_offline_flag

Options
    • -93
    • +90
    ./insert_test_data.sql
10:30 am

cperfect

added run_offline_flag to activity table

Options
    • -0
    • +1
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
6:25 am

jfang

added grouping data into testing sql script

Options
    • -4
    • +9
    ./insert_test_data.sql
  2. … 2 more files in changeset.
Monday 21 Feb 2005
1:49 pm

jfang

test group based tool session

Options
    • -1
    • +6
    ./insert_test_data.sql
  2. … 7 more files in changeset.
Thursday 17 Feb 2005
6:17 am

jfang

get rid of the # comment which make ant call failure

Options
    • -5
    • +1
    ./drop_lams_11_tables.sql
5:58 am

mminhas

default data for lams_copy_type table

Options
    • -1
    • +3
    ./insert_types_data.sql
Wednesday 16 Feb 2005
1:47 pm

mminhas

*** empty log message ***

Options
    • -11
    • +6
    ./insert_types_data.sql
1:44 pm

mminhas

Latest test data

Options
    • -27
    • +24
    ./insert_test_data.sql
1:16 pm

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -2
    • +2
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.