OpenACS / openacs-4 / packages / assessment / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 2,738
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 01 Jun 2008
3:35 pm

emmar

file upgrade-0.22d5-0.22d6.sql was initially added on branch oacs-5-4.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.22d5-0.22d6.sql
  2. … 1 more file in changeset.
Monday 08 Oct 2007
12:36 am

donb

Merged oacs-5-3 branch to HEAD

Options
    • -0
    • +6
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  2. … 187 more files in changeset.
Saturday 15 Sep 2007
1:58 am

daveb

Fix upgrade to work with correct constraint names

Options
    • -6
    • +6
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  2. … 3 more files in changeset.
Friday 14 Sep 2007
10:38 pm

daveb

Add on delete cascade on as_session_items mapping table.

Options
    • -0
    • +6
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  2. … 1 more file in changeset.
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -8
    • +8
    ./assessment-actions-package-create.sql
    • -32
    • +65
    ./assessment-collected-data-create.sql
    • -8
    • +16
    ./assessment-item-create.sql
    • -9
    • +45
    ./assessment-item-type-create.sql
    • -9
    • +17
    ./assessment-section-create.sql
    • -2
    • +6
    ./assessment-types-create.sql
    • -26
    • +36
    ./upgrade/upgrade-0.22d2-0.22d3.sql
    • -0
    • +299
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  9. … 1549 more files in changeset.
Sunday 22 Apr 2007
10:07 pm

donb

Fixesd daveb typo in previous post-beta commit

Options
    • -2
    • +2
    ./assessment-collected-data-create.sql
Sunday 08 Apr 2007
7:16 pm

daveb

Many fixes to Oracle support in assessment.

Options
    • -8
    • +8
    ./assessment-actions-package-create.sql
    • -0
    • +4
    ./assessment-collected-data-create.sql
    • -0
    • +27
    ./assessment-item-type-create.sql
    • -8
    • +16
    ./assessment-section-create.sql
    • -2
    • +6
    ./assessment-types-create.sql
    • -34
    • +34
    ./upgrade/upgrade-0.22d2-0.22d3.sql
    • -50
    • +253
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  8. … 18 more files in changeset.
1:27 am

daveb

More on delete cascades.

Set uninstantiate and unmount callbacks in info file so we can remove a

package instance.

Options
    • -29
    • +58
    ./assessment-collected-data-create.sql
  2. … 3 more files in changeset.
12:50 am

daveb

Make sure oracle is the same as postgresql data model.

Make sure upgrades are up to date

Options
    • -8
    • +16
    ./assessment-item-create.sql
    • -9
    • +18
    ./assessment-item-type-create.sql
    • -0
    • +96
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  4. … 1 more file in changeset.
12:50 am

daveb

file upgrade-0.22d3-0.22d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.22d3-0.22d4.sql
  2. … 1 more file in changeset.
Saturday 07 Apr 2007
11:47 pm

daveb

Add missing on delete cascade from create file.

Fix HTML anchors so they aren't picked up as HTML entities.

Options
    • -2
    • +2
    ./assessment-collected-data-create.sql
  2. … 4 more files in changeset.
Tuesday 27 Mar 2007
2:49 pm

emmar

Change in as_assessments table done in the upgrade script but not in the creation one

Options
    • -1
    • +1
    ./assessment-section-create.sql
  2. … 1 more file in changeset.
Monday 05 Feb 2007
7:51 pm

daveb

Add a few more on delete cascades.

Options
    • -0
    • +10
    ./upgrade/upgrade-0.22d2-0.22d3.sql
  2. … 1 more file in changeset.
Friday 08 Dec 2006
3:20 pm

daveb

Add upgrade to change forign keys to on delete cascade to make removing sessions possible.

Options
    • -0
    • +52
    ./upgrade/upgrade-0.22d2-0.22d3.sql
  2. … 1 more file in changeset.
Monday 16 Oct 2006
3:20 pm

daveb

Add upgrades for as_item_data.as_item_id index.

Options
    • -0
    • +9
    ./upgrade/upgrade-0.22d1-0.22d2.sql
  2. … 1 more file in changeset.
3:17 pm

daveb

Add index to as_item_data.as_item_id to allow lookups of assessment

data by "question".

Options
    • -1
    • +1
    ./assessment-collected-data-create.sql
  2. … 2 more files in changeset.
