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 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
7:46 am

fmalikoff

Checked in in error

Options
    • -872
    • +0
    ./lams_11.sql
    • -48
    • +0
    ./lams_learning_design.sql
7:41 am

fmalikoff

LDEV-1051 and LDEV-1198: Fixed the break out of frames logic for parallels at the end of a design and inside an optional activity. Changing flag for waiting from boolean to a numeric flag.

Options
    • -2
    • +2
    ./create_lams_11_tables.sql
    • -2
    • +2
    ./insert_lams_unix_config_data.sql
    • -2
    • +2
    ./insert_rams_unix_config_data.sql
    • -0
    • +872
    ./lams_11.sql
    • -0
    • +48
    ./lams_learning_design.sql
    • -0
    • +7
    ./updatescripts/alter_203_learner_progress.sql
  7. … 1 more file in changeset.
Wednesday 09 May 2007
7:47 pm

fmalikoff

Fixed version string - missing "Beta"

Options
    • -1
    • +1
    ./insert_rams_unix_config_data.sql
9:13 am

fmalikoff

Merging RAMS and Edit On Fly changes from branch to the head.

Options
    • -2
    • +12
    ./create_lams_11_tables.sql
    • -1
    • +2
    ./insert_lams_unix_config_data.sql
    • -9
    • +11
    ./insert_rams_unix_config_data.sql
    • -11
    • +13
    ./insert_rams_windows_config_data.sql
    • -1
    • +10
    ./insert_types_data.sql
    • -0
    • +20
    ./updatescripts/alter_203_editonfly.sql
  7. … 2 more files in changeset.
9:01 am

fmalikoff

Merging RAMS and Edit On Fly changes from branch to the head.

Options
    • -1
    • +3
    ./insert_lams_windows_config_data.sql
  2. … 74 more files in changeset.
Wednesday 02 May 2007
11:40 am

fmalikoff

Changed name of server parameter from AllowEditOnFly to AllowLiveEdit, so that it makes more sense on the configuration screen.

Options
    • -1
    • +1
    ./insert_lams_unix_config_data.sql
    • -1
    • +2
    ./insert_lams_windows_config_data.sql
    • -1
    • +1
    ./insert_rams_unix_config_data.sql
    • -1
    • +1
    ./insert_rams_windows_config_data.sql
    • -1
    • +2
    ./updatescripts/alter_21_editonfly.sql
  6. … 1 more file in changeset.
Sunday 29 Apr 2007
7:15 pm

fmalikoff

Initial version for demonstration will be 1.0 Beta, but marking the clients as 0.8 so that none of the calculation code will break.

Options
    • -5
    • +5
    ./insert_rams_unix_config_data.sql
    • -5
    • +5
    ./insert_rams_windows_config_data.sql
Friday 27 Apr 2007
8:28 am

fmalikoff

Fixing servername - accidently set to Shaun in previous check in.

Options
    • -1
    • +1
    ./insert_rams_windows_config_data.sql