You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
38 lines
883 B
38 lines
883 B
USE lifanghe_education;
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY()
|
|
WHERE role = 'parent';
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY('*:*:*')
|
|
WHERE role = 'super_admin';
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY(
|
|
'dashboard:view',
|
|
'system:user:view',
|
|
'system:role:view',
|
|
'leads:view',
|
|
'leads:advance',
|
|
'points:view',
|
|
'points:rule',
|
|
'courses:view',
|
|
'courses:add',
|
|
'courses:edit',
|
|
'statistics:view'
|
|
)
|
|
WHERE role = 'campus_admin';
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY('dashboard:view', 'leads:view', 'leads:advance', 'courses:view', 'points:view')
|
|
WHERE role = 'advisor';
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY('dashboard:view', 'leads:view', 'courses:view')
|
|
WHERE role = 'teacher';
|
|
|
|
UPDATE roles
|
|
SET permissions = JSON_ARRAY('dashboard:view', 'points:view', 'points:adjust', 'points:rule', 'points:reward', 'statistics:view')
|
|
WHERE role = 'finance';
|