[Koha] mysql error

[Danabalou Mohanassoundarame]

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
|
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mohanassoundarame.danabalou.vcf
Type: text/x-vcard
Size: 429 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20060328/8c11a762/mohanassoundarame.danabalou.vcf