ALTER TABLE kanadi_devices
ADD COLUMN IF NOT EXISTS fingerprint VARCHAR(64),
ADD COLUMN IF NOT EXISTS client_fingerprint VARCHAR(64),
ADD COLUMN IF NOT EXISTS server_fingerprint VARCHAR(64);

CREATE INDEX IF NOT EXISTS idx_devices_fingerprint ON kanadi_devices(fingerprint);
CREATE INDEX IF NOT EXISTS idx_devices_client_fingerprint ON kanadi_devices(client_fingerprint);
CREATE INDEX IF NOT EXISTS idx_devices_server_fingerprint ON kanadi_devices(server_fingerprint);