Lxi0UDMi

1CREATE TABLE IF NOT EXISTS `vacation` (
2  `email` varchar(255) NOT NULL,
3  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,
4  `body` text CHARACTER SET utf8 NOT NULL,
5  `cache` text NOT NULL,
6  `domain` varchar(255) NOT NULL,
7  `created` datetime NOT NULL,
8  `active` tinyint(1) NOT NULL DEFAULT '1',
9  `start_date` datetime NOT NULL,
10  `end_date` datetime NOT NULL,
11  `send_date_range` int(1) NOT NULL,
12  PRIMARY KEY (`email`),
13  KEY `email` (`email`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation';
15
16CREATE TABLE IF NOT EXISTS `vacation_notification` (
17  `on_vacation` varchar(255) CHARACTER SET latin1 NOT NULL,
18  `notified` varchar(255) CHARACTER SET latin1 NOT NULL,
19  `notified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
20  PRIMARY KEY (`on_vacation`,`notified`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';