lams / lams_common / db

sql

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): 2,833
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
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
    • -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:01 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:47 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:04 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
    • -23
    • +156
    ./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.
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
    • -3
    • +17
    ./create_lams_11_tables.sql
    • -0
    • +5
    ./drop_lams_11_tables.sql
    • -0
    • +9
    ./insert_types_data.sql
  4. … 1 more file in changeset.
8:49 am

cperfect

added previous_activity_id to LearnerProgress

Options
    • -0
    • +4
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Tuesday 15 Feb 2005
10:19 am

dgarth

changed id to ui_id in activity and transition

Options
    • -55
    • +55
    ./insert_test_data.sql
10:18 am

dgarth

added set foreign_key_checks

Options
    • -32
    • +3
    ./drop_lams_11_tables.sql
10:17 am

dgarth

replaced lams11 with lams

Options
    • -3
    • +3
    ./create_lams_11_db.sql
8:51 am

cperfect

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

Options
    • -4
    • +3
    ./create_lams_11_tables.sql
    • -0
    • +10
    ./insert_types_data.sql
  3. … 1 more file in changeset.
8:12 am

cperfect

added license table and fields in ld table

Options
    • -0
    • +16
    ./create_lams_11_tables.sql
    • -0
    • +5
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
6:59 am

cperfect

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

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