[gaartsen]

Hi, and sorry for my brief explanation.

My colleague and I have experienced the very same issue.

He was working on version 5.25, and I was working on version 5.28. I installed version 5.32, and still experience the same problem.

Below is the export ot the table.

/*

SQLyog Community Edition- MySQL GUI v5.32

Host – 5.0.18 : Database – xxxxxx

*********************************************************************

Server version : 5.0.18

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `originchg` */

CREATE TABLE `originchg` (

`id` int(6) NOT NULL auto_increment,

`cust` char(6) NOT NULL default '',

`mode` char(4) NOT NULL default '',

`ccy` char(3) NOT NULL default '',

`description` char(50) NOT NULL default '',

`int_port` int(6) unsigned zerofill NOT NULL default '000000',

`type` enum('FLAT','PCNT','WGHT','CUBM') NOT NULL default 'FLAT',

`rate` decimal(10,2) NOT NULL default '0.00',

`min` decimal(10,2) NOT NULL default '0.00',

`lcl` decimal(10,2) NOT NULL default '0.00',

`fcl20` decimal(10,2) NOT NULL default '0.00',

`fcl40` decimal(10,2) NOT NULL default '0.00',

`fcl40h` decimal(10,2) NOT NULL default '0.00',

`comment` char(50) NOT NULL default '',

`validity` bigint(20) default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Hopefully this will give you a bit more to work with.

[Author]

Posts