#!/usr/local/bin/php

//
// Database configuration
//
private $hostname = "mydatabasehost";
private $username = "openvacation";
private $password = "mypassword";
private $database = "openvacation";
private $tbl_vacation_cache = "mail_vacation_cache";
private $tbl_vacation_prefs = "mail_vacation_prefs";
//
// Vacation's related stuff
//
private $cache_time = "INTERVAL 1 DAY";

CREATE DATABASE openvacation;
USE openvacation;

CREATE TABLE `mail_vacation_cache` (
   `id` int(32) unsigned NOT NULL auto_increment,
   `recipient` varchar(128) NOT NULL default ,
   `sender` varchar(128) NOT NULL default ,
   `cache` datetime default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `recipient` (`recipient`,`sender`),
   KEY `recipient_2` (`recipient`,`sender`)
);

CREATE TABLE `mail_vacation_prefs` (
   `id` int(32) unsigned NOT NULL auto_increment,
   `login` varchar(128) NOT NULL default ,
   `vacation_text` text,
   `vacation_subject` varchar(128) NOT NULL default ,
   `initHour` time NOT NULL default '18:00:00',
   `countHour` tinyint(2) NOT NULL default '14',
   `active` enum('0','1') NOT NULL default '1',
   PRIMARY KEY  (`id`),
   KEY `login` (`login`)
);

GRANT USAGE ON *.* TO 'openvacation'@'seu-servidor-mysql' IDENTIFIED BY 'mypassword';
GRANT SELECT, INSERT, UPDATE (cache) ON `openvacation`.`mail_vacation_cache` TO 'openvacation'@'seu-servidor-mysql';
GRANT SELECT ON `openvacation`.`mail_vacation_prefs` TO 'openvacation'@'seu-servidor-mysql';

INSERT INTO mail_vacation_prefs (login, vacation_text, vacation_subject) VALUES ('somelogin@mydomain.tld', 'Sorry, I cant anwser you now ...', 'My vacation ...');