OpenACS / openacs-4 / packages / assessment / sql / postgresql

upgrade

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): 1,684
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 26 Aug 2014
1:36 pm

gustafn

- fix calls to deprecated function ad_parameter stored in SQL (this should be actually replaced to a single call to a proc performing the logic)

Options
    • -1
    • +1
    ./upgrade-0.10d6-0.10d7.sql
    • -2
    • +2
    ./upgrade-0.23d3-0.23d4.sql
  3. … 7 more files in changeset.
Monday 18 Aug 2014
10:37 pm

gustafn

- modernize sql (dollar quoting, named arguments, fix and complete function_args)

Options
    • -23
    • +41
    ./upgrade-0.10d3-0.10d4.sql
    • -59
    • +93
    ./upgrade-0.10d6-0.10d7.sql
    • -6
    • +12
    ./upgrade-0.22d3-0.22d4.sql
    • -15
    • +39
    ./upgrade-0.23d1-0.23d2.sql
    • -2
    • +2
    ./upgrade-0.23d3-0.23d4.sql
  6. … 5 more files in changeset.
Monday 02 Dec 2013
9:56 am

gustafn

- replace deprecated ns_sendmail by acs_mail_lite::send;

- assessment stores tcl-code in the db. someone with assessement knowledge should take care about updating this code!

- needs to be tested

Options
    • -0
    • +101
    ./upgrade-0.23d3-0.23d4.sql
  2. … 6 more files in changeset.
Monday 06 Jul 2009
2:04 pm

emmar

Removed drop statement of two triggers that actually wouldn't exist in previous version.

Options
    • -2
    • +2
    ./upgrade-0.23d1-0.23d2.sql
Monday 01 Dec 2008
5:57 pm

daveb

Merge assessment from oacs-5-4

Options
    • -6
    • +4
    ./upgrade-0.17-0.18.sql
  2. … 108 more files in changeset.
Wednesday 05 Nov 2008
8:19 pm

daveb

Fix typos in upgrade script

Options
    • -3
    • +3
    ./upgrade-0.23d1-0.23d2.sql
8:13 pm

daveb

Add correct upgrade script versions

Options
    • -0
    • +18
    ./upgrade-0.22d5-0.22d6.sql
  2. … 1 more file in changeset.
8:12 pm

daveb

Remove old wrong upgrade scipts

Options
    • -57
    • +0
    ./upgrade-0.22d5-0.22d6.sql
  2. … 1 more file in changeset.
8:08 pm

daveb

Fix upgrade version numbers

Options
    • -0
    • +57
    ./upgrade-0.23d1-0.23d2.sql
    • -0
    • +27
    ./upgrade-0.23d2-0.23d3.sql
  3. … 3 more files in changeset.
Tuesday 09 Sep 2008
7:28 pm

daveb

Revert ajax dependency. More fix for fractional points

Options
    • -0
    • +3
    ./upgrade-0.22d6-0.22d7.sql
  2. … 11 more files in changeset.
Sunday 07 Sep 2008
11:22 pm

daveb

Fix reference in trigger to use CR view to get title.

Options
    • -1
    • +1
    ./upgrade-0.22d5-0.22d6.sql
9:38 pm

daveb

Finish work to support fractional points. All tables switched to

float. Forms switched to validate float.

Options
    • -0
    • +15
    ./upgrade-0.22d6-0.22d7.sql
  2. … 4 more files in changeset.
Tuesday 02 Sep 2008
3:21 am

daveb

Change points to float to allow partial credit

Options
    • -0
    • +9
    ./upgrade-0.22d6-0.22d7.sql
  2. … 1 more file in changeset.
3:08 am

daveb

UpUpgrade denormalizaton to make it possible to generate reports in a scalable manner

Options
    • -0
    • +57
    ./upgrade-0.22d5-0.22d6.sql
  2. … 4 more files in changeset.
Sunday 01 Jun 2008
3:35 pm

emmar

More fixes for bug 3139. The creation script was out of sync in dotlrn 2.3 too so it needs to be upgraded in 2.4. The upgrade is harmless for installation that already have the fix.

Options
    • -6
    • +4
    ./upgrade-0.17-0.18.sql
    • -0
    • +18
    ./upgrade-0.22d5-0.22d6.sql
  3. … 3 more files in changeset.
3:35 pm

emmar

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

Options
    • -0
    • +0
    ./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
    • +7
    ./upgrade-0.22d3-0.22d4.sql
  2. … 187 more files in changeset.
Friday 14 Sep 2007
10:38 pm

daveb

Add on delete cascade on as_session_items mapping table.

Options
    • -0
    • +7
    ./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
    • -2
    • +2
    ./upgrade-0.20-0.21.sql
    • -1
    • +7
    ./upgrade-0.22d2-0.22d3.sql
    • -0
    • +116
    ./upgrade-0.22d3-0.22d4.sql
  4. … 1554 more files in changeset.
Sunday 08 Apr 2007
7:16 pm

daveb

Many fixes to Oracle support in assessment.

Options
    • -0
    • +20
    ./upgrade-0.22d3-0.22d4.sql
  2. … 24 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
    • -0
    • +96
    ./upgrade-0.22d3-0.22d4.sql
  2. … 3 more files 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-0.22d3-0.22d4.sql
  2. … 1 more file in changeset.
Monday 05 Feb 2007
7:51 pm

daveb

Add a few more on delete cascades.

Options
    • -1
    • +5
    ./upgrade-0.22d2-0.22d3.sql
  2. … 1 more file in changeset.
Friday 02 Feb 2007
5:16 pm

daveb

Another on delete cascade. If you table has "map" in the name, its a

pretty good chance the foreign keys should have "on delete cascade".

Options
    • -0
    • +5
    ./upgrade-0.22d2-0.22d3.sql
Tuesday 16 Jan 2007
11:12 am

darior

not work delete attempt when exist one row in as_session_result

Options
    • -0
    • +3
    ./upgrade-0.22d2-0.22d3.sql
Tuesday 09 Jan 2007
6:28 pm

maltes

Made sure the version number matches the upgrade script and that the view can actually be deleted. Someone else please take a look if this is actually desired (adding the cascade), it worked on my install just fine (but I am not a heavy user...)

Options
    • -2
    • +2
    ./upgrade-0.20-0.21.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-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-0.22d1-0.22d2.sql
  2. … 1 more file 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
    • +8
    ./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-0.20-0.21.sql
  2. … 34 more files in changeset.