<?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 Version20231221211831 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 TABLE empresa (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, empresa_rut VARCHAR(20) DEFAULT NULL, empresa_razon_social VARCHAR(100) DEFAULT NULL, webfactura_id INT DEFAULT NULL, webfactura_client_id VARCHAR(200) DEFAULT NULL, webfactura_client_secret VARCHAR(200) DEFAULT NULL, empresa_giro VARCHAR(255) DEFAULT NULL, empresa_direccion VARCHAR(100) DEFAULT NULL, empresa_comuna VARCHAR(100) DEFAULT NULL, empresa_ciudad VARCHAR(100) DEFAULT NULL, empresa_telefono VARCHAR(20) DEFAULT NULL, empresa_correo VARCHAR(100) DEFAULT NULL, precio_bruto TINYINT(1) DEFAULT NULL, precio_neto TINYINT(1) DEFAULT NULL, empresa_actividad_economica INT DEFAULT NULL, is_active TINYINT(1) DEFAULT NULL, modo_demo TINYINT(1) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_report (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, observacion VARCHAR(255) DEFAULT NULL, method VARCHAR(10) DEFAULT NULL, content LONGTEXT DEFAULT NULL, controller_used VARCHAR(40) DEFAULT NULL, function_used VARCHAR(40) DEFAULT NULL, time_alive VARCHAR(100) DEFAULT NULL, ip_call VARCHAR(20) DEFAULT NULL, file_log_name VARCHAR(100) DEFAULT NULL, empresa_id INT NOT NULL, ruta_log VARCHAR(150) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE magento (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, empresa_id INT DEFAULT NULL, oauth_consumer_key VARCHAR(255) DEFAULT NULL, oauth_consumer_secret VARCHAR(255) DEFAULT NULL, store_base_url VARCHAR(255) DEFAULT NULL, oauth_verifier VARCHAR(255) DEFAULT NULL, oauth_token VARCHAR(255) DEFAULT NULL, oauth_token_secret VARCHAR(255) DEFAULT NULL, is_active TINYINT(1) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE magento_order (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, empresa_id INT DEFAULT NULL, doc_fecha_emision DATETIME DEFAULT NULL, increment_id BIGINT DEFAULT NULL, state VARCHAR(100) DEFAULT NULL, status VARCHAR(100) DEFAULT NULL, doc_folio INT DEFAULT NULL, protect_code VARCHAR(150) DEFAULT NULL, doc_tipo_id INT DEFAULT NULL, pdf_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE queue_magento (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, empresa_id INT DEFAULT NULL, resource INT DEFAULT NULL, magento_resource_id INT DEFAULT NULL, status TINYINT(1) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, email VARCHAR(180) NOT NULL, roles JSON NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, empresa_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT NULL, salt VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('DROP TABLE empresa');
$this->addSql('DROP TABLE event_report');
$this->addSql('DROP TABLE magento');
$this->addSql('DROP TABLE magento_order');
$this->addSql('DROP TABLE queue_magento');
$this->addSql('DROP TABLE user');
}
}