Tuesday 26 Sep 2006
4:22 am

daveb

Updated upgrade file to drop views when mutating attribute type.

Updated catalog files.

Fix a couple for type integer checks

Options
    • -1
    • +10
    ./upgrade/upgrade-0.20-0.21.sql
  2. … 3 more files in changeset.
2:22 am

daveb

Many UI improvements. Add permissions checks to asm-admin pages that

were missing them!

Change type from an integer that has no meaning to a string, that might

give you a clue what it means. TODO change type to refer to a "template"

assessment_id with all the default values set so an admin can manage

types.

Options
    • -2
    • +10
    ./upgrade/upgrade-0.20-0.21.sql
  2. … 34 more files in changeset.
Tuesday 15 Aug 2006
3:44 am

daveb

Update Update storage type on existing as_items (questions) so that the storage_type is not FILE.

Options
    • -2
    • +3
    ./upgrade/upgrade-0.20-0.21.sql
  2. … 1 more file in changeset.
Sunday 06 Aug 2006
6:51 pm

daveb

Add upgrade scripts for new long question text support.

Options
    • -0
    • +9
    ./upgrade/upgrade-0.20-0.21.sql
  2. … 1 more file in changeset.
Monday 12 Jun 2006
4:49 am

daveb

Merge oacs-5-2 to HEAD

Options
    • -1
    • +20
    ./assessment-actions-package-create.sql
    • -9
    • +9
    ./assessment-checks-package-create.sql
    • -1
    • +3
    ./assessment-item-type-create.sql
    • -4
    • +5
    ./assessment-section-create.sql
    • -0
    • +5
    ./upgrade/upgrade-0.10d10-0.10d11.sql
    • -0
    • +26
    ./upgrade/upgrade-0.11-0.12.sql
    • -0
    • +1
    ./upgrade/upgrade-0.12-0.13.sql
    • -0
    • +7
    ./upgrade/upgrade-0.17-0.18.sql
    • -0
    • +17
    ./upgrade/upgrade-0.19-0.20.sql
  10. … 218 more files in changeset.
Saturday 11 Mar 2006
6:07 pm

daveb

file upgrade-0.19-0.20.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.19-0.20.sql
  2. … 1 more file in changeset.
6:07 pm

daveb

Set context_id so folder and assessment inherit permissions from package_id

Options
    • -0
    • +17
    ./upgrade/upgrade-0.19-0.20.sql
  2. … 4 more files in changeset.
Thursday 02 Mar 2006
1:49 am

donb

Oracle needs to use "del()" rather than "delete()" for 9i and better due to

"delete" being treated as a reserved word in PL/SQL.

Options
    • -9
    • +9
    ./assessment-checks-package-create.sql
    • -1
    • +0
    ./assessment-item-type-create.sql
  3. … 2 more files in changeset.
Tuesday 14 Feb 2006
7:02 pm

maltes

Fixed problem with too small varchars for the URLs

Options
    • -3
    • +3
    ./assessment-section-create.sql
    • -0
    • +7
    ./upgrade/upgrade-0.17-0.18.sql
  3. … 4 more files in changeset.
7:02 pm

maltes

file upgrade-0.17-0.18.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.17-0.18.sql
  2. … 1 more file in changeset.
Saturday 29 Oct 2005
9:52 pm

roelc

Added an option for select box widgets to prepend an empty option, this is useful for instances where the field is required but you don't want a default to be selected but also don't want the options to be ordered by random

Options
    • -1
    • +4
    ./assessment-item-type-create.sql
  2. … 12 more files in changeset.
Monday 18 Jul 2005
8:04 pm

annyf

file upgrade-0.11-0.12.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.11-0.12.sql
8:04 pm

annyf

file upgrade-0.12-0.13.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.12-0.13.sql
  2. … 1 more file in changeset.
8:01 pm

annyf

simplify assessment UI by adding the type field on the as_assessment table, change default value of confirmation pages

Options
    • -0
    • +2
    ./assessment-actions-package-create.sql
    • -1
    • +2
    ./assessment-section-create.sql
    • -0
    • +26
    ./upgrade/upgrade-0.11-0.12.sql
    • -0
    • +1
    ./upgrade/upgrade-0.12-0.13.sql
  5. … 33 more files in changeset.