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

groups-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 13 Oct
Commits this week: 0
Total Lines of Code (LoC): 559
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
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./groups-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -6
    • +11
    ./groups-create.sql
  2. … 8099 more files in changeset.
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
    • +5
    ./groups-create.sql
  2. … 10 more files in changeset.
Friday 22 Jul 2022
7:37 pm

gustafn

Added membership "expired" to membership states. "expired" can be

used for "dormant" accounts, which are neither "banned" nor "deleted".

Options
    • -2
    • +2
    ./groups-create.sql
  2. … 4 more files in changeset.
Sunday 13 Feb 2022
2:21 pm

gustafn

The composite_p attribute for acs_object_type.create_type() was missing

This fixes in essence the following errors.

acs_rel_type.create_type (

*

ERROR at line 35:

ORA-06550: line 35, column 2:

PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE'

ORA-06550: line 35, column 2:

PL/SQL: Statement ignored

ORA-06550: line 54, column 2:

PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE'

ORA-06550: line 54, column 2:

PL/SQL: Statement ignored

ORA-06550: line 70, column 2:

PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE'

ORA-06550: line 70, column 2:

PL/SQL: Statement ignored

No errors

insert into group_type_rels

*

ERROR at line 1:

ORA-02291: integrity constraint (OPENACS.GROUP_TYPE_RELS_GROUP_TYPE_FK)

violated - parent key not found

insert into group_type_rels

*

ERROR at line 1:

ORA-02291: integrity constraint (OPENACS.GROUP_TYPE_RELS_GROUP_TYPE_FK)

violated - parent key not found

Options
    • -5
    • +5
    ./groups-create.sql
  2. … 1 more file in changeset.
Sunday 12 Apr 2020
10:52 am

gustafn

Added index on foreign key column to reduce sequential reads on delete

operations, since the optimizer brain fart ((c)Don Baccus) that existed

17 years ago in pg 7.2 seems to be gone

(https://openacs.org/forums/message-view?message_id=142769)

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

gustafn

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

Options
    • -6
    • +9
    ./groups-create.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./groups-create.sql
  2. … 48 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
    • -4
    • +7
    ./groups-create.sql
  2. … 34 more files in changeset.
Monday 08 Sep 2008
10:05 pm

daveb

Add description to groups object type

Options
    • -2
    • +3
    ./groups-create.sql
  2. … 4 more files in changeset.
Friday 18 Aug 2006
8:17 pm

emmar

Applying constraint naming standard

Options
    • -31
    • +36
    ./groups-create.sql
  2. … 10 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
    • -2
    • +6
    ./groups-create.sql
  2. … 721 more files in changeset.
Tuesday 24 May 2005
4:21 am

enriquec

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

Options
    • -2
    • +6
    ./groups-create.sql
  2. … 6 more files in changeset.
Sunday 27 Feb 2005
2:21 am

donb

A variety of group oriented things, and finally added the definitions of

acs-objects package procs in PG so that we can use package_instantiate_object

and package_db_exec with them.

Options
    • -3
    • +5
    ./groups-create.sql
  2. … 10 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -2
    • +7
    ./groups-create.sql
  2. … 598 more files in changeset.
Thursday 20 Nov 2003
5:32 pm

jeffd

Adds max_child_sortkey to acs_objects, uses select for update to incr

tree_sortkey (fixes concurrency problems and substantially improves

performance), drop group_elem_idx_container_idx (not useful) and

acs_objects_context_object_idx (which is superflous since there is an

identical unique constraint). changes acs_objects_get_tree_sortkey to

be isstrict/iscachable fixes a bug in acs_objects_context_id_up_tr on

both oracle an postgres.

See http://openacs.org/forums/message-view?message_id=142769 for discussion.

Options
    • -2
    • +7
    ./groups-create.sql
  2. … 7 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
    • -5
    • +5
    ./groups-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
    • +47
    ./groups-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
    • +47
    ./groups-create.sql
  2. … 8 more files in changeset.
Thursday 05 Dec 2002
2:07 pm

peterm

I18N: we need pretty_name and pretty_plural of the member relationship role to be internationalized in dotLRN - using two new message keys

Options
    • -2
    • +2
    ./groups-create.sql
  2. … 2 more files in changeset.
Monday 16 Sep 2002
11:52 pm

jeffd

increase field sizes (from sloan)

Options
    • -2
    • +2
    ./groups-create.sql
  2. … 3 more files in changeset.
Friday 29 Mar 2002
6:12 pm

yon

adding an index to increase performance of some views

Options
    • -1
    • +3
    ./groups-create.sql
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
    • -2
    • +4
    ./groups-create.sql
  2. … 9 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
    • +484
    ./groups-create.sql
  2. … 113 more files in changeset.