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