We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
1 parent 95c9412 commit 6033a49Copy full SHA for 6033a49
1 file changed
sql/update/20171129.sql
@@ -8,7 +8,7 @@ INSERT INTO `country` VALUES ('46', '比利时', 'be');
8
9
10
-- 用户余额字段由decimal改为int,数值变大十倍
11
-ALTER TABLE `user` MODIFY `balance` int(11) NOT NULL DEFAULT '0' COMMENT '余额,单位分'
+ALTER TABLE `user` MODIFY `balance` int(11) NOT NULL DEFAULT '0' COMMENT '余额,单位分';
12
UPDATE `user` SET balance = balance * 100;
13
14
0 commit comments