Index: openacs-4/packages/forums/sql/oracle/forums-search-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-search-create.sql,v
diff -u -r1.8 -r1.8.4.1
--- openacs-4/packages/forums/sql/oracle/forums-search-create.sql	13 Oct 2003 07:47:52 -0000	1.8
+++ openacs-4/packages/forums/sql/oracle/forums-search-create.sql	13 May 2004 10:23:32 -0000	1.8.4.1
@@ -22,12 +22,19 @@
 -- @version $Id$
 --
 
--- IMPORTANT:
--- replace all instances of the string "yon" below this line with your schema
--- user and schema password accordingly. also, replace the "connect
--- ctxsys/ctxsys" statement with the appropriate values for your system. need
--- to figure out how to do this in a better way.
 
+
+-- Call this script like this:
+-- 
+-- sqlplus /nolog @forums-search-create.sql <ctxsys-password> <openacs-db-user> <openacs-db-password>
+-- 
+--   &1 = ctxsys password
+--   &2 = OpenACS database user
+--   &3 = OpenACS database password
+
+
+connect &2/&3;
+
 -- as normal user
 create or replace procedure index_message (
     rid                             in rowid,
@@ -57,24 +64,24 @@
 show errors
 
 -- as ctxsys
-connect ctxsys/ctxsys;
+connect ctxsys/&1;
 
 create or replace procedure s_index_message (
     rid                             in rowid,
     tlob                            in out NOCOPY clob
 )
 is
 begin
-    yon.index_message(rid, tlob);
+    &2..index_message(rid, tlob);
 end;
 /
 show errors
 
-grant execute on s_index_message to yon;
-grant execute on ctx_ddl to yon;
+grant execute on s_index_message to &2;
+grant execute on ctx_ddl to &2;
 
 -- as normal user
-connect yon/yon;
+connect &2/&3;
 
 execute ctx_ddl.create_preference('forums_user_datastore', 'user_datastore');
 execute ctx_ddl.set_attribute('forums_user_datastore', 'procedure', 's_index_message');
@@ -96,9 +103,6 @@
 /
 show errors
 
--- as normal user
-connect yon/yon;
-
 -- ripped off from site-wide-search
 
 -- if we pass in a very long string to im_convert, we will end up with internal 
@@ -264,3 +268,6 @@
 end;
 /
 show errors;
+
+exit
+
Index: openacs-4/packages/forums/sql/oracle/forums-search-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-search-drop.sql,v
diff -u -r1.4 -r1.4.8.1
--- openacs-4/packages/forums/sql/oracle/forums-search-drop.sql	9 Aug 2002 20:51:49 -0000	1.4
+++ openacs-4/packages/forums/sql/oracle/forums-search-drop.sql	13 May 2004 10:23:32 -0000	1.4.8.1
@@ -22,22 +22,25 @@
 -- @version $Id$
 --
 
--- IMPORTANT:
--- replace all instances of the string "yon" below this line with your schema
--- user and schema password accordingly. also, replace the "connect
--- ctxsys/ctxsys" statement with the appropriate values for your system. need
--- to figure out how to do this in a better way.
+-- Call this script like this:
+-- 
+-- sqlplus /nolog @forums-search-create.sql <ctxsys-password> <openacs-db-user> <openacs-db-password>
+-- 
+--   &1 = ctxsys password
+--   &2 = OpenACS database user
+--   &3 = OpenACS database password
 
--- as normal user
 
+connect &2/&3;
+
 drop function im_convert;
 drop procedure im_convert_length_check;
 
 declare
 begin
     for row in (select job
                 from user_jobs
-                where what like '%yon.forums_content_idx%')
+                where what like '%&2..forums_content_idx%')
     loop
         dbms_job.remove(job => row.job);
     end loop;
@@ -51,11 +54,13 @@
 execute ctx_ddl.drop_preference('forums_user_datastore');
 
 -- as ctxsys
-connect ctxsys/ctxsys;
+connect ctxsys/&1;
 
 drop procedure s_index_message;
 
 -- as normal user
-connect yon/yon;
+connect &2/&3;
 
 drop procedure index_message;
+
+exit