· 8 years ago · Jul 10, 2018, 03:36 PM
1CREATE DATABASE IF NOT EXISTS `go-mysql-crud` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
2USE `go-mysql-crud`;
3
4/* Create table for `posts` */
5
6DROP TABLE IF EXISTS `posts`;
7CREATE TABLE `posts` (
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
10 `content` longtext COLLATE utf8_unicode_ci NOT NULL,
11 PRIMARY KEY (`id`)
12);