@@ -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 | } |
@@ -30,9 +30,9 @@ |
||
30 | 30 | { |
31 | 31 | // this up() migration is auto-generated, please modify it to your needs |
32 | 32 | $this->addSql( |
33 | - 'ALTER TABLE company ' . |
|
34 | - 'ADD zip_code VARCHAR(255) NOT NULL, ' . |
|
35 | - 'ADD town VARCHAR(255) NOT NULL, ' . |
|
33 | + 'ALTER TABLE company '. |
|
34 | + 'ADD zip_code VARCHAR(255) NOT NULL, '. |
|
35 | + 'ADD town VARCHAR(255) NOT NULL, '. |
|
36 | 36 | 'ADD country VARCHAR(255) NOT NULL' |
37 | 37 | ); |
38 | 38 | } |
@@ -51,7 +51,7 @@ |
||
51 | 51 | |
52 | 52 | public function getValue(): string |
53 | 53 | { |
54 | - return $this->address . "\n" . $this->zipCode . ' ' . $this->town . ', ' . $this->country; |
|
54 | + return $this->address."\n".$this->zipCode.' '.$this->town.', '.$this->country; |
|
55 | 55 | } |
56 | 56 | |
57 | 57 | public function address(): string |