OpenACS / openacs-4 / packages / acs-kernel / sql / oracle

groups-body-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 943
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
Friday 10 Feb 2023
8:07 pm

gernst

Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

Options
    • -1
    • +11
    ./groups-body-create.sql
  2. … 10 more files in changeset.
Sunday 13 Feb 2022
4:45 pm

gustafn

Fixes for Oracle 19c for membership and composition triggers

Warning: Trigger created with compilation errors.

Errors for TRIGGER MEMBERSHIP_RELS_IN_TR:

LINE/COL ERROR

-------- -----------------------------------------------------------------

14/3 PL/SQL: SQL Statement ignored

16/3 PL/SQL: ORA-00947: not enough values

32/3 PL/SQL: Statement ignored

32/6 PLS-00201: identifier 'V_COMPOSABLE_P' must be declared

Trigger created.

No errors.

Warning: Trigger created with compilation errors.

Errors for TRIGGER COMPOSITION_RELS_IN_TR:

LINE/COL ERROR

-------- -----------------------------------------------------------------

72/21 PL/SQL: SQL Statement ignored

72/48 PL/SQL: ORA-00918: column ambiguously defined

83/7 PL/SQL: Statement ignored

83/47 PLS-00364: loop index variable 'MEMBERS' use is invalid

86/5 PL/SQL: SQL Statement ignored

91/6 PL/SQL: ORA-00918: column ambiguously defined

Trigger created.

No errors.

Options
    • -4
    • +5
    ./groups-body-create.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -24
    • +33
    ./groups-body-create.sql
  2. … 7834 more files in changeset.
Wednesday 31 Aug 2016
8:57 pm

gustafn

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

Options
    • -23
    • +32
    ./groups-body-create.sql
  2. … 34 more files in changeset.
Friday 01 Jul 2016
4:04 pm

gustafn

- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

- bump version number to 5.9.1d10

Options
    • -2
    • +2
    ./groups-body-create.sql
  2. … 6 more files in changeset.
Saturday 14 Feb 2009
8:22 pm

donb

Fixed daveb's connect by and nextval, for initial install and upgrade (change

to acs_group.new)

Options
    • -4
    • +4
    ./groups-body-create.sql
  2. … 1 more file in changeset.
Thursday 12 Feb 2009
3:27 am

daveb

Fix acs_group__new to create group_rels for all group supertypes

Options
    • -5
    • +17
    ./groups-body-create.sql
  2. … 4 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -4
    • +11
    ./groups-body-create.sql
  2. … 721 more files in changeset.
Sunday 05 Jun 2005
5:12 pm

donb

Fixed someone's typo in the new "merge" pl/sql procs

Options
    • -2
    • +2
    ./groups-body-create.sql
Tuesday 24 May 2005
4:21 am

enriquec

Adding the member_state 'merged'. Added plsql functions and upgrade scripts for oracle and pg.

Options
    • -4
    • +11
    ./groups-body-create.sql
  2. … 6 more files in changeset.
Monday 12 Jul 2004
4:49 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

Options
    • -9
    • +9
    ./groups-body-create.sql
  2. … 116 more files in changeset.
Friday 09 Jul 2004
11:43 am

jeffd

flip order of delete for group delete

Options
    • -10
    • +10
    ./groups-body-create.sql
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -1
    • +5
    ./groups-body-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -5
    • +1
    ./groups-body-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:38 pm

andrewg

fixing a syntax error

Options
    • -2
    • +2
    ./groups-body-create.sql
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -1
    • +5
    ./groups-body-create.sql
  2. … 96 more files in changeset.
Tuesday 30 Sep 2003
2:10 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
    • -15
    • +19
    ./groups-body-create.sql
  2. … 275 more files in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -1
    • +48
    ./groups-body-create.sql
  2. … 816 more files in changeset.
Friday 04 Jul 2003
2:22 pm

lars

1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

Options
    • -1
    • +48
    ./groups-body-create.sql
  2. … 8 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -3
    • +45
    ./groups-body-create.sql
  2. … 30 more files in changeset.
Monday 24 Mar 2003
9:30 pm

donb

Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

Options
    • -3
    • +45
    ./groups-body-create.sql
  2. … 4 more files in changeset.
Friday 21 Mar 2003
3:57 pm

donb

Accidently dropped the latest PG rather than Oracle versions of these files

here.

Options
    • -603
    • +458
    ./groups-body-create.sql
  2. … 3 more files in changeset.
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -458
    • +603
    ./groups-body-create.sql
  2. … 7 more files in changeset.
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -19
    • +60
    ./groups-body-create.sql
  2. … 17 more files in changeset.
Sunday 16 Feb 2003
3:15 am

donb

Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

Options
    • -2
    • +3
    ./groups-body-create.sql
  2. … 4 more files in changeset.
Saturday 15 Feb 2003
9:56 pm

donb

Fixed various problems with the new permissions and minor main site changes

Options
    • -49
    • +35
    ./groups-body-create.sql
  2. … 5 more files in changeset.
4:23 am

donb

First cut at Oracle perm rewrite and some whacking around on the PG version

Options
    • -1
    • +55
    ./groups-body-create.sql
  2. … 10 more files in changeset.
Saturday 23 Feb 2002
3:43 am

donb

Added C. R. Oldham's patch to fix membership testing (unimplemented in ACS

4.2). Ported it to PG on the way ...

Options
    • -4
    • +32
    ./groups-body-create.sql
  2. … 9 more files in changeset.
Saturday 11 Aug 2001
11:31 pm

ben

Fixed a few spelling mistakes

Ported a bunch more of acs-subsite

Fixed a few small, acs-subsite related bugs

Options
    • -2
    • +2
    ./groups-body-create.sql
  2. … 41 more files in changeset.
Tuesday 20 Mar 2001
11:51 pm

donb

bootstrapper can now load either the Oracle or PostgreSQL acs-kernel

datamodel. It checks on-the-fly for which db is configured in the OpenNSD

database pools allocated to OpenACS. Only acs-kernel is correctly self-

configured at this point.

Options
    • -0
    • +749
    ./groups-body-create.sql
  2. … 113 more files in changeset.