sqlite3 metadata.db <<'SQL'
BEGIN;
UPDATE entry
SET remoteRotation = 0
WHERE origin = 1
  AND remoteRotation IS NULL;
COMMIT;
SQL