[ensembl-dev] ensembl-variation table.sql patch for mysql 5.5

[Jan Vogel]

Heya Ensembl !

I'm using the ensembl-variation database schema on mysql 5.5 - it works well, but the SQL to create the meta_coord table is incompatible with mysql 5.5 : 

File:  ensembl_66/ensembl-variation/sql/table.sql
Line 1134 ff: 

CREATE TABLE meta_coord (

  table_name      VARCHAR(40) NOT NULL,
  coord_system_id INT(10) UNSIGNED NOT NULL,
  max_length          INT,

  UNIQUE(table_name, coord_system_id)

) TYPE=MyISAM;




"TYPE=MyISAM' is not supported in mysql 5.5 anymore see : 

http://dev.mysql.com/doc/refman/5.5/en/create-table.html
….
Section 5.1.6, “Server SQL Modes”.

Note
The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.



Please find the patch file attached - and keep the good work up ! :-) ! 


Cheers, 

    Jan Vogel



       




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120319/86f9d321/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: patch.txt
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120319/86f9d321/attachment.txt>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120319/86f9d321/attachment-0001.html>