[Koha-bugs] [Bug 7736] Edifact QUOTE and ORDER functionality

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736

Zeno Tajoli <tajoli at cilea.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Patch doesn't apply

--- Comment #16 from Zeno Tajoli <tajoli at cilea.it> ---
Hi to all.
I can't sign-off the patch.
In kohastructure.sql and updatedatabase.pl I see:

CREATE TABLE IF NOT EXISTS edifact_messages (
  key int(11) NOT NULL auto_increment,
  message_type text NOT NULL,
  date_sent date default NULL,
  provider int(11) default NULL,
  status text,
  basketno int(11) NOT NULL default '0',
  PRIMARY KEY  (key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The string key is a reserved word in Mysql 5.5,
http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

I don't know if it is better to use `key` or to use a different name

-- 
You are receiving this mail because:
You are watching all bug changes.