Minor fixes to make created and upgraded databases equal.

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

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);