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