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

START TRANSACTION;



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

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

CREATE TABLE `advertisement` (
  `id` int(11) NOT NULL,
  `img` varchar(255) NOT NULL,
  `Position` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL,
  `appName` varchar(150) NOT NULL,
  `ownerName` varchar(100) NOT NULL,
  `ownerEmail` varchar(100) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `application` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `created_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `expire_time` date DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `appliedforms`
--

CREATE TABLE `appliedforms` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `dob` date NOT NULL,
  `address` text NOT NULL,
  `district` varchar(100) NOT NULL,
  `province` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `levelOfStudy` varchar(100) NOT NULL,
  `message` text DEFAULT NULL,
  `institute_id` int(11) DEFAULT NULL,
  `courses_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bankstdloan`
--

CREATE TABLE `bankstdloan` (
  `id` int(11) NOT NULL,
  `bankName` varchar(100) NOT NULL,
  `stdLoanName` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category`) VALUES
(3, 'Education'),
(6, 'Finance'),
(5, 'Food'),
(2, 'Health'),
(1, 'Technology'),
(4, 'Travel');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `contact` varchar(50) DEFAULT NULL,
  `message` text NOT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `institute_id` int(11) 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 DEFAULT NULL,
  `industry` varchar(255) DEFAULT NULL,
  `cologo` varchar(255) DEFAULT NULL,
  `codescription` text DEFAULT NULL,
  `contactDetails` text DEFAULT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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 `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `university` varchar(255) NOT NULL,
  `universityType` varchar(255) NOT NULL,
  `eventName` varchar(255) NOT NULL,
  `venue` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `link` varchar(500) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `inWebsite` varchar(10) DEFAULT NULL,
  `instituteAddress` varchar(255) DEFAULT NULL,
  `institutePhone` varchar(50) DEFAULT NULL,
  `instituteEmail` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `university`, `universityType`, `eventName`, `venue`, `date`, `time`, `link`, `description`, `banner`, `inWebsite`, `instituteAddress`, `institutePhone`, `instituteEmail`, `institute_id`, `deleted`, `approved`, `created_at`) VALUES
(1, 'Global University', 'Private', 'AI & Future Tech Conference', 'Main Hall A', '2025-08-15', '10:00:00', 'https://example.com/ai-conference', 'A conference about emerging technologies in AI.', 'banner_1689422345.jpg', 'yes', '123 University Rd', '0112345678', 'info@globaluni.edu', 1, 0, 1, '2025-06-16 16:29:33');

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

--
-- Table structure for table `external_degrees`
--

CREATE TABLE `external_degrees` (
  `id` int(11) NOT NULL,
  `university` varchar(255) NOT NULL,
  `universityType` varchar(100) NOT NULL,
  `faculty` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `courseName` varchar(255) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `level` varchar(100) DEFAULT NULL,
  `duration` varchar(100) DEFAULT NULL,
  `startDate` date DEFAULT NULL,
  `specification` text DEFAULT NULL,
  `careerOpportunities` text DEFAULT NULL,
  `industry` text DEFAULT NULL,
  `scholarships` text DEFAULT NULL,
  `courseFee` decimal(10,2) DEFAULT NULL,
  `cologo` varchar(255) DEFAULT NULL,
  `codescription` text DEFAULT NULL,
  `instituteAddress` text DEFAULT NULL,
  `institutePhone` varchar(50) DEFAULT NULL,
  `instituteEmail` varchar(100) DEFAULT NULL,
  `instituteLocation` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `external_degrees`
--

INSERT INTO `external_degrees` (`id`, `university`, `universityType`, `faculty`, `department`, `courseName`, `category`, `level`, `duration`, `startDate`, `specification`, `careerOpportunities`, `industry`, `scholarships`, `courseFee`, `cologo`, `codescription`, `instituteAddress`, `institutePhone`, `instituteEmail`, `instituteLocation`, `institute_id`, `deleted`, `approved`, `created_at`) VALUES
(1, 'Oxford University', 'Public', 'Science', 'Physics', 'Quantum Mechanics', 'Science', 'Advanced', '4 Years', '2025-09-01', 'Focus on quantum fields', 'Research, Academia, Quantum Computing', 'Science & Tech', 'Merit-based, Need-based', 12000.00, 'quantum_logo.png', 'Course about quantum theory', '123 Main St, Oxford', '01234 567890', 'info@oxford.edu', 'Oxford, UK', 1, 0, 1, '2025-06-16 16:11:15'),
(2, 'Harvard University', 'Private', 'Engineering', 'Computer Science', 'Machine Learning', 'Technology', 'Intermediate', '2 Years', '2025-01-15', 'Hands-on AI development', 'Tech Industry, Research Labs', 'Tech Sector', 'Partial Scholarships Available', 20000.00, 'ml_logo.png', 'ML course with practical focus', '456 Elm St, Cambridge', '09876 543210', 'cs@harvard.edu', 'Cambridge, MA', 2, 0, 0, '2025-06-16 16:11:15');

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

--
-- Table structure for table `fjob`
--

CREATE TABLE `fjob` (
  `id` int(11) NOT NULL,
  `aname` varchar(255) NOT NULL,
  `ano` varchar(100) NOT NULL,
  `aaddr` text NOT NULL,
  `contact` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `jobtit` varchar(255) NOT NULL,
  `fType` varchar(100) NOT NULL,
  `msalry` decimal(10,2) NOT NULL,
  `avacn` int(11) NOT NULL,
  `otfc` varchar(100) NOT NULL,
  `mca` text NOT NULL,
  `reqq` text NOT NULL,
  `pdate` date NOT NULL,
  `cdate` date NOT NULL,
  `country` varchar(100) NOT NULL,
  `approve` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `img` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fjob`
