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 |