· 8 years ago · Mar 25, 2018, 12:04 PM
1CREATE TABLE IF NOT EXISTS `reviews` (
2 `id` int(11) NOT NULL,
3 `course_id` int(11) NOT NULL,
4 `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5 `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
6 `rating` double NOT NULL,
7 `created` datetime NOT NULL,
8 `modified` datetime NOT NULL,
9 `user_id` int(11) NOT NULL
10) ENGINE=InnoDB;