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