CREATE TABLE `investor_accounts_summary` (
  `id`                    int(11)   NOT NULL,
  `date`                  date      NOT NULL,
  `investabill_etr_funds` double    NOT NULL,
  `leasabill_etr_funds`   double    NOT NULL,
  `deferred_yields`       double    NOT NULL,
  `crystallised_yields`   double    NOT NULL,
  `created_at`            timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at`           datetime           DEFAULT NULL
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

ALTER TABLE `investor_accounts_summary`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `date` (`date`);

ALTER TABLE `investor_accounts_summary`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 1;