[platal.git] / upgrade / 0.9.13 / 05_ip_watcher.sql

CREATE TABLE `ip_watch` (
    `ip` CHAR(16) NOT NULL,
    `state` ENUM('safe', 'unsafe', 'dangerous', 'ban') NOT NULL DEFAULT 'unsafe',
    `detection` DATE DEFAULT 0,
    `last` TIMESTAMP DEFAULT 0,
    `uid`  SMALLINT(5) DEFAULT NULL,
    `description` TEXT NOT NULL,
    PRIMARY KEY(`ip`)
);

# vim:set syntax=mysql:
Commit	Line	Data
5480a216	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	);
5480a216	10
5480a216	11	# vim:set syntax=mysql: