[bse.git] / schema / bse_sp.sql

delimiter ;;
drop procedure if exists bse_ip_lockout;
create procedure bse_ip_lockout(
  pip_address varchar(20),
  ptype char,
  plockout_end datetime)
begin
  insert bse_ip_lockouts(ip_address, type, expires)
    values(pip_address, ptype, plockout_end)
    on duplicate key update expires = plockout_end;
end;;
Commit	Line	Data
74b3689a TC	1	delimiter ;;
	2	drop procedure if exists bse_ip_lockout;
	3	create procedure bse_ip_lockout(
	4	pip_address varchar(20),
	5	ptype char,
	6	plockout_end datetime)
	7	begin
	8	insert bse_ip_lockouts(ip_address, type, expires)
	9	values(pip_address, ptype, plockout_end)
	10	on duplicate key update expires = plockout_end;
	11	end;;