DROP TABLE IF EXISTS tng_cemeteries;
CREATE TABLE `tng_cemeteries` (
  `cemeteryID` int(11) NOT NULL AUTO_INCREMENT,
  `cemname` varchar(64) NOT NULL,
  `maplink` varchar(255) NOT NULL,
  `city` varchar(64) DEFAULT NULL,
  `county` varchar(64) DEFAULT NULL,
  `state` varchar(64) DEFAULT NULL,
  `country` varchar(64) DEFAULT NULL,
  `longitude` varchar(22) DEFAULT NULL,
  `latitude` varchar(22) DEFAULT NULL,
  `zoom` tinyint(4) DEFAULT NULL,
  `notes` text,
  `place` varchar(248) NOT NULL,
  PRIMARY KEY (`cemeteryID`),
  KEY `cemname` (`cemname`),
  KEY `place` (`place`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
