Blitz
Blitz
Explore posts from servers
DTDrizzle Team
Created by Blitz on 1/8/2024 in #help
Migrations problem
found out that the problem was update statement on updatedAt, but now i don't know how to best perform updatedAt field so that it's working automatically
3 replies
DTDrizzle Team
Created by Blitz on 1/8/2024 in #help
Migrations problem
and lastly my current migration file
CREATE TABLE IF NOT EXISTS "children" (
"cuid" serial PRIMARY KEY NOT NULL,
"createdAt" timestamp DEFAULT now(),
"updatedAt" timestamp DEFAULT CURRENT_TIMESTAMP(3) on update CURRENT_TIMESTAMP(3),
"name" varchar(100) NOT NULL,
"surname" varchar(100) NOT NULL,
"pesel" integer,
"birthDate" date NOT NULL,
"address" text,
"allergies" json,
CONSTRAINT "children_pesel_unique" UNIQUE("pesel")
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "parentToChild" (
"parentId" serial NOT NULL,
"childId" serial NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "users" (
"cuid" serial PRIMARY KEY NOT NULL,
"createdAt" timestamp DEFAULT now(),
"updatedAt" timestamp DEFAULT CURRENT_TIMESTAMP(3) on update CURRENT_TIMESTAMP(3),
"name" varchar(100) NOT NULL,
"surname" varchar(100) NOT NULL,
"pesel" integer,
"address" text,
"personalIdentification" varchar,
"password" varchar NOT NULL,
"email" varchar NOT NULL,
"isActive" boolean DEFAULT true NOT NULL,
CONSTRAINT "users_pesel_unique" UNIQUE("pesel"),
CONSTRAINT "users_personalIdentification_unique" UNIQUE("personalIdentification"),
CONSTRAINT "users_email_unique" UNIQUE("email")
);
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "parentToChild" ADD CONSTRAINT "parentToChild_parentId_users_cuid_fk" FOREIGN KEY ("parentId") REFERENCES "public"."users"("cuid") ON DELETE no action ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "parentToChild" ADD CONSTRAINT "parentToChild_childId_children_cuid_fk" FOREIGN KEY ("childId") REFERENCES "public"."children"("cuid") ON DELETE no action ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
CREATE TABLE IF NOT EXISTS "children" (
"cuid" serial PRIMARY KEY NOT NULL,
"createdAt" timestamp DEFAULT now(),
"updatedAt" timestamp DEFAULT CURRENT_TIMESTAMP(3) on update CURRENT_TIMESTAMP(3),
"name" varchar(100) NOT NULL,
"surname" varchar(100) NOT NULL,
"pesel" integer,
"birthDate" date NOT NULL,
"address" text,
"allergies" json,
CONSTRAINT "children_pesel_unique" UNIQUE("pesel")
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "parentToChild" (
"parentId" serial NOT NULL,
"childId" serial NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "users" (
"cuid" serial PRIMARY KEY NOT NULL,
"createdAt" timestamp DEFAULT now(),
"updatedAt" timestamp DEFAULT CURRENT_TIMESTAMP(3) on update CURRENT_TIMESTAMP(3),
"name" varchar(100) NOT NULL,
"surname" varchar(100) NOT NULL,
"pesel" integer,
"address" text,
"personalIdentification" varchar,
"password" varchar NOT NULL,
"email" varchar NOT NULL,
"isActive" boolean DEFAULT true NOT NULL,
CONSTRAINT "users_pesel_unique" UNIQUE("pesel"),
CONSTRAINT "users_personalIdentification_unique" UNIQUE("personalIdentification"),
CONSTRAINT "users_email_unique" UNIQUE("email")
);
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "parentToChild" ADD CONSTRAINT "parentToChild_parentId_users_cuid_fk" FOREIGN KEY ("parentId") REFERENCES "public"."users"("cuid") ON DELETE no action ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "parentToChild" ADD CONSTRAINT "parentToChild_childId_children_cuid_fk" FOREIGN KEY ("childId") REFERENCES "public"."children"("cuid") ON DELETE no action ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
3 replies