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
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
8:26 am

fmalikoff

Added a new configuration item - server url context. This should be either "lams" or "rams". Used by the FCKEditor upload servlet code to generate the appropriate paths to the images.

Also converted paths over to refer to RAMS rather than LAMS.

Options
    • -5
    • +6
    ./insert_rams_unix_config_data.sql
    • -5
    • +6
    ./insert_rams_windows_config_data.sql
8:23 am

fmalikoff

Added a new configuration item - server url context. This should be either "lams" or "rams". Used by the FCKEditor upload servlet code to generate the appropriate paths to the images.

Options
    • -0
    • +1
    ./insert_lams_unix_config_data.sql
    • -0
    • +1
    ./insert_lams_windows_config_data.sql
  3. … 1 more file in changeset.
Monday 23 Apr 2007
10:43 am

fmalikoff

Had wrong server url and path, and wrong date for dictionary. Remerging changes from head.

Options
    • -2
    • +3
    ./insert_lams_unix_config_data.sql
    • -2
    • +3
    ./insert_rams_unix_config_data.sql
    • -2
    • +3
    ./insert_rams_windows_config_data.sql
10:38 am

fmalikoff

Checked in the wrong values for the server url and the jboss directory.

Options
    • -2
    • +3
    ./insert_lams_unix_config_data.sql
    • -2
    • +2
    ./insert_rams_unix_config_data.sql
    • -1
    • +1
    ./insert_rams_windows_config_data.sql
9:23 am

fmalikoff

Merging RAMS theme changes from the head

Options
    • -4
    • +4
    ./create_lams_11_db.sql
    • -0
    • +0
    ./insert_lams_unix_config_data.sql
    • -1
    • +1
    ./insert_lams_users.sql
    • -0
    • +0
    ./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
    • -33
    • +0
    ./insert_unix_config_data.sql
    • -297
    • +0
    ./insert_users.sql
    • -33
    • +0
    ./insert_windows_config_data.sql
    • -0
    • +0
    ./updatescripts/alter_203_rams_theme.sql
  12. … 12 more files in changeset.
8:51 am

fmalikoff

Adding RAMS theme and version to the build.

Options
    • -0
    • +32
    ./insert_lams_unix_config_data.sql
    • -0
    • +295
    ./insert_lams_users.sql
    • -0
    • +32
    ./insert_lams_windows_config_data.sql
    • -0
    • +32
    ./insert_rams_unix_config_data.sql
    • -0
    • +170
    ./insert_rams_users.sql
    • -0
    • +32
    ./insert_rams_windows_config_data.sql
    • -32
    • +0
    ./insert_unix_config_data.sql
    • -297
    • +0
    ./insert_users.sql
    • -32
    • +0
    ./insert_windows_config_data.sql
    • -0
    • +4
    ./updatescripts/alter_203_rams_theme.sql
  11. … 9 more files in changeset.
Friday 20 Apr 2007
3:02 pm

mseaton

change default value for allowEditOnFly

Options
    • -1
    • +1
    ./insert_unix_config_data.sql
    • -1
    • +1
    ./insert_windows_config_data.sql