View GitHub Repository glsr

Schedule Inspection
Subscribe
Passed
Push — feat/manage-settings ( 66d990...95214d )
by
unknown
01:35
created
Status
Category
Toggle Patches
src/Core/Infrastructure/Doctrine/Migrations/Version20210502131525.php 1 patch
Spacing   +60 added lines, -60 removed lines patch added patch discarded remove patch 
@@ -30,78 +30,78 @@
 
 block discarded – undo
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 
-            'company_name VARCHAR(255) NOT NULL, ' .
36 
-            'address VARCHAR(255) NOT NULL, ' .
37 
-            'zip_code VARCHAR(5) NOT NULL, ' .
38 
-            'town VARCHAR(255) NOT NULL, ' .
39 
-            'country VARCHAR(255) NOT NULL, ' .
40 
-            'phone VARCHAR(14) NOT NULL, ' .
41 
-            'facsimile VARCHAR(14) DEFAULT NULL, ' .
42 
-            'email VARCHAR(255) NOT NULL, ' .
43 
-            'contact_name VARCHAR(255) NOT NULL, ' .
44 
-            'cellphone VARCHAR(14) NOT NULL, ' .
45 
-            'slug VARCHAR(255) NOT NULL, ' .
46 
-            'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), ' .
47 
-            'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), ' .
48 
-            'PRIMARY KEY(uuid)' .
33 
+            'CREATE TABLE company ('.
34 
+            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '.
35 
+            'company_name VARCHAR(255) NOT NULL, '.
36 
+            'address VARCHAR(255) NOT NULL, '.
37 
+            'zip_code VARCHAR(5) NOT NULL, '.
38 
+            'town VARCHAR(255) NOT NULL, '.
39 
+            'country VARCHAR(255) NOT NULL, '.
40 
+            'phone VARCHAR(14) NOT NULL, '.
41 
+            'facsimile VARCHAR(14) DEFAULT NULL, '.
42 
+            'email VARCHAR(255) NOT NULL, '.
43 
+            'contact_name VARCHAR(255) NOT NULL, '.
44 
+            'cellphone VARCHAR(14) NOT NULL, '.
45 
+            'slug VARCHAR(255) NOT NULL, '.
46 
+            'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), '.
47 
+            'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), '.
48 
+            'PRIMARY KEY(uuid)'.
49 49 
             ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
50 50 
         );
51 51 
         $this->addSql(
52 
-            'CREATE TABLE settings (' .
53 
-            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
54 
-            'locale VARCHAR(255) NOT NULL, ' .
55 
-            'currency VARCHAR(255) NOT NULL, ' .
56 
-            'PRIMARY KEY(uuid)' .
52 
+            'CREATE TABLE settings ('.
53 
+            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '.
54 
+            'locale VARCHAR(255) NOT NULL, '.
55 
+            'currency VARCHAR(255) NOT NULL, '.
56 
+            'PRIMARY KEY(uuid)'.
57 57 
             ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
58 58 
         );
