Miscellany

-- --------------------------------------------------------

--
-- Table structure for table `uri`
--

CREATE TABLE IF NOT EXISTS `uri` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `scheme` int(10) unsigned NOT NULL,
  `host` int(10) unsigned NOT NULL,
  `port` int(10) unsigned NOT NULL,
  `path` int(10) unsigned NOT NULL,
  `query` int(10) unsigned NOT NULL,
  `fragment` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `scheme` (`scheme`,`host`,`port`,`path`,`query`,`fragment`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `uri_fragment`
--

CREATE TABLE IF NOT EXISTS `uri_fragment` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fragment` tinytext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fragment` (`fragment`(100))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `uri_host`
--

CREATE TABLE IF NOT EXISTS `uri_host` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `host` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `host` (`host`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `uri_path`
--

CREATE TABLE IF NOT EXISTS `uri_path` (
  `id` int(11) NOT NULL auto_increment,
  `path` tinytext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `path` (`path`(100))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `uri_query`
--

CREATE TABLE IF NOT EXISTS `uri_query` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `query` tinytext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `query` (`query`(100))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `uri_scheme`
--

CREATE TABLE IF NOT EXISTS `uri_scheme` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `scheme` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `scheme` (`scheme`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;