-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 02, 2026 at 03:43 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `jobsportal2026`
--

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `slug`, `module`, `created_at`, `updated_at`) VALUES
(1, 'View Admin Users', 'admin_users.view', 'Admin Users', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(2, 'Create Admin Users', 'admin_users.create', 'Admin Users', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(3, 'Edit Admin Users', 'admin_users.edit', 'Admin Users', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(4, 'Delete Admin Users', 'admin_users.delete', 'Admin Users', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(5, 'Manage Roles', 'roles.manage', 'Admin Users', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(6, 'List Jobs', 'jobs.view', 'Jobs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(7, 'Create Jobs', 'jobs.create', 'Jobs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(8, 'Edit Jobs', 'jobs.edit', 'Jobs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(9, 'Delete Jobs', 'jobs.delete', 'Jobs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(10, 'Import Jobs', 'jobs.import', 'Jobs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(11, 'List Companies', 'companies.view', 'Companies', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(12, 'Create Companies', 'companies.create', 'Companies', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(13, 'Edit Companies', 'companies.edit', 'Companies', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(14, 'Delete Companies', 'companies.delete', 'Companies', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(15, 'List Site Users', 'site_users.view', 'User Profiles', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(16, 'Create Site Users', 'site_users.create', 'User Profiles', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(17, 'Edit Site Users', 'site_users.edit', 'User Profiles', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(18, 'Delete Site Users', 'site_users.delete', 'User Profiles', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(19, 'List CMS Pages', 'cms.view', 'C.M.S', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(20, 'Create CMS Pages', 'cms.create', 'C.M.S', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(21, 'Edit CMS Pages', 'cms.edit', 'C.M.S', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(22, 'Delete CMS Pages', 'cms.delete', 'C.M.S', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(23, 'Manage Blog', 'blog.manage', 'Blog', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(24, 'Manage SEO', 'seo.manage', 'SEO', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(25, 'List FAQs', 'faq.view', 'FAQs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(26, 'Create/Edit FAQs', 'faq.manage', 'FAQs', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(27, 'List Videos', 'videos.view', 'Videos', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(28, 'Create/Edit Videos', 'videos.manage', 'Videos', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(29, 'List Testimonials', 'testimonials.view', 'Testimonials', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(30, 'Create/Edit Testimonials', 'testimonials.manage', 'Testimonials', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(31, 'List Sliders', 'sliders.view', 'Slider', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(32, 'Create/Edit Sliders', 'sliders.manage', 'Slider', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(33, 'Manage Languages', 'languages.manage', 'Translation', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(34, 'Manage Countries', 'countries.manage', 'Location', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(35, 'Manage Country Details', 'country_details.manage', 'Location', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(36, 'Manage States', 'states.manage', 'Location', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(37, 'Manage Cities', 'cities.manage', 'Location', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(38, 'Manage Packages', 'packages.manage', 'Packages', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(39, 'View Payment History', 'payments.view', 'Payments', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(40, 'View Referrals', 'referrals.view', 'Referral', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(41, 'Manage Job Attributes', 'job_attributes.manage', 'Job Attributes', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(42, 'Site Settings', 'site_settings.manage', 'Manage', '2026-02-01 12:41:24', '2026-02-01 12:41:24'),
(43, 'Manage Widgets', 'widgets.manage', 'Manage', '2026-02-01 12:41:24', '2026-02-01 12:41:24');

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_name` varchar(50) NOT NULL,
  `role_abbreviation` varchar(30) NOT NULL,
  `role_description` varchar(250) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role_name`, `role_abbreviation`, `role_description`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'SUP_ADM', 'Super Admin', NULL, NULL),
(2, 'Sub Admin', 'SUB_ADM', 'Sub Admin', NULL, NULL),
(5, 'Accountant', 'ACC_UR', 'Manage Accountant', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `role_permission`
--

CREATE TABLE `role_permission` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role_permission`
--

INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES
(5, 38),
(5, 39);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_slug_unique` (`slug`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD PRIMARY KEY (`role_id`,`permission_id`),
  ADD KEY `role_permission_permission_id_foreign` (`permission_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD CONSTRAINT `role_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_permission_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
