blob: b31fc9c79f11c09ea83da74c5de416efa28eec6d [file] [log] [blame]
Rushabh Mehtae67d1fb2013-08-05 14:59:54 +05301# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
2# License: GNU General Public License v3. See license.txt
Rushabh Mehta3966f1d2012-02-23 12:35:32 +05303
Anand Doshi486f9df2012-07-19 13:40:31 +05304from __future__ import unicode_literals
Anand Doshid56d57d2012-01-02 16:25:05 +05305patch_list = [
Anand Doshi4daf3dd2013-07-17 18:06:02 +05306 "execute:webnotes.reload_doc('core', 'doctype', 'doctype', force=True) #2013-07-15",
7 "execute:webnotes.reload_doc('core', 'doctype', 'docfield', force=True) #2013-07-15",
8 "execute:webnotes.reload_doc('core', 'doctype', 'doctype', force=True) #2013-07-16",
9 "execute:webnotes.reload_doc('core', 'doctype', 'docfield', force=True) #2013-07-16",
10 "execute:webnotes.reload_doc('core', 'doctype', 'docperm') #2013-07-16",
11 "execute:webnotes.reload_doc('core', 'doctype', 'page') #2013-07-16",
12 "execute:webnotes.reload_doc('core', 'doctype', 'report') #2013-07-16",
Nabin Haita642ae12013-01-18 10:49:39 +053013 "patches.september_2012.stock_report_permissions_for_accounts",
14 "patches.september_2012.communication_delete_permission",
15 "patches.september_2012.all_permissions_patch",
16 "patches.september_2012.customer_permission_patch",
17 "patches.september_2012.add_stock_ledger_entry_index",
18 "patches.september_2012.plot_patch",
19 "patches.september_2012.event_permission",
20 "patches.september_2012.repost_stock",
Nabin Haita642ae12013-01-18 10:49:39 +053021 "patches.september_2012.rebuild_trees",
22 "patches.september_2012.deprecate_account_balance",
23 "patches.september_2012.profile_delete_permission",
24 "patches.october_2012.update_permission",
Nabin Haita642ae12013-01-18 10:49:39 +053025 "patches.october_2012.fix_wrong_vouchers",
Nabin Haita642ae12013-01-18 10:49:39 +053026 "patches.october_2012.company_fiscal_year_docstatus_patch",
27 "patches.october_2012.update_account_property",
Nabin Haita642ae12013-01-18 10:49:39 +053028 "patches.october_2012.fix_cancelled_gl_entries",
29 "patches.october_2012.custom_script_delete_permission",
30 "patches.november_2012.custom_field_insert_after",
Nabin Haita642ae12013-01-18 10:49:39 +053031 "patches.november_2012.report_permissions",
32 "patches.november_2012.customer_issue_allocated_to_assigned",
33 "patches.november_2012.reset_appraisal_permissions",
34 "patches.november_2012.disable_cancelled_profiles",
Nabin Haita642ae12013-01-18 10:49:39 +053035 "patches.november_2012.support_ticket_response_to_communication",
36 "patches.november_2012.cancelled_bom_patch",
37 "patches.november_2012.communication_sender_and_recipient",
38 "patches.november_2012.update_delivered_billed_percentage_for_pos",
39 "patches.november_2012.add_theme_to_profile",
40 "patches.november_2012.add_employee_field_in_employee",
41 "patches.november_2012.leave_application_cleanup",
42 "patches.november_2012.production_order_patch",
43 "patches.november_2012.gle_floating_point_issue",
44 "patches.december_2012.deprecate_tds",
45 "patches.december_2012.expense_leave_reload",
46 "patches.december_2012.repost_ordered_qty",
47 "patches.december_2012.repost_projected_qty",
Nabin Haita642ae12013-01-18 10:49:39 +053048 "patches.december_2012.website_cache_refactor",
49 "patches.december_2012.production_cleanup",
50 "patches.december_2012.fix_default_print_format",
51 "patches.december_2012.file_list_rename",
52 "patches.december_2012.replace_createlocal",
Nabin Haita642ae12013-01-18 10:49:39 +053053 "patches.december_2012.remove_quotation_next_contact",
54 "patches.december_2012.stock_entry_cleanup",
55 "patches.december_2012.production_order_naming_series",
56 "patches.december_2012.rebuild_item_group_tree",
57 "patches.december_2012.address_title",
58 "patches.december_2012.delete_form16_print_format",
Nabin Haita642ae12013-01-18 10:49:39 +053059 "patches.december_2012.update_print_width",
60 "patches.january_2013.remove_bad_permissions",
Nabin Haita642ae12013-01-18 10:49:39 +053061 "patches.january_2013.holiday_list_patch",
62 "patches.january_2013.stock_reconciliation_patch",
63 "patches.january_2013.report_permission",
64 "patches.january_2013.give_report_permission_on_read",
65 "patches.january_2013.update_closed_on",
66 "patches.january_2013.change_patch_structure",
67 "patches.january_2013.update_country_info",
68 "patches.january_2013.remove_tds_entry_from_gl_mapper",
Rushabh Mehtaf5b04cf2013-01-21 10:14:10 +053069 "patches.january_2013.update_number_format",
Anand Doshi0382d5a2013-05-02 16:42:26 +053070 "execute:webnotes.reload_doc('core', 'doctype', 'print_format') #2013-01",
Rushabh Mehta6dd9d452013-01-21 18:44:43 +053071 "execute:webnotes.reload_doc('accounts','Print Format','Payment Receipt Voucher')",
Nabin Haitf0881a92013-01-22 11:21:55 +053072 "patches.january_2013.update_fraction_for_usd",
Rushabh Mehta6382a422013-01-23 10:09:28 +053073 "patches.january_2013.enable_currencies",
Nabin Haita8454e22013-01-23 16:01:35 +053074 "patches.january_2013.remove_unwanted_permission",
Nabin Hait291e8c22013-01-23 16:06:44 +053075 "patches.january_2013.remove_landed_cost_master",
Nabin Haite37b3442013-01-25 17:38:48 +053076 "patches.january_2013.reload_print_format",
Rushabh Mehta83e08362013-01-25 15:11:26 +053077 "patches.january_2013.rebuild_tree",
Rushabh Mehtafe99c292013-01-28 15:30:02 +053078 "execute:webnotes.reload_doc('core','doctype','docfield') #2013-01-28",
Rushabh Mehta6abb2e62013-01-28 17:00:59 +053079 "patches.january_2013.tabsessions_to_myisam",
Nabin Haitce4178b2013-02-01 12:14:45 +053080 "patches.february_2013.remove_gl_mapper",
81 "patches.february_2013.reload_bom_replace_tool_permission",
Nabin Haitc40a64a2013-02-01 14:23:22 +053082 "patches.february_2013.payment_reconciliation_reset_values",
Nabin Hait7bdf27b2013-02-05 15:52:46 +053083 "patches.february_2013.account_negative_balance",
Anand Doshi22807a62013-02-06 15:41:32 +053084 "patches.february_2013.remove_account_utils_folder",
Rushabh Mehta4b9827a2013-02-12 19:20:39 +053085 "patches.february_2013.update_company_in_leave_application",
Nabin Hait362455e2013-02-13 15:50:39 +053086 "execute:webnotes.conn.sql_ddl('alter table tabSeries change `name` `name` varchar(100)')",
Anand Doshi86af3522013-02-13 18:04:21 +053087 "execute:webnotes.conn.sql('update tabUserRole set parentfield=\"user_roles\" where parentfield=\"userroles\"')",
Anand Doshi0cfdeec2013-02-16 11:08:55 +053088 "patches.february_2013.p01_event",
Anand Doshi96bebb42013-02-16 15:09:34 +053089 "execute:webnotes.delete_doc('Page', 'Calendar')",
Anand Doshi27947362013-02-16 18:44:40 +053090 "patches.february_2013.p02_email_digest",
Anand Doshi236cc172013-02-18 13:49:15 +053091 "patches.february_2013.p03_material_request",
Rushabh Mehta9c880da2013-02-18 14:28:34 +053092 "patches.february_2013.p04_remove_old_doctypes",
Anand Doshic1db0a62013-02-20 16:08:21 +053093 "execute:webnotes.delete_doc('DocType', 'Plot Control')",
Anand Doshi78352d12013-02-18 17:09:11 +053094 "patches.february_2013.p05_leave_application",
Nabin Hait66ea0862013-02-19 15:13:23 +053095 "patches.february_2013.gle_floating_point_issue_revisited",
96 "patches.february_2013.fix_outstanding",
Nabin Hait704d5f02013-02-19 16:23:21 +053097 "execute:webnotes.delete_doc('DocType', 'Service Order')",
98 "execute:webnotes.delete_doc('DocType', 'Service Quotation')",
99 "execute:webnotes.delete_doc('DocType', 'Service Order Detail')",
100 "execute:webnotes.delete_doc('DocType', 'Service Quotation Detail')",
Rushabh Mehta90098d22013-02-22 17:54:50 +0530101 "execute:webnotes.delete_doc('Page', 'Query Report')",
Nabin Haitad8a46c2013-02-22 17:58:54 +0530102 "patches.february_2013.repost_reserved_qty",
Anand Doshi7bc7aef2013-02-25 13:12:37 +0530103 "execute:webnotes.reload_doc('core', 'doctype', 'report') # 2013-02-25",
Rushabh Mehta22681df2013-02-23 17:13:44 +0530104 "execute:webnotes.conn.sql(\"update `tabReport` set report_type=if(ifnull(query, '')='', 'Report Builder', 'Query Report') where is_standard='No'\")",
Anand Doshib60aef52013-02-25 15:22:20 +0530105 "execute:webnotes.conn.sql(\"update `tabReport` set report_name=name where ifnull(report_name,'')='' and is_standard='No'\")",
106 "patches.february_2013.p08_todo_query_report",
Rushabh Mehtaed196662013-02-26 16:36:41 +0530107 "execute:(not webnotes.conn.exists('Role', 'Projects Manager')) and webnotes.doc({'doctype':'Role', 'role_name':'Projects Manager'}).insert()",
Anand Doshia8caa5e2013-02-28 16:45:37 +0530108 "patches.february_2013.p09_remove_cancelled_warehouses",
Nabin Hait95a72a72013-03-01 11:07:07 +0530109 "patches.march_2013.update_po_prevdoc_doctype",
Rushabh Mehtaf934a242013-03-04 15:34:45 +0530110 "patches.february_2013.p09_timesheets",
Rushabh Mehta5423c962013-03-04 15:45:46 +0530111 "execute:(not webnotes.conn.exists('UOM', 'Hour')) and webnotes.doc({'uom_name': 'Hour', 'doctype': 'UOM', 'name': 'Hour'}).insert()",
Nabin Haitdae20d82013-03-05 15:52:07 +0530112 "patches.march_2013.p01_c_form",
Nabin Haita0accd92013-03-05 15:58:04 +0530113 "execute:webnotes.conn.sql('update tabDocPerm set `submit`=1, `cancel`=1, `amend`=1 where parent=\"Time Log\"')",
Nabin Haitdae20d82013-03-05 15:52:07 +0530114 "execute:webnotes.delete_doc('DocType', 'Attendance Control Panel')",
Nabin Hait87b9cd52013-03-06 13:15:08 +0530115 "patches.march_2013.p02_get_global_default",
Rushabh Mehtab8ec3e72013-03-11 14:29:09 +0530116 "patches.march_2013.p03_rename_blog_to_blog_post",
Anand Doshi71bed312013-03-13 12:57:04 +0530117 "patches.march_2013.p04_pos_update_stock_check",
Anand Doshi1cf73912013-03-15 13:42:31 +0530118 "patches.march_2013.p05_payment_reconciliation",
Anand Doshi080f9092013-03-18 17:57:59 +0530119 "patches.march_2013.p06_remove_sales_purchase_return_tool",
Rushabh Mehta06d186b2013-03-25 17:03:52 +0530120 "execute:webnotes.bean('Global Defaults').save()",
121 "patches.march_2013.p07_update_project_in_stock_ledger",
Anand Doshie3507312013-03-27 17:35:23 +0530122 "execute:webnotes.reload_doc('stock', 'doctype', 'item') #2013-03-25",
123 "execute:webnotes.reload_doc('setup', 'doctype', 'item_group') #2013-03-25",
124 "execute:webnotes.reload_doc('website', 'doctype', 'blog_post') #2013-03-25",
125 "execute:webnotes.reload_doc('website', 'doctype', 'web_page') #2013-03-25",
Nabin Hait4d150e62013-06-25 11:05:17 +0530126 "execute:webnotes.reload_doc('setup', 'doctype', 'sales_partner') #2013-06-25",
Anand Doshi9f910532013-03-26 12:25:11 +0530127 "execute:webnotes.conn.set_value('Email Settings', None, 'send_print_in_body_and_attachment', 1)",
Anand Doshie3507312013-03-27 17:35:23 +0530128 "patches.march_2013.p10_set_fiscal_year_for_stock",
Nabin Haite2fe8de2013-03-28 15:30:41 +0530129 "patches.march_2013.p10_update_against_expense_account",
Rushabh Mehta2fe802c2013-03-28 16:26:11 +0530130 "patches.march_2013.p11_update_attach_files",
Nabin Haitacecb942013-03-29 10:48:41 +0530131 "patches.march_2013.p12_set_item_tax_rate_in_json",
Nabin Hait787c02e2013-03-29 16:42:33 +0530132 "patches.march_2013.p07_update_valuation_rate",
133 "patches.march_2013.p08_create_aii_accounts",
Nabin Hait2f20a7a2013-04-01 17:23:43 +0530134 "patches.april_2013.p01_update_serial_no_valuation_rate",
Nabin Hait996e4692013-04-02 14:26:26 +0530135 "patches.april_2013.p02_add_country_and_currency",
Nabin Hait1e3fc882013-04-02 18:13:20 +0530136 "patches.april_2013.p03_fixes_for_lead_in_quotation",
Rushabh Mehta27c40792013-04-03 15:21:44 +0530137 "patches.april_2013.p04_reverse_modules_list",
Nabin Haitd35293d2013-04-09 11:39:16 +0530138 "patches.april_2013.p04_update_role_in_pages",
Rushabh Mehta0c161122013-04-10 13:54:13 +0530139 "patches.april_2013.p05_update_file_data",
140 "patches.april_2013.p06_update_file_size",
Anand Doshie33f8272013-04-10 19:33:57 +0530141 "patches.april_2013.p05_fixes_in_reverse_modules",
Anand Doshiaeef7bd2013-04-19 16:21:55 +0530142 "patches.april_2013.p07_rename_cost_center_other_charges",
Anand Doshi4d705592013-04-18 16:21:42 +0530143 "patches.april_2013.p06_default_cost_center",
Rushabh Mehtacdc9e2c2013-04-25 11:06:17 +0530144 "execute:webnotes.reset_perms('File Data')",
Anand Doshieda17eb2013-04-29 15:21:30 +0530145 "patches.april_2013.p07_update_file_data_2",
Nabin Hait345c8fb2013-04-29 14:35:11 +0530146 "patches.april_2013.rebuild_sales_browser",
Anand Doshi21f4ea32013-05-10 18:08:32 +0530147 "patches.may_2013.p01_selling_net_total_export",
Nabin Hait4e1dcfc2013-05-10 15:17:20 +0530148 "patches.may_2013.repost_stock_for_no_posting_time",
Nabin Haitf826b932013-05-17 12:19:50 +0530149 "patches.may_2013.p01_conversion_factor_and_aii",
Nabin Hait9053cbc2013-05-20 15:28:44 +0530150 "patches.may_2013.p02_update_valuation_rate",
Nabin Haitcb990452013-05-21 17:17:40 +0530151 "patches.may_2013.p03_update_support_ticket",
Nabin Hait62d06292013-05-22 16:19:10 +0530152 "patches.may_2013.p04_reorder_level",
Nabin Haitb56412c2013-05-23 17:41:52 +0530153 "patches.may_2013.p05_update_cancelled_gl_entries",
Rushabh Mehta9c5f4fe2013-05-24 16:33:10 +0530154 "patches.may_2013.p06_make_notes",
Nabin Hait0feebc12013-06-03 16:45:38 +0530155 "patches.may_2013.p06_update_billed_amt_po_pr",
Anand Doshiecc28f02013-05-30 17:43:30 +0530156 "patches.may_2013.p07_move_update_stock_to_pos",
Anand Doshif41ce112013-05-30 19:18:51 +0530157 "patches.may_2013.p08_change_item_wise_tax",
Nabin Haitad600cc2013-06-04 16:56:56 +0530158 "patches.june_2013.p01_update_bom_exploded_items",
Rushabh Mehtacdd265d2013-06-07 14:52:53 +0530159 "patches.june_2013.p02_update_project_completed",
Anand Doshie3e15a92013-06-06 11:35:49 +0530160 "execute:webnotes.delete_doc('DocType', 'System Console')",
Anand Doshi060d9242013-06-12 17:40:36 +0530161 "patches.june_2013.p03_buying_selling_for_price_list",
Anand Doshie53a81d2013-06-10 15:15:40 +0530162 "patches.june_2013.p04_fix_event_for_lead_oppty_project",
Nabin Hait82366d32013-06-24 14:31:56 +0530163 "patches.june_2013.p05_remove_search_criteria_reports",
Anand Doshi690c2f52013-07-08 11:55:50 +0530164 "execute:webnotes.delete_doc('Report', 'Sales Orders Pending To Be Delivered')",
Rushabh Mehtaa642d592013-06-11 17:32:48 +0530165 "patches.june_2013.p05_remove_unused_doctypes",
Anand Doshi060d9242013-06-12 17:40:36 +0530166 "patches.june_2013.p06_drop_unused_tables",
Anand Doshi8f9f8a42013-06-28 19:18:33 +0530167 "patches.june_2013.p07_taxes_price_list_for_territory",
168 "patches.june_2013.p08_shopping_cart_settings",
Rushabh Mehtad242a8b2013-06-25 11:46:07 +0530169 "patches.june_2013.p09_update_global_defaults",
Anand Doshi8f9f8a42013-06-28 19:18:33 +0530170 "patches.june_2013.p10_lead_address",
Nabin Haited23cca2013-07-07 19:11:52 +0530171 "patches.july_2013.p01_remove_doctype_mappers",
Nabin Hait2bd37772013-07-08 19:00:29 +0530172 "execute:webnotes.delete_doc('Report', 'Delivered Items To Be Billed')",
173 "execute:webnotes.delete_doc('Report', 'Received Items To Be Billed')",
Nabin Haitfd33b2b2013-07-09 11:42:38 +0530174 "patches.july_2013.p02_copy_shipping_address",
Anand Doshi1357c0b2013-07-09 15:45:38 +0530175 "patches.july_2013.p03_cost_center_company",
Anand Doshi2d71a512013-07-16 13:06:14 +0530176 "patches.july_2013.p04_merge_duplicate_leads",
Anand Doshi55da1ff2013-07-17 12:36:07 +0530177 "patches.july_2013.p05_custom_doctypes_in_list_view",
Nabin Hait5b43b3d2013-07-18 12:28:09 +0530178 "patches.july_2013.p06_same_sales_rate",
Nabin Hait60d9a5e2013-07-18 13:15:41 +0530179 "patches.july_2013.p07_repost_billed_amt_in_sales_cycle",
Anand Doshid81c3202013-07-22 15:37:48 +0530180 "execute:webnotes.reload_doc('accounts', 'Print Format', 'Sales Invoice Classic') # 2013-07-22",
181 "execute:webnotes.reload_doc('accounts', 'Print Format', 'Sales Invoice Modern') # 2013-07-22",
182 "execute:webnotes.reload_doc('accounts', 'Print Format', 'Sales Invoice Spartan') # 2013-07-22",
183 "execute:webnotes.reload_doc('selling', 'Print Format', 'Quotation Classic') # 2013-07-22",
184 "execute:webnotes.reload_doc('selling', 'Print Format', 'Quotation Modern') # 2013-07-22",
185 "execute:webnotes.reload_doc('selling', 'Print Format', 'Quotation Spartan') # 2013-07-22",
186 "execute:webnotes.reload_doc('selling', 'Print Format', 'Sales Order Classic') # 2013-07-22",
187 "execute:webnotes.reload_doc('selling', 'Print Format', 'Sales Order Modern') # 2013-07-22",
188 "execute:webnotes.reload_doc('selling', 'Print Format', 'Sales Order Spartan') # 2013-07-22",
189 "execute:webnotes.reload_doc('stock', 'Print Format', 'Delivery Note Classic') # 2013-07-22",
190 "execute:webnotes.reload_doc('stock', 'Print Format', 'Delivery Note Modern') # 2013-07-22",
191 "execute:webnotes.reload_doc('stock', 'Print Format', 'Delivery Note Spartan') # 2013-07-22",
192 "patches.july_2013.p08_custom_print_format_net_total_export",
Anand Doshi4a352312013-07-23 17:54:16 +0530193 "patches.july_2013.p09_remove_website_pyc",
Anand Doshi2b1d33f2013-07-25 17:17:47 +0530194 "patches.july_2013.p10_change_partner_user_to_website_user",
Anand Doshief0ab5d2013-07-29 13:06:50 +0530195 "patches.july_2013.p11_update_price_list_currency",
Anand Doshi25647c42013-07-29 13:31:00 +0530196 "execute:webnotes.bean('Selling Settings').save() #2013-07-29",
Anand Doshie79d57c2013-08-02 19:31:41 +0530197 "patches.august_2013.p01_hr_settings",
Rushabh Mehta0b995402013-08-09 15:29:59 +0530198 "patches.august_2013.p02_rename_price_list",
Anand Doshi9e59aff2013-08-12 20:00:33 +0530199 "patches.august_2013.p03_pos_setting_replace_customer_account",
Rushabh Mehta62030e02013-08-14 18:37:28 +0530200 "patches.august_2013.p05_update_serial_no_status",
Anand Doshi0b6fa012013-08-14 10:50:19 +0530201 "patches.august_2013.p05_employee_birthdays",
Nabin Hait176f3af2013-08-16 16:17:34 +0530202 "execute:webnotes.reload_doc('accounts', 'Print Format', 'POS Invoice') # 2013-08-16",
Anand Doshi42840242013-08-21 12:27:26 +0530203 "patches.august_2013.p06_fix_sle_against_stock_entry",
Akhilesh Darjee12425ce2013-09-02 18:48:39 +0530204 "patches.september_2013.p01_add_user_defaults_from_pos_setting",
205 "execute:webnotes.reload_doc('accounts', 'Print Format', 'POS Invoice') # 2013-09-02",
Anand Doshi215c9012013-09-02 15:38:53 +0530206 "patches.september_2013.p01_fix_buying_amount_gl_entries",
Rushabh Mehta1f166302013-09-02 17:41:43 +0530207 "patches.september_2013.p01_update_communication",
Anand Doshif6e62c92013-09-05 17:11:52 +0530208 "execute:webnotes.reload_doc('setup', 'doctype', 'features_setup') # 2013-09-05",
Nabin Hait3e34a6d2013-09-04 12:54:33 +0530209 "patches.september_2013.p02_fix_serial_no_status",
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +0530210 "patches.september_2013.p03_modify_item_price_include_in_price_list",
Nabin Hait6656acf2013-09-12 11:46:09 +0530211 "patches.september_2013.p03_update_stock_uom_in_sle",
Anand Doshi155d9852013-09-12 17:03:21 +0530212 "patches.september_2013.p03_move_website_to_framework",
Anand Doshi417b2372013-09-19 13:44:52 +0530213 "execute:webnotes.bean('Style Settings').save() #2013-09-19",
Nabin Hait01e6a9c2013-09-24 12:08:31 +0530214 "execute:webnotes.reload_doc('accounts', 'doctype', 'accounts_settings') # 2013-09-24"
215 "execute:webnotes.conn.set_value('Accounts Settings', None, 'frozen_accounts_modifier', 'Accounts Manager') # 2013-09-24",
Rushabh Mehta78d4b492012-11-23 17:53:43 +0530216]