Database schema changed - added primary key to EVENTS table
authorVictor Kirhenshtein <victor@netxms.org>
Thu, 23 Oct 2003 11:41:08 +0000 (11:41 +0000)
committerVictor Kirhenshtein <victor@netxms.org>
Thu, 23 Oct 2003 11:41:08 +0000 (11:41 +0000)
sql/schema.sql

index 4dfa74a..0cb12e4 100644 (file)
@@ -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)
 );