@@ -19,7 +19,13 @@ |
||
| 19 | 19 | { |
| 20 | 20 | public function existsWithName(string $name): bool; |
| 21 | 21 | |
| 22 | + /** |
|
| 23 | + * @return void |
|
| 24 | + */ |
|
| 22 | 25 | public function add(Company $company): void; |
| 23 | 26 | |
| 27 | + /** |
|
| 28 | + * @return void |
|
| 29 | + */ |
|
| 24 | 30 | public function remove(Company $company): void; |
| 25 | 31 | } |
@@ -30,31 +30,31 @@ |
||
| 30 | 30 | { |
| 31 | 31 | // this up() migration is auto-generated, please modify it to your needs |
| 32 | 32 | $this->addSql( |
| 33 | - 'CREATE TABLE company (' . |
|
| 34 | - 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' . |
|
| 35 | - 'name VARCHAR(150) NOT NULL, ' . |
|
| 36 | - 'address VARCHAR(255) NOT NULL, ' . |
|
| 37 | - 'phone VARCHAR(255) NOT NULL, ' . |
|
| 38 | - 'facsimile VARCHAR(255) DEFAULT NULL, ' . |
|
| 39 | - 'email VARCHAR(255) NOT NULL, ' . |
|
| 40 | - 'contact VARCHAR(255) NOT NULL, ' . |
|
| 41 | - 'cellphone VARCHAR(255) NOT NULL, ' . |
|
| 42 | - 'PRIMARY KEY(uuid)' . |
|
| 33 | + 'CREATE TABLE company ('. |
|
| 34 | + 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '. |
|
| 35 | + 'name VARCHAR(150) NOT NULL, '. |
|
| 36 | + 'address VARCHAR(255) NOT NULL, '. |
|
| 37 | + 'phone VARCHAR(255) NOT NULL, '. |
|
| 38 | + 'facsimile VARCHAR(255) DEFAULT NULL, '. |
|
| 39 | + 'email VARCHAR(255) NOT NULL, '. |
|
| 40 | + 'contact VARCHAR(255) NOT NULL, '. |
|
| 41 | + 'cellphone VARCHAR(255) NOT NULL, '. |
|
| 42 | + 'PRIMARY KEY(uuid)'. |
|
| 43 | 43 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' |
| 44 | 44 | ); |
| 45 | 45 | $this->addSql( |
| 46 | - 'CREATE TABLE messenger_messages (' . |
|
| 47 | - 'id BIGINT AUTO_INCREMENT NOT NULL, ' . |
|
| 48 | - 'body LONGTEXT NOT NULL, ' . |
|
| 49 | - 'headers LONGTEXT NOT NULL, ' . |
|
| 50 | - 'queue_name VARCHAR(190) NOT NULL, ' . |
|
| 51 | - 'created_at DATETIME NOT NULL, ' . |
|
| 52 | - 'available_at DATETIME NOT NULL, ' . |
|
| 53 | - 'delivered_at DATETIME DEFAULT NULL, ' . |
|
| 54 | - 'INDEX IDX_75EA56E0FB7336F0 (queue_name), ' . |
|
| 55 | - 'INDEX IDX_75EA56E0E3BD61CE (available_at), ' . |
|
| 56 | - 'INDEX IDX_75EA56E016BA31DB (delivered_at), ' . |
|
| 57 | - 'PRIMARY KEY(id)' . |
|
| 46 | + 'CREATE TABLE messenger_messages ('. |
|
| 47 | + 'id BIGINT AUTO_INCREMENT NOT NULL, '. |
|
| 48 | + 'body LONGTEXT NOT NULL, '. |
|
| 49 | + 'headers LONGTEXT NOT NULL, '. |
|
| 50 | + 'queue_name VARCHAR(190) NOT NULL, '. |
|
| 51 | + 'created_at DATETIME NOT NULL, '. |
|
| 52 | + 'available_at DATETIME NOT NULL, '. |
|
| 53 | + 'delivered_at DATETIME DEFAULT NULL, '. |
|
| 54 | + 'INDEX IDX_75EA56E0FB7336F0 (queue_name), '. |
|
| 55 | + 'INDEX IDX_75EA56E0E3BD61CE (available_at), '. |
|
| 56 | + 'INDEX IDX_75EA56E016BA31DB (delivered_at), '. |
|
| 57 | + 'PRIMARY KEY(id)'. |
|
| 58 | 58 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' |
| 59 | 59 | ); |
| 60 | 60 | } |