1 --*************************************************************************
2 -- (c) Copyright 2002, Andromeda Technology & Automation
3 -- This is free software; you can redistribute it and/or modify it under the
4 -- terms of the GNU General Public License, see the file COPYING.
5 --*************************************************************************/
7 -- Gnucomo database destruction script.
10 -- This SQL script drops all tables and sequences from the database
11 -- It is primarily used for testing, where we clean up after performing
16 DROP SEQUENCE "action_actionid_seq";
20 DROP SEQUENCE "action_user_actionstepid_seq";
22 DROP TABLE "action_user";
24 DROP TABLE "db_value";
28 DROP SEQUENCE "log_logid_seq";
32 DROP SEQUENCE "log_advid_seq";
35 DROP TABLE log_adv_kernel_network;
36 DROP TABLE log_adv_daemon_email;
37 DROP TABLE log_adv_daemon;
40 DROP TABLE "log_notification";
42 DROP SEQUENCE "notification_notificationid_seq";
44 DROP TABLE "notification";
46 DROP SEQUENCE checkid_seq;
48 DROP TABLE notification_check;
50 DROP TABLE notification_check_buffer;
52 DROP SEQUENCE checklineid_seq;
54 DROP TABLE notification_check_line;
56 DROP SEQUENCE "object_objectid_seq";
60 DROP TABLE "object_abuse";
62 DROP TABLE "object_issue";
64 DROP TABLE "object_priority";
66 DROP TABLE "object_service";
68 DROP TABLE object_statistics;
70 DROP TABLE "object_system_user";
72 DROP TABLE "object_user";
74 DROP SEQUENCE "paramid_seq";
76 DROP TABLE "parameter";
78 DROP TABLE "parameter_class";
80 DROP TABLE "parameter_notification";
82 DROP TABLE "priority";
84 DROP TABLE "property";
88 DROP TABLE service_pattern
91 DROP TABLE supported_os;
93 DROP SEQUENCE "type_of_issue_type_of_issue_seq";
95 DROP TABLE "type_of_issue";
97 DROP SEQUENCE "unprocessed_l_unprocessedid_seq";
99 DROP TABLE "unprocessed_log";
101 DROP TABLE "user_gnucomo";