Untangld database schema

gistfile1.sql

CREATE TABLE `entities` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('PERSON','PLACE','BUSINESS','MUNICIPALITY') DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `url` varchar(256) DEFAULT NULL,
  `prevurl` varchar(256) DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

CREATE TABLE `relationships` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fromID` int(11) DEFAULT NULL,
  `to` int(11) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;