CREATE TABLE httptestitem ( httptestitemid bigint unsigned DEFAULT '0' NOT NULL, httptestid bigint unsigned DEFAULT '0' NOT NULL, itemid bigint unsigned DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httptestitemid) ) ENGINE=InnoDB; CREATE UNIQUE INDEX httptestitem_httptestitem_1 on httptestitem (httptestid,itemid);