CREATE TABLE `ampm`.`test` ( `instrument_token` INT(20) NOT NULL , `exchange_token` INT(20) NOT NULL , `trading_symbol` VARCHAR(50) NOT NULL , `name` VARCHAR(50) NULL DEFAULT NULL , `last_price` FLOAT NOT NULL , `expiry` DATE NOT NULL , `strike` INT(10) NOT NULL , `tick_size` FLOAT(10) NOT NULL , `lot_size` INT(10) NOT NULL , `instrument_type` VARCHAR(4) NOT NULL , `segment` VARCHAR(10) NOT NULL , `exchange` VARCHAR(10) NOT NULL , PRIMARY KEY (`instrument_token`(20), `exchange_token`(20)), UNIQUE (`trading_symbol`(60))) ENGINE = InnoDB;