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


--
-- Table structure for table `academy_settings`
--

CREATE TABLE `academy_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `academy_name` varchar(100) NOT NULL,
  `academy_website` varchar(100) DEFAULT NULL,
  `academy_email` varchar(100) DEFAULT NULL,
  `academy_contact` varchar(20) DEFAULT NULL,
  `academy_address` text,
  `academy_logo` varchar(255) DEFAULT NULL,
  `certificate_background` varchar(255) DEFAULT NULL,
  `main_color` varchar(10) DEFAULT '#030062',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `academy_settings`
--

INSERT INTO `academy_settings` VALUES (1,'ABC Academy','https://www.abcacademy.edu','contact@abcacademy.edu','+1234567890','123 Education Street\nLearning City, 560001',NULL,NULL,'#030062','2025-06-22 02:20:22');

--
-- 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 DEFAULT NULL,
  `duration` varchar(50) DEFAULT NULL,
  `grade` varchar(20) DEFAULT NULL,
  `award_date` date DEFAULT NULL,
  `marks` varchar(20) DEFAULT NULL,
  `student_photo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `certificate_no` (`certificate_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `certificates` VALUES (1,'CERT-2023-001','John Doe','Web Development','1995-05-15','6 Months','A+','2023-01-20','95%',NULL,'2025-06-22 02:20:22');


