Index: openacs-4/packages/search/sql/oracle/search-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-tables-create.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/search/sql/oracle/search-tables-create.sql	7 Jun 2005 19:00:07 -0000	1.3
+++ openacs-4/packages/search/sql/oracle/search-tables-create.sql	7 Jun 2005 19:58:15 -0000	1.4
@@ -30,6 +30,13 @@
                                         constraint sws_index_fk references acs_objects(object_id) on delete cascade,
 	object_name	     	varchar(4000),
 	indexed_content	        clob,
+	package_id		integer 
+-- TODO Dirk: bring back not null constraint 
+--		                     constraint swi_package_id_nn
+--		                     not null
+				     constraint swi_package_id_fk
+                                     references apm_packages
+                                     on delete cascade,
 	datastore		char(1) not null,
         event_date                      date
                                         default sysdate,