CREATE TABLE `Audit_Schedule` ( `Id` INTEGER NOT NULL AUTO_INCREMENT , `UserId` INTEGER NOT NULL , `AuditScheduleTitle` VARCHARACTER (?) CHARACTER SET ASCII NULL , `AuditScheduleDescription` VARCHARACTER (?) CHARACTER SET ASCII NULL , `CompletedDate` DATETIME (?) NULL , `IsDeleted` TINYINT (?) NOT NULL , `IsActive` TINYINT (?) NOT NULL , `Createdby` INTEGER NOT NULL , `CreatedDate` DATETIME (?) NOT NULL , `Updatedby` INTEGER NOT NULL , `UpdatedDate` DATETIME (?) NULL , `ComplianceType` VARCHARACTER (?) CHARACTER SET ASCII NULL , `SAAssessmentType` TINYINT (?) NOT NULL , `IAAssessmentType` TINYINT (?) NOT NULL , `EAAssessmentType` TINYINT (?) NOT NULL , `SMAssessmentType` TINYINT (?) NOT NULL , `AssessmentById` INTEGER NOT NULL , `IsCompleted` TINYINT (?) NOT NULL , `OrgEmailAddress` LONGTEXT CHARACTER SET ASCII NULL , CONSTRAINT `PK_Audit_Schedule` PRIMARY KEY ( `Id` ) ) CHARACTER SET = ASCII 