Viewing File: /usr/local/cpanel/whostmgr/docroot/cgi/ncssl/source/migrations/Version20230920110356.php

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20230920110356 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE TEMPORARY TABLE __temp__certificates AS SELECT id, userid, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect FROM certificates');
        $this->addSql('DROP TABLE certificates');
        $this->addSql('CREATE TABLE certificates (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER DEFAULT NULL, nc_id INTEGER DEFAULT NULL, cpanel_id VARCHAR(100) DEFAULT NULL, nc_user VARCHAR(100) NOT NULL, privatekey_id VARCHAR(100) DEFAULT NULL, status VARCHAR(25) DEFAULT \'CREATED\', nc_status VARCHAR(25) NOT NULL, host VARCHAR(100) NOT NULL, common_name VARCHAR(100) NOT NULL, type VARCHAR(100) NOT NULL, expires INTEGER DEFAULT NULL, years INTEGER NOT NULL, vendor VARCHAR(100) NOT NULL, validation_data CLOB DEFAULT NULL, installed_at INTEGER DEFAULT NULL, auto_redirect BOOLEAN DEFAULT 1 NOT NULL, CONSTRAINT FK_8D26FB5FA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE)');
        $this->addSql('INSERT INTO certificates (id, user_id, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect) SELECT id, userid, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect FROM __temp__certificates');
        $this->addSql('DROP TABLE __temp__certificates');
        $this->addSql('CREATE INDEX IDX_8D26FB5FA76ED395 ON certificates (user_id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE TEMPORARY TABLE __temp__certificates AS SELECT id, user_id, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect FROM certificates');
        $this->addSql('DROP TABLE certificates');
        $this->addSql('CREATE TABLE certificates (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, nc_id INTEGER DEFAULT NULL, cpanel_id VARCHAR(100) DEFAULT NULL, nc_user VARCHAR(100) NOT NULL, privatekey_id VARCHAR(100) DEFAULT NULL, status VARCHAR(25) DEFAULT \'CREATED\', nc_status VARCHAR(25) NOT NULL, host VARCHAR(100) NOT NULL, common_name VARCHAR(100) NOT NULL, type VARCHAR(100) NOT NULL, expires INTEGER DEFAULT NULL, years INTEGER NOT NULL, vendor VARCHAR(100) NOT NULL, validation_data CLOB DEFAULT NULL, installed_at INTEGER DEFAULT NULL, auto_redirect BOOLEAN DEFAULT 1 NOT NULL, userid INTEGER NOT NULL)');
        $this->addSql('INSERT INTO certificates (id, userid, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect) SELECT id, user_id, nc_id, cpanel_id, nc_user, privatekey_id, status, nc_status, host, common_name, type, expires, years, vendor, validation_data, installed_at, auto_redirect FROM __temp__certificates');
        $this->addSql('DROP TABLE __temp__certificates');
    }
}