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
Monday 09 Jul 2007
3:20 pm

jliew

pre-select idp in lesson link for learner

Options
    • -2
    • +4
    ./insert_lams_unix_config_data.sql
    • -2
    • +4
    ./insert_lams_windows_config_data.sql
  3. … 4 more files in changeset.
Friday 06 Jul 2007
12:05 pm

fmalikoff

LDEV-1256: Added admin_url column to tool and system tool tables

Options
    • -1
    • +3
    ./create_lams_11_tables.sql
    • -2
    • +6
    ./updatescripts/alter_21_branching.sql
  3. … 7 more files in changeset.
Wednesday 04 Jul 2007
2:10 pm

jliew

add new column to lams_lesson_fed to store local lesson state of external lessons (for later)

Options
    • -0
    • +1
    ./create_sharedlesson_tables.sql
  2. … 3 more files in changeset.
Tuesday 03 Jul 2007
10:00 am

fmalikoff

Branching: Adding x and y co-ordinates for the start and stop points. This is to support to UI - the details are not used by the progress engine.

Options
    • -1
    • +5
    ./create_lams_11_tables.sql
    • -1
    • +6
    ./updatescripts/alter_21_branching.sql
  3. … 10 more files in changeset.
Friday 29 Jun 2007
2:55 pm

jliew

added new table to record list of external lessons joined by local groups

Options
    • -0
    • +12
    ./create_sharedlesson_tables.sql
  2. … 9 more files in changeset.
1:13 pm

fmalikoff

Branching: Added a new field firstActivity to the SequenceActivity, so Flash can easily indicate where to start in a sequence activity. That way, the logic works in the same way as it does in a learning design.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -0
    • +3
    ./updatescripts/alter_21_branching.sql
  3. … 5 more files in changeset.
Thursday 28 Jun 2007
2:43 pm

fmalikoff

Branching: Getting the progress engine working so it will display the branch activities if the sequence/branch contains one or no activities

Options
    • -5
    • +10
    ./create_lams_11_tables.sql
    • -4
    • +8
    ./updatescripts/alter_21_branching.sql
  3. … 11 more files in changeset.
11:22 am

fmalikoff

Updating version to 2.0.4 / 2.0.4 Dev

Options
    • -5
    • +5
    ./insert_lams_unix_config_data.sql
Thursday 21 Jun 2007
8:20 am

fmalikoff

Fix to add the system tool entry has been moved to a separate script on the lams2_0_3_fixes tag.

Options
    • -0
    • +30
    ./updatescripts/alter_204_editonfly.sql
8:15 am

fmalikoff

Changed script to include all the edit on the fly changes

Options
    • -0
    • +23
    ./updatescripts/alter_204_editonfly.sql
7:42 am

fmalikoff

Fix to add the system tool entry has been moved to a separate script on the lams2_0_3_fixes tag.

Options
    • -8
    • +0
    ./updatescripts/alter_203_editonfly.sql
7:01 am

fmalikoff

Move the system tool table update to a 2.0.4 script as we'll mark the "fixed" upgraders 2.0.4

Options
    • -5
    • +5
    ./insert_lams_unix_config_data.sql
    • -5
    • +5
    ./insert_lams_windows_config_data.sql
    • -8
    • +0
    ./updatescripts/alter_203_editonfly.sql
    • -0
    • +7
    ./updatescripts/alter_204_editonfly.sql
  5. … 1 more file in changeset.
7:01 am

fmalikoff

file alter_204_editonfly.sql was initially added on branch lams2_0_3_fixes.

Options
    • -0
    • +0
    ./updatescripts/alter_204_editonfly.sql
Monday 18 Jun 2007
3:30 pm

fmalikoff

Missed adding the system tool for the System Gate. As a result, if the user tries to go to the gate, they just get the index screen. The problem will have gone out in the Windows upgrader. Doing this fix now and will be okay in the Unix upgrader.

Options
    • -1
    • +9
    ./updatescripts/alter_203_editonfly.sql
Wednesday 13 Jun 2007
6:36 pm

fmalikoff

LDEV-1257: Added support for Groups to be created in authoring (so that the names can be entered) and the mapping table to map groups to a sequence activity (ala branch) for a Group based branching activity.

Options
    • -1
    • +17
    ./create_lams_11_tables.sql
    • -0
    • +20
    ./updatescripts/alter_21_branching.sql
  3. … 17 more files in changeset.
Friday 08 Jun 2007
2:19 pm

fmalikoff

Split branching activity into 3 activities - one for each method of branching (teacher chosen, grouped and tool based)

