laravel-raw-migrations

Create Migration File

add the below format in up migration for MySQL.

		$sql = <<<'SQL'

        CREATE TABLE holidays (

            id                             INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            date                           DATE NOT NULL UNIQUE,
            description                    VARCHAR(255) NOT NULL,
            status                         ENUM('Pending', 'Approved', 'Rejected') NOT NULL DEFAULT 'Pending',
            remarks                        VARCHAR(255) NULL,
            verified_id                    BIGINT UNSIGNED NULL,
            created_id                     BIGINT UNSIGNED NOT NULL,
            updated_id                     BIGINT UNSIGNED NULL,

            FOREIGN KEY (verified_id)      REFERENCES users(id),
            FOREIGN KEY (created_id)       REFERENCES users(id),
            FOREIGN KEY (updated_id)       REFERENCES users(id),

            created_at                     TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at                     TIMESTAMP DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
            deleted_at                     TIMESTAMP DEFAULT NULL
        );

        SQL;

        DB::statement($sql);