New columns in the table 'log_adv_daemon_email': size, pri, relay,

[gnucomo.git] / src / gcm_daemon / classes / gnucomo_db_version.php

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index 9908b81..f28e62c 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -295,6 +295,42 @@ case 31:
      $local_sql .= ") INHERITS (log_adv_daemon)";
      $dbms->query($local_sql);
 
+case 32:
+     $local_sql = "CREATE INDEX log_adv_daemon_email_s_ip ON log_adv_daemon_email (source_ip)";
+     $dbms->query($local_sql);
+
+     $local_sql = "CREATE INDEX log_adv_daemon_email_d_ip ON log_adv_daemon_email (destination_ip)";
+     $dbms->query($local_sql);
+
+     $local_sql = "CREATE INDEX log_adv_daemon_email_to   ON log_adv_daemon_email (to_email)";
+     $dbms->query($local_sql);
+
+     $local_sql = "CREATE INDEX log_adv_daemon_email_from ON log_adv_daemon_email (from_email)";
+     $dbms->query($local_sql);
+
+
+case 33:
+     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN size INT";
+     $dbms->query($local_sql);
+
+case 34:
+     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN pri INT";
+     $dbms->query($local_sql);
+
+     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN relay TEXT";
+     $dbms->query($local_sql);
+
+     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN status_details TEXT";
+     $dbms->query($local_sql);
+
+     $local_sql = "CREATE INDEX log_adv_email_status ON log_adv_daemon_email (status)";
+     $dbms->query($local_sql);
+              
+case 35:
+     $local_sql = "ALTER TABLE log_adv_daemon_email ADD COLUMN dsn TEXT";
+     $dbms->query($local_sql);
+         
+
 //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
 /*