--
-- Table structure for table `addressbook`
--

DROP TABLE IF EXISTS `addressbook`;
CREATE TABLE `addressbook` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `prefix` enum('mr','mrs','ms') NOT NULL default 'mr',
  `last_name` varchar(25) NOT NULL default '',
  `first_name` varchar(30) NOT NULL default '',
  `company` varchar(120) NOT NULL default '',
  `birthday` date NOT NULL default '0000-00-00',
  `group` enum('personal','work','other') default NULL,
  `street` varchar(40) NOT NULL default '',
  `city` varchar(40) NOT NULL default '',
  `state` varchar(30) NOT NULL default '',
  `zip` varchar(7) NOT NULL default '',
  `country` varchar(40) NOT NULL default '',
  `home_phone` varchar(14) NOT NULL default '',
  `work_phone` varchar(14) NOT NULL default '',
  `cell_phone` varchar(14) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `www` varchar(250) NOT NULL,
  `favorite` tinyint(1) NOT NULL default '0',
  `visibility` enum('private','public') default 'private',
  `public_id` varchar(255) default NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `favorite` (`favorite`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `addressbook_bday_reminder`
--

DROP TABLE IF EXISTS `addressbook_bday_reminder`;
CREATE TABLE `addressbook_bday_reminder` (
  `day` tinyint(3) unsigned NOT NULL,
  `month` tinyint(3) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`user_id`,`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;