Index: openacs-4/packages/search/sql/oracle/load-site-wide-search
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/load-site-wide-search,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/search/sql/oracle/load-site-wide-search	21 May 2005 11:34:10 -0000	1.1
+++ openacs-4/packages/search/sql/oracle/load-site-wide-search	8 Nov 2005 18:24:06 -0000	1.2
@@ -39,10 +39,14 @@
 # For programming convenience just drop everything
 sqlplus ${USERNAME}/${PASSWORD}   @search-tables-drop.sql 
 sqlplus ${USERNAME}/${PASSWORD}   @search-packages-drop.sql 
+sqlplus ${USERNAME}/${PASSWORD}   @search-sc-drop.sql
 sqlplus ${USERNAME}/${PASSWORD}   @search-index-drop.sql  ${USERNAME} ${PASSWORD}
 
 sqlplus ${USERNAME}/${PASSWORD}   @search-tables-create.sql 
 sqlplus ${USERNAME}/${PASSWORD}   @search-packages-create.sql 
-sqlplus ctxsys/${CTXSYS_PASSWORD} @search-ctxsys.sql ${USERNAME} ${PASSWORD}
+sqlplus ${USERNAME}/${PASSWORD}   @search-sc-create.sql
+sqlplus ${USERNAME}/${PASSWORD}   @syndication-create.sql
+
+sqlplus ctxsys/${CTXSYS_PASSWORD} @search-ctxsys.sql  ${USERNAME} ${PASSWORD}
 sqlplus ${USERNAME}/${PASSWORD}   @search-index-create.sql  ${USERNAME} ${PASSWORD}
 sqlplus ${USERNAME}/${PASSWORD}   @search-from-scratch.sql