1CREATE TABLE `posts` (
2 `id` int AUTO_INCREMENT PRIMARY KEY,
3 `user_id` int NOT NULL,
4 `title` varchar(255) NOT NULL,
5 `body` varchar(4096) NOT NULL,
6 `created_at` timestamp NOT NULL DEFAULT (now())
7);
8--> statement-breakpoint
9CREATE TABLE `users` (
10 `id` int AUTO_INCREMENT PRIMARY KEY,
11 `email` varchar(255) NOT NULL,
12 `name` varchar(255) NOT NULL,
13 `created_at` timestamp NOT NULL DEFAULT (now()),
14 CONSTRAINT `email_unique` UNIQUE INDEX(`email`)
15);