/home2/mshostin/tmp/sess_d58e35363ea100332ca7ca901298d5ac
PMA_token |s:32:"6f4a6d31697a243c33703f2c653b2e4f"; HMAC_secret |s:16:"d|5zQ@]N)`r!zv<a";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1757048369;}encryption_key|s:32:"�=5O�+WH��: �w��[�������y�Z";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:5:"en_GB";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1757048369;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:3:{s:15:"userprefs_mtime";i:1757048249;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1754873710;}s:17:"server_1_mshostin";a:18:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:3:{i:0;s:15:"mshostin\_wp254";i:1;s:19:"mshostin\_inventory";i:2;s:18:"mshostin\_carnival";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:8:"Plug-ins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:17:"menu-levels-table";a:11:{s:6:"browse";s:6:"Browse";s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:6:"insert";s:6:"Insert";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:10:"privileges";s:10:"Privileges";s:9:"operation";s:10:"Operations";s:8:"tracking";s:8:"Tracking";s:8:"triggers";s:8:"Triggers";}s:19:"profiling_supported";b:1;s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:18:"mshostin@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:1:{i:0;a:2:{s:2:"db";s:17:"mshostin_carnival";s:5:"table";s:11:"permissions";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:17:"mshostin_carnival";s:5:"query";a:9:{s:32:"fd014a83b59a3f1fbce5bfb42d0e5935";a:8:{s:3:"sql";s:70:"-- Disable foreign key checks temporarily
SET FOREIGN_KEY_CHECKS = 0;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"8bac2b29bececfef6e1bbd5e1787d413";a:8:{s:3:"sql";s:52:"-- Truncate the table
TRUNCATE TABLE `permissions`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"9ca3b9a21ef1c4bca7439fbebe2731a4";a:8:{s:3:"sql";s:58:"-- Disable foreign key checks
SET FOREIGN_KEY_CHECKS = 0;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"203049639d7e91886e5aa426da87c24e";a:8:{s:3:"sql";s:63:"-- Now truncate the table safely
TRUNCATE TABLE `permissions`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"74b40250f1d99c2d35d0c0a458aae748";a:8:{s:3:"sql";s:27:"SET FOREIGN_KEY_CHECKS = 0;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"b174e7ce9be0a96914ad859b4f006b66";a:8:{s:3:"sql";s:29:"TRUNCATE TABLE `permissions`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"609afcc94600494f8bcce557e3868831";a:8:{s:3:"sql";s:16061:"-- Insert all permissions
INSERT INTO `permissions` (`name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
('dashboard.edit.profile', 'Edit Profile', 'Edit user profile', 'web', NOW(), NOW()),
('users.update', 'Update User', 'Update user details', 'web', NOW(), NOW()),
('users.profile', 'View Profile', 'View own profile', 'web', NOW(), NOW()),
('users.profile.update', 'Update Profile', 'Update own profile', 'web', NOW(), NOW()),
-- Dashboard
('dashboard.index', 'Dashboard', 'Access dashboard', 'web', NOW(), NOW()),
-- Roles Resource
('roles.index', 'Roles List', 'View all roles', 'web', NOW(), NOW()),
('roles.create', 'Create Role', 'Create new role', 'web', NOW(), NOW()),
('roles.store', 'Store Role', 'Save new role', 'web', NOW(), NOW()),
('roles.show', 'Show Role', 'View single role', 'web', NOW(), NOW()),
('roles.edit', 'Edit Role', 'Edit existing role', 'web', NOW(), NOW()),
('roles.update', 'Update Role', 'Update existing role', 'web', NOW(), NOW()),
('roles.destroy', 'Delete Role', 'Delete existing role', 'web', NOW(), NOW()),
-- Permissions Resource
('permissions.index', 'Permissions List', 'View all permissions', 'web', NOW(), NOW()),
('permissions.create', 'Create Permission', 'Create new permission', 'web', NOW(), NOW()),
('permissions.store', 'Store Permission', 'Save new permission', 'web', NOW(), NOW()),
('permissions.show', 'Show Permission', 'View single permission', 'web', NOW(), NOW()),
('permissions.edit', 'Edit Permission', 'Edit existing permission', 'web', NOW(), NOW()),
('permissions.update', 'Update Permission', 'Update existing permission', 'web', NOW(), NOW()),
('permissions.destroy', 'Delete Permission', 'Delete existing permission', 'web', NOW(), NOW()),
-- Role Permissions Resource
('role_permissions.index', 'Role Permissions', 'View role permissions', 'web', NOW(), NOW()),
('role_permissions.create', 'Create Role Permission', 'Create new role permission', 'web', NOW(), NOW()),
('role_permissions.store', 'Store Role Permission', 'Save role permission', 'web', NOW(), NOW()),
('role_permissions.show', 'Show Role Permission', 'View single role permission', 'web', NOW(), NOW()),
('role_permissions.edit', 'Edit Role Permission', 'Edit existing role permission', 'web', NOW(), NOW()),
('role_permissions.update', 'Update Role Permission', 'Update role permission', 'web', NOW(), NOW()),
('role_permissions.destroy', 'Delete Role Permission', 'Delete role permission', 'web', NOW(), NOW()),
('get_permissions_by_role', 'Get Permissions by Role', 'Fetch permissions for a role', 'web', NOW(), NOW()),
('get_permissions_by_package', 'Get Permissions by Package', 'Fetch permissions for a package', 'web', NOW(), NOW()),
('role_permissions.detach', 'Detach Permission', 'Detach permission from package', 'web', NOW(), NOW()),
-- Packages Resource
('packages.index', 'Packages List', 'View all packages', 'web', NOW(), NOW()),
('packages.create', 'Create Package', 'Create new package', 'web', NOW(), NOW()),
('packages.store', 'Store Package', 'Save new package', 'web', NOW(), NOW()),
('packages.show', 'Show Package', 'View single package', 'web', NOW(), NOW()),
('packages.edit', 'Edit Package', 'Edit existing package', 'web', NOW(), NOW()),
('packages.update', 'Update Package', 'Update existing package', 'web', NOW(), NOW()),
('packages.destroy', 'Delete Package', 'Delete existing package', 'web', NOW(), NOW()),
-- Products Resource
('products.index', 'Products List', 'View all products', 'web', NOW(), NOW()),
('products.create', 'Create Product', 'Create new product', 'web', NOW(), NOW()),
('products.store', 'Store Product', 'Save new product', 'web', NOW(), NOW()),
('products.show', 'Show Product', 'View single product', 'web', NOW(), NOW()),
('products.edit', 'Edit Product', 'Edit existing product', 'web', NOW(), NOW()),
('products.update', 'Update Product', 'Update existing product', 'web', NOW(), NOW()),
('products.destroy', 'Delete Product', 'Delete existing product', 'web', NOW(), NOW()),
-- Costumes Resource
('costumes.index', 'Costumes List', 'View all costumes', 'web', NOW(), NOW()),
('costumes.create', 'Create Costume', 'Create new costume', 'web', NOW(), NOW()),
('costumes.store', 'Store Costume', 'Save new costume', 'web', NOW(), NOW()),
('costumes.show', 'Show Costume', 'View single costume', 'web', NOW(), NOW()),
('costumes.edit', 'Edit Costume', 'Edit existing costume', 'web', NOW(), NOW()),
('costumes.update', 'Update Costume', 'Update existing costume', 'web', NOW(), NOW()),
('costumes.destroy', 'Delete Costume', 'Delete existing costume', 'web', NOW(), NOW()),
-- Events Resource
('events.index', 'Events List', 'View all events', 'web', NOW(), NOW()),
('events.create', 'Create Event', 'Create new event', 'web', NOW(), NOW()),
('events.store', 'Store Event', 'Save new event', 'web', NOW(), NOW()),
('events.show', 'Show Event', 'View single event', 'web', NOW(), NOW()),
('events.edit', 'Edit Event', 'Edit existing event', 'web', NOW(), NOW()),
('events.update', 'Update Event', 'Update existing event', 'web', NOW(), NOW()),
('events.destroy', 'Delete Event', 'Delete existing event', 'web', NOW(), NOW()),
-- Blogs Resource
('blogs.index', 'Blogs List', 'View all blogs', 'web', NOW(), NOW()),
('blogs.create', 'Create Blog', 'Create new blog', 'web', NOW(), NOW()),
('blogs.store', 'Store Blog', 'Save new blog', 'web', NOW(), NOW()),
('blogs.show', 'Show Blog', 'View single blog', 'web', NOW(), NOW()),
('blogs.edit', 'Edit Blog', 'Edit existing blog', 'web', NOW(), NOW()),
('blogs.update', 'Update Blog', 'Update existing blog', 'web', NOW(), NOW()),
('blogs.destroy', 'Delete Blog', 'Delete existing blog', 'web', NOW(), NOW()),
-- Categories Resource
('categories.index', 'Categories List', 'View all categories', 'web', NOW(), NOW()),
('categories.create', 'Create Category', 'Create new category', 'web', NOW(), NOW()),
('categories.store', 'Store Category', 'Save new category', 'web', NOW(), NOW()),
('categories.show', 'Show Category', 'View single category', 'web', NOW(), NOW()),
('categories.edit', 'Edit Category', 'Edit existing category', 'web', NOW(), NOW()),
('categories.update', 'Update Category', 'Update existing category', 'web', NOW(), NOW()),
('categories.destroy', 'Delete Category', 'Delete existing category', 'web', NOW(), NOW()),
-- Subcategories Resource
('subcategories.index', 'Subcategories List', 'View all subcategories', 'web', NOW(), NOW()),
('subcategories.create', 'Create Subcategory', 'Create new subcategory', 'web', NOW(), NOW()),
('subcategories.store', 'Store Subcategory', 'Save new subcategory', 'web', NOW(), NOW()),
('subcategories.show', 'Show Subcategory', 'View single subcategory', 'web', NOW(), NOW()),
('subcategories.edit', 'Edit Subcategory', 'Edit existing subcategory', 'web', NOW(), NOW()),
('subcategories.update', 'Update Subcategory', 'Update existing subcategory', 'web', NOW(), NOW()),
('subcategories.destroy', 'Delete Subcategory', 'Delete existing subcategory', 'web', NOW(), NOW()),
-- Features Resource
('features.index', 'Features List', 'View all features', 'web', NOW(), NOW()),
('features.create', 'Create Feature', 'Create new feature', 'web', NOW(), NOW()),
('features.store', 'Store Feature', 'Save new feature', 'web', NOW(), NOW()),
('features.show', 'Show Feature', 'View single feature', 'web', NOW(), NOW()),
('features.edit', 'Edit Feature', 'Edit existing feature', 'web', NOW(), NOW()),
('features.update', 'Update Feature', 'Update existing feature', 'web', NOW(), NOW()),
('features.destroy', 'Delete Feature', 'Delete existing feature', 'web', NOW(), NOW()),
-- States Resource
('states.index', 'States List', 'View all states', 'web', NOW(), NOW()),
('states.create', 'Create State', 'Create new state', 'web', NOW(), NOW()),
('states.store', 'Store State', 'Save new state', 'web', NOW(), NOW()),
('states.show', 'Show State', 'View single state', 'web', NOW(), NOW()),
('states.edit', 'Edit State', 'Edit existing state', 'web', NOW(), NOW()),
('states.update', 'Update State', 'Update existing state', 'web', NOW(), NOW()),
('states.destroy', 'Delete State', 'Delete existing state', 'web', NOW(), NOW()),
-- Musics Resource
('musics.index', 'Musics List', 'View all musics', 'web', NOW(), NOW()),
('musics.create', 'Create Music', 'Create new music', 'web', NOW(), NOW()),
('musics.store', 'Store Music', 'Save new music', 'web', NOW(), NOW()),
('musics.show', 'Show Music', 'View single music', 'web', NOW(), NOW()),
('musics.edit', 'Edit Music', 'Edit existing music', 'web', NOW(), NOW()),
('musics.update', 'Update Music', 'Update existing music', 'web', NOW(), NOW()),
('musics.destroy', 'Delete Music', 'Delete existing music', 'web', NOW(), NOW()),
-- Services Resource
('services.index', 'Services List', 'View all services', 'web', NOW(), NOW()),
('services.create', 'Create Service', 'Create new service', 'web', NOW(), NOW()),
('services.store', 'Store Service', 'Save new service', 'web', NOW(), NOW()),
('services.show', 'Show Service', 'View single service', 'web', NOW(), NOW()),
('services.edit', 'Edit Service', 'Edit existing service', 'web', NOW(), NOW()),
('services.update', 'Update Service', 'Update existing service', 'web', NOW(), NOW()),
('services.destroy', 'Delete Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Orders Resource
('orders.index', 'Orders List', 'View all orders', 'web', NOW(), NOW()),
('orders.create', 'Create Order', 'Create new order', 'web', NOW(), NOW()),
('orders.store', 'Store Order', 'Save new order', 'web', NOW(), NOW()),
('orders.show', 'Show Order', 'View single order', 'web', NOW(), NOW()),
('orders.edit', 'Edit Order', 'Edit existing order', 'web', NOW(), NOW()),
('orders.update', 'Update Order', 'Update existing order', 'web', NOW(), NOW()),
('orders.destroy', 'Delete Order', 'Delete existing order', 'web', NOW(), NOW()),
-- Carnivals Resource
('carnivals.index', 'Carnivals List', 'View all carnivals', 'web', NOW(), NOW()),
('carnivals.create', 'Create Carnival', 'Create new carnival', 'web', NOW(), NOW()),
('carnivals.store', 'Store Carnival', 'Save new carnival', 'web', NOW(), NOW()),
('carnivals.show', 'Show Carnival', 'View single carnival', 'web', NOW(), NOW()),
('carnivals.edit', 'Edit Carnival', 'Edit existing carnival', 'web', NOW(), NOW()),
('carnivals.update', 'Update Carnival', 'Update existing carnival', 'web', NOW(), NOW()),
('carnivals.destroy', 'Delete Carnival', 'Delete existing carnival', 'web', NOW(), NOW()),
-- Regions Resource
('regions.index', 'Regions List', 'View all regions', 'web', NOW(), NOW()),
('regions.create', 'Create Region', 'Create new region', 'web', NOW(), NOW()),
('regions.store', 'Store Region', 'Save new region', 'web', NOW(), NOW()),
('regions.show', 'Show Region', 'View single region', 'web', NOW(), NOW()),
('regions.edit', 'Edit Region', 'Edit existing region', 'web', NOW(), NOW()),
('regions.update', 'Update Region', 'Update existing region', 'web', NOW(), NOW()),
('regions.destroy', 'Delete Region', 'Delete existing region', 'web', NOW(), NOW()),
-- Our Services Resource
('our_services.index', 'Our Services List', 'View all our services', 'web', NOW(), NOW()),
('our_services.create', 'Create Our Service', 'Create new service', 'web', NOW(), NOW()),
('our_services.store', 'Store Our Service', 'Save new service', 'web', NOW(), NOW()),
('our_services.show', 'Show Our Service', 'View single service', 'web', NOW(), NOW()),
('our_services.edit', 'Edit Our Service', 'Edit existing service', 'web', NOW(), NOW()),
('our_services.update', 'Update Our Service', 'Update existing service', 'web', NOW(), NOW()),
('our_services.destroy', 'Delete Our Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Site Gallery Resource
('site_gallery.index', 'Site Gallery List', 'View all site gallery', 'web', NOW(), NOW()),
('site_gallery.create', 'Create Site Gallery', 'Create new gallery', 'web', NOW(), NOW()),
('site_gallery.store', 'Store Site Gallery', 'Save new gallery', 'web', NOW(), NOW()),
('site_gallery.show', 'Show Site Gallery', 'View single gallery', 'web', NOW(), NOW()),
('site_gallery.edit', 'Edit Site Gallery', 'Edit existing gallery', 'web', NOW(), NOW()),
('site_gallery.update', 'Update Site Gallery', 'Update existing gallery', 'web', NOW(), NOW()),
('site_gallery.destroy', 'Delete Site Gallery', 'Delete existing gallery', 'web', NOW(), NOW()),
-- Investors Resource
('investors.index', 'Investors List', 'View all investors', 'web', NOW(), NOW()),
('investors.create', 'Create Investor', 'Create new investor', 'web', NOW(), NOW()),
('investors.store', 'Store Investor', 'Save new investor', 'web', NOW(), NOW()),
('investors.show', 'Show Investor', 'View single investor', 'web', NOW(), NOW()),
('investors.edit', 'Edit Investor', 'Edit existing investor', 'web', NOW(), NOW()),
('investors.update', 'Update Investor', 'Update existing investor', 'web', NOW(), NOW()),
('investors.destroy', 'Delete Investor', 'Delete existing investor', 'web', NOW(), NOW()),
-- Brands Resource
('brands.index', 'Brands List', 'View all brands', 'web', NOW(), NOW()),
('brands.create', 'Create Brand', 'Create new brand', 'web', NOW(), NOW()),
('brands.store', 'Store Brand', 'Save new brand', 'web', NOW(), NOW()),
('brands.show', 'Show Brand', 'View single brand', 'web', NOW(), NOW()),
('brands.edit', 'Edit Brand', 'Edit existing brand', 'web', NOW(), NOW()),
('brands.update', 'Update Brand', 'Update existing brand', 'web', NOW(), NOW()),
('brands.destroy', 'Delete Brand', 'Delete existing brand', 'web', NOW(), NOW()),
-- Countries Resource
('countries.index', 'Countries List', 'View all countries', 'web', NOW(), NOW()),
('countries.create', 'Create Country', 'Create new country', 'web', NOW(), NOW()),
('countries.store', 'Store Country', 'Save new country', 'web', NOW(), NOW()),
('countries.show', 'Show Country', 'View single country', 'web', NOW(), NOW()),
('countries.edit', 'Edit Country', 'Edit existing country', 'web', NOW(), NOW()),
('countries.update', 'Update Country', 'Update existing country', 'web', NOW(), NOW()),
('countries.destroy', 'Delete Country', 'Delete existing country', 'web', NOW(), NOW()),
-- Cities Resource
('cities.index', 'Cities List', 'View all cities', 'web', NOW(), NOW()),
('cities.create', 'Create City', 'Create new city', 'web', NOW(), NOW()),
('cities.store', 'Store City', 'Save new city', 'web', NOW(), NOW()),
('cities.show', 'Show City', 'View single city', 'web', NOW(), NOW()),
('cities.edit', 'Edit City', 'Edit existing city', 'web', NOW(), NOW()),
('cities.update', 'Update City', 'Update existing city', 'web', NOW(), NOW()),
('cities.destroy', 'Delete City', 'Delete existing city', 'web', NOW(), NOW()),
-- Events Country Tabs Resource
('events_country_tabs.index', 'Events Country Tabs List', 'View all country tabs', 'web', NOW(), NOW()),
('events_country_tabs.create', 'Create Events Country Tab', 'Create new country tab', 'web', NOW(), NOW()),
('events_country_tabs.store', 'Store Events Country Tab', 'Save new country tab', 'web', NOW(), NOW()),
('events_country_tabs.show', 'Show Events Country Tab', 'View single country tab', 'web', NOW(), NOW()),
('events_country_tabs.edit', 'Edit Events Country Tab', 'Edit existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.update', 'Update Events Country Tab', 'Update existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.destroy', 'Delete Events Country Tab', 'Delete existing country tab', 'web', NOW(), NOW()),
('get.cities.by.country', 'Get Cities by Country', 'Fetch cities by country id', 'web', NOW(), NOW()),
('get.placements', 'Get Placements', 'Fetch placements by carnival id', 'web', NOW(), NOW()),
-- FAQs CRUD
('faqs.index', 'FAQs List', 'View all FAQs', 'web', NOW(), NOW()),
('faqs.create', 'Create FAQ', 'Create new FAQ', 'web', NOW(), NOW;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"653d4fbe7d1ecddc631313fbf59fa06c";a:8:{s:3:"sql";s:16064:"-- Insert all permissions
INSERT INTO `permissions` (`name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
('dashboard.edit.profile', 'Edit Profile', 'Edit user profile', 'web', NOW(), NOW()),
('users.update', 'Update User', 'Update user details', 'web', NOW(), NOW()),
('users.profile', 'View Profile', 'View own profile', 'web', NOW(), NOW()),
('users.profile.update', 'Update Profile', 'Update own profile', 'web', NOW(), NOW()),
-- Dashboard
('dashboard.index', 'Dashboard', 'Access dashboard', 'web', NOW(), NOW()),
-- Roles Resource
('roles.index', 'Roles List', 'View all roles', 'web', NOW(), NOW()),
('roles.create', 'Create Role', 'Create new role', 'web', NOW(), NOW()),
('roles.store', 'Store Role', 'Save new role', 'web', NOW(), NOW()),
('roles.show', 'Show Role', 'View single role', 'web', NOW(), NOW()),
('roles.edit', 'Edit Role', 'Edit existing role', 'web', NOW(), NOW()),
('roles.update', 'Update Role', 'Update existing role', 'web', NOW(), NOW()),
('roles.destroy', 'Delete Role', 'Delete existing role', 'web', NOW(), NOW()),
-- Permissions Resource
('permissions.index', 'Permissions List', 'View all permissions', 'web', NOW(), NOW()),
('permissions.create', 'Create Permission', 'Create new permission', 'web', NOW(), NOW()),
('permissions.store', 'Store Permission', 'Save new permission', 'web', NOW(), NOW()),
('permissions.show', 'Show Permission', 'View single permission', 'web', NOW(), NOW()),
('permissions.edit', 'Edit Permission', 'Edit existing permission', 'web', NOW(), NOW()),
('permissions.update', 'Update Permission', 'Update existing permission', 'web', NOW(), NOW()),
('permissions.destroy', 'Delete Permission', 'Delete existing permission', 'web', NOW(), NOW()),
-- Role Permissions Resource
('role_permissions.index', 'Role Permissions', 'View role permissions', 'web', NOW(), NOW()),
('role_permissions.create', 'Create Role Permission', 'Create new role permission', 'web', NOW(), NOW()),
('role_permissions.store', 'Store Role Permission', 'Save role permission', 'web', NOW(), NOW()),
('role_permissions.show', 'Show Role Permission', 'View single role permission', 'web', NOW(), NOW()),
('role_permissions.edit', 'Edit Role Permission', 'Edit existing role permission', 'web', NOW(), NOW()),
('role_permissions.update', 'Update Role Permission', 'Update role permission', 'web', NOW(), NOW()),
('role_permissions.destroy', 'Delete Role Permission', 'Delete role permission', 'web', NOW(), NOW()),
('get_permissions_by_role', 'Get Permissions by Role', 'Fetch permissions for a role', 'web', NOW(), NOW()),
('get_permissions_by_package', 'Get Permissions by Package', 'Fetch permissions for a package', 'web', NOW(), NOW()),
('role_permissions.detach', 'Detach Permission', 'Detach permission from package', 'web', NOW(), NOW()),
-- Packages Resource
('packages.index', 'Packages List', 'View all packages', 'web', NOW(), NOW()),
('packages.create', 'Create Package', 'Create new package', 'web', NOW(), NOW()),
('packages.store', 'Store Package', 'Save new package', 'web', NOW(), NOW()),
('packages.show', 'Show Package', 'View single package', 'web', NOW(), NOW()),
('packages.edit', 'Edit Package', 'Edit existing package', 'web', NOW(), NOW()),
('packages.update', 'Update Package', 'Update existing package', 'web', NOW(), NOW()),
('packages.destroy', 'Delete Package', 'Delete existing package', 'web', NOW(), NOW()),
-- Products Resource
('products.index', 'Products List', 'View all products', 'web', NOW(), NOW()),
('products.create', 'Create Product', 'Create new product', 'web', NOW(), NOW()),
('products.store', 'Store Product', 'Save new product', 'web', NOW(), NOW()),
('products.show', 'Show Product', 'View single product', 'web', NOW(), NOW()),
('products.edit', 'Edit Product', 'Edit existing product', 'web', NOW(), NOW()),
('products.update', 'Update Product', 'Update existing product', 'web', NOW(), NOW()),
('products.destroy', 'Delete Product', 'Delete existing product', 'web', NOW(), NOW()),
-- Costumes Resource
('costumes.index', 'Costumes List', 'View all costumes', 'web', NOW(), NOW()),
('costumes.create', 'Create Costume', 'Create new costume', 'web', NOW(), NOW()),
('costumes.store', 'Store Costume', 'Save new costume', 'web', NOW(), NOW()),
('costumes.show', 'Show Costume', 'View single costume', 'web', NOW(), NOW()),
('costumes.edit', 'Edit Costume', 'Edit existing costume', 'web', NOW(), NOW()),
('costumes.update', 'Update Costume', 'Update existing costume', 'web', NOW(), NOW()),
('costumes.destroy', 'Delete Costume', 'Delete existing costume', 'web', NOW(), NOW()),
-- Events Resource
('events.index', 'Events List', 'View all events', 'web', NOW(), NOW()),
('events.create', 'Create Event', 'Create new event', 'web', NOW(), NOW()),
('events.store', 'Store Event', 'Save new event', 'web', NOW(), NOW()),
('events.show', 'Show Event', 'View single event', 'web', NOW(), NOW()),
('events.edit', 'Edit Event', 'Edit existing event', 'web', NOW(), NOW()),
('events.update', 'Update Event', 'Update existing event', 'web', NOW(), NOW()),
('events.destroy', 'Delete Event', 'Delete existing event', 'web', NOW(), NOW()),
-- Blogs Resource
('blogs.index', 'Blogs List', 'View all blogs', 'web', NOW(), NOW()),
('blogs.create', 'Create Blog', 'Create new blog', 'web', NOW(), NOW()),
('blogs.store', 'Store Blog', 'Save new blog', 'web', NOW(), NOW()),
('blogs.show', 'Show Blog', 'View single blog', 'web', NOW(), NOW()),
('blogs.edit', 'Edit Blog', 'Edit existing blog', 'web', NOW(), NOW()),
('blogs.update', 'Update Blog', 'Update existing blog', 'web', NOW(), NOW()),
('blogs.destroy', 'Delete Blog', 'Delete existing blog', 'web', NOW(), NOW()),
-- Categories Resource
('categories.index', 'Categories List', 'View all categories', 'web', NOW(), NOW()),
('categories.create', 'Create Category', 'Create new category', 'web', NOW(), NOW()),
('categories.store', 'Store Category', 'Save new category', 'web', NOW(), NOW()),
('categories.show', 'Show Category', 'View single category', 'web', NOW(), NOW()),
('categories.edit', 'Edit Category', 'Edit existing category', 'web', NOW(), NOW()),
('categories.update', 'Update Category', 'Update existing category', 'web', NOW(), NOW()),
('categories.destroy', 'Delete Category', 'Delete existing category', 'web', NOW(), NOW()),
-- Subcategories Resource
('subcategories.index', 'Subcategories List', 'View all subcategories', 'web', NOW(), NOW()),
('subcategories.create', 'Create Subcategory', 'Create new subcategory', 'web', NOW(), NOW()),
('subcategories.store', 'Store Subcategory', 'Save new subcategory', 'web', NOW(), NOW()),
('subcategories.show', 'Show Subcategory', 'View single subcategory', 'web', NOW(), NOW()),
('subcategories.edit', 'Edit Subcategory', 'Edit existing subcategory', 'web', NOW(), NOW()),
('subcategories.update', 'Update Subcategory', 'Update existing subcategory', 'web', NOW(), NOW()),
('subcategories.destroy', 'Delete Subcategory', 'Delete existing subcategory', 'web', NOW(), NOW()),
-- Features Resource
('features.index', 'Features List', 'View all features', 'web', NOW(), NOW()),
('features.create', 'Create Feature', 'Create new feature', 'web', NOW(), NOW()),
('features.store', 'Store Feature', 'Save new feature', 'web', NOW(), NOW()),
('features.show', 'Show Feature', 'View single feature', 'web', NOW(), NOW()),
('features.edit', 'Edit Feature', 'Edit existing feature', 'web', NOW(), NOW()),
('features.update', 'Update Feature', 'Update existing feature', 'web', NOW(), NOW()),
('features.destroy', 'Delete Feature', 'Delete existing feature', 'web', NOW(), NOW()),
-- States Resource
('states.index', 'States List', 'View all states', 'web', NOW(), NOW()),
('states.create', 'Create State', 'Create new state', 'web', NOW(), NOW()),
('states.store', 'Store State', 'Save new state', 'web', NOW(), NOW()),
('states.show', 'Show State', 'View single state', 'web', NOW(), NOW()),
('states.edit', 'Edit State', 'Edit existing state', 'web', NOW(), NOW()),
('states.update', 'Update State', 'Update existing state', 'web', NOW(), NOW()),
('states.destroy', 'Delete State', 'Delete existing state', 'web', NOW(), NOW()),
-- Musics Resource
('musics.index', 'Musics List', 'View all musics', 'web', NOW(), NOW()),
('musics.create', 'Create Music', 'Create new music', 'web', NOW(), NOW()),
('musics.store', 'Store Music', 'Save new music', 'web', NOW(), NOW()),
('musics.show', 'Show Music', 'View single music', 'web', NOW(), NOW()),
('musics.edit', 'Edit Music', 'Edit existing music', 'web', NOW(), NOW()),
('musics.update', 'Update Music', 'Update existing music', 'web', NOW(), NOW()),
('musics.destroy', 'Delete Music', 'Delete existing music', 'web', NOW(), NOW()),
-- Services Resource
('services.index', 'Services List', 'View all services', 'web', NOW(), NOW()),
('services.create', 'Create Service', 'Create new service', 'web', NOW(), NOW()),
('services.store', 'Store Service', 'Save new service', 'web', NOW(), NOW()),
('services.show', 'Show Service', 'View single service', 'web', NOW(), NOW()),
('services.edit', 'Edit Service', 'Edit existing service', 'web', NOW(), NOW()),
('services.update', 'Update Service', 'Update existing service', 'web', NOW(), NOW()),
('services.destroy', 'Delete Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Orders Resource
('orders.index', 'Orders List', 'View all orders', 'web', NOW(), NOW()),
('orders.create', 'Create Order', 'Create new order', 'web', NOW(), NOW()),
('orders.store', 'Store Order', 'Save new order', 'web', NOW(), NOW()),
('orders.show', 'Show Order', 'View single order', 'web', NOW(), NOW()),
('orders.edit', 'Edit Order', 'Edit existing order', 'web', NOW(), NOW()),
('orders.update', 'Update Order', 'Update existing order', 'web', NOW(), NOW()),
('orders.destroy', 'Delete Order', 'Delete existing order', 'web', NOW(), NOW()),
-- Carnivals Resource
('carnivals.index', 'Carnivals List', 'View all carnivals', 'web', NOW(), NOW()),
('carnivals.create', 'Create Carnival', 'Create new carnival', 'web', NOW(), NOW()),
('carnivals.store', 'Store Carnival', 'Save new carnival', 'web', NOW(), NOW()),
('carnivals.show', 'Show Carnival', 'View single carnival', 'web', NOW(), NOW()),
('carnivals.edit', 'Edit Carnival', 'Edit existing carnival', 'web', NOW(), NOW()),
('carnivals.update', 'Update Carnival', 'Update existing carnival', 'web', NOW(), NOW()),
('carnivals.destroy', 'Delete Carnival', 'Delete existing carnival', 'web', NOW(), NOW()),
-- Regions Resource
('regions.index', 'Regions List', 'View all regions', 'web', NOW(), NOW()),
('regions.create', 'Create Region', 'Create new region', 'web', NOW(), NOW()),
('regions.store', 'Store Region', 'Save new region', 'web', NOW(), NOW()),
('regions.show', 'Show Region', 'View single region', 'web', NOW(), NOW()),
('regions.edit', 'Edit Region', 'Edit existing region', 'web', NOW(), NOW()),
('regions.update', 'Update Region', 'Update existing region', 'web', NOW(), NOW()),
('regions.destroy', 'Delete Region', 'Delete existing region', 'web', NOW(), NOW()),
-- Our Services Resource
('our_services.index', 'Our Services List', 'View all our services', 'web', NOW(), NOW()),
('our_services.create', 'Create Our Service', 'Create new service', 'web', NOW(), NOW()),
('our_services.store', 'Store Our Service', 'Save new service', 'web', NOW(), NOW()),
('our_services.show', 'Show Our Service', 'View single service', 'web', NOW(), NOW()),
('our_services.edit', 'Edit Our Service', 'Edit existing service', 'web', NOW(), NOW()),
('our_services.update', 'Update Our Service', 'Update existing service', 'web', NOW(), NOW()),
('our_services.destroy', 'Delete Our Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Site Gallery Resource
('site_gallery.index', 'Site Gallery List', 'View all site gallery', 'web', NOW(), NOW()),
('site_gallery.create', 'Create Site Gallery', 'Create new gallery', 'web', NOW(), NOW()),
('site_gallery.store', 'Store Site Gallery', 'Save new gallery', 'web', NOW(), NOW()),
('site_gallery.show', 'Show Site Gallery', 'View single gallery', 'web', NOW(), NOW()),
('site_gallery.edit', 'Edit Site Gallery', 'Edit existing gallery', 'web', NOW(), NOW()),
('site_gallery.update', 'Update Site Gallery', 'Update existing gallery', 'web', NOW(), NOW()),
('site_gallery.destroy', 'Delete Site Gallery', 'Delete existing gallery', 'web', NOW(), NOW()),
-- Investors Resource
('investors.index', 'Investors List', 'View all investors', 'web', NOW(), NOW()),
('investors.create', 'Create Investor', 'Create new investor', 'web', NOW(), NOW()),
('investors.store', 'Store Investor', 'Save new investor', 'web', NOW(), NOW()),
('investors.show', 'Show Investor', 'View single investor', 'web', NOW(), NOW()),
('investors.edit', 'Edit Investor', 'Edit existing investor', 'web', NOW(), NOW()),
('investors.update', 'Update Investor', 'Update existing investor', 'web', NOW(), NOW()),
('investors.destroy', 'Delete Investor', 'Delete existing investor', 'web', NOW(), NOW()),
-- Brands Resource
('brands.index', 'Brands List', 'View all brands', 'web', NOW(), NOW()),
('brands.create', 'Create Brand', 'Create new brand', 'web', NOW(), NOW()),
('brands.store', 'Store Brand', 'Save new brand', 'web', NOW(), NOW()),
('brands.show', 'Show Brand', 'View single brand', 'web', NOW(), NOW()),
('brands.edit', 'Edit Brand', 'Edit existing brand', 'web', NOW(), NOW()),
('brands.update', 'Update Brand', 'Update existing brand', 'web', NOW(), NOW()),
('brands.destroy', 'Delete Brand', 'Delete existing brand', 'web', NOW(), NOW()),
-- Countries Resource
('countries.index', 'Countries List', 'View all countries', 'web', NOW(), NOW()),
('countries.create', 'Create Country', 'Create new country', 'web', NOW(), NOW()),
('countries.store', 'Store Country', 'Save new country', 'web', NOW(), NOW()),
('countries.show', 'Show Country', 'View single country', 'web', NOW(), NOW()),
('countries.edit', 'Edit Country', 'Edit existing country', 'web', NOW(), NOW()),
('countries.update', 'Update Country', 'Update existing country', 'web', NOW(), NOW()),
('countries.destroy', 'Delete Country', 'Delete existing country', 'web', NOW(), NOW()),
-- Cities Resource
('cities.index', 'Cities List', 'View all cities', 'web', NOW(), NOW()),
('cities.create', 'Create City', 'Create new city', 'web', NOW(), NOW()),
('cities.store', 'Store City', 'Save new city', 'web', NOW(), NOW()),
('cities.show', 'Show City', 'View single city', 'web', NOW(), NOW()),
('cities.edit', 'Edit City', 'Edit existing city', 'web', NOW(), NOW()),
('cities.update', 'Update City', 'Update existing city', 'web', NOW(), NOW()),
('cities.destroy', 'Delete City', 'Delete existing city', 'web', NOW(), NOW()),
-- Events Country Tabs Resource
('events_country_tabs.index', 'Events Country Tabs List', 'View all country tabs', 'web', NOW(), NOW()),
('events_country_tabs.create', 'Create Events Country Tab', 'Create new country tab', 'web', NOW(), NOW()),
('events_country_tabs.store', 'Store Events Country Tab', 'Save new country tab', 'web', NOW(), NOW()),
('events_country_tabs.show', 'Show Events Country Tab', 'View single country tab', 'web', NOW(), NOW()),
('events_country_tabs.edit', 'Edit Events Country Tab', 'Edit existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.update', 'Update Events Country Tab', 'Update existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.destroy', 'Delete Events Country Tab', 'Delete existing country tab', 'web', NOW(), NOW()),
('get.cities.by.country', 'Get Cities by Country', 'Fetch cities by country id', 'web', NOW(), NOW()),
('get.placements', 'Get Placements', 'Fetch placements by carnival id', 'web', NOW(), NOW()),
-- FAQs CRUD
('faqs.index', 'FAQs List', 'View all FAQs', 'web', NOW(), NOW()),
('faqs.create', 'Create FAQ', 'Create new FAQ', 'web', NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"bd3aa6313d9d91bde4c2fa43e55f9f45";a:8:{s:3:"sql";s:27:"SELECT * FROM `permissions`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:1;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:17:"mshostin_carnival";a:1:{s:11:"permissions";a:0:{}}}}}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:"message";s:24988:"<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL query:</strong> <a href="#" class="copyQueryBtn" data-text="-- Insert all permissions
INSERT INTO `permissions` (`name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
('dashboard.edit.profile', 'Edit Profile', 'Edit user profile', 'web', NOW(), NOW()),
('users.update', 'Update User', 'Update user details', 'web', NOW(), NOW()),
('users.profile', 'View Profile', 'View own profile', 'web', NOW(), NOW()),
('users.profile.update', 'Update Profile', 'Update own profile', 'web', NOW(), NOW()),
-- Dashboard
('dashboard.index', 'Dashboard', 'Access dashboard', 'web', NOW(), NOW()),
-- Roles Resource
('roles.index', 'Roles List', 'View all roles', 'web', NOW(), NOW()),
('roles.create', 'Create Role', 'Create new role', 'web', NOW(), NOW()),
('roles.store', 'Store Role', 'Save new role', 'web', NOW(), NOW()),
('roles.show', 'Show Role', 'View single role', 'web', NOW(), NOW()),
('roles.edit', 'Edit Role', 'Edit existing role', 'web', NOW(), NOW()),
('roles.update', 'Update Role', 'Update existing role', 'web', NOW(), NOW()),
('roles.destroy', 'Delete Role', 'Delete existing role', 'web', NOW(), NOW()),
-- Permissions Resource
('permissions.index', 'Permissions List', 'View all permissions', 'web', NOW(), NOW()),
('permissions.create', 'Create Permission', 'Create new permission', 'web', NOW(), NOW()),
('permissions.store', 'Store Permission', 'Save new permission', 'web', NOW(), NOW()),
('permissions.show', 'Show Permission', 'View single permission', 'web', NOW(), NOW()),
('permissions.edit', 'Edit Permission', 'Edit existing permission', 'web', NOW(), NOW()),
('permissions.update', 'Update Permission', 'Update existing permission', 'web', NOW(), NOW()),
('permissions.destroy', 'Delete Permission', 'Delete existing permission', 'web', NOW(), NOW()),
-- Role Permissions Resource
('role_permissions.index', 'Role Permissions', 'View role permissions', 'web', NOW(), NOW()),
('role_permissions.create', 'Create Role Permission', 'Create new role permission', 'web', NOW(), NOW()),
('role_permissions.store', 'Store Role Permission', 'Save role permission', 'web', NOW(), NOW()),
('role_permissions.show', 'Show Role Permission', 'View single role permission', 'web', NOW(), NOW()),
('role_permissions.edit', 'Edit Role Permission', 'Edit existing role permission', 'web', NOW(), NOW()),
('role_permissions.update', 'Update Role Permission', 'Update role permission', 'web', NOW(), NOW()),
('role_permissions.destroy', 'Delete Role Permission', 'Delete role permission', 'web', NOW(), NOW()),
('get_permissions_by_role', 'Get Permissions by Role', 'Fetch permissions for a role', 'web', NOW(), NOW()),
('get_permissions_by_package', 'Get Permissions by Package', 'Fetch permissions for a package', 'web', NOW(), NOW()),
('role_permissions.detach', 'Detach Permission', 'Detach permission from package', 'web', NOW(), NOW()),
-- Packages Resource
('packages.index', 'Packages List', 'View all packages', 'web', NOW(), NOW()),
('packages.create', 'Create Package', 'Create new package', 'web', NOW(), NOW()),
('packages.store', 'Store Package', 'Save new package', 'web', NOW(), NOW()),
('packages.show', 'Show Package', 'View single package', 'web', NOW(), NOW()),
('packages.edit', 'Edit Package', 'Edit existing package', 'web', NOW(), NOW()),
('packages.update', 'Update Package', 'Update existing package', 'web', NOW(), NOW()),
('packages.destroy', 'Delete Package', 'Delete existing package', 'web', NOW(), NOW()),
-- Products Resource
('products.index', 'Products List', 'View all products', 'web', NOW(), NOW()),
('products.create', 'Create Product', 'Create new product', 'web', NOW(), NOW()),
('products.store', 'Store Product', 'Save new product', 'web', NOW(), NOW()),
('products.show', 'Show Product', 'View single product', 'web', NOW(), NOW()),
('products.edit', 'Edit Product', 'Edit existing product', 'web', NOW(), NOW()),
('products.update', 'Update Product', 'Update existing product', 'web', NOW(), NOW()),
('products.destroy', 'Delete Product', 'Delete existing product', 'web', NOW(), NOW()),
-- Costumes Resource
('costumes.index', 'Costumes List', 'View all costumes', 'web', NOW(), NOW()),
('costumes.create', 'Create Costume', 'Create new costume', 'web', NOW(), NOW()),
('costumes.store', 'Store Costume', 'Save new costume', 'web', NOW(), NOW()),
('costumes.show', 'Show Costume', 'View single costume', 'web', NOW(), NOW()),
('costumes.edit', 'Edit Costume', 'Edit existing costume', 'web', NOW(), NOW()),
('costumes.update', 'Update Costume', 'Update existing costume', 'web', NOW(), NOW()),
('costumes.destroy', 'Delete Costume', 'Delete existing costume', 'web', NOW(), NOW()),
-- Events Resource
('events.index', 'Events List', 'View all events', 'web', NOW(), NOW()),
('events.create', 'Create Event', 'Create new event', 'web', NOW(), NOW()),
('events.store', 'Store Event', 'Save new event', 'web', NOW(), NOW()),
('events.show', 'Show Event', 'View single event', 'web', NOW(), NOW()),
('events.edit', 'Edit Event', 'Edit existing event', 'web', NOW(), NOW()),
('events.update', 'Update Event', 'Update existing event', 'web', NOW(), NOW()),
('events.destroy', 'Delete Event', 'Delete existing event', 'web', NOW(), NOW()),
-- Blogs Resource
('blogs.index', 'Blogs List', 'View all blogs', 'web', NOW(), NOW()),
('blogs.create', 'Create Blog', 'Create new blog', 'web', NOW(), NOW()),
('blogs.store', 'Store Blog', 'Save new blog', 'web', NOW(), NOW()),
('blogs.show', 'Show Blog', 'View single blog', 'web', NOW(), NOW()),
('blogs.edit', 'Edit Blog', 'Edit existing blog', 'web', NOW(), NOW()),
('blogs.update', 'Update Blog', 'Update existing blog', 'web', NOW(), NOW()),
('blogs.destroy', 'Delete Blog', 'Delete existing blog', 'web', NOW(), NOW()),
-- Categories Resource
('categories.index', 'Categories List', 'View all categories', 'web', NOW(), NOW()),
('categories.create', 'Create Category', 'Create new category', 'web', NOW(), NOW()),
('categories.store', 'Store Category', 'Save new category', 'web', NOW(), NOW()),
('categories.show', 'Show Category', 'View single category', 'web', NOW(), NOW()),
('categories.edit', 'Edit Category', 'Edit existing category', 'web', NOW(), NOW()),
('categories.update', 'Update Category', 'Update existing category', 'web', NOW(), NOW()),
('categories.destroy', 'Delete Category', 'Delete existing category', 'web', NOW(), NOW()),
-- Subcategories Resource
('subcategories.index', 'Subcategories List', 'View all subcategories', 'web', NOW(), NOW()),
('subcategories.create', 'Create Subcategory', 'Create new subcategory', 'web', NOW(), NOW()),
('subcategories.store', 'Store Subcategory', 'Save new subcategory', 'web', NOW(), NOW()),
('subcategories.show', 'Show Subcategory', 'View single subcategory', 'web', NOW(), NOW()),
('subcategories.edit', 'Edit Subcategory', 'Edit existing subcategory', 'web', NOW(), NOW()),
('subcategories.update', 'Update Subcategory', 'Update existing subcategory', 'web', NOW(), NOW()),
('subcategories.destroy', 'Delete Subcategory', 'Delete existing subcategory', 'web', NOW(), NOW()),
-- Features Resource
('features.index', 'Features List', 'View all features', 'web', NOW(), NOW()),
('features.create', 'Create Feature', 'Create new feature', 'web', NOW(), NOW()),
('features.store', 'Store Feature', 'Save new feature', 'web', NOW(), NOW()),
('features.show', 'Show Feature', 'View single feature', 'web', NOW(), NOW()),
('features.edit', 'Edit Feature', 'Edit existing feature', 'web', NOW(), NOW()),
('features.update', 'Update Feature', 'Update existing feature', 'web', NOW(), NOW()),
('features.destroy', 'Delete Feature', 'Delete existing feature', 'web', NOW(), NOW()),
-- States Resource
('states.index', 'States List', 'View all states', 'web', NOW(), NOW()),
('states.create', 'Create State', 'Create new state', 'web', NOW(), NOW()),
('states.store', 'Store State', 'Save new state', 'web', NOW(), NOW()),
('states.show', 'Show State', 'View single state', 'web', NOW(), NOW()),
('states.edit', 'Edit State', 'Edit existing state', 'web', NOW(), NOW()),
('states.update', 'Update State', 'Update existing state', 'web', NOW(), NOW()),
('states.destroy', 'Delete State', 'Delete existing state', 'web', NOW(), NOW()),
-- Musics Resource
('musics.index', 'Musics List', 'View all musics', 'web', NOW(), NOW()),
('musics.create', 'Create Music', 'Create new music', 'web', NOW(), NOW()),
('musics.store', 'Store Music', 'Save new music', 'web', NOW(), NOW()),
('musics.show', 'Show Music', 'View single music', 'web', NOW(), NOW()),
('musics.edit', 'Edit Music', 'Edit existing music', 'web', NOW(), NOW()),
('musics.update', 'Update Music', 'Update existing music', 'web', NOW(), NOW()),
('musics.destroy', 'Delete Music', 'Delete existing music', 'web', NOW(), NOW()),
-- Services Resource
('services.index', 'Services List', 'View all services', 'web', NOW(), NOW()),
('services.create', 'Create Service', 'Create new service', 'web', NOW(), NOW()),
('services.store', 'Store Service', 'Save new service', 'web', NOW(), NOW()),
('services.show', 'Show Service', 'View single service', 'web', NOW(), NOW()),
('services.edit', 'Edit Service', 'Edit existing service', 'web', NOW(), NOW()),
('services.update', 'Update Service', 'Update existing service', 'web', NOW(), NOW()),
('services.destroy', 'Delete Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Orders Resource
('orders.index', 'Orders List', 'View all orders', 'web', NOW(), NOW()),
('orders.create', 'Create Order', 'Create new order', 'web', NOW(), NOW()),
('orders.store', 'Store Order', 'Save new order', 'web', NOW(), NOW()),
('orders.show', 'Show Order', 'View single order', 'web', NOW(), NOW()),
('orders.edit', 'Edit Order', 'Edit existing order', 'web', NOW(), NOW()),
('orders.update', 'Update Order', 'Update existing order', 'web', NOW(), NOW()),
('orders.destroy', 'Delete Order', 'Delete existing order', 'web', NOW(), NOW()),
-- Carnivals Resource
('carnivals.index', 'Carnivals List', 'View all carnivals', 'web', NOW(), NOW()),
('carnivals.create', 'Create Carnival', 'Create new carnival', 'web', NOW(), NOW()),
('carnivals.store', 'Store Carnival', 'Save new carnival', 'web', NOW(), NOW()),
('carnivals.show', 'Show Carnival', 'View single carnival', 'web', NOW(), NOW()),
('carnivals.edit', 'Edit Carnival', 'Edit existing carnival', 'web', NOW(), NOW()),
('carnivals.update', 'Update Carnival', 'Update existing carnival', 'web', NOW(), NOW()),
('carnivals.destroy', 'Delete Carnival', 'Delete existing carnival', 'web', NOW(), NOW()),
-- Regions Resource
('regions.index', 'Regions List', 'View all regions', 'web', NOW(), NOW()),
('regions.create', 'Create Region', 'Create new region', 'web', NOW(), NOW()),
('regions.store', 'Store Region', 'Save new region', 'web', NOW(), NOW()),
('regions.show', 'Show Region', 'View single region', 'web', NOW(), NOW()),
('regions.edit', 'Edit Region', 'Edit existing region', 'web', NOW(), NOW()),
('regions.update', 'Update Region', 'Update existing region', 'web', NOW(), NOW()),
('regions.destroy', 'Delete Region', 'Delete existing region', 'web', NOW(), NOW()),
-- Our Services Resource
('our_services.index', 'Our Services List', 'View all our services', 'web', NOW(), NOW()),
('our_services.create', 'Create Our Service', 'Create new service', 'web', NOW(), NOW()),
('our_services.store', 'Store Our Service', 'Save new service', 'web', NOW(), NOW()),
('our_services.show', 'Show Our Service', 'View single service', 'web', NOW(), NOW()),
('our_services.edit', 'Edit Our Service', 'Edit existing service', 'web', NOW(), NOW()),
('our_services.update', 'Update Our Service', 'Update existing service', 'web', NOW(), NOW()),
('our_services.destroy', 'Delete Our Service', 'Delete existing service', 'web', NOW(), NOW()),
-- Site Gallery Resource
('site_gallery.index', 'Site Gallery List', 'View all site gallery', 'web', NOW(), NOW()),
('site_gallery.create', 'Create Site Gallery', 'Create new gallery', 'web', NOW(), NOW()),
('site_gallery.store', 'Store Site Gallery', 'Save new gallery', 'web', NOW(), NOW()),
('site_gallery.show', 'Show Site Gallery', 'View single gallery', 'web', NOW(), NOW()),
('site_gallery.edit', 'Edit Site Gallery', 'Edit existing gallery', 'web', NOW(), NOW()),
('site_gallery.update', 'Update Site Gallery', 'Update existing gallery', 'web', NOW(), NOW()),
('site_gallery.destroy', 'Delete Site Gallery', 'Delete existing gallery', 'web', NOW(), NOW()),
-- Investors Resource
('investors.index', 'Investors List', 'View all investors', 'web', NOW(), NOW()),
('investors.create', 'Create Investor', 'Create new investor', 'web', NOW(), NOW()),
('investors.store', 'Store Investor', 'Save new investor', 'web', NOW(), NOW()),
('investors.show', 'Show Investor', 'View single investor', 'web', NOW(), NOW()),
('investors.edit', 'Edit Investor', 'Edit existing investor', 'web', NOW(), NOW()),
('investors.update', 'Update Investor', 'Update existing investor', 'web', NOW(), NOW()),
('investors.destroy', 'Delete Investor', 'Delete existing investor', 'web', NOW(), NOW()),
-- Brands Resource
('brands.index', 'Brands List', 'View all brands', 'web', NOW(), NOW()),
('brands.create', 'Create Brand', 'Create new brand', 'web', NOW(), NOW()),
('brands.store', 'Store Brand', 'Save new brand', 'web', NOW(), NOW()),
('brands.show', 'Show Brand', 'View single brand', 'web', NOW(), NOW()),
('brands.edit', 'Edit Brand', 'Edit existing brand', 'web', NOW(), NOW()),
('brands.update', 'Update Brand', 'Update existing brand', 'web', NOW(), NOW()),
('brands.destroy', 'Delete Brand', 'Delete existing brand', 'web', NOW(), NOW()),
-- Countries Resource
('countries.index', 'Countries List', 'View all countries', 'web', NOW(), NOW()),
('countries.create', 'Create Country', 'Create new country', 'web', NOW(), NOW()),
('countries.store', 'Store Country', 'Save new country', 'web', NOW(), NOW()),
('countries.show', 'Show Country', 'View single country', 'web', NOW(), NOW()),
('countries.edit', 'Edit Country', 'Edit existing country', 'web', NOW(), NOW()),
('countries.update', 'Update Country', 'Update existing country', 'web', NOW(), NOW()),
('countries.destroy', 'Delete Country', 'Delete existing country', 'web', NOW(), NOW()),
-- Cities Resource
('cities.index', 'Cities List', 'View all cities', 'web', NOW(), NOW()),
('cities.create', 'Create City', 'Create new city', 'web', NOW(), NOW()),
('cities.store', 'Store City', 'Save new city', 'web', NOW(), NOW()),
('cities.show', 'Show City', 'View single city', 'web', NOW(), NOW()),
('cities.edit', 'Edit City', 'Edit existing city', 'web', NOW(), NOW()),
('cities.update', 'Update City', 'Update existing city', 'web', NOW(), NOW()),
('cities.destroy', 'Delete City', 'Delete existing city', 'web', NOW(), NOW()),
-- Events Country Tabs Resource
('events_country_tabs.index', 'Events Country Tabs List', 'View all country tabs', 'web', NOW(), NOW()),
('events_country_tabs.create', 'Create Events Country Tab', 'Create new country tab', 'web', NOW(), NOW()),
('events_country_tabs.store', 'Store Events Country Tab', 'Save new country tab', 'web', NOW(), NOW()),
('events_country_tabs.show', 'Show Events Country Tab', 'View single country tab', 'web', NOW(), NOW()),
('events_country_tabs.edit', 'Edit Events Country Tab', 'Edit existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.update', 'Update Events Country Tab', 'Update existing country tab', 'web', NOW(), NOW()),
('events_country_tabs.destroy', 'Delete Events Country Tab', 'Delete existing country tab', 'web', NOW(), NOW()),
('get.cities.by.country', 'Get Cities by Country', 'Fetch cities by country id', 'web', NOW(), NOW()),
('get.placements', 'Get Placements', 'Fetch placements by carnival id', 'web', NOW(), NOW()),
-- FAQs CRUD
('faqs.index', 'FAQs List', 'View all FAQs', 'web', NOW(), NOW()),
('faqs.create', 'Create FAQ', 'Create new FAQ', 'web', NOW(), NOW());">Copy</a>
</p>
<p>
<code class="sql" dir="ltr"><pre>
-- Insert all permissions
INSERT INTO `permissions` (`name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
('dashboard.edit.profile', 'Edit Profile', 'Edit user profile', 'web', NOW(), NOW()),
('users.update', 'Update User', 'Update user details', 'web', NOW(), NOW()),
('users.profile', 'View Profile', 'View own profile', 'web', NOW(), NOW()),
('users.profile.update', 'Update Profile', 'Update own profile', 'web', NOW(), NOW()),
-- Dashboard
('dashboard.index', 'Dashboard', 'Access dashboard', 'web', NOW(), NOW()),
-- Roles Resource
('roles.index', 'Roles List', 'View all roles', 'web', NOW(), NOW()),
('roles.create', 'Create Role', 'Create new role', 'web', NOW(), NOW()),
('roles.store', 'Store Role', 'Save new role', 'web', NOW(), NOW()),
('roles.show', 'Show Role', 'View single role', 'web', NOW(), NOW()),
('roles.edit', 'Edit Role', 'Edit existing role', 'web', NOW(), NOW()),
('roles.update', 'Update Role', 'Update existing role',[...]
</pre></code>
</p>
<p>
<strong>MySQL said: </strong><a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
</p>
<code>#1452 - Cannot add or update a child row: a foreign key constraint fails (`mshostin_carnival`.`permissions`, CONSTRAINT `permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)</code><br></div>";s:11:"go_back_url";s:71:"index.php?route=/table/structure&db=mshostin_carnival&table=permissions";}is_multi_query|b:0;sql_history|a:4:{i:0;a:3:{s:2:"db";s:17:"mshostin_carnival";s:5:"table";s:11:"permissions";s:8:"sqlquery";s:27:"SELECT * FROM `permissions`";}i:1;a:3:{s:2:"db";s:17:"mshostin_carnival";s:5:"table";s:11:"permissions";s:8:"sqlquery";s:27:"SELECT * FROM `permissions`";}i:2;a:3:{s:2:"db";s:17:"mshostin_carnival";s:5:"table";s:11:"permissions";s:8:"sqlquery";s:27:"SELECT * FROM `permissions`";}i:3;a:3:{s:2:"db";s:17:"mshostin_carnival";s:5:"table";s:11:"permissions";s:8:"sqlquery";s:27:"SELECT * FROM `permissions`";}}errors|a:0:{}