OpenACS / openacs-4 / packages / dotlrn

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 20
Last Commit: 16:56
Commits this week: 0
Total Lines of Code (LoC): 18,051
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 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 14 Sep 2004
5:34 pm

tracya

users in classes were labeled with dotlrn_member_rel if they were not added from the class administratio page. This caused issues with bulk-mailing them by role. Includes upgrade script to properly label these users as dotlrn_student_rel

Options
    • -0
    • +22
    ./oracle/upgrade/upgrade-2.1.0a2-2.1.0b1.sql
  2. … 5 more files in changeset.
Tuesday 20 Apr 2004
11:12 pm

jeffd

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

Options
    • -0
    • +2
    ./oracle/dotlrn-create.sql
    • -0
    • +94
    ./oracle/privacy-init.sql
    • -0
    • +150
    ./oracle/privacy-package-create.sql
    • -0
    • +219
    ./oracle/upgrade/upgrade-2.0a3-2.0.2.sql
    • -0
    • +2
    ./postgresql/dotlrn-create.sql
    • -0
    • +99
    ./postgresql/privacy-init.sql
    • -0
    • +123
    ./postgresql/privacy-package-create.sql
    • -0
    • +203
    ./postgresql/upgrade/upgrade-2.0a3-2.0.2.sql
  9. … 640 more files in changeset.
Monday 15 Mar 2004
9:59 pm

andrewg

fix for bug #1633

Options
    • -1
    • +96
    ./oracle/upgrade/upgrade-2.0a3-2.0.2.sql
    • -1
    • +101
    ./postgresql/upgrade/upgrade-2.0a3-2.0.2.sql
Monday 01 Mar 2004
5:40 pm

andrewg

Moving upgrade-feb-20-2004.sql to upgrade-2.0a3-2.0.2.sql so that APM will run it properly

Options
    • -0
    • +124
    ./oracle/upgrade/upgrade-2.0a3-2.0.2.sql
    • -124
    • +0
    ./oracle/upgrade/upgrade-feb-20-2004.sql
    • -0
    • +103
    ./postgresql/upgrade/upgrade-2.0a3-2.0.2.sql
    • -103
    • +0
    ./postgresql/upgrade/upgrade-feb-20-2004.sql
5:40 pm

andrewg

file upgrade-2.0a3-2.0.2.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.0a3-2.0.2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.0a3-2.0.2.sql
Thursday 26 Feb 2004
4:41 am

andrewg

Fixing bugs.

Options
    • -6
    • +8
    ./postgresql/upgrade/upgrade-feb-20-2004.sql
Wednesday 25 Feb 2004
10:24 pm

andrewg

Ported Oracle script.

Options
    • -0
    • +101
    ./postgresql/upgrade/upgrade-feb-20-2004.sql
10:24 pm

andrewg

file upgrade-feb-20-2004.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-feb-20-2004.sql
Tuesday 24 Feb 2004
11:00 pm

andrewg

Correcting the comments at top.

Options
    • -2
    • +2
    ./oracle/upgrade/upgrade-feb-20-2004.sql
10:55 pm

andrewg

Adding.

Options
    • -0
    • +124
    ./oracle/upgrade/upgrade-feb-20-2004.sql
10:55 pm

andrewg

file upgrade-feb-20-2004.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-feb-20-2004.sql
10:00 pm

andrewg

Fixed a few postgres queries.

Options
    • -5
    • +5
    ./postgresql/privacy-package-create.sql
8:56 pm

andrewg

Packagized the privacy code.

Options
    • -2
    • +3
    ./oracle/dotlrn-create.sql
    • -30
    • +0
    ./oracle/privacy-init.sql
    • -0
    • +150
    ./oracle/privacy-package-create.sql
    • -0
    • +1
    ./postgresql/dotlrn-create.sql
    • -117
    • +0
    ./postgresql/privacy-init.sql
    • -0
    • +123
    ./postgresql/privacy-package-create.sql
  7. … 11 more files in changeset.
8:56 pm

andrewg

file privacy-package-create.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./oracle/privacy-package-create.sql
    • -0
    • +0
    ./postgresql/privacy-package-create.sql
Saturday 21 Feb 2004
6:20 am

andrewg

Fixing broken queries

Options
    • -0
    • +95
    ./postgresql/privacy-init.sql
  2. … 1 more file in changeset.
3:36 am

andrewg

Privacy overhaul, prompted by bug 1549

Options
    • -1
    • +2
    ./oracle/dotlrn-create.sql
    • -0
    • +1
    ./postgresql/dotlrn-create.sql
  3. … 32 more files in changeset.
3:34 am

andrewg

Adding these files for privacy overhaul, prompted by bug 1549

Options
    • -0
    • +124
    ./oracle/privacy-init.sql
    • -0
    • +121
    ./postgresql/privacy-init.sql
  3. … 4 more files in changeset.
3:34 am

andrewg

file privacy-init.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./oracle/privacy-init.sql
    • -0
    • +0
    ./postgresql/privacy-init.sql
Thursday 09 Oct 2003
10:31 am

peterm

version was changed to 1.0d1 for the Oralce 9i upgrade, however that's lower than 1.0. Changing version to be 2.0d1 instead

Options
    • -1762
    • +0
    ./oracle/upgrade/upgrade-1.0-1.0d1.sql
  2. … 1 more file in changeset.
10:12 am

peterm

