-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.10 2003-02-14 06:32:27 arjen
+-- Revision 1.11 2003-02-16 08:24:38 arjen
+-- Added a new entry to the action table: Notification was displayed in the listing
+--
+-- Revision 1.10 2003/02/14 06:32:27 arjen
-- Setup the groups and database permissions. The three groups
-- are: view, ops and admin.
-- Added a new entry to the action table.
18 Notification closed cls The notification has been closed.
19 Notification reopend opn The notification has been reopend.
20 Redisplayed to user \N The notification has been presented to a user. This is not the first time
+21 Displayed in list \N The notification has been presented in a list with other notifications.
\.
CREATE UNIQUE INDEX action_actionid_key ON "action" USING btree (actionid);
COPY "db_value" FROM stdin;
-db_version 28
+db_version 31
gcm_daemon_version 1
log_processing 0
last_notification 0
case 29:
$local_sql = "INSERT INTO action (actionname, description) VALUES ('Redisplayed to user', "
. "'The notification has been presented to a user. This is not the first time')";
- echo $local_sql;
$dbms->query ($local_sql);
+case 30:
+ $local_sql = "INSERT INTO action (actionname, description) VALUES ('Displayed in list', "
+ . "'The notification has been presented in a list with other notifications.')";
+ $dbms->query ($local_sql);
+
+
+
/*
//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
$local_sql = "ALTER TABLE log DROP COLUMN recognized";
*/
-// $Id: gcm_daemon.php,v 1.7 2003-02-14 06:35:09 arjen Exp $
+// $Id: gcm_daemon.php,v 1.8 2003-02-16 08:24:06 arjen Exp $
ini_set('include_path', '.:./classes:../phpclasses');
$project_name = "gnucomo"; //name of the entire project
$app_name = "gcm_daemon"; //name of the application running
$developrelease = "TRUE"; //Indicates if special debug settings are needed
-$db_version = 30; //The db_version indicates what the level of
+$db_version = 31; //The db_version indicates what the level of
//the database should be. If the database is
//old an update will be generated.
$gcmd_version = 3; //This value indicates the active version of the gcm_daemon,