-- MySQL dump For LiveOffice
--
-- 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;

--
-- Table structure for table `backup`
--

DROP TABLE IF EXISTS `backup`;
CREATE TABLE `backup` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `addressbook` tinyint(1) unsigned NOT NULL default '1',
  `organizer` tinyint(1) unsigned NOT NULL default '1',
  `document` tinyint(1) unsigned NOT NULL default '1',
  `todo` tinyint(1) unsigned NOT NULL default '1',
  `bookmark` tinyint(1) unsigned NOT NULL default '1',
  `date_created` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `bookmark_cache`
--

DROP TABLE IF EXISTS `bookmark_cache`;
CREATE TABLE `bookmark_cache` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `public_id` varchar(255) default NULL,
  `visibility` enum('private','public') default 'private',
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `bookmark_category`
--

DROP TABLE IF EXISTS `bookmark_category`;
CREATE TABLE `bookmark_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(18) NOT NULL default '',
  `parent_id` int(10) unsigned NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `bookmark_url`
--

DROP TABLE IF EXISTS `bookmark_url`;
CREATE TABLE `bookmark_url` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `fk_category_id` int(10) unsigned NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `budget`
--

DROP TABLE IF EXISTS `budget`;
CREATE TABLE `budget` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `in` float(10,2) NOT NULL default '0.00',
  `out` float(10,2) NOT NULL default '0.00',
  `category` smallint(5) unsigned NOT NULL default '0',
  `transaction_id` varchar(255) NOT NULL default '',
  `payment_type` smallint(5) NOT NULL default '0',
  `details` text NOT NULL,
  `note` text NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `code` smallint(5) unsigned NOT NULL default '0',
  `value` varchar(50) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `property` varchar(255) default NULL,
  `visibility` varchar(50) default NULL,
  PRIMARY KEY  (`code`,`value`(15))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES (100,'en','English',NULL,NULL),(100,'fr','Français',NULL,NULL),(101,'default','Default',NULL,NULL),(50,'about','','1',NULL),(50,'addressbook','module','3','desktop'),(50,'backup','','1',NULL),(50,'bookmark','module','1','desktop'),(50,'comic','widget','1',NULL),(50,'currency','widget','1',NULL),(50,'dashboard','','1',NULL),(50,'document','module','3','desktop'),(50,'home','','1',NULL),(50,'news','module','1','desktop'),(50,'note','module','3',NULL),(50,'organizer','module','3','desktop'),(50,'preference','','1',NULL),(50,'todo','module','3','desktop'),(50,'traffic','widget','1',NULL),(50,'trash','','1',NULL),(50,'weather','widget','1',NULL),(50,'budget','module','3','desktop'),(50,'stockmarket','widget','1',NULL);

--
-- Table structure for table `document_file`
--

DROP TABLE IF EXISTS `document_file`;
CREATE TABLE `document_file` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_folder_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `ext` varchar(5) NOT NULL default 'nkw',
  `size` bigint(20) NOT NULL default '0',
  `mime` varchar(50) NOT NULL default 'unknow',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `visibility` enum('private','public') default 'private',
  `information` 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 `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `source` varchar(25) NOT NULL default '',
  `url` varchar(255) default NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `note`
--

DROP TABLE IF EXISTS `note`;
CREATE TABLE `note` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `desc` varchar(100) NOT NULL default '',
  `pos_x` smallint(5) NOT NULL default '100',
  `pos_y` smallint(5) NOT NULL default '100',
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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;

--
-- Table structure for table `session`
--

DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
  `id` char(32) NOT NULL,
  `data` mediumtext,
  `expires` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `todo`
--

DROP TABLE IF EXISTS `todo`;
CREATE TABLE `todo` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `desc` varchar(18) NOT NULL default '',
  `priority` enum('urgent','high','normal','low') default 'normal',
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) NOT NULL,
  `password` char(32) NOT NULL,
  `first_name` varchar(40) default NULL,
  `last_name` varchar(50) default NULL,
  `bday` date default NULL,
  `phone` varchar(14) default NULL,
  `provider` varchar(80) default NULL,
  `background_image` varchar(255) default '',
  `background_color` char(6) default '346793',
  `start_hour` tinyint(2) NOT NULL default '8',
  `end_hour` tinyint(2) NOT NULL default '17',
  `widget_traffic` varchar(7) default NULL,
  `widget_weather` varchar(7) default NULL,
  `widget_comic` varchar(10) default 'ga',
  `time_format` tinyint(2) NOT NULL default '12',
  `default_color` char(6) default 'FFFFFF',
  `duration` tinyint(3) default '30',
  `theme` varchar(40) NOT NULL default 'default',
  `lang` char(2) NOT NULL default 'en',
  `reminder_birthday` tinyint(1) NOT NULL default '1',
  `desktop_click` tinyint(1) NOT NULL default '0',
  `ip_filtering_1` varchar(20) NOT NULL default '',
  `ip_filtering_2` varchar(20) NOT NULL default '',
  `ip_filtering_3` varchar(20) NOT NULL default '',
  `ip_filtering_global` tinyint(3) unsigned NOT NULL default '1',
  `public_key_organizer` varchar(255) NOT NULL default '',
  `public_key_addressbook` varchar(255) NOT NULL default '',
  `public_key_document` varchar(255) NOT NULL default '',
  `public_key_bookmark` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `user` (`username`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `user_registration`
--

DROP TABLE IF EXISTS `user_registration`;
CREATE TABLE `user_registration` (
  `username` varchar(200) NOT NULL,
  `first_name` varchar(40) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;