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 |