DROP TABLE IF EXISTS cache;

CREATE TABLE `cache` (
  `last_refresh` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `cache` (`last_refresh`) VALUES 
('2012-01-01 12:00:00');

DROP TABLE IF EXISTS bills;

CREATE TABLE `bills` (
  `number` varchar(40) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `year` varchar(4) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `url` varchar(1000) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `current_chamber` varchar(40) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(40) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `date_introduced` date NOT NULL,
  `outcome` varchar(40) CHARSET utf8 COLLATE utf8_general_ci default NULL,
  `title` varchar(1000) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `summary` varchar(10000) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `text` text CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `tags` varchar(1000) CHARSET utf8 COLLATE utf8_general_ci default NULL,
  `patron_name` varchar(100) CHARSET utf8 COLLATE utf8_general_ci default NULL,
  `patron_id` varchar(40) CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_notes` text CHARSET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY  (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;