CREATE TABLE `AccountSignUps` ( `Id` INTEGER NOT NULL AUTO_INCREMENT , `BusinessName` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `Address1` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `Address2` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `State` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `PostCode` LONGTEXT CHARACTER SET ASCII NULL , `FirstName` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `LastName` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `Email` VARCHARACTER (?) CHARACTER SET ASCII NOT NULL , `Mobile` LONGTEXT CHARACTER SET ASCII NULL , `IsConfirm` TINYINT (?) NOT NULL , `Active` TINYINT (?) NOT NULL , `Deleted` TINYINT (?) NOT NULL , `CreatedBy` LONGTEXT CHARACTER SET ASCII NULL , `CreatedDate` DATETIME (?) NULL , `ModifiedBy` LONGTEXT CHARACTER SET ASCII NULL , `ModifiedDate` DATETIME (?) NULL , `DeletedBy` LONGTEXT CHARACTER SET ASCII NULL , `DeletedDate` DATETIME (?) NULL , CONSTRAINT `PK_AccountSignUps` PRIMARY KEY ( `Id` ) ) CHARACTER SET = ASCII 