OpenACS / openacs-4 / packages / dotlrn / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 8,639
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • +103
    ./upgrade/upgrade-2.0a3-2.0.2.sql
    • -103
    • +0
    ./upgrade/upgrade-feb-20-2004.sql
  3. … 2 more files in changeset.
5:40 pm

andrewg

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

Options
    • -0
    • +0
    ./upgrade/upgrade-2.0a3-2.0.2.sql
  2. … 1 more file in changeset.
Thursday 26 Feb 2004
4:41 am

andrewg

Fixing bugs.

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

andrewg

Ported Oracle script.

Options
    • -0
    • +101
    ./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
    ./upgrade/upgrade-feb-20-2004.sql
Tuesday 24 Feb 2004
10:00 pm

andrewg

Fixed a few postgres queries.

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

andrewg

Packagized the privacy code.

Options
    • -0
    • +1
    ./dotlrn-create.sql
    • -117
    • +0
    ./privacy-init.sql
    • -0
    • +123
    ./privacy-package-create.sql
  4. … 14 more files in changeset.
8:56 pm

andrewg

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

Options
    • -0
    • +0
    ./privacy-package-create.sql
  2. … 1 more file in changeset.
Saturday 21 Feb 2004
6:20 am

andrewg

Fixing broken queries

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

andrewg

Privacy overhaul, prompted by bug 1549

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

andrewg

Adding these files for privacy overhaul, prompted by bug 1549

Options
    • -0
    • +121
    ./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.
Friday 29 Aug 2003
12:06 pm

peterm

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

Options
    • -2
    • +1
    ./dotlrn-init.sql
  2. … 1 more file in changeset.
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
    ./classes-create.sql
    • -2
    • +2
    ./clubs-create.sql
    • -6
    • +6
    ./communities-package-create.sql
    • -13
    • +1
    ./security-create.sql
    • -1
    • +1
    ./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
    ./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
    ./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
    ./classes-create.sql
    • -2
    • +2
    ./clubs-create.sql
    • -6
    • +6
    ./communities-package-create.sql
    • -1
    • +1
    ./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
    ./communities-create.sql
    • -2
    • +2
    ./communities-drop.sql
    • -0
    • +62
    ./custom-permissions.sql
    • -0
    • +1
    ./dotlrn-create.sql
    • -24
    • +33
    ./security-create.sql
    • -2
    • +4
    ./security-drop.sql
  7. … 195 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
    • -30
    • +30
    ./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.
Tuesday 22 Oct 2002
11:08 pm

jeffd

doh. forgot to remove the plsql function from the vars

Options
    • -6
    • +6
    ./custom-permissions.sql
10:41 pm

jeffd

move child create to before trigger recreate

Options
    • -5
    • +3
    ./security-create.sql
Thursday 17 Oct 2002
2:19 pm

jeffd

sloan - adds dotlrn_spam_community perm, postgresql cleanup

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

jeffd

sloan - faster permission check dotlrn_community_admin_p

Options
    • -0
    • +62
    ./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.
Thursday 15 Aug 2002
8:00 pm

chak

rel_id->p_rel_id in function calls to ...rel__detete()

Options
    • -4
    • +4
    ./community-memberships-packages-create.sql
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
    • -8
    • +8
    ./class-membership-drop.sql
    • -2
    • +2
    ./class-memberships-create.sql
    • -7
    • +3
    ./classes-create.sql
  16. … 532 more files in changeset.
6:24 pm

chak

fixed but in dotlrn_admin_rel__delete

Options
    • -10
    • +9
    ./community-memberships-packages-create.sql
Monday 05 Aug 2002
6:51 pm

chak

fixed order of define_function_args for dotlrn_community__new and also added default value of false for archived_p. also placed the define_function_args calls next to their plsql procs so it is easier to see when the parameter lists don't match.

Options
    • -15
    • +16
    ./communities-package-create.sql
Friday 02 Aug 2002
11:07 pm

chak

fixed another typo in a member_rel_creation..

Options
    • -2
    • +2
    ./dotlrn-init.sql