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