labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
CleanupUserLockout
Parameters
Name
Type
Mode
Definition
BEGIN DROP TEMPORARY TABLE IF EXISTS `TempUserLockout`; CREATE TEMPORARY TABLE `TempUserLockout` SELECT uals.* FROM `userauthenticationlockoutstats` uals, `users` u WHERE uals.UserID = u.UserId; TRUNCATE TABLE `userauthenticationlockoutstats`; INSERT INTO `userauthenticationlockoutstats` SELECT * FROM `TempUserLockout`; DROP TEMPORARY TABLE `TempUserLockout`; END