Completed
Push — master ( e0b171...4026f6 )
by Jan
04:46
created
src/Migrations/Version20190812154222.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -23,7 +23,7 @@  discard block
 block discarded – undo
23 23
         $old_db = true;
24 24
         try {
25 25
             //Check if we can use this migration method:
26
-            $version = (int)$this->connection->fetchColumn("SELECT keyValue AS version FROM `internal` WHERE `keyName` = 'dbVersion'");
26
+            $version = (int) $this->connection->fetchColumn("SELECT keyValue AS version FROM `internal` WHERE `keyName` = 'dbVersion'");
27 27
         } catch (DBALException $ex) {
28 28
             //when the table was not found, then we have an new database
29 29
             $old_db = false;
@@ -40,15 +40,15 @@  discard block
 block discarded – undo
40 40
 
41 41
         /** Migrate the part locations for parts with known instock */
42 42
         $this->addSql(
43
-            'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' .
44
-                'SELECT parts.id, parts.id_storelocation,  parts.instock, 0, NOW(), NOW() FROM parts ' .
43
+            'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '.
44
+                'SELECT parts.id, parts.id_storelocation,  parts.instock, 0, NOW(), NOW() FROM parts '.
45 45
                 'WHERE parts.instock >= 0'
46 46
         );
47 47
 
48 48
         //Migrate part locations for parts with unknown instock
49 49
         $this->addSql(
50
-            'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' .
51
-            'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts ' .
50
+            'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '.
51
+            'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts '.
52 52
             'WHERE parts.instock = -2'
53 53
         );
54 54
 
Please login to merge, or discard this patch.