-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 23, 2025 at 01:16 AM
-- 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: `waleed`
--

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

--
-- Table structure for table `adminpageaccess`
--

CREATE TABLE `adminpageaccess` (
  `access_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `accessSalesBookings` int(11) DEFAULT NULL,
  `accessSalesOfflineCourses` int(11) DEFAULT NULL,
  `accessSalesOnlineCourses` int(11) DEFAULT NULL,
  `incomeBookings` int(11) DEFAULT NULL,
  `incomeOfflineCourses` int(11) DEFAULT NULL,
  `incomeOnlineCourses` int(11) DEFAULT NULL,
  `contentServices` int(11) DEFAULT NULL,
  `contentOfflineCourses` int(11) DEFAULT NULL,
  `contentOnlineCourses` int(11) DEFAULT NULL,
  `contentFreeAssets` int(11) DEFAULT NULL,
  `contentBanners` int(11) DEFAULT NULL,
  `contentDiscountCodes` int(11) DEFAULT NULL,
  `settingsInfoAbout` int(11) DEFAULT NULL,
  `settingsInfoPrivacy` int(11) DEFAULT NULL,
  `settingsInfoTerms` int(11) DEFAULT NULL,
  `users` int(11) DEFAULT NULL,
  `admins` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `adminpageaccess`
--

INSERT INTO `adminpageaccess` (`access_id`, `admin_id`, `accessSalesBookings`, `accessSalesOfflineCourses`, `accessSalesOnlineCourses`, `incomeBookings`, `incomeOfflineCourses`, `incomeOnlineCourses`, `contentServices`, `contentOfflineCourses`, `contentOnlineCourses`, `contentFreeAssets`, `contentBanners`, `contentDiscountCodes`, `settingsInfoAbout`, `settingsInfoPrivacy`, `settingsInfoTerms`, `users`, `admins`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `admin_id` int(11) NOT NULL,
  `adminName` text DEFAULT NULL,
  `adminEmail` text DEFAULT NULL,
  `adminPassword` text DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`admin_id`, `adminName`, `adminEmail`, `adminPassword`, `createdBy`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`) VALUES
(1, 'Jamal Dashti', 'jamal.ahmad@idigitalq8.com', '$2y$10$BgKEo7dfc.DensYTK3XdZOr.bPT0jFjyc6qhCp3WCDW9zhj60SKG.', NULL, NULL, 0, NULL, NULL);

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

--
-- Table structure for table `assettypes`
--

CREATE TABLE `assettypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assettypes`
--

INSERT INTO `assettypes` (`type_id`, `typeName`) VALUES
(1, 'Document'),
(2, 'Image'),
(3, 'Video'),
(4, 'ZIP');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `banner_id` int(11) NOT NULL,
  `bannerType` int(11) DEFAULT NULL,
  `bannerTitle` text DEFAULT NULL,
  `bannerImage` text DEFAULT NULL,
  `bannerContent` text DEFAULT NULL,
  `bannerStatus` int(11) DEFAULT NULL,
  `bannerOrder` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bannerstatuses`
--

CREATE TABLE `bannerstatuses` (
  `status_id` int(11) NOT NULL,
  `statusName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bannerstatuses`
--

INSERT INTO `bannerstatuses` (`status_id`, `statusName`) VALUES
(1, 'Active'),
(2, 'Inactive');

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

--
-- Table structure for table `bannertypes`
--

CREATE TABLE `bannertypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bannertypes`
--

INSERT INTO `bannertypes` (`type_id`, `typeName`) VALUES
(1, 'No Action'),
(2, 'Consultation Service'),
(3, 'Offline Course'),
(4, 'Online Course'),
(5, 'External Page');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `booking_id` int(11) NOT NULL,
  `service_id` int(11) DEFAULT NULL,
  `slot_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `bookingOnlineUrl` text DEFAULT NULL,
  `bookingLocationUrl` text DEFAULT NULL,
  `bookingLocationDesc` text DEFAULT NULL,
  `bookingDt` datetime DEFAULT NULL,
  `bookingOriginalAmount` float DEFAULT NULL,
  `bookingDiscountCode` text DEFAULT NULL,
  `bookingDiscountAmount` float DEFAULT NULL,
  `bookingPaymentAmount` float DEFAULT NULL,
  `bookingStatus` int(11) DEFAULT 1,
  `bookingStatusChangeDt` datetime DEFAULT NULL,
  `bookingPgResponse` text DEFAULT NULL,
  `bookingPgTrackId` text DEFAULT NULL,
  `bookingGoogleEventId` text DEFAULT NULL,
  `isConfirmed` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bookingservicefields`
--

CREATE TABLE `bookingservicefields` (
  `bfield_id` int(11) NOT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `field_id` int(11) DEFAULT NULL,
  `bfieldValue` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bookingservices`
--

