CREATE TABLE `mt4server`.`sent`(
    `id` INT(11) NOT NULL,
    `chart_id` VARCHAR(255) NOT NULL,
    `type` ENUM('long', 'short') NOT NULL,
    `symbol` VARCHAR(255) NOT NULL,
    `chart_timestamp` TIMESTAMP NOT NULL,
    `chart_date` VARCHAR(255) NOT NULL,
    `chart_time` TIME NOT NULL,
    `time_frame` VARCHAR(255) NOT NULL,
    `strategy_name` VARCHAR(255) NOT NULL,
    `strategy_setting` TEXT NOT NULL,
    `open` FLOAT(50) NOT NULL,
    `high` FLOAT(50) NOT NULL,
    `low` FLOAT(50) NOT NULL,
    `close` FLOAT(50) NOT NULL,
    `sent_timestamp` TIMESTAMP NOT NULL,
    PRIMARY KEY(`id`),
    UNIQUE(`chart_id`)
) ENGINE = InnoDB;