[Erp5-dev] again comma with mysql >= 4.0.20

[Sebastien Robin]

I tell you again this problem, just to remind things :-) :

According to ISO/IEC 9075-2:2003, trailing commas are not allowed when you 
create a new table :

<table element list> ::=
  <left paren> <table element> [ { <comma> <table element> }... ] <right 
paren>


So all last version of MySQL will give you an error if you do :

create table test (
myfield tinyint(2),
);

The right syntax is :
create table test (
myfield tinyint(2)
);

Please see http://bugs.mysql.com/bug.php?id=3481 if you want more 
information.

  Sebastien.
-- 
Sebastien Robin, Nexedi Technical Director
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
ERP5: Free / Open Source ERP Software for small and medium companies
http://www.erp5.org
Storever: OpenBrick, WiFi infrastructure, notebooks and servers
http://www.storever.com