Untitled

CREATE TABLE pf_performance_values_cusip (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  cusip_id INT(11) NOT NULL DEFAULT '0',
  period_date date NOT NULL,
  performance_value DOUBLE DEFAULT NULL,
  PRIMARY KEY (period_date,id),
  KEY cusip_id (cusip_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
PARTITION BY RANGE (TO_DAYS(period_date))
(
    partition p200001 VALUES LESS THAN (TO_DAYS('2000-01-01')),
    partition p200002 VALUES LESS THAN (TO_DAYS('2000-02-01')),
    partition p200003 VALUES LESS THAN (TO_DAYS('2000-03-01')),
    partition p200004 VALUES LESS THAN (TO_DAYS('2000-04-01')),
    partition p200005 VALUES LESS THAN (TO_DAYS('2000-05-01'))
);