CREATE TABLE tableb (
ID int(11) NOT NULL AUTO_INCREMENT,
IP varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
BATCH_ID varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL,
STATUS int(11) DEFAULT NULL,
TEMP_TABLE_NAME varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL,
CREATED timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
UPDATED timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (ID),
UNIQUE KEY tableb _BATCH_ID (IP,BATCH_ID),
KEY tableb _STATUS (STATUS)
)