V41__tabela_bloquei_login.sql 579 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 
CREATE TABLE `login_attempt` (
  `id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `amount` int(2) NOT NULL DEFAULT '1',
  `reset_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE login_attempt
  ADD PRIMARY KEY (`id`),
  ADD KEY `amount` (`amount`),
  ADD KEY `reset_at` (`reset_at`),
  ADD KEY `key` (`key`) USING BTREE;



ALTER TABLE login_attempt
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;