--

INSERT INTO `fjob` (`id`, `aname`, `ano`, `aaddr`, `contact`, `email`, `jobtit`, `fType`, `msalry`, `avacn`, `otfc`, `mca`, `reqq`, `pdate`, `cdate`, `country`, `approve`, `deleted`, `img`, `created_at`) VALUES
(1, 'Global Manpower Ltd', 'GML123', '123 Colombo Street, Sri Lanka', '0771234567', 'jobs@gml.com', 'Construction Worker', 'Skilled Labor', 1200.00, 50, 'Accommodation, Meals', '18-45', 'Physically Fit, Experience Required', '2025-06-01', '2025-06-30', 'Qatar', 1, 0, 'img_1718580000.jpg', '2025-06-16 16:27:54');

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

--
-- Table structure for table `fjobcategory`
--

CREATE TABLE `fjobcategory` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fjobcategory`
--

INSERT INTO `fjobcategory` (`id`, `name`) VALUES
(1, 'Skilled Labor'),
(2, 'Healthcare'),
(3, 'Engineering'),
(4, 'IT & Software'),
(5, 'Hospitality'),
(6, 'Construction'),
(7, 'Education'),
(8, 'Logistics');

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

--
-- Table structure for table `international_schools`
--

CREATE TABLE `international_schools` (
  `id` int(11) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `intschlName` varchar(255) NOT NULL,
  `branchestableRows` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`branchestableRows`)),
  `commonEmail` varchar(255) NOT NULL,
  `commonPhone` varchar(100) NOT NULL,
  `studyLevel` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `facilities` text DEFAULT NULL,
  `mainLocation` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `international_schools`
--

INSERT INTO `international_schools` (`id`, `logo`, `intschlName`, `branchestableRows`, `commonEmail`, `commonPhone`, `studyLevel`, `description`, `facilities`, `mainLocation`, `website`, `approved`, `deleted`, `created_at`) VALUES
(101, 'school_logo.png', 'Global Scholars International', '[{\"branchName\": \"Downtown Campus\", \"location\": \"City Center\", \"phone\": \"1234567890\"}, {\"branchName\": \"Uptown Campus\", \"location\": \"North Zone\", \"phone\": \"0987654321\"}]', 'info@globalscholars.edu', '+1 234-567-890', 'K-12', 'An international school offering IB curriculum.', 'Library, Sports Complex, Labs, Digital Classrooms', 'New York, USA', 'https://globalscholars.edu', 1, 0, '2025-06-16 16:13:46');

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

--
-- Table structure for table `langqualifications`
--

CREATE TABLE `langqualifications` (
  `id` int(11) NOT NULL,
  `langQualName` varchar(255) NOT NULL,
  `university` varchar(255) NOT NULL,
  `teachingMethod` varchar(100) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `courseFee` decimal(10,2) NOT NULL,
  `payMethod` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `instituteAddress` text NOT NULL,
  `institutePhone` varchar(50) NOT NULL,
  `instituteEmail` varchar(100) NOT NULL,
  `instituteWebsite` varchar(255) DEFAULT NULL,
  `instituteLocation` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `langqualifications`
--

INSERT INTO `langqualifications` (`id`, `langQualName`, `university`, `teachingMethod`, `duration`, `courseFee`, `payMethod`, `description`, `instituteAddress`, `institutePhone`, `instituteEmail`, `instituteWebsite`, `instituteLocation`, `institute_id`, `approved`, `deleted`, `created_at`) VALUES
(1, 'IELTS Academic Preparation', 'British Council', 'Online', '3 Months', 45000.00, 'Full Payment', 'Covers all four skills with test strategies and mock exams.', '389 Galle Road, Colombo 03', '+94-112-345678', 'info@britishcouncil.lk', 'https://www.britishcouncil.lk', 'Colombo, Sri Lanka', 1, 1, 0, '2025-06-16 16:24:11');

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

--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` int(11) NOT NULL,
  `level` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` (`id`, `level`) VALUES
(3, 'Advanced'),
(1, 'Beginner'),
(4, 'Expert'),
(2, 'Intermediate'),
(5, 'Master');

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

--
-- Table structure for table `ljob`
--

CREATE TABLE `ljob` (
  `id` int(11) NOT NULL,
  `jobtit` varchar(255) NOT NULL,
  `joblevel` varchar(100) NOT NULL,
  `jobtype` varchar(100) NOT NULL,
  `salary` decimal(10,2) NOT NULL,
  `cname` varchar(255) NOT NULL,
  `caddr` text NOT NULL,
  `contact` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `web` varchar(255) NOT NULL,
  `pdate` date NOT NULL,
  `cdate` date NOT NULL,
  `_desc` text NOT NULL,
  `approve` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `img` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ljob`
