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 -N -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 -N -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
Index: openacs-4/packages/intermedia-driver/sql/oracle/syndication-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/syndication-create.sql,v
diff -u -N
--- openacs-4/packages/intermedia-driver/sql/oracle/syndication-create.sql	27 Jan 2006 16:03:57 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,17 +0,0 @@
-create table syndication (
-        object_id       integer
-                        constraint syndication_object_id_fk
-                        references acs_objects (object_id) on delete cascade
-                        constraint syndication_pk
-                        primary key,
-        last_updated    date default sysdate not null,
-        rss_xml_frag    blob,
-        body            blob,
-        url             blob
-);
-
-
-comment on table syndication is 'stores xml fragments for consolidating into rss feeds. Also stores an html version of the content item
-         and it''s url from the link field of the rss';
-
-exit;
Index: openacs-4/packages/intermedia-driver/sql/oracle/syndication-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/syndication-drop.sql,v
diff -u -N
--- openacs-4/packages/intermedia-driver/sql/oracle/syndication-drop.sql	27 Jan 2006 16:03:57 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,3 +0,0 @@
-drop table syndication;
-
-exit;