Index: openacs-4/packages/edit-this-page-portlet/sql/postgresql/edit-this-page-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page-portlet/sql/postgresql/edit-this-page-portlet-drop.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page-portlet/sql/postgresql/edit-this-page-portlet-drop.sql	22 Nov 2004 13:47:47 -0000	1.1.2.1
@@ -0,0 +1,108 @@
+--
+--  Copyright (C) 2001, 2002 MIT
+--
+--  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.
+--
+
+-- Drops edit-this-page portlet
+-- @author Stefan Wurdack (dotlrn@email.wuon.de)
+
+create function inline_0 ()
+returns integer as '
+declare  
+  ds_id portal_datasources.datasource_id%TYPE;
+begin
+
+  select datasource_id into ds_id
+    from portal_datasources
+    where name = ''edit-this-page_portlet'';
+
+--  Exception handling?
+
+
+    if not found then
+        raise notice ''No datasource_id found here '', ds_id ;
+	ds_id := null;        
+    end if;
+
+      
+  if ds_id is NOT null then
+    perform portal_datasource__delete(ds_id);
+  end if;
+
+return 0;
+
+end;' language 'plpgsql';
+
+select inline_0 ();
+
+drop function inline_0 ();
+
+
+-- drop the hooks
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'GetMyName'
+);
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'GetPrettyName'
+	);
+
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'Link'
+);
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'AddSelfToPage'
+);
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'Show'
+);
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'Edit'
+);
+
+select acs_sc_impl_alias__delete (
+	       'portal_datasource',
+	       'edit-this-page_portlet',
+	       'RemoveSelfFromPage'
+);
+
+-- Drop the binding
+select acs_sc_binding__delete (
+	'portal_datasource',
+	'edit-this-page_portlet'
+);
+
+-- drop the impl
+select acs_sc_impl__delete (
+		'portal_datasource',
+		'edit-this-page_portlet'
+);
+
+\i edit-this-page-admin-portlet-drop.sql