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')