Commit | Line | Data |
---|---|---|
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: |