-- pg_isok  A query centered monitoring tool for PostgreSQL
-- Copyright (C) 2015, 2025 The Meme Factory, Inc.  http://www.karlpinc.com/
--
--  This program is free software: you can redistribute it and/or modify
--  it under the terms of the GNU Affero 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 Affero General Public License for more details.
--
--  You should have received a copy of the GNU Affero General Public License
--  along with this program.  If not, see <https://www.gnu.org/licenses/>.
--
-- Karl O. Pinc <kop@karlpinc.com>

-- Remove Isok tables from the database so we can
-- re-create the db with our creation scripts.  Removes Isok
-- manually created sequences as well.
-- (Removing the tables also destroys views and rules
-- via CASCADE.)

--
-- Main tables
--

DROP TABLE isok_results CASCADE;
DROP TABLE isok_queries CASCADE;

--
-- Support Tables
--

DROP TABLE ir_types CASCADE;
DROP TABLE iq_types CASCADE;