23
|
|
|
$this->addSql('CREATE TABLE sepa_exports_audit (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_ede507fa01c5da3aa3c480afb73c017a_idx (type), INDEX object_id_ede507fa01c5da3aa3c480afb73c017a_idx (object_id), INDEX discriminator_ede507fa01c5da3aa3c480afb73c017a_idx (discriminator), INDEX transaction_hash_ede507fa01c5da3aa3c480afb73c017a_idx (transaction_hash), INDEX blame_id_ede507fa01c5da3aa3c480afb73c017a_idx (blame_id), INDEX created_at_ede507fa01c5da3aa3c480afb73c017a_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |