install/schemas/mysql_stage2.sql
changeset 1170 71cb87b7dc3f
parent 1159 a1cca4472a58
child 1175 1e2c9819ede3
equal deleted inserted replaced
1169:d5474f54a525 1170:71cb87b7dc3f
   272 CREATE TABLE {{TABLE_PREFIX}}lockout(
   272 CREATE TABLE {{TABLE_PREFIX}}lockout(
   273   id int(12) NOT NULL auto_increment,
   273   id int(12) NOT NULL auto_increment,
   274   ipaddr varchar(40) NOT NULL,
   274   ipaddr varchar(40) NOT NULL,
   275   action ENUM('credential', 'level') NOT NULL DEFAULT 'credential',
   275   action ENUM('credential', 'level') NOT NULL DEFAULT 'credential',
   276   timestamp int(12) NOT NULL DEFAULT 0,
   276   timestamp int(12) NOT NULL DEFAULT 0,
       
   277   username varchar(255) NOT NULL DEFAULT '',
   277   PRIMARY KEY ( id )
   278   PRIMARY KEY ( id )
   278 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   279 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   279 
   280 
   280 -- Added in 1.1.1
   281 -- Added in 1.1.1
   281 
   282