CREATE TABLE `bookingservices` (
  `service_id` int(11) NOT NULL,
  `serviceType` int(11) DEFAULT NULL COMMENT '1 = Offline\r\n2 = Online',
  `serviceNameEn` text DEFAULT NULL,
  `serviceNameAr` text DEFAULT NULL,
  `serviceDescEn` text DEFAULT NULL,
  `serviceDescAr` text DEFAULT NULL,
  `serviceShortDescEn` text DEFAULT NULL,
  `serviceShortDescAr` text DEFAULT NULL,
  `serviceImage` text DEFAULT NULL,
  `serviceOrgPrice` float DEFAULT NULL,
  `serviceDisPrice` float DEFAULT NULL,
  `serviceDuration` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bookingserviceslots`
--

CREATE TABLE `bookingserviceslots` (
  `slot_id` int(11) NOT NULL,
  `service_id` int(11) DEFAULT NULL,
  `slotDate` date DEFAULT NULL,
  `slotTime` time DEFAULT NULL,
  `slotStatus` int(11) DEFAULT 1 COMMENT '0 = Booked\r\n1 = Available',
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT 0,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bookingservicetypes`
--

CREATE TABLE `bookingservicetypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookingservicetypes`
--

INSERT INTO `bookingservicetypes` (`type_id`, `typeName`) VALUES
(1, 'Offline'),
(2, 'Online');

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

--
-- Table structure for table `bookingstatuses`
--

CREATE TABLE `bookingstatuses` (
  `status_id` int(11) NOT NULL,
  `statusName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookingstatuses`
--

INSERT INTO `bookingstatuses` (`status_id`, `statusName`) VALUES
(1, 'Pending Payment'),
(2, 'Booked'),
(3, 'Completed'),
(4, 'Cancelled'),
(5, 'Refunded');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `categoryNameEn` text DEFAULT NULL,
  `categoryNameAr` text DEFAULT NULL,
  `categoryOrder` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `checkouttypes`
--

CREATE TABLE `checkouttypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `checkouttypes`
--

INSERT INTO `checkouttypes` (`type_id`, `typeName`) VALUES
(1, 'Service Booking'),
(2, 'Offline Course'),
(3, 'Online Course');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `country_id` int(11) NOT NULL,
  `countryName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`country_id`, `countryName`) VALUES
(1, 'Afghanistan'),
(2, 'Albania'),
(3, 'Algeria'),
(4, 'American Samoa'),
(5, 'Andorra'),
(6, 'Angola'),
(7, 'Anguilla'),
(8, 'Antarctica'),
(9, 'Antigua and Barbuda'),
(10, 'Argentina'),
(11, 'Armenia'),
(12, 'Aruba'),
(13, 'Australia'),
(14, 'Austria'),
(15, 'Azerbaijan'),
(16, 'Bahamas'),
(17, 'Bahrain'),
(18, 'Bangladesh'),
(19, 'Barbados'),
(20, 'Belarus'),
(21, 'Belgium'),
(22, 'Belize'),
(23, 'Benin'),
(24, 'Bermuda'),
(25, 'Bhutan'),
(26, 'Bolivia'),
(27, 'Bosnia and Herzegovina'),
(28, 'Botswana'),
(29, 'Bouvet Island'),
(30, 'Brazil'),
(31, 'British Indian Ocean Territory'),
(32, 'Brunei Darussalam'),
(33, 'Bulgaria'),
(34, 'Burkina Faso'),
(35, 'Burundi'),
(36, 'Cambodia'),
(37, 'Cameroon'),
(38, 'Canada'),
(39, 'Cape Verde'),
(40, 'Cayman Islands'),
(41, 'Central African Republic'),
(42, 'Chad'),
(43, 'Chile'),
(44, 'China'),
(45, 'Christmas Island'),
(46, 'Cocos (Keeling) Islands'),
(47, 'Colombia'),
(48, 'Comoros'),
(49, 'Democratic Republic of the Congo'),
(50, 'Republic of the Congo'),
(51, 'Cook Islands'),
(52, 'Costa Rica'),
(53, 'Croatia (Hrvatska)'),
(54, 'Cuba'),
(55, 'Cyprus'),
(56, 'Czech Republic'),
(57, 'Denmark'),
(58, 'Djibouti'),
(59, 'Dominica'),
(60, 'Dominican Republic'),
(61, 'East Timor'),
(62, 'Ecuador'),
(63, 'Egypt'),
(64, 'El Salvador'),
(65, 'Equatorial Guinea'),
(66, 'Eritrea'),
(67, 'Estonia'),
(68, 'Ethiopia'),
(69, 'Falkland Islands (Malvinas)'),
(70, 'Faroe Islands'),
(71, 'Fiji'),
(72, 'Finland'),
(73, 'France'),
(74, 'France, Metropolitan'),
(75, 'French Guiana'),
(76, 'French Polynesia'),
(77, 'French Southern Territories'),
(78, 'Gabon'),
(79, 'Gambia'),
(80, 'Georgia'),
(81, 'Germany'),
(82, 'Ghana'),
(83, 'Gibraltar'),
(84, 'Guernsey'),
(85, 'Greece'),
(86, 'Greenland'),
(87, 'Grenada'),
(88, 'Guadeloupe'),
(89, 'Guam'),
(90, 'Guatemala'),
(91, 'Guinea'),
(92, 'Guinea-Bissau'),
(93, 'Guyana'),
(94, 'Haiti'),
(95, 'Heard and Mc Donald Islands'),
(96, 'Honduras'),
(97, 'Hong Kong'),
(98, 'Hungary'),
(99, 'Iceland'),
(100, 'India'),
(101, 'Isle of Man'),
(102, 'Indonesia'),
(103, 'Iran (Islamic Republic of)'),
(104, 'Iraq'),
(105, 'Ireland'),
(107, 'Italy'),
(108, 'Ivory Coast'),
(109, 'Jersey'),
(110, 'Jamaica'),
(111, 'Japan'),
(112, 'Jordan'),
(113, 'Kazakhstan'),
(114, 'Kenya'),
(115, 'Kiribati'),
(116, 'South Korea'),
(117, 'North Korea'),
(118, 'Kosovo'),
(119, 'Kuwait'),
(120, 'Kyrgyzstan'),
(121, 'Lao People\'s Democratic Republic'),
(122, 'Latvia'),
(123, 'Lebanon'),
(124, 'Lesotho'),
(125, 'Liberia'),
(126, 'Libyan Arab Jamahiriya'),
(127, 'Liechtenstein'),
(128, 'Lithuania'),
(129, 'Luxembourg'),
(130, 'Macau'),
(131, 'North Macedonia'),
(132, 'Madagascar'),
(133, 'Malawi'),
(134, 'Malaysia'),
(135, 'Maldives'),
(136, 'Mali'),
(137, 'Malta'),
(138, 'Marshall Islands'),
(139, 'Martinique'),
(140, 'Mauritania'),
(141, 'Mauritius'),
(142, 'Mayotte'),
(143, 'Mexico'),
(144, 'Micronesia, Federated States of'),
(145, 'Moldova, Republic of'),
(146, 'Monaco'),
(147, 'Mongolia'),
(148, 'Montenegro'),
(149, 'Montserrat'),
(150, 'Morocco'),
(151, 'Mozambique'),
(152, 'Myanmar'),
(153, 'Namibia'),
(154, 'Nauru'),
(155, 'Nepal'),
(156, 'Netherlands'),
(157, 'Netherlands Antilles'),
(158, 'New Caledonia'),
(159, 'New Zealand'),
(160, 'Nicaragua'),
(161, 'Niger'),
(162, 'Nigeria'),
(163, 'Niue'),
(164, 'Norfolk Island'),
(165, 'Northern Mariana Islands'),
(166, 'Norway'),
(167, 'Oman'),
(168, 'Pakistan'),
(169, 'Palau'),
(170, 'Palestine'),
(171, 'Panama'),
(172, 'Papua New Guinea'),
(173, 'Paraguay'),
(174, 'Peru'),
(175, 'Philippines'),
(176, 'Pitcairn'),
(177, 'Poland'),
(178, 'Portugal'),
(179, 'Puerto Rico'),
(180, 'Qatar'),
(181, 'Reunion'),
(182, 'Romania'),
(183, 'Russian Federation'),
(184, 'Rwanda'),
(185, 'Saint Kitts and Nevis'),
(186, 'Saint Lucia'),
(187, 'Saint Vincent and the Grenadines'),
(188, 'Samoa'),
(189, 'San Marino'),
(190, 'Sao Tome and Principe'),
(191, 'Saudi Arabia'),
(192, 'Senegal'),
(193, 'Serbia'),
(194, 'Seychelles'),
(195, 'Sierra Leone'),
(196, 'Singapore'),
(197, 'Slovakia'),
(198, 'Slovenia'),
(199, 'Solomon Islands'),
(200, 'Somalia'),
(201, 'South Africa'),
(202, 'South Georgia South Sandwich Islands'),
(203, 'South Sudan'),
(204, 'Spain'),
(205, 'Sri Lanka'),
(206, 'St. Helena'),
(207, 'St. Pierre and Miquelon'),
(208, 'Sudan'),
(209, 'Suriname'),
(210, 'Svalbard and Jan Mayen Islands'),
(211, 'Eswatini'),
(212, 'Sweden'),
(213, 'Switzerland'),
(214, 'Syrian Arab Republic'),
(215, 'Taiwan'),
(216, 'Tajikistan'),
(217, 'Tanzania, United Republic of'),
(218, 'Thailand'),
(219, 'Togo'),
(220, 'Tokelau'),
(221, 'Tonga'),
(222, 'Trinidad and Tobago'),
(223, 'Tunisia'),
(224, 'Turkey'),
(225, 'Turkmenistan'),
(226, 'Turks and Caicos Islands'),
(227, 'Tuvalu'),
(228, 'Uganda'),
(229, 'Ukraine'),
(230, 'United Arab Emirates'),
(231, 'United Kingdom'),
(232, 'United States'),
(233, 'United States minor outlying islands'),
(234, 'Uruguay'),
(235, 'Uzbekistan'),
(236, 'Vanuatu'),
(237, 'Vatican City State'),
(238, 'Venezuela'),
(239, 'Vietnam'),
(240, 'Virgin Islands (British)'),
(241, 'Virgin Islands (U.S.)'),
(242, 'Wallis and Futuna Islands'),
(243, 'Western Sahara'),
(244, 'Yemen'),
(245, 'Zambia'),
(246, 'Zimbabwe'),
(248, 'Schengen Area'),
(249, 'Republic of Ireland');

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

--
-- Table structure for table `courseorderstatuses`
--

CREATE TABLE `courseorderstatuses` (
  `status_id` int(11) NOT NULL,
  `statusName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `courseorderstatuses`
--

INSERT INTO `courseorderstatuses` (`status_id`, `statusName`) VALUES
(1, 'Pending Payment'),
(2, 'Paid'),
(3, 'Cancelled'),
(4, 'Refunded');

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

--
-- Table structure for table `coursesorders`
--

CREATE TABLE `coursesorders` (
  `order_id` int(11) NOT NULL,
  `courseType` int(11) DEFAULT NULL COMMENT '1 = Offline\r\n2 = Online',
  `course_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `orderDt` datetime DEFAULT NULL,
  `orderOriginalAmount` float DEFAULT NULL,
  `orderDiscountCode` text DEFAULT NULL,
  `orderDiscountAmount` float DEFAULT NULL,
  `orderPaymentAmount` float DEFAULT NULL,
  `orderStatus` int(11) DEFAULT 1,
  `orderStatusChangeDt` datetime DEFAULT NULL,
  `orderPoints` float DEFAULT NULL,
  `orderPgResponse` text DEFAULT NULL,
  `orderPgTrackId` text DEFAULT NULL,
  `isConfirmed` int(11) DEFAULT 0 COMMENT 'Is confirmation page visited?\r\n0 = No\r\n1 = Yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coursesorders`
--

INSERT INTO `coursesorders` (`order_id`, `courseType`, `course_id`, `user_id`, `orderDt`, `orderOriginalAmount`, `orderDiscountCode`, `orderDiscountAmount`, `orderPaymentAmount`, `orderStatus`, `orderStatusChangeDt`, `orderPoints`, `orderPgResponse`, `orderPgTrackId`, `isConfirmed`) VALUES
(1, 1, 1, 1, '2025-08-22 18:34:21', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(2, 1, 1, 1, '2025-08-22 18:35:08', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(3, 1, 1, 1, '2025-08-22 18:35:53', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(4, 1, 1, 1, '2025-08-22 18:38:25', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(5, 1, 1, 1, '2025-08-22 18:38:49', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(6, 1, 1, 1, '2025-08-22 18:42:35', 10, NULL, 0, 10, 1, NULL, NULL, NULL, NULL, 0),
(7, 2, 1, 1, '2025-08-22 18:43:35', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0),
(8, 2, 1, 1, '2025-08-22 18:53:36', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0),
(9, 2, 1, 1, '2025-08-22 18:53:47', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0),
(10, 2, 1, 1, '2025-08-22 18:54:53', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0),
(11, 2, 1, 1, '2025-08-22 18:55:08', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0),
(12, 2, 1, 1, '2025-08-22 18:56:46', 100, NULL, 0, 100, 1, NULL, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `discountcodes`
--

CREATE TABLE `discountcodes` (
  `code_id` int(11) NOT NULL,
  `codeName` text DEFAULT NULL,
  `codeType` int(11) DEFAULT NULL COMMENT '1 = Public\r\n2 = User Specific',
  `codeText` text DEFAULT NULL,
  `codeValue` float DEFAULT NULL,
  `codeStatus` int(11) DEFAULT NULL COMMENT '0 = Inactive\r\n1 = Active',
  `codeFor` int(11) DEFAULT NULL COMMENT 'User ID The Code is For',
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `fcmtokens`
--

CREATE TABLE `fcmtokens` (
  `fcm_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `fcmToken` text DEFAULT NULL,
  `fcmPlatform` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `freeassets`
--

CREATE TABLE `freeassets` (
  `asset_id` int(11) NOT NULL,
  `assetType` int(11) DEFAULT NULL,
  `assetNameEn` text DEFAULT NULL,
  `assetNameAr` text DEFAULT NULL,
  `assetDescEn` text DEFAULT NULL,
  `assetDescAr` text DEFAULT NULL,
  `assetFileName` text DEFAULT NULL,
  `isHidden` int(11) DEFAULT NULL,
  `hiddenBy` int(11) DEFAULT NULL,
  `hiddenOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `freeassets`
--

INSERT INTO `freeassets` (`asset_id`, `assetType`, `assetNameEn`, `assetNameAr`, `assetDescEn`, `assetDescAr`, `assetFileName`, `isHidden`, `hiddenBy`, `hiddenOn`, `isDeleted`, `deletedBy`, `deletedOn`, `createdBy`, `createdOn`) VALUES
(1, 2, 'test', 'test', NULL, NULL, 'WaleedAlSaleemAsset-68a8f2501a00f.webp', NULL, NULL, NULL, 0, NULL, NULL, 1, '2025-08-23 00:42:24'),
(2, 1, 'geag', 'ththtr', NULL, NULL, 'WaleedAlSaleemAsset-f2532d67d3c8b6b9.pdf', NULL, NULL, NULL, 0, NULL, NULL, 1, '2025-08-23 00:56:15');

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

--
-- Table structure for table `freeassetsdownloads`
--

CREATE TABLE `freeassetsdownloads` (
  `download_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `downloadDt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `freeassetsdownloads`
--

INSERT INTO `freeassetsdownloads` (`download_id`, `user_id`, `asset_id`, `downloadDt`) VALUES
(1, 1, 1, '2025-08-23 01:44:45'),
(2, 1, 1, '2025-08-23 01:45:45'),
(3, 1, 1, '2025-08-23 01:50:26'),
(4, 1, 1, '2025-08-23 01:50:59'),
(5, 1, 1, '2025-08-23 01:53:04'),
(6, 1, 1, '2025-08-23 01:53:37'),
(7, 1, 1, '2025-08-23 01:54:59'),
(8, 1, 1, '2025-08-23 01:55:17'),
(9, 1, 1, '2025-08-23 01:55:38'),
(10, 1, 2, '2025-08-23 01:57:36'),
(11, 1, 2, '2025-08-23 01:57:50'),
(12, 1, 1, '2025-08-23 02:01:33'),
(13, 1, 1, '2025-08-23 02:04:10');

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

--
-- Table structure for table `infoabout`
--

CREATE TABLE `infoabout` (
  `section_id` int(11) NOT NULL,
  `sectionEn` text DEFAULT NULL,
  `sectionAr` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `infoabout`
--

INSERT INTO `infoabout` (`section_id`, `sectionEn`, `sectionAr`) VALUES
(1, 'betgherthg\r\n\r\ntheathet', 'etrhetrhetr\r\n\r\nhteterht');

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

--
-- Table structure for table `infoprivacy`
--

CREATE TABLE `infoprivacy` (
  `section_id` int(11) NOT NULL,
  `sectionEn` text DEFAULT NULL,
  `sectionAr` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `infoprivacy`
--

INSERT INTO `infoprivacy` (`section_id`, `sectionEn`, `sectionAr`) VALUES
(1, NULL, NULL);

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

--
-- Table structure for table `infoterms`
--

CREATE TABLE `infoterms` (
  `section_id` int(11) NOT NULL,
  `sectionEn` text DEFAULT NULL,
  `sectionAr` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `infoterms`
--

INSERT INTO `infoterms` (`section_id`, `sectionEn`, `sectionAr`) VALUES
(1, NULL, NULL);

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

--
-- Table structure for table `offlinecourses`
--

CREATE TABLE `offlinecourses` (
  `course_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `courseNameEn` text DEFAULT NULL,
  `courseNameAr` text DEFAULT NULL,
  `courseDescEn` text DEFAULT NULL,
  `courseDescAr` text DEFAULT NULL,
  `courseLearnEn` text DEFAULT NULL,
  `courseLearnAr` text DEFAULT NULL,
  `courseDt` datetime DEFAULT NULL,
  `courseDuration` float DEFAULT NULL,
  `courseLocationEn` text DEFAULT NULL,
  `courseLocationAr` text DEFAULT NULL,
  `courseLocationUrl` text DEFAULT NULL,
  `courseImage` text DEFAULT NULL,
  `courseSeats` float DEFAULT NULL,
  `coursePrice` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `offlinecourses`
--

INSERT INTO `offlinecourses` (`course_id`, `category_id`, `courseNameEn`, `courseNameAr`, `courseDescEn`, `courseDescAr`, `courseLearnEn`, `courseLearnAr`, `courseDt`, `courseDuration`, `courseLocationEn`, `courseLocationAr`, `courseLocationUrl`, `courseImage`, `courseSeats`, `coursePrice`, `createdBy`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`) VALUES
(1, 0, 'Test', 'test', 'test', 'test', 'test', 'test', '2025-08-08 13:54:41', 90, 'test', NULL, 'test', 'logo-1.webp', 10, 10, NULL, NULL, 0, NULL, NULL);

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

--
-- Table structure for table `onlinecourselessons`
--

CREATE TABLE `onlinecourselessons` (
  `lesson_id` int(11) NOT NULL,
  `course_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `lessonNameEn` text DEFAULT NULL,
  `lessonNameAr` text DEFAULT NULL,
  `lessonImage` text DEFAULT NULL,
  `lessonBunnyVideoId` text DEFAULT NULL,
  `lessonDuration` float DEFAULT NULL,
  `lessonOrder` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL,
  `isUploaded` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `onlinecourselessons`
--

INSERT INTO `onlinecourselessons` (`lesson_id`, `course_id`, `section_id`, `lessonNameEn`, `lessonNameAr`, `lessonImage`, `lessonBunnyVideoId`, `lessonDuration`, `lessonOrder`, `createdBy`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`, `isUploaded`) VALUES
(1, 1, 1, 'frefgaergr', 'eargear', '687133db2489d399.png', 'c60329cd-baa9-4cff-90b5-3abe71b5da47', 392, 1, 1, '2025-08-16 13:15:42', 0, NULL, NULL, NULL),
(2, 1, 2, 'brththrs', 'aethe', 'bfae068989e8e940.png', 'd5812bc3-cd82-4c6e-9f08-fa2b74b71a27', 392, 1, 1, '2025-08-16 13:22:18', 0, NULL, NULL, NULL),
(3, 1, 2, 'frefgaergr', 'eargear', '687133db2489d399.png', 'c60329cd-baa9-4cff-90b5-3abe71b5da47', 392, 2, 1, '2025-08-16 13:15:42', 0, NULL, NULL, NULL);

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

--
-- Table structure for table `onlinecourseprogress`
--

CREATE TABLE `onlinecourseprogress` (
  `progress_id` int(11) NOT NULL,
  `course_id` int(11) DEFAULT NULL,
  `lesson_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `bunnyVideoId` text DEFAULT NULL,
  `positionSecond` float DEFAULT NULL,
  `durationSecond` float DEFAULT NULL,
  `isCompleted` int(11) DEFAULT NULL,
  `updatedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `onlinecourseprogress`
--

INSERT INTO `onlinecourseprogress` (`progress_id`, `course_id`, `lesson_id`, `user_id`, `bunnyVideoId`, `positionSecond`, `durationSecond`, `isCompleted`, `updatedOn`) VALUES
(1, 1, 0, 1, 'c60329cd-baa9-4cff-90b5-3abe71b5da47', 60, 392, 0, '2025-08-18 23:32:54'),
(2, 1, 0, 1, 'd5812bc3-cd82-4c6e-9f08-fa2b74b71a27', 212, 392, 0, '2025-08-18 23:46:38');

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

--
-- Table structure for table `onlinecourses`
--

CREATE TABLE `onlinecourses` (
  `course_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `courseNameEn` text DEFAULT NULL,
  `courseNameAr` text DEFAULT NULL,
  `courseDescEn` text DEFAULT NULL,
  `courseDescAr` text DEFAULT NULL,
  `courseLearnEn` text DEFAULT NULL,
  `courseLearnAr` text DEFAULT NULL,
  `courseImage` text DEFAULT NULL,
  `courseOrgPrice` float DEFAULT NULL,
  `courseDisPrice` float DEFAULT NULL,
  `isHidden` int(11) DEFAULT NULL,
  `hiddenBy` int(11) DEFAULT NULL,
  `hiddenOn` datetime DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `onlinecourses`
--

INSERT INTO `onlinecourses` (`course_id`, `category_id`, `courseNameEn`, `courseNameAr`, `courseDescEn`, `courseDescAr`, `courseLearnEn`, `courseLearnAr`, `courseImage`, `courseOrgPrice`, `courseDisPrice`, `isHidden`, `hiddenBy`, `hiddenOn`, `createdBy`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`) VALUES
(1, NULL, 'The Ultimate Blender 3D Geometry Nodes Course', 'The Ultimate Blender 3D Geometry Nodes Course', 'Fully compatible with Blender 4.5 & above!\r\n\r\nHave you ever wanted to learn geometry nodes but didn't know where to start or were overwhelmed by them? Well look no further! This course will go from A-Z of geometry nodes. We will cover ALL geometry nodes and ALL their options and along the way create some awesome scenes!\r\n\r\nThis course is structed so that every video introduces a new geometry node. With every new node we learn, we will build on the previous knowledge of what we learned. Each section of the course will introduce between 10 to 15 new nodes and by the end of each section you will have created an awesome geometry nodes scene!\r\n\r\nThis course is project based so we will be making an awesome project with each section!\r\n\r\nWe will learn how to make things such as:\r\n- Buildings & Villages\r\n- Trees\r\n- Clouds\r\n- Grass\r\n- A road With Cars on It\r\n- Vines\r\n- Lighting\r\n- Dragons\r\n- A Candyland Scene\r\n- A Sci-fi Corridor\r\n- Rivers With Boats on Them!\r\n- A Donut\r\n- A Strategy Game\r\n- How to Create Hair Using the Hair Nodes\r\nAND MUCH, MUCH more!\r\n\r\n3 Different Ways to Do the Course!\r\n\r\nBecause of how the course is structed, you can do the course 3 different ways:\r\n- Again we are going to learn every single geometry node, their options and how to use them. Because of this there 3 ways you can do this course.\r\n- For options 2 and 3 I recommend knowing a little bit about geometry nodes first. If you are not familiar with geometry nodes at all it is best to go with option 1 or do the first couple sections of the course so that you understand the basics of geometry nodes before going for option 2 or 3.\r\n- Option 1 is to do the course from start to finish. If you are new to geometry nodes or would like to learn every geometry node, this is the best option. Every video we will learn a new geometry node and each video will build on the last one\r\n- The second option is to skip to any project or section and do just that section. Each section we start a brand new project so if you want to do a particular project or learn some particular nodes you can just skip to that section.\r\n- The third option is if you want to learn or go over a particular node you can go to just that node and learn about that node or refresh your memory on that node!\r\n\r\nWhat will you have gained by the end of this course?\r\n\r\nBy the end of this course you will have learned every single geometry node, their options and HOW to use them. Not only that but you will have created some awesome projects along the way. The best part? you will now be equipped with the knowledge and understanding to create your own geometry node based scenes! This course will empower you so that you no longer are in confusion about geometry nodes but you have mastery over them like a pro!\r\n\r\nSo get the course & let's learn about geometry nodes!\r\n\r\nWho this course is for:\r\n- This course is for anyone who wants to be able to learn ALL the geometry nodes and what they do\r\n- Anyone who wants to learn how to use geometry nodes practically to create scenes or objects procedurally\r\n- This course is not for someone who already knows EVERYTHING about geometry nodes', 'Fully compatible with Blender 4.5 & above!\r\n\r\nHave you ever wanted to learn geometry nodes but didn't know where to start or were overwhelmed by them? Well look no further! This course will go from A-Z of geometry nodes. We will cover ALL geometry nodes and ALL their options and along the way create some awesome scenes!\r\n\r\nThis course is structed so that every video introduces a new geometry node. With every new node we learn, we will build on the previous knowledge of what we learned. Each section of the course will introduce between 10 to 15 new nodes and by the end of each section you will have created an awesome geometry nodes scene!\r\n\r\nThis course is project based so we will be making an awesome project with each section!\r\n\r\nWe will learn how to make things such as:\r\n- Buildings & Villages\r\n- Trees\r\n- Clouds\r\n- Grass\r\n- A road With Cars on It\r\n- Vines\r\n- Lighting\r\n- Dragons\r\n- A Candyland Scene\r\n- A Sci-fi Corridor\r\n- Rivers With Boats on Them!\r\n- A Donut\r\n- A Strategy Game\r\n- How to Create Hair Using the Hair Nodes\r\nAND MUCH, MUCH more!\r\n\r\n3 Different Ways to Do the Course!\r\n\r\nBecause of how the course is structed, you can do the course 3 different ways:\r\n- Again we are going to learn every single geometry node, their options and how to use them. Because of this there 3 ways you can do this course.\r\n- For options 2 and 3 I recommend knowing a little bit about geometry nodes first. If you are not familiar with geometry nodes at all it is best to go with option 1 or do the first couple sections of the course so that you understand the basics of geometry nodes before going for option 2 or 3.\r\n- Option 1 is to do the course from start to finish. If you are new to geometry nodes or would like to learn every geometry node, this is the best option. Every video we will learn a new geometry node and each video will build on the last one\r\n- The second option is to skip to any project or section and do just that section. Each section we start a brand new project so if you want to do a particular project or learn some particular nodes you can just skip to that section.\r\n- The third option is if you want to learn or go over a particular node you can go to just that node and learn about that node or refresh your memory on that node!\r\n\r\nWhat will you have gained by the end of this course?\r\n\r\nBy the end of this course you will have learned every single geometry node, their options and HOW to use them. Not only that but you will have created some awesome projects along the way. The best part? you will now be equipped with the knowledge and understanding to create your own geometry node based scenes! This course will empower you so that you no longer are in confusion about geometry nodes but you have mastery over them like a pro!\r\n\r\nSo get the course & let's learn about geometry nodes!\r\n\r\nWho this course is for:\r\n- This course is for anyone who wants to be able to learn ALL the geometry nodes and what they do\r\n- Anyone who wants to learn how to use geometry nodes practically to create scenes or objects procedurally\r\n- This course is not for someone who already knows EVERYTHING about geometry nodes', '- Learn every single geometry node and all their settings\r\n- How to practically use geometry nodes to create what you want\r\n- Learn how to create scenes using geometry nodes\r\n- Create procedural assets so that you can quickly fill your scene', '- Learn every single geometry node and all their settings\r\n- How to practically use geometry nodes to create what you want\r\n- Learn how to create scenes using geometry nodes\r\n- Create procedural assets so that you can quickly fill your scene', 'OfflineCourse-689f9c613f4cb.webp', 100, 0, 0, NULL, NULL, 1, '2025-08-15 22:45:21', 0, NULL, NULL);

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

--
-- Table structure for table `onlinecoursesections`
--

CREATE TABLE `onlinecoursesections` (
  `section_id` int(11) NOT NULL,
  `course_id` int(11) DEFAULT NULL,
  `sectionNameEn` text DEFAULT NULL,
  `sectionNameAr` text DEFAULT NULL,
  `sectionOrder` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `onlinecoursesections`
--

INSERT INTO `onlinecoursesections` (`section_id`, `course_id`, `sectionNameEn`, `sectionNameAr`, `sectionOrder`, `createdBy`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`) VALUES
(1, 1, 's1', 's1', 1, 1, '2025-08-15 22:51:03', 0, NULL, NULL),
(2, 1, 's2', 's2', 2, 1, '2025-08-16 13:21:40', 0, NULL, NULL);

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

--
-- Table structure for table `phoneotps`
--

CREATE TABLE `phoneotps` (
  `otp_id` int(11) NOT NULL,
  `otpExt` varchar(4) DEFAULT NULL,
  `otpPhone` varchar(15) DEFAULT NULL,
  `otpNumber` varchar(6) DEFAULT NULL,
  `otpDt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `rate_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `rateSource` int(11) DEFAULT NULL,
  `rateSourceId` int(11) DEFAULT NULL,
  `rateScore` float DEFAULT NULL,
  `rateComment` text DEFAULT NULL,
  `rateStatus` int(11) DEFAULT NULL,
  `rateDt` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `servicefields`
--

CREATE TABLE `servicefields` (
  `field_id` int(11) NOT NULL,
  `service_id` int(11) DEFAULT NULL,
  `fieldNameEn` text DEFAULT NULL,
  `fieldNameAr` text DEFAULT NULL,
  `fieldType` int(11) DEFAULT NULL,
  `fieldRequired` int(11) DEFAULT NULL COMMENT '0 = No\r\n1 = Yes',
  `fieldOrder` float DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `servicefieldtypes`
--

CREATE TABLE `servicefieldtypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `servicefieldtypes`
--

INSERT INTO `servicefieldtypes` (`type_id`, `typeName`) VALUES
(1, 'Single Line Text'),
(2, 'Multi Line Text'),
(3, 'Number'),
(4, 'Money'),
(5, 'Date');

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

--
-- Table structure for table `sources`
--

CREATE TABLE `sources` (
  `source_id` int(11) NOT NULL,
  `sourceName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sources`
--

INSERT INTO `sources` (`source_id`, `sourceName`) VALUES
(1, 'Service Booking'),
(2, 'Offline Course'),
(3, 'Online Course'),
(4, 'General Note');

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

--
-- Table structure for table `sponsors`
--

CREATE TABLE `sponsors` (
  `sponsor_id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `sponsorType` int(11) DEFAULT NULL,
  `sponsorTitle` text DEFAULT NULL,
  `sponsorDesc` text DEFAULT NULL,
  `sponsorStatus` int(11) DEFAULT NULL,
  `sponsorDate` date DEFAULT NULL,
  `sponsorTotalAmount` float DEFAULT NULL,
  `sponsorPaidAmount` float DEFAULT NULL,
  `sponsorPaidDate` date DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sponsorstatuses`
--

CREATE TABLE `sponsorstatuses` (
  `status_id` int(11) NOT NULL,
  `statusName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sponsortypes`
--

CREATE TABLE `sponsortypes` (
  `type_id` int(11) NOT NULL,
  `typeName` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `userdocs`
--

CREATE TABLE `userdocs` (
  `doc_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `docSource` int(11) DEFAULT NULL,
  `docSourceId` int(11) DEFAULT NULL,
  `docTitle` text DEFAULT NULL,
  `docFileName` text DEFAULT NULL,
  `docDt` datetime DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `usernotes`
--

CREATE TABLE `usernotes` (
  `note_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `noteSource` int(11) DEFAULT NULL,
  `noteSourceId` int(11) DEFAULT NULL,
  `noteBody` text DEFAULT NULL,
  `noteDt` datetime DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `userName` text DEFAULT NULL,
  `userExt` varchar(4) DEFAULT NULL,
  `userPhone` varchar(15) DEFAULT NULL,
  `userEmail` text DEFAULT NULL,
  `userBirthDate` date DEFAULT NULL,
  `userCountry` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `isDeleted` int(11) DEFAULT NULL,
  `deletedBy` int(11) DEFAULT NULL,
  `deletedOn` datetime DEFAULT NULL,
  `userReferralCode` text DEFAULT NULL,
  `userPoints` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `userName`, `userExt`, `userPhone`, `userEmail`, `userBirthDate`, `userCountry`, `createdOn`, `isDeleted`, `deletedBy`, `deletedOn`, `userReferralCode`, `userPoints`) VALUES
(1, 'Jamal Ahmad', '965', '99512259', NULL, NULL, NULL, '2025-08-15 21:15:20', 0, NULL, NULL, 'CF1BCE4B', 0);

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

--
-- Table structure for table `views`
--

CREATE TABLE `views` (
  `view_id` int(11) NOT NULL,
  `viewSource` int(11) DEFAULT NULL,
  `viewSourceId` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `viewDt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `adminpageaccess`
--
ALTER TABLE `adminpageaccess`
  ADD PRIMARY KEY (`access_id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `assettypes`
--
ALTER TABLE `assettypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`banner_id`);

--
-- Indexes for table `bannerstatuses`
--
ALTER TABLE `bannerstatuses`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `bannertypes`
--
ALTER TABLE `bannertypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`booking_id`);

--
-- Indexes for table `bookingservicefields`
--
ALTER TABLE `bookingservicefields`
  ADD PRIMARY KEY (`bfield_id`);

--
-- Indexes for table `bookingservices`
--
ALTER TABLE `bookingservices`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `bookingserviceslots`
--
ALTER TABLE `bookingserviceslots`
  ADD PRIMARY KEY (`slot_id`);

--
-- Indexes for table `bookingservicetypes`
--
ALTER TABLE `bookingservicetypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `bookingstatuses`
--
ALTER TABLE `bookingstatuses`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `checkouttypes`
--
ALTER TABLE `checkouttypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `courseorderstatuses`
--
ALTER TABLE `courseorderstatuses`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `coursesorders`
--
ALTER TABLE `coursesorders`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `discountcodes`
--
ALTER TABLE `discountcodes`
  ADD PRIMARY KEY (`code_id`);

--
-- Indexes for table `fcmtokens`
--
ALTER TABLE `fcmtokens`
  ADD PRIMARY KEY (`fcm_id`);

--
-- Indexes for table `freeassets`
--
ALTER TABLE `freeassets`
  ADD PRIMARY KEY (`asset_id`);

--
-- Indexes for table `freeassetsdownloads`
--
ALTER TABLE `freeassetsdownloads`
  ADD PRIMARY KEY (`download_id`);

--
-- Indexes for table `infoabout`
--
ALTER TABLE `infoabout`
  ADD PRIMARY KEY (`section_id`);

--
-- Indexes for table `infoprivacy`
--
ALTER TABLE `infoprivacy`
  ADD PRIMARY KEY (`section_id`);

--
-- Indexes for table `infoterms`
--
ALTER TABLE `infoterms`
  ADD PRIMARY KEY (`section_id`);

--
-- Indexes for table `offlinecourses`
--
ALTER TABLE `offlinecourses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `onlinecourselessons`
--
ALTER TABLE `onlinecourselessons`
  ADD PRIMARY KEY (`lesson_id`);

--
-- Indexes for table `onlinecourseprogress`
--
ALTER TABLE `onlinecourseprogress`
  ADD PRIMARY KEY (`progress_id`);

--
-- Indexes for table `onlinecourses`
--
ALTER TABLE `onlinecourses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `onlinecoursesections`
--
ALTER TABLE `onlinecoursesections`
  ADD PRIMARY KEY (`section_id`);

--
-- Indexes for table `phoneotps`
--
ALTER TABLE `phoneotps`
  ADD PRIMARY KEY (`otp_id`);

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`rate_id`);

--
-- Indexes for table `servicefields`
--
ALTER TABLE `servicefields`
  ADD PRIMARY KEY (`field_id`);

--
-- Indexes for table `servicefieldtypes`
--
ALTER TABLE `servicefieldtypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `sources`
--
ALTER TABLE `sources`
  ADD PRIMARY KEY (`source_id`);

--
-- Indexes for table `sponsors`
--
ALTER TABLE `sponsors`
  ADD PRIMARY KEY (`sponsor_id`);

--
-- Indexes for table `sponsorstatuses`
--
ALTER TABLE `sponsorstatuses`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `sponsortypes`
--
ALTER TABLE `sponsortypes`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `userdocs`
--
ALTER TABLE `userdocs`
  ADD PRIMARY KEY (`doc_id`);

--
-- Indexes for table `usernotes`
--
ALTER TABLE `usernotes`
  ADD PRIMARY KEY (`note_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `views`
--
ALTER TABLE `views`
  ADD PRIMARY KEY (`view_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adminpageaccess`
--
ALTER TABLE `adminpageaccess`
  MODIFY `access_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `assettypes`
--
ALTER TABLE `assettypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bannerstatuses`
--
ALTER TABLE `bannerstatuses`
  MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bannertypes`
--
ALTER TABLE `bannertypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookingservicefields`
--
ALTER TABLE `bookingservicefields`
  MODIFY `bfield_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookingservices`
--
ALTER TABLE `bookingservices`
  MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookingserviceslots`
--
ALTER TABLE `bookingserviceslots`
  MODIFY `slot_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookingservicetypes`
--
ALTER TABLE `bookingservicetypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bookingstatuses`
--
ALTER TABLE `bookingstatuses`
  MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `checkouttypes`
--
ALTER TABLE `checkouttypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;

--
-- AUTO_INCREMENT for table `courseorderstatuses`
--
ALTER TABLE `courseorderstatuses`
  MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `coursesorders`
--
ALTER TABLE `coursesorders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `discountcodes`
--
ALTER TABLE `discountcodes`
  MODIFY `code_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fcmtokens`
--
ALTER TABLE `fcmtokens`
  MODIFY `fcm_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeassets`
--
ALTER TABLE `freeassets`
  MODIFY `asset_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `freeassetsdownloads`
--
ALTER TABLE `freeassetsdownloads`
  MODIFY `download_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `infoabout`
--
ALTER TABLE `infoabout`
  MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `infoprivacy`
--
ALTER TABLE `infoprivacy`
  MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `infoterms`
--
ALTER TABLE `infoterms`
  MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `offlinecourses`
--
ALTER TABLE `offlinecourses`
  MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `onlinecourselessons`
--
ALTER TABLE `onlinecourselessons`
  MODIFY `lesson_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `onlinecourseprogress`
--
ALTER TABLE `onlinecourseprogress`
  MODIFY `progress_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `onlinecourses`
--
ALTER TABLE `onlinecourses`
  MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `onlinecoursesections`
--
ALTER TABLE `onlinecoursesections`
  MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `phoneotps`
--
ALTER TABLE `phoneotps`
  MODIFY `otp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `rate_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `servicefields`
--
ALTER TABLE `servicefields`
  MODIFY `field_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `servicefieldtypes`
--
ALTER TABLE `servicefieldtypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `sources`
--
ALTER TABLE `sources`
  MODIFY `source_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `sponsors`
--
ALTER TABLE `sponsors`
  MODIFY `sponsor_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsorstatuses`
--
ALTER TABLE `sponsorstatuses`
  MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsortypes`
--
ALTER TABLE `sponsortypes`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userdocs`
--
ALTER TABLE `userdocs`
  MODIFY `doc_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usernotes`
--
ALTER TABLE `usernotes`
  MODIFY `note_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `views`
--
ALTER TABLE `views`
  MODIFY `view_id` int(11) NOT NULL AUTO_INCREMENT;
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 */;