CREATE TABLE httpstepitem ( httpstepitemid bigint unsigned DEFAULT '0' NOT NULL, httpstepid bigint unsigned DEFAULT '0' NOT NULL, itemid bigint unsigned DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httpstepitemid) ) ENGINE=InnoDB; CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid);