DROP TABLE IF EXISTS `T_ITEM`;
CREATE TABLE `T_ITEM` (
  `UUID` varchar(32) NOT NULL COMMENT 'Ö÷¼ü',
  `NAME` varchar(64) ,
  `SYMBOL` varchar(32) ,
  `SYMBOL_DATA` varchar(32) ,
  `PIPS` double ,
  `PIPS_AMOUNT` double ,
  `ADJUSTMENT_VALUE` double ,
  `UNIT_AMOUNT` double ,
   `UNIT_FEE` double ,
  `MARKET` varchar(32) ,
  PRIMARY KEY (`UUID`),
  KEY `INDEX_ITEM_SYMBOL` (`SYMBOL`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
alter table T_ITEM add DECIMALS int;

DROP TABLE IF EXISTS `T_ITEM_LEVERAGE`;
CREATE TABLE `T_ITEM_LEVERAGE` (
  `UUID` varchar(32) NOT NULL COMMENT 'Ö÷¼ü',
  `ITEM_ID` varchar(32) ,
  `LEVER_RATE` double ,
  PRIMARY KEY (`UUID`),
  KEY `INDEX_ITEM_LEVERAGE_ITEM_ID` (`ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;







 ALTER TABLE `T_ITEM` ADD COLUMN `MULTIPLE`  double NULL DEFAULT 0;