CREATE TABLE `account` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `sAccountName` varchar(190) DEFAULT NULL,
  `sInitialAdminPassword` 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=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `account_roles` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `iRole` bigint DEFAULT NULL,
  `sAccountAssignment` 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=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;