· 4 years ago · Apr 13, 2021, 04:24 PM
1DROP DATABASE IF EXISTS `ideas`;
2CREATE DATABASE IF NOT EXISTS `ideas`;
3ALTER DATABASE ideas CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
4
5USE `ideas`;
6
7DROP TABLE IF EXISTS `ideas`;
8
9CREATE TABLE `posts` (
10 `id` CHAR(36) NOT NULL,
11 `title` VARCHAR(255) NOT NULL,
12 `description` VARCHAR(255) NOT NULL,
13 `keyword` VARCHAR(255) NOT NULL,
14 PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
16