Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -N -r1.80.2.8 -r1.80.2.9 --- openacs-4/packages/acs-kernel/acs-kernel.info 10 Dec 2005 11:24:52 -0000 1.80.2.8 +++ openacs-4/packages/acs-kernel/acs-kernel.info 14 Dec 2005 22:11:02 -0000 1.80.2.9 @@ -7,7 +7,7 @@ t t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2005-12-01 @@ -16,7 +16,7 @@ GPL 3 - + 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 -N -r1.8 -r1.8.2.1 --- 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 14 Dec 2005 22:11:04 -0000 1.8.2.1 @@ -329,6 +329,32 @@ 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_rel_id_fk + 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 -- -------------- Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql,v diff -u -N -r1.18.2.4 -r1.18.2.5 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql 12 Oct 2005 18:23:04 -0000 1.18.2.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql 14 Dec 2005 22:11:04 -0000 1.18.2.5 @@ -360,6 +360,32 @@ 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 -- -------------- Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql 14 Dec 2005 22:11:04 -0000 1.1.2.1 @@ -0,0 +1,28 @@ +---------------------------- +-- 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); + +insert into acs_data_links +(select - rel_id as rel_id, object_id_one, object_id_two + from acs_rels + where rel_type = 'application_data_link');