π End-to-end encrypted cloud for everything.
Dart 2faandroidauthye2eeencryptionend-to-end-encryptionfluttergolanggoogle-photosgoogle-photos-alternativeiosopensourcephotosprivacyprivacy-toolstypescriptzero-knowledge
BEGIN;
ALTER TABLE tokens ALTER COLUMN token DROP NOT NULL;
CREATE OR REPLACE FUNCTION sync_token_hash() RETURNS TRIGGER AS $$
BEGIN
IF NEW.token IS NOT NULL THEN
NEW.token_hash := sha256(convert_to(NEW.token, 'UTF8'));
NEW.token := NULL;
END IF;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
COMMIT;