title: can't convert sql to sqlite
body: <p>this query was made for a php 5.7 script and does not function anymore, my provider is one.com and this is what they use: PHP Versie: 7.1.30
  MySQL versie: 10.3.14-MariaDB-1:10.3.14+maria~bionic</p>
  
  <p>Been already here numerous times for answers and usually i get it fixed, but this one is breaking my head! Tried DB Fiddle and they Always come up with the same fault:</p>
  
  <blockquote>
    <p>Query Error: Error: SQLITE_ERROR: near "KEY": syntax error ,and,Query Error: Error: SQLITE_ERROR: near "unsigned": syntax error</p>
  </blockquote>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE IF NOT EXISTS `bo_hourly` (
    `time` int(15) NOT NULL,
    `strikes` int(6) NOT NULL,
    `st_strikes` int(8) NOT NULL,
    UNIQUE KEY `time` (`time`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  CREATE TABLE IF NOT EXISTS `bo_stat` (
    `date` date NOT NULL,
    `strikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
    `maxdist` int(6) NOT NULL DEFAULT '0',
    `mindist` int(6) NOT NULL DEFAULT '999999',
    `maxstrikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
    `maxtime` int(15) unsigned NOT NULL DEFAULT '0',
    `maxusers` int(6) NOT NULL DEFAULT '0',
    `st_strikes` int(8) NOT NULL,
    `st_mindist` int(6) NOT NULL DEFAULT '999999',
    `st_maxdist` int(6) NOT NULL DEFAULT '0',
    `st_max` int(6) NOT NULL,
    `st_maxtime` int(15) NOT NULL,
    KEY `time` (`date`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>I know it must be simple but something near 'key' and 'unsigned' seems to be wrong, if anyone could help me on the way, perhaps i am searching too farfetched...</p>