--
-- Table structure for table `organizer`
--

DROP TABLE IF EXISTS `organizer`;
CREATE TABLE `organizer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` enum('appointment','meeting','event') NOT NULL default 'appointment',
  `title` varchar(25) NOT NULL default '',
  `start_date` date NOT NULL default '0000-00-00',
  `start_time` time NOT NULL default '00:00:00',
  `location` varchar(30) NOT NULL default '',
  `duration` smallint(5) default '30',
  `category` enum('personal','work','specialevent','confidential','other') NOT NULL default 'personal',
  `priority` enum('low','normal','high','urgent') NOT NULL default 'normal',
  `disponibility` enum('free','busy','tentative','notavailable') default 'notavailable',
  `visibility` enum('private','public') default 'private',
  `reminder` enum('5','15','30','60','120','1440','2880') default '5',
  `color` char(6) NOT NULL default 'FFFFFF',
  `note` text,
  `public_id` varchar(255) default NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `organizer_attendees`
--

DROP TABLE IF EXISTS `organizer_attendees`;
CREATE TABLE `organizer_attendees` (
  `fk_organizer_id` int(10) unsigned NOT NULL,
  `fk_addressbook_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`fk_organizer_id`,`fk_addressbook_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `organizer_reminder`
--

DROP TABLE IF EXISTS `organizer_reminder`;
CREATE TABLE `organizer_reminder` (
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `organizer_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`organizer_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;