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 14 Jan 2008
1:05 pm

fmalikoff

LDEV-1488: Demo was missing the system_tool_id for 90 grouping activities. This script fixes this problelm - how it arose is unknown.

Options
    • -0
    • +6
    ./updatescripts/alter_21_fixgroupings.sql
Friday 21 Dec 2007
11:47 am

fmalikoff

Missed some of the updates to the system tool table for branching and optional sequences.

Options
    • -7
    • +16
    ./updatescripts/alter_21_branching.sql
Wednesday 19 Dec 2007
10:38 am

jliew

update config settings in 2.0.6 update script.

Options
    • -0
    • +4
    ./updatescripts/alter_206_integration.sql
Tuesday 18 Dec 2007
1:40 pm

fmalikoff

Preparing for 2.1 Beta Release - Updated dictionary date.

Options
    • -1
    • +1
    ./insert_lams_unix_config_data.sql
    • -1
    • +1
    ./insert_lams_windows_config_data.sql
Monday 17 Dec 2007
12:52 pm

fmalikoff

Preparing for 2.1 Beta Release

Options
    • -5
    • +5
    ./insert_lams_unix_config_data.sql
    • -5
    • +5
    ./insert_lams_windows_config_data.sql
  3. … 1 more file in changeset.
Friday 14 Dec 2007
2:08 pm

fmalikoff

Updated version to 2.0.6

Options
    • -5
    • +5
    ./insert_lams_unix_config_data.sql
    • -5
    • +5
    ./insert_lams_windows_config_data.sql
Wednesday 12 Dec 2007
1:51 pm

jliew

LDEV-1284 integration organisation no longer mandatory; marking file as ascii, not binary

Options
    • -53
    • +53
    ./create_integration_tables.sql
1:50 pm

jliew

LDEV-1284 integration organisation no longer mandatory; marking file as ascii, not binary

Options
    • -53
    • +53
    ./create_integration_tables.sql
1:46 pm

jliew

merge changes from HEAD to ldap2_0_4 branch for LDEV-1284, making integration organsiations not mandatory (requires alter_206_integration.sql update script to be run)

Options
    • -0
    • +2
    ./updatescripts/alter_206_integration.sql
  2. … 3 more files in changeset.
1:46 pm

jliew

file alter_206_integration.sql was initially added on branch ldap2_0_4.

Options
    • -0
    • +0
    ./updatescripts/alter_206_integration.sql
1:40 pm

jliew

LDEV-1284 integration organisation no longer mandatory; orgid column in lams_ext_server_org_map can be null now.

Options
    • -0
    • +3
    ./updatescripts/alter_21_branching.sql
  2. … 3 more files in changeset.
12:37 pm

jliew

Merge LDEV-1284 changes to ldap2_0_4 branch

Options
    • -1
    • +1
    ./updatescripts/Alter21Integration.java
  2. … 1 more file in changeset.
Monday 10 Dec 2007
7:23 am

fmalikoff

LDEV-1218: Adding the batch size for the learner progress screen to the monitoring call.

Options
    • -0
    • +3
    ./insert_lams_unix_config_data.sql
    • -0
    • +3
    ./insert_lams_windows_config_data.sql
    • -0
    • +3
    ./insert_rams_unix_config_data.sql
    • -0
    • +3
    ./insert_rams_windows_config_data.sql
    • -1
    • +2
    ./updatescripts/alter_21_branching.sql
  6. … 1 more file in changeset.
Tuesday 04 Dec 2007
12:02 pm

fmalikoff

LDEV-1301: Changing some of the I18N labels for the configuration screen to reuse existing labels. Removed the LearnerProgressBatchSize as we aren't using it for the Learner Progress screen after all.

Options
    • -22
    • +19
    ./insert_lams_unix_config_data.sql
    • -22
    • +19
    ./insert_lams_windows_config_data.sql
    • -23
    • +20
    ./insert_rams_unix_config_data.sql
    • -22
    • +19
    ./insert_rams_windows_config_data.sql
    • -50
    • +124
    ./updatescripts/alter_21_branching.sql
Friday 16 Nov 2007
12:48 pm

fmalikoff

LDEV-1285: Adding a new Activity type "Options With Sequences" so the Flash will know whether to expect sequences or not. The type is stored in the database otherwise we won't know which type it will be if the user saves the Optional without any child activities. The back end treats all Optional activities the same.

Options
    • -1
    • +2
    ./insert_types_data.sql
    • -0
    • +2
    ./updatescripts/alter_21_branching.sql
  3. … 6 more files in changeset.
Thursday 15 Nov 2007
8:53 am

jliew

fix missing semi-colon

Options
    • -2
    • +2
    ./updatescripts/Alter21Integration.java
8:52 am

jliew

removing accidental commit

Options
    • -10
    • +0
    ./lams_user_organisation_collapsed.sql
Tuesday 13 Nov 2007
7:30 am

jliew