59 59 
         $this->addSql(
60 
-            'CREATE TABLE supplier (' .
61 
-            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
62 
-            'family_log VARCHAR(255) NOT NULL, ' .
63 
-            'delay_delivery INT NOT NULL, ' .
64 
-            'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
65 
-            'active TINYINT(1) NOT NULL, ' .
66 
-            'company_name VARCHAR(255) NOT NULL, ' .
67 
-            'address VARCHAR(255) NOT NULL, ' .
68 
-            'zip_code VARCHAR(5) NOT NULL, ' .
69 
-            'town VARCHAR(255) NOT NULL, ' .
70 
-            'country VARCHAR(255) NOT NULL, ' .
71 
-            'phone VARCHAR(14) NOT NULL, ' .
72 
-            'facsimile VARCHAR(14) DEFAULT NULL, ' .
73 
-            'email VARCHAR(255) NOT NULL, ' .
74 
-            'contact_name VARCHAR(255) NOT NULL, ' .
75 
-            'cellphone VARCHAR(14) NOT NULL, s' .
76 
-            'lug VARCHAR(255) NOT NULL, ' .
77 
-            'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), ' .
78 
-            'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), ' .
79 
-            'PRIMARY KEY(uuid)' .
60 
+            'CREATE TABLE supplier ('.
61 
+            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '.
62 
+            'family_log VARCHAR(255) NOT NULL, '.
63 
+            'delay_delivery INT NOT NULL, '.
64 
+            'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', '.
65 
+            'active TINYINT(1) NOT NULL, '.
66 
+            'company_name VARCHAR(255) NOT NULL, '.
67 
+            'address VARCHAR(255) NOT NULL, '.
68 
+            'zip_code VARCHAR(5) NOT NULL, '.
69 
+            'town VARCHAR(255) NOT NULL, '.
70 
+            'country VARCHAR(255) NOT NULL, '.
71 
+            'phone VARCHAR(14) NOT NULL, '.
72 
+            'facsimile VARCHAR(14) DEFAULT NULL, '.
73 
+            'email VARCHAR(255) NOT NULL, '.
74 
+            'contact_name VARCHAR(255) NOT NULL, '.
75 
+            'cellphone VARCHAR(14) NOT NULL, s'.
76 
+            'lug VARCHAR(255) NOT NULL, '.
77 
+            'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), '.
78 
+            'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), '.
79 
+            'PRIMARY KEY(uuid)'.
80 80 
             ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
81 81 
         );
82 82 
         $this->addSql(
83 
-            'CREATE TABLE user (' .
84 
-            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
85 
-            'username VARCHAR(150) NOT NULL, ' .
86 
-            'email VARCHAR(255) NOT NULL, ' .
87 
-            'password VARCHAR(120) NOT NULL, ' .
88 
-            'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
89 
-            'PRIMARY KEY(uuid)' .
83 
+            'CREATE TABLE user ('.
84 
+            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '.
85 
+            'username VARCHAR(150) NOT NULL, '.
86 
+            'email VARCHAR(255) NOT NULL, '.
87 
+            'password VARCHAR(120) NOT NULL, '.
88 
+            'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', '.
89 
+            'PRIMARY KEY(uuid)'.
90 90 
             ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
91 91 
         );
92 92 
         $this->addSql(
93 
-            'CREATE TABLE messenger_messages (' .
94 
-            'id BIGINT AUTO_INCREMENT NOT NULL, ' .
95 
-            'body LONGTEXT NOT NULL, ' .
96 
-            'headers LONGTEXT NOT NULL, ' .
97 
-            'queue_name VARCHAR(190) NOT NULL, ' .
98 
-            'created_at DATETIME NOT NULL, ' .
99 
-            'available_at DATETIME NOT NULL, ' .
100 
-            'delivered_at DATETIME DEFAULT NULL, ' .
101 
-            'INDEX IDX_75EA56E0FB7336F0 (queue_name), ' .
102 
-            'INDEX IDX_75EA56E0E3BD61CE (available_at), ' .
103 
-            'INDEX IDX_75EA56E016BA31DB (delivered_at), ' .
104 
-            'PRIMARY KEY(id)' .
93 
+            'CREATE TABLE messenger_messages ('.
94 
+            'id BIGINT AUTO_INCREMENT NOT NULL, '.
95 
+            'body LONGTEXT NOT NULL, '.
96 
+            'headers LONGTEXT NOT NULL, '.
97 
+            'queue_name VARCHAR(190) NOT NULL, '.
98 
+            'created_at DATETIME NOT NULL, '.
99 
+            'available_at DATETIME NOT NULL, '.
100 
+            'delivered_at DATETIME DEFAULT NULL, '.
101 
+            'INDEX IDX_75EA56E0FB7336F0 (queue_name), '.
102 
+            'INDEX IDX_75EA56E0E3BD61CE (available_at), '.
103 
+            'INDEX IDX_75EA56E016BA31DB (delivered_at), '.
104 
+            'PRIMARY KEY(id)'.
105 105 
             ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
106 106 
         );
107 107 
     }
Please login to merge, or discard this patch.