H8tRR5SB

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `bids`;
7CREATE TABLE `bids` (
8  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9  `project_id` int(11) DEFAULT NULL,
10  `hourly_rate` int(11) NOT NULL DEFAULT '0',
11  `estimated_time` double(8,2) NOT NULL DEFAULT '0.00',
12  `user_id` int(11) DEFAULT NULL,
13  `status` int(11) NOT NULL DEFAULT '1',
14  `created_at` timestamp NULL DEFAULT NULL,
15  `updated_at` timestamp NULL DEFAULT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
18
19
20DROP TABLE IF EXISTS `projects`;
21CREATE TABLE `projects` (
22  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
23  `project_visibility` int(11) NOT NULL DEFAULT '0',
24  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
25  `tattoo_style` int(11) NOT NULL DEFAULT '0',
26  `description` longtext COLLATE utf8mb4_unicode_ci,
27  `timeline` longtext COLLATE utf8mb4_unicode_ci,
28  `longitude` decimal(10,7) NOT NULL DEFAULT '0.0000000',
29  `latitude` decimal(10,7) NOT NULL DEFAULT '0.0000000',
30  `inspirations` longtext COLLATE utf8mb4_unicode_ci,
31  `user_id` int(10) unsigned NOT NULL,
32  `status` int(11) NOT NULL DEFAULT '1',
33  `created_at` timestamp NULL DEFAULT NULL,
34  `updated_at` timestamp NULL DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
37
38
39DROP TABLE IF EXISTS `project_requests`;
40CREATE TABLE `project_requests` (
41  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
42  `project_id` int(11) NOT NULL,
43  `artist_id` int(11) NOT NULL,
44  `status` int(11) NOT NULL DEFAULT '0',
45  `created_at` timestamp NULL DEFAULT NULL,
46  `updated_at` timestamp NULL DEFAULT NULL,
47  PRIMARY KEY (`id`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;