[Web-erp-svn] SF.net SVN: web-erp:[7602] trunk/sql/mysql/upgrade4.13-4.13.1.sql

[<ex...@us...>]

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;