Re: [Postfixadmin-devel] mysql table structure for vacation and vacation_notication (version 2.2.1.1)

[David G. <da...@co...>]

Dyks, Axel wrote :
> Hi,
> 
> could someone with a running 2.2.1.1 installation of postfixadmin be so
> nice and post the mysql table structure (including indexes and such)
> for the tables "vacation" and "vacation_notification".
> 
> I'm in the "lucky" position to implement "vacation" (o-o-o) on top
> of an existing postfix virtual mailbox installation and I want to
> use as much of postfixadmin's "vacation" feature as possible.
> 
> Thank you very much
> 
> Axel

CREATE TABLE `vacation_notification` (
`on_vacation` varchar(255) NOT NULL,
`notified` varchar(255) NOT NULL,
`notified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`on_vacation`,`notified`),
CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation Notifications'

CREATE TABLE `vacation` (
`email` varchar(255) NOT NULL,
`subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`cache` text NOT NULL,
`domain` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`email`),
KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
COMMENT='Postfix Admin - Virtual Vacation'


Hope that helps,
thanks
David.

-- 
David Goodwin 

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]