--*************************************************************************
--  (c) Copyright 2002, Andromeda Technology & Automation
-- This is free software; you can redistribute it and/or modify it under the
-- terms of the GNU General Public License, see the file COPYING.
--*************************************************************************/
--
-- Gnucomo database destruction script.
--
--
-- This SQL script drops all tables and sequences from the database
-- It is primarily used for testing, where we clean up after performing
-- a test.
--
--

DROP SEQUENCE "action_actionid_seq";

DROP TABLE "action";

DROP SEQUENCE "action_user_actionstepid_seq";

DROP TABLE "action_user";

DROP TABLE "db_value";

DROP TABLE "history";

DROP SEQUENCE "log_logid_seq";

DROP TABLE "log";

DROP TABLE log_abuse;

DROP TABLE "log_notification";

DROP SEQUENCE "notification_notificationid_seq";

DROP TABLE "notification";

DROP SEQUENCE checkid_seq;
    
DROP TABLE notification_check;

DROP TABLE notification_check_buffer;

DROP SEQUENCE checklineid_seq;
     
DROP TABLE notification_check_line;

DROP SEQUENCE "object_objectid_seq";

DROP TABLE "object";

DROP TABLE "object_abuse";

DROP TABLE "object_issue";

DROP TABLE "object_priority";

DROP TABLE "object_service";

DROP TABLE object_statistics;

DROP TABLE "object_user";

DROP SEQUENCE "paramid_seq";

DROP TABLE "parameter";

DROP TABLE "parameter_class";

DROP TABLE "parameter_notification";

DROP TABLE "priority";

DROP TABLE "property";

DROP TABLE "service";

DROP TABLE service_pattern;

DROP TABLE "status";
DROP TABLE supported_os;

DROP SEQUENCE "type_of_issue_type_of_issue_seq";

DROP TABLE "type_of_issue";

DROP TABLE "usr";

