Index: openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/search-packages-create.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql	27 Jan 2006 16:03:57 -0000	1.1
+++ openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql	16 Apr 2008 13:00:18 -0000	1.1.2.1
@@ -26,57 +26,6 @@
 -- The site_wide_search packages holds generally useful
 -- PL/SQL procedures and functions.
 
-create or replace package search_observer
-as
-  procedure enqueue (
-	object_id 	acs_objects.object_id%TYPE,
-	event		search_observer_queue.event%TYPE
-);
-  procedure dequeue (
-        object_id acs_objects.object_id%TYPE, event
-	search_observer_queue.event%TYPE, event_date
-	search_observer_queue.event_date%TYPE
-);
-end search_observer;
-/
-show errors
-
-create or replace package body search_observer
-as
-  procedure enqueue (
-	object_id 	acs_objects.object_id%TYPE,
-	event		search_observer_queue.event%TYPE
-) is
-begin
-    insert into search_observer_queue (
-	object_id,
-	event
-    ) values (
-        enqueue.object_id,
-	enqueue.event
-    );
-
-  end enqueue;
-
-  procedure dequeue (
-	object_id 	acs_objects.object_id%TYPE,
-	event		search_observer_queue.event%TYPE,
-	event_date	search_observer_queue.event_date%TYPE
-) is
-  begin
-
-
-    delete from search_observer_queue 
-    where object_id = dequeue.object_id 
-    and event = dequeue.event
-    and to_char(dequeue.event_date,'yyyy-mm-dd hh24:mi:ss') = to_char(dequeue.event_date,'yyyy-mm-dd hh24:mi:ss');
-
-  end dequeue;
-end search_observer;
-/
-show errors
-
-
 create or replace package site_wide_search
 as
   procedure register_event (p_object_id	search_observer_queue.object_id%TYPE,
Index: openacs-4/packages/intermedia-driver/sql/oracle/search-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/search-tables-create.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/intermedia-driver/sql/oracle/search-tables-create.sql	27 Jan 2006 16:03:57 -0000	1.1
+++ openacs-4/packages/intermedia-driver/sql/oracle/search-tables-create.sql	16 Apr 2008 13:00:18 -0000	1.1.2.1
@@ -54,15 +54,6 @@
         relevant_date           date
 );
 
-create table search_observer_queue (
-    object_id                       integer,
-    event_date                      date
-                                    default sysdate,
-    event                           varchar(6)
-                                    constraint search_observer_queue_event_ck
-                                    check (event in ('INSERT','DELETE','UPDATE'))  
-);
-
 -- Intermedia sometimes is painful to debug, so I added a logging
 -- mechanism which relies on Oracle's autonomous transactions: DML
 -- statements are committed immediately so you can access this data
Fisheye: Tag 1.1.2.1 refers to a dead (removed) revision in file `openacs-4/packages/intermedia-driver/sql/oracle/syndication-create.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1.2.1 refers to a dead (removed) revision in file `openacs-4/packages/intermedia-driver/sql/oracle/syndication-drop.sql'.
Fisheye: No comparison available.  Pass `N' to diff?