CREATE TABLE `investor_investments_history` (
  `id`                int(11) NOT NULL,
  `investment_id`     int(11) NOT NULL,
  `currency_id`       tinyint(3)     DEFAULT '0',
  `commission`        double(4, 3)   DEFAULT '0.000',
  `months`            tinyint(3)     DEFAULT '0',
  `buy_rate`          double(5, 3)   DEFAULT '0.000',
  `comment`           tinytext,
  `amount`            decimal(10, 2) DEFAULT '0.00',
  `investment_source` varchar(50)    DEFAULT NULL,
  `modified_by`       tinyint(3)     DEFAULT '0',
  `modified_at`       datetime       DEFAULT NULL
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

ALTER TABLE `investor_investments_history`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `investor_investments_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;