#
# "delicious"
#
CREATE TABLE `delicious` (
  `id` int(11) NOT NULL auto_increment,
  `url` text,
  `tags` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;


#
# "delicious fulltext"
#
CREATE TABLE `delicious` (
  `id` int(11) NOT NULL auto_increment,
  `url` text,
  `tags` text,
   PRIMARY KEY  (`id`),
   FULLTEXT tags_index (tags)
) TYPE=MyISAM;

#
# "scuttle"
#
CREATE TABLE `bookmark` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255),
  PRIMARY KEY  (`id`),
  KEY `scuttle_url` (`url`)
) TYPE=MyISAM;
CREATE TABLE `tag` (
  `id` int(11) NOT NULL auto_increment,
  `bookmark_id` int(11),
  `tag` varchar(20),
  PRIMARY KEY  (`id`),
  KEY `scuttle_tag` (`tag`),
  KEY `scuttle_bookmark` (`bookmark_id`)
) TYPE=MyISAM;

#
# "toxi"
#
CREATE TABLE `bookmark` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `url` varchar(255),
  PRIMARY KEY  (`id`),
  KEY `url` (`url`)
) TYPE=MyISAM;
CREATE TABLE `tag` (
  `id` int(11) NOT NULL auto_increment,
  `tag` varchar(255),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `tag` (`tag`)
) TYPE=MyISAM;
CREATE TABLE `tagmap` (
  `id` int(11) NOT NULL auto_increment,
  `bookmark_id` int(11),
  `tag_id` int(11),
  PRIMARY KEY  (`id`),
  KEY `bookmark` (`bookmark_id`),
  KEY `tag` (`tag_id`)
) TYPE=MyISAM;