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');