<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Jan,<br>
<br>
Thank you for spotting this!<br>
I applied your patch into the file table.sql, in the branch-66 and
the head code of the ensembl-variation CVS.<br>
<br>
Best regards,<br>
<pre class="moz-signature" cols="72">Laurent
Ensembl Variation
</pre>
<br>
On 20/03/2012 04:46, Jan Vogel wrote:
<blockquote
cite="mid:1CCB4ABB-426B-476A-985A-F292EA3232E5@gmail.com"
type="cite">
<div><br>
</div>
<div>Heya Ensembl !</div>
<div><br>
</div>
<div>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 : </div>
<div><br>
</div>
<div><font class="Apple-style-span" face="Monaco">File:
ensembl_66/ensembl-variation/sql/table.sql</font></div>
<div>L<span class="Apple-style-span" style="font-family: Courier;
">ine 1134 ff: </span></div>
<div><br>
</div>
<div>
<div><font class="Apple-style-span" face="Courier">CREATE TABLE
meta_coord (</font></div>
<div><font class="Apple-style-span" face="Courier"><br>
</font></div>
<div><font class="Apple-style-span" face="Courier"> table_name
VARCHAR(40) NOT NULL,</font></div>
<div><font class="Apple-style-span" face="Courier">
coord_system_id INT(10) UNSIGNED NOT NULL,</font></div>
<div><font class="Apple-style-span" face="Courier"> max_length
INT,</font></div>
<div><font class="Apple-style-span" face="Courier"><br>
</font></div>
<div><font class="Apple-style-span" face="Courier">
UNIQUE(table_name, coord_system_id)</font></div>
<div><font class="Apple-style-span" face="Courier"><br>
</font></div>
<div><font class="Apple-style-span" face="Courier">)
TYPE=MyISAM;</font></div>
<div><br>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>"TYPE=MyISAM' is not supported in mysql 5.5 anymore see : </div>
<div><br>
</div>
<div><font class="Apple-style-span" face="Courier"><a
moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.5/en/create-table.html">http://dev.mysql.com/doc/refman/5.5/en/create-table.html</a></font></div>
<div><font class="Apple-style-span" face="Courier">….</font></div>
<div>
<p><font class="Apple-style-span" face="Courier"><a
moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html"
title="5.1.6. Server SQL Modes">Section 5.1.6, “Server SQL
Modes”</a>. </font></p>
<div xmlns="http://www.w3.org/1999/xhtml" class="note"
style="margin-left: 0.5in; margin-right: 0.5in;">
<div class="admon-title"><font class="Apple-style-span"
face="Courier">Note</font></div>
<p xmlns=""><font class="Apple-style-span" face="Courier"> The
older <code class="literal">TYPE</code> option was
synonymous with <code class="literal">ENGINE</code>. <code
class="literal">TYPE</code> was deprecated in MySQL 4.0
and removed in MySQL 5.5. <span class="emphasis"><em>When
upgrading to MySQL 5.5 or later, you must convert
existing applications that rely on <code
class="literal">TYPE</code> to use <code
class="literal">ENGINE</code> instead</em></span>.</font></p>
<p xmlns=""><br>
</p>
<p xmlns="">Please find the patch file attached - and keep the
good work up ! :-) ! </p>
<div><br>
</div>
<p xmlns="">Cheers, </p>
<p xmlns=""> Jan Vogel</p>
<p xmlns=""><br>
</p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<div>
<div xmlns="http://www.w3.org/1999/xhtml" class="note"
style="margin-left: 0.5in; margin-right: 0.5in;">
<p xmlns=""> </p>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Dev mailing list <a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
List admin (including subscribe/unsubscribe): <a class="moz-txt-link-freetext" href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a>
Ensembl Blog: <a class="moz-txt-link-freetext" href="http://www.ensembl.info/">http://www.ensembl.info/</a>
</pre>
</blockquote>
</body>
</html>