Skip to content

Instantly share code, notes, and snippets.

@ilyasozkurt
Created Sep 24, 2021
Embed
What would you like to do?
-- ----------------------------
-- 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment