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

acs-relationships-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 550
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • +9
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
Saturday 12 Feb 2022
9:13 pm

gustafn

providing compatibility with Oracle 19c

Either these scripts never worked for Oracle, or these Oracle changed over the years

Options
    • -2
    • +2
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
Thursday 01 Nov 2018
9:38 am

gustafn

improve comments and spelling

Options
    • -2
    • +2
    ./acs-relationships-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
    • -1
    • +2
    ./acs-relationships-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
    • -1
    • +2
    ./acs-relationships-create.sql
  2. … 34 more files in changeset.
Wednesday 06 Jan 2010
9:07 pm

ryang

add three column constraint to acs_data_links

Options
    • -6
    • +4
    ./acs-relationships-create.sql
  2. … 3 more files in changeset.
Tuesday 05 Jan 2010
4:30 pm

ryang

drop acs_data_links unique constraint, use unique index instead.

Options
    • -4
    • +5
    ./acs-relationships-create.sql
  2. … 3 more files in changeset.
Monday 04 Jan 2010
8:54 pm

ryang

TIP #138 - Add relation_tag to acs_data_links

Options
    • -2
    • +4
    ./acs-relationships-create.sql
  2. … 7 more files in changeset.
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

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

emmar

Applying constraint naming standard

Options
    • -18
    • +27
    ./acs-relationships-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
    • -1
    • +26
    ./acs-relationships-create.sql
  2. … 721 more files in changeset.
Wednesday 04 Jan 2006
1:48 am

donb

Fixed malte/timo typo that broke oracle

Options
    • -2
    • +1
    ./acs-relationships-create.sql
Wednesday 14 Dec 2005
11:11 pm

timoh

added new seperate table for application_data_links

Options
    • -1
    • +27
    ./acs-relationships-create.sql
  2. … 3 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
    • -7
    • +10
    ./acs-relationships-create.sql
  2. … 10 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -1
    • +2
    ./acs-relationships-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
    • -1
    • +0
    ./acs-relationships-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

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

Options
    • -1
    • +2
    ./acs-relationships-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
    • -4
    • +4
    ./acs-relationships-create.sql
  2. … 275 more files in changeset.
Wednesday 13 Feb 2002
5:58 pm

yon

fixed remove_user function to do the right things

Options
    • -3
    • +3
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
Friday 11 May 2001
2:14 am

donb

1. Polished up the query files for the root www directory

2. Turned a bunch of bitmap indexes into b-tree indexes

3. the developer support .info file had been messed over by an early

version of my APM port to PG.

Options
    • -5
    • +9
    ./acs-relationships-create.sql
  2. … 8 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
    • +506
    ./acs-relationships-create.sql
  2. … 113 more files in changeset.