-- ============================================
-- BAYAZID FARM MANAGEMENT SYSTEM
-- Employee/Buyer management module — RBAC permissions
-- Run this once, any time after schema_rbac.sql
-- ============================================

USE technica_bayezid;

INSERT IGNORE INTO permissions (name, description) VALUES ('employees.view', 'View employees');
INSERT IGNORE INTO permissions (name, description) VALUES ('employees.add', 'Add employees');
INSERT IGNORE INTO permissions (name, description) VALUES ('employees.edit', 'Edit employees');
INSERT IGNORE INTO permissions (name, description) VALUES ('employees.delete', 'Delete employees');

-- Grant to Admin (all)
INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT 1, id FROM permissions WHERE name LIKE 'employees.%';

-- Manager: everything except delete
INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT 2, id FROM permissions WHERE name LIKE 'employees.%' AND name != 'employees.delete';

-- Staff: view + add only
INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT 3, id FROM permissions WHERE name IN ('employees.view','employees.add');