@@ -30,15 +30,15 @@ |
||
30 | 30 | |
31 | 31 | /** Migrate the part locations for parts with known instock */ |
32 | 32 | $this->addSql( |
33 | - 'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' . |
|
34 | - 'SELECT parts.id, parts.id_storelocation, parts.instock, 0, NOW(), NOW() FROM parts ' . |
|
33 | + 'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '. |
|
34 | + 'SELECT parts.id, parts.id_storelocation, parts.instock, 0, NOW(), NOW() FROM parts '. |
|
35 | 35 | 'WHERE parts.instock >= 0' |
36 | 36 | ); |
37 | 37 | |
38 | 38 | //Migrate part locations for parts with unknown instock |
39 | 39 | $this->addSql( |
40 | - 'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) ' . |
|
41 | - 'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts ' . |
|
40 | + 'INSERT INTO part_lots (id_part, id_store_location, amount, instock_unknown, last_modified, datetime_added) '. |
|
41 | + 'SELECT parts.id, parts.id_storelocation, 0, 1, NOW(), NOW() FROM parts '. |
|
42 | 42 | 'WHERE parts.instock = -2' |
43 | 43 | ); |
44 | 44 |