USE trainer_attendance;

CREATE TABLE IF NOT EXISTS app_roles (
  role_key VARCHAR(40) NOT NULL PRIMARY KEY,
  label VARCHAR(191) NOT NULL,
  description VARCHAR(255) NULL,
  icon VARCHAR(60) NOT NULL DEFAULT 'bi-person',
  home_action VARCHAR(60) NOT NULL DEFAULT 'trainee',
  sort_order INT NOT NULL DEFAULT 100,
  is_system TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE users MODIFY role VARCHAR(40) NOT NULL DEFAULT 'trainee';
ALTER TABLE role_permissions MODIFY role VARCHAR(40) NOT NULL;