[Koha] mysql error

[Henri-Damien LAURENT]

Danabalou Mohanassoundarame a écrit :
> Hello/Bonjour,
>
> I got a problem to create this table in mysql-5.0.18
>
> any idea
>
> CREATE TABLE issues(
> borrowernumber int( 11 ) NOT NULL default '0',
> itemnumber int( 11 ) NOT NULL default '0',
> date_due date default NULL ,
> branchcode char( 4 ) default NULL ,
> issuingbranch char( 18 ) default NULL ,
> returndate date default NULL ,
> lastreneweddate date default NULL ,
> RETURN char( 4 ) default NULL ,
> renewals tinyint( 4 ) default NULL ,
> timestamptimestamp( 14 ) NOT NULL ,
> KEY issuesborridx( borrowernumber ) ,
> KEY issuesitemidx( itemnumber ) ,
> KEY bordate( borrowernumber, timestamp )
> ) TYPE = MYISAM ;
>
> *MySQL a répondu:*Documentation
> <http://dev.mysql.com/doc/refman/5.0/en/error-returns.html>
>
> | #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'return char(4) default NULL,
>  renewals tinyint(4) default NULL,
>  timestamp t' at line 9
>
> cordialement  
Return seems to be a reserved word for mysql5.0
Try with quoting this word.
'return'
or "return"
or `return`

HTH.
-- 
Henri-Damien LAURENT