-- Copyright (C) 2012, 2013 The Meme Factory, Inc.  http://www.meme.com/
--
--    This file is part of Gombe-MI.
--
--    Gombe-MI is free software; you can redistribute it and/or modify
--    it under the terms of the GNU General Public License as published by
--    the Free Software Foundation; either version 3 of the License, or
--    (at your option) any later version.
--
--    This program is distributed in the hope that it will be useful,
--    but WITHOUT ANY WARRANTY; without even the implied warranty of
--    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
--    GNU General Public License for more details.
--
--    You should have received a copy of the GNU General Public License
--    along with Gombe-MI.  If not, see <http://www.gnu.org/licenses/>.
--
-- Karl O. Pinc <kop@meme.com>

-- Remove all the data from all the tables.

-- Main tables

BEGIN;

DELETE FROM parts;
SELECT setval('parts_pid_seq'::regclass, 1, false);

DELETE FROM plays;
SELECT setval('plays_playid_seq'::regclass, 1, false);

DELETE FROM rides;
SELECT setval('rides_rideid_seq'::regclass, 1, false);

DELETE FROM rests;
SELECT setval('rests_restid_seq'::regclass, 1, false);

DELETE FROM eats;
SELECT setval('eats_eatid_seq'::regclass, 1, false);

DELETE FROM fished;
SELECT setval('fished_fishedid_seq'::regclass, 1, false);

DELETE FROM vocs;
SELECT setval('vocs_vocid_seq'::regclass, 1, false);

DELETE FROM events;
SELECT setval('events_eid_seq'::regclass, 1, false);

COMMIT;

BEGIN;

DELETE FROM distanceparts;
SELECT setval('distanceparts_dpid_seq'::regclass, 1, false);

DELETE FROM distances;
SELECT setval('distances_distid_seq'::regclass, 1, false);

COMMIT;

BEGIN;

DELETE FROM raw_groupmembers;
SELECT setval('raw_groupmembers_rgmid_seq'::regclass, 1, false);

DELETE FROM raw_groups;
SELECT setval('raw_groups_rgid_seq'::regclass, 1, false);

DELETE FROM groupmembers;
SELECT setval('groupmembers_gmid_seq'::regclass, 1, false);

DELETE FROM intervals;
SELECT setval('intervals_intid_seq'::regclass, 1, false);

DELETE FROM groups;
SELECT setval('groups_gid_seq'::regclass, 1, false);

DELETE FROM sheets;
SELECT setval('sheets_sheetid_seq'::regclass, 1, false);

SELECT setval('fieldfollows_ffid_seq'::regclass, 1, false);

DELETE FROM followparts;
SELECT setval('followparts_fpid_seq'::regclass, 1, false);

DELETE FROM follows;
SELECT setval('follows_followid_seq'::regclass, 1, false);

COMMIT;

DELETE FROM adoptions;
SELECT setval('adoptions_adoptid_seq'::regclass, 1, false);

DELETE FROM twins;
SELECT setval('twins_twinid_seq'::regclass, 1, false);

DELETE FROM community_membership;

BEGIN;
DELETE FROM chimpids;

DELETE FROM biography_data;
COMMIT;

-- Support tables.

DELETE FROM bddists;
DELETE FROM entrytypes;
DELETE FROM departtypes;
DELETE FROM followtypes;
DELETE FROM people;
DELETE FROM followroles;
DELETE FROM distancecodes;
DELETE FROM behaviors CASCADE;
DELETE FROM positions CASCADE;
DELETE FROM vocalizations CASCADE;
DELETE FROM foodparts CASCADE;
DELETE FROM foodkinds CASCADE;
DELETE FROM resting_postures CASCADE;
DELETE FROM riding_postures CASCADE;
DELETE FROM play_types CASCADE;
DELETE FROM fishing_results CASCADE;
DELETE FROM gcstatuses CASCADE;
DELETE FROM gm_origins CASCADE;


-- Warning system.

-- Main tables
DELETE FROM integrity_warnings;
SELECT setval('integrity_warnings_iwid_seq'::regclass, 1, false);

DELETE FROM integrity_queries;

-- Support tables
DELETE FROM iqtypes;
DELETE FROM warning_remarks;