Do not remove roles in the database.
[gnucomo.git] / src / database / destroy.sql
index 5820798..17d06a8 100644 (file)
@@ -29,10 +29,7 @@ DROP SEQUENCE "log_logid_seq";
 
 DROP TABLE "log";
 
-DROP SEQUENCE "log_advid_seq";
-
-DROP TABLE log_adv_kernel_network;
-DROP TABLE "log_adv";
+DROP TABLE log_abuse;
 
 DROP TABLE "log_notification";
 
@@ -40,17 +37,29 @@ 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_system_user";
+DROP TABLE object_statistics;
 
 DROP TABLE "object_user";
 
@@ -58,12 +67,18 @@ 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;
 
@@ -71,10 +86,5 @@ 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";