Index: openacs-4/packages/new-portal/sql/oracle/datasource-sc-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/datasource-sc-drop.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/new-portal/sql/oracle/datasource-sc-drop.sql 9 May 2002 04:04:05 -0000 1.6 +++ openacs-4/packages/new-portal/sql/oracle/datasource-sc-drop.sql 9 May 2002 23:59:53 -0000 1.7 @@ -247,69 +247,6 @@ ); - -- rem MakeSelfAvailable - op_id := acs_sc_operation.get_id ( - contract_name => 'portal_datasource', - operation_name => 'MakeSelfAvailable' - ); - - acs_sc_operation.delete ( - operation_id => op_id, - contract_name => 'portal_datasource', - operation_name => 'MakeSelfAvailable' - ); - - - msg_type_id := acs_sc_msg_type.get_id ( - msg_type_name => 'portal_datasource.MakeSelfAvailable.InputType' - ); - - acs_sc_msg_type.delete ( - msg_type_name => 'portal_datasource.MakeSelfAvailable.InputType', - msg_type_id => msg_type_id - ); - - msg_type_id := acs_sc_msg_type.get_id ( - msg_type_name => 'portal_datasource.MakeSelfAvailable.OutputType' - ); - - acs_sc_msg_type.delete ( - msg_type_name => 'portal_datasource.MakeSelfAvailable.OutputType', - msg_type_id => msg_type_id - ); - - - -- rem MakeSelfUnavailable - op_id := acs_sc_operation.get_id ( - contract_name => 'portal_datasource', - operation_name => 'MakeSelfUnavailable' - ); - - acs_sc_operation.delete ( - operation_id => op_id, - contract_name => 'portal_datasource', - operation_name => 'MakeSelfUnavailable' - ); - - msg_type_id := acs_sc_msg_type.get_id ( - msg_type_name => 'portal_datasource.MakeSelfUnavailable.InputType' - ); - - acs_sc_msg_type.delete ( - msg_type_name => 'portal_datasource.MakeSelfUnavailable.InputType', - msg_type_id => msg_type_id - ); - - msg_type_id := acs_sc_msg_type.get_id ( - msg_type_name => 'portal_datasource.MakeSelfUnavailable.OutputType' - ); - - acs_sc_msg_type.delete ( - msg_type_name => 'portal_datasource.MakeSelfUnavailable.OutputType', - msg_type_id => msg_type_id - ); - - -- drop the contract contract_id := acs_sc_contract.get_id ('portal_datasource'); acs_sc_contract.delete (