1CREATE TABLE `posts` (
2 `id` integer PRIMARY KEY AUTOINCREMENT,
3 `user_id` integer NOT NULL,
4 `title` text NOT NULL,
5 `body` text NOT NULL,
6 `created_at` integer DEFAULT (unixepoch()) NOT NULL,
7 CONSTRAINT `fk_posts_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
8);
9--> statement-breakpoint
10CREATE TABLE `users` (
11 `id` integer PRIMARY KEY AUTOINCREMENT,
12 `email` text NOT NULL UNIQUE,
13 `name` text NOT NULL,
14 `created_at` integer DEFAULT (unixepoch()) NOT NULL
15);