-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 30, 2024 at 04:14 AM
-- Server version: 8.2.0
-- PHP Version: 8.2.13

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: `skills`
--

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

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

DROP TABLE IF EXISTS `courses`;
CREATE TABLE IF NOT EXISTS `courses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `institute_id` int NOT NULL,
  `university` varchar(255) NOT NULL,
  `courseName` varchar(255) NOT NULL,
  `level` varchar(50) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `startDate` date NOT NULL,
  `studyArea` varchar(255) DEFAULT NULL,
  `specification` varchar(255) DEFAULT NULL,
  `careerOpportunities` text,
  `industry` varchar(255) DEFAULT NULL,
  `cologo` varchar(255) DEFAULT NULL,
  `codescription` text,
  `contactDetails` text,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` tinyint(1) DEFAULT '0',
  `approved` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `institute_id` (`institute_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `courses` (`id`, `institute_id`, `university`, `courseName`, `level`, `duration`, `startDate`, `studyArea`, `specification`, `careerOpportunities`, `industry`, `cologo`, `codescription`, `contactDetails`, `createdAt`, `updatedAt`, `deleted`, `approved`) VALUES
(5, 0, 'AAT Sri Lanka', 'BUSINESS MANAGEMENT', 'Postgraduate Diploma', '3 years', '2024-08-12', 'Business', 'dfsf', 'kfldamkan', 'skdk,s', 'cologo_1721899822931.jpg', 'dsddksnksk', '{\"instituteName\":\"AAT Sri Lanka\",\"instituteAddress\":\"wadadwdq\",\"institutePhone\":\"2222222\",\"instituteEmail\":\"aatsl@gmail.com\",\"instituteLocation\":\"colombo\"}', '2024-07-29 05:47:09', '2024-07-30 03:55:29', 0, 1),
(2, 0, 'Harvard University', 'COMPUTER SCIENCE 101', 'Degree', '4 years', '2024-09-07', 'Computer Science', 'Introduction to programming, data structures, algorithms', 'Software Developer, Systems Analyst, Data Scientist', 'Technology', 'cologo_1721910421557.jpg', 'This course provides a comprehensive introduction to the field of computer science. Students will learn the fundamentals of programming, data structures, and algorithms, with a focus on practical applications.', '{}', '2024-07-25 12:33:46', '2024-07-30 03:52:15', 0, 0),
(3, 0, 'OUSL', 'MASTER OF SCIENCE IN ENVIRONMENTAL SCIENCE', 'Master\'s', '2 years', '2024-10-06', 'Environment Science', 'mkhmh', 'mkhth', 'ortkr', 'cologo_1721970258338.jpeg', '', '{\"instituteName\":\"OUSL\",\"instituteAddress\":\"dksjcs\",\"institutePhone\":\"2222222\",\"instituteEmail\":\"ousl@gmail.com\",\"instituteLocation\":\"colombo\"}', '2024-07-26 04:49:53', '2024-07-30 03:51:54', 0, 1),
(4, 0, 'AAT Sri Lanka', 'COMPUTER SCIENCE ', 'Degree', '3 years', '2024-08-02', 'Computer Science', 'gdf', 'dgdgee', 'ter', 'cologo_1721980276265.jpg', 'fdnmdmnsnkjsdnc sdjcsdnkcjnsdkcs dmnc sndcjkscksdc s skjdnckjsdncksdm snm ksc msd csncjksdncs ckjnvksjncs csdja,nv v;ajacn', '{\"instituteName\":\"AAT Sri Lanka\",\"instituteAddress\":\"wadadwdq\",\"institutePhone\":\"2222222\",\"instituteEmail\":\"aatsl@gmail.com\",\"instituteLocation\":\"colombo\"}', '2024-07-26 07:51:16', '2024-07-29 08:14:58', 0, 0),
(6, 0, 'abc', 'aaa', 'Advanced Diploma', '1 year', '2024-08-01', 'aaa', 'dscscdss', 'dcsssb', 'fdkvkm', 'cologo_1722239126733.png', 'smkanvjkfaviuava', '{\"instituteName\":\"abc\",\"instituteAddress\":\"ada\",\"institutePhone\":\"000445\",\"instituteEmail\":\"abc@gmail.com\",\"instituteLocation\":\"sk\"}', '2024-07-29 07:45:26', '2024-07-29 07:45:26', 0, 0),
(7, 0, 'ccc', 'cc2', 'Certificate', '1 year', '2024-07-31', 'cc', 'ccccc', 'cccc', 'cc', NULL, 'ccccccccc', '{\"instituteName\":\"ccc\",\"instituteAddress\":\"cccccccccc\",\"institutePhone\":\"1111\",\"instituteEmail\":\"ccc@gmail.com\",\"instituteLocation\":\"cc\"}', '2024-07-29 08:23:28', '2024-07-29 08:33:52', 1, 0),
(8, 0, 'ccc', 'c', 'Certificate', '1 year', '2024-07-31', 'cc', 'ccccc', 'cccc', 'cc', NULL, 'ccccccccc', '{\"instituteName\":\"ccc\",\"instituteAddress\":\"cccccccccc\",\"institutePhone\":\"1111\",\"instituteEmail\":\"c@gmail.com\",\"instituteLocation\":\"cc\"}', '2024-07-29 08:25:01', '2024-07-29 08:33:47', 1, 0),
(9, 0, 'ccc', 'xx', 'Certificate', '1 year', '2024-07-31', 'cc', 'ccccc', 'cccc', 'cc', NULL, 'ccccccccc', '{\"instituteName\":\"ccc\",\"instituteAddress\":\"cccccccccc\",\"institutePhone\":\"1111\",\"instituteEmail\":\"xx@gmail.com\",\"instituteLocation\":\"cc\"}', '2024-07-29 08:27:34', '2024-07-29 08:38:07', 1, 1);

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

--
-- Table structure for table `institute`
--

DROP TABLE IF EXISTS `institute`;
CREATE TABLE IF NOT EXISTS `institute` (
  `id` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `in_name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `website` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `tel` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `address` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `img` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `desc_` text COLLATE utf8mb4_general_ci NOT NULL,
  `approve` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `token` text COLLATE utf8mb4_general_ci NOT NULL,
  `deleted` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `date` text COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `institute`
--

INSERT INTO `institute` (`id`, `in_name`, `website`, `email`, `tel`, `address`, `img`, `desc_`, `approve`, `password`, `token`, `deleted`, `date`) VALUES
('00001', 'AAT SRI LANKA', ' https://aatsl.lk/index.php/en/', 'marketing1@aatsl.lk', '777-559669', 'No. 540, Ven. Muruththettuwe Ananda Nahimi Mw, Narahenpita, Colombo', 'img_1721990710636.jpg', 'AAT Sri Lanka Was Established In Dec. 1987 On The Model Of The AAT (UK) As A Non-Profit Organization. AAT (UK) Was Initially Formed In 1980, By A Merger Of Two Bodies That Existed Earlier In The U.K., Namely; The Association For Accounting Technicians Of Finance And Accounting (ATFA) And The Institute Of Accounting Staff (IAS).\r\n\r\nSubsequently, AAT Ireland (Called The Institute Of Accounting Technicians Ireland) Was Formed In April 1983.\r\n\r\nAATs Have Since Been Established In Pakistan (Now Called Institute Of Public Service Accountants-Pakistan), In Malaysia (Now Called Association Of Accounting Administrators-Malaysia), In Singapore, And In New Zealand (Called College Of Accounting Technicians-New Zealand).\r\n\r\nThe Master Plan For Accountancy Education In Sri Lanka, Prepared By The ADB Inception Mission In 1986, Emphasized The Need For The Technician Level Accounting Personnel. The Mission Report Forecast The Island’s Requirement Of Accounting Technicians At 12,000 By The Year 2020.\r\n\r\nAccounting Technicians Are Recognized As Middle Level Professional Accountants, Immediately After Obtaining The Associate Membership (MAAT). However, By Gaining Experience In The Field Of Accountancy, They Can Reach The Senior Technician Level (SAT) And Fellow Technician Level (FMAAT), At Which Point They Are Considered Well-Groomed Professional Accountants. One Can Add More Value And Recognition To This Qualification By Gaining Qualifications In Other Professional Accountancy Bodies.', 'approve', '1234hjh56', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2023650.2207512448!2d79.12088309195528!3d7.848739376759062!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae25a2afb969687%3A0x576dfb5da5aa6f7f!2sAssociation%20of%20Accounting%20Technicians%20of%20Sri%20Lanka!5e0!3m2!1sen!2slk!4v1571564276658!5m2!1sen!2slk', 'false', '12/05/2024'),
('00002', 'ESOFT', ' https://aatsl.lk/index.php/en/', 'marketing1@ESOFTl.lk', '777-559669', 'No. 540, Ven. Muruththettuwe Ananda Nahimi Mw, Narahenpita, Colombo', 'img_1721991033054.jpg', 'AAT Sri Lanka Was Established In Dec. 1987 On The Model Of The AAT (UK) As A Non-Profit Organization. AAT (UK) Was Initially Formed In 1980, By A Merger Of Two Bodies That Existed Earlier In The U.K., Namely; The Association For Accounting Technicians Of Finance And Accounting (ATFA) And The Institute Of Accounting Staff (IAS).\r\n\r\nSubsequently, AAT Ireland (Called The Institute Of Accounting Technicians Ireland) Was Formed In April 1983.\r\n\r\nAATs Have Since Been Established In Pakistan (Now Called Institute Of Public Service Accountants-Pakistan), In Malaysia (Now Called Association Of Accounting Administrators-Malaysia), In Singapore, And In New Zealand (Called College Of Accounting Technicians-New Zealand).\r\n\r\nThe Master Plan For Accountancy Education In Sri Lanka, Prepared By The ADB Inception Mission In 1986, Emphasized The Need For The Technician Level Accounting Personnel. The Mission Report Forecast The Island’s Requirement Of Accounting Technicians At 12,000 By The Year 2020.\r\n\r\nAccounting Technicians Are Recognized As Middle Level Professional Accountants, Immediately After Obtaining The Associate Membership (MAAT). However, By Gaining Experience In The Field Of Accountancy, They Can Reach The Senior Technician Level (SAT) And Fellow Technician Level (FMAAT), At Which Point They Are Considered Well-Groomed Professional Accountants. One Can Add More Value And Recognition To This Qualification By Gaining Qualifications In Other Professional Accountancy Bodies.', 'pending', '1234hjh56', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d1013995.8542937454!2d78.63931137812504!3d6.900014899999988!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae2596309dfdd3f%3A0x45a4b0e7834ac0', 'false', '02/05/2020'),
('00003', 'CSCT Campus', ' https://aatsl.lk/index.php/en/', 'marketing1@CSCTCampusl.lk', '777-559669', 'No. 540, Ven. Muruththettuwe Ananda Nahimi Mw, Narahenpita, Colombo', 'img_1721991359999.png', 'AAT Sri Lanka Was Established In Dec. 1987 On The Model Of The AAT (UK) As A Non-Profit Organization. AAT (UK) Was Initially Formed In 1980, By A Merger Of Two Bodies That Existed Earlier In The U.K., Namely; The Association For Accounting Technicians Of Finance And Accounting (ATFA) And The Institute Of Accounting Staff (IAS).\r\n\r\nSubsequently, AAT Ireland (Called The Institute Of Accounting Technicians Ireland) Was Formed In April 1983.\r\n\r\nAATs Have Since Been Established In Pakistan (Now Called Institute Of Public Service Accountants-Pakistan), In Malaysia (Now Called Association Of Accounting Administrators-Malaysia), In Singapore, And In New Zealand (Called College Of Accounting Technicians-New Zealand).\r\n\r\nThe Master Plan For Accountancy Education In Sri Lanka, Prepared By The ADB Inception Mission In 1986, Emphasized The Need For The Technician Level Accounting Personnel. The Mission Report Forecast The Island’s Requirement Of Accounting Technicians At 12,000 By The Year 2020.\r\n\r\nAccounting Technicians Are Recognized As Middle Level Professional Accountants, Immediately After Obtaining The Associate Membership (MAAT). However, By Gaining Experience In The Field Of Accountancy, They Can Reach The Senior Technician Level (SAT) And Fellow Technician Level (FMAAT), At Which Point They Are Considered Well-Groomed Professional Accountants. One Can Add More Value And Recognition To This Qualification By Gaining Qualifications In Other Professional Accountancy Bodies.', 'pending', '1234hjh56', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d1013995.8542937454!2d78.63931137812504!3d6.900014899999988!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae2596309dfdd3f%3A0x45a4b0e7834ac0', 'true', '13/05/2024'),
('00004', 'AIC', 'https://aic.lk/index.php/en/', 'acilk@sl.com', '+94 77 442 2502', 'No. 154, Havelock Road, Thimbirigasyaya, Colombo 5, 00500. +94 77 442 2502', 'img_1722233781494.jpg', 'AIC Campus is a Member of the IMC - AIC Education Consortium, a leading transnational education service conglomerate established with a vision to provide total higher education solutions under one roof. AIC Campus offers, Global University Foundation Programs, Global University Transfer Programs, Degree Completion Programs in Civil and Mechanical Engineering, International Business and Marketing and Direct Placements to leading Universities.', 'pending', '1234hjh56', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2023650.2207512448!2d79.12088309195528!3d7.848739376759062!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae25a2afb969687%3A0x576dfb5da5aa6f7f!2sAssociation%20of%20Accounting%20Technicians%20of%20Sri%20Lanka!5e0!3m2!1sen!2slk!4v1571564276658!5m2!1sen!2slk', 'true', '22/10/2021'),
('00005', 'IIT', 'https://aatsl.lk/index.php/en/', 'iitsl@email.com', '77524423', 'AIC Campus Colombo: No. 154, Havelock Road, Thimbirigasyaya, Colombo 5, 00500.', 'img_1722239907085.jpeg', 'AIC Campus is a Member of the IMC - AIC Education Consortium, a leading transnational education service conglomerate established with a vision to provide total higher education solutions under one roof. AIC Campus offers, Global University Foundation Programs, Global University Transfer Programs, Degree Completion Programs in Civil and Mechanical Engineering, International Business and Marketing and Direct Placements to leading Universities.\r\nAIC Campus is a Member of the IMC - AIC Education Consortium, a leading transnational education service conglomerate established with a vision to provide total higher education solutions under one roof. AIC Campus offers, ', 'approve', '1234hjh56', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2023650.2207512448!2d79.12088309195528!3d7.848739376759062!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae25a2afb969687%3A0x576dfb5da5aa6f7f!2sAssociation%20of%20Accounting%20Technicians%20of%20Sri%20Lanka!5e0!3m2!1sen!2slk!4v1571564276658!5m2!1sen!2slk', 'false', '2022-11-02');

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

--
-- Table structure for table `student_registration`
--

DROP TABLE IF EXISTS `student_registration`;
CREATE TABLE IF NOT EXISTS `student_registration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `province` varchar(10) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `course` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `message` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `student_registration`
--

INSERT INTO `student_registration` (`id`, `name`, `address`, `district`, `province`, `phone`, `mobile`, `email`, `school`, `course`, `category`, `message`) VALUES
(1, 'Chiranji ', '75/3, Gettuwana road ', 'Kurunegala', 'North West', '0372222683', '0719143846', 'chivinodya12@gmail.com', 'RIS', 'Master\'s', 'Technology', ''),
(2, 'Lucifer', '123 Main St', 'Colombo', 'Western', '123456789', '987654321', 'lucifer@example.com', 'XYZ School', 'Phd', 'Science', 'Looking forward to the course!'),
(3, 'Chiranji ', '75/3, Gettuwana road ', 'Kurunegala', 'North West', '0372222683', '0719143846', 'chiranji@gmail.com', 'RIS', 'Master\'s', 'Technology', ''),
(4, 'Chi', 'ccc123', 'Kurunegala', 'North West', '1111111111', '2222222222', 'chi@gmail.com', 'abcd_school', 'Postgraduate Diploma', 'Science', ''),
(5, 'Chi', 'ccc123', 'Kurunegala', 'North West', '1111111111', '2222222222', 'ccc@gmail.com', 'abcd_school', 'Postgraduate Diploma', 'Science', 'hi'),
(6, 'jj', 'jjjj', 'Colombo', 'Western', '1111111111', '2222222222', 'jj@gmail.com', 'jj', 'HND', 'Arts', 'jjjjjjjjjj'),
(7, 'chloe', 'ferrfs', 'Colombo', 'Western', '000000', '552212', 'chloe@gmail.com', 'dsfsfc', 'Degree', 'Science', ''),
(8, 'anne', 'aaaaa', 'Galle', 'Southern', '1111111', '4111111111111', 'aaa@gmail.com', 'aaaa', 'Advanced Diploma', 'Arts', 'aaaaaaa'),
(9, 'abc', 'abc', 'Colombo', 'Western', '2222222', '1111111', 'abc@gmail.com', 'abc', 'Postgraduate Diploma', 'Science', '');
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 */;
