CREATE DATABASE `test`;
USE `test`;

DROP TABLE IF EXISTS `uri`;
CREATE TABLE `uri` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `value` varchar(254) NOT NULL default '',
  `a` datetime NOT NULL default '0000-00-00 00:00:00',
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `value` (`value`),
  KEY `t` (`t`),
  KEY `uricache` (`value`,`t`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COMMENT='uri table';

--
-- Table structure for table `uri_scrape_count`
--

DROP TABLE IF EXISTS `uri_scrape_count`;
CREATE TABLE `uri_scrape_count` (
  `id` int(10) unsigned NOT NULL default '0',
  `value` int(6) NOT NULL default '0',
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `id` (`id`),
  KEY `value` (`value`),
  KEY `t` (`t`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COMMENT='track number of scrapes on this site.';