Minor fixes to make created and upgraded databases equal.

Cleanup of database destruction script.

diff --git a/src/database/create.sql b/src/database/create.sql
index 1b62eea..d32de26 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,11 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
---  Revision 1.22  2007-11-03 10:30:10  arjen
+--  Revision 1.23  2007-11-17 09:32:24  arjen
+--  Minor fixes to make created and upgraded databases equal.
+--  Cleanup of database destruction script.
+--
+--  Revision 1.22  2007/11/03 10:30:10  arjen
 --  Added the class definition for a filesystem parameter.
 --  New issue type: 'property out of range'.
 --
@@ -172,9 +176,10 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
-db_version     48
+db_version     53
 gcm_daemon_version     5
 log_processing 0
+log_servicecheck       0
 last_notification      0
 \.
 
@@ -719,18 +724,18 @@ CREATE TABLE "type_of_issue"
 
 
 COPY "type_of_issue" FROM stdin;
-1      manual entry    4       A manual entry of a notification        t       t       1       \N      \N
-2      parameter created       3       A new parameter was created     t       t       1       \N      \N
-3      property modified       3       The STATIC property of a parameter was modified t       t       1       \N      \N
-4      parameter removed       3       A parameter was removed t       t       1       \N      \N
-5      service unknown 5       Service in log entry is unknown t       t       1       \N      \N
-6      service not used        5       Service in log entry is not used        t       t       1       \N      \N
-7      abuses exceeded 5       Abuse treshold exceeded from an IP address      t       t       1       \N      \N
-8      unmatched log   5       Log entries could not be matched        t       t       1       \N      \N
-9      Error detected  5       An Error is reported in the log t       t       1       \N      \N
-10     Failure detected        5       A Failure is reported in the log        t       t       1       \N      \N
-11     Warning detected        3       A Warning is reported in the log        t       t       1       \N      \N
-12     property out of range   5       The DYNAMIC property of a parameter is out of range     t       t       1       \N      \N
+1      manual entry    4       A manual entry of a notification        t       \N      \N      \N      \N
+2      parameter created       3       A new parameter was created     t       \N      \N      \N      \N
+3      property modified       3       The STATIC property of a parameter was modified t       \N      \N      \N      \N
+4      parameter removed       3       A parameter was removed t       \N      \N      \N      \N
+5      service unknown 5       Service in log entry is unknown t       \N      \N      \N      \N
+6      service not used        5       Service in log entry is not used        t       \N      \N      \N      \N
+7      abuses exceeded 5       Abuse treshold exceeded from an IP address      t       \N      \N      \N      \N
+8      unmatched log   5       Log entries could not be matched        t       \N      \N      \N      \N
+9      Error detected  5       An Error is reported in the log t       \N      \N      \N      \N
+10     Failure detected        5       A Failure is reported in the log        t       \N      \N      \N      \N
+11     Warning detected        3       A Warning is reported in the log        t       \N      \N      \N      \N
+12     property out of range   5       The DYNAMIC property of a parameter is out of range     t       \N      \N      \N      \N
 \.
 
 CREATE UNIQUE INDEX type_of_issue_type_of_issue_key ON type_of_issue USING btree (type_of_issueid);

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;