@@ -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 | } |