Index: openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-create.sql	10 Jul 2002 16:56:04 -0000	1.1
@@ -0,0 +1,157 @@
+--
+--  Copyright (C) 2001, 2002 OpenForce, Inc.
+--
+--  This file is part of dotLRN.
+--
+--  dotLRN is free software; you can redistribute it and/or modify it under the
+--  terms of the GNU General Public License as published by the Free Software
+--  Foundation; either version 2 of the License, or (at your option) any later
+--  version.
+--
+--  dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY
+--  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+--  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
+--  details.
+--
+
+
+--
+-- The faq applet for dotLRN
+-- copyright 2001, OpenForce
+-- distributed under GPL v2.0
+--
+--
+-- ben,arjun@openforce.net
+--
+-- 10/05/2001
+--
+-- Postgresql port adarsh@symphinity.com
+--  
+-- 10th July 2002
+--
+
+
+-- create the implementation
+
+select acs_sc_impl__new (
+		'dotlrn_applet',
+		'dotlrn_faq',
+		'dotlrn_faq'
+);
+
+
+-- add all the hooks
+
+-- GetPrettyName
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'GetPrettyName',
+	       'dotlrn_faq::get_pretty_name',
+	       'TCL'
+);
+
+-- AddApplet
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddApplet',
+	       'dotlrn_faq::add_applet',
+	       'TCL'
+);
+
+-- RemoveApplet
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveApplet',
+	       'dotlrn_faq::remove_applet',
+	       'TCL'
+);
+
+-- AddAppletToCommunity
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddAppletToCommunity',
+	       'dotlrn_faq::add_applet_to_community',
+	       'TCL'
+);
+
+-- RemoveAppletFromCommunity
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveAppletFromCommunity',
+	       'dotlrn_faq::remove_applet_from_community',
+	       'TCL'
+);
+
+-- AddUser
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddUser',
+	       'dotlrn_faq::add_user',
+	       'TCL'
+);
+
+-- RemoveUser
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveUser',
+	       'dotlrn_faq::remove_user',
+	       'TCL'
+);
+
+-- AddUserToCommunity
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddUserToCommunity',
+	       'dotlrn_faq::add_user_to_community',
+	       'TCL'
+);
+
+-- RemoveUserFromCommunity
+select acs_sc_impl_alias__new (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveUserFromCommunity',
+	       'dotlrn_faq::remove_user_from_community',
+	       'TCL'
+);
+
+-- AddPortlet
+select acs_sc_impl_alias__new (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'AddPortlet',
+        'dotlrn_faq::add_portlet',
+        'TCL'
+);
+
+-- RemovePortlet
+select acs_sc_impl_alias__new (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'RemovePortlet',
+        'dotlrn_faq::remove_portlet',
+        'TCL'
+);
+
+-- Clone
+select acs_sc_impl_alias__new (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'Clone',
+        'dotlrn_faq::clone',
+        'TCL'
+);
+
+-- Add the binding
+select acs_sc_binding__new (
+	    'dotlrn_applet',
+	    'dotlrn_faq'
+);
Index: openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-faq/sql/postgresql/dotlrn-faq-drop.sql	10 Jul 2002 16:56:04 -0000	1.1
@@ -0,0 +1,132 @@
+--
+--  Copyright (C) 2001, 2002 OpenForce, Inc.
+--
+--  This file is part of dotLRN.
+--
+--  dotLRN is free software; you can redistribute it and/or modify it under the
+--  terms of the GNU General Public License as published by the Free Software
+--  Foundation; either version 2 of the License, or (at your option) any later
+--  version.
+--
+--  dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY
+--  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+--  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
+--  details.
+--
+
+
+--
+-- The faq applet for dotLRN
+-- copyright 2001, OpenForce
+-- distributed under GPL v2.0
+--
+--
+-- ben,arjun@openforce.net
+--
+-- 10/05/2001
+--
+-- Postgresql port adarsh@symphinity.com
+--  
+-- 10th July 2002
+--
+
+
+-- delete the implementation
+
+select acs_sc_impl__delete (
+		'dotlrn_applet',
+		'dotlrn_faq'
+);
+
+
+
+
+-- GetPrettyName
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'GetPrettyName'
+);
+
+-- AddApplet
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddApplet'
+);
+
+-- RemoveApplet
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveApplet'
+);
+
+-- AddAppletToCommunity
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddAppletToCommunity'
+);
+
+-- RemoveAppletFromCommunity
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveAppletFromCommunity'
+);
+
+-- AddUser
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddUser'
+);
+
+-- RemoveUser
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveUser'
+);
+
+-- AddUserToCommunity
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'AddUserToCommunity'
+);
+
+-- RemoveUserFromCommunity
+select acs_sc_impl_alias__delete (
+	       'dotlrn_applet',
+	       'dotlrn_faq',
+	       'RemoveUserFromCommunity'
+);
+
+-- AddPortlet
+select acs_sc_impl_alias__delete (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'AddPortlet'
+);
+
+-- RemovePortlet
+select acs_sc_impl_alias__delete (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'RemovePortlet'
+);
+
+-- Clone
+select acs_sc_impl_alias__delete (
+        'dotlrn_applet',
+        'dotlrn_faq',
+        'Clone'
+);
+
+-- Add the binding
+select acs_sc_binding__delete (
+	    'dotlrn_applet',
+	    'dotlrn_faq'
+);