Partial Fix #7796 - media outreach crm - needs distributed email sending (due to...

diff --git a/DataObjects/Core_notify_server.php b/DataObjects/Core_notify_server.php
new file mode 100644 (file)
index 0000000..f678e6c
--- /dev/null
+++ b/DataObjects/Core_notify_server.php
@@ -0,0 +1,23 @@
+<?php
+/**
+ * Table Definition for core_notify_server
+ */
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
+
+class Pman_Core_DataObjects_Core_notify_server extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'core_notify_server';    // table name
+    public $id;                              // int(11)  not_null primary_key auto_increment
+    public $hostname;
+    public $helo;
+    public $poolname;
+    public $is_active;
+    public $last_send;
+    
+    
+    
+    
+}
\ No newline at end of file

diff --git a/sql/core_notify_blacklist.sql b/sql/core_notify_blacklist.sql
new file mode 100644 (file)
index 0000000..3c0e001
--- /dev/null
+++ b/sql/core_notify_blacklist.sql
@@ -0,0 +1,11 @@
+CREATE  TABLE core_notify_blacklist (
+    id INT(11) NOT NULL AUTO_INCREMENT ,
+    server_id INT(11) NOT NULL DEFAULT 0,
+    domain_id INT(11) NOT NULL DEFAULT 0,
+    added DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
+    error_str TEXT NOT NULL DEFAULT '',
+    
+    PRIMARY KEY (id)
+) ENGINE=InnoDB;;
+
+ALTER TABLE core_notify_blacklist ADD INDEX lookup (server_id,domain_id);