CREATE TABLE `SupplierContacts` ( `Id` INTEGER NOT NULL AUTO_INCREMENT , `SupplierId` INTEGER NOT NULL , `Name` VARCHARACTER (?) CHARACTER SET ASCII NULL , `Email` 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_SupplierContacts` PRIMARY KEY ( `Id` ) ) CHARACTER SET = ASCII 