def execute():
	import webnotes
	from webnotes.modules import reload_doc
	reload_doc('setup', 'doctype', 'manage_account')
	reload_doc('stock', 'doctype', 'item')
	webnotes.conn.sql("delete from `tabDocField` where fieldname='minimum_inventory_level' and parent='item'")
	webnotes.conn.sql("update `tabItem` set re_order_level = minimum_inventory_level where ifnull(re_order_level,0) = 0 ")

def execute():
	from webnotes.model import delete_doc
	from webnotes.modules import reload_doc
	delete_doc("DocType", "SSO Control")
	delete_doc("DocType", "WN ERP Client Control")
	delete_doc("DocType", "Production Tips Common")
	delete_doc("DocType", "DocTrigger")
	delete_doc("Page", "Setup Wizard")
	
	# cleanup control panel
	delete_doc("DocType", "Control Panel")
	reload_doc("core", "doctype", "control_panel")
	
	webnotes.conn.sql("""delete from tabSingles
		where field like 'startup_%' and doctype='Control Panel'""")
	webnotes.conn.sql("""delete from __SessionCache""")

	webnotes.conn.commit()

	# DDLs
	# -------------------
	
	webnotes.conn.sql("drop table if exists tabDocTrigger")	

	try: webnotes.conn.sql("""alter table `tabFile Data` drop column blob_content""")
	except: pass
		
	webnotes.conn.sql("""alter table __PatchLog engine=InnoDB""")

def execute():
    """
		* Reload ToDo
	"""
    from webnotes.modules import reload_doc

    reload_doc("utilities", "doctype", "todo_item")

def execute():
	import webnotes
	webnotes.conn.sql("""delete from `tabSearch Criteria` \
		where name = 'customer_address_contact'""")
		
	from webnotes.modules import reload_doc
	reload_doc('selling', 'report', 'customer_addresses_and_contacts')

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	reload_doc('stock', 'Search Criteria', 'Stock Ledger')

	from webnotes.model import delete_doc
	delete_doc("Report", "Stock Ledger")

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	webnotes.conn.sql("delete from `tabField Mapper Detail` where from_field = 'transaction_date' and parent in ('Sales Order-Delivery Note', 'Purchase Order-Purchase Receipt')")

	reload_doc('stock', 'DocType Mapper', 'Sales Order-Delivery Note')
	reload_doc('stock', 'DocType Mapper', 'Purchase Order-Purchase Receipt')

def execute():
    import webnotes
    from webnotes.modules import reload_doc

    reload_doc("stock", "doctype", "item")

    webnotes.conn.sql("update `tabItem` set re_order_qty = min_order_qty")

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	reload_doc('stock', 'doctype', 'delivery_note_detail')
	reload_doc('stock', 'Print Format', 'Delivery Note Packing List Wise')
	
	webnotes.conn.sql("delete from `tabDocField` where fieldname in ('packed_by', 'packing_checked_by', 'pack_size') and parent = 'Delivery Note'")

def walk_and_sync(start_path, force=0):
	"""walk and sync all doctypes and pages"""
	import os
	from webnotes.modules import reload_doc

	modules = []

	for path, folders, files in os.walk(start_path):
		for f in files:
			if f.endswith(".txt"):
				# great grand-parent folder is module_name
				module_name = path.split(os.sep)[-3]
				if not module_name in modules:
					modules.append(module_name)
				
				# grand parent folder is doctype
				doctype = path.split(os.sep)[-2]
				
				# parent folder is the name
				name = path.split(os.sep)[-1]
				
				if doctype == 'doctype':
					sync(module_name, name, force)
				elif doctype in ['page']:#, 'search_criteria', 'Print Format', 'DocType Mapper']:
					reload_doc(module_name, doctype, name)
					print module_name + ' | ' + doctype + ' | ' + name
					
	return modules

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	sql = webnotes.conn.sql

	reload_doc('hr', 'doctype', 'salary_manager')
	sql("delete from `tabDocField` where parent = 'Salary Manager' and fieldname = 'employment_type'")

