[UPDATE] Base Structure with new DOUBLE

zhongkai · Jun 30, 2014 · b987358 · b987358
1 parent 1a3d5e6
commit b987358
Showing 1 changed file with 2 additions and 2 deletions.
diff --git a/sql/000_base_structure.sql b/sql/000_base_structure.sql
@@ -134,7 +134,7 @@ CREATE TABLE IF NOT EXISTS `settings` (
   UNIQUE KEY `setting` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-INSERT INTO `settings` (`name`, `value`) VALUES ('DB_VERSION', '0.0.11');
+INSERT INTO `settings` (`name`, `value`) VALUES ('DB_VERSION', '0.0.12');
 
 CREATE TABLE IF NOT EXISTS `shares` (
   `id` bigint(30) NOT NULL AUTO_INCREMENT,
@@ -216,7 +216,7 @@ CREATE TABLE IF NOT EXISTS `transactions` (
   `account_id` int(255) unsigned NOT NULL,
   `type` varchar(25) DEFAULT NULL,
   `coin_address` varchar(255) DEFAULT NULL,
-  `amount` double DEFAULT '0',
+  `amount` double(60,30) DEFAULT '0',
   `block_id` int(255) DEFAULT NULL,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `txid` varchar(256) DEFAULT NULL,