cRrTG5kT

1CREATE TABLE IF NOT EXISTS marketData (
2        date                      INT(8) NOT NULL DEFAULT 0,
3        name                      CHAR(40) NOT NULL DEFAULT "",
4        t                         INT NOT NULL DEFAULT 0,
5        value                     FLOAT NOT NULL DEFAULT 0,
6        timestamp                 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
7        INDEX(date),
8        INDEX(name),
9        INDEX(t),
10        INDEX(timestamp),
11        PRIMARY KEY               (date, name, t)
12) ENGINE MyISAM;