--

INSERT INTO `ljob` (`id`, `jobtit`, `joblevel`, `jobtype`, `salary`, `cname`, `caddr`, `contact`, `email`, `web`, `pdate`, `cdate`, `_desc`, `approve`, `deleted`, `img`, `created_at`) VALUES
(1001, 'Frontend Web Developer', 'Entry Level', 'Full-Time', 75000.00, 'TechWorld Solutions', '456 Main Street, Colombo', '+94-771234567', 'hr@techworld.lk', 'https://www.techworld.lk', '2024-06-01', '2024-07-15', 'We are looking for a skilled frontend developer familiar with HTML, CSS, and JavaScript frameworks.', 1, 0, 'img_1718579200.png', '2025-06-16 16:22:35');

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

--
-- Table structure for table `ljobcategory`
--

CREATE TABLE `ljobcategory` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ljobcategory`
--

INSERT INTO `ljobcategory` (`id`, `name`, `created_at`) VALUES
(1, 'IT & Software', '2025-06-16 16:23:20'),
(2, 'Accounting & Finance', '2025-06-16 16:23:20'),
(3, 'Healthcare', '2025-06-16 16:23:20'),
(4, 'Education', '2025-06-16 16:23:20'),
(5, 'Engineering', '2025-06-16 16:23:20'),
(6, 'Marketing', '2025-06-16 16:23:20'),
(7, 'Logistics', '2025-06-16 16:23:20');

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

--
-- Table structure for table `professional_exams`
--

CREATE TABLE `professional_exams` (
  `id` int(11) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `examName` varchar(255) NOT NULL,
  `shortName` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `tableRows` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tableRows`)),
  `university` varchar(255) DEFAULT NULL,
  `instituteAddress` varchar(255) DEFAULT NULL,
  `institutePhone` varchar(100) DEFAULT NULL,
  `instituteEmail` varchar(100) DEFAULT NULL,
  `instituteWebsite` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `level` varchar(100) DEFAULT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `professional_exams`
