sql.auth.secUser.update.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of butor-auth-dao Show documentation

This project is an authentication module (DAO).

There is a newer version: 1.0.31

UPDATE secUser
SET
	active = :active,
	resetInProgress = :resetInProgress,
	lastQ = :lastQ,
	missedLogin = :missedLogin,
	pwd = :pwd,
	firmId = :firmId,
	displayName = :displayName,
	fullName = :fullName,
	email = :email,
	phone = :phone,
	firstName = :firstName,
	lastName = :lastName,
	lastLoginDate = :lastLoginDate,
	attributes = :attributes,
	revNo = :revNo +1,
	stamp = CURRENT_TIMESTAMP,
	userId = :userId
WHERE
	id = :id
AND revNo = :revNo