Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	7 Nov 2001 04:13:45 -0000	1.11
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	7 Nov 2001 22:55:49 -0000	1.12
@@ -446,15 +446,12 @@
   has_child_symlinks char(1)
                      default 'f'
                      constraint cr_folder_symlink_chk
-                     check (has_child_symlinks in ('t', 'f'))
+                     check (has_child_symlinks in ('t', 'f')),
+  package_id integer 
+  constraint cr_fldr_pkg_id_fk
+  references apm_packages
 );  
 
-alter table cr_folders add (
-    package_id integer 
-    constraint cr_fldr_pkg_id_fk
-    references apm_packages
-);
-
 comment on table cr_folders is '
   Folders are used to support a virtual file system within the content
   repository.
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.30 -r1.31
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	7 Nov 2001 04:12:58 -0000	1.30
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	7 Nov 2001 22:55:49 -0000	1.31
@@ -723,7 +723,10 @@
   label		    varchar(1000),
   description	    text,
   has_child_folders boolean default 'f',
-  has_child_symlinks boolean default 'f'
+  has_child_symlinks boolean default 'f',
+  package_id integer 
+  constraint cr_fldr_pkg_id_fk
+  references apm_packages
 );  
 
 comment on table cr_folders is '
@@ -1321,8 +1324,6 @@
 -- 05-Nov-2001 Jon Griffin jon@mayuli.com
 
 alter table cr_folders
-
-alter table cr_folders
 add constraint cr_flder_pkg_id_fk foreign key (package_id) references apm_packages (package_id);
 
 --constraint cr_fldr_pkg_id_fk