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

START TRANSACTION;



--
-- Database: `u900687499_demo2`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `email` varchar(55) NOT NULL,
  `image` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `email`, `image`, `password`) VALUES
(1, 'admin@admin.com', 'ditrpindia@gmail.com', '02.png', 'admin@admin.com');

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

--
-- Table structure for table `advertisement`
--

CREATE TABLE `advertisement` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `link` longtext NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `advertisement`
--

INSERT INTO `advertisement` (`id`, `title`, `description`, `link`, `added_on`) VALUES
(1, 'Get 50% OFF on All Courses', '1703768552_interior-design-in-bhubaneswar-odisha.webp', 'https://youtu.be/KbjpvUUvBUE?si=GP84WrkCh10w3aGR', '2023-12-26 12:07:14');

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

--
-- Table structure for table `award`
--

CREATE TABLE `award` (
  `id` int(11) NOT NULL,
  `awardname` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `award`
--

INSERT INTO `award` (`id`, `awardname`, `dt`) VALUES
(5, 'DIPLOMA', '2024-01-05 07:02:42'),
(6, 'ADVANCE DIPLOMA', '2024-01-06 04:29:18'),
(7, 'CERTIFICATE', '2024-01-06 04:29:41');

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

--
-- Table structure for table `callback`
--

CREATE TABLE `callback` (
  `id` int(11) NOT NULL,
  `fullname` varchar(55) NOT NULL,
  `phone` varchar(55) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `hgqlafication` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `mname` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `postcode` varchar(255) NOT NULL,
  `permanentaddress` varchar(255) NOT NULL,
  `aadharno` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `abbr` varchar(255) NOT NULL,
  `altphone` varchar(255) NOT NULL,
  `caste` varchar(255) NOT NULL,
  `occupation` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `callback`
--

INSERT INTO `callback` (`id`, `fullname`, `phone`, `gender`, `email`, `hgqlafication`, `fname`, `mname`, `state`, `city`, `postcode`, `permanentaddress`, `aadharno`, `dob`, `course`, `duration`, `abbr`, `altphone`, `caste`, `occupation`, `dt`) VALUES
(1, 'amzad sathe', '+919975554765', 'Male', 'ditrpindia@gmail.com', 'aewtryjghtgrew', 'SHAAN DOLEY', 'A', 'virar', 'virar', '401303', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', '123456u7i8o9p0', '2023-11-26', 'Learning Hub: TallyPrime Videos & Tally Shortcuts', '1 Months', 'Mr', '+919975554765', 'qwerty', 'qwerty', '2023-12-28 10:06:17'),
(2, 'amzad sathe', '+919975554765', 'Male', 'ditrpindia@gmail.com', '', 'A', 'A', 'virar', 'virar', '401303', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', 'ccxcx', '2024-01-02', 'BUSINESS MANAGEMENT', '1 Months', 'Mr', '+919975554765', '', 'gvvgnv', '2024-01-03 10:39:27'),
(3, 'ABHISHEK ', '08891606659', 'Male', 'WSF826@gmail.com', '', 'SATISH', 'DEMO', 'wdefwve', 'wdefwve', '401305', 'e2df', '', '2000-01-05', 'tally', '1 year', 'Mr', '', '', '', '2024-01-05 07:26:09');

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

--
-- Table structure for table `color`
--

CREATE TABLE `color` (
  `id` int(11) NOT NULL,
  `hcolor` varchar(255) NOT NULL,
  `fcolor` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `color`
--

INSERT INTO `color` (`id`, `hcolor`, `fcolor`, `added_on`) VALUES
(2, '#f5f5f5', '#e0eded', '2024-01-06 15:40:27');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `name` varchar(55) NOT NULL,
  `phone` varchar(55) NOT NULL,
  `email` varchar(55) NOT NULL,
  `message` varchar(855) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `name`, `phone`, `email`, `message`, `dt`) VALUES
(1, 'DITRP OPC PVT LTD', '+919999999999', 'ditrpindia121@gmail.com', 'c cbv  ', '2024-01-03 10:40:00');

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

--
-- Table structure for table `coursedetails`
--

CREATE TABLE `coursedetails` (
  `id` int(11) NOT NULL,
  `course` varchar(555) NOT NULL,
  `subdescription` mediumtext NOT NULL,
  `description` longtext NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coursedetails`
--

INSERT INTO `coursedetails` (`id`, `course`, `subdescription`, `description`, `dt`) VALUES
(1, 'BUSINESS MANAGEMENT', '<div class=\"vc_row wpb_row vc_row-fluid\" style=\"position: relative; margin-left: -15px; margin-right: -15px; color: rgb(106, 114, 133); font-family: \" open=\"\" sans\";=\"\" font-size:=\"\" 13px;\"=\"\"><div class=\"wpb_column vc_column_container vc_col-sm-12\" style=\"width: 1240px; position: initial; min-height: 1px; padding-left: 0px; padding-right: 0px; float: left;\"><div class=\"vc_column-inner\" style=\"padding-left: 15px; padding-right: 15px; width: 1240px;\"><div class=\"wpb_wrapper\"><div class=\"vc_row wpb_row vc_inner vc_row-fluid\" style=\"position: relative; margin-left: -15px; margin-right: -15px;\"><div class=\"wpb_column vc_column_container vc_col-sm-12\" style=\"width: 1210px; position: initial; min-height: 1px; padding-left: 0px; padding-right: 0px; float: left;\"><div class=\"vc_column-inner\" style=\"padding-left: 15px; padding-right: 15px; width: 1210px;\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element  vc_custom_1666345434422\" style=\"margin-bottom: 0px; margin-top: 20px !important;\"><h3 style=\"margin-bottom: 12px;\"><span style=\"font-weight: bolder;\">Course Curriculum of our All-inclusive Tally Course</span></h3><div class=\"RqBzHd\" google=\"\" sans\",=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 16px;=\"\" font-weight:=\"\" 400;\"=\"\" style=\"padding: 0px 20px; color: rgb(32, 33, 36);\"><ul class=\"i8Z77e\" style=\"padding: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;\"><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Basics of Tally.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Creation / Setting up of Company in Tally.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Creating Accounting Masters in Tally.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Setting up Accounts Heads.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Group &amp; Ledger Creation.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Voucher Entry.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Debit &amp; Credit Note.</li><li class=\"TrT0Xe\" style=\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\">Creating Inventory Masters in Tally.</li></ul></div></div></div></div></div></div></div></div></div></div>', '<h1 style=\"border: 0px solid rgb(217, 217, 227); --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-shadow: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-shadow-colored: 0 0 transparent; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; font-size: 2.25em; font-weight: 600; margin-right: 0px; margin-bottom: 0.888889em; margin-left: 0px; line-height: 1.11111; color: var(--tw-prose-headings); font-family: Söhne, ui-sans-serif, system-ui, -apple-system, \" segoe=\"\" ui\",=\"\" roboto,=\"\" ubuntu,=\"\" cantarell,=\"\" \"noto=\"\" sans\",=\"\" sans-serif,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";=\"\" white-space-collapse:=\"\" preserve;\"=\"\"></h1><h1 style=\"box-sizing: border-box; margin: 0px 0px 20px; font-weight: 500; line-height: 30px; color: rgb(57, 73, 112); font-size: 24px; letter-spacing: -0.03em;\">Who Should Pursue Our Explicit Tally Course?</h1><h1 style=\"margin-bottom: 12px; font-family: \" google=\"\" sans\",=\"\" arial,=\"\" sans-serif;=\"\" color:=\"\" rgb(32,=\"\" 33,=\"\" 36);=\"\" font-size:=\"\" 16px;=\"\" font-weight:=\"\" 400;\"=\"\"><div style=\"color: rgb(106, 114, 133); font-size: 16px;\"></div><p style=\"color: rgb(106, 114, 133); font-size: 16px;\">Customized as per the needs and requirements of freshmen and professionals in the finance and accounting sphere, the rich Tally Advanced course at IIM Skills is a must-have for all. Acquisition of Tally skills will help both professionals and newbies to make their way up in their careers, irrespective of their current positioning.</p><p style=\"margin-bottom: 0px; color: rgb(106, 114, 133); font-size: 16px;\"></p><p style=\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 1.6;\"><span style=\"margin-bottom: 0px;\">Leveraging this well-structured course, determination and grit will help you set your talents ablaze in this field. Generally speaking, this course is an excellent fit for finance, accounts, business, and business management aspirants.</span></p><p style=\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 1.6;\"><span style=\"margin-bottom: 0px;\">The Tally is an important skill you should master if your degree is in accounting or finance. The majority of businesses already use Tally ERP, thus becoming familiar with it will greatly increase your understanding of accounting, inventory management, and taxation.</span></p></h1><h4 style=\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; line-height: 1.6;\"><span style=\"font-weight: 700; margin-bottom: 0px;\">The Master Tally Course is a good call on your career front if you are:</span></h4><h1 style=\"margin-bottom: 12px; font-family: \" google=\"\" sans\",=\"\" arial,=\"\" sans-serif;=\"\" color:=\"\" rgb(32,=\"\" 33,=\"\" 36);=\"\" font-size:=\"\" 16px;=\"\" font-weight:=\"\" 400;\"=\"\"><ul style=\"padding-left: 0px; margin-bottom: 0px; color: rgb(106, 114, 133); font-size: 16px; list-style-type: none;\"><ol></ol></ul><p style=\"color: rgb(106, 114, 133); font-size: 16px;\"></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Fresh Graduates</span><span style=\"margin-bottom: 0px;\">: Commerce graduates can find this Tally course highly rewarding to make their way in the accounting field. Besides, graduates from any stream can leverage this course to set the stage for a prosperous career in the domain of accounts and finance. The base-stage competence in important professional accounting software like Tally will provide a remarkable head start to your career.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">CA professional/pursuing:</span><span style=\"margin-bottom: 0px;\"> Those pursuing a Chartered Accountant (CA) degree and existing CA professionals can savor the benefits of this Tally advanced course. Not only will it add to your skills and tool knowledge, but make you incredibly competent in the eyes of prospective employers.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">CS Professional/pursuing:</span><span style=\"margin-bottom: 0px;\"> Company secretary degree holders or CS learners can equally profit from this entry-level accounting software to record and track data of company businesses. Besides, it multiplies your chances of better job prospects in the industry.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Tax Experts:</span><span style=\"margin-bottom: 0px;\"> As simple as it sounds, Tally is an accounting software that is highly useful for tax experts to record accurate transitions and conversions. Those working or aiming to work in the tax industry must enroll in a Tally advanced course to stride ahead in their careers.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">GST Practitioners:</span><span style=\"margin-bottom: 0px;\"> Since GST is all about filing returns, bills, and payments, having a strong hold over Tally software will add a much-needed boost to your career. With Tally skills under your kitty, you can process loads of data and client information in an accessible and comprehensible manner.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Finance Professionals</span><span style=\"margin-bottom: 0px;\">: Working professionals belonging to the finance domain can consider the Tally course to enlarge their skills, thereby strengthening their work areas. Finance experts targeting career upliftment or career switch options can also add Tally to their skill kit.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Entrepreneurs/Solopreneurs</span><span style=\"margin-bottom: 0px;\">: Those running for entrepreneurship roles have to process tons of statistics and figures. With that being the case, Tally software knowledge can come in handy to document and anecdote figures and numbers. For solopreneurs, this easy-to-use software is a true benefactor to archive useful data.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Start-up Owners:</span><span style=\"margin-bottom: 0px;\"> As mentioned, Tally is a beginner-level accounting tool. Start-up owners can use this software to the best of their abilities to manage all work-related statistics and data.</span></p><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\"><span style=\"font-weight: 700;\">Business Management Students:</span><span style=\"margin-bottom: 0px;\"> Those running for business management roles have an advantage with Tally software knowledge. Tally not only adds up as a skill badge but also counts toward the process of business-related activities.</span></p></h1>', '2023-12-27 05:11:11');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `courses` varchar(255) NOT NULL,
  `courseduration` varchar(255) NOT NULL,
  `cprice` varchar(255) NOT NULL,
  `coursecode` varchar(255) NOT NULL,
  `awards` varchar(255) NOT NULL,
  `cmrp` varchar(255) NOT NULL,
  `minimumfees` varchar(255) NOT NULL,
  `coursesubject` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `subdescription` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `courses`, `courseduration`, `cprice`, `coursecode`, `awards`, `cmrp`, `minimumfees`, `coursesubject`, `description`, `subdescription`, `image`, `dt`) VALUES
(1, 'BUSINESS MANAGEMENT', '1 ', '1999', '4321321', 'Certificate', '2499', '499', 'Tally Prime,Web Development,D.T.P,FUNDAMENTEL,MS-OFFICE', '<h1 style=\\\"border: 0px solid rgb(217, 217, 227); --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-shadow: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-shadow-colored: 0 0 transparent; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; font-size: 2.25em; font-weight: 600; margin-right: 0px; margin-bottom: 0.888889em; margin-left: 0px; line-height: 1.11111; color: var(--tw-prose-headings); font-family: Söhne, ui-sans-serif, system-ui, -apple-system, \\\" segoe=\\\"\\\" ui\\\",=\\\"\\\" roboto,=\\\"\\\" ubuntu,=\\\"\\\" cantarell,=\\\"\\\" \\\"noto=\\\"\\\" sans\\\",=\\\"\\\" sans-serif,=\\\"\\\" \\\"helvetica=\\\"\\\" neue\\\",=\\\"\\\" arial,=\\\"\\\" \\\"apple=\\\"\\\" color=\\\"\\\" emoji\\\",=\\\"\\\" \\\"segoe=\\\"\\\" ui=\\\"\\\" symbol\\\",=\\\"\\\" emoji\\\";=\\\"\\\" white-space-collapse:=\\\"\\\" preserve;\\\"=\\\"\\\"></h1><h1 style=\\\"box-sizing: border-box; margin: 0px 0px 20px; font-weight: 500; line-height: 30px; color: rgb(57, 73, 112); font-size: 24px; letter-spacing: -0.03em;\\\">Who Should Pursue Our Explicit Tally Course?</h1><h1 style=\\\"margin-bottom: 12px; font-family: \\\" google=\\\"\\\" sans\\\",=\\\"\\\" arial,=\\\"\\\" sans-serif;=\\\"\\\" color:=\\\"\\\" rgb(32,=\\\"\\\" 33,=\\\"\\\" 36);=\\\"\\\" font-size:=\\\"\\\" 16px;=\\\"\\\" font-weight:=\\\"\\\" 400;\\\"=\\\"\\\"><div style=\\\"color: rgb(106, 114, 133); font-size: 16px;\\\"></div><p style=\\\"color: rgb(106, 114, 133); font-size: 16px;\\\">Customized as per the needs and requirements of freshmen and professionals in the finance and accounting sphere, the rich Tally Advanced course at IIM Skills is a must-have for all. Acquisition of Tally skills will help both professionals and newbies to make their way up in their careers, irrespective of their current positioning.</p><p style=\\\"margin-bottom: 0px; color: rgb(106, 114, 133); font-size: 16px;\\\"></p><p style=\\\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 1.6;\\\"><span style=\\\"margin-bottom: 0px;\\\">Leveraging this well-structured course, determination and grit will help you set your talents ablaze in this field. Generally speaking, this course is an excellent fit for finance, accounts, business, and business management aspirants.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 1.6;\\\"><span style=\\\"margin-bottom: 0px;\\\">The Tally is an important skill you should master if your degree is in accounting or finance. The majority of businesses already use Tally ERP, thus becoming familiar with it will greatly increase your understanding of accounting, inventory management, and taxation.</span></p></h1><h4 style=\\\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; line-height: 1.6;\\\"><span style=\\\"font-weight: 700; margin-bottom: 0px;\\\">The Master Tally Course is a good call on your career front if you are:</span></h4><h1 style=\\\"margin-bottom: 12px; font-family: \\\" google=\\\"\\\" sans\\\",=\\\"\\\" arial,=\\\"\\\" sans-serif;=\\\"\\\" color:=\\\"\\\" rgb(32,=\\\"\\\" 33,=\\\"\\\" 36);=\\\"\\\" font-size:=\\\"\\\" 16px;=\\\"\\\" font-weight:=\\\"\\\" 400;\\\"=\\\"\\\"><ul style=\\\"padding-left: 0px; margin-bottom: 0px; color: rgb(106, 114, 133); font-size: 16px; list-style-type: none;\\\"><ol></ol></ul><p style=\\\"color: rgb(106, 114, 133); font-size: 16px;\\\"></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Fresh Graduates</span><span style=\\\"margin-bottom: 0px;\\\">: Commerce graduates can find this Tally course highly rewarding to make their way in the accounting field. Besides, graduates from any stream can leverage this course to set the stage for a prosperous career in the domain of accounts and finance. The base-stage competence in important professional accounting software like Tally will provide a remarkable head start to your career.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">CA professional/pursuing:</span><span style=\\\"margin-bottom: 0px;\\\"> Those pursuing a Chartered Accountant (CA) degree and existing CA professionals can savor the benefits of this Tally advanced course. Not only will it add to your skills and tool knowledge, but make you incredibly competent in the eyes of prospective employers.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">CS Professional/pursuing:</span><span style=\\\"margin-bottom: 0px;\\\"> Company secretary degree holders or CS learners can equally profit from this entry-level accounting software to record and track data of company businesses. Besides, it multiplies your chances of better job prospects in the industry.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Tax Experts:</span><span style=\\\"margin-bottom: 0px;\\\"> As simple as it sounds, Tally is an accounting software that is highly useful for tax experts to record accurate transitions and conversions. Those working or aiming to work in the tax industry must enroll in a Tally advanced course to stride ahead in their careers.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">GST Practitioners:</span><span style=\\\"margin-bottom: 0px;\\\"> Since GST is all about filing returns, bills, and payments, having a strong hold over Tally software will add a much-needed boost to your career. With Tally skills under your kitty, you can process loads of data and client information in an accessible and comprehensible manner.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Finance Professionals</span><span style=\\\"margin-bottom: 0px;\\\">: Working professionals belonging to the finance domain can consider the Tally course to enlarge their skills, thereby strengthening their work areas. Finance experts targeting career upliftment or career switch options can also add Tally to their skill kit.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Entrepreneurs/Solopreneurs</span><span style=\\\"margin-bottom: 0px;\\\">: Those running for entrepreneurship roles have to process tons of statistics and figures. With that being the case, Tally software knowledge can come in handy to document and anecdote figures and numbers. For solopreneurs, this easy-to-use software is a true benefactor to archive useful data.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Start-up Owners:</span><span style=\\\"margin-bottom: 0px;\\\"> As mentioned, Tally is a beginner-level accounting tool. Start-up owners can use this software to the best of their abilities to manage all work-related statistics and data.</span></p><p style=\\\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(106, 114, 133); font-size: 16px; line-height: 30px; padding-left: 35px; position: relative;\\\"><span style=\\\"font-weight: 700;\\\">Business Management Students:</span><span style=\\\"margin-bottom: 0px;\\\"> Those running for business management roles have an advantage with Tally software knowledge. Tally not only adds up as a skill badge but also counts toward the process of business-related activities.</span></p></h1>', '<div class=\\\"vc_row wpb_row vc_row-fluid\\\" style=\\\"position: relative; margin-left: -15px; margin-right: -15px; color: rgb(106, 114, 133); font-family: \\\" open=\\\"\\\" sans\\\";=\\\"\\\" font-size:=\\\"\\\" 13px;\\\"=\\\"\\\"><div class=\\\"wpb_column vc_column_container vc_col-sm-12\\\" style=\\\"width: 1240px; position: initial; min-height: 1px; padding-left: 0px; padding-right: 0px; float: left;\\\"><div class=\\\"vc_column-inner\\\" style=\\\"padding-left: 15px; padding-right: 15px; width: 1240px;\\\"><div class=\\\"wpb_wrapper\\\"><div class=\\\"vc_row wpb_row vc_inner vc_row-fluid\\\" style=\\\"position: relative; margin-left: -15px; margin-right: -15px;\\\"><div class=\\\"wpb_column vc_column_container vc_col-sm-12\\\" style=\\\"width: 1210px; position: initial; min-height: 1px; padding-left: 0px; padding-right: 0px; float: left;\\\"><div class=\\\"vc_column-inner\\\" style=\\\"padding-left: 15px; padding-right: 15px; width: 1210px;\\\"><div class=\\\"wpb_wrapper\\\"><div class=\\\"wpb_text_column wpb_content_element  vc_custom_1666345434422\\\" style=\\\"margin-bottom: 0px; margin-top: 20px !important;\\\"><h3 style=\\\"margin-bottom: 12px;\\\"><span style=\\\"font-weight: bolder;\\\">Course Curriculum of our All-inclusive Tally Course</span></h3><div class=\\\"RqBzHd\\\" google=\\\"\\\" sans\\\",=\\\"\\\" arial,=\\\"\\\" sans-serif;=\\\"\\\" font-size:=\\\"\\\" 16px;=\\\"\\\" font-weight:=\\\"\\\" 400;\\\"=\\\"\\\" style=\\\"padding: 0px 20px; color: rgb(32, 33, 36);\\\"><ul class=\\\"i8Z77e\\\" style=\\\"padding: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;\\\"><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Basics of Tally.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Creation / Setting up of Company in Tally.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Creating Accounting Masters in Tally.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Setting up Accounts Heads.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Group & Ledger Creation.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Voucher Entry.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Debit & Credit Note.</li><li class=\\\"TrT0Xe\\\" style=\\\"margin: 0px 0px 4px; padding: 0px; list-style-type: disc;\\\">Creating Inventory Masters in Tally.</li></ul></div></div></div></div></div></div></div></div></div></div>', 'course_thumbnail_efanew_142.jpg', '2023-12-26 16:05:03'),
(2, 'tally', '1 ', '5000', 'c101200', 'Certificate', '1000', '1000', 'Tally Prime, Web Development, D.T.P', '<p>fgcf</p>', '<p>ghfch</p>', '1.png', '2024-01-05 06:21:09'),
(3, 'dtp desk of padsdzsf', '6 ', '8000', 'c41414', 'Certificate', '10000', '100', 'fggcfg fxgfgdg dgcfgfg df gcfgf cfgcfg  cffgcfgcfgfgfcgfgdfg', '<p>vgnhv</p>', '<p>gvnvg</p>', '6b7ed698713c09ad9e6afc7dcb996a09 (1).jpg', '2024-01-05 06:26:59'),
(4, 'TALLY ERP', '6 ', '12000', 'C6CBVCVBCF', 'DIPLOMA', '15000', '100', 'fggcfg fxgfgdg dgcfgfg df gcfgf cfgcfg  cffgcfgcfgfgfcgfgdfg', '<p>CXVX</p>', '<p>XGFDFGCFG DXFDFGDFG DFGFG</p>', '6b7ed698713c09ad9e6afc7dcb996a09 (1).jpg', '2024-01-05 07:04:30'),
(5, 'HTML', '1 ', '12000', 'C01010', 'ADVANCE DIPLOMA', '10000', '500', 'Web Development', '<p>HTML, HTML, HTML<br></p>', '<p>HTMLHTMLHTMLHTMLHTMLHTML<br></p>', '1704522577_fffffffffffffff.jpg', '2024-01-06 04:32:17');

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

--
-- Table structure for table `design`
--

CREATE TABLE `design` (
  `id` int(11) NOT NULL,
  `mimage` varchar(255) NOT NULL,
  `cimage` varchar(255) NOT NULL,
  `aimage` varchar(255) NOT NULL,
  `idimage` varchar(100) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `design`
--

INSERT INTO `design` (`id`, `mimage`, `cimage`, `aimage`, `idimage`, `dt`) VALUES
(4, 'mark.jpg', 'NEXSTEP.jpg', 'NEXSTEP (3).jpg', 'ID.jpg', '2024-01-06 04:53:44');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `image`, `dt`) VALUES
(5, 'interior-design-banner-retro-living-room-with-a-sofa-and-modern-furniture-vector.jpg', '2023-12-28 12:58:28');

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

--
-- Table structure for table `home`
--

CREATE TABLE `home` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `dt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home`
--

INSERT INTO `home` (`id`, `image`, `title`, `description`, `dt`) VALUES
(3, 'welcome-banner-design-template-2613f911adef178b58c395f76b2890c5_screen.jpg', 'ABOUT US : WELCOME TO CENTER', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eius mod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehe derit in voluptate velit esse cillum.\r\n\r\nOn the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot fore see the pain and trouble that are bound to ensue; and equal who fail in their duty.', '0000-00-00 00:00:00');

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

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `favicon` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `sitename`, `favicon`, `image`, `added_on`) VALUES
(14, 'ditrp', '1703756915_01.png', '1703756915_favicon_01.png', '2023-12-28 09:48:35');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `menu` varchar(255) NOT NULL,
  `submenu` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `menu`, `submenu`, `added_on`) VALUES
(1, 'About Us', 'Mission & Vision', '2023-12-26 12:15:18'),
(2, 'About Us', 'Director\'s Message', '2023-12-26 12:15:37'),
(3, 'About Us', 'Why Choose Us?', '2023-12-26 12:15:57'),
(4, 'About Us', 'Infrastructure', '2023-12-26 12:16:25'),
(6, 'About Us', 'Our Services', '2024-01-03 10:36:29'),
(7, 'About Us', 'All', '2024-01-04 06:41:23');

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

--
-- Table structure for table `pagedetails`
--

CREATE TABLE `pagedetails` (
  `id` int(255) NOT NULL,
  `pagemenu` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pagedetails`
--

INSERT INTO `pagedetails` (`id`, `pagemenu`, `title`, `description`, `added_on`) VALUES
(1, 'Mission & Vision', 'Mission and Vision', '<h1 style=\"color: #252525;\"><span id=\"allowed-text\" style=\"font-family: \" arial=\"\" black\";\"=\"\">Mission</span></h1><p style=\"color: #252525;\"><img src=\"data:image/png;base64,[encoded data, 43856 characters]\" data-filename=\"7198180.png\" style=\"width: 25%;\"><span id=\"allowed-text\"><br></span></p><h6 style=\"color: #252525;\"><span id=\"allowed-text\">Our roadmap starts with our mission, which is enduring. It declares our purpose as a company and services as the standard against which we weight our action and decisions. To strengthen, sustain, and professionalise business knowledge through creative research and teaching, highlighting the significance of learning, and by collaborating with organisations, institutions, and universities both within and well beyond national boundaries.</span></h6><h1 style=\"color: #252525;\"><span id=\"allowed-text\" style=\"font-family: \" arial=\"\" black\";\"=\"\">Vision</span></h1><h1 style=\"color: #252525;\"><img src=\"data:image/png;base64,[encoded data, 43332 characters]\" data-filename=\"5482006.png\" style=\"width: 25%;\"><span id=\"allowed-text\" style=\"font-family: \" arial=\"\" black\";\"=\"\"><br></span></h1><p>\r\n\r\n\r\n</p><h6 style=\"color: #252525;\"><span id=\"allowed-text\">Our vision serves as the framework for our roadmap and guides every aspect of our business by describing what we need to accomplish in order to continue achieving sustained quality to be an academic centre of excellence in the area of computer education and a well-networked institution committed to delivering globally competitive computer education, training, and research to individuals, corporate bodies,</span> government organisations, and society.<img src=\"data:image/jpeg;base64,[encoded data, 156416 characters]\" style=\"width: 742px;\" data-filename=\"Payments_109387573_3.jpg\"></h6>', '2023-12-26 12:24:01');

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

--
-- Table structure for table `result`
--

CREATE TABLE `result` (
  `id` int(11) NOT NULL,
  `studentname` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `result`
--

INSERT INTO `result` (`id`, `studentname`, `dt`) VALUES
(1, 'CCZ-2023-46391', '2023-12-27 05:18:27'),
(2, 'CCZ-2023-5159', '2023-12-28 13:06:02'),
(3, 'CCZ-2024-57238', '2024-01-03 06:15:56'),
(4, 'CCZ-2024-62049', '2024-01-05 07:13:43');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `image` varchar(100) NOT NULL,
  `alt` varchar(55) NOT NULL,
  `added_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `image`, `alt`, `added_on`) VALUES
(6, '1703749041_fffffffffffffff.jpg', 'Hi', '2023-12-28 07:37:21'),
(7, '1703749052_77777777777777.jpg', 'Ff', '2023-12-28 07:37:32'),
(8, '1703749062_444444.jpg', 'Fff', '2023-12-28 07:37:42'),
(9, '1703749072_77777777777777.jpg', 'Fff', '2023-12-28 07:37:52');

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

--
-- Table structure for table `socialinks`
--

CREATE TABLE `socialinks` (
  `id` int(11) NOT NULL,
  `flink` longtext NOT NULL,
  `ilink` longtext NOT NULL,
  `ylink` longtext NOT NULL,
  `linkedin` longtext NOT NULL,
  `telegram` longtext NOT NULL,
  `twitter` longtext NOT NULL,
  `phone` varchar(255) NOT NULL,
  `wno` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `iframe` longtext NOT NULL,
  `added_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `socialinks`
--

INSERT INTO `socialinks` (`id`, `flink`, `ilink`, `ylink`, `linkedin`, `telegram`, `twitter`, `phone`, `wno`, `email`, `address`, `city`, `iframe`, `added_on`) VALUES
(1, 'www.facebook.com/radheyasoftech', 'www.instagram.com/radheyasoftech', 'www.youtube.com/radheyasoftech', 'www.linkedin.com/radheyasoftech', 'www.telegram.me/radheyasoftech', 'www.instagram.com/radheyasoftech', '+91 9975554765', '+91 7620052713', 'ditrpindia@gmail.com', 'Room No 109, New Rushikesh Apartment, Near Cricket Ground, Virat Nagar, Virar West, Palghar, Mumbai, 401303, Maharashtra, India', 'Mumbai', '                                    <iframe src=\\\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d7356521.869363923!2d81.83306728348651!3d25.801868590787713!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x398db731cf76f82b%3A0x126d6fe2c45055bc!2sDITRP%20COMPUTER%20EDUCATION!5e0!3m2!1sen!2sin!4v1704528252922!5m2!1sen!2sin\\\" width=\\\"100%\\\" height=\\\"450\\\" style=\\\"border:0;\\\" allowfullscreen=\\\"\\\" loading=\\\"lazy\\\" referrerpolicy=\\\"no-referrer-when-downgrade\\\"></iframe>                                    ', '2023-12-27 06:45:59');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `regno` varchar(100) NOT NULL,
  `name` varchar(55) NOT NULL,
  `mobile` varchar(55) NOT NULL,
  `altmobile` varchar(55) NOT NULL,
  `gender` varchar(55) NOT NULL,
  `address` varchar(255) NOT NULL,
  `aadhar` varchar(55) NOT NULL,
  `email` varchar(55) NOT NULL,
  `image` varchar(100) NOT NULL,
  `highqualification` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `awards` varchar(255) NOT NULL,
  `minfees` varchar(255) NOT NULL,
  `feesreceived` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `father` varchar(55) NOT NULL,
  `careof` varchar(55) NOT NULL,
  `mother` varchar(55) NOT NULL,
  `dob` varchar(55) NOT NULL,
  `abbr` varchar(55) NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `postcode` varchar(255) NOT NULL,
  `caste` varchar(255) NOT NULL,
  `occupation` varchar(255) NOT NULL,
  `coursesubject` varchar(255) NOT NULL,
  `tmarks` varchar(255) NOT NULL,
  `marksob` varchar(255) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `status` smallint(10) NOT NULL,
  `wpm` varchar(255) NOT NULL,
  `dog` datetime NOT NULL DEFAULT current_timestamp(),
  `dt` timestamp NOT NULL DEFAULT current_timestamp(),
  `ddate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `regno`, `name`, `mobile`, `altmobile`, `gender`, `address`, `aadhar`, `email`, `image`, `highqualification`, `course`, `duration`, `awards`, `minfees`, `feesreceived`, `balance`, `father`, `careof`, `mother`, `dob`, `abbr`, `state`, `city`, `postcode`, `caste`, `occupation`, `coursesubject`, `tmarks`, `marksob`, `signature`, `status`, `wpm`, `dog`, `dt`, `ddate`) VALUES
(1, 'CCZ-2023-46391', 'amzad sathe', '9975554765', '7620052713', 'Male', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', '9898989898888', 'ditrpindia@gmail.com', 'istockphoto-913062404-612x612.jpg', 'ssc', 'BUSINESS MANAGEMENT', '1 ', 'Certificate', '1999', '100', '4900.00', 'jusab', 'Mr', 'sathe', '2023-12-14', 'Mr', 'Maharashtra', 'virar', '401303', 'muslim', 'good', 'Tally Prime,Web Development,D.T.P', '50,50,50', '40,40,42', '206-2067024_signechar-png-transparent-png.png', 0, '', '2023-12-27 04:54:36', '2023-12-27 04:54:36', '2024-01-06 06:58:23'),
(2, 'CCZ-2023-5159', 'Pooja', '9975554765', '1234567890', 'Male', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', '789456123789', 'ditrpindia@gmail.com', 'student.jpg', 'qwerty', 'BUSINESS MANAGEMENT', '1 ', '', '499', '300', '199.00', 'Shankar Prasad', 'Mr', 'Priya Devi', '2023-11-26', 'Mrs', 'Maharashtra', 'virar', '401303', 'qwerty', 'qwerty', 'Tally Prime,Web Development,D.T.P', '48,48,47', '49,43,38', 'sign_29544042.jpg', 0, '', '2023-12-28 10:02:42', '2023-12-28 10:02:42', '2024-01-06 06:58:23'),
(3, 'CCZ-2024-57238', 'test', '5999999999', '7527117856', 'Male', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', '123456789012', 'ditrpindia8527410@gmail.com', 'student.jpg', '12th', 'BUSINESS MANAGEMENT', '1 ', 'Certificate', '1999', '1000', '999.00', 'aa', 'Mr', 'aa', '2023-12-31', 'Mr', 'Maharashtra', 'virar', '401303', 'qwerty', '123456789', 'Tally Prime,Web Development,D.T.P,FUNDAMENTEL,MS-OFFICE', '48,47,43,42,47', '41,45,44,47,41', 'sign_29544042.jpg', 0, '', '2024-01-03 06:15:06', '2024-01-03 06:15:06', '2024-01-06 06:58:23'),
(4, 'CCZ-2024-62049', 'AMIT', '+919975554765', '7596869234', 'Male', 'DGDGDFGDFG', 'DFGDFGDFGFG', 'DFGDFGCF', '6b7ed698713c09ad9e6afc7dcb996a09 (1).jpg', 'GFCGFG', 'TALLY ERP', '6 ', 'DIPLOMA', '12000', '6000', '6000.00', 'XDFGDXG', 'Mr', 'DFGDFG', '2024-01-30', 'Mr', 'DXDGFG', 'CFGCFH', 'FGCFGFG', 'CGHFH', 'GHVGHGH', 'fggcfg fxgfgdg dgcfgfg df gcfgf cfgcfg  cffgcfgcfgfgfcgfgdfg', '41', '47', '206-2067024_signechar-png-transparent-png.png', 0, '', '2024-01-05 07:05:56', '2024-01-05 07:05:56', '2024-01-06 06:58:23'),
(5, 'CCZ-2024-16251', 'AMZAD SATHE', '+919975554765', '+919999999999', 'Male', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', '5234334534534', 'ditrpindia@gmail.com', 'istockphoto-913062404-612x612.jpg', 'SSC', 'HTML', '1 ', 'ADVANCE DIPLOMA', '12000', '1000', '11000.00', 'JUSAB', 'Mr', 'JANAB', '2024-01-04', 'Mr', 'Maharashtra', 'virar', '401303', 'ebc', 'stundent', 'Web Development', '40', '42', '206-2067024_signechar-png-transparent-png.png', 0, '', '2024-01-06 04:33:39', '2024-01-06 04:33:39', '2024-01-06 06:58:23'),
(6, 'CCZ-2024-87444', 'rajesh', '999999999', '+919975554765', 'Male', 'shop no 3 new rushikesh apt virat nagar virar w, shop no3 virat nagar virar', 'sszdszd', 'ditrpindia121@gmail.com', '19.jpg', '12th pass', 'BUSINESS MANAGEMENT', '1 ', 'Certificate', '1999', '1000', '999.00', 'rahaant', 'Mr', 'pooja', '1983-05-14', 'Mr', 'Maharashtra', 'virar', '401303', 'ebc', 'stundent', 'Tally Prime,Web Development,D.T.P,FUNDAMENTEL,MS-OFFICE', '40,42,44,40,40', '38,42,44,44,36', 'fake-hand-drawn-autographs-set-handwritten-signature-scribble-for-business-certificate-or-letter-isolated-illustration-vector.jpg', 0, '', '2024-01-06 05:12:46', '2024-01-06 05:12:46', '2024-01-06 06:58:23');

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

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `subjectname` varchar(255) NOT NULL,
  `marks` int(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `subjectname`, `marks`, `dt`) VALUES
(1, 'Tally Prime', 100, '2023-12-27 04:52:07'),
(2, 'Web Development', 100, '2023-12-27 04:52:07'),
(3, 'D.T.P', 100, '2023-12-27 04:56:58'),
(4, 'FUNDAMENTEL', 100, '2023-12-27 04:57:12'),
(5, 'MS-OFFICE', 100, '2023-12-27 04:57:24'),
(6, 'WEB-DINGNING', 100, '2023-12-27 04:57:37'),
(7, 'TALLY PRIME', 100, '2023-12-27 04:57:49'),
(8, 'WINDOWNS', 100, '2023-12-27 04:58:01'),
(9, 'C, C++', 100, '2023-12-27 04:58:15'),
(10, 'VB SQL', 100, '2023-12-27 04:58:28'),
(11, 'INTRODUCTION TO COMPUTER HARDWARE NETWORKING FUNDAMENTALS COMPUTER NETWORKING TECHNOLOGIES CISCO CERTIFIED NETWORK ASSOCIATE ADVANCED NETWORKING TECHNOLOGIES', 100, '2024-01-05 06:29:30'),
(12, 'CERTIFIED NETWORK ASSOCIATE ADVANCED NETWORKING TECHNOLOGIES', 100, '2024-01-05 06:29:30');

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

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`id`, `name`, `designation`, `image`, `dt`) VALUES
(1, 'Vikas Singh', 'Tally Instructor', 'Shazim uddin pp image with stroke.jpg', '2023-12-26 15:51:07'),
(2, 'roshan', 'testing', 'iso 4.jpg', '2023-12-28 09:56:19');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `name` text NOT NULL,
  `designation` varchar(55) NOT NULL,
  `image` varchar(100) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `content`, `name`, `designation`, `image`, `dt`) VALUES
(1, 'Top Computer Training Institutes in Patna', 'Vikas Singh', 'Student', '1762519.png', '2023-12-26 12:14:27'),
(3, 'qwerty', 'roshan', 'testing', 'WhatsApp Image 2023-09-04 at 4.41.14 PM.jpeg', '2023-12-28 09:43:26');

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

--
-- Table structure for table `toppers`
--

CREATE TABLE `toppers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `dt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `toppers`
--

INSERT INTO `toppers` (`id`, `name`, `designation`, `image`, `dt`) VALUES
(1, 'Sumit Kumar', 'Tally Student', 'user.png', '2023-12-27 04:48:22'),
(2, 'roshan', 'testing', '1690100878389.jpg', '2023-12-28 09:58:11'),
(3, 'ajaya ', 'students', 'istockphoto-913062404-612x612.jpg', '2024-01-06 04:26:08');

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int(11) NOT NULL,
  `link` longtext NOT NULL,
  `dt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`id`, `link`, `dt`) VALUES
(2, '<iframe Width=\"560\" Height=\"315\" Src=\"https://www.youtube.com/embed/hzivqHfxsoc?si=_nZ5_Or1jZHRq1Si\" Title=\"YouTube Video Player\" Frameborder=\"0\" Allow=\"accelerometer; Autoplay; Clipboard-write; Encrypted-media; Gyroscope; Picture-in-picture; Web-share\" Allowfullscreen></iframe>', '2024-01-03 11:47:48'),
(3, '<iframe Width=\"560\" Height=\"315\" Src=\"https://www.youtube.com/embed/iAFeZ0Cs4h8?si=gTumHYS9y9wTXNcn\" Title=\"YouTube Video Player\" Frameborder=\"0\" Allow=\"accelerometer; Autoplay; Clipboard-write; Encrypted-media; Gyroscope; Picture-in-picture; Web-share\" Allowfullscreen></iframe>', '2024-01-05 06:57:31');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `award`
--
ALTER TABLE `award`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `logo`
--
ALTER TABLE `logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `pagedetails`
--
ALTER TABLE `pagedetails`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

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

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

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

