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

START TRANSACTION;



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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `integrations`
--

CREATE TABLE `integrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `teamswebhook` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `integrations`
--

INSERT INTO `integrations` (`id`, `teamswebhook`, `created_at`, `updated_at`) VALUES
(1, 'https://oryonbiz.webhook.office.com/webhookb2/85f5c5a3-f27a-492e-8c09-4b6193b58f4a@12865514-f6fa-41c1-a8cc-f2bdb7811483/IncomingWebhook/5c161694648045e4bd3c6f87411c3420/2a526e00-d3e7-456c-9455-b5ae68f89609', '2023-08-21 04:58:19', '2023-08-21 04:58:19'),
(2, 'https://oryonbiz.webhook.office.com/webhookb2/85f5c5a3-f27a-492e-8c09-4b6193b58f4a@12865514-f6fa-41c1-a8cc-f2bdb7811483/IncomingWebhook/5c161694648045e4bd3c6f87411c3420/2a526e00-d3e7-456c-9455-b5ae68f89609', '2023-08-25 03:15:12', '2023-08-25 03:15:12'),
(3, 'https://oryonbiz.webhook.office.com/webhookb2/85f5c5a3-f27a-492e-8c09-4b6193b58f4a@12865514-f6fa-41c1-a8cc-f2bdb7811483/IncomingWebhook/5c161694648045e4bd3c6f87411c3420/2a526e00-d3e7-456c-9455-b5ae68f89609', '2023-08-25 03:16:39', '2023-08-25 03:16:39');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2023_07_31_084651_create_admins_table', 1),
(5, '2023_08_02_043511_create_organizations_table', 1),
(6, '2023_08_17_103320_create_integrations_table', 1),
(7, '2023_08_18_051352_create_users_table', 1),
(8, '2023_08_18_051440_create_userportals_table', 1),
(9, '2023_08_18_055031_create_userprofiles_table', 1),
(10, '2023_08_18_070312_add_soft_deletes_column_in_userprofiles_table', 1),
(11, '2023_08_18_092040_create_userexperiences_table', 1),
(12, '2023_08_21_074133_create_usereducations_table', 1),
(13, '2023_08_25_092803_add_fields_to_userprofiles', 2);

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

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `org_name` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `org_logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` (`id`, `org_name`, `filename`, `org_logo`, `created_at`, `updated_at`) VALUES
(1, 'oryon exceeding expectation', '1692613692.png', 'logos/1692613692.png', '2023-08-21 04:58:12', '2023-08-21 04:58:12');

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

--
-- Table structure for table `usereducations`
--

CREATE TABLE `usereducations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `degree` varchar(255) NOT NULL,
  `branch` varchar(255) NOT NULL,
  `college` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usereducations`
--

INSERT INTO `usereducations` (`id`, `user_id`, `degree`, `branch`, `college`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'BE', 'EEE', 'KLN', NULL, '2023-08-21 04:32:22', '2023-08-21 04:32:22'),
(2, 2, 'BE', 'ECE', 'AAA', NULL, '2023-08-21 06:31:41', '2023-08-21 06:31:41'),
(3, 2, 'BE', 'ECE', 'AAA', NULL, '2023-08-21 06:32:36', '2023-08-21 06:32:36'),
(4, 3, 'BCA', 'IT', 'AAA', NULL, '2023-08-21 06:34:44', '2023-08-22 22:47:24'),
(5, 3, 'BCA', 'IT', 'AAA', NULL, '2023-08-21 06:37:02', '2023-08-22 22:47:24'),
(6, 4, 'BBA', 'IT', 'AAA', NULL, '2023-08-21 22:08:08', '2023-08-22 22:45:29'),
(7, 6, 'BE', 'IT', 'AAA', NULL, '2023-08-21 22:20:31', '2023-08-21 22:20:31');

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

--
-- Table structure for table `userexperiences`
--

CREATE TABLE `userexperiences` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `numofexperience` varchar(255) NOT NULL,
  `dateofjoining` date NOT NULL,
  `courses` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userexperiences`
--

