- Table "Users" added to schema

- Default users 'admin' and 'guest' added to setup.sql
- Event priorities changed

diff --git a/sql/clear.sql b/sql/clear.sql
index 4c2176c..ac142a3 100644 (file)
--- a/sql/clear.sql
+++ b/sql/clear.sql
@@ -7,3 +7,4 @@ DELETE FROM Interfaces;
 DELETE FROM Subnets;
 DELETE FROM nsmap;
 DELETE FROM NewNodes;
+DELETE FROM EventLog;

diff --git a/sql/events.sql b/sql/events.sql
index 355a622..8565d75 100644 (file)
--- a/sql/events.sql
+++ b/sql/events.sql
@@ -67,7 +67,7 @@ INSERT INTO events (id,severity,flags,message,description) VALUES
        );
 INSERT INTO events (id,severity,flags,message,description) VALUES
        (
-               7, 0, 1,
+               7, 1, 1,
                'Node status changed to MINOR',
                'Generated when node status changed to "Minor Problem" (informational).\n'
                'Parameters:\n'
@@ -75,7 +75,7 @@ INSERT INTO events (id,severity,flags,message,description) VALUES
        );
 INSERT INTO events (id,severity,flags,message,description) VALUES
        (
-               8, 0, 1,
+               8, 2, 1,
                'Node status changed to WARNING',
                'Generated when node status changed to "Warning".\n'
                'Parameters:\n'
@@ -83,7 +83,7 @@ INSERT INTO events (id,severity,flags,message,description) VALUES
        );
 INSERT INTO events (id,severity,flags,message,description) VALUES
        (
-               9, 0, 1,
+               9, 3, 1,
                'Node status changed to MAJOR',
                'Generated when node status changed to "Major Problem".\n'
                'Parameters:\n'
@@ -91,7 +91,7 @@ INSERT INTO events (id,severity,flags,message,description) VALUES
        );
 INSERT INTO events (id,severity,flags,message,description) VALUES
        (
-               10, 0, 1,
+               10, 4, 1,
                'Node status changed to CRITICAL',
                'Generated when node status changed to critical.\n'
                'Parameters:\n'

diff --git a/sql/schema.sql b/sql/schema.sql
index 573b22e..b487da9 100644 (file)
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -10,6 +10,19 @@ CREATE TABLE Config
 );
 
 
+--
+-- Users
+--
+
+CREATE TABLE Users
+(
+       id integer not null,
+       name varchar(64) not null,
+       password varchar(64),
+       PRIMARY KEY(id)
+);
+
+
 --
 -- Nodes to be added
 --
@@ -170,9 +183,4 @@ CREATE TABLE ACTIONS
        command varchar(255),
        PRIMARY KEY(id)
 );
-
-
---
--- Node templates
---
        
\ No newline at end of file

diff --git a/sql/setup.sql b/sql/setup.sql
index 41f1407..66636f4 100644 (file)
--- a/sql/setup.sql
+++ b/sql/setup.sql
@@ -8,3 +8,11 @@ INSERT INTO config (name,value) VALUES ('DiscoveryPollingInterval','900');
 INSERT INTO config (name,value) VALUES ('StatusPollingInterval','30');
 INSERT INTO config (name,value) VALUES ('ResolveNodeNames','0');
 INSERT INTO config (name,value) VALUES ('NumberOfEventProcessors','1');
+
+
+--
+-- Default users
+--
+
+INSERT INTO users (id,name,password) VALUES (0,'admin','');
+INSERT INTO users (id,name,password) VALUES (1,'guest','');