| Nijil Y | 8dd861b | 2011-12-20 17:17:51 +0530 | [diff] [blame] | 1 | def execute(): |
| 2 | import webnotes |
| 3 | from webnotes.modules.module_manager import reload_doc |
| Nijil Y | 35aa35b | 2011-12-21 11:50:20 +0530 | [diff] [blame] | 4 | reload_doc('setup', 'doctype', 'manage_account') |
| 5 | reload_doc('stock', 'doctype', 'item') |
| Nijil Y | 4d6a71c | 2011-12-21 11:56:42 +0530 | [diff] [blame] | 6 | webnotes.conn.sql("alter table `tabItem` drop column `minimum_inventory_level`") |
| Nijil Y | 16ca593 | 2011-12-21 12:20:07 +0530 | [diff] [blame] | 7 | webnotes.conn.sql("update `tabItem` set re_order_level = minimum_inventory_level wehre ifnull(re_order_level,0) = 0 ") |
| Nijil Y | 35aa35b | 2011-12-21 11:50:20 +0530 | [diff] [blame] | 8 | |