π End-to-end encrypted cloud for everything.
Dart 2faandroidauthye2eeencryptionend-to-end-encryptionfluttergolanggoogle-photosgoogle-photos-alternativeiosopensourcephotosprivacyprivacy-toolstypescriptzero-knowledge
CREATE TABLE IF NOT EXISTS memory_shares (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT NOT NULL REFERENCES users(user_id),
type TEXT NOT NULL CHECK (type IN ('share', 'lane')),
memory_hash TEXT,
metadata_cipher TEXT,
metadata_nonce TEXT,
mem_enc_key TEXT NOT NULL,
mem_key_decryption_nonce TEXT NOT NULL,
access_token TEXT NOT NULL UNIQUE,
is_deleted BOOLEAN DEFAULT false,
created_at BIGINT NOT NULL,
updated_at BIGINT NOT NULL
);
CREATE TABLE IF NOT EXISTS memory_share_files (
id BIGSERIAL PRIMARY KEY,
memory_share_id BIGINT NOT NULL REFERENCES memory_shares(id) ON DELETE CASCADE,
file_id BIGINT NOT NULL,
file_owner_id BIGINT NOT NULL,
position BIGINT NOT NULL,
file_enc_key TEXT NOT NULL,
file_key_decryption_nonce TEXT NOT NULL,
created_at BIGINT NOT NULL,
UNIQUE(memory_share_id, position)
);