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

[Laurent Gil]

Hi Jan,

Thank you for spotting this!
I applied your patch into the file table.sql, in the branch-66 and the 
head code of the ensembl-variation CVS.

Best regards,

Laurent
Ensembl Variation


On 20/03/2012 04:46, Jan Vogel wrote:
>
> 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" 
> <http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html>.
>
> 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
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120412/f72f89da/attachment.html>