Yke4qjaa

1DROP TABLE IF EXISTS `shops`;
2CREATE TABLE `shops` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
6  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
7  `address` longtext COLLATE utf8mb4_unicode_ci,
8  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
9  `latitude` decimal(10,7) DEFAULT '0.0000000',
10  `longitude` decimal(10,7) DEFAULT '0.0000000',
11  `verification_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
12  `description` longtext COLLATE utf8mb4_unicode_ci,
13  `user_id` int(10) unsigned NOT NULL,
14  `created_at` timestamp NULL DEFAULT NULL,
15  `updated_at` timestamp NULL DEFAULT NULL,
16  PRIMARY KEY (`id`),
17  UNIQUE KEY `shops_email_unique` (`email`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;