CREATE TABLE `staff` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `FGC_Creator` varchar(190) DEFAULT NULL,
  `FGC_CreateDate` datetime DEFAULT NULL,
  `FGC_LastModifier` varchar(190) DEFAULT NULL,
  `FGC_LastModifyDate` datetime DEFAULT NULL,
  `FGC_Rowversion` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `FGC_UpdateHelp` varchar(190) DEFAULT NULL,
  `sStaffName` varchar(190) DEFAULT NULL,
  `sUserName` varchar(190) DEFAULT NULL,
  `sInitialPassword` varchar(190) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `ticket` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `sValue` varchar(190) DEFAULT NULL,
  `FGC_Creator` varchar(190) DEFAULT NULL,
  `FGC_CreateDate` datetime DEFAULT NULL,
  `FGC_LastModifier` varchar(190) DEFAULT NULL,
  `FGC_LastModifyDate` datetime DEFAULT NULL,
  `FGC_Rowversion` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `FGC_UpdateHelp` varchar(190) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;