import { MigrateUpArgs, MigrateDownArgs, sql } from '@payloadcms/db-vercel-postgres'
export async function up({ db, payload, req }: MigrateUpArgs): Promise<void> {
 await db.execute(sql`
 ALTER TABLE "users_sessions" DISABLE ROW LEVEL SECURITY;
 ALTER TABLE "users_verification_tokens" DISABLE ROW LEVEL SECURITY;
 DROP TABLE "users_sessions" CASCADE;
 DROP TABLE "users_verification_tokens" CASCADE;
 CREATE INDEX IF NOT EXISTS "users_accounts_provider_account_id_idx" ON "users_accounts" USING btree ("provider_account_id");
 CREATE UNIQUE INDEX IF NOT EXISTS "users_email_idx" ON "users" USING btree ("email");`)
}
export async function down({ db, payload, req }: MigrateDownArgs): Promise<void> {
 await db.execute(sql`
 CREATE TABLE IF NOT EXISTS "users_sessions" (
 	"_order" integer NOT NULL,
 	"_parent_id" varchar NOT NULL,
 	"id" varchar PRIMARY KEY NOT NULL,
 	"session_token" varchar NOT NULL,
 	"expires" timestamp(3) with time zone NOT NULL
 );
 
 CREATE TABLE IF NOT EXISTS "users_verification_tokens" (
 	"_order" integer NOT NULL,
 	"_parent_id" varchar NOT NULL,
 	"id" varchar PRIMARY KEY NOT NULL,
 	"token" varchar NOT NULL,
 	"expires" timestamp(3) with time zone NOT NULL
 );
 
 DROP INDEX IF EXISTS "users_accounts_provider_account_id_idx";
 DROP INDEX IF EXISTS "users_email_idx";
 DO $$ BEGIN
 ALTER TABLE "users_sessions" ADD CONSTRAINT "users_sessions_parent_id_fk" FOREIGN KEY ("_parent_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;
 EXCEPTION
 WHEN duplicate_object THEN null;
 END $$;
 
 DO $$ BEGIN
 ALTER TABLE "users_verification_tokens" ADD CONSTRAINT "users_verification_tokens_parent_id_fk" FOREIGN KEY ("_parent_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;
 EXCEPTION
 WHEN duplicate_object THEN null;
 END $$;
 
 CREATE INDEX IF NOT EXISTS "users_sessions_order_idx" ON "users_sessions" USING btree ("_order");
 CREATE INDEX IF NOT EXISTS "users_sessions_parent_id_idx" ON "users_sessions" USING btree ("_parent_id");
 CREATE INDEX IF NOT EXISTS "users_verification_tokens_order_idx" ON "users_verification_tokens" USING btree ("_order");
 CREATE INDEX IF NOT EXISTS "users_verification_tokens_parent_id_idx" ON "users_verification_tokens" USING btree ("_parent_id");`)
}