-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.11 2003-02-16 08:24:38 arjen
+-- Revision 1.12 2003-02-21 08:38:38 arjen
+-- Added new table to the database: log_adv_daemon_email.
+--
+-- 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
COPY "db_value" FROM stdin;
-db_version 31
+db_version 32
gcm_daemon_version 1
log_processing 0
last_notification 0
CREATE TABLE log_adv_daemon
(
service TEXT,
- event TEXT
+ event TEXT
) INHERITS (log_adv);
CREATE INDEX log_adv_daemon_service ON log_adv_daemon (service);
+CREATE TABLE log_adv_daemon_email
+(
+ source_ip INET,
+ destination_ip INET,
+ internal_messageid TEXT,
+ external_messageid TEXT,
+ to_email TEXT,
+ from_email TEXT,
+ delay TIME,
+ xdelay TIME,
+ mailer TEXT,
+ status TEXT,
+ pid INT
+) INHERITS (log_adv_daemon);
+
/*
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER '';
CREATE FUNCTION "funct_processlog" () RETURNS opaque AS '
DROP SEQUENCE "log_advid_seq";
DROP TABLE log_adv_kernel_network;
+DROP TABLE log_adv_daemon_email;
DROP TABLE log_adv_daemon;
DROP TABLE "log_adv";
. "'The notification has been presented in a list with other notifications.')";
$dbms->query ($local_sql);
-
+case 31:
+ $local_sql = "CREATE TABLE log_adv_daemon_email (";
+ $local_sql .= "source_ip INET, destination_ip INET, internal_messageid TEXT, ";
+ $local_sql .= "external_messageid TEXT, to_email TEXT, from_email TEXT, delay TIME, xdelay TIME, ";
+ $local_sql .= "mailer TEXT, status TEXT, pid INT";
+ $local_sql .= ") INHERITS (log_adv_daemon)";
+ $dbms->query($local_sql);
-/*
- //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
+//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";
$dbms->query($local_sql);
First : November 8th 2002
Gnucomo-0.0.3: December 6th 2002
+ $Log: gcm_daemon.php,v $
+ Revision 1.9 2003-02-21 08:37:59 arjen
+ Added new table to the database: log_adv_daemon_email.
+
+
*/
-// $Id: gcm_daemon.php,v 1.8 2003-02-16 08:24:06 arjen Exp $
+// $Id: gcm_daemon.php,v 1.9 2003-02-21 08:37:59 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 = 31; //The db_version indicates what the level of
+$db_version = 32; //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,