t3-code-android-nightly/.repos/alchemy-effect/examples/cloudflare-d1-drizzle/migrations/20260721033159_fantastic_bloodaxe/migration.sql
Julius Marminge 108e01746c
Upgrade Effect and Alchemy betas (#4643)
Prepare Relay production infrastructure for the PlanetScale PS_20 HA topology, upgrade Effect and Alchemy to compatible betas, reconcile migration state, and preserve patched MCP session termination behavior.\n\nCo-authored-by: codex <codex@users.noreply.github.com>
2026-07-27 16:21:02 +02:00

15 lines
506 B
SQL

CREATE TABLE `posts` (
`id` integer PRIMARY KEY AUTOINCREMENT,
`user_id` integer NOT NULL,
`title` text NOT NULL,
`body` text NOT NULL,
`created_at` integer DEFAULT (unixepoch()) NOT NULL,
CONSTRAINT `fk_posts_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
);
--> statement-breakpoint
CREATE TABLE `users` (
`id` integer PRIMARY KEY AUTOINCREMENT,
`email` text NOT NULL UNIQUE,
`name` text NOT NULL,
`created_at` integer DEFAULT (unixepoch()) NOT NULL
);