Index: openacs-4/packages/faq/faq.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/faq.info,v
diff -u -N -r1.19.2.1 -r1.19.2.2
--- openacs-4/packages/faq/faq.info 2 Apr 2007 14:18:29 -0000 1.19.2.1
+++ openacs-4/packages/faq/faq.info 11 Jul 2007 09:56:58 -0000 1.19.2.2
@@ -7,18 +7,18 @@
f
f
-
+
Elizabeth Wirth
Jennie Kim Housman
Nima Mazloumi
Manage simple and categorized Question and Answer style FAQs with WYSIWYG and notification functionalities.
- 2004-08-12
+ 2007-07-11
Ybos Corporation
Handles frequently asked questions Q&A presentation. Can be one Q&A per page or all presented flat. Straightforward application with room for improvement. Support for notification as well as WYSIQYG Editor and Categories - both optional. Category trees are displayed flat. No multiple filters.
2
-
-
+
+
Index: openacs-4/packages/faq/sql/postgresql/faq-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-create.sql,v
diff -u -N -r1.5 -r1.5.6.1
--- openacs-4/packages/faq/sql/postgresql/faq-create.sql 1 Apr 2004 22:52:46 -0000 1.5
+++ openacs-4/packages/faq/sql/postgresql/faq-create.sql 11 Jul 2007 09:56:59 -0000 1.5.6.1
@@ -142,9 +142,4 @@
\i faq-package-create.sql
-
-
-
-
-
-
+\i faq-sc-create.sql
Index: openacs-4/packages/faq/sql/postgresql/faq-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-drop.sql,v
diff -u -N -r1.3 -r1.3.12.1
--- openacs-4/packages/faq/sql/postgresql/faq-drop.sql 17 May 2003 10:33:37 -0000 1.3
+++ openacs-4/packages/faq/sql/postgresql/faq-drop.sql 11 Jul 2007 09:56:59 -0000 1.3.12.1
@@ -2,6 +2,15 @@
-- @author wirth@ybos.net
--openacs port @samir.symphinity.com
+--drop triggers
+drop trigger faq_sc__itrg on faq_q_and_as;
+drop trigger faq_sc__dtrg on faq_q_and_as;
+drop trigger faq_sc__utrg on faq_q_and_as;
+
+drop function faq_sc__itrg ()
+drop function faq_sc__dtrg ()
+drop function faq_sc__utrg ()
+
--drop functions
drop function faq__new_q_and_a (integer,integer,varchar,varchar,integer,varchar,timestamptz,integer,varchar,integer);
drop function faq__delete_q_and_a (integer);
Index: openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql 11 Jul 2007 09:56:59 -0000 1.1.2.1
@@ -0,0 +1,38 @@
+--
+-- packages/faq/sql/postgresql/faq-sc-create.sql
+--
+-- @author Emmanuelle Raffenne (eraffenne@dia.uned.es)
+-- @creation-date 2007-07-11
+-- @arch-tag: 24e3ba57-1575-4718-b664-924e7bc170e1
+-- @cvs-id $Id: faq-sc-create.sql,v 1.1.2.1 2007/07/11 09:56:59 emmar Exp $
+--
+
+create function faq_sc__itrg ()
+returns opaque as '
+ begin
+ perform search_observer__enqueue(new.entry_id,''INSERT'');
+ return new;
+ end; '
+language 'plpgsql';
+
+create function faq_sc__dtrg ()
+returns opaque as '
+ begin
+ perform search_observer__enqueue(old.entry_id,''DELETE'');
+ return old;
+ end; '
+language 'plpgsql';
+
+create function faq_sc__utrg ()
+returns opaque as '
+ begin
+ perform search_observer__enqueue(old.entry_id,''UPDATE'');
+ return old;
+ end; '
+language 'plpgsql';
+
+create trigger faq_sc__itrg after insert on faq_q_and_as for each row execute procedure faq_sc__itrg ();
+
+create trigger faq_sc__dtrg after delete on faq_q_and_as for each row execute procedure faq_sc__dtrg ();
+
+create trigger faq_sc__utrg after update on faq_q_and_as for each row execute procedure faq_sc__utrg ();
Index: openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql 11 Jul 2007 09:56:59 -0000 1.1.2.1
@@ -0,0 +1,10 @@
+--
+-- packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
+--
+-- @author Emmanuelle Raffenne (eraffenne@dia.uned.es)
+-- @creation-date 2007-07-11
+-- @arch-tag: 3f699cf4-3aa2-44d5-a116-594b0fd9fede
+-- @cvs-id $Id: upgrade-5.2.0d4-5.2.0d5.sql,v 1.1.2.1 2007/07/11 09:56:59 emmar Exp $
+--
+
+\i ../faq-sc-create.sql