Completed
Push — master ( da4625...467579 )
by Jan
04:13
created
src/Migrations/Version20190902140506.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -25,7 +25,7 @@  discard block
 block discarded – undo
25 25
 
26 26
         try {
27 27
             //Check if we can use this migration method:
28
-            $version = (int)$this->connection->fetchColumn("SELECT keyValue AS version FROM `internal` WHERE `keyName` = 'dbVersion'");
28
+            $version = (int) $this->connection->fetchColumn("SELECT keyValue AS version FROM `internal` WHERE `keyName` = 'dbVersion'");
29 29
             $this->abortIf($version !== 26, "This database migration can only be used if the database version is 26! Install Part-DB 0.5.6 and update database there!");
30 30
         } catch (DBALException $ex) {
31 31
             //when the table was not found, then you can not use this migration
@@ -46,15 +46,15 @@  discard block
 block discarded – undo
46 46
 
47 47
         /** Migrate the part locations for parts with known instock */
48 48
         $this->addSql(
49
-            'INSERT IGNORE INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' .
50
-            'SELECT parts.id, parts.id_storelocation,  parts.instock, 0, NOW(), NOW() FROM parts ' .
49
+            'INSERT IGNORE INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '.
50
+            'SELECT parts.id, parts.id_storelocation,  parts.instock, 0, NOW(), NOW() FROM parts '.
51 51
             'WHERE parts.instock >= 0'
52 52
         );
53 53
 
54 54
         //Migrate part locations for parts with unknown instock
55 55
         $this->addSql(
56
-            'INSERT IGNORE INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' .
57
-            'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts ' .
56
+            'INSERT IGNORE INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '.
57
+            'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts '.
58 58
             'WHERE parts.instock = -2'
59 59
         );
60 60
 
Please login to merge, or discard this patch.