[platal.git] / upgrade / 0.9.11 / 05_email_watch.sql

CREATE TABLE `emails_watch` (
    `email` CHAR(60) NOT NULL,
    `state` ENUM('pending', 'safe', 'unsafe', 'dangerous') NOT NULL DEFAULT 'pending',
    `detection` DATE DEFAULT 0,
    `last` TIMESTAMP DEFAULT 0,
    `uid`  SMALLINT(5) DEFAULT NULL,
    `description` TEXT NOT NULL,
    PRIMARY KEY(`email`)
);
DROP TABLE `emails_broken`;
Commit	Line	Data
866f1333	1	CREATE TABLE `emails_watch` (
	2	`email` CHAR(60) NOT NULL,
	3	`state` ENUM('pending', 'safe', 'unsafe', 'dangerous') NOT NULL DEFAULT 'pending',
	4	`detection` DATE DEFAULT 0,
	5	`last` TIMESTAMP DEFAULT 0,
	6	`uid` SMALLINT(5) DEFAULT NULL,
	7	`description` TEXT NOT NULL,
	8	PRIMARY KEY(`email`)
	9	);
66bd2918	10	DROP TABLE `emails_broken`;