import { MigrationInterface, QueryRunner } from "typeorm";

export class  $npmConfigName1773842436464 implements MigrationInterface {
    name = ' $npmConfigName1773842436464'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE \`public_holidays\` (\`id\` int UNSIGNED NOT NULL AUTO_INCREMENT, \`date\` date NOT NULL, \`label\` varchar(100) NOT NULL, \`is_exceptional\` tinyint NOT NULL DEFAULT 0, \`applies_to\` enum ('all', 'specific_team') NOT NULL DEFAULT 'all', \`created_at\` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), \`created_by\` int UNSIGNED NULL, UNIQUE INDEX \`IDX_7599e8969de9ac9e64a3d53645\` (\`date\`), PRIMARY KEY (\`id\`)) ENGINE=InnoDB`);
        await queryRunner.query(`ALTER TABLE \`public_holidays\` ADD CONSTRAINT \`FK_93212bbdfddbf0b70c7ca522eb3\` FOREIGN KEY (\`created_by\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE \`public_holidays\` DROP FOREIGN KEY \`FK_93212bbdfddbf0b70c7ca522eb3\``);
        await queryRunner.query(`DROP INDEX \`IDX_7599e8969de9ac9e64a3d53645\` ON \`public_holidays\``);
        await queryRunner.query(`DROP TABLE \`public_holidays\``);
    }

}