-- MySQL dump 10.11
--
-- Host: localhost Database: email_blaster
-- ------------------------------------------------------
-- Server version 5.0.51a-3ubuntu5.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `asp_applications`
--
DROP TABLE IF EXISTS `asp_applications`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `asp_applications` (
`application_id` varchar(100) NOT NULL,
`application_data` blob,
PRIMARY KEY (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `asp_applications`
--
LOCK TABLES `asp_applications` WRITE;
/*!40000 ALTER TABLE `asp_applications` DISABLE KEYS */;
INSERT INTO `asp_applications` VALUES ('DefaultApp','1234\0\0\0\n1\0\0\0__Server_Started18945\n1\0\0\0__Server_Started18546\n1\0\0\0__Server_Started18766\n1\0\0\0__Server_Started18758\n1\0\0\0__Server_Started18934\n1\0\0\0__Server_Started18549\n1\0\0\0__Server_Started19226\n1\0\0\0__Server_Started18545\n1\0\0\0__Application_Started\n1\0\0\0__Server_Started19222\n1\0\0\0__Server_Started18760\n1\0\0\0__Server_Started18941\n1\0\0\0__Server_Started18765\n1\0\0\0__Server_Started18938\n1\0\0\0__Server_Started19220\n1\0\0\0__Server_Started19216\n1\0\0\0__Server_Started19218\n1\0\0\0__Server_Started18761\n1\0\0\0__Server_Started18542\n1\0\0\0__Server_Started18541\n1\0\0\0__Server_Started18936');
/*!40000 ALTER TABLE `asp_applications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `asp_sessions`
--
DROP TABLE IF EXISTS `asp_sessions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `asp_sessions` (
`session_id` char(32) NOT NULL,
`session_data` blob,
`created_on` datetime default NULL,
`modified_on` datetime default NULL,
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `asp_sessions`
--
LOCK TABLES `asp_sessions` WRITE;
/*!40000 ALTER TABLE `asp_sessions` DISABLE KEYS */;
INSERT INTO `asp_sessions` VALUES ('02d9d373411094823a09cb57e101fa2e','1234\0\0\0\n 59bf8c3ad8307a866240dd2fb8725e71 \0\0\0__signature\n1 \0\0\0__Started\n 02d9d373411094823a09cb57e101fa2e \0\0\0SessionID','2008-11-26 22:38:55','2008-11-26 22:38:55'),('078702af315981ee0f49f15cf36ef0bd','1234\0\0\0\n 2450f186de1dbfc9cb85db709dbdf734 \0\0\0__signature\n1 \0\0\0__Started\n 078702af315981ee0f49f15cf36ef0bd \0\0\0SessionID','2008-11-26 22:52:05','2008-11-26 22:52:05'),('19eeb447b405edea6aa0ea1dbd9518f4','1234\0\0\0\n 4861c985660e9b0b3b003c22a2bb5828 \0\0\0__signature\n1 \0\0\0__Started\n 19eeb447b405edea6aa0ea1dbd9518f4 \0\0\0SessionID','2008-11-26 22:36:45','2008-11-26 22:36:45'),('1d0a8a8ef6b6e03dd22c0b5d908170ca','1234\0\0\0\n 43ca15fb25440efb0d4c00b99e52eac4 \0\0\0__signature\n1 \0\0\0__Started\n 1d0a8a8ef6b6e03dd22c0b5d908170ca \0\0\0SessionID','2008-11-26 22:52:04','2008-11-26 22:52:04'),('23283dcb2cd1771434dff01fcf637c45','1234\0\0\0\n a5bbbf580d6134e2d846c11930d7972b \0\0\0__signature\n1 \0\0\0__Started\n 23283dcb2cd1771434dff01fcf637c45 \0\0\0SessionID','2008-11-26 22:38:55','2008-11-26 22:38:55'),('26f110b821e217850cc26a51d5efab6a','1234\0\0\0\n 51a6d26f5598718062b4d4e0c6b4b0e9 \0\0\0__signature\n1 \0\0\0__Started\n 26f110b821e217850cc26a51d5efab6a \0\0\0SessionID','2008-11-26 22:38:03','2008-11-26 22:38:03'),('289eaed7a3cbe1c21dceac0899724563','1234\0\0\0\n c1aa38284316e1849365837bfd716b44 \0\0\0__signature\n1 \0\0\0__Started\n 289eaed7a3cbe1c21dceac0899724563 \0\0\0SessionID','2008-11-26 22:38:55','2008-11-26 22:38:55'),('3dc968d0645f43c566e4b269139a5b74','1234\0\0\0\n cb732e4cb17b43036b6dc7ae5ea774f0 \0\0\0__signature\n1 \0\0\0__Started\n 3dc968d0645f43c566e4b269139a5b74 \0\0\0SessionID','2008-11-26 22:38:55','2008-11-26 22:38:55'),('413252c693d4a6a5fef276099ffb7304','1234\0\0\0\n 72e4184d8c8843d6dc0b8692f684ee25 \0\0\0__signature\n1 \0\0\0__Started\n 413252c693d4a6a5fef276099ffb7304 \0\0\0SessionID','2008-11-26 22:52:04','2008-11-26 22:52:05'),('425077d1f39bf0fc7a6394571377e60c','1234\0\0\0\n 5bc678a6125b93903256c1f4abb1a383 \0\0\0__signature\n1 \0\0\0__Started\n 425077d1f39bf0fc7a6394571377e60c \0\0\0SessionID','2008-11-26 22:36:45','2008-11-26 22:36:45'),('5f161f932cfc67991610f2c6db63c7e0','1234\0\0\0\n 9d3370a6c6ddb741f8df33603b00596e \0\0\0__signature\n1 \0\0\0__Started\n 5f161f932cfc67991610f2c6db63c7e0 \0\0\0SessionID','2008-11-26 22:36:45','2008-11-26 22:36:45'),('6a5bf5465f5a76b2d4355faf9cda4d62','1234\0\0\0\n 9be204d2b2e30577d700f6a8a25ff4df \0\0\0__signature\n1 \0\0\0__Started\n 6a5bf5465f5a76b2d4355faf9cda4d62 \0\0\0SessionID','2008-11-26 22:38:03','2008-11-26 22:38:03'),('6e1a7071a4cdc6b6857b3d1fd005510e','1234\0\0\0\n 39227219c02f0ccaec5b5139e85d2e17 \0\0\0__signature\n1 \0\0\0__Started\n 6e1a7071a4cdc6b6857b3d1fd005510e \0\0\0SessionID','2008-11-26 22:36:45','2008-11-26 22:36:45'),('a24b6532942ba118e41f1e98778af635','1234\0\0\0\n 40eabd07c5b9e7350454340c250ecf2e \0\0\0__signature\n1 \0\0\0__Started\n a24b6532942ba118e41f1e98778af635 \0\0\0SessionID','2008-11-26 22:52:04','2008-11-26 22:52:04'),('a767e6c3e5545a4a17ea5368bd7e96c5','1234\0\0\0\n feab3dfa8fb7431084c85665154655db \0\0\0__signature\n1 \0\0\0__Started\n a767e6c3e5545a4a17ea5368bd7e96c5 \0\0\0SessionID','2008-11-26 22:38:03','2008-11-26 22:38:03'),('a80e8ebf307ac263168e01eb8721e529','1234\0\0\0\n b7c959b5a4089e0f6c2e2e15a6a98e86 \0\0\0__signature\n1 \0\0\0__Started\n a80e8ebf307ac263168e01eb8721e529 \0\0\0SessionID','2008-11-26 22:38:03','2008-11-26 22:38:03'),('b7cd70fbdd6fb313926ba56302b6e679','1234\0\0\0\n b64eb1eba26d0432766cf361b86fe9e2 \0\0\0__signature\n1 \0\0\0__Started\n b7cd70fbdd6fb313926ba56302b6e679 \0\0\0SessionID','2008-11-26 22:38:55','2008-11-26 22:38:55'),('d5f6e78e8b1f67c5e26004be0ac7d446','1234\0\0\0\n 4a3d00822da49ed589c42adaf2088dcf \0\0\0__signature\n1 \0\0\0__Started\n d5f6e78e8b1f67c5e26004be0ac7d446 \0\0\0SessionID','2008-11-26 22:52:04','2008-11-26 22:52:04'),('d6fae5e3f2ae79959b2b34bca45befc4','1234\0\0\0\n 70c0cc3dcb9a63b16b9f92cb0ecb95f1 \0\0\0__signature\n1 \0\0\0__Started\n d6fae5e3f2ae79959b2b34bca45befc4 \0\0\0SessionID','2008-11-26 22:36:45','2008-11-26 22:36:45'),('dc1165c875d11d9f33f1f406ad13dec2','1234\0\0\0\n ac16f2ab4f48054972626ff490e83ce2 \0\0\0__signature\n1 \0\0\0__Started\n dc1165c875d11d9f33f1f406ad13dec2 \0\0\0SessionID','2008-11-26 22:38:03','2008-11-26 22:38:03');
/*!40000 ALTER TABLE `asp_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contact_lists`
--
DROP TABLE IF EXISTS `contact_lists`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `contact_lists` (
`contact_list_id` int(11) NOT NULL auto_increment,
`contact_list_name` varchar(50) NOT NULL,
PRIMARY KEY (`contact_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `contact_lists`
--
LOCK TABLES `contact_lists` WRITE;
/*!40000 ALTER TABLE `contact_lists` DISABLE KEYS */;
INSERT INTO `contact_lists` VALUES (5,'ContactList1'),(6,'ContactList2');
/*!40000 ALTER TABLE `contact_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contact_subscriptions`
--
DROP TABLE IF EXISTS `contact_subscriptions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `contact_subscriptions` (
`contact_subscription_id` int(11) NOT NULL auto_increment,
`contact_id` int(11) NOT NULL,
`contact_list_id` int(11) NOT NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`contact_subscription_id`),
KEY `FK_subscriptions_contacts` (`contact_id`),
KEY `FK_subscriptions_lists` (`contact_list_id`),
CONSTRAINT `FK_subscriptions_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE,
CONSTRAINT `FK_subscriptions_lists` FOREIGN KEY (`contact_list_id`) REFERENCES `contact_lists` (`contact_list_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `contact_subscriptions`
--
LOCK TABLES `contact_subscriptions` WRITE;
/*!40000 ALTER TABLE `contact_subscriptions` DISABLE KEYS */;
INSERT INTO `contact_subscriptions` VALUES (301,201,5,'0000-00-00 00:00:00'),(302,202,5,'0000-00-00 00:00:00'),(303,203,5,'0000-00-00 00:00:00'),(304,204,5,'0000-00-00 00:00:00'),(305,205,5,'0000-00-00 00:00:00'),(306,206,5,'0000-00-00 00:00:00'),(307,207,5,'0000-00-00 00:00:00'),(308,208,5,'0000-00-00 00:00:00'),(309,209,5,'0000-00-00 00:00:00'),(310,210,5,'0000-00-00 00:00:00'),(311,211,5,'0000-00-00 00:00:00'),(312,212,5,'0000-00-00 00:00:00'),(313,213,5,'0000-00-00 00:00:00'),(314,214,5,'0000-00-00 00:00:00'),(315,215,5,'0000-00-00 00:00:00'),(316,216,5,'0000-00-00 00:00:00'),(317,217,5,'0000-00-00 00:00:00'),(318,218,5,'0000-00-00 00:00:00'),(319,219,5,'0000-00-00 00:00:00'),(320,220,5,'0000-00-00 00:00:00'),(321,221,5,'0000-00-00 00:00:00'),(322,222,5,'0000-00-00 00:00:00'),(323,223,5,'0000-00-00 00:00:00'),(324,224,5,'0000-00-00 00:00:00'),(325,225,5,'0000-00-00 00:00:00'),(326,226,5,'0000-00-00 00:00:00'),(327,227,5,'0000-00-00 00:00:00'),(328,228,5,'0000-00-00 00:00:00'),(329,229,5,'0000-00-00 00:00:00'),(330,230,5,'0000-00-00 00:00:00'),(331,231,5,'0000-00-00 00:00:00'),(332,232,5,'0000-00-00 00:00:00'),(333,233,5,'0000-00-00 00:00:00'),(334,234,5,'0000-00-00 00:00:00'),(335,235,5,'0000-00-00 00:00:00'),(336,236,5,'0000-00-00 00:00:00'),(337,237,5,'0000-00-00 00:00:00'),(338,238,5,'0000-00-00 00:00:00'),(339,239,5,'0000-00-00 00:00:00'),(340,240,5,'0000-00-00 00:00:00'),(341,241,5,'0000-00-00 00:00:00'),(342,242,5,'0000-00-00 00:00:00'),(343,243,5,'0000-00-00 00:00:00'),(344,244,5,'0000-00-00 00:00:00'),(345,245,5,'0000-00-00 00:00:00'),(346,246,5,'0000-00-00 00:00:00'),(347,247,5,'0000-00-00 00:00:00'),(348,248,5,'0000-00-00 00:00:00'),(349,249,5,'0000-00-00 00:00:00'),(350,250,5,'0000-00-00 00:00:00'),(351,251,5,'0000-00-00 00:00:00'),(352,252,5,'0000-00-00 00:00:00'),(353,253,5,'0000-00-00 00:00:00'),(354,254,5,'0000-00-00 00:00:00'),(355,255,5,'0000-00-00 00:00:00'),(356,256,5,'0000-00-00 00:00:00'),(357,257,5,'0000-00-00 00:00:00'),(358,258,5,'0000-00-00 00:00:00'),(359,259,5,'0000-00-00 00:00:00'),(360,260,5,'0000-00-00 00:00:00'),(361,261,5,'0000-00-00 00:00:00'),(362,262,5,'0000-00-00 00:00:00'),(363,263,5,'0000-00-00 00:00:00'),(364,264,5,'0000-00-00 00:00:00'),(365,265,5,'0000-00-00 00:00:00'),(366,266,5,'0000-00-00 00:00:00'),(367,267,5,'0000-00-00 00:00:00'),(368,268,5,'0000-00-00 00:00:00'),(369,269,5,'0000-00-00 00:00:00'),(370,270,5,'0000-00-00 00:00:00'),(371,271,5,'0000-00-00 00:00:00'),(372,272,5,'0000-00-00 00:00:00'),(373,273,5,'0000-00-00 00:00:00'),(374,274,5,'0000-00-00 00:00:00'),(375,275,5,'0000-00-00 00:00:00'),(376,276,5,'0000-00-00 00:00:00'),(377,277,5,'0000-00-00 00:00:00'),(378,278,5,'0000-00-00 00:00:00'),(379,279,5,'0000-00-00 00:00:00'),(380,280,5,'0000-00-00 00:00:00'),(381,281,5,'0000-00-00 00:00:00'),(382,282,5,'0000-00-00 00:00:00'),(383,283,5,'0000-00-00 00:00:00'),(384,284,5,'0000-00-00 00:00:00'),(385,285,5,'0000-00-00 00:00:00'),(386,286,5,'0000-00-00 00:00:00'),(387,287,5,'0000-00-00 00:00:00'),(388,288,5,'0000-00-00 00:00:00'),(389,289,5,'0000-00-00 00:00:00'),(390,290,5,'0000-00-00 00:00:00'),(391,291,5,'0000-00-00 00:00:00'),(392,292,5,'0000-00-00 00:00:00'),(393,293,5,'0000-00-00 00:00:00'),(394,294,5,'0000-00-00 00:00:00'),(395,295,5,'0000-00-00 00:00:00'),(396,296,5,'0000-00-00 00:00:00'),(397,297,5,'0000-00-00 00:00:00'),(398,298,5,'0000-00-00 00:00:00'),(399,299,5,'0000-00-00 00:00:00'),(400,300,5,'0000-00-00 00:00:00'),(401,201,6,'0000-00-00 00:00:00'),(402,203,6,'0000-00-00 00:00:00'),(403,205,6,'0000-00-00 00:00:00'),(404,207,6,'0000-00-00 00:00:00'),(405,209,6,'0000-00-00 00:00:00'),(406,211,6,'0000-00-00 00:00:00'),(407,213,6,'0000-00-00 00:00:00'),(408,215,6,'0000-00-00 00:00:00'),(409,217,6,'0000-00-00 00:00:00'),(410,219,6,'0000-00-00 00:00:00'),(411,221,6,'0000-00-00 00:00:00'),(412,223,6,'0000-00-00 00:00:00'),(413,225,6,'0000-00-00 00:00:00'),(414,227,6,'0000-00-00 00:00:00'),(415,229,6,'0000-00-00 00:00:00'),(416,231,6,'0000-00-00 00:00:00'),(417,233,6,'0000-00-00 00:00:00'),(418,235,6,'0000-00-00 00:00:00'),(419,237,6,'0000-00-00 00:00:00'),(420,239,6,'0000-00-00 00:00:00'),(421,241,6,'0000-00-00 00:00:00'),(422,243,6,'0000-00-00 00:00:00'),(423,245,6,'0000-00-00 00:00:00'),(424,247,6,'0000-00-00 00:00:00'),(425,249,6,'0000-00-00 00:00:00'),(426,251,6,'0000-00-00 00:00:00'),(427,253,6,'0000-00-00 00:00:00'),(428,255,6,'0000-00-00 00:00:00'),(429,257,6,'0000-00-00 00:00:00'),(430,259,6,'0000-00-00 00:00:00'),(431,261,6,'0000-00-00 00:00:00'),(432,263,6,'0000-00-00 00:00:00'),(433,265,6,'0000-00-00 00:00:00'),(434,267,6,'0000-00-00 00:00:00'),(435,269,6,'0000-00-00 00:00:00'),(436,271,6,'0000-00-00 00:00:00'),(437,273,6,'0000-00-00 00:00:00'),(438,275,6,'0000-00-00 00:00:00'),(439,277,6,'0000-00-00 00:00:00'),(440,279,6,'0000-00-00 00:00:00'),(441,281,6,'0000-00-00 00:00:00'),(442,283,6,'0000-00-00 00:00:00'),(443,285,6,'0000-00-00 00:00:00'),(444,287,6,'0000-00-00 00:00:00'),(445,289,6,'0000-00-00 00:00:00'),(446,291,6,'0000-00-00 00:00:00'),(447,293,6,'0000-00-00 00:00:00'),(448,295,6,'0000-00-00 00:00:00'),(449,297,6,'0000-00-00 00:00:00'),(450,299,6,'0000-00-00 00:00:00');
/*!40000 ALTER TABLE `contact_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contacts`
--
DROP TABLE IF EXISTS `contacts`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `contacts` (
`contact_id` int(11) NOT NULL auto_increment,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`is_subscribed` int(11) NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=301 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `contacts`
--
LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
INSERT INTO `contacts` VALUES (201,'TestFirst1','TestLast1','email1@aol.com',0),(202,'TestFirst2','TestLast2','email2@test.com',1),(203,'TestFirst3','TestLast3','email3@aol.com',1),(204,'TestFirst4','TestLast4','email4@test.com',1),(205,'TestFirst5','TestLast5','email5@aol.com',1),(206,'TestFirst6','TestLast6','email6@test.com',1),(207,'TestFirst7','TestLast7','email7@aol.com',1),(208,'TestFirst8','TestLast8','email8@test.com',1),(209,'TestFirst9','TestLast9','email9@aol.com',1),(210,'TestFirst10','TestLast10','email10@test.com',1),(211,'TestFirst11','TestLast11','email11@aol.com',1),(212,'TestFirst12','TestLast12','email12@test.com',1),(213,'TestFirst13','TestLast13','email13@aol.com',1),(214,'TestFirst14','TestLast14','email14@test.com',1),(215,'TestFirst15','TestLast15','email15@aol.com',1),(216,'TestFirst16','TestLast16','email16@test.com',1),(217,'TestFirst17','TestLast17','email17@aol.com',1),(218,'TestFirst18','TestLast18','email18@test.com',1),(219,'TestFirst19','TestLast19','email19@aol.com',1),(220,'TestFirst20','TestLast20','email20@test.com',1),(221,'TestFirst21','TestLast21','email21@aol.com',1),(222,'TestFirst22','TestLast22','email22@test.com',1),(223,'TestFirst23','TestLast23','email23@aol.com',1),(224,'TestFirst24','TestLast24','email24@test.com',1),(225,'TestFirst25','TestLast25','email25@aol.com',1),(226,'TestFirst26','TestLast26','email26@test.com',1),(227,'TestFirst27','TestLast27','email27@aol.com',1),(228,'TestFirst28','TestLast28','email28@test.com',1),(229,'TestFirst29','TestLast29','email29@aol.com',1),(230,'TestFirst30','TestLast30','email30@test.com',1),(231,'TestFirst31','TestLast31','email31@aol.com',1),(232,'TestFirst32','TestLast32','email32@test.com',1),(233,'TestFirst33','TestLast33','email33@aol.com',1),(234,'TestFirst34','TestLast34','email34@test.com',1),(235,'TestFirst35','TestLast35','email35@aol.com',1),(236,'TestFirst36','TestLast36','email36@test.com',1),(237,'TestFirst37','TestLast37','email37@aol.com',1),(238,'TestFirst38','TestLast38','email38@test.com',1),(239,'TestFirst39','TestLast39','email39@aol.com',1),(240,'TestFirst40','TestLast40','email40@test.com',1),(241,'TestFirst41','TestLast41','email41@aol.com',1),(242,'TestFirst42','TestLast42','email42@test.com',1),(243,'TestFirst43','TestLast43','email43@aol.com',1),(244,'TestFirst44','TestLast44','email44@test.com',1),(245,'TestFirst45','TestLast45','email45@aol.com',1),(246,'TestFirst46','TestLast46','email46@test.com',1),(247,'TestFirst47','TestLast47','email47@aol.com',1),(248,'TestFirst48','TestLast48','email48@test.com',1),(249,'TestFirst49','TestLast49','email49@aol.com',1),(250,'TestFirst50','TestLast50','email50@test.com',1),(251,'TestFirst51','TestLast51','email51@aol.com',1),(252,'TestFirst52','TestLast52','email52@test.com',1),(253,'TestFirst53','TestLast53','email53@aol.com',1),(254,'TestFirst54','TestLast54','email54@test.com',1),(255,'TestFirst55','TestLast55','email55@aol.com',1),(256,'TestFirst56','TestLast56','email56@test.com',1),(257,'TestFirst57','TestLast57','email57@aol.com',1),(258,'TestFirst58','TestLast58','email58@test.com',1),(259,'TestFirst59','TestLast59','email59@aol.com',1),(260,'TestFirst60','TestLast60','email60@test.com',1),(261,'TestFirst61','TestLast61','email61@aol.com',1),(262,'TestFirst62','TestLast62','email62@test.com',1),(263,'TestFirst63','TestLast63','email63@aol.com',1),(264,'TestFirst64','TestLast64','email64@test.com',1),(265,'TestFirst65','TestLast65','email65@aol.com',1),(266,'TestFirst66','TestLast66','email66@test.com',1),(267,'TestFirst67','TestLast67','email67@aol.com',1),(268,'TestFirst68','TestLast68','email68@test.com',1),(269,'TestFirst69','TestLast69','email69@aol.com',1),(270,'TestFirst70','TestLast70','email70@test.com',1),(271,'TestFirst71','TestLast71','email71@aol.com',1),(272,'TestFirst72','TestLast72','email72@test.com',1),(273,'TestFirst73','TestLast73','email73@aol.com',1),(274,'TestFirst74','TestLast74','email74@test.com',1),(275,'TestFirst75','TestLast75','email75@aol.com',1),(276,'TestFirst76','TestLast76','email76@test.com',1),(277,'TestFirst77','TestLast77','email77@aol.com',1),(278,'TestFirst78','TestLast78','email78@test.com',1),(279,'TestFirst79','TestLast79','email79@aol.com',1),(280,'TestFirst80','TestLast80','email80@test.com',1),(281,'TestFirst81','TestLast81','email81@aol.com',1),(282,'TestFirst82','TestLast82','email82@test.com',1),(283,'TestFirst83','TestLast83','email83@aol.com',1),(284,'TestFirst84','TestLast84','email84@test.com',1),(285,'TestFirst85','TestLast85','email85@aol.com',1),(286,'TestFirst86','TestLast86','email86@test.com',1),(287,'TestFirst87','TestLast87','email87@aol.com',1),(288,'TestFirst88','TestLast88','email88@test.com',1),(289,'TestFirst89','TestLast89','email89@aol.com',1),(290,'TestFirst90','TestLast90','email90@test.com',1),(291,'TestFirst91','TestLast91','email91@aol.com',1),(292,'TestFirst92','TestLast92','email92@test.com',1),(293,'TestFirst93','TestLast93','email93@aol.com',1),(294,'TestFirst94','TestLast94','email94@test.com',1),(295,'TestFirst95','TestLast95','email95@aol.com',1),(296,'TestFirst96','TestLast96','email96@test.com',1),(297,'TestFirst97','TestLast97','email97@aol.com',1),(298,'TestFirst98','TestLast98','email98@test.com',1),(299,'TestFirst99','TestLast99','email99@aol.com',1),(300,'TestFirst100','TestLast100','email100@test.com',1);
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `event_types`
--
DROP TABLE IF EXISTS `event_types`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `event_types` (
`event_type_id` int(11) NOT NULL auto_increment,
`event_type_name` varchar(100) NOT NULL,
PRIMARY KEY (`event_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `event_types`
--
LOCK TABLES `event_types` WRITE;
/*!40000 ALTER TABLE `event_types` DISABLE KEYS */;
INSERT INTO `event_types` VALUES (1,'server_shutdown'),(2,'server_startup'),(3,'init_transmission'),(4,'begin_transmission'),(5,'end_transmission'),(6,'message_bounced');
/*!40000 ALTER TABLE `event_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `events`
--
DROP TABLE IF EXISTS `events`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `events` (
`event_id` int(11) NOT NULL auto_increment,
`event_type_id` int(11) NOT NULL,
`transmission_id` int(11) NOT NULL,
`sendlog_id` int(11) NOT NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `events`
--
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT INTO `events` VALUES (1,2,0,0,'0000-00-00 00:00:00'),(3,2,0,0,'0000-00-00 00:00:00'),(5,2,0,0,'0000-00-00 00:00:00'),(7,1,0,0,'0000-00-00 00:00:00'),(8,1,0,0,'0000-00-00 00:00:00'),(9,2,0,0,'0000-00-00 00:00:00'),(11,1,0,0,'0000-00-00 00:00:00'),(13,2,0,0,'0000-00-00 00:00:00'),(15,1,0,0,'0000-00-00 00:00:00'),(16,1,0,0,'0000-00-00 00:00:00'),(17,2,0,0,'0000-00-00 00:00:00'),(19,1,0,0,'0000-00-00 00:00:00'),(20,1,0,0,'0000-00-00 00:00:00'),(21,2,0,0,'0000-00-00 00:00:00'),(23,1,0,0,'0000-00-00 00:00:00'),(24,1,0,0,'0000-00-00 00:00:00'),(25,2,0,0,'0000-00-00 00:00:00'),(27,2,0,0,'0000-00-00 00:00:00'),(29,1,0,0,'0000-00-00 00:00:00'),(30,1,0,0,'0000-00-00 00:00:00'),(31,2,0,0,'0000-00-00 00:00:00'),(33,1,0,0,'0000-00-00 00:00:00'),(34,1,0,0,'0000-00-00 00:00:00'),(35,2,0,0,'0000-00-00 00:00:00'),(37,1,0,0,'0000-00-00 00:00:00'),(38,2,0,0,'0000-00-00 00:00:00'),(40,1,0,0,'0000-00-00 00:00:00'),(41,2,0,0,'0000-00-00 00:00:00'),(43,1,0,0,'0000-00-00 00:00:00'),(44,2,0,0,'0000-00-00 00:00:00'),(46,1,0,0,'0000-00-00 00:00:00'),(47,2,0,0,'0000-00-00 00:00:00'),(49,1,0,0,'0000-00-00 00:00:00'),(50,2,0,0,'0000-00-00 00:00:00'),(51,1,0,0,'0000-00-00 00:00:00'),(52,2,0,0,'0000-00-00 00:00:00'),(54,1,0,0,'0000-00-00 00:00:00'),(55,2,0,0,'0000-00-00 00:00:00'),(57,1,0,0,'0000-00-00 00:00:00'),(58,2,0,0,'0000-00-00 00:00:00'),(60,1,0,0,'0000-00-00 00:00:00'),(61,2,0,0,'0000-00-00 00:00:00'),(63,1,0,0,'0000-00-00 00:00:00'),(64,2,0,0,'0000-00-00 00:00:00'),(66,1,0,0,'0000-00-00 00:00:00'),(67,2,0,0,'0000-00-00 00:00:00'),(69,1,0,0,'0000-00-00 00:00:00'),(70,2,0,0,'0000-00-00 00:00:00'),(72,1,0,0,'0000-00-00 00:00:00'),(73,2,0,0,'0000-00-00 00:00:00'),(75,1,0,0,'0000-00-00 00:00:00'),(76,2,0,0,'0000-00-00 00:00:00'),(78,2,0,0,'0000-00-00 00:00:00'),(80,2,0,0,'0000-00-00 00:00:00'),(82,1,0,0,'0000-00-00 00:00:00'),(83,2,0,0,'0000-00-00 00:00:00'),(85,1,0,0,'0000-00-00 00:00:00'),(86,2,0,0,'0000-00-00 00:00:00'),(88,1,0,0,'0000-00-00 00:00:00'),(89,2,0,0,'0000-00-00 00:00:00'),(91,1,0,0,'0000-00-00 00:00:00'),(92,2,0,0,'0000-00-00 00:00:00'),(94,1,0,0,'0000-00-00 00:00:00'),(95,1,0,0,'0000-00-00 00:00:00'),(96,1,0,0,'0000-00-00 00:00:00'),(97,1,0,0,'0000-00-00 00:00:00'),(98,1,0,0,'0000-00-00 00:00:00'),(99,1,0,0,'0000-00-00 00:00:00'),(100,2,0,0,'0000-00-00 00:00:00'),(102,1,0,0,'0000-00-00 00:00:00'),(103,2,0,0,'0000-00-00 00:00:00'),(104,1,0,0,'0000-00-00 00:00:00'),(105,2,0,0,'0000-00-00 00:00:00'),(107,1,0,0,'0000-00-00 00:00:00'),(108,2,0,0,'0000-00-00 00:00:00'),(110,1,0,0,'0000-00-00 00:00:00'),(111,2,0,0,'0000-00-00 00:00:00'),(113,1,0,0,'0000-00-00 00:00:00'),(114,2,0,0,'0000-00-00 00:00:00'),(116,1,0,0,'0000-00-00 00:00:00'),(117,2,0,0,'0000-00-00 00:00:00'),(119,1,0,0,'0000-00-00 00:00:00'),(120,2,0,0,'0000-00-00 00:00:00'),(122,1,0,0,'0000-00-00 00:00:00'),(123,2,0,0,'0000-00-00 00:00:00'),(125,1,0,0,'0000-00-00 00:00:00'),(126,2,0,0,'0000-00-00 00:00:00'),(128,1,0,0,'0000-00-00 00:00:00'),(129,2,0,0,'0000-00-00 00:00:00'),(131,1,0,0,'0000-00-00 00:00:00'),(132,2,0,0,'0000-00-00 00:00:00'),(134,1,0,0,'0000-00-00 00:00:00'),(135,2,0,0,'0000-00-00 00:00:00'),(136,1,0,0,'0000-00-00 00:00:00'),(137,2,0,0,'0000-00-00 00:00:00'),(139,1,0,0,'0000-00-00 00:00:00'),(140,2,0,0,'0000-00-00 00:00:00'),(141,2,0,0,'0000-00-00 00:00:00'),(143,2,0,0,'0000-00-00 00:00:00'),(145,1,0,0,'0000-00-00 00:00:00'),(146,1,0,0,'0000-00-00 00:00:00'),(148,1,0,0,'0000-00-00 00:00:00'),(149,1,0,0,'0000-00-00 00:00:00'),(150,1,0,0,'0000-00-00 00:00:00'),(151,1,0,0,'0000-00-00 00:00:00'),(152,2,0,0,'0000-00-00 00:00:00'),(153,2,0,0,'0000-00-00 00:00:00'),(154,2,0,0,'0000-00-00 00:00:00'),(155,2,0,0,'0000-00-00 00:00:00'),(156,2,0,0,'0000-00-00 00:00:00'),(157,1,0,0,'0000-00-00 00:00:00'),(158,1,0,0,'0000-00-00 00:00:00'),(159,2,0,0,'0000-00-00 00:00:00'),(161,1,0,0,'0000-00-00 00:00:00'),(162,1,0,0,'0000-00-00 00:00:00'),(163,1,0,0,'0000-00-00 00:00:00'),(164,1,0,0,'0000-00-00 00:00:00'),(165,1,0,0,'0000-00-00 00:00:00'),(166,1,0,0,'0000-00-00 00:00:00'),(167,1,0,0,'0000-00-00 00:00:00'),(168,2,0,0,'0000-00-00 00:00:00'),(169,1,0,0,'0000-00-00 00:00:00'),(170,1,0,0,'0000-00-00 00:00:00'),(171,2,0,0,'0000-00-00 00:00:00'),(172,1,0,0,'0000-00-00 00:00:00'),(173,1,0,0,'0000-00-00 00:00:00'),(174,2,0,0,'0000-00-00 00:00:00'),(175,1,0,0,'0000-00-00 00:00:00'),(176,2,0,0,'0000-00-00 00:00:00'),(177,1,0,0,'0000-00-00 00:00:00'),(178,2,0,0,'0000-00-00 00:00:00'),(179,1,0,0,'0000-00-00 00:00:00'),(180,2,0,0,'0000-00-00 00:00:00'),(181,1,0,0,'0000-00-00 00:00:00'),(182,2,0,0,'0000-00-00 00:00:00'),(183,1,0,0,'0000-00-00 00:00:00'),(184,2,0,0,'0000-00-00 00:00:00'),(185,1,0,0,'0000-00-00 00:00:00'),(186,2,0,0,'0000-00-00 00:00:00'),(187,1,0,0,'0000-00-00 00:00:00'),(188,2,0,0,'0000-00-00 00:00:00'),(189,1,0,0,'0000-00-00 00:00:00'),(190,1,0,0,'0000-00-00 00:00:00'),(191,2,0,0,'0000-00-00 00:00:00'),(192,1,0,0,'0000-00-00 00:00:00'),(193,1,0,0,'0000-00-00 00:00:00'),(194,2,0,0,'0000-00-00 00:00:00'),(195,1,0,0,'0000-00-00 00:00:00'),(196,1,0,0,'0000-00-00 00:00:00'),(197,2,0,0,'0000-00-00 00:00:00'),(198,1,0,0,'0000-00-00 00:00:00'),(199,1,0,0,'0000-00-00 00:00:00'),(200,2,0,0,'0000-00-00 00:00:00'),(201,1,0,0,'0000-00-00 00:00:00'),(202,1,0,0,'0000-00-00 00:00:00'),(203,2,0,0,'0000-00-00 00:00:00'),(204,1,0,0,'0000-00-00 00:00:00'),(205,2,0,0,'0000-00-00 00:00:00'),(207,1,0,0,'0000-00-00 00:00:00'),(208,1,0,0,'0000-00-00 00:00:00'),(209,1,0,0,'0000-00-00 00:00:00'),(210,1,0,0,'0000-00-00 00:00:00'),(211,1,0,0,'0000-00-00 00:00:00'),(212,1,0,0,'0000-00-00 00:00:00'),(213,1,0,0,'0000-00-00 00:00:00'),(214,2,0,0,'0000-00-00 00:00:00'),(215,1,0,0,'0000-00-00 00:00:00'),(216,2,0,0,'0000-00-00 00:00:00'),(217,1,0,0,'0000-00-00 00:00:00'),(218,1,0,0,'0000-00-00 00:00:00'),(219,2,0,0,'0000-00-00 00:00:00'),(220,1,0,0,'0000-00-00 00:00:00'),(221,1,0,0,'0000-00-00 00:00:00'),(222,2,0,0,'0000-00-00 00:00:00'),(224,1,0,0,'0000-00-00 00:00:00'),(225,1,0,0,'0000-00-00 00:00:00'),(226,1,0,0,'0000-00-00 00:00:00'),(227,1,0,0,'0000-00-00 00:00:00'),(228,1,0,0,'0000-00-00 00:00:00'),(229,1,0,0,'0000-00-00 00:00:00'),(230,1,0,0,'0000-00-00 00:00:00'),(231,2,0,0,'0000-00-00 00:00:00'),(232,1,0,0,'0000-00-00 00:00:00'),(233,2,0,0,'0000-00-00 00:00:00'),(234,1,0,0,'0000-00-00 00:00:00'),(235,1,0,0,'0000-00-00 00:00:00'),(236,2,0,0,'0000-00-00 00:00:00'),(237,1,0,0,'0000-00-00 00:00:00'),(238,1,0,0,'0000-00-00 00:00:00'),(239,2,0,0,'0000-00-00 00:00:00'),(240,1,0,0,'0000-00-00 00:00:00'),(241,2,0,0,'0000-00-00 00:00:00'),(242,1,0,0,'0000-00-00 00:00:00'),(243,1,0,0,'0000-00-00 00:00:00'),(244,2,0,0,'0000-00-00 00:00:00'),(245,1,0,0,'0000-00-00 00:00:00'),(246,1,0,0,'0000-00-00 00:00:00'),(247,2,0,0,'0000-00-00 00:00:00'),(248,1,0,0,'0000-00-00 00:00:00'),(249,1,0,0,'0000-00-00 00:00:00'),(250,2,0,0,'0000-00-00 00:00:00'),(251,1,0,0,'0000-00-00 00:00:00'),(252,1,0,0,'0000-00-00 00:00:00'),(253,2,0,0,'0000-00-00 00:00:00'),(254,1,0,0,'0000-00-00 00:00:00'),(255,1,0,0,'0000-00-00 00:00:00'),(256,2,0,0,'0000-00-00 00:00:00'),(257,1,0,0,'0000-00-00 00:00:00'),(258,1,0,0,'0000-00-00 00:00:00'),(259,2,0,0,'0000-00-00 00:00:00'),(260,1,0,0,'0000-00-00 00:00:00'),(261,1,0,0,'0000-00-00 00:00:00'),(262,2,0,0,'0000-00-00 00:00:00'),(263,1,0,0,'0000-00-00 00:00:00'),(264,1,0,0,'0000-00-00 00:00:00'),(265,2,0,0,'0000-00-00 00:00:00'),(266,1,0,0,'0000-00-00 00:00:00'),(267,1,0,0,'0000-00-00 00:00:00'),(268,2,0,0,'0000-00-00 00:00:00'),(269,1,0,0,'0000-00-00 00:00:00'),(270,1,0,0,'0000-00-00 00:00:00'),(271,2,0,0,'0000-00-00 00:00:00'),(272,1,0,0,'0000-00-00 00:00:00'),(273,1,0,0,'0000-00-00 00:00:00'),(274,2,0,0,'0000-00-00 00:00:00'),(276,2,0,0,'0000-00-00 00:00:00'),(278,1,0,0,'0000-00-00 00:00:00'),(279,1,0,0,'0000-00-00 00:00:00'),(280,2,0,0,'0000-00-00 00:00:00'),(282,1,0,0,'0000-00-00 00:00:00'),(283,2,0,0,'0000-00-00 00:00:00'),(285,1,0,0,'0000-00-00 00:00:00'),(286,2,0,0,'0000-00-00 00:00:00'),(287,1,0,0,'0000-00-00 00:00:00'),(288,1,0,0,'0000-00-00 00:00:00'),(289,2,0,0,'0000-00-00 00:00:00'),(291,1,0,0,'0000-00-00 00:00:00'),(292,2,0,0,'0000-00-00 00:00:00'),(293,2,0,0,'0000-00-00 00:00:00'),(295,1,0,0,'0000-00-00 00:00:00'),(296,2,0,0,'0000-00-00 00:00:00'),(297,2,0,0,'0000-00-00 00:00:00'),(299,1,0,0,'0000-00-00 00:00:00'),(300,1,0,0,'0000-00-00 00:00:00'),(301,2,0,0,'0000-00-00 00:00:00'),(302,1,0,0,'0000-00-00 00:00:00'),(303,2,0,0,'0000-00-00 00:00:00'),(305,2,0,0,'0000-00-00 00:00:00'),(307,1,0,0,'0000-00-00 00:00:00'),(308,2,0,0,'0000-00-00 00:00:00'),(310,1,0,0,'0000-00-00 00:00:00'),(311,2,0,0,'0000-00-00 00:00:00'),(313,1,0,0,'0000-00-00 00:00:00'),(314,2,0,0,'0000-00-00 00:00:00'),(315,1,0,0,'0000-00-00 00:00:00'),(316,1,0,0,'0000-00-00 00:00:00'),(317,2,0,0,'0000-00-00 00:00:00'),(319,1,0,0,'0000-00-00 00:00:00'),(320,2,0,0,'0000-00-00 00:00:00'),(322,1,0,0,'0000-00-00 00:00:00'),(323,2,0,0,'0000-00-00 00:00:00'),(325,1,0,0,'0000-00-00 00:00:00'),(326,2,0,0,'0000-00-00 00:00:00'),(327,1,0,0,'0000-00-00 00:00:00'),(328,1,0,0,'0000-00-00 00:00:00'),(329,2,0,0,'0000-00-00 00:00:00'),(330,1,0,0,'0000-00-00 00:00:00'),(331,2,0,0,'0000-00-00 00:00:00'),(332,1,0,0,'0000-00-00 00:00:00'),(333,2,0,0,'0000-00-00 00:00:00'),(334,1,0,0,'0000-00-00 00:00:00'),(335,1,0,0,'0000-00-00 00:00:00'),(336,2,0,0,'0000-00-00 00:00:00'),(337,1,0,0,'0000-00-00 00:00:00'),(338,2,0,0,'0000-00-00 00:00:00'),(339,1,0,0,'0000-00-00 00:00:00'),(340,1,0,0,'0000-00-00 00:00:00'),(341,2,0,0,'0000-00-00 00:00:00'),(342,1,0,0,'0000-00-00 00:00:00'),(343,2,0,0,'0000-00-00 00:00:00'),(344,1,0,0,'0000-00-00 00:00:00'),(345,1,0,0,'0000-00-00 00:00:00'),(346,2,0,0,'0000-00-00 00:00:00'),(348,2,0,0,'0000-00-00 00:00:00'),(350,1,0,0,'0000-00-00 00:00:00'),(351,2,0,0,'0000-00-00 00:00:00'),(352,2,0,0,'0000-00-00 00:00:00'),(353,1,0,0,'0000-00-00 00:00:00'),(354,1,0,0,'0000-00-00 00:00:00'),(355,2,0,0,'0000-00-00 00:00:00'),(356,1,0,0,'0000-00-00 00:00:00'),(357,1,0,0,'0000-00-00 00:00:00'),(358,2,0,0,'0000-00-00 00:00:00'),(360,1,0,0,'0000-00-00 00:00:00'),(361,1,0,0,'0000-00-00 00:00:00'),(362,2,0,0,'0000-00-00 00:00:00'),(364,2,0,0,'0000-00-00 00:00:00'),(366,2,0,0,'0000-00-00 00:00:00'),(367,1,0,0,'0000-00-00 00:00:00'),(368,1,0,0,'0000-00-00 00:00:00'),(369,2,0,0,'0000-00-00 00:00:00'),(370,1,0,0,'0000-00-00 00:00:00'),(371,1,0,0,'0000-00-00 00:00:00'),(372,2,0,0,'0000-00-00 00:00:00'),(374,1,0,0,'0000-00-00 00:00:00'),(375,2,0,0,'0000-00-00 00:00:00'),(377,1,0,0,'0000-00-00 00:00:00'),(378,2,0,0,'0000-00-00 00:00:00'),(380,1,0,0,'0000-00-00 00:00:00'),(381,2,0,0,'0000-00-00 00:00:00'),(383,1,0,0,'0000-00-00 00:00:00'),(384,2,0,0,'0000-00-00 00:00:00'),(385,1,0,0,'0000-00-00 00:00:00'),(386,1,0,0,'0000-00-00 00:00:00'),(387,2,0,0,'0000-00-00 00:00:00'),(388,1,0,0,'0000-00-00 00:00:00'),(389,1,0,0,'0000-00-00 00:00:00'),(390,2,0,0,'0000-00-00 00:00:00'),(391,7,40,0,'0000-00-00 00:00:00'),(392,1,0,0,'0000-00-00 00:00:00'),(393,1,0,0,'0000-00-00 00:00:00'),(394,2,0,0,'0000-00-00 00:00:00'),(395,7,40,0,'0000-00-00 00:00:00'),(396,2,0,0,'0000-00-00 00:00:00'),(397,7,40,0,'0000-00-00 00:00:00'),(398,2,0,0,'0000-00-00 00:00:00'),(399,7,40,0,'0000-00-00 00:00:00'),(400,2,0,0,'0000-00-00 00:00:00'),(402,1,0,0,'0000-00-00 00:00:00'),(403,2,0,0,'0000-00-00 00:00:00'),(405,1,0,0,'0000-00-00 00:00:00'),(406,1,0,0,'0000-00-00 00:00:00'),(407,1,0,0,'0000-00-00 00:00:00'),(408,2,0,0,'0000-00-00 00:00:00'),(410,2,0,0,'0000-00-00 00:00:00'),(412,1,0,0,'0000-00-00 00:00:00'),(413,2,0,0,'0000-00-00 00:00:00'),(414,1,0,0,'0000-00-00 00:00:00'),(415,1,0,0,'0000-00-00 00:00:00'),(416,2,0,0,'0000-00-00 00:00:00'),(417,1,0,0,'0000-00-00 00:00:00'),(418,2,0,0,'0000-00-00 00:00:00'),(420,1,0,0,'0000-00-00 00:00:00'),(421,1,0,0,'0000-00-00 00:00:00'),(422,1,0,0,'0000-00-00 00:00:00'),(423,1,0,0,'0000-00-00 00:00:00'),(424,1,0,0,'0000-00-00 00:00:00'),(425,1,0,0,'0000-00-00 00:00:00'),(426,1,0,0,'0000-00-00 00:00:00'),(427,2,0,0,'0000-00-00 00:00:00'),(429,1,0,0,'0000-00-00 00:00:00'),(430,1,0,0,'0000-00-00 00:00:00'),(431,1,0,0,'0000-00-00 00:00:00'),(432,1,0,0,'0000-00-00 00:00:00'),(433,1,0,0,'0000-00-00 00:00:00'),(434,1,0,0,'0000-00-00 00:00:00'),(435,1,0,0,'0000-00-00 00:00:00'),(436,2,0,0,'0000-00-00 00:00:00'),(438,1,0,0,'0000-00-00 00:00:00'),(439,2,0,0,'0000-00-00 00:00:00'),(440,1,0,0,'0000-00-00 00:00:00'),(441,1,0,0,'0000-00-00 00:00:00'),(442,2,0,0,'0000-00-00 00:00:00'),(443,1,0,0,'0000-00-00 00:00:00'),(444,2,0,0,'0000-00-00 00:00:00'),(446,1,0,0,'0000-00-00 00:00:00'),(447,2,0,0,'0000-00-00 00:00:00'),(448,1,0,0,'0000-00-00 00:00:00'),(449,2,0,0,'0000-00-00 00:00:00'),(451,1,0,0,'0000-00-00 00:00:00'),(452,2,0,0,'0000-00-00 00:00:00'),(454,1,0,0,'0000-00-00 00:00:00'),(455,2,0,0,'0000-00-00 00:00:00'),(456,1,0,0,'0000-00-00 00:00:00'),(457,2,0,0,'0000-00-00 00:00:00'),(458,7,4,0,'0000-00-00 00:00:00'),(459,1,0,0,'0000-00-00 00:00:00'),(460,2,0,0,'0000-00-00 00:00:00'),(461,1,0,0,'0000-00-00 00:00:00'),(462,2,0,0,'0000-00-00 00:00:00'),(463,1,0,0,'0000-00-00 00:00:00'),(464,2,0,0,'0000-00-00 00:00:00'),(465,1,0,0,'0000-00-00 00:00:00'),(466,2,0,0,'0000-00-00 00:00:00'),(468,1,0,0,'0000-00-00 00:00:00'),(469,2,0,0,'0000-00-00 00:00:00'),(470,1,0,0,'0000-00-00 00:00:00'),(471,2,0,0,'0000-00-00 00:00:00'),(473,1,0,0,'0000-00-00 00:00:00'),(474,2,0,0,'0000-00-00 00:00:00'),(475,1,0,0,'0000-00-00 00:00:00'),(476,2,0,0,'0000-00-00 00:00:00'),(477,1,0,0,'0000-00-00 00:00:00'),(478,2,0,0,'0000-00-00 00:00:00'),(479,1,0,0,'0000-00-00 00:00:00'),(480,2,0,0,'0000-00-00 00:00:00'),(481,1,0,0,'0000-00-00 00:00:00'),(482,2,0,0,'0000-00-00 00:00:00'),(484,2,0,0,'0000-00-00 00:00:00'),(487,1,0,0,'0000-00-00 00:00:00'),(488,2,0,0,'0000-00-00 00:00:00'),(492,1,0,0,'0000-00-00 00:00:00'),(493,2,0,0,'0000-00-00 00:00:00'),(494,1,0,0,'0000-00-00 00:00:00'),(495,2,0,0,'0000-00-00 00:00:00'),(496,1,0,0,'0000-00-00 00:00:00'),(497,2,0,0,'0000-00-00 00:00:00'),(501,3,3,0,'0000-00-00 00:00:00'),(502,4,3,0,'0000-00-00 00:00:00'),(503,5,3,0,'0000-00-00 00:00:00'),(504,1,0,0,'0000-00-00 00:00:00'),(505,2,0,0,'0000-00-00 00:00:00'),(506,1,0,0,'0000-00-00 00:00:00'),(507,2,0,0,'0000-00-00 00:00:00'),(508,1,0,0,'0000-00-00 00:00:00'),(509,2,0,0,'0000-00-00 00:00:00'),(510,1,0,0,'0000-00-00 00:00:00'),(511,2,0,0,'0000-00-00 00:00:00'),(512,1,0,0,'0000-00-00 00:00:00'),(513,2,0,0,'0000-00-00 00:00:00'),(514,1,0,0,'0000-00-00 00:00:00'),(515,2,0,0,'0000-00-00 00:00:00'),(516,1,0,0,'0000-00-00 00:00:00'),(517,2,0,0,'0000-00-00 00:00:00'),(518,2,0,0,'0000-00-00 00:00:00'),(519,2,0,0,'0000-00-00 00:00:00'),(520,2,0,0,'0000-00-00 00:00:00'),(521,1,0,0,'0000-00-00 00:00:00'),(522,2,0,0,'0000-00-00 00:00:00'),(523,2,0,0,'0000-00-00 00:00:00'),(524,1,0,0,'0000-00-00 00:00:00'),(525,2,0,0,'0000-00-00 00:00:00'),(526,1,0,0,'0000-00-00 00:00:00'),(527,2,0,0,'0000-00-00 00:00:00'),(528,1,0,0,'0000-00-00 00:00:00'),(529,2,0,0,'0000-00-00 00:00:00'),(530,1,0,0,'0000-00-00 00:00:00'),(531,2,0,0,'0000-00-00 00:00:00'),(532,1,0,0,'0000-00-00 00:00:00'),(533,2,0,0,'0000-00-00 00:00:00'),(534,1,0,0,'0000-00-00 00:00:00'),(535,2,0,0,'0000-00-00 00:00:00'),(536,1,0,0,'0000-00-00 00:00:00'),(537,2,0,0,'0000-00-00 00:00:00'),(538,1,0,0,'0000-00-00 00:00:00'),(539,2,0,0,'0000-00-00 00:00:00'),(540,1,0,0,'0000-00-00 00:00:00'),(541,2,0,0,'0000-00-00 00:00:00'),(542,1,0,0,'0000-00-00 00:00:00'),(543,2,0,0,'0000-00-00 00:00:00'),(544,1,0,0,'0000-00-00 00:00:00'),(545,2,0,0,'0000-00-00 00:00:00'),(546,1,0,0,'0000-00-00 00:00:00'),(547,2,0,0,'0000-00-00 00:00:00'),(548,1,0,0,'0000-00-00 00:00:00'),(549,2,0,0,'0000-00-00 00:00:00'),(550,1,0,0,'0000-00-00 00:00:00'),(551,2,0,0,'0000-00-00 00:00:00'),(552,1,0,0,'0000-00-00 00:00:00'),(553,2,0,0,'0000-00-00 00:00:00'),(554,1,0,0,'0000-00-00 00:00:00'),(555,2,0,0,'0000-00-00 00:00:00'),(556,2,0,0,'0000-00-00 00:00:00'),(557,2,0,0,'0000-00-00 00:00:00'),(558,2,0,0,'0000-00-00 00:00:00'),(559,2,0,0,'0000-00-00 00:00:00'),(560,1,0,0,'0000-00-00 00:00:00'),(561,2,0,0,'0000-00-00 00:00:00'),(562,1,0,0,'0000-00-00 00:00:00'),(563,2,0,0,'0000-00-00 00:00:00'),(564,1,0,0,'0000-00-00 00:00:00'),(565,2,0,0,'0000-00-00 00:00:00'),(566,1,0,0,'0000-00-00 00:00:00'),(567,2,0,0,'0000-00-00 00:00:00'),(568,1,0,0,'0000-00-00 00:00:00'),(569,2,0,0,'0000-00-00 00:00:00'),(570,1,0,0,'0000-00-00 00:00:00'),(571,2,0,0,'0000-00-00 00:00:00'),(572,1,0,0,'0000-00-00 00:00:00'),(573,2,0,0,'0000-00-00 00:00:00'),(574,1,0,0,'0000-00-00 00:00:00'),(575,2,0,0,'0000-00-00 00:00:00'),(576,1,0,0,'0000-00-00 00:00:00'),(577,2,0,0,'0000-00-00 00:00:00'),(578,1,0,0,'0000-00-00 00:00:00'),(579,2,0,0,'0000-00-00 00:00:00'),(580,1,0,0,'0000-00-00 00:00:00'),(581,2,0,0,'0000-00-00 00:00:00'),(582,1,0,0,'0000-00-00 00:00:00'),(583,2,0,0,'0000-00-00 00:00:00'),(584,1,0,0,'0000-00-00 00:00:00'),(585,2,0,0,'0000-00-00 00:00:00'),(586,1,0,0,'0000-00-00 00:00:00'),(587,2,0,0,'0000-00-00 00:00:00'),(588,1,0,0,'0000-00-00 00:00:00'),(589,2,0,0,'0000-00-00 00:00:00'),(590,1,0,0,'0000-00-00 00:00:00'),(591,2,0,0,'0000-00-00 00:00:00'),(592,2,0,0,'0000-00-00 00:00:00'),(593,1,0,0,'0000-00-00 00:00:00'),(594,2,0,0,'0000-00-00 00:00:00'),(595,1,0,0,'0000-00-00 00:00:00'),(596,2,0,0,'0000-00-00 00:00:00'),(597,1,0,0,'0000-00-00 00:00:00'),(598,2,0,0,'0000-00-00 00:00:00'),(599,1,0,0,'0000-00-00 00:00:00'),(600,2,0,0,'0000-00-00 00:00:00'),(601,1,0,0,'0000-00-00 00:00:00'),(602,2,0,0,'0000-00-00 00:00:00'),(603,2,0,0,'0000-00-00 00:00:00'),(604,2,0,0,'0000-00-00 00:00:00'),(605,1,0,0,'0000-00-00 00:00:00'),(606,2,0,0,'0000-00-00 00:00:00'),(607,1,0,0,'0000-00-00 00:00:00'),(608,2,0,0,'0000-00-00 00:00:00'),(609,1,0,0,'0000-00-00 00:00:00');
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `recipients`
--
DROP TABLE IF EXISTS `recipients`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `recipients` (
`recipient_id` int(11) NOT NULL auto_increment,
`transmission_id` int(11) NOT NULL,
`contact_list_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
PRIMARY KEY (`recipient_id`),
KEY `FK_recipients_transmissions` (`transmission_id`),
CONSTRAINT `FK_recipients_transmissions` FOREIGN KEY (`transmission_id`) REFERENCES `transmissions` (`transmission_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `recipients`
--
LOCK TABLES `recipients` WRITE;
/*!40000 ALTER TABLE `recipients` DISABLE KEYS */;
/*!40000 ALTER TABLE `recipients` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sendlogs`
--
DROP TABLE IF EXISTS `sendlogs`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sendlogs` (
`sendlog_id` int(11) NOT NULL auto_increment,
`transmission_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
`email` varchar(255) NOT NULL,
`first_name` varchar(255) default NULL,
`last_name` varchar(255) default NULL,
`throttled_domain` varchar(255) NOT NULL,
`assigned_to_host` varchar(255) NOT NULL,
`is_sent` int(11) NOT NULL default '0',
`sent_on` datetime NOT NULL,
`is_successful` double NOT NULL default '-1',
`queued_as` varchar(50) NOT NULL,
PRIMARY KEY (`sendlog_id`),
KEY `FK_sendlogs_transmissions` (`transmission_id`),
KEY `FK_sendlogs_contacts` (`contact_id`),
CONSTRAINT `FK_sendlogs_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE,
CONSTRAINT `FK_sendlogs_transmissions` FOREIGN KEY (`transmission_id`) REFERENCES `transmissions` (`transmission_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `sendlogs`
--
LOCK TABLES `sendlogs` WRITE;
/*!40000 ALTER TABLE `sendlogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `sendlogs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transmissions`
--
DROP TABLE IF EXISTS `transmissions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `transmissions` (
`transmission_id` int(11) NOT NULL auto_increment,
`subject` varchar(255) NOT NULL,
`from_name` varchar(255) NOT NULL,
`from_address` varchar(255) NOT NULL,
`reply_to` varchar(255) NOT NULL,
`content_type` varchar(100) NOT NULL,
`content` longtext NOT NULL,
`is_queued` int(11) NOT NULL,
`queued_on` datetime NOT NULL,
`is_started` int(11) NOT NULL,
`started_on` datetime NOT NULL,
`is_completed` int(11) NOT NULL,
`completed_on` datetime NOT NULL,
`blaster_hostname` varchar(255) default NULL,
PRIMARY KEY (`transmission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `transmissions`
--
LOCK TABLES `transmissions` WRITE;
/*!40000 ALTER TABLE `transmissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmissions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2008-11-30 5:03:44