import frappe

def execute():
	frappe.reload_doc('website', 'doctype', 'web_page_view', force=True)
	site_url = frappe.utils.get_site_url(frappe.local.site)
	frappe.db.sql("""UPDATE `tabWeb Page View` set is_unique=1 where referrer LIKE '%{0}%'""".format(site_url))

import frappe

def execute():
	frappe.reload_doc('website', 'doctype', 'web_page_view', force=True)
	site_url = frappe.utils.get_site_url(frappe.local.site)
	frappe.db.sql("""UPDATE `tabWeb Page View` set is_unique=1 where referrer LIKE '%{0}%'""".format(site_url))

UPDATE `tabWeb Page View` set is_unique=1 where referrer LIKE '%{0}%'