--
-- packages/chat/sql/chat-drop.sql
--
-- @author ddao@arsdigita.com
-- @creation-date November 09, 2000
-- @cvs-id $Id: chat-drop.sql,v 1.3 2007/06/07 09:14:24 pablom Exp $
--

      --drop objects

create function inline_0()
returns integer as '
declare
	object_rec		record;
begin

        for object_rec in select object_id from acs_objects where object_type=''chat_transcript''
	loop
		PERFORM acs_object__delete( object_rec.object_id );
	end loop;

	for object_rec in select object_id from acs_objects where object_type=''chat_room''
	loop
		PERFORM acs_object__delete( object_rec.object_id );
	end loop;


  return 0;
end;' language 'plpgsql';

select inline_0 ();
drop function inline_0 ();


--
-- Drop chat_room object type
--




select acs_object_type__drop_type('chat_room','t');
select acs_object_type__drop_type('chat_transcript','t');

drop   function chat_transcript__new (varchar, varchar, varchar, integer, integer, timestamptz, integer,  varchar, varchar);
drop   function chat_transcript__del (integer);
drop   function chat_transcript__edit (integer, varchar, varchar, varchar );

drop   function chat_room__new (varchar, varchar, varchar, varchar, integer, timestamp, boolean, boolean, boolean, boolean, boolean, integer, integer, integer, varchar, varchar, varchar);
drop   function chat_room__name (integer);

drop   function chat_room__message_post (integer, varchar, integer, varchar);

drop   function chat_room__delete_registered_users (integer, integer);
drop   funciton chat_room_registered__user (varchar, integer, integer, boolean, boolean, integer, varchar);

drop   function chat_room__edit (varchar, varchar, varchar, varchar, integer, timestamp, boolean, boolean, boolean, boolean, boolean, integer, integer, varchar);
drop   function chat_room__message_count (integer);
drop   function chat_room__delete_all_msgs (integer);

drop function chat_room__insert_keywords (varchar, integer);

drop function chat_room__send_files (integer, varchar, varchar, varchar, date, integer, integer, varchar);
drop function chat_room__send_files_message (integer)

drop function chat_rss__store_db (varchar, varchar, date, varchar, varchar, varchar, timestamp);
drop function chat_update_rss ();
drop function chat_upload ();

drop function chat_room__private_new (varchar, varchar, varchar, varchar, integer, timestamp, boolean, boolean, boolean, boolean, boolean, integer, integer, integer, varchar, varchar, boolean);
drop   function chat_room__del (integer);

drop function chat_room__edit_admin (varchar, boolean, boolean, integer, integer, varchar, integer);
drop function chat_room__store_transcripts_keywords (varchar, integer);
drop function chat_rss__store_keywords_rss (integer, varchar);
drop function chat_rss__store_partitipants_rss (integer, varchar);
drop function chat_rss__store_sent_files_rss (integer, integer);
drop function chat_rss__store_transcripts_rss (integer, integer);
drop function chat_transcript__store_partitipants_transcript (integer, varchar);
drop function chat_transcript__store_sent_files_tanscript (integer, integer);


drop table chat_msgs;
drop table chat_registered_users;
drop table chat_file_transcript;
drop table chat_files_rss;
drop table chat_key_rss;
drop table chat_partitipants_rss;
drop table chat_partitipants_transcript;
drop table chat_room_transcript_keywords;
drop table chat_transcription_rss;
drop table chat_transcripts;
drop table chat_keywords;
drop table chat_private_room_users;
drop table chat_room_user_id;
drop table chat_rooms_files_sent;
drop table chat_rss;
drop table chat_rooms;



--
-- Drop all chat privileges
--

create function inline_0 ()
returns integer as '
begin

  -- Drop child privileges for regular chat user.
 PERFORM acs_privilege__remove_child(''chat_user'', ''chat_read'');
 PERFORM acs_privilege__remove_child(''chat_user'', ''chat_write'');

 -- Drop child privileges for chat moderator.
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_room_moderate'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_user_ban'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_user_unban'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_user_grant'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_user_revoke'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_transcript_create'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_transcript_view'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_transcript_edit'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_transcript_delete'');
 PERFORM acs_privilege__remove_child(''chat_moderator'', ''chat_user'');

  -- Drop child privileges for chat administrator.
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_room_create'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_room_delete'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_room_edit'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_room_view'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_moderator_grant'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_moderator_revoke'');
 PERFORM acs_privilege__remove_child(''chat_room_admin'', ''chat_moderator'');

 -- remove Site wite admin also administrator of the chat room
 PERFORM acs_privilege__remove_child(''admin'', ''chat_room_admin'');



 PERFORM acs_privilege__drop_privilege(''chat_room_create'');
 PERFORM acs_privilege__drop_privilege(''chat_room_view'');
 PERFORM acs_privilege__drop_privilege(''chat_room_edit'');
 PERFORM acs_privilege__drop_privilege(''chat_room_delete'');
 PERFORM acs_privilege__drop_privilege(''chat_transcript_create'');
 PERFORM acs_privilege__drop_privilege(''chat_transcript_view'');
 PERFORM acs_privilege__drop_privilege(''chat_transcript_edit'');
 PERFORM acs_privilege__drop_privilege(''chat_transcript_delete'');
 PERFORM acs_privilege__drop_privilege(''chat_room_moderate'');
 PERFORM acs_privilege__drop_privilege(''chat_moderator_grant'');
 PERFORM acs_privilege__drop_privilege(''chat_moderator_revoke'');
 PERFORM acs_privilege__drop_privilege(''chat_user_grant'');
 PERFORM acs_privilege__drop_privilege(''chat_user_revoke'');
 PERFORM acs_privilege__drop_privilege(''chat_user_ban'');
 PERFORM acs_privilege__drop_privilege(''chat_user_unban'');
 PERFORM acs_privilege__drop_privilege(''chat_ban'');
 PERFORM acs_privilege__drop_privilege(''chat_read'');
 PERFORM acs_privilege__drop_privilege(''chat_write'');
 PERFORM acs_privilege__drop_privilege(''chat_room_admin'');
 PERFORM acs_privilege__drop_privilege(''chat_moderator'');
 PERFORM acs_privilege__drop_privilege(''chat_user'');


  return 0;
end;' language 'plpgsql';

select inline_0 ();
drop function inline_0 ();