OpenACS / openacs-4 / packages / dotlrn / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit: 06:29
Commits this week: 0
Total Lines of Code (LoC): 9,412
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 21 Feb 2004
3:34 am

andrewg

Adding these files for privacy overhaul, prompted by bug 1549

Options
    • -0
    • +124
    ./privacy-init.sql
  2. … 5 more files in changeset.
3:34 am

andrewg

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

Options
    • -0
    • +0
    ./privacy-init.sql
  2. … 1 more file in changeset.
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
    ./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
    ./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
    ./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
    ./admin-profile-provider-create.sql
    • -3
    • +3
    ./admin-profile-provider-drop.sql
    • -5
    • +5
    ./admins-package-create.sql
    • -3
    • +3
    ./admins-sanitize.sql
    • -40
    • +40
    ./applet-sc-drop.sql
    • -10
    • +10
    ./classes-create.sql
    • -5
    • +5
    ./clubs-create.sql
    • -9
    • +9
    ./communities-package-create.sql
    • -29
    • +29
    ./community-memberships-packages-create.sql
    • -4
    • +4
    ./dotlrn-sanitize.sql
    • -1
    • +2
    ./external-profile-provider-create.sql
    • -3
    • +3
    ./external-profile-provider-drop.sql
    • -5
    • +5
    ./externals-package-create.sql
    • -3
    • +3
    ./externals-sanitize.sql
    • -1
    • +2
    ./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
    ./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
    ./dotlrn-init.sql
  2. … 1 more file in changeset.
Wednesday 04 Dec 2002
10:50 am

peterm

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

Options
    • -2
    • +1
    ./communities-create.sql
    • -0
    • +70
    ./custom-permissions.sql
    • -1
    • +2
    ./dotlrn-create.sql
    • -1
    • +5
    ./security-create.sql
    • -2
    • +5
    ./security-drop.sql
  6. … 196 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
    ./admins-init.sql
    • -37
    • +37
    ./dotlrn-init.sql
    • -2
    • +2
    ./externals-init.sql
    • -2
    • +2
    ./professors-init.sql
    • -2
    • +2
    ./students-init.sql
  6. … 27 more files in changeset.
Friday 25 Oct 2002
11:02 pm

donb

I removed the composite index that checks for uniqueness of the community_type

and supertype pair. This index broke installation if the Oracle blocksize is

less than 8KB (which is true by default on at least some platforms).

The unique constraint was unnecessary since community_type was already declared as the

table's primary key. Because of this, only one row with a given community_type name

is possible, which means the composite key (community_type, supertype) is guaranteed

to be unique.

Removing the index will also speed community creation slightly, save a bit of

disk space, etc etc.

Note that the composite index was useless for lookups on the supertype alone

anyway (since community_type was the leftmost member of the composite key), and that

any queries on the type hierarchy ought to use the denormalized table defined

by acs-objects-metadata.sql anyway.

So the index seems entirely useless to me.

Options
    • -2
    • +1
    ./communities-create.sql
  2. … 1 more file in changeset.
Thursday 17 Oct 2002
2:19 pm

jeffd

sloan - adds dotlrn_spam_community perm, postgresql cleanup

Options
    • -1
    • +2
    ./dotlrn-create.sql
    • -1
    • +5
    ./security-create.sql
    • -2
    • +5
    ./security-drop.sql
  4. … 4 more files in changeset.
1:40 pm

jeffd

sloan - faster permission check dotlrn_community_admin_p

Options
    • -0
    • +70
    ./custom-permissions.sql
  2. … 1 more file in changeset.
1:40 pm

jeffd

file custom-permissions.sql was initially added on branch dotlrn-1-0.

Options
    • -0
    • +0
    ./custom-permissions.sql
  2. … 1 more file in changeset.
Friday 09 Aug 2002
8:39 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./admin-profile-provider-create.sql
    • -2
    • +2
    ./admin-profile-provider-drop.sql
    • -2
    • +2
    ./admins-create.sql
    • -2
    • +2
    ./admins-drop.sql
    • -2
    • +2
    ./admins-init.sql
    • -2
    • +2
    ./admins-package-create.sql
    • -2
    • +2
    ./admins-package-drop.sql
    • -2
    • +2
    ./admins-sanitize.sql
    • -1
    • +1
    ./applet-sc-create.sql
    • -1
    • +1
    ./applet-sc-drop.sql
    • -2
    • +2
    ./applets-create.sql
    • -2
    • +2
    ./applets-drop.sql
    • -2
    • +2
    ./class-memberships-create.sql
    • -2
    • +2
    ./class-memberships-drop.sql
    • -2
    • +2
    ./classes-create.sql
  16. … 532 more files in changeset.