def execute():
	import webnotes
	from webnotes.model import delete_doc
	delete_doc("Search Criteria", "sales_order_pending_items1")
	
	webnotes.conn.sql("update `tabSearch Criteria` set module = 'Selling' where module = 'CRM'")
	from webnotes.modules import reload_doc
	reload_doc('selling', 'search_criteria', 'sales_order_pending_items')

def execute():
	from webnotes.model.doc import Document
	from webnotes.modules import reload_doc
	reload_doc('hr', 'search_criteria', 'employeewise_balance_leave_report')
	d = Document('Search Criteria', 'employeewise_balance_leave_report')
	d.criteria_name = 'Employee Leave Balance Report'
	d.description = 'Employeewise Balance Leave Report'
	d.save()

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	
	
	reload_doc('stock', 'doctype', 'landed_cost_wizard')
	reload_doc('stock', 'doctype', 'lc_pr_detail')
	
	webnotes.conn.sql("delete from `tabDocField` where parent ='Landed Cost Purchase Receipt' and fieldname in ('purchase_receipt_no', 'include_in_landed_cost')")

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	from webnotes.model import delete_doc

	delete_doc('DocType', 'Landed Cost Wizard')
	delete_doc('DocType', 'Landed Cost Purchase Receipt')
	reload_doc('stock', 'doctype', 'landed_cost_wizard')
	reload_doc('stock', 'doctype', 'lc_pr_detail')

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	from webnotes.model.code import get_obj

	reload_doc('accounts', 'doctype', 'receivable_voucher')

	reload_doc('setup', 'doctype', 'features_setup')
	get_obj('Features setup').validate()

def execute():
	"""
		* Change option of doclayer's doc_type field
		* Reload doclayer
	"""
	webnotes.conn.sql("""
		UPDATE `tabDocField` SET options=NULL
		WHERE parent='Customize Form' AND fieldname='doc_type'
	""")
	from webnotes.modules import reload_doc
	reload_doc('core', 'doctype', 'doclayer')

def execute():
	"""sync supplier quotatoin and create supplier quotation mappers"""
	webnotes.reload_doc('buying', 'doctype', 'supplier_quotation')
	webnotes.reload_doc('buying', 'doctype', 'supplier_quotation_item')
	webnotes.reload_doc('buying', 'doctype', 'purchase_order')
	webnotes.reload_doc('buying', 'doctype', 'purchase_order_item')
	
	from webnotes.modules import reload_doc
	reload_doc('buying', 'DocType Mapper', 'Material Request-Supplier Quotation')
	reload_doc('buying', 'DocType Mapper', 'Supplier Quotation-Purchase Order')
	

def execute():
	import webnotes
	from webnotes.modules import reload_doc

	reload_doc('accounts', 'doctype', 'receivable_voucher')
	reload_doc('stock', 'doctype', 'delivery_note')
	reload_doc('selling', 'doctype', 'sales_order')
	reload_doc('selling', 'doctype', 'quotation')
	reload_doc('setup', 'doctype', 'manage_account')


	for d in ['Sales Invoice', 'Delivery Note', 'Sales Order', 'Quotation']:
		webnotes.conn.sql("update `tab%s` set price_list_currency = currency, plc_conversion_rate = conversion_rate" % d)

def execute():
	"""
		* Change type of mail_port field to int
		* reload email settings
	"""
	import webnotes
	webnotes.conn.sql("""
		UPDATE `tabDocField` SET fieldtype='Int'
		WHERE parent = 'Email Settings' AND fieldname = 'mail_port'
	""")

	from webnotes.modules import reload_doc
	reload_doc('setup', 'doctype', 'email_settings')

def execute():
	"""
		Install print formats
	"""
	from webnotes.modules import reload_doc
	reload_doc('core', 'doctype', 'print_format')
	
	#copy_doctype_to_pfs()
	global pf_to_install
	for pf in pf_to_install:
	#	install_print_format(pf)
	#	print "Installed PF: " + pf['name']
		reload_doc(pf['module'], 'Print Format', pf['name'])