sbd2Sz1E

1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `review`;
9CREATE TABLE `review` (
10  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
11  `product_id` int(10) unsigned NOT NULL,
12  `user_id` int(10) unsigned NOT NULL,
13  `review` text COLLATE utf8_unicode_ci NOT NULL,
14  `rating` int(11) NOT NULL DEFAULT '1',
15  `created_at` timestamp NULL DEFAULT NULL,
16  `updated_at` timestamp NULL DEFAULT NULL,
17  PRIMARY KEY (`id`),
18  KEY `review_product_id_foreign` (`product_id`),
19  KEY `review_user_id_foreign` (`user_id`),
20  CONSTRAINT `review_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
21  CONSTRAINT `review_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
22) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
23
24
25-- 2018-12-31 04:41:08