-- RBAC seed derived from current ShasPOS v3.9.1
SET NAMES utf8mb4;
START TRANSACTION;

INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_SALES','sales','View Sales',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CREATE_SALE','sales','Create Sale',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('HOLD_SALE','sales','Hold Sale',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('DELETE_DRAFT','sales','Delete Draft',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CHANGE_SALE_QUANTITY','sales','Change Sale Quantity',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EDIT_SALE_PRICE','sales','Edit Sale Price',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPLY_DISCOUNT','sales','Apply Discount',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_DISCOUNT','sales','Approve Discount',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VOID_POSTED_SALE','sales','Void Posted Sale',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('REPRINT_RECEIPT','sales','Reprint Receipt',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_RETURNS','returns','View Returns',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CREATE_RETURN','returns','Create Return',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ISSUE_REFUND','returns','Issue Refund',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_REFUND','returns','Approve Refund',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RETURN_WITHOUT_INVOICE','returns','Return Without Invoice',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_PRODUCTS','products','View Products',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ADD_PRODUCT','products','Add Product',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EDIT_PRODUCT','products','Edit Product',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EDIT_PRODUCT_PRICE','products','Edit Product Price',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('DELETE_PRODUCT','products','Delete Product',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('IMPORT_PRODUCTS','products','Import Products',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EXPORT_PRODUCTS','products','Export Products',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_CATEGORIES','products','Manage Categories',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_UNITS','products','Manage Units',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CONFIGURE_BATCH_TRACKING','products','Configure Batch Tracking',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_BUY_PRICE','products','View Buy Price',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_STOCK','inventory','View Stock',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ADJUST_STOCK','inventory','Adjust Stock',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_STOCK_ADJUSTMENT','inventory','Approve Stock Adjustment',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('TRANSFER_STOCK','inventory','Transfer Stock',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RECEIVE_TRANSFER','inventory','Receive Transfer',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_LOCATIONS','inventory','Manage Locations',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('SWITCH_LOCATION','inventory','Switch Location',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ACCESS_ALL_LOCATIONS','inventory','Access All Locations',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_OTHER_LOCATION_STOCK','inventory','View Other Location Stock',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_BATCH','inventory','Manage Batch',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_BATCH_RESTRICTIONS','inventory','Manage Batch Restrictions',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('WRITE_OFF_STOCK','inventory','Write Off Stock',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_STOCK_TAKE','inventory','View Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CREATE_STOCK_TAKE','inventory','Create Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('COUNT_STOCK_TAKE','inventory','Count Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('SUBMIT_STOCK_TAKE','inventory','Submit Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_STOCK_TAKE','inventory','Approve Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('POST_STOCK_TAKE','inventory','Post Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CANCEL_STOCK_TAKE','inventory','Cancel Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EXPORT_STOCK_TAKE','inventory','Export Stock Take',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_SUPPLIERS','purchasing','View Suppliers',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_SUPPLIERS','purchasing','Manage Suppliers',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_PURCHASES','purchasing','View Purchases',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CREATE_PURCHASE','purchasing','Create Purchase',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EDIT_PURCHASE','purchasing','Edit Purchase',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CANCEL_PURCHASE','purchasing','Cancel Purchase',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_PURCHASE_COST','purchasing','View Purchase Cost',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_PURCHASE_ORDERS','purchasing','View Purchase Orders',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CREATE_PURCHASE_ORDER','purchasing','Create Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EDIT_PURCHASE_ORDER','purchasing','Edit Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('SUBMIT_PURCHASE_ORDER','purchasing','Submit Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_PURCHASE_ORDER','purchasing','Approve Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CANCEL_PURCHASE_ORDER','purchasing','Cancel Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RECEIVE_PURCHASE_ORDER','purchasing','Receive Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CLOSE_PURCHASE_ORDER','purchasing','Close Purchase Order',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EXPORT_PURCHASE_ORDERS','purchasing','Export Purchase Orders',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_CUSTOMERS','customers','View Customers',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_CUSTOMERS','customers','Manage Customers',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_CUSTOMER_LEDGER','customers','View Customer Ledger',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ALLOW_CREDIT_SALE','customers','Allow Credit Sale',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RECEIVE_DUE_PAYMENT','customers','Receive Due Payment',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('SET_CREDIT_LIMIT','customers','Set Credit Limit',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('OVERRIDE_CREDIT_LIMIT','customers','Override Credit Limit',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_CASH_REGISTER','cash_register','View Cash Register',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('OPEN_CASH_REGISTER','cash_register','Open Cash Register',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CLOSE_CASH_REGISTER','cash_register','Close Cash Register',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CASH_IN','cash_register','Cash In',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CASH_OUT','cash_register','Cash Out',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('REOPEN_CASH_REGISTER','cash_register','Reopen Cash Register',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_CASH_VARIANCE','cash_register','Approve Cash Variance',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_ALL_CASH_REGISTERS','cash_register','View All Cash Registers',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CLOSE_OTHER_CASH_REGISTER','cash_register','Close Other Cash Register',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_ACCOUNTING','finance','View Accounting',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_SUPPLIER_LEDGER','purchasing','View Supplier Ledger',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('PAY_SUPPLIER','purchasing','Pay Supplier',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_AGING','finance','View Aging',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_FINANCIAL_ACCOUNTS','finance','View Financial Accounts',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_INCOME','finance','View Income',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_INCOME','finance','Manage Income',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_EXPENSES','finance','View Expenses',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_EXPENSES','finance','Manage Expenses',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_PROFIT','finance','View Profit',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_COGS','finance','View Cogs',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_INVENTORY_VALUATION','finance','View Inventory Valuation',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_REPORTS','reports','View Reports',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('EXPORT_DATA','reports','Export Data',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('PRINT_REPORTS','reports','Print Reports',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_STAFF_ACTIVITY','reports','View Staff Activity',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('VIEW_SECURITY_AUDIT','security','View Security Audit',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ACCESS_SECURITY_CENTER','security','Access Security Center',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CHANGE_SETTINGS','security','Change Settings',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('BACKUP_DATABASE','security','Backup Database',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RESTORE_DATABASE','security','Restore Database',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_STAFF','security','Manage Staff',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_ROLES','security','Manage Roles',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_APPROVAL_RULES','security','Manage Approval Rules',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('RESET_STAFF_PIN','security','Reset Staff Pin',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('ENABLE_DISABLE_STAFF','security','Enable Disable Staff',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('APPROVE_MANAGER_OVERRIDE','security','Approve Manager Override',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('CHANGE_SECURITY_SETTINGS','security','Change Security Settings',0) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_STOCK','inventory','Manage Stock',1) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);
INSERT INTO permissions(permission_key,module_key,name,is_legacy) VALUES('MANAGE_CASH_REGISTER','cash_register','Manage Cash Register',1) ON DUPLICATE KEY UPDATE module_key=VALUES(module_key),name=VALUES(name),is_legacy=VALUES(is_legacy);

INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('OWNER','Owner','Immutable business owner with full access.',10,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('ADMIN','Admin','System administration and full operational access.',20,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('MANAGER','Manager','Operational management, approvals and reports.',30,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('SUPERVISOR','Supervisor','Front-desk supervision and controlled approvals.',40,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('CASHIER','Cashier','Standard point-of-sale operations.',50,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('SENIOR_CASHIER','Senior Cashier','POS with limited discount and refund authority.',60,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('INVENTORY_CLERK','Inventory Clerk','Products, stock, batch and purchasing operations.',70,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('ACCOUNTANT','Accountant','Finance, customer ledger and reporting access.',80,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;
INSERT INTO role_templates(role_key,role_name,description,sort_order,is_active) VALUES('AUDITOR','Auditor','Read-only financial, inventory and audit visibility.',90,1) ON DUPLICATE KEY UPDATE role_name=VALUES(role_name),description=VALUES(description),sort_order=VALUES(sort_order),is_active=1;

INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_SALE_PRICE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPLY_DISCOUNT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_DISCOUNT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VOID_POSTED_SALE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_RETURN' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ISSUE_REFUND' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_REFUND' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RETURN_WITHOUT_INVOICE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADD_PRODUCT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT_PRICE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_PRODUCT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='IMPORT_PRODUCTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PRODUCTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CATEGORIES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_UNITS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CONFIGURE_BATCH_TRACKING' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADJUST_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_ADJUSTMENT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='TRANSFER_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_TRANSFER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_LOCATIONS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SWITCH_LOCATION' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_ALL_LOCATIONS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_OTHER_LOCATION_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH_RESTRICTIONS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='WRITE_OFF_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='COUNT_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='POST_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_SUPPLIERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_PURCHASE_ORDER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SET_CREDIT_LIMIT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OVERRIDE_CREDIT_LIMIT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_IN' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_OUT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REOPEN_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_CASH_VARIANCE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_OTHER_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ACCOUNTING' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIER_LEDGER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PAY_SUPPLIER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_AGING' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_FINANCIAL_ACCOUNTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INCOME' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_INCOME' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_EXPENSES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_EXPENSES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PROFIT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_COGS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STAFF_ACTIVITY' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SECURITY_AUDIT' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_SECURITY_CENTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SETTINGS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='BACKUP_DATABASE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RESTORE_DATABASE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STAFF' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_ROLES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_APPROVAL_RULES' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RESET_STAFF_PIN' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ENABLE_DISABLE_STAFF' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_MANAGER_OVERRIDE' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SECURITY_SETTINGS' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STOCK' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CASH_REGISTER' WHERE rt.role_key='OWNER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_SALE_PRICE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPLY_DISCOUNT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_DISCOUNT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VOID_POSTED_SALE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_RETURN' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ISSUE_REFUND' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_REFUND' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RETURN_WITHOUT_INVOICE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADD_PRODUCT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT_PRICE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_PRODUCT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='IMPORT_PRODUCTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PRODUCTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CATEGORIES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_UNITS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CONFIGURE_BATCH_TRACKING' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADJUST_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_ADJUSTMENT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='TRANSFER_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_TRANSFER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_LOCATIONS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SWITCH_LOCATION' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_ALL_LOCATIONS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_OTHER_LOCATION_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH_RESTRICTIONS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='WRITE_OFF_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='COUNT_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='POST_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_SUPPLIERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_PURCHASE_ORDER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SET_CREDIT_LIMIT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OVERRIDE_CREDIT_LIMIT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_IN' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_OUT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REOPEN_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_CASH_VARIANCE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_OTHER_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ACCOUNTING' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIER_LEDGER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PAY_SUPPLIER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_AGING' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_FINANCIAL_ACCOUNTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INCOME' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_INCOME' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_EXPENSES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_EXPENSES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PROFIT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_COGS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STAFF_ACTIVITY' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SECURITY_AUDIT' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_SECURITY_CENTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SETTINGS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='BACKUP_DATABASE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RESTORE_DATABASE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STAFF' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_ROLES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_APPROVAL_RULES' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RESET_STAFF_PIN' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ENABLE_DISABLE_STAFF' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_MANAGER_OVERRIDE' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SECURITY_SETTINGS' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STOCK' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CASH_REGISTER' WHERE rt.role_key='ADMIN' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_SALE_PRICE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPLY_DISCOUNT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_DISCOUNT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_RETURN' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ISSUE_REFUND' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_REFUND' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADD_PRODUCT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT_PRICE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='IMPORT_PRODUCTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PRODUCTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CATEGORIES' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_UNITS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CONFIGURE_BATCH_TRACKING' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADJUST_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_ADJUSTMENT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='TRANSFER_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_TRANSFER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_LOCATIONS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SWITCH_LOCATION' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_OTHER_LOCATION_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH_RESTRICTIONS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='WRITE_OFF_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='COUNT_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='POST_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_SUPPLIERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_PURCHASE_ORDER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SET_CREDIT_LIMIT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OVERRIDE_CREDIT_LIMIT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_IN' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_OUT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REOPEN_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_CASH_VARIANCE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_OTHER_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ACCOUNTING' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIER_LEDGER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PAY_SUPPLIER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_AGING' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_FINANCIAL_ACCOUNTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INCOME' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_INCOME' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_EXPENSES' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_EXPENSES' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PROFIT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_COGS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STAFF_ACTIVITY' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SECURITY_AUDIT' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_SECURITY_CENTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_MANAGER_OVERRIDE' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STOCK' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CASH_REGISTER' WHERE rt.role_key='MANAGER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPLY_DISCOUNT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPROVE_DISCOUNT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_RETURN' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ISSUE_REFUND' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='COUNT_STOCK_TAKE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_STOCK_TAKE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SWITCH_LOCATION' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_IN' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CASH_OUT' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CASH_REGISTER' WHERE rt.role_key='SUPERVISOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_SALE' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='HOLD_SALE' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='DELETE_DRAFT' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CHANGE_SALE_QUANTITY' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='APPLY_DISCOUNT' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='REPRINT_RECEIPT' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_RETURN' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ISSUE_REFUND' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CUSTOMERS' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ALLOW_CREDIT_SALE' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='OPEN_CASH_REGISTER' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CLOSE_CASH_REGISTER' WHERE rt.role_key='SENIOR_CASHIER' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADD_PRODUCT' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PRODUCT' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='IMPORT_PRODUCTS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PRODUCTS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_CATEGORIES' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_UNITS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CONFIGURE_BATCH_TRACKING' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ADJUST_STOCK' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='COUNT_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='POST_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CANCEL_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='TRANSFER_STOCK' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_TRANSFER' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SWITCH_LOCATION' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_OTHER_LOCATION_STOCK' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_BATCH' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIERS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_SUPPLIERS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='CREATE_PURCHASE_ORDER' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EDIT_PURCHASE_ORDER' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='SUBMIT_PURCHASE_ORDER' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_PURCHASE_ORDER' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_STOCK' WHERE rt.role_key='INVENTORY_CLERK' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='RECEIVE_DUE_PAYMENT' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ACCOUNTING' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIER_LEDGER' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PAY_SUPPLIER' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_AGING' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_FINANCIAL_ACCOUNTS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INCOME' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_INCOME' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_EXPENSES' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='MANAGE_EXPENSES' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PROFIT' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_COGS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='PRINT_REPORTS' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STAFF_ACTIVITY' WHERE rt.role_key='ACCOUNTANT' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SALES' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_RETURNS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PRODUCTS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_BUY_PRICE' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STOCK_TAKE' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_STOCK_TAKE' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIERS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASES' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_COST' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PURCHASE_ORDERS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_PURCHASE_ORDERS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMERS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CUSTOMER_LEDGER' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_CASH_REGISTER' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ALL_CASH_REGISTERS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_ACCOUNTING' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SUPPLIER_LEDGER' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_AGING' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_FINANCIAL_ACCOUNTS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INCOME' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_EXPENSES' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_PROFIT' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_COGS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_INVENTORY_VALUATION' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_REPORTS' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='EXPORT_DATA' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_STAFF_ACTIVITY' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='VIEW_SECURITY_AUDIT' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);
INSERT INTO role_template_permissions(role_template_id,permission_id,allowed) SELECT rt.id,p.id,1 FROM role_templates rt JOIN permissions p ON p.permission_key='ACCESS_SECURITY_CENTER' WHERE rt.role_key='AUDITOR' ON DUPLICATE KEY UPDATE allowed=VALUES(allowed);

COMMIT;