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