title: mysql - used in key specification without a key length
body: <p>Sorry, I forgot about error:
  When I try to load dump, I receive an error:</p>
  
  <pre><code>ERROR 1170 (42000) at line 225099: BLOB/TEXT column 'query' used in key specification without a key length
  </code></pre>
  
  <p>225099:</p>
  
  <pre><code>create table toc_piwik_log_profiling (
    query text not null,
    count int(10) unsigned,
    sum_time_ms float,
    UNIQUE query (query)
  );
  </code></pre>
  
  <p>What's causing the issue? And how to fix?</p>