@@ -23,7 +23,7 @@ discard block |
||
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 |
||
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 |