upgrade/0.9.13/05_ip_watcher.sql

   1 CREATE TABLE `ip_watch` (
   2     `ip` CHAR(16) NOT NULL,
   3     `state` ENUM('safe', 'unsafe', 'dangerous', 'ban') NOT NULL DEFAULT 'unsafe',
   4     `detection` DATE DEFAULT 0,
   5     `last` TIMESTAMP DEFAULT 0,
   6     `uid`  SMALLINT(5) DEFAULT NULL,
   7     `description` TEXT NOT NULL,
   8     PRIMARY KEY(`ip`)
   9 );
  10
  11 # vim:set syntax=mysql: