projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
8d062bd
)
sql/core_curr_rate.sql
author
Edward
<edward@roojs.com>
Mon, 20 Oct 2014 09:00:26 +0000
(17:00 +0800)
committer
Edward
<edward@roojs.com>
Mon, 20 Oct 2014 09:00:26 +0000
(17:00 +0800)
sql/core_curr_rate.sql
patch
|
blob
|
history
diff --git
a/sql/core_curr_rate.sql
b/sql/core_curr_rate.sql
index
ff8c24f
..
7a62766
100644
(file)
--- a/
sql/core_curr_rate.sql
+++ b/
sql/core_curr_rate.sql
@@
-1,7
+1,7
@@
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,
+ rate
FLOAT(11
) NOT NULL DEFAULT 0,
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)