· 8 years ago · Apr 24, 2018, 07:30 AM
1DROP TABLE IF EXISTS `bids`;
2CREATE TABLE `bids` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `project_id` int(11) DEFAULT NULL,
5 `hourly_rate` int(11) NOT NULL DEFAULT '0',
6 `estimated_time` double(8,2) NOT NULL DEFAULT '0.00',
7 `user_id` int(11) DEFAULT NULL,
8 `status` int(11) NOT NULL DEFAULT '1',
9 `created_at` timestamp NULL DEFAULT NULL,
10 `updated_at` timestamp NULL DEFAULT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;