dnl Copyright (C) 2012, 2013 The Meme Factory, Inc.  http://www.meme.com/
dnl Copyright (C) 2005, 2008, Karl O. Pinc <kop@meme.com>
dnl
dnl    This file is part of Gombe-MI.
dnl
dnl    Gombe-MI is free software; you can redistribute it and/or modify
dnl    it under the terms of the GNU General Public License as published by
dnl    the Free Software Foundation; either version 3 of the License, or
dnl    (at your option) any later version.
dnl
dnl    This program is distributed in the hope that it will be useful,
dnl    but WITHOUT ANY WARRANTY; without even the implied warranty of
dnl    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
dnl    GNU General Public License for more details.
dnl
dnl    You should have received a copy of the GNU General Public License
dnl    along with Gombe-MI.  If not, see <http://www.gnu.org/licenses/>.
dnl
dnl Remove all functions supporting view rules from the database
dnl
dnl Karl O. Pinc <kop@meme.com>
dnl
dnl Bugs:
dnl  The abstraction of the datatypes that uses column names does not
dnl really work.  Combinations of errors and changing table definition
dnl can leave an old function lying around.
dnl
dnl m4 includes
include(`copyright.m4')
include(`types.m4')

--
-- Remove all functions from the database that support views so
-- we can re-create them with our creation scripts.
--

--
-- Functions
--

DROP FUNCTION _error_immutable_view() CASCADE;
DROP FUNCTION _raise_gombemi_exception(TEXT) CASCADE;

--
-- Triggers
--
DROP FUNCTION community_membership_upload_insert_func() CASCADE;
DROP FUNCTION community_membership_upload_update_func() CASCADE;
DROP FUNCTION community_membership_upload_delete_func() CASCADE;

DROP FUNCTION biography_insert_func() CASCADE;
DROP FUNCTION biography_update_func() CASCADE;
DROP FUNCTION biography_delete_func() CASCADE;

DROP FUNCTION biography_upload_insert_func() CASCADE;
DROP FUNCTION biography_upload_update_func() CASCADE;
DROP FUNCTION biography_upload_delete_func() CASCADE;

DROP FUNCTION upload_behaviors_insert_func() CASCADE;

DROP FUNCTION focal_follows_insert_func() CASCADE;
DROP FUNCTION focal_follows_update_func() CASCADE;
DROP FUNCTION focal_follows_delete_func() CASCADE;

DROP FUNCTION follow_intervals_insert_func() CASCADE;
DROP FUNCTION follow_intervals_update_func() CASCADE;
DROP FUNCTION follow_intervals_delete_func() CASCADE;

DROP FUNCTION family_events_insert_func() CASCADE;
DROP FUNCTION family_events_update_func() CASCADE;
DROP FUNCTION family_events_delete_func() CASCADE;

DROP FUNCTION datasheet_events_insert_func() CASCADE;
DROP FUNCTION datasheet_events_update_func() CASCADE;
DROP FUNCTION datasheet_events_delete_func() CASCADE;

DROP FUNCTION family_dists_insert_func() CASCADE;
DROP FUNCTION family_dists_update_func() CASCADE;
DROP FUNCTION family_dists_delete_func() CASCADE;

DROP FUNCTION _error_immutable(TEXT) CASCADE;