--

INSERT INTO `professional_exams` (`id`, `logo`, `examName`, `shortName`, `description`, `tableRows`, `university`, `instituteAddress`, `institutePhone`, `instituteEmail`, `instituteWebsite`, `institute_id`, `category`, `level`, `approved`, `deleted`, `created_at`) VALUES
(1, 'exam_logo.png', 'Certified Information Systems Auditor', 'CISA', 'CISA is a globally recognized certification for information systems audit control, assurance, and security professionals.', '[{\"module\": \"Information System Auditing\", \"duration\": \"3 months\"}, {\"module\": \"Governance and Management of IT\", \"duration\": \"2 months\"}]', 'ISACA', '123 Audit Ave, NY', '+1-555-1234', 'contact@isaca.org', 'https://www.isaca.org', 1, 'IT Certification', 'Professional', 1, 0, '2025-06-16 16:15:40');

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

--
-- Table structure for table `scholarships`
--

CREATE TABLE `scholarships` (
  `id` int(11) NOT NULL,
  `sProgrammeName` varchar(255) NOT NULL,
  `country` varchar(100) NOT NULL,
  `university` varchar(255) NOT NULL,
  `closingDate` date NOT NULL,
  `description` text NOT NULL,
  `instituteWebsite` varchar(255) NOT NULL,
  `institutePhone` varchar(50) NOT NULL,
  `instituteEmail` varchar(100) NOT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scholarships`
--

INSERT INTO `scholarships` (`id`, `sProgrammeName`, `country`, `university`, `closingDate`, `description`, `instituteWebsite`, `institutePhone`, `instituteEmail`, `banner`, `institute_id`, `approved`, `deleted`, `created_at`) VALUES
(1, 'Global Excellence Scholarship', 'Canada', 'University of Toronto', '2025-10-31', 'A merit-based scholarship for international students pursuing undergraduate studies in Canada.', 'https://www.utoronto.ca', '+1 416-978-2011', 'scholarships@utoronto.ca', 'global_scholar_banner.png', 3, 1, 0, '2025-06-16 16:16:38');

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

--
-- Table structure for table `stdloans`
--

CREATE TABLE `stdloans` (
  `id` int(11) NOT NULL,
  `university` varchar(255) NOT NULL,
  `faculty` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `degreeName` varchar(255) NOT NULL,
  `category` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `startDate` date NOT NULL,
  `specification` text NOT NULL,
  `careerOpportunities` text NOT NULL,
  `industry` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `instituteAddress` text NOT NULL,
  `institutePhone` varchar(50) NOT NULL,
  `instituteEmail` varchar(100) NOT NULL,
  `instituteLocation` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stdloans`
--

INSERT INTO `stdloans` (`id`, `university`, `faculty`, `department`, `degreeName`, `category`, `level`, `duration`, `startDate`, `specification`, `careerOpportunities`, `industry`, `description`, `instituteAddress`, `institutePhone`, `instituteEmail`, `instituteLocation`, `logo`, `institute_id`, `deleted`, `approved`, `created_at`) VALUES
(1, 'University of Colombo', 'Faculty of Arts', 'Department of Economics', 'BA in Economics', 'Humanities', 'Undergraduate', '4 Years', '2025-02-01', 'Economics, Statistics, and Policy Making', 'Policy Advisor, Financial Analyst, Economic Consultant', 'Education & Public Sector', 'A comprehensive economics degree with focus on macroeconomic planning and sustainable growth.', '94 Reid Ave, Colombo 07', '+94-112-123456', 'loans@econ.colombo.ac.lk', 'Colombo, Sri Lanka', 'econloan_logo_1718579200.png', 1, 0, 1, '2025-06-16 16:21:35');

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

--
-- Table structure for table `stdregistrations`
--

CREATE TABLE `stdregistrations` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `province` varchar(100) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `school` varchar(255) DEFAULT NULL,
  `course` varchar(255) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stdregistrations`
--

INSERT INTO `stdregistrations` (`id`, `name`, `address`, `district`, `province`, `phone`, `mobile`, `email`, `school`, `course`, `category`, `message`, `approved`, `deleted`, `created_at`) VALUES
(1, 'Tharindu Silva', '123 Galle Road, Colombo', 'Colombo', 'Western', '0112345678', '0771234567', 'tharindu@example.com', 'Royal College', 'Computer Science', 'A/L', 'Looking forward to learning new technologies.', 1, 0, '2025-06-16 16:20:33');

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

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

CREATE TABLE `student_registration` (
  `id` int(11) NOT NULL,
  `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 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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', '');

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

--
-- Table structure for table `studyabroad`
--

CREATE TABLE `studyabroad` (
  `id` int(11) NOT NULL,
  `country` varchar(100) NOT NULL,
  `university` varchar(255) NOT NULL,
  `courseName` varchar(255) NOT NULL,
  `level` varchar(100) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `startDate` date NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `specification` text DEFAULT NULL,
  `courseFee` decimal(10,2) DEFAULT NULL,
  `careerOpportunities` text DEFAULT NULL,
  `industry` text DEFAULT NULL,
  `cologo` varchar(255) DEFAULT NULL,
  `codescription` text DEFAULT NULL,
  `instituteName` varchar(255) DEFAULT NULL,
  `instituteAddress` text DEFAULT NULL,
  `institutePhone` varchar(50) DEFAULT NULL,
  `instituteEmail` varchar(100) DEFAULT NULL,
  `instituteLocation` varchar(255) DEFAULT NULL,
  `institute_id` int(11) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `studyabroad`
--

INSERT INTO `studyabroad` (`id`, `country`, `university`, `courseName`, `level`, `duration`, `startDate`, `category`, `specification`, `courseFee`, `careerOpportunities`, `industry`, `cologo`, `codescription`, `instituteName`, `instituteAddress`, `institutePhone`, `instituteEmail`, `instituteLocation`, `institute_id`, `deleted`, `approved`, `created_at`) VALUES
(1, 'Australia', 'University of Melbourne', 'Bachelor of Computer Science', 'Undergraduate', '3 Years', '2025-02-01', 'Technology', 'Core CS subjects + AI/ML specialization', 18000.00, 'Software Developer, Data Scientist, Research', 'Information Technology', 'melbourne_cs_logo.png', 'This program provides a foundation in computing, programming, and AI.', 'TechWorld Institute', '789 Park St, Melbourne, VIC', '+61-3-9000-1234', 'info@techworld.edu.au', 'Melbourne, Australia', 10, 0, 1, '2025-06-16 16:18:28');

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

--
-- Table structure for table `tuition`
--

CREATE TABLE `tuition` (
  `id` int(11) NOT NULL,
  `className` varchar(255) NOT NULL,
  `classType` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL,
  `classLevel` varchar(100) NOT NULL,
  `startDate` date DEFAULT NULL,
  `time` varchar(100) DEFAULT NULL,
  `classFee` decimal(10,2) DEFAULT NULL,
  `cbanner` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `teacherName` varchar(255) NOT NULL,
  `teacherQualification` varchar(255) NOT NULL,
  `teacherEmail` varchar(100) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `location` varchar(255) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `approved` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tuition`
--

INSERT INTO `tuition` (`id`, `className`, `classType`, `subject`, `district`, `classLevel`, `startDate`, `time`, `classFee`, `cbanner`, `description`, `teacherName`, `teacherQualification`, `teacherEmail`, `contact`, `location`, `deleted`, `approved`, `created_at`) VALUES
(101, 'O/L Maths Revision Class', 'Group', 'Mathematics', 'Colombo', 'O/L', '2025-01-15', '5:00 PM - 7:00 PM', 5000.00, 'cbanner_1718579200000.jpg', 'Comprehensive revision with model papers and past papers.', 'Mr. Nimal Perera', 'B.Sc in Mathematics', 'nimal.maths@example.com', '+94771234567', 'Colombo 05', 0, 1, '2025-06-16 16:19:26');

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

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

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

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category` (`category`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `levels`
--
ALTER TABLE `levels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `level` (`level`);

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

--
-- Indexes for table `ljobcategory`
--
ALTER TABLE `ljobcategory`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

