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
Monday 07 Feb 2005
1:06 pm

mminhas

*** empty log message ***

Options
    • -0
    • +1
    ./drop_lams_11_tables.sql
    • -9
    • +395
    ./insert_test_data.sql
10: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.
8: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
11:28 am

jfang

learning design test data added

Options
    • -0
    • +20
    ./insert_test_data.sql
9: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
12:11 pm

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
9:50 am

dgarth

added extra columns to user insert

Options
    • -3
    • +3
    ./insert_test_data.sql
9: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
2:22 pm

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.
9:22 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
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:46 am

cperfect

no message

Options
    • -31
    • +0
    ./add_workspace_tables.sql
    • -566
    • +0
    ./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
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
Monday 10 Jan 2005
2:54 pm

jfang

change tool session state default value

Options
    • -8
    • +6
    ./create_lams_db.sql
    • -5
    • +3
    ./insert_types_data.sql
Thursday 16 Dec 2004
2:02 pm

fyang

*** empty log message ***

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -1
    • +2
    ./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
    • -1
    • +1
    ./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
    • -1
    • +2
    ./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
    • -36
    • +46
    ./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
    • -519
    • +0
    ./setup_lams_tables.sql
12:45 pm

fyang

all in one create lams database script

Options
    • -0
    • +556
    ./create_lams_db.sql
Sunday 12 Dec 2004
1:24 pm

fyang

drop,create and populate 3 in 1 script

Options
    • -0
    • +519
    ./setup_lams_tables.sql
1:24 pm

fyang

*** empty log message ***

Options
    • -0
    • +33
    ./insert_test_data.sql
  2. … 11 more files in changeset.