LDEV-1252 adding new table lams_user_organisation_collapsed; refactored jsps/action/data access to accomodate collapsible courses; added callback servlet UpdateCollapsedGroupServlet.

Options
    • -1
    • +9
    ./create_lams_11_tables.sql
    • -0
    • +10
    ./lams_user_organisation_collapsed.sql
    • -1
    • +10
    ./updatescripts/alter_21_branching.sql
  4. … 18 more files in changeset.
Friday 09 Nov 2007
4:17 pm

fmalikoff

LDEV-1278: Adding calls that allow the sending of learner progress records in batches. This requires specific HQL to lookup the records, and a new entry (for the size of the batches) in the configuration table.

Options
    • -0
    • +3
    ./insert_lams_unix_config_data.sql
    • -0
    • +3
    ./insert_lams_windows_config_data.sql
    • -0
    • +3
    ./insert_rams_unix_config_data.sql
    • -0
    • +3
    ./insert_rams_windows_config_data.sql
    • -0
    • +1
    ./updatescripts/alter_21_branching.sql
  6. … 6 more files in changeset.
Thursday 25 Oct 2007
3:19 pm

jliew

LDEV-1251, LDEV-1064. Refactored the way lessons are retrieved for the index page (fixed LDEV-1064); added interface 1.2 (jquery extension), allowing sorting of lessons via drag and drop (LDEV-1251); added ordered_lesson_ids column to lams_organisation (LDEV-1251).

Options
    • -0
    • +6
    ./create_lams_11_tables.sql
    • -0
    • +3
    ./updatescripts/alter_21_branching.sql
  3. … 12 more files in changeset.
Monday 22 Oct 2007
12:12 pm

jliew

remove LamsHome and FileManagerDir from lams_configuration (wasn't removed during previous updates)

Options
    • -0
    • +4
    ./updatescripts/alter_21_branching.sql
Thursday 18 Oct 2007
3:26 pm

fmalikoff

LDEV-1375: Adding a page for sequence activities for class export portfolio. This requires setting it up as a system tool so that we have a url for the export portfolio.

Options
    • -1
    • +10
    ./insert_types_data.sql
  2. … 3 more files in changeset.
Tuesday 16 Oct 2007
2:11 pm

jliew

fix typo and add inserts for ldap configs. LDEV-1301, LDEV-1365

Options
    • -39
    • +38
    ./updatescripts/alter_21_branching.sql
Monday 15 Oct 2007
3:08 pm

jliew

LDEV-1301 i18n configuration items, categorise items, add validation

Options
    • -71
    • +212
    ./insert_lams_unix_config_data.sql
    • -71
    • +212
    ./insert_lams_windows_config_data.sql
    • -34
    • +212
    ./insert_rams_unix_config_data.sql
    • -34
    • +212
    ./insert_rams_windows_config_data.sql
    • -46
    • +71
    ./updatescripts/alter_21_branching.sql
  6. … 8 more files in changeset.
10:01 am

fmalikoff

LDEV-1348: Tweaking the db handling of branch activity mappings. If a user deletes and then readds an identical mapping for grouped based branching, we get a new entry created and the old entry deleted. Can't guarantee what order Hibernate will persist the changes to the db, so e can't have a unique key on group/sequence on the table.

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
    • -1
    • +0
    ./updatescripts/alter_21_branching.sql
  3. … 1 more file in changeset.
Friday 12 Oct 2007
9:27 am

jliew

LDEV-1284: set run sequences folder's parent folder id, and append 'Run Sequences' to its name, clarified comments.

Options
    • -7
    • +25
    ./updatescripts/Alter21Integration.java
Wednesday 10 Oct 2007
3:11 pm

fmalikoff

LDEV-1280: Implementing assign groups to branch in monitor screen (for define later). Split the current branching activity into three - one for each type of branching. Also moved the UTF-8 ajax fix to a common class in lams.jar so it can be used for all AJAX calls if desired.

Options
    • -7
    • +7
    ./insert_types_data.sql
  2. … 10 more files in changeset.
Thursday 04 Oct 2007
9:06 am

jliew

merging changes from ldap2_0_4 branch to HEAD

Options
    • -2
    • +3
    ./insert_lams_unix_config_data.sql
    • -7
    • +8
    ./insert_lams_windows_config_data.sql
    • -1
    • +2
    ./updatescripts/alter_205_ldap.sql
  4. … 11 more files in changeset.
Monday 01 Oct 2007
9:13 am

fmalikoff

LDEV-1301: Added new fields to the configuration items, to support the I18N of descriptions and heading on the page, along with some basic validation.

Options
    • -1
    • +7
    ./create_lams_11_tables.sql
    • -1
    • +53
    ./updatescripts/alter_21_branching.sql
  3. … 3 more files in changeset.
Friday 28 Sep 2007
3:18 pm

jliew

forgot to increment some ids

Options
    • -6
    • +6
    ./shaun/all.sql