Minor fixes to make created and upgraded databases equal.

[gnucomo.git] / src / database / destroy.sql

diff --git a/src/database/destroy.sql b/src/database/destroy.sql
index d466a9f..98a9a59 100644 (file)
--- a/src/database/destroy.sql
+++ b/src/database/destroy.sql
@@ -29,13 +29,7 @@ DROP SEQUENCE "log_logid_seq";
 
 DROP TABLE "log";
 
-DROP SEQUENCE "log_advid_seq";
-
 DROP TABLE log_abuse;
-DROP TABLE log_adv_kernel_network;
-DROP TABLE log_adv_daemon_email;
-DROP TABLE log_adv_daemon;
-DROP TABLE "log_adv";
 
 DROP TABLE "log_notification";
 
@@ -67,8 +61,6 @@ DROP TABLE "object_service";
 
 DROP TABLE object_statistics;
 
-DROP TABLE "object_system_user";
-
 DROP TABLE "object_user";
 
 DROP SEQUENCE "paramid_seq";
@@ -85,7 +77,7 @@ DROP TABLE "property";
 
 DROP TABLE "service";
 
-DROP TABLE service_pattern
+DROP TABLE service_pattern;
 
 DROP TABLE "status";
 DROP TABLE supported_os;
@@ -94,10 +86,8 @@ DROP SEQUENCE "type_of_issue_type_of_issue_seq";
 
 DROP TABLE "type_of_issue";
 
-DROP SEQUENCE "unprocessed_l_unprocessedid_seq";
-
-DROP TABLE "unprocessed_log";
-
-DROP TABLE "user_gnucomo";
 DROP TABLE "usr";
 
+DROP GROUP view;
+DROP GROUP ops;
+DROP GROUP admin;