Migration

[vcsvinicius]

Hi,

My application doens't use migration, i'm using liquibase. I can't create migration because my application doens't prepare to migrate, when a i try to use migration many errors happens.

Do you can send the dump the tables?

[mmucklo]

@vcsvinicius - Ah, I haven't dealt with that before.

What happens if you do a:

bin/console doctrine:schema:create --dump-sql

When I run it on my testing setup I get something like:

root@af4b593faf27:/var/www/symfony# bin/console doctrine:schema:create --dump-sql

 The following SQL statements will be executed:

     CREATE TABLE dtc_queue_job_timing (id BIGINT AUTO_INCREMENT NOT NULL, finished_at DATETIME NOT NULL, status INT NOT NULL, INDEX job_timing_finished_at (status, finished_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE dtc_queue_run_archive (id BIGINT AUTO_INCREMENT NOT NULL, started_at DATETIME DEFAULT NULL, duration INT DEFAULT NULL, ended_at DATETIME DEFAULT NULL, elapsed DOUBLE PRECISION DEFAULT NULL, max_count INT DEFAULT NULL, last_heartbeat_at DATETIME DEFAULT NULL, process_timeout INT DEFAULT NULL, current_job_id VARCHAR(255) DEFAULT NULL, processed INT NOT NULL, hostname VARCHAR(255) DEFAULT NULL, pid INT DEFAULT NULL, INDEX run_archive_ended_at_idx (ended_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE dtc_queue_run (id BIGINT AUTO_INCREMENT NOT NULL, started_at DATETIME DEFAULT NULL, ended_at DATETIME DEFAULT NULL, elapsed DOUBLE PRECISION DEFAULT NULL, duration INT DEFAULT NULL, last_heartbeat_at DATETIME NOT NULL, max_count INT DEFAULT NULL, processed INT NOT NULL, hostname VARCHAR(255) DEFAULT NULL, pid INT DEFAULT NULL, process_timeout INT DEFAULT NULL, current_job_id VARCHAR(255) DEFAULT NULL, INDEX run_last_heart_beat (last_heartbeat_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE dtc_queue_job_archive (id BIGINT NOT NULL, finished_at DATETIME DEFAULT NULL, elapsed DOUBLE PRECISION DEFAULT NULL, started_at DATETIME DEFAULT NULL, when_us NUMERIC(18, 0) DEFAULT NULL, priority INT DEFAULT NULL, expires_at DATETIME DEFAULT NULL, updated_at DATETIME NOT NULL, worker_name VARCHAR(255) NOT NULL, class_name VARCHAR(255) NOT NULL, method VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, args LONGTEXT NOT NULL, crc_hash VARCHAR(255) NOT NULL, message LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, max_duration INT DEFAULT NULL, run_id BIGINT DEFAULT NULL, stalls INT NOT NULL, max_stalls INT DEFAULT NULL, exceptions INT NOT NULL, max_exceptions INT DEFAULT NULL, failures INT NOT NULL, max_failures INT DEFAULT NULL, retries INT NOT NULL, max_retries INT DEFAULT NULL, INDEX job_archive_status_idx (status), INDEX job_archive_updated_at_idx (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE dtc_queue_job (id BIGINT AUTO_INCREMENT NOT NULL, worker_name VARCHAR(255) NOT NULL, class_name VARCHAR(255) NOT NULL, method VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, args LONGTEXT NOT NULL, priority INT DEFAULT NULL, crc_hash VARCHAR(255) NOT NULL, when_us NUMERIC(18, 0) DEFAULT NULL, expires_at DATETIME DEFAULT NULL, started_at DATETIME DEFAULT NULL, finished_at DATETIME DEFAULT NULL, elapsed DOUBLE PRECISION DEFAULT NULL, message LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, max_duration INT DEFAULT NULL, run_id BIGINT DEFAULT NULL, stalls INT NOT NULL, max_stalls INT DEFAULT NULL, exceptions INT NOT NULL, max_exceptions INT DEFAULT NULL, failures INT NOT NULL, max_failures INT DEFAULT NULL, retries INT NOT NULL, max_retries INT DEFAULT NULL, INDEX job_crc_hash_idx (crc_hash, status), INDEX job_priority_idx (priority, when_us), INDEX job_when_idx (when_us), INDEX job_status_idx (status, when_us), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;

[vcsvinicius]

@mmucklo I using liquibase, so, when I try use this commands errors happen because my application doesn't prepare to use this.

To resolve this I started a new project with Symfony only to execute this commands e get the query.