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 use logger;
  11 alter table sessions add key(ip);
  12 insert into actions (text, description) values ('view_page', 'Consultation d\'une page');
  13 use x4dat;
  14
  15 # vim:set syntax=mysql: