1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| <?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 Version20190104142743 extends AbstractMigration
{
public function up(Schema $schema) : void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('CREATE TABLE advert (id INT AUTO_INCREMENT NOT NULL, vehicle_id INT NOT NULL, description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, expires_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_54F1F40B545317D1 (vehicle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE fuel (id INT AUTO_INCREMENT NOT NULL, fuel VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE mark (id INT AUTO_INCREMENT NOT NULL, mark VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE photo (id INT AUTO_INCREMENT NOT NULL, advert_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, extension VARCHAR(255) NOT NULL, INDEX IDX_14B78418D07ECCB6 (advert_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE sort (id INT AUTO_INCREMENT NOT NULL, sort VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE vehicle (id INT AUTO_INCREMENT NOT NULL, sort_id INT NOT NULL, fuel_id INT NOT NULL, mark_id INT NOT NULL, manufacture_date DATETIME NOT NULL, INDEX IDX_1B80E48647013001 (sort_id), INDEX IDX_1B80E48697C79677 (fuel_id), INDEX IDX_1B80E4864290F12B (mark_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
$this->addSql('ALTER TABLE advert ADD CONSTRAINT FK_54F1F40B545317D1 FOREIGN KEY (vehicle_id) REFERENCES vehicle (id)');
$this->addSql('ALTER TABLE photo ADD CONSTRAINT FK_14B78418D07ECCB6 FOREIGN KEY (advert_id) REFERENCES advert (id)');
$this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E48647013001 FOREIGN KEY (sort_id) REFERENCES sort (id)');
$this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E48697C79677 FOREIGN KEY (fuel_id) REFERENCES fuel (id)');
$this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E4864290F12B FOREIGN KEY (mark_id) REFERENCES mark (id)');
}
public function down(Schema $schema) : void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE photo DROP FOREIGN KEY FK_14B78418D07ECCB6');
$this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E48697C79677');
$this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E4864290F12B');
$this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E48647013001');
$this->addSql('ALTER TABLE advert DROP FOREIGN KEY FK_54F1F40B545317D1');
$this->addSql('DROP TABLE advert');
$this->addSql('DROP TABLE fuel');
$this->addSql('DROP TABLE mark');
$this->addSql('DROP TABLE photo');
$this->addSql('DROP TABLE sort');
$this->addSql('DROP TABLE vehicle');
}
} |
Partager