-- SQL script to create tbl_vaccine_receipts table
-- Run this script in your MySQL database

CREATE TABLE IF NOT EXISTS `tbl_vaccine_receipts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ReceiptNo` int(11) DEFAULT NULL,
  `Date` date DEFAULT NULL,
  `UhidNo` varchar(100) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `Procedure` varchar(255) DEFAULT 'VACCINE',
  `ConsultantId` int(11) DEFAULT NULL,
  `Consultant` varchar(255) DEFAULT NULL,
  `Amount` decimal(10,2) DEFAULT 0.00,
  `PayMode` varchar(50) DEFAULT NULL,
  `ChequeNo` varchar(100) DEFAULT NULL,
  `ChequeDate` date DEFAULT NULL,
  `Status` tinyint(1) DEFAULT 1,
  `CreatedBy` int(11) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int(11) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ReceiptNo` (`ReceiptNo`),
  KEY `idx_Date` (`Date`),
  KEY `idx_Status` (`Status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
