From 811458427593a4172a2cd535cc768db375350dca Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 6 Dec 2025 17:05:21 +0900
Subject: feat(dev): change architecture and directory structure

---
 drizzle/0001_spotty_jane_foster.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 drizzle/0001_spotty_jane_foster.sql

(limited to 'drizzle/0001_spotty_jane_foster.sql')

diff --git a/drizzle/0001_spotty_jane_foster.sql b/drizzle/0001_spotty_jane_foster.sql
new file mode 100644
index 0000000..417408f
--- /dev/null
+++ b/drizzle/0001_spotty_jane_foster.sql
@@ -0,0 +1,9 @@
+CREATE TABLE "refresh_tokens" (
+	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
+	"user_id" uuid NOT NULL,
+	"token_hash" varchar(255) NOT NULL,
+	"expires_at" timestamp with time zone NOT NULL,
+	"created_at" timestamp with time zone DEFAULT now() NOT NULL
+);
+--> statement-breakpoint
+ALTER TABLE "refresh_tokens" ADD CONSTRAINT "refresh_tokens_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

