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
Tuesday 25 Jan 2005
7: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
10:57 am

fyang

change SUB-ORGANIZATION as SUB-ORGANISATION

Options
    • -1
    • +1
    ./insert_types_data.sql
Friday 14 Jan 2005
7: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
10: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.
10: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
10: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
2:54 pm

jfang

change tool session state default value

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

fyang

*** empty log message ***

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • binary
    ./create_lams_db.sql
    • -3
    • +3
    ./insert_test_data.sql
11:34 am

fyang

change user names and authentication method names for testing

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

fyang

make base_organisation_id nullable (sysadmin has no base organisation)

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
    • binary
    ./create_lams_db.sql
6:33 am

fyang

add some test data

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

fyang

*** empty log message ***

Options
    • binary
    ./create_lams_db.sql
6:29 am

fyang

remove user_organisation_id column

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
Wednesday 15 Dec 2004
11: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.
7: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
1:57 pm

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
12:46 pm

fyang

*** empty log message ***

Options
    • binary
    ./setup_lams_tables.sql
  2. … 2 more files in changeset.
12:45 pm

fyang

all in one create lams database script

Options
    • binary
    ./create_lams_db.sql
Sunday 12 Dec 2004
1:24 pm

fyang

drop,create and populate 3 in 1 script

Options
    • binary
    ./setup_lams_tables.sql
1:24 pm

fyang

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

be there

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

fyang

*** empty log message ***

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

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
2:20 pm

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
Monday 29 Nov 2004
1:13 pm

fyang

fix duplicate entry error

Options
    • -1
    • +1
    ./insert_types_data.sql
11:29 am

cperfect

no message

Options
    • -61
    • +56
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Friday 26 Nov 2004
8:36 am

cperfect

no message

Options
    • -0
    • +62
    ./insert_types_data.sql
8:15 am

cperfect

no message

Options
    • -84
    • +183
    ./create_lams_11_tables.sql
    • -28
    • +30
    ./drop_lams_11_tables.sql
  3. … 2 more files in changeset.
Tuesday 23 Nov 2004
1:32 pm

cperfect

no message

Options
    • -0
    • +328
    ./create_lams_11_tables.sql
    • -0
    • +270
    ./create_learning_design_tables.sql
    • -1
    • +4
    ./create_user_management_tables.sql
    • -0
    • +112
    ./drop_lams_11_tables.sql
    • -0
    • +140
    ./drop_learning_design_tables.sql
    • -3
    • +7
    ./insert_user_management_data.sql
  7. … 4 more files in changeset.
Wednesday 17 Nov 2004
8:43 am

cperfect

no message

Options
    • -0
    • +3
    ./create_user_management_tables.sql
  2. … 2 more files in changeset.
Thursday 11 Nov 2004
11:01 am

cperfect

no message

Options
    • -0
    • +31
    ./add_workspace_tables.sql
    • -0
    • +136
    ./create_user_management_tables.sql
    • -0
    • +31
    ./drop_user_management_tables.sql
    • -0
    • +22
    ./insert_user_management_data.sql
  5. … 4 more files in changeset.