· 7 years ago · Feb 16, 2019, 11:52 PM
1CREATE TABLE IF NOT EXISTS `test` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `ip` varchar(16) NOT NULL,
4 `ip_status` smallint(1) unsigned NOT NULL,
5 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 PRIMARY KEY (`id`),
7 KEY `ip` (`ip`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;