sql.auth.secFirm.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 secFirm sf
SET
	sf.active = :active,
	sf.theme = :theme,
	sf.firmId = :firmId,
	sf.firmName = :firmName,
	sf.contactName = :contactName,
	sf.contactPhone = :contactPhone,
	sf.attributes = :attributes,
	sf.revNo = :revNo +1,
	sf.stamp = CURRENT_TIMESTAMP,
	sf.userId = :userId
WHERE
	sf.firmId = :firmId AND
	sf.revNo = :revNo