ahilles107 /
web-publisher
| Conditions | 1 |
| Paths | 1 |
| Total Lines | 10 |
| Lines | 10 |
| Ratio | 100 % |
| Changes | 0 | ||
| 1 | <?php |
||
| 15 | public function up(Schema $schema) |
||
| 16 | { |
||
| 17 | // this up() migration is auto-generated, please modify it to your needs |
||
| 18 | $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
||
| 19 | |||
| 20 | $this->addSql('CREATE SEQUENCE swp_package_preview_token_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
||
| 21 | $this->addSql('CREATE TABLE swp_package_preview_token (id INT NOT NULL, route_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, body TEXT NOT NULL, tenant_code VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
||
| 22 | $this->addSql('CREATE INDEX IDX_AD1CA87234ECB4E6 ON swp_package_preview_token (route_id)'); |
||
| 23 | $this->addSql('ALTER TABLE swp_package_preview_token ADD CONSTRAINT FK_AD1CA87234ECB4E6 FOREIGN KEY (route_id) REFERENCES swp_route (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
||
| 24 | } |
||
| 25 | |||
| 35 |
Loading history...
This class, trait or interface has been deprecated. The supplier of the file has supplied an explanatory message.
The explanatory message should give you some clue as to whether and when the type will be removed from the class and what other constant to use instead.