Database schema changed - added primary key to EVENTS table

diff --git a/sql/schema.sql b/sql/schema.sql
index 4dfa74a..0cb12e4 100644 (file)
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -132,13 +132,14 @@ create table IDATA
 -- Events configuration
 --
 
-create table EVENTS
+CREATE TABLE Events
 (
        id integer not null,
        severity integer,
        message varchar(255),           -- Message template
        retention_time integer,
-       description blob
+       description blob,
+       PRIMARY KEY(id)
 );