[Weberp-cvs] SF.net SVN: web-erp:[4094] trunk

[<tim...@us...>]

Revision: 4094
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4094&view=rev
Author:   tim_schofield
Date:     2010-10-04 15:54:54 +0000 (Mon, 04 Oct 2010)

Log Message:
-----------
Matt Taylor: upgrade3.11.1-3.12.sql - Update tables to utf8

Modified Paths:
--------------
    trunk/doc/Change.log.html
    trunk/sql/mysql/upgrade3.11.1-3.12.sql

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-10-04 15:54:23 UTC (rev 4093)
+++ trunk/doc/Change.log.html	2010-10-04 15:54:54 UTC (rev 4094)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>04/10/10 Matt Taylor: upgrade3.11.1-3.12.sql - Update tables to utf8</p>
 <p>03/10/10 Gabriel Olowo: ManualPurchaseOrdering.php - Manual for purchase ordering system</p>
 <p>02/10/10 Tim: AuditTrail.php - Bug fixes and layout changes</p>
 <p>02/10/10 Tim: DailySalesInquiry.php - Bug fixes and layout changes</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-10-04 15:54:23 UTC (rev 4093)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-10-04 15:54:54 UTC (rev 4094)
@@ -1,4 +1,12 @@
 SET FOREIGN_KEY_CHECKS=0;
+ALTER TABLE `workcentres` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `stockmaster` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `custbranch` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `stockcategory` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `locations` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `www_users` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `currencies` CONVERT TO CHARACTER SET utf8;
+ALTER TABLE `suppliers` CONVERT TO CHARACTER SET utf8;
 CREATE TABLE IF NOT EXISTS `fixedassetlocations` (
   `locationid` char(6) NOT NULL default '',
   `locationdescription` char(20) NOT NULL default '',


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.