CREATE TABLE `VLP_Users` (
  `VLPMemberID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `FullName` varchar(100) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Region` varchar(100) DEFAULT NULL,
  `PhoneNumber` varchar(20) DEFAULT NULL,
  `CreatedAt` datetime DEFAULT current_timestamp(),
  `ChapterID` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`VLPMemberID`),
  UNIQUE KEY `Email` (`Email`),
  KEY `fk_vlpusers_chapter` (`ChapterID`),
  CONSTRAINT `fk_vlpusers_chapter` FOREIGN KEY (`ChapterID`) REFERENCES `Chapters` (`ChapterID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