INSERT INTO `userexperiences` (`id`, `user_id`, `numofexperience`, `dateofjoining`, `courses`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, '1', '2022-03-21', 'Web developement', NULL, '2023-08-21 04:32:08', '2023-08-22 06:26:22'),
(2, 2, '5', '2023-08-03', 'web developement', NULL, '2023-08-21 06:18:36', '2023-08-22 22:17:04'),
(3, 3, '1', '2023-08-11', 'IOS developement', NULL, '2023-08-21 06:34:36', '2023-08-22 22:46:59'),
(4, 4, '2', '2023-08-01', 'Web developementt', NULL, '2023-08-21 22:07:23', '2023-08-22 22:43:15'),
(5, 5, '3', '2023-08-03', 'Web developement', NULL, '2023-08-21 22:14:51', '2023-08-21 22:14:51'),
(6, 6, '2', '2023-08-10', 'Web developement', NULL, '2023-08-21 22:20:23', '2023-08-21 22:20:23');

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

--
-- Table structure for table `userportals`
--

CREATE TABLE `userportals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `date_field` date NOT NULL,
  `punchintime` time DEFAULT NULL,
  `breakintime` time DEFAULT NULL,
  `breakouttime` time DEFAULT NULL,
  `punchouttime` time DEFAULT NULL,
  `total_shift_time` time DEFAULT NULL,
  `total_working_hours` time DEFAULT NULL,
  `total_break_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userportals`
--

INSERT INTO `userportals` (`id`, `user_id`, `date_field`, `punchintime`, `breakintime`, `breakouttime`, `punchouttime`, `total_shift_time`, `total_working_hours`, `total_break_time`, `created_at`, `updated_at`) VALUES
(1, 1, '2023-08-18', '10:22:35', '10:22:54', '10:23:02', '10:23:13', '01:30:38', '01:00:30', '00:30:08', '2023-08-17 23:22:35', '2023-08-17 23:23:13'),
(2, 6, '2023-08-19', '12:46:17', '12:46:30', '12:46:42', '12:46:52', '02:00:35', '01:30:23', '00:30:12', '2023-08-19 01:46:17', '2023-08-19 01:46:52'),
(3, 1, '2023-08-20', '14:00:00', '15:00:00', '15:20:00', '17:00:00', '03:00:00', '02:40:00', '00:20:00', '2023-08-20 03:49:22', '2023-08-20 03:49:45'),
(4, 1, '2023-08-21', '14:00:00', '15:00:00', '15:30:00', '17:00:00', '03:00:00', '02:00:30', '00:30:00', '2023-08-21 03:49:42', '2023-08-21 03:49:54'),
(5, 2, '2023-08-22', '10:00:00', '11:00:00', '11:45:00', '14:00:00', '04:00:00', '03:15:00', '00:45:00', '2023-08-22 04:24:50', '2023-08-22 04:24:50'),
(6, 3, '2023-08-23', '10:00:00', '12:00:00', '13:45:00', '17:00:00', '07:00:00', '05:15:00', '01:45:00', '2023-08-23 10:36:19', '2023-08-23 10:36:19'),
(7, 1, '2023-08-24', '11:00:00', '13:00:00', '13:30:00', '15:00:00', '03:00:00', '02:30:00', '00:30:00', '2023-08-24 00:00:23', '2023-08-24 00:01:48'),
(8, 1, '2023-08-25', '11:00:00', '15:00:00', '16:00:00', '18:00:00', '07:00:00', '06:00:00', '01:00:00', '2023-08-25 00:01:38', '2023-08-25 00:02:34'),
(9, 1, '2023-07-01', '13:00:00', '14:00:00', '15:00:00', '16:00:00', '03:00:00', '02:00:00', '01:00:00', '2023-07-01 08:00:59', '2023-07-01 08:00:59'),
(10, 3, '2023-06-01', '13:00:00', '14:00:00', '15:00:00', '16:00:00', '03:00:00', '02:00:00', '01:00:00', '2023-06-01 08:00:59', '2023-06-01 08:00:59'),
(11, 1, '2023-08-25', '14:17:20', '14:17:40', '14:17:51', '14:26:21', '00:09:01', '00:08:50', '00:00:11', '2023-08-25 03:17:20', '2023-08-25 03:26:21'),
(12, 1, '2023-08-25', '14:25:25', '14:25:42', '14:26:07', '17:50:47', '03:25:22', '03:24:57', '00:00:25', '2023-08-25 03:25:25', '2023-08-25 06:50:47'),
(13, 1, '2023-08-25', '14:35:23', '17:50:00', '17:50:02', '18:00:00', '04:35:23', '04:35:21', '00:00:02', '2023-08-25 03:35:23', '2023-08-25 06:50:36'),
(14, 1, '2023-08-26', '06:58:54', '12:50:45', '14:17:29', '15:33:02', '08:34:08', '07:07:24', '01:26:44', '2023-08-25 19:58:54', '2023-08-26 04:33:02'),
(15, 1, '2023-08-28', '09:19:18', '13:25:57', '13:49:39', '14:06:55', '04:47:37', '04:23:55', '00:23:42', '2023-08-27 22:19:18', '2023-08-28 03:06:55'),
(16, 1, '2023-08-28', '14:07:05', '14:07:16', '14:07:27', '14:07:39', '00:00:34', '00:00:23', '00:00:11', '2023-08-28 03:07:05', '2023-08-28 03:07:39'),
(17, 1, '2023-08-28', '14:08:40', '14:09:01', '14:09:12', '14:09:51', '00:01:11', '00:01:00', '00:00:11', '2023-08-28 03:08:40', '2023-08-28 03:09:51'),
(18, 1, '2023-08-28', '14:10:25', '14:10:44', '14:11:00', '14:11:27', '00:01:02', '00:00:46', '00:00:16', '2023-08-28 03:10:25', '2023-08-28 03:11:27'),
(19, 1, '2023-08-28', '14:34:56', '14:35:18', '14:35:32', '14:35:43', '00:00:47', '00:00:33', '00:00:14', '2023-08-28 03:34:56', '2023-08-28 03:35:43'),
(20, 1, '2023-08-28', '14:36:33', NULL, NULL, NULL, NULL, NULL, NULL, '2023-08-28 03:36:33', '2023-08-28 03:36:33');

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

--
-- Table structure for table `userprofiles`
--

CREATE TABLE `userprofiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `permanent_id` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `hobbies` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userprofiles`
--

INSERT INTO `userprofiles` (`id`, `user_id`, `permanent_id`, `role`, `photo`, `phonenumber`, `address`, `dob`, `hobbies`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, '119220', 'Jr.Web developer', 'profilephoto/1693014906.png', '9876543213', '23 classic city, Madurai', '1998-07-25', 'Drawing', NULL, '2023-08-21 04:31:48', '2023-08-25 23:38:30'),
(2, 2, NULL, 'Android Developer', 'profilephoto/1692965991.png', '09758627891', 'Madurai', '2023-08-04', 'drawing', NULL, '2023-08-21 06:09:46', '2023-08-21 06:09:46'),
(3, 3, NULL, NULL, '[]', '09758627891', 'Madurai', '2023-08-16', 'Colouring', NULL, '2023-08-21 06:34:22', '2023-08-27 23:28:54'),
(4, 4, NULL, NULL, '[]', '123-496-7991', 'Anna nagar, Madurai', '2023-08-01', 'Drawing', NULL, '2023-08-21 22:07:03', '2023-08-27 23:51:06'),
(5, 5, NULL, NULL, NULL, '948765783', 'Anna nagar, Madurai', '2023-08-03', 'Drawing', NULL, '2023-08-21 22:14:36', '2023-08-21 22:14:36'),
(6, 6, NULL, NULL, NULL, '9876543212', 'Anna nagar, Madurai', '2023-08-11', 'Drawing,painting', NULL, '2023-08-21 22:20:08', '2023-08-22 00:47:01'),
(7, 7, NULL, NULL, NULL, '987654321', '23 classic city, Madurai', '2023-08-03', 'Drawing', NULL, '2023-08-22 22:12:06', '2023-08-22 22:12:06'),
(8, 8, NULL, NULL, NULL, '9876543211', '23 classic city, Madurai', '2023-08-11', 'Drawing', NULL, '2023-08-22 22:15:39', '2023-08-22 22:15:39'),
(9, 9, NULL, NULL, NULL, '9876543216', 'Anna nagar, Madurai', '2023-08-04', 'Drawing', NULL, '2023-08-23 03:09:01', '2023-08-23 03:09:01'),
(10, 10, NULL, NULL, NULL, '987654321', '23 classic city, Madurai', '2023-08-10', 'Drawing', NULL, '2023-08-23 03:11:00', '2023-08-23 03:11:00'),
(11, 11, NULL, NULL, NULL, '9635663565', '23 classic city, Madurai', '2023-08-05', 'Drawing', NULL, '2023-08-23 03:12:14', '2023-08-23 03:12:14'),
(12, 12, NULL, NULL, NULL, '9635663565', 'Anna nagar, Madurai', '2023-08-11', 'Drawing', NULL, '2023-08-23 03:15:42', '2023-08-23 03:15:42'),
(13, 13, NULL, NULL, NULL, '9635663569', 'Anna nagar, Madurai', '2023-08-05', 'Drawing', NULL, '2023-08-25 05:05:33', '2023-08-25 05:05:33'),
(14, 14, '1100192', 'Android Developer', NULL, '9635663565', '23 classic city, Madurai', '2023-08-11', 'Drawing,painting', NULL, '2023-08-25 05:08:19', '2023-08-25 05:08:19'),
(15, 15, '1101098', 'web developer', 'profilephoto/LaFA63RRf7ZFHg06Ep5nIs0ZMVHGxM8urIIFO9M5.png', '98767676767', 'Madurai', '2023-08-19', 'Drawing', NULL, '2023-08-25 05:14:21', '2023-08-25 05:14:21'),
(16, 16, '1101098', 'web developer', 'profilephoto/Y2oiULJSQimoyaW12PKtx1As1j3DZxInEWEFDeX5.png', '98767676767', 'Madurai', '2023-08-19', 'Drawing', NULL, '2023-08-25 05:38:28', '2023-08-25 05:38:28'),
(18, 18, '1100191', 'Web developer', NULL, '9876543211', '23 classic city, Madurai', '2023-08-23', 'Drawing,painting', NULL, '2023-08-25 05:53:51', '2023-08-25 05:53:51'),
(19, 20, '1101098', 'web developer', 'profilephoto/dl24EkS5o6crDtjIg4sMljpFVTCFA8bEkfeJIRLK.png', '98767676767', 'Madurai', '2023-08-19', 'Drawing', NULL, '2023-08-25 05:55:09', '2023-08-25 05:55:09'),
(20, 25, '1100191', 'Web developer', NULL, '9635663569', 'Madurai', '2023-08-10', 'Drawing,painting', NULL, '2023-08-25 06:43:36', '2023-08-25 06:43:36'),
(21, 26, '1100192', 'Web developer', NULL, '9876543211', NULL, NULL, NULL, NULL, '2023-08-25 06:47:48', '2023-08-25 06:47:48'),
(22, 27, '1101098', 'web developer', 'profilephoto/1692965991.png', '98767676767', 'Madurai', '2023-08-19', 'Drawing', NULL, '2023-08-25 06:49:52', '2023-08-25 06:49:52'),
(23, 28, NULL, NULL, 'profilephoto/1693014906.png', NULL, NULL, NULL, NULL, NULL, '2023-08-25 20:25:06', '2023-08-25 20:25:06'),
(24, 29, NULL, NULL, 'profilephoto/1693017665.png', NULL, NULL, NULL, NULL, NULL, '2023-08-25 21:11:05', '2023-08-25 21:11:05');

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

--
-- Indexes for table `usereducations`
--
ALTER TABLE `usereducations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `usereducations_user_id_foreign` (`user_id`);

--
-- Indexes for table `userexperiences`
--
ALTER TABLE `userexperiences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userexperiences_user_id_foreign` (`user_id`);

--
-- Indexes for table `userportals`
--
ALTER TABLE `userportals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userportals_user_id_foreign` (`user_id`);

--
-- Indexes for table `userprofiles`
--
ALTER TABLE `userprofiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userprofiles_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `integrations`
--
ALTER TABLE `integrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `organizations`
--
ALTER TABLE `organizations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `usereducations`
--
ALTER TABLE `usereducations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `userexperiences`
--
ALTER TABLE `userexperiences`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `userportals`
--
ALTER TABLE `userportals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `userprofiles`
--
ALTER TABLE `userprofiles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `usereducations`
--
ALTER TABLE `usereducations`
  ADD CONSTRAINT `usereducations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `userexperiences`
--
ALTER TABLE `userexperiences`
  ADD CONSTRAINT `userexperiences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `userportals`
--
ALTER TABLE `userportals`
  ADD CONSTRAINT `userportals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `userprofiles`
--
ALTER TABLE `userprofiles`
  ADD CONSTRAINT `userprofiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

