| Conditions | 1 |
| Paths | 1 |
| Total Lines | 8 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
| 1 | <?php |
||
| 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 task (id SERIAL NOT NULL, todo_id INT NOT NULL, name VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, PRIMARY KEY(id))'); |
||
| 24 | $this->addSql('CREATE INDEX IDX_527EDB25EA1EBC33 ON task (todo_id)'); |
||
| 25 | $this->addSql('CREATE TABLE to_do (id SERIAL NOT NULL, name VARCHAR(255) NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, description TEXT DEFAULT NULL, PRIMARY KEY(id))'); |
||
| 26 | $this->addSql('ALTER TABLE task ADD CONSTRAINT FK_527EDB25EA1EBC33 FOREIGN KEY (todo_id) REFERENCES to_do (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
||
| 27 | } |
||
| 28 | |||
| 38 |