dbForge automatically changes the following line from:Unexpected Symbol 'NONE'
PRIMARY KEY (ArchiveSupplierID)
Below is my table definitionPRIMARY KEY USING NONE (ArchiveSupplierID)
Code: Select all
CREATE TABLE supplierarchives (
ArchiveSupplierID INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY USING NONE (ArchiveSupplierID)
)
ENGINE = ARCHIVE
AUTO_INCREMENT = 31888
AVG_ROW_LENGTH = 148
CHARACTER SET utf8
COLLATE utf8_general_ci;
Thanks.