CREATE TABLE `Suppliers` ( `Id` INTEGER NOT NULL AUTO_INCREMENT , `SupplierName` VARCHARACTER (?) CHARACTER SET ASCII NULL , `ContactNumber` VARCHARACTER (?) CHARACTER SET ASCII NULL , `AddressLine1` VARCHARACTER (?) CHARACTER SET ASCII NULL , `AddressLine2` VARCHARACTER (?) CHARACTER SET ASCII NULL , `State` VARCHARACTER (?) CHARACTER SET ASCII NULL , `PostCode` VARCHARACTER (?) CHARACTER SET ASCII NULL , `CountryId` INTEGER NULL , `Email` VARCHARACTER (?) CHARACTER SET ASCII NULL , `PreferredOrderingMethod` LONGTEXT CHARACTER SET ASCII NULL , `Abn` VARCHARACTER (?) CHARACTER SET ASCII NULL , `SubUrb` VARCHARACTER (?) CHARACTER SET ASCII 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 , `AccountId` LONGTEXT CHARACTER SET ASCII NULL , CONSTRAINT `PK_Suppliers` PRIMARY KEY ( `Id` ) ) CHARACTER SET = ASCII 