CREATE TABLE `Role_Details` ( `DetailId` INTEGER NOT NULL AUTO_INCREMENT , `RoleName` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `FAPId` INTEGER NOT NULL , `RoleDescription` VARCHARACTER (?) CHARACTER SET ASCII NULL , `MaxAlloweduser` INTEGER NOT NULL , `IsActive` TINYINT (?) NOT NULL , `IsDeleted` TINYINT (?) NOT NULL , `CreatedDate` DATETIME (?) NOT NULL , `RoleMaxCountLog` LONGTEXT CHARACTER SET ASCII NULL , `UpdatedDate` DATETIME (?) NOT NULL , CONSTRAINT `PK_Role_Details` PRIMARY KEY ( `DetailId` ) ) CHARACTER SET = ASCII 