Wednesday 31 Jul 2002
11:18 pm

yon

added an operation to the dotlrn_applet service contract. the operation's name

is ChangeEventHandler and is usually implemented by change_event_handler

method in the dotlrn_applet implementation. dotLRN can throw events based on

changes to a community via the dotlrn_community::generate_change_event method.

currently the only event being thrown and handled is the 'rename' event. this

event is thrown when the name of a community is changed. the only applets that

currently listen for this event are dotlrn_fs, dotlrn_forums, and

dotlrn_calendar.

applets do not have to handle all events, only events they are interested in

handling.

we will add events on an as needed basis.

Options
    • -145
    • +168
    ./applet-sc-create.sql
    • -0
    • +13
    ./applet-sc-drop.sql
  3. … 50 more files in changeset.
Friday 26 Jul 2002
4:53 pm

yon

added rel_type and segment_id columns to dotlrn_user_types table and

dotlrn_users view.

Options
    • -8
    • +9
    ./admins-init.sql
    • -8
    • +9
    ./externals-init.sql
    • -8
    • +9
    ./professors-init.sql
    • -8
    • +9
    ./students-init.sql
    • -2
    • +12
    ./users-create.sql
  6. … 5 more files in changeset.
3:59 am

arjun

increase term_year col to 9

Options
    • -2
    • +2
    ./classes-create.sql
3:57 am

arjun

increase term_year lenght to 9

Options
    • -0
    • +1
    ./upgrade/upgrade-july-25-2002.sql
  2. … 2 more files in changeset.
Saturday 13 Jul 2002
2:43 am

yon

update info file. fix referential constraint in dotlrn_applets table.

Options
    • -2
    • +2
    ./applets-create.sql
  2. … 2 more files in changeset.
2:13 am

yon

some changes regarding dotlrn applets. the data model has changed. some other

small api changes. most of these api are not used.

Options
    • -0
    • +65
    ./applets-create.sql
    • -0
    • +28
    ./applets-drop.sql
    • -39
    • +1
    ./communities-create.sql
    • -3
    • +1
    ./communities-drop.sql
    • -1
    • +2
    ./dotlrn-create.sql
    • -1
    • +2
    ./dotlrn-drop.sql
  7. … 28 more files in changeset.
Tuesday 09 Jul 2002
12:09 am

chak

fixes to get dotlrn postgres port working

Options
    • -2
    • +2
    ./dotlrn-init.sql
  2. … 4 more files in changeset.
Friday 28 Jun 2002
9:50 pm

arjun

fix typo

Options
    • -2
    • +2
    ./communities-create.sql
2:14 am

yon

optimized tree trigger a little bit

Options
    • -19
    • +18
    ./communities-tree-create.sql
  2. … 2 more files in changeset.
Wednesday 26 Jun 2002
12:21 am

yon

removed unused columns; you can just drop them and recreate any dependent views

Options
    • -7
    • +1
    ./communities-create.sql
Monday 24 Jun 2002
11:10 pm

yon

tree.increment_key() now does the lpadding for us

Options
    • -2
    • +2
    ./communities-tree-create.sql
  2. … 2 more files in changeset.
Thursday 20 Jun 2002
10:33 pm

arjun

One of the index names was too long for oracle

Options
    • -2
    • +2
    ./communities-create.sql
Thursday 13 Jun 2002
6:34 am

arjun

Use icon and alt text attrs for groups

Options
    • -1
    • +12
    ./dotlrn-init.sql
  2. … 3 more files in changeset.
6:28 am

arjun

added for icon alt text change in groups

Options
    • -0
    • +29
    ./upgrade/upgrade-jun-12-2002.sql
Friday 07 Jun 2002
7:00 am

arjun

fix typo

Options
    • -1
    • +1
    ./upgrade/upgrade-jun-07-2002.sql