From 811458427593a4172a2cd535cc768db375350dca Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sat, 6 Dec 2025 17:05:21 +0900 Subject: feat(dev): change architecture and directory structure --- pkgs/server/drizzle/0000_cynical_zeigeist.sql | 58 --------------------------- 1 file changed, 58 deletions(-) delete mode 100644 pkgs/server/drizzle/0000_cynical_zeigeist.sql (limited to 'pkgs/server/drizzle/0000_cynical_zeigeist.sql') diff --git a/pkgs/server/drizzle/0000_cynical_zeigeist.sql b/pkgs/server/drizzle/0000_cynical_zeigeist.sql deleted file mode 100644 index 3034102..0000000 --- a/pkgs/server/drizzle/0000_cynical_zeigeist.sql +++ /dev/null @@ -1,58 +0,0 @@ -CREATE TABLE "cards" ( - "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL, - "deck_id" uuid NOT NULL, - "front" text NOT NULL, - "back" text NOT NULL, - "state" smallint DEFAULT 0 NOT NULL, - "due" timestamp with time zone DEFAULT now() NOT NULL, - "stability" real DEFAULT 0 NOT NULL, - "difficulty" real DEFAULT 0 NOT NULL, - "elapsed_days" integer DEFAULT 0 NOT NULL, - "scheduled_days" integer DEFAULT 0 NOT NULL, - "reps" integer DEFAULT 0 NOT NULL, - "lapses" integer DEFAULT 0 NOT NULL, - "last_review" timestamp with time zone, - "created_at" timestamp with time zone DEFAULT now() NOT NULL, - "updated_at" timestamp with time zone DEFAULT now() NOT NULL, - "deleted_at" timestamp with time zone, - "sync_version" integer DEFAULT 0 NOT NULL -); ---> statement-breakpoint -CREATE TABLE "decks" ( - "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL, - "user_id" uuid NOT NULL, - "name" varchar(255) NOT NULL, - "description" text, - "new_cards_per_day" integer DEFAULT 20 NOT NULL, - "created_at" timestamp with time zone DEFAULT now() NOT NULL, - "updated_at" timestamp with time zone DEFAULT now() NOT NULL, - "deleted_at" timestamp with time zone, - "sync_version" integer DEFAULT 0 NOT NULL -); ---> statement-breakpoint -CREATE TABLE "review_logs" ( - "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL, - "card_id" uuid NOT NULL, - "user_id" uuid NOT NULL, - "rating" smallint NOT NULL, - "state" smallint NOT NULL, - "scheduled_days" integer NOT NULL, - "elapsed_days" integer NOT NULL, - "reviewed_at" timestamp with time zone DEFAULT now() NOT NULL, - "duration_ms" integer, - "sync_version" integer DEFAULT 0 NOT NULL -); ---> statement-breakpoint -CREATE TABLE "users" ( - "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL, - "username" varchar(255) NOT NULL, - "password_hash" varchar(255) NOT NULL, - "created_at" timestamp with time zone DEFAULT now() NOT NULL, - "updated_at" timestamp with time zone DEFAULT now() NOT NULL, - CONSTRAINT "users_username_unique" UNIQUE("username") -); ---> statement-breakpoint -ALTER TABLE "cards" ADD CONSTRAINT "cards_deck_id_decks_id_fk" FOREIGN KEY ("deck_id") REFERENCES "public"."decks"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint -ALTER TABLE "decks" ADD CONSTRAINT "decks_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint -ALTER TABLE "review_logs" ADD CONSTRAINT "review_logs_card_id_cards_id_fk" FOREIGN KEY ("card_id") REFERENCES "public"."cards"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint -ALTER TABLE "review_logs" ADD CONSTRAINT "review_logs_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE no action ON UPDATE no action; \ No newline at end of file -- cgit v1.2.3-70-g09d2