equal
deleted
inserted
replaced
273 CREATE TABLE {{TABLE_PREFIX}}lockout( |
273 CREATE TABLE {{TABLE_PREFIX}}lockout( |
274 id SERIAL, |
274 id SERIAL, |
275 ipaddr varchar(40) NOT NULL, |
275 ipaddr varchar(40) NOT NULL, |
276 action varchar(20) NOT NULL DEFAULT 'credential', |
276 action varchar(20) NOT NULL DEFAULT 'credential', |
277 timestamp int NOT NULL DEFAULT 0, |
277 timestamp int NOT NULL DEFAULT 0, |
|
278 username varchar(255) NOT NULL DEFAULT '', |
278 CHECK ( action IN ('credential', 'level') ), |
279 CHECK ( action IN ('credential', 'level') ), |
279 PRIMARY KEY ( id ) |
280 PRIMARY KEY ( id ) |
280 ); |
281 ); |
281 |
282 |
282 -- Added in 1.1.1 |
283 -- Added in 1.1.1 |