Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0b9-5.2.0b10.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/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/oracle/upgrade/upgrade-5.2.0b9-5.2.0b10.sql 29 Mar 2006 10:47:21 -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, object_id_one, object_id_two + from acs_rels + where rel_type = 'application_data_link');