-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Aug 25, 2025 at 10:44 AM -- Server version: 8.4.3 -- PHP Version: 8.3.16 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: `upedia_academics` -- -- -------------------------------------------------------- -- -- Table structure for table `staff_scheduleds` -- CREATE TABLE `staff_scheduleds` ( `id` bigint UNSIGNED NOT NULL, `course_name_en` text COLLATE utf8mb4_unicode_ci NOT NULL, `course_name_ar` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `session` int NOT NULL, `schedule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `staff_id` int NOT NULL, `category_id` bigint UNSIGNED NOT NULL, `track_level_id` bigint UNSIGNED NOT NULL, `track_type_id` bigint UNSIGNED NOT NULL, `track_id` bigint UNSIGNED NOT NULL, `schedule_type` enum('course','track') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'course', `meeting_url` varchar(255) COLLATE utf8mb4_unicode_ci 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 `staff_scheduleds` -- INSERT INTO `staff_scheduleds` (`id`, `course_name_en`, `course_name_ar`, `status`, `session`, `schedule`, `start_date`, `end_date`, `staff_id`, `category_id`, `track_level_id`, `track_type_id`, `track_id`, `schedule_type`, `meeting_url`, `created_at`, `updated_at`) VALUES (268, 'Software Testing - 2025-07-26 - 2025-09-06', 'اختبار البرمجيات - 2025-07-26 - 2025-09-06', 'scheduled', 6, 'once', '2025-07-27', '2025-08-31', 52, 6, 121, 1, 27, 'track', NULL, '2025-07-23 12:33:27', '2025-07-23 12:33:27'), (269, 'Demo - 2025-07-23 - 2025-07-23', 'Demo - 2025-07-23 - 2025-07-23', 'scheduled', 1, 'once', '2025-07-23', '2025-07-23', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-23 15:33:31', '2025-07-23 15:33:31'), (270, 'Software Testing - 2025-07-24 - 2025-09-06', 'اختبار البرمجيات - 2025-07-24 - 2025-09-06', 'scheduled', 6, 'once', '2025-07-24', '2025-08-28', 55, 6, 122, 4, 27, 'track', NULL, '2025-07-23 17:08:22', '2025-07-23 17:08:22'), (271, 'Demo - 2025-07-23 - 2025-07-23', 'Demo - 2025-07-23 - 2025-07-23', 'scheduled', 1, 'once', '2025-07-23', '2025-07-23', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-23 17:11:16', '2025-07-23 17:11:16'), (272, 'Software Testing - 2025-07-24 - 2025-08-16', 'اختبار البرمجيات - 2025-07-24 - 2025-08-16', 'scheduled', 6, 'twice', '2025-07-24', '2025-08-11', 57, 6, 122, 2, 27, 'track', 'https://us04web.zoom.us/j/78195773886?pwd=BOTcM5jKtVZmb0698f9MWV6ObiJV6f.1', '2025-07-23 22:38:06', '2025-07-28 10:14:34'), (273, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74645569199?pwd=fBkQ7v9FQy0TMf2P01nPI4FZ9oGEv1.1', '2025-07-24 10:22:51', '2025-07-24 10:56:26'), (274, 'english tracks - 2025-07-24 - 2025-08-23', 'English tracks - 2025-07-24 - 2025-08-23', 'scheduled', 4, 'once', '2025-07-24', '2025-08-14', 33, 1, 2, 2, 1, 'track', NULL, '2025-07-24 10:26:38', '2025-07-24 10:26:38'), (275, 'Software Testing - 2025-07-28 - 2025-08-23', 'اختبار البرمجيات - 2025-07-28 - 2025-08-23', 'scheduled', 6, 'twice', '2025-07-28', '2025-08-14', 57, 6, 121, 1, 27, 'track', 'https://us04web.zoom.us/j/76371961654?pwd=F3pv2wmE23QY7hNOUkhrCTvaB3hGHo.1', '2025-07-24 10:36:09', '2025-07-28 10:20:45'), (276, 'speaking - 2025-07-24 - 2025-07-24', 'speaking - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 33, 2, 0, 0, 5, 'course', 'https://us04web.zoom.us/j/78251812559?pwd=j3bXDiHimLodiWynm0McMxb3K1YbKY.1', '2025-07-24 11:09:39', '2025-07-24 09:20:51'), (277, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 43, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74987988275?pwd=RxSSdVqB0wbfVqbbY5MKVak354B1jc.1', '2025-07-24 12:27:04', '2025-07-24 09:33:54'), (278, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-24 12:38:59', '2025-07-24 12:38:59'), (279, 'extra session - 2025-07-24 - 2025-07-24', 'جلسة إضافية - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 58, 3, 0, 0, 3, 'course', NULL, '2025-07-24 13:53:27', '2025-07-24 13:53:27'), (280, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75909283975?pwd=TvAhrWT47xnTqDrgKeV8FEt2GgMrrA.1', '2025-07-24 13:56:53', '2025-07-24 11:22:30'), (281, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/71742115709?pwd=BjxKnWbDBpxSOdihPhNTdkivYhAH5C.1', '2025-07-24 14:25:39', '2025-07-24 12:16:10'), (282, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-24 15:04:53', '2025-07-24 15:04:53'), (283, 'Software Testing - 2025-07-27 - 2025-08-16', 'اختبار البرمجيات - 2025-07-27 - 2025-08-16', 'scheduled', 6, 'fourth', '2025-07-27', '2025-08-04', 58, 6, 121, 2, 27, 'track', NULL, '2025-07-27 13:50:20', '2025-07-27 13:50:20'), (284, 'Demo - 2025-07-27 - 2025-07-27', 'Demo - 2025-07-27 - 2025-07-27', 'scheduled', 1, 'once', '2025-07-27', '2025-07-27', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/77704631327?pwd=kUbxSa3N3paYDT7zNT4NgycJzkup52.1', '2025-07-27 13:54:03', '2025-07-27 10:57:59'), (285, 'Demo - 2025-07-28 - 2025-08-02', 'Demo - 2025-07-28 - 2025-08-02', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 12:30:09', '2025-07-28 12:30:09'), (286, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 12:32:10', '2025-07-28 12:32:10'), (287, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 39, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72282752788?pwd=3828V3rbWVG4bkMG5myBistovcaQ97.1', '2025-07-28 14:09:00', '2025-07-28 13:58:46'), (288, 'speaking - 2025-07-28 - 2025-07-28', 'speaking - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 33, 2, 0, 0, 5, 'course', NULL, '2025-07-28 16:00:38', '2025-07-28 16:00:38'), (289, 'davd - 2025-07-29 - 2025-09-06', 'david - 2025-07-29 - 2025-09-06', 'scheduled', 5, 'once', '2025-08-03', '2025-08-31', 33, 1, 8, 2, 3, 'track', 'https://us04web.zoom.us/j/74893663134?pwd=HzbQZ56Fgw2PH7qEWGeSLsEwdxSSeG.1', '2025-07-28 16:07:01', '2025-07-28 13:53:35'), (290, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/78070000581?pwd=Q223ppHdDwwbie2M9qxDumIH5B6j5Y.1', '2025-07-28 17:02:11', '2025-07-28 14:04:17'), (291, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 17:05:46', '2025-07-28 17:05:46'), (292, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74549500193?pwd=c6uMokHzaSboCzmwJZpDzNStjyL5rv.1', '2025-07-28 17:30:02', '2025-07-28 14:58:56'), (293, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/77522246424?pwd=L0p9h08NHOk3gLvRpttSjPk401dmWG.1', '2025-07-28 17:50:36', '2025-07-29 12:03:15'), (294, 'speaking - 2025-07-29 - 2025-07-29', 'speaking - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 33, 2, 0, 0, 5, 'course', NULL, '2025-07-29 12:52:59', '2025-07-29 12:52:59'), (295, 'Software Testing - 2025-07-30 - 2025-09-13', 'اختبار البرمجيات - 2025-07-30 - 2025-09-13', 'scheduled', 6, 'once', '2025-08-02', '2025-09-06', 57, 6, 122, 1, 27, 'track', NULL, '2025-07-29 13:28:12', '2025-07-29 13:28:12'), (296, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/79316375858?pwd=DExobofXjr1NVukd4KrpPm2LqxeUvg.1', '2025-07-29 15:07:31', '2025-07-29 12:16:18'), (297, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-29 15:32:16', '2025-07-29 15:32:16'), (298, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-29 15:41:01', '2025-07-29 15:41:01'), (299, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/76585200328?pwd=SKmD4YuEf97oDTXi5ajwagnCxrrrF0.1', '2025-07-29 16:01:41', '2025-07-29 13:04:02'), (300, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75072893646?pwd=CN7oLzaMLbONdNz6SsaS984MQ11bsW.1', '2025-07-29 17:15:50', '2025-07-29 14:19:13'), (301, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74730825344?pwd=8ASMC8tpoN9ZNKswnhIvsblVyMHmky.1', '2025-07-29 17:22:22', '2025-07-29 14:45:50'), (302, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-30 12:34:38', '2025-07-30 12:34:38'), (303, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-30 12:37:28', '2025-07-30 12:37:28'), (305, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-30 16:15:42', '2025-07-30 16:15:42'), (306, 'General - 2025-08-03 - 2025-08-16', 'عام - 2025-08-03 - 2025-08-16', 'scheduled', 2, 'once', '2025-08-01', '2025-08-10', 63, 1, 118, 1, 26, 'track', NULL, '2025-08-03 14:27:45', '2025-08-03 14:27:45'), (315, 'General - 2025-08-04 - 2025-08-23', 'عام - 2025-08-04 - 2025-08-23', 'scheduled', 2, 'once', '2025-08-09', '2025-08-16', 61, 1, 118, 1, 26, 'track', NULL, '2025-08-04 12:50:15', '2025-08-04 12:50:15'), (317, 'General - 2025-08-04 - 2025-08-23', 'عام - 2025-08-04 - 2025-08-23', 'scheduled', 2, 'once', '2025-08-09', '2025-08-16', 63, 1, 118, 1, 26, 'track', NULL, '2025-08-04 12:53:11', '2025-08-04 12:53:11'), (318, 'SDLC - 2025-08-06 - 2025-08-16', 'SDLC - 2025-08-06 - 2025-08-16', 'scheduled', 1, 'once', '2025-08-09', '2025-08-09', 33, 11, 129, 9, 29, 'track', NULL, '2025-08-04 13:05:24', '2025-08-04 13:05:24'), (319, 'Demo - 2025-08-06 - 2025-09-06', 'Demo - 2025-08-06 - 2025-09-06', 'scheduled', 1, 'once', '2025-08-06', '2025-08-06', 43, 9, 0, 0, 6, 'course', NULL, '2025-08-06 14:55:09', '2025-08-06 14:55:09'), (320, 'Demo - 2025-08-07 - 2025-08-07', 'Demo - 2025-08-07 - 2025-08-07', 'scheduled', 1, 'once', '2025-08-07', '2025-08-07', 43, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72834022653?pwd=mteg2nzw3rb6bpP5I46XinxXzqQIf7.1', '2025-08-06 15:49:21', '2025-08-06 12:51:06'), (321, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', NULL, '2025-08-10 12:51:46', '2025-08-10 12:51:46'), (322, 'Demo - 2025-08-10 - 2025-08-10', 'Demo - 2025-08-10 - 2025-08-10', 'scheduled', 1, 'once', '2025-08-10', '2025-08-10', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/79683612209?pwd=FNs2lFQ2YSx5rMVBGJbSccpZF60E9t.1', '2025-08-10 13:34:20', '2025-08-10 10:39:08'), (323, 'Demo - 2025-08-10 - 2025-08-10', 'Demo - 2025-08-10 - 2025-08-10', 'scheduled', 1, 'once', '2025-08-10', '2025-08-10', 68, 9, 0, 0, 6, 'course', NULL, '2025-08-10 15:57:35', '2025-08-10 15:57:35'), (324, 'Demo - 2025-08-11 - 2025-08-11', 'Demo - 2025-08-11 - 2025-08-11', 'scheduled', 1, 'once', '2025-08-11', '2025-08-11', 47, 9, 0, 0, 6, 'course', NULL, '2025-08-11 13:44:39', '2025-08-11 13:44:39'), (325, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75764660413?pwd=ZmQDfYcqmcxP8QWr3lIAHKLE47uz70.1', '2025-08-12 11:14:28', '2025-08-12 08:34:02'), (326, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72410962608?pwd=GllhgkMQXet2IbflUFTy8peLRmQGya.1', '2025-08-12 11:20:44', '2025-08-12 08:39:51'), (327, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 47, 9, 0, 0, 6, 'course', NULL, '2025-08-12 11:54:17', '2025-08-12 11:54:17'); -- -- Indexes for dumped tables -- -- -- Indexes for table `staff_scheduleds` -- ALTER TABLE `staff_scheduleds` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `staff_scheduleds` -- ALTER TABLE `staff_scheduleds` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=328; 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 */;