-- /packages/news/sql/news-sc-drop.sql
--
-- @author Robert Locke (rlocke@infiniteinfo.com)
-- @created 2001-10-23
-- @cvs-id $Id: forums-sc-drop.sql,v 1.2 2003/08/28 09:41:54 lars Exp $
--
-- Removes search support from news module.
--

select acs_sc_impl__delete(
	   'FtsContentProvider',		-- impl_contract_name
           'forums_message'				-- impl_name
);



drop trigger forums_message_search__itrg on forums_messages;
drop trigger forums_message_search__dtrg on forums_messages;
drop trigger forums_message_search__utrg on forums_messages;

drop function forums_message_search__itrg ();
drop function forums_message_search__dtrg ();
drop function forums_message_search__utrg ();