--
-- Host: localhost    Database: xoolin_hostdata
-- ------------------------------------------------------


--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `certificate_no` varchar(50) NOT NULL,
  `student_name` varchar(100) NOT NULL,
  `course_name` varchar(100) NOT NULL,
  `date_of_birth` date NOT NULL,
  `duration` varchar(50) NOT NULL,
  `grade` varchar(20) NOT NULL,
  `award_date` date NOT NULL,
  `marks` varchar(50) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `certificate_no` (`certificate_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` VALUES (4,'JUB2027','FAIMA SV','INTERNATIONAL DIPLOMA IN MONTESSORI TEACHER TRAINING','2001-01-01','1 Year','A+','2025-07-05','85%','uploads/photos/1750403466_Faima-01 (1).png','2025-06-20 07:11:12'),(5,'JUB2026','LEEDHANU','MDMA','1911-03-07','6 Months','A+','2025-02-05','80%','uploads/photos/1750426863_Dhanush_500x500.jpg','2025-06-20 13:41:03');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL,
  `academy_name` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `address` text,
  `logo` varchar(255) DEFAULT NULL,
  `layout_bg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'JUBiLEE ACADEMY','https://jubileeacademy.in','care@jubileeacademy.in','08062177182','1st Floor, Opp Krishibhavan, \r\nNilambur Road, Manjeri, \r\nMalappuram, Kerala - 676121','../uploads/logo/685573eb20ea0_logo 600x200.png','');