Options
    • -8
    • +27
    ./insert_types_data.sql
    • -9
    • +30
    ./updatescripts/alter_21_branching.sql
  3. … 9 more files in changeset.
Thursday 07 Jun 2007
9:26 am

jliew

merge with lams2_0_3 tag on HEAD

Options
    • -4
    • +4
    ./create_lams_11_db.sql
    • -3
    • +14
    ./create_lams_11_tables.sql
    • -1
    • +7
    ./insert_lams_unix_config_data.sql
    • -1
    • +1
    ./insert_lams_users.sql
    • -1
    • +7
    ./insert_lams_windows_config_data.sql
    • -0
    • +0
    ./insert_rams_unix_config_data.sql
    • -1
    • +1
    ./insert_rams_users.sql
    • -0
    • +0
    ./insert_rams_windows_config_data.sql
    • -1
    • +10
    ./insert_types_data.sql
    • -38
    • +0
    ./insert_unix_config_data.sql
    • -297
    • +0
    ./insert_users.sql
    • -38
    • +0
    ./insert_windows_config_data.sql
    • -0
    • +0
    ./updatescripts/alter_203_editonfly.sql
    • -0
    • +0
    ./updatescripts/alter_203_learner_progress.sql
    • -0
    • +0
    ./updatescripts/alter_203_rams_theme.sql
  16. … 115 more files in changeset.
Tuesday 05 Jun 2007
3:16 pm

fmalikoff

Adding database changes script for branching

Options
    • -0
    • +13
    ./updatescripts/alter_21_branching.sql
12:33 pm

mseaton

adding branch activity to sequence - basic model/dto changes and packet handling

Options
    • -1
    • +12
    ./insert_types_data.sql
  2. … 9 more files in changeset.
12:31 pm

jliew

update list of federation servers from registry

Options
    • -0
    • +2
    ./insert_unix_config_data.sql
    • -1
    • +3
    ./insert_windows_config_data.sql
  3. … 7 more files in changeset.
Friday 01 Jun 2007
12:51 pm

jliew

added fed_id column to lams_fed_server (common id number maintained across federation)

Options
    • -0
    • +1
    ./create_sharedlesson_tables.sql
  2. … 3 more files in changeset.
Thursday 31 May 2007
2:39 pm

lfoxton

needed to add an extra row to lams_learning_activity_type for the edit on the fly to work

Options
    • -0
    • +1
    ./updatescripts/alter_203_editonfly.sql
Friday 25 May 2007
1:42 pm

jliew

Adding lams_fed_server and lams_fed_lesson tables to database, with accompanying files and service methods

Options
    • -0
    • +26
    ./create_sharedlesson_tables.sql
  2. … 9 more files in changeset.
1:42 pm

jliew

file create_sharedlesson_tables.sql was initially added on branch shibboleth_2_0.

Options
    • -0
    • +0
    ./create_sharedlesson_tables.sql
Thursday 24 May 2007
9:28 am

fmalikoff

Updating version numbers for LAMS 2.0.3, RAMS 0.8.1 (Still 1.0 beta!)

Options
    • -6
    • +6
    ./insert_lams_unix_config_data.sql
    • -6
    • +6
    ./insert_lams_windows_config_data.sql
    • -5
    • +5
    ./insert_rams_unix_config_data.sql
    • -5
    • +5
    ./insert_rams_windows_config_data.sql
Monday 21 May 2007
12:03 pm

lfoxton

[LDEV-1229] Add unique index on transitions

For the 2.0.3 updater, existing duplicate rows need to be deleted from the lams_learning_transition table, this SQL code has been added to the alter_203_transition.sql

Options
    • -1
    • +17
    ./updatescripts/alter_203_transition.sql
Thursday 17 May 2007
2:33 pm

fmalikoff

LDEV-1229: Add a unique key on the activity columns in transition. Somehow we are ending up with duplicate rows in the database, which stops the design being opened. This will stop the bad data being written to the database.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -0
    • +7
    ./updatescripts/alter_203_transition.sql
    • -0
    • +16
    ./updatescripts/check_203_upgrade_okay.sql
  4. … 1 more file in changeset.
9:26 am

fmalikoff

Missed adding design_version to the update script when we changed the create script

Options
    • -0
    • +1
    ./updatescripts/alter_203_editonfly.sql
8:56 am

jliew

add missing semicolon

Options
    • -1
    • +1
    ./updatescripts/alter_203_editonfly.sql
Wednesday 16 May 2007
7:49 am

fmalikoff

Previous version checked in in error - contains my own local values.

Options
    • -2
    • +2
    ./insert_lams_unix_config_data.sql
    • -2
    • +2
    ./insert_rams_unix_config_data.sql