-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `compliance`
--

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category_name`, `is_active`) VALUES
(1, 'ISO', 1),
(2, 'SOC', 1);

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `company_name`, `company_description`, `company_address`, `company_email`, `company_contact`, `is_active`) VALUES
(1, 'Stellar Innovation', NULL, '#25/2/2, Arakkonam Road, Near SBI, Sholinghur, Ranipet District, Vellore– 631102', 'contact@stellaripl.com', NULL, 1),
(2, 'Zenith Taxes', NULL, '2605 Maitland Center PKWY - STE. C Maitland, FL 32751-4131 USA', NULL, NULL, 1);

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `company_id`, `department_name`, `department_description`, `is_active`) VALUES
(1, 1, 'Development', NULL, 1),
(2, 2, 'Development', NULL, 1);

--
-- Dumping data for table `frequency`
--

INSERT INTO `frequency` (`id`, `frequency`) VALUES
(1, 'Daily'),
(2, 'Weekly'),
(3, 'Monthly');

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 3),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 5),
(2, 'App\\Models\\User', 6);

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'web', NULL, NULL),
(2, 'Admin', 'web', NULL, NULL),
(3, 'Approver', 'web', NULL, NULL),
(4, 'User', 'web', NULL, NULL);

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `status`) VALUES
(1, 'Open'),
(2, 'In-Progress'),
(3, 'On-Hold'),
(4, 'Completed'),
(5, 'In-Review'),
(6, 'Re-Opened'),
(7, 'Closed'),
(8, 'Outdated');

--
-- Dumping data for table `usertypes`
--

INSERT INTO `usertypes` (`id`, `user_types`) VALUES
(1, 'Super Admin'),
(2, 'Admin'),
(3, 'Approver'),
(4, 'User');
COMMIT;

