zend-blog-3-backend
35 строк · 1.6 Кб
1<?php
2
3namespace Application\Migrations;4
5use Doctrine\DBAL\Schema\Schema;6use Doctrine\Migrations\AbstractMigration;7
8/**
9* Auto-generated Migration: Please modify to your needs!
10*/
11class Version20160409151334 extends AbstractMigration12{
13/**14* @param Schema $schema
15*/
16public function up(Schema $schema): void17{18// this up() migration is auto-generated, please modify it to your needs19$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');20
21$this->addSql('CREATE TABLE media_file (id INT AUTO_INCREMENT NOT NULL, post_id INT DEFAULT NULL, path VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, file_size INT NOT NULL, default_image TINYINT(1) NOT NULL, backuped TINYINT(1) NOT NULL, time_created DATETIME NOT NULL, last_update DATETIME NOT NULL, UNIQUE INDEX UNIQ_4FD8E9C3B548B0F (path), INDEX IDX_4FD8E9C34B89032C (post_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');22$this->addSql('ALTER TABLE media_file ADD CONSTRAINT FK_4FD8E9C34B89032C FOREIGN KEY (post_id) REFERENCES posts (id) ON DELETE SET NULL');23}24
25/**26* @param Schema $schema
27*/
28public function down(Schema $schema): void29{30// this down() migration is auto-generated, please modify it to your needs31$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');32
33$this->addSql('DROP TABLE media_file');34}35}
36