mysql -u root -p USE roundcubedb; CREATE TABLE IF NOT EXISTS `rcguard` ( -> `ip` VARCHAR(40) NOT NULL, -> `first` DATETIME NOT NULL, -> `last` DATETIME NOT NULL, -> `hits` INT(10) NOT NULL, -> PRIMARY KEY (`ip`), -> INDEX `last_index` (`last`), -> INDEX `hits_index` (`hits`) -> ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;