Index: openacs-4/packages/dotlrn-expense-tracking/sql/postgresql/dotlrn-expense-tracking-admin-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-expense-tracking/sql/postgresql/dotlrn-expense-tracking-admin-portlet-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-expense-tracking/sql/postgresql/dotlrn-expense-tracking-admin-portlet-drop.sql	24 Jun 2005 09:57:55 -0000	1.1
@@ -0,0 +1,86 @@
+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 = ''dotlrn_expense_tracking_admin_portlet'';
+
+    if not found then
+        raise exception ''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 ();
+
+-- create the implementation
+select acs_sc_impl__delete (
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet'
+);
+
+-- add all the hooks
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'GetMyName'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'GetPrettyName'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'Link'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'AddSelfToPage'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'Show'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'Edit'
+);
+
+select acs_sc_impl_alias__delete(
+        'portal_datasource',
+        'dotlrn_expense_tracking_admin_portlet',
+        'RemoveSelfFromPage'
+);
+
+-- Add the binding
+select acs_sc_binding__delete(
+	'portal_datasource',
+ 	'dotlrn_expense_tracking_admin_portlet'
+);
+
+
+
+