earthquakes.sql

-- ----------------------------
-- Table structure for earthquakes
-- ----------------------------
DROP TABLE IF EXISTS `earthquakes`;
CREATE TABLE `earthquakes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `latitude` double(8,2) NOT NULL,
  `longitude` double(8,2) NOT NULL,
  `depth` double(8,2) NOT NULL,
  `md` double(8,2) DEFAULT NULL,
  `ml` double(8,2) NOT NULL,
  `mw` double(8,2) DEFAULT NULL,
  `region` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `happened_at` timestamp NOT NULL,
  `hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;