Added log, notification and parameter counters to the 'object' table.

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

diff --git a/src/database/create.sql b/src/database/create.sql
index 38fa870..b2105ae 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,13 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
---  Revision 1.8  2003-02-08 07:36:41  arjen
+--  Revision 1.9  2003-02-13 08:46:54  arjen
+--  Added log, notification and parameter counters to the 'object' table.
+--  Counting these things at the time a user interface needs them is
+--  too slow. Other programs, like gcm_daemon en gcm_input should prepare
+--  these counters for quick retrieval.
+--
+--  Revision 1.8  2003/02/08 07:36:41  arjen
 --  Added new table to the database : log_adv_daemon
 --
 --  Revision 1.7  2003/02/05 09:29:08  arjen
@@ -112,9 +118,10 @@ CREATE TABLE "db_value"
 
 
 COPY "db_value" FROM stdin;
-db_version     21
+db_version     28
 gcm_daemon_version     1
 log_processing 0
+last_notification      0
 \.
 
 --
@@ -324,7 +331,10 @@ CREATE TABLE "object"
        "timezone" text,
        "remark" text,
         "os"     text,
-        "os_version"   text
+        "os_version"   text,
+        "log_count"    bigint,
+        "notification_count"   bigint,
+        "parameter_count"      bigint
 );
 
 CREATE UNIQUE INDEX object_objectid_key ON object USING btree (objectid);
@@ -588,7 +598,7 @@ CREATE TABLE "type_of_issue"
 COPY "type_of_issue" FROM stdin;
 1      manual entry    4       A manual entry of a notification        t
 2      parameter created       3       A new parameter was created     t
-3      property modified       3       The STATIC property of a parameter was modified t
+3      property modified       3       The STATIC property of a parameter was modified t
 4      parameter removed       3       A parameter was removed t
 \.