import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1733123818059 implements MigrationInterface {
    name = 'Migrations1733123818059'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE "cms" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "title" character varying, "slug" character varying, "description" text, "created_at" TIMESTAMP(0) NOT NULL DEFAULT now(), "updated_at" TIMESTAMP(0) NOT NULL DEFAULT now(), "deleted_at" TIMESTAMP(0), "created_by" uuid, "updated_by" uuid, CONSTRAINT "PK_beb81752e4f627d4ab498fc60c1" PRIMARY KEY ("id"))`);
        await queryRunner.query(`ALTER TABLE "cms" ADD CONSTRAINT "FK_e76bb78da0cabc11d13884b7277" FOREIGN KEY ("created_by") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`);
        await queryRunner.query(`ALTER TABLE "cms" ADD CONSTRAINT "FK_3ef0ee0043a857146626701a2d6" FOREIGN KEY ("updated_by") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "cms" DROP CONSTRAINT "FK_3ef0ee0043a857146626701a2d6"`);
        await queryRunner.query(`ALTER TABLE "cms" DROP CONSTRAINT "FK_e76bb78da0cabc11d13884b7277"`);
        await queryRunner.query(`DROP TABLE "cms"`);
    }

}