dnl Copyright (C) 2012, 2015 The Meme Factory, Inc. http://www.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 .
dnl
dnl Remove all functions from the database
dnl
dnl Karl O. Pinc
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')
include(`constants.m4')
--
-- Remove all functions from the database so
-- we can re-create it with our creation scripts.
--
--
-- Functions
--
--
-- General purpose
--
-- DROP FUNCTION FOO();
DROP FUNCTION infer_gc(DATE, VARCHAR(gmi_animid_len));
DROP FUNCTION infer_gc(INT);
DROP FUNCTION delete_gc(DATE, VARCHAR(gmi_animid_len));
DROP FUNCTION delete_gc(INT);
DROP FUNCTION followfunc(INT, VARCHAR(gmi_animid_len));
DROP FUNCTION followrole(INT, VARCHAR(gmi_animid_len));
DROP FUNCTION mom_in_gc(VARCHAR(gmi_animid_len), BIGINT, DATE);
DROP FUNCTION infants_in_gc(VARCHAR(gmi_animid_len), BIGINT, DATE);
DROP FUNCTION add_social_partners(VARCHAR(gmi_animid_len), BIGINT);
-- The warning system
include(`destroywarningfunctions.m4')