Total Complexity | 3 |
Total Lines | 18 |
Duplicated Lines | 0 % |
Changes | 1 | ||
Bugs | 0 | Features | 0 |
1 | <?php |
||
13 | final class Version20210817062054 extends AbstractMigration |
||
14 | { |
||
15 | public function getDescription(): string |
||
16 | { |
||
17 | return ''; |
||
18 | } |
||
19 | |||
20 | public function up(Schema $schema): void |
||
21 | { |
||
22 | // this up() migration is auto-generated, please modify it to your needs |
||
23 | $this->addSql('CREATE TABLE property_description (id INT AUTO_INCREMENT NOT NULL, property_id INT NOT NULL, title VARCHAR(255) DEFAULT NULL, content LONGTEXT DEFAULT NULL, meta_title VARCHAR(255) DEFAULT NULL, meta_description VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_D2818010549213EC (property_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
||
24 | $this->addSql('ALTER TABLE property_description ADD CONSTRAINT FK_D2818010549213EC FOREIGN KEY (property_id) REFERENCES property (id)'); |
||
25 | } |
||
26 | |||
27 | public function down(Schema $schema): void |
||
31 | } |
||
32 | } |
||
33 |