SQL Updates for lems_wcso database 10/22/2026



ALTER TABLE lems.device_registrations
  ADD COLUMN IF NOT EXISTS verification_code VARCHAR(6),
  ADD COLUMN IF NOT EXISTS verification_expires_at TIMESTAMPTZ;

ALTER TABLE lems.device_registrations
  ADD COLUMN IF NOT EXISTS device_type VARCHAR(20);

Note: 
- Delete all devices that do not have a phone number from the database (this can be done in device management or in the database itself)
- If keeping old devices, ensure they have one of the following in device_type 
	- iphone
	- android
	- browser
	- other