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