dgSzJ0tb

1
2DROP TABLE IF EXISTS `tags`;
3CREATE TABLE `tags` (
4  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5  `tag` text COLLATE utf8mb4_unicode_ci NOT NULL,
6  `created_at` timestamp NULL DEFAULT NULL,
7  `updated_at` timestamp NULL DEFAULT NULL,
8  PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
10
11
12DROP TABLE IF EXISTS `tattoos`;
13CREATE TABLE `tattoos` (
14  `tattoo_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
15  `user_id` int(10) unsigned NOT NULL,
16  `tattoo_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
17  `slug` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
18  `tattoo_subject` text COLLATE utf8mb4_unicode_ci,
19  `tattoo_description` longtext COLLATE utf8mb4_unicode_ci,
20  `tattoo_style` int(11) DEFAULT NULL,
21  `tattoo_type` int(11) DEFAULT '1',
22  `original_image` text COLLATE utf8mb4_unicode_ci,
23  `tattoo_tags` longtext COLLATE utf8mb4_unicode_ci,
24  `created_at` timestamp NULL DEFAULT NULL,
25  `updated_at` timestamp NULL DEFAULT NULL,
26  PRIMARY KEY (`tattoo_id`),
27  FULLTEXT KEY `tattoos_search` (`tattoo_title`,`tattoo_subject`,`tattoo_description`,`tattoo_tags`)
28) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;