CREATE TABLE `bdp_spotprice_zeccny` (
`id` bigint(25) NOT NULL AUTO_INCREMENT,
`high` decimal(20,6) DEFAULT NULL,
`low` decimal(20,6) DEFAULT NULL,
`open` decimal(20,6) DEFAULT NULL,
`close` decimal(20,6) DEFAULT NULL,
`vol` decimal(20,4) DEFAULT NULL,
`type` varchar(20) DEFAULT NULL,
`symbol` varchar(50) DEFAULT NULL,
`tradedate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='MySQL://user:@passwd:3306/bdp/bdp_spotprice_zeccny'
`id` bigint(25) NOT NULL AUTO_INCREMENT,
`high` decimal(20,6) DEFAULT NULL,
`low` decimal(20,6) DEFAULT NULL,
`open` decimal(20,6) DEFAULT NULL,
`close` decimal(20,6) DEFAULT NULL,
`vol` decimal(20,4) DEFAULT NULL,
`type` varchar(20) DEFAULT NULL,
`symbol` varchar(50) DEFAULT NULL,
`tradedate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='MySQL://user:@passwd:3306/bdp/bdp_spotprice_zeccny'