version was changed to 1.0d1 for the Oralce 9i upgrade, however that's lower than 1.0. Changing version to be 2.0d1 instead

Options
    • -0
    • +1762
    ./oracle/upgrade/upgrade-1.0-2.0d1.sql
Wednesday 08 Oct 2003
5:54 pm

mohanp

Added this file to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +1762
    ./oracle/upgrade/upgrade-1.0-1.0d1.sql
  2. … 4 more files in changeset.
Tuesday 30 Sep 2003
3:11 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -1
    • +2
    ./oracle/admin-profile-provider-create.sql
    • -3
    • +3
    ./oracle/admin-profile-provider-drop.sql
    • -5
    • +5
    ./oracle/admins-package-create.sql
    • -3
    • +3
    ./oracle/admins-sanitize.sql
    • -40
    • +40
    ./oracle/applet-sc-drop.sql
    • -10
    • +10
    ./oracle/classes-create.sql
    • -5
    • +5
    ./oracle/clubs-create.sql
    • -9
    • +9
    ./oracle/communities-package-create.sql
    • -29
    • +29
    ./oracle/community-memberships-packages-create.sql
    • -4
    • +4
    ./oracle/dotlrn-sanitize.sql
    • -1
    • +2
    ./oracle/external-profile-provider-create.sql
    • -3
    • +3
    ./oracle/external-profile-provider-drop.sql
    • -5
    • +5
    ./oracle/externals-package-create.sql
    • -3
    • +3
    ./oracle/externals-sanitize.sql
    • -1
    • +2
    ./oracle/main-portlet-create.sql
  16. … 75 more files in changeset.
Wednesday 17 Sep 2003
3:58 pm

peterm

using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

Options
    • -3
    • +3
    ./oracle/user-extension-create.sql
  2. … 26 more files in changeset.
Friday 29 Aug 2003
12:06 pm

peterm

removing the admin role as it already exists in the acs-kernel now

Options
    • -7
    • +1
    ./oracle/dotlrn-init.sql
    • -2
    • +1
    ./postgresql/dotlrn-init.sql
Thursday 29 May 2003
8:04 pm

peterm

merging dotlrn-1-0-1 tag down onto head. Thanks to Jarkko Laine and Mohan Pakkurti for all the help. See comments at http://openacs.org/storage/download/index?version_id=104101

Options
    • -5
    • +5
    ./postgresql/classes-create.sql
    • -2
    • +2
    ./postgresql/clubs-create.sql
    • -6
    • +6
    ./postgresql/communities-package-create.sql
    • -13
    • +1
    ./postgresql/security-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-july-25-2002.sql
  6. … 117 more files in changeset.
Tuesday 04 Mar 2003
8:51 pm

donb

Removed unnecessary trigger drop/recreate (PG bug fixed in 7.2)

Options
    • -12
    • +2
    ./postgresql/security-create.sql
Monday 03 Mar 2003
6:39 pm

donb

1. The externals group was pretty-named "Externals" rather than "External".

2. Date arithmetic issue for PG 7.3, switched to PG interval type

Options
    • -2
    • +2
    ./postgresql/externals-init.sql
  2. … 1 more file in changeset.
Sunday 02 Mar 2003
11:40 pm

donb

A handful of various fixes, mostly for PG 7.3. Unfortunately I copied

over the fixed directory tree from my test instance here by mistake so

everything looks changed.

Options
    • -5
    • +5
    ./postgresql/classes-create.sql
    • -2
    • +2
    ./postgresql/clubs-create.sql
    • -6
    • +6
    ./postgresql/communities-package-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-july-25-2002.sql
  5. … 9 more files in changeset.
Wednesday 04 Dec 2002
10:50 am

peterm

merging the dotlrn-1-0 branch down onto HEAD (the trunk)

Options
    • -2
    • +1
    ./oracle/communities-create.sql
    • -0
    • +70
    ./oracle/custom-permissions.sql
    • -1
    • +2
    ./oracle/dotlrn-create.sql
    • -1
    • +5
    ./oracle/security-create.sql
    • -2
    • +5
    ./oracle/security-drop.sql
    • -2
    • +1
    ./postgresql/communities-create.sql
    • -2
    • +2
    ./postgresql/communities-drop.sql
    • -0
    • +62
    ./postgresql/custom-permissions.sql
    • -0
    • +1
    ./postgresql/dotlrn-create.sql
    • -24
    • +33
    ./postgresql/security-create.sql
    • -2
    • +4
    ./postgresql/security-drop.sql
  12. … 190 more files in changeset.
Tuesday 12 Nov 2002
9:44 am

peterm

change because underscore proc only takes two arguments now, localizing more texts in UI, using message keys for the role names in the database

Options
    • -2
    • +2
    ./oracle/admins-init.sql
    • -37
    • +37
    ./oracle/dotlrn-init.sql
    • -2
    • +2
    ./oracle/externals-init.sql
    • -2
    • +2
    ./oracle/professors-init.sql
    • -2
    • +2
    ./oracle/students-init.sql
    • -2
    • +2
    ./postgresql/admins-init.sql
    • -30
    • +30
    ./postgresql/dotlrn-init.sql
    • -2
    • +2
    ./postgresql/externals-init.sql
    • -2
    • +2
    ./postgresql/professors-init.sql
    • -2
    • +2
    ./postgresql/students-init.sql
  11. … 22 more files in changeset.