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.11 -r1.12 --- openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 26 Sep 2006 14:48:02 -0000 1.11 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 4 Jan 2010 19:54:37 -0000 1.12 @@ -355,12 +355,14 @@ constraint acs_data_links_obj_two_fk references acs_objects (object_id) on delete cascade, + relation_tag varchar2(100), constraint acs_data_links_un unique - (object_id_one, object_id_two) + (object_id_one, object_id_two, relation_tag) ); 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); +create index acs_data_links_rel_tag_idx on acs_data_links (relation_tag); --------------