From d4dcd1bcb3122242b54f781c4a92aae1721e5a1e Mon Sep 17 00:00:00 2001 From: arjen Date: Sat, 17 Nov 2007 09:32:24 +0000 Subject: [PATCH] Minor fixes to make created and upgraded databases equal. Cleanup of database destruction script. --- src/database/create.sql | 33 +++++++++++++++++++-------------- src/database/destroy.sql | 18 ++++-------------- 2 files changed, 23 insertions(+), 28 deletions(-) diff --git a/src/database/create.sql b/src/database/create.sql index 1b62eea..d32de26 100644 --- 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 --- 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; -- 2.11.0