· 9 years ago · Nov 19, 2016, 11:30 AM
1CREATE TABLE IF NOT EXISTS `AUDCAD` (
2 `date` BIGINT NOT NULL,
3 `open` decimal(7,5) DEFAULT NULL,
4 `high` decimal(7,5) DEFAULT NULL,
5 `low` decimal(7,5) DEFAULT NULL,
6 `close` decimal(7,5) DEFAULT NULL,
7 `volume` INT DEFAULT NULL,
8 PRIMARY KEY(date),
9 UNIQUE (date)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;