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
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
4:34 am

fyang

change user names and authentication method names for testing

Options
    • -5
    • +5
    ./insert_test_data.sql
Wednesday 15 Dec 2004
11:38 pm

fyang

make base_organisation_id nullable (sysadmin has no base organisation)

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
    • binary
    ./create_lams_db.sql
11:33 pm

fyang

add some test data

Options
    • -1
    • +7
    ./insert_test_data.sql
11:33 pm

fyang

*** empty log message ***

Options
    • binary
    ./create_lams_db.sql
11:29 pm

fyang

remove user_organisation_id column

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
4:44 am

cperfect

Added library_activity_ui_image to lams_learning_activity and max_no_of_groups to lams_grouping

Options
    • -35
    • +31
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
12:45 am

fyang

change according to chris's change of create_lams_11_tables.sql

Options
    • binary
    ./create_lams_db.sql
Tuesday 14 Dec 2004
6:57 am

cperfect

Changed PKs to auto generate for dymanic tables, add lams_tool_content table

Options
    • -36
    • +41
    ./create_lams_11_tables.sql
    • -1
    • +277
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
Monday 13 Dec 2004
5:46 am

fyang

*** empty log message ***

Options
    • binary
    ./setup_lams_tables.sql
  2. … 2 more files in changeset.
5:45 am

fyang

all in one create lams database script

Options
    • binary
    ./create_lams_db.sql
Sunday 12 Dec 2004
6:24 am

fyang

drop,create and populate 3 in 1 script

Options
    • binary
    ./setup_lams_tables.sql
6:24 am

fyang

remove user_organisation_id column from lams_user table, because it shouldn't

be there

Options
    • -2
    • +1
    ./create_lams_11_tables.sql
6:17 am

fyang

*** empty log message ***

Options
    • -0
    • +33
    ./insert_test_data.sql
  2. … 11 more files in changeset.
Monday 06 Dec 2004
6:42 am

cperfect

Updated DB design: changes to lesson realted tables. lams_tool_content table removed. Added nee columns to lams_tool table.

Options
    • -85
    • +115
    ./create_lams_11_tables.sql
    • -14
    • +12
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
Thursday 02 Dec 2004
7:20 am

fyang

remove lams_authentication_method_parameter table;

add authentication_method_name column to lams_authentication_method table

Options
    • -11
    • +2
    ./create_lams_11_tables.sql