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
Wednesday 16 Feb 2005
6:02 am

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.
1: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
3:19 am

dgarth

changed id to ui_id in activity and transition

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

dgarth

added set foreign_key_checks

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

dgarth

replaced lams11 with lams

Options
    • -3
    • +3
    ./create_lams_11_db.sql
1: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.
1: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.
Monday 14 Feb 2005
11:59 pm

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.
Friday 11 Feb 2005
5:22 am

jfang

tool session hibernate object and mapping file corrected.

NonGroupedToolSession creation and deletion process tested.

Options
    • -5
    • +0
    ./create_lams_11_tables.sql
  2. … 10 more files in changeset.
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.