File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/public/files/DB/abilities.sql
Back
INSERT INTO `abilities` (`name`, `title`, `created_at`, `updated_at`) VALUES ('create-sla', 'Create SLA', NOW(), NOW()), ('view-sla', 'View SLA', NOW(), NOW()), ('update-sla', 'Update SLA', NOW(), NOW()), ('delete-sla', 'Delete SLA', NOW(), NOW()), ('create-category', 'Create CATEGORY', NOW(), NOW()), ('view-category', 'View CATEGORY', NOW(), NOW()), ('update-category', 'Update CATEGORY', NOW(), NOW()), ('delete-category', 'Delete CATEGORY', NOW(), NOW()), ('create-ticket', 'Create TICKET', NOW(), NOW()), ('view-ticket', 'View TICKET', NOW(), NOW()), ('update-ticket', 'Update TICKET', NOW(), NOW()), ('delete-ticket', 'Delete TICKET', NOW(), NOW()), ('assign-ticket', 'Assign TICKET', NOW(), NOW()), ('pick-ticket', 'Pick TICKET', NOW(), NOW()), ('view-dept-ticket', 'View Department TICKET', NOW(), NOW()), ('create-role', 'Create Role', NOW(), NOW()), ('update-role', 'Update Role', NOW(), NOW()), ('delete-role', 'Delete Role', NOW(), NOW()), ('assign-role', 'Assign Role', NOW(), NOW()), ('view-role', 'View Role', NOW(), NOW()), ('assign-permission', 'Assign Permission', NOW(), NOW()), ('view-permission', 'View Permission', NOW(), NOW()); INSERT INTO `roles` (`name`,`title`,`created_at`,`updated_at`) VALUES ('system-admin','System Administrator',NOW(),NOW()), ('admin','Administrator',NOW(),NOW()), ('user','User',NOW(),NOW()), ('support','Support',NOW(),NOW()); INSERT INTO `users` (`asa_id`, `f_name`, `l_name`, `email`, `position`, `password`, `active`, `status`, `created_at`, `updated_at`, `department_id`) VALUES ('00000', 'System', 'Admin', 'sysad@autohubgroup.com', 'SYSTEM ADMIN', '$2a$12$WxRMiPqj/FveVyYQ3d2tk.9BTAID1EyV2zHkmLanxEAWvixx/me3O', 1, 1, NOW(), NOW(), '15')
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings