Index: openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 27 Feb 2005 01:21:07 -0000 1.8 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 4 Jun 2006 00:45:38 -0000 1.9 @@ -329,6 +329,31 @@ acs_attributes. '; +---------------------------- +-- Application Data Links -- +---------------------------- + +create sequence acs_data_links_seq start with 1; + +create table acs_data_links ( + rel_id integer not null + constraint acs_data_links_pk primary key, + object_id_one integer not null + constraint acs_data_links_one_fk + references acs_objects (object_id) + on delete cascade, + object_id_two integer not null + constraint acs_data_links_two_fk + references acs_objects (object_id) + on delete cascade, + constraint acs_data_links_un unique + (object_id_one, object_id_two) +); + +create index acs_data_links_id_one_idx on acs_data_links (object_id_one); +create index acs_data_links_id_two_idx on acs_data_links (object_id_two); + + -------------- -- TRIGGERS -- --------------