From 5be871b4d0f9abccb266496b80f5b9dc2e7f5bd6 Mon Sep 17 00:00:00 2001 From: Edward Date: Mon, 20 Oct 2014 16:51:46 +0800 Subject: [PATCH] sql/core_curr_rate.sql --- sql/core_curr_rate.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/core_curr_rate.sql b/sql/core_curr_rate.sql index 169edad0..ff8c24fa 100644 --- a/sql/core_curr_rate.sql +++ b/sql/core_curr_rate.sql @@ -2,11 +2,11 @@ CREATE TABLE core_curr_rate ( id INT(11) NOT NULL AUTO_INCREMENT , curr VARCHAR(255) NOT NULL DEFAULT '', rate DECIMAL(11, 8) NOT NULL DEFAULT 0, - `from` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00', - `to` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00', + from_dt DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00', + to_dt DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00', PRIMARY KEY (id) ); ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_curr_lookup (curr); -ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_from_to_lookup (from, to); -ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_lookup (curr, from, to); +ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_from_to_lookup (from_dt, to_dt); +ALTER TABLE core_curr_rate ADD INDEX core_curr_rate_lookup (curr, from_dt, to_dt); -- 2.39.2