Revision: 7602
http://sourceforge.net/p/web-erp/reponame/7602
Author: exsonqu
Date: 2016-08-24 09:55:22 +0000 (Wed, 24 Aug 2016)
Log Message:
-----------
24/08/16 Exson: Fixed the latin1 charset mixed bug in supplierdiscounts table;
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.13-4.13.1.sql
Modified: trunk/sql/mysql/upgrade4.13-4.13.1.sql
===================================================================
--- trunk/sql/mysql/upgrade4.13-4.13.1.sql 2016-08-24 09:04:09 UTC (rev 7601)
+++ trunk/sql/mysql/upgrade4.13-4.13.1.sql 2016-08-24 09:55:22 UTC (rev 7602)
@@ -7,5 +7,6 @@
-- standardise transaction date to DATE type:
ALTER TABLE `debtortrans` CHANGE `trandate` `trandate` DATE NOT NULL DEFAULT '0000-00-00';
+ALTER table supplierdiscounts CONVERT TO CHARACTER SET utf8;
|
