Ragnarok schema lacks "login" table?

[Eisetley]

I'm trying to set up the newest rA I've just downloaded from git and there's no "login" table after importing main.sql. There's also an error:

11:03:57    CREATE TABLE IF NOT EXISTS `ipbanlist` (   `list` varchar(255) NOT NULL default '',   `btime` datetime NOT NULL,   `rtime` datetime NOT NULL,   `reason` varchar(255) NOT NULL default '',   KEY (`list`) ) ENGINE=MyISAM    Error Code: 1071. Specified key was too long; max key length is 1000 bytes    0.046 sec

What should I do?

@edit

I created the login table by running a separate script, but there are more errors. ragnarok.market, ragnarok.sc_data, ragnarok.mapreg are missing.

Edited October 24, 2018 by Eisetley

[Vykimo]

Please give infos about your SQL version (Phpmyadmin)

[Eisetley]

I downloaded and installed community server + workbench from official source yesterday so it's most likely the recent version.

[Eisetley]

Ok, there's something wrong with script for creating ipbanlist and workbench refuses to execute script after it. How do I fix it?

-- Table structure for table `ipbanlist`
--

CREATE TABLE IF NOT EXISTS `ipbanlist` (
  `list` varchar(255) NOT NULL default '',
  `btime` datetime NOT NULL,
  `rtime` datetime NOT NULL,
  `reason` varchar(255) NOT NULL default '',
  KEY (`list`)
) ENGINE=MyISAM;