· 8 years ago · Jul 19, 2018, 07:54 AM
1CREATE TABLE IF NOT EXISTS `mydb`.`trades` (
2 `idtrades` INT NOT NULL AUTO_INCREMENT ,
3 `tradeid` INT NULL ,
4 `tradedate` DATE NULL ,
5 `tradetime` TIME NULL ,
6 `symbol` VARCHAR(12) NULL ,
7 `quantity` INT(11) NULL ,
8 `closeprice` DECIMAL NULL ,
9 `ordertype` VARCHAR(4) NULL ,
10 `opencloseindicator` VARCHAR(4) NULL ,
11 `multiplier` INT(11) NULL ,
12 `ibcommission` DECIMAL NULL ,
13 `ibcommissioncurrency` VARCHAR(4) NULL ,
14 `currency` VARCHAR(4) NULL ,
15 PRIMARY KEY (`idtrades`) )