From: arjen Date: Tue, 23 Oct 2007 11:25:42 +0000 (+0000) Subject: Fixed the Failure and warning issues. X-Git-Tag: V_0_0_10~3 X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=bf698f05e1300ee9fa5864ec92fd4d8ebba2853b Fixed the Failure and warning issues. --- diff --git a/src/database/create.sql b/src/database/create.sql index a17028a..500c79b 100644 --- a/src/database/create.sql +++ b/src/database/create.sql @@ -12,7 +12,10 @@ -- DBA create the database and give access permissions. -- -- $Log: create.sql,v $ --- Revision 1.20 2007-01-11 13:47:35 arjen +-- Revision 1.21 2007-10-23 11:25:42 arjen +-- Fixed the Failure and warning issues. +-- +-- Revision 1.20 2007/01/11 13:47:35 arjen -- Log_adv and derived tables removed. -- Create notifications from log entries with pattern matching. -- @@ -706,8 +709,8 @@ COPY "type_of_issue" FROM stdin; 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 -9 Failure detected 5 A Failure is reported in the log t t 1 \N \N -10 Warning detected 3 A Warning 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 \. CREATE UNIQUE INDEX type_of_issue_type_of_issue_key ON type_of_issue USING btree (type_of_issueid); @@ -716,7 +719,7 @@ CREATE UNIQUE INDEX toi_name ON type_of_issue USING btree (name); CREATE INDEX toi_active ON type_of_issue USING btree (active); -SELECT setval ('"type_of_issue_type_of_issue_seq"', 6, true); +SELECT setval ('"type_of_issue_type_of_issue_seq"', 11, true); -- --