Index: openacs-4/packages/search/sql/oracle/search-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/search/sql/oracle/search-create.sql 8 Nov 2005 18:24:06 -0000 1.3 +++ openacs-4/packages/search/sql/oracle/search-create.sql 31 Aug 2006 07:31:29 -0000 1.4 @@ -1,3 +1,4 @@ @@ search-tables-create.sql @@ search-packages-create.sql @@ search-sc-create.sql +@@ syndication-create.sql Index: openacs-4/packages/search/sql/oracle/search-ctxsys.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/search-ctxsys.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/search/sql/oracle/search-ctxsys.sql 21 May 2005 11:34:10 -0000 1.1 +++ openacs-4/packages/search/sql/oracle/search-ctxsys.sql 31 Aug 2006 07:31:29 -0000 1.2 @@ -37,5 +37,3 @@ -- stuff to make interMedia faster exec ctx_adm.set_parameter('max_index_memory', '1G'); - -exit; Index: openacs-4/packages/search/sql/oracle/search-from-scratch.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-from-scratch.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/search/sql/oracle/search-from-scratch.sql 8 Nov 2005 18:24:06 -0000 1.2 +++ openacs-4/packages/search/sql/oracle/search-from-scratch.sql 31 Aug 2006 07:31:29 -0000 1.3 @@ -54,9 +54,3 @@ --alter index swi_index rebuild parameters ('sync') ; - - -exit; - - - Index: openacs-4/packages/search/sql/oracle/search-index-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/search-index-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/search/sql/oracle/search-index-create.sql 8 Nov 2005 18:24:06 -0000 1.2 +++ openacs-4/packages/search/sql/oracle/search-index-create.sql 31 Aug 2006 07:31:29 -0000 1.3 @@ -49,4 +49,3 @@ create index swi_index on site_wide_index (indexed_content) indextype is ctxsys.context parameters ('datastore ctxsys.default_datastore memory 250M'); -exit; \ No newline at end of file Index: openacs-4/packages/search/sql/oracle/search-index-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/search-index-drop.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/search/sql/oracle/search-index-drop.sql 8 Nov 2005 18:24:06 -0000 1.2 +++ openacs-4/packages/search/sql/oracle/search-index-drop.sql 31 Aug 2006 07:31:29 -0000 1.3 @@ -28,5 +28,3 @@ / drop index swi_ctx_index; - -exit; Index: openacs-4/packages/search/sql/oracle/search-index-from-scratch.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/search-index-from-scratch.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/search/sql/oracle/search-index-from-scratch.sql 21 May 2005 11:34:10 -0000 1.1 +++ openacs-4/packages/search/sql/oracle/search-index-from-scratch.sql 31 Aug 2006 07:31:29 -0000 1.2 @@ -13,8 +13,3 @@ alter index sws_ctx_index rebuild parameters ('sync') ; select * from sws_log_messages; -quit -exit - - - Index: openacs-4/packages/search/sql/oracle/search-packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-packages-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/search/sql/oracle/search-packages-create.sql 8 Nov 2005 18:24:06 -0000 1.3 +++ openacs-4/packages/search/sql/oracle/search-packages-create.sql 31 Aug 2006 07:31:29 -0000 1.4 @@ -239,228 +239,230 @@ / show errors +-- TRIGGERS SHOULD GO IN THEIR OWN PACKAGE -- + -------------------------------------------------------- -- Forum triggers and procedures -create or replace trigger forums_messages_sws_insert_tr - after insert on forums_messages for each row -begin - site_wide_search.register_event (:new.message_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger forums_messages_sws_insert_tr +-- after insert on forums_messages for each row +-- begin +-- site_wide_search.register_event (:new.message_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger forums_messages_sws_update_tr - after update on forums_messages for each row -begin - site_wide_search.register_event (:new.message_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger forums_messages_sws_update_tr +-- after update on forums_messages for each row +-- begin +-- site_wide_search.register_event (:new.message_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger forums_messages_sws_delete_tr - after delete on forums_messages for each row -begin - site_wide_search.register_event (:new.message_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger forums_messages_sws_delete_tr +-- after delete on forums_messages for each row +-- begin +-- site_wide_search.register_event (:new.message_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- static-portal triggers and procedures -create or replace trigger static_portal_sws_insert_tr - after insert on static_portal_content for each row -begin - site_wide_search.register_event (:new.content_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger static_portal_sws_insert_tr +-- after insert on static_portal_content for each row +-- begin +-- site_wide_search.register_event (:new.content_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger static_portal_sws_update_tr - after update on static_portal_content for each row -begin - site_wide_search.register_event (:new.content_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger static_portal_sws_update_tr +-- after update on static_portal_content for each row +-- begin +-- site_wide_search.register_event (:new.content_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger static_portal_sws_delete_tr - after delete on static_portal_content for each row -begin - site_wide_search.register_event (:new.content_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger static_portal_sws_delete_tr +-- after delete on static_portal_content for each row +-- begin +-- site_wide_search.register_event (:new.content_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- ACS-events triggers and procedures -- I think only calendar makes use of the acs-events tables. -create or replace trigger acs_events_sws_insert_tr - after insert on acs_events for each row -begin - site_wide_search.register_event (:new.event_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger acs_events_sws_insert_tr +-- after insert on acs_events for each row +-- begin +-- site_wide_search.register_event (:new.event_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger acs_events_sws_update_tr - after update on acs_events for each row -begin - site_wide_search.register_event (:new.event_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger acs_events_sws_update_tr +-- after update on acs_events for each row +-- begin +-- site_wide_search.register_event (:new.event_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger acs_events_sws_delete_tr - after delete on acs_events for each row -begin - site_wide_search.register_event (:new.event_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger acs_events_sws_delete_tr +-- after delete on acs_events for each row +-- begin +-- site_wide_search.register_event (:new.event_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- FAQ triggers and procedures -create or replace trigger faq_q_and_as_sws_insert_tr - after insert on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.entry_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_insert_tr +-- after insert on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.entry_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger faq_q_and_as_sws_update_tr - after update on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.entry_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_update_tr +-- after update on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.entry_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger faq_q_and_as_sws_delete_tr - after delete on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.entry_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_delete_tr +-- after delete on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.entry_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- Survey Procs -create or replace trigger surveys_sws_insert_tr - after insert on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger surveys_sws_insert_tr +-- after insert on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger surveys_sws_update_tr - after update on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger surveys_sws_update_tr +-- after update on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger surveys_sws_delete_tr - after delete on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger surveys_sws_delete_tr +-- after delete on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- Photobook Procs -create or replace trigger phb_person_sws_insert_tr - after insert on phb_person for each row -begin - site_wide_search.register_event (:new.person_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger phb_person_sws_insert_tr +-- after insert on phb_person for each row +-- begin +-- site_wide_search.register_event (:new.person_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger phb_person_sws_update_tr - after update on phb_person for each row -begin - site_wide_search.register_event (:new.person_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger phb_person_sws_update_tr +-- after update on phb_person for each row +-- begin +-- site_wide_search.register_event (:new.person_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger phb_person_sws_delete_tr - after delete on phb_person for each row -begin - site_wide_search.register_event (:new.person_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger phb_person_sws_delete_tr +-- after delete on phb_person for each row +-- begin +-- site_wide_search.register_event (:new.person_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- FAQ Procs -create or replace trigger faq_q_and_as_sws_insert_tr - after insert on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.faq_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_insert_tr +-- after insert on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.faq_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger faq_q_and_as_sws_update_tr - after update on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.faq_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_update_tr +-- after update on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.faq_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger faq_q_and_as_sws_delete_tr - after delete on faq_q_and_as for each row -begin - site_wide_search.register_event (:new.faq_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger faq_q_and_as_sws_delete_tr +-- after delete on faq_q_and_as for each row +-- begin +-- site_wide_search.register_event (:new.faq_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- Survey Procs -create or replace trigger surveys_sws_insert_tr - after insert on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'INSERT'); -end; -/ -show errors +-- create or replace trigger surveys_sws_insert_tr +-- after insert on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'INSERT'); +-- end; +-- / +-- show errors -create or replace trigger surveys_sws_update_tr - after update on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'UPDATE'); -end; -/ -show errors +-- create or replace trigger surveys_sws_update_tr +-- after update on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'UPDATE'); +-- end; +-- / +-- show errors -create or replace trigger surveys_sws_delete_tr - after delete on surveys for each row -begin - site_wide_search.register_event (:new.survey_id, 'DELETE'); -end; -/ -show errors +-- create or replace trigger surveys_sws_delete_tr +-- after delete on surveys for each row +-- begin +-- site_wide_search.register_event (:new.survey_id, 'DELETE'); +-- end; +-- / +-- show errors -------------------------------------------------------- -- The user_datastore proc which is called on every change of the datastore. @@ -482,6 +484,3 @@ end; / show errors; - - -exit; Index: openacs-4/packages/search/sql/oracle/search-sc-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-sc-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/search/sql/oracle/search-sc-create.sql 8 Nov 2005 18:24:06 -0000 1.2 +++ openacs-4/packages/search/sql/oracle/search-sc-create.sql 31 Aug 2006 07:31:29 -0000 1.3 @@ -183,5 +183,3 @@ end; / show errors - -exit; \ No newline at end of file Index: openacs-4/packages/search/sql/oracle/search-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-tables-create.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/search/sql/oracle/search-tables-create.sql 10 Aug 2006 16:01:47 -0000 1.6 +++ openacs-4/packages/search/sql/oracle/search-tables-create.sql 31 Aug 2006 07:31:29 -0000 1.7 @@ -74,4 +74,3 @@ logmessage varchar2(4000), logtime date default sysdate); -exit; Index: openacs-4/packages/search/sql/oracle/syndication-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/syndication-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/search/sql/oracle/syndication-create.sql 8 Nov 2005 18:24:07 -0000 1.2 +++ openacs-4/packages/search/sql/oracle/syndication-create.sql 31 Aug 2006 07:31:29 -0000 1.3 @@ -4,7 +4,8 @@ references acs_objects (object_id) on delete cascade constraint syndication_pk primary key, - last_updated date default sysdate not null, + last_updated date default sysdate + constraint syndication_last_updated_nn not null, rss_xml_frag blob, body blob, url blob @@ -13,5 +14,3 @@ 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/search/sql/oracle/syndication-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/syndication-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/search/sql/oracle/syndication-drop.sql 8 Nov 2005 18:24:07 -0000 1.1 +++ openacs-4/packages/search/sql/oracle/syndication-drop.sql 31 Aug 2006 07:31:29 -0000 1.2 @@ -1,3 +1 @@ drop table syndication; - -exit;