| Conditions | 1 |
| Paths | 1 |
| Total Lines | 19 |
| Code Lines | 18 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 0 | Features | 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(<<<'SQL' |
||
| 24 | CREATE TABLE product (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, value INTEGER NOT NULL) |
||
| 25 | SQL); |
||
| 26 | $this->addSql(<<<'SQL' |
||
| 27 | CREATE TABLE messenger_messages (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, body CLOB NOT NULL, headers CLOB NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL --(DC2Type:datetime_immutable) |
||
| 28 | , available_at DATETIME NOT NULL --(DC2Type:datetime_immutable) |
||
| 29 | , delivered_at DATETIME DEFAULT NULL --(DC2Type:datetime_immutable) |
||
| 30 | ) |
||
| 31 | SQL); |
||
| 32 | $this->addSql(<<<'SQL' |
||
| 33 | CREATE INDEX IDX_75EA56E0FB7336F0 ON messenger_messages (queue_name) |
||
| 34 | SQL); |
||
| 35 | $this->addSql(<<<'SQL' |
||
| 36 | CREATE INDEX IDX_75EA56E0E3BD61CE ON messenger_messages (available_at) |
||
| 37 | SQL); |
||
| 38 | $this->addSql(<<<'SQL' |
||
| 39 | CREATE INDEX IDX_75EA56E016BA31DB ON messenger_messages (delivered_at) |
||
| 54 |