1 CREATE TABLE core_curr_rate (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
3 curr VARCHAR(255) NOT NULL DEFAULT '',
4 rate DECIMAL(11, 8) NOT NULL DEFAULT 0,
5 `from` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00',
6 `to` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00',
10 ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_curr_lookup (curr);
11 ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_from_to_lookup (from, to);
12 ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_lookup (curr, from, to);