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 11 Feb 2005
2:24 am

jfang

add some domain convenient methods, such as getAllLearners for a lesson, validate the

type of an acitivity.

change cascade to save-update between learningdesign and activity.

Options
    • -3
    • +3
    ./insert_test_data.sql
  2. … 11 more files in changeset.
Wednesday 09 Feb 2005
5:05 am

jfang

add IF EXISTS to ensure it is always working

Options
    • -32
    • +32
    ./drop_lams_11_tables.sql
2:19 am

jfang

add tool content id for all tool activity test data

Options
    • -20
    • +27
    ./insert_test_data.sql
Tuesday 08 Feb 2005
6:07 am

mminhas

tool_id added to lams_learning_activity

Options
    • -11
    • +11
    ./insert_test_data.sql
5:54 am

jfang

*** empty log message ***

Options
    • -22
    • +22
    ./insert_test_data.sql
5:35 am

mminhas

some changes to Transition test data

Options
    • -8
    • +8
    ./insert_test_data.sql
5:32 am

cperfect

changed the class_name field in the lams_tool_table to service_name

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

mminhas

converted # symbol to --

Options
    • -1
    • +1
    ./insert_test_data.sql
12:02 am

dgarth

Create script for that lams11 DB

Options
    • -0
    • +566
    ./create_lams_11_db.sql
Monday 07 Feb 2005
6:41 am

mminhas

value of first_activity_id changed corresponding to the test design data

Options
    • -8
    • +7
    ./insert_test_data.sql
6:39 am

mminhas

*** empty log message ***

Options
    • -5
    • +6
    ./insert_test_data.sql
6:19 am

mminhas

*** empty log message ***

Options
    • -1
    • +0
    ./drop_lams_11_tables.sql
6:06 am

mminhas

*** empty log message ***

Options
    • -0
    • +1
    ./drop_lams_11_tables.sql
    • -9
    • +395
    ./insert_test_data.sql
  3. … 1 more file in changeset.
3:34 am

cperfect

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

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

cperfect

fk activity id in tool_session

Options
    • -78
    • +72
    ./create_lams_11_tables.sql
    • -34
    • +33
    ./drop_lams_11_tables.sql
    • -27
    • +7
    ./insert_types_data.sql
  4. … 1 more file in changeset.
Thursday 03 Feb 2005
4:28 am

jfang

learning design test data added

Options
    • -0
    • +20
    ./insert_test_data.sql
2:20 am

jfang

correct the drop script - two drop statements are missing.

changed the lesson state type data

Options
    • -82
    • +34
    ./drop_lams_11_tables.sql
    • -5
    • +6
    ./insert_types_data.sql
Wednesday 02 Feb 2005
5:11 am

dgarth

Removed lams_user_tool_session and states, added lams_tool_session_type

Options
    • -22
    • +36
    ./create_lams_11_tables.sql
    • -5
    • +8
    ./insert_types_data.sql
2:50 am

dgarth

added extra columns to user insert

Options
    • -3
    • +3
    ./insert_test_data.sql
2:50 am

dgarth

removed some defaults on fkeys

updated lams_learner_progress with current and next activity

Options
    • -28
    • +32
    ./create_lams_11_tables.sql
Monday 31 Jan 2005
7:22 am

cperfect

fixed some defualt 0 for nullable fks in activity table

Options
    • -3
    • +3
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
2:21 am

cperfect

changed authentication method table to match Fei's changes

Options
    • -1
    • +13
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Tuesday 25 Jan 2005
12:24 am

cperfect

changes for lessons

Options
    • -8
    • +6
    ./create_lams_11_tables.sql
    • -3
    • +13
    ./insert_types_data.sql
  3. … 1 more file in changeset.
Monday 17 Jan 2005
3:57 am

fyang

change SUB-ORGANIZATION as SUB-ORGANISATION

Options
    • -1
    • +1
    ./insert_types_data.sql
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
    • -1
    • +5
    ./create_lams_11_tables.sql
    • -1
    • +1
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
Tuesday 11 Jan 2005
3:39 am

cperfect

updated db

Options
    • -82
    • +101
    ./create_lams_11_tables.sql
    • -287
    • +13
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
3:38 am

cperfect

moved old scripts to old folder

Options
    • -0
    • +31
    ./old/add_workspace_tables.sql
    • -0
    • +462
    ./old/create_lams_11_tables.sql
    • -0
    • +568
    ./old/create_lams_db.sql
    • -0
    • +270
    ./old/create_learning_design_tables.sql
    • -0
    • +142
    ./old/create_user_management_tables.sql
    • -0
    • +114
    ./old/drop_lams_11_tables.sql
    • -0
    • +140
    ./old/drop_learning_design_tables.sql
    • -0
    • +31
    ./old/drop_user_management_tables.sql
    • -0
    • +39
    ./old/insert_test_data.sql
    • -0
    • +62
    ./old/insert_types_data.sql
    • -0
    • +26
    ./old/insert_user_management_data.sql
    • -0
    • +547
    ./old/lams_11_scratch.sql
    • -0
    • +43
    ./old/tables.txt
3:38 am

cperfect

no message

Options
    • -31
    • +0
    ./add_workspace_tables.sql
    • binary
    ./create_lams_db.sql
    • -270
    • +0
    ./create_learning_design_tables.sql
    • -142
    • +0
    ./create_user_management_tables.sql
    • -140
    • +0
    ./drop_learning_design_tables.sql
    • -31
    • +0
    ./drop_user_management_tables.sql
    • -26
    • +0
    ./insert_user_management_data.sql
    • -8
    • +6
    ./old/create_lams_db.sql
  9. … 2 more files in changeset.
Monday 10 Jan 2005
7:54 am

jfang

change tool session state default value

Options
    • binary
    ./create_lams_db.sql
    • -5
    • +3
    ./insert_types_data.sql
Thursday 16 Dec 2004
7:01 am

fyang

*** empty log message ***

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • binary
    ./create_lams_db.sql
    • -3
    • +3
    ./insert_test_data.sql