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 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
2:05 pm

jliew

add 2 new columns as flags to lams_organisation, canJoinJointLessons and canOfferJointLessons

Options
    • -1
    • +3
    ./create_lams_11_tables.sql
  2. … 2 more files in changeset.
Thursday 19 Apr 2007
2:51 pm

jliew

configure shibboleth attribute header names in lams_configuration table

Options
    • -0
    • +4
    ./insert_unix_config_data.sql
    • -1
    • +5
    ./insert_windows_config_data.sql
  3. … 5 more files in changeset.
Thursday 12 Apr 2007
3:11 pm

fmalikoff

Adding initialise field, so we can tell which activities get added during the live edit.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -1
    • +2
    ./updatescripts/alter_21_editonfly.sql
  3. … 5 more files in changeset.
Thursday 05 Apr 2007
10:55 am

Ernie Ghiglione

Fix problem with database name always being lams instead of the one specified in the db.name var

Options
    • -4
    • +4
    ./create_lams_11_db.sql
  2. … 1 more file in changeset.
Friday 30 Mar 2007
8:09 am

jliew

add shibboleth authentication method

Options
    • -1
    • +3
    ./insert_types_data.sql
  2. … 4 more files in changeset.
Monday 26 Mar 2007
1:57 pm

fmalikoff

Merging 2.0.2 changes from the HEAD

Options
    • -7
    • +7
    ./insert_unix_config_data.sql
    • -7
    • +7
    ./insert_windows_config_data.sql
  3. … 17 more files in changeset.
10:08 am

fmalikoff

Merged from 2.0.2 Release on head.

Options
    • -7
    • +7
    ./insert_unix_config_data.sql
    • -7
    • +7
    ./insert_windows_config_data.sql
  3. … 5 more files in changeset.
Tuesday 20 Mar 2007
9:06 am

fmalikoff

Added a hibernate version field to the learning design. This allows the Flash progress bar in learner to work out whether or not to get a new design. When edit on the fly is done, the design is changed and hence the new design will need to be displayed next time the learner completes an activity.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Monday 19 Mar 2007
7:49 am

fmalikoff

LDEV-1176: Update the release to 2.0.2

Options
    • -7
    • +7
    ./insert_unix_config_data.sql
    • -7
    • +7
    ./insert_windows_config_data.sql
Monday 12 Mar 2007
4:18 pm

fmalikoff

Merging 2.0.1 changes from the HEAD

Options
    • -4
    • +7
    ./create_lams_11_tables.sql
    • -2
    • +2
    ./insert_types_data.sql
    • -1
    • +1
    ./insert_unix_config_data.sql
    • -2
    • +2
    ./insert_users.sql
    • -7
    • +7
    ./insert_windows_config_data.sql
    • -0
    • +0
    ./updatescripts/alter_201_ext.sql
    • -3
    • +3
    ./updatescripts/alter_201_locale_id.sql
    • -0
    • +0
    ./updatescripts/alter_201_system_tool_user_workspace.sql
    • -0
    • +0
    ./updatescripts/alter_201_tool.sql
  10. … 34 more files in changeset.