migrations · cafeteria · Tangled

A downstream fork of Tranquil PDS for use in margin.cafe margin.cafe

cafeteria migrations

55 files

· Merge upstream/main (v0.7.0) into main · 1w ago

20251211_initial_schema.sql

20251225_passwordless_accounts.sql

Passkey-only accounts

20251226_trusted_devices.sql

Passkey-only accounts

20251227_reauth_tracking.sql

Passkey-only accounts

20251228_add_passkey_recovery_comms_type.sql

Passkey-only accounts

20251229_legacy_login_security.sql

Security improvements

20251230_add_preferred_locale.sql

Locales in frontend, why not

20251231_server_config.sql

Generic cosmetic per-server config

20251232_add_migration_verification_comms_type.sql

'Clever' stateless token verification. We could revert later if it sucks.

20251233_remove_channel_verifications.sql

'Clever' stateless token verification. We could revert later if it sucks.

20251234_app_password_scopes.sql

App password scopes

20251235_session_token_scope.sql

App password scopes

20251236_oauth_refresh_grace_period.sql

App password scopes

20251237_account_delegation.sql

Delegated accounts

20251238_add_rev_to_repo_seq.sql

Store rev properly like a good boy

20251239_add_delete_after.sql

Account lifecycle conf. vs ref

20251240_add_block_count.sql

Account lifecycle conf. vs ref

20251241_session_app_password_name.sql

App password conf. vs ref

20251242_invite_code_for_account.sql

Invite codes conf. vs ref

20251243_record_blobs.sql

Fixed migration problem

20251244_did_web_overrides.sql

pds-hosted did migrates away

20260101_account_backups.sql

Backups, adversarial migrations

20260102_composite_indexes.sql

Performance improvements

20260106_clear_user_blocks.sql

Remove old user blocks

20260107_add_repo_rev_to_user_blocks.sql

migrations for repo_rev tracking and backlinks table

20260114_backlinks.sql

migrations for repo_rev tracking and backlinks table

20260115_sso_external_identities.sql

sso signup & login

20260116_sso_auth_state_did.sql

sso signup & login

20260117_handle_reservations.sql

sso signup & login

20260118_external_identity_email_verified.sql

sso signup & login

20260119_add_apple_sso_provider.sql

sso signup & login

20260120_remove_email_uniqueness.sql

feat: oauth prompt=create, other frontend fixes

20260121_preferences_allow_duplicate_types.sql

fix: no preference dedup needed

20260122_backup_storage_key_unique.sql

fix: better dashboard UX

20260203_telegram_chat_id.sql

fix: telegram comms ux improvements

20260204_channel_verified_comms_type.sql

fix: telegram comms ux improvements

20260205_discord_username.sql

fix: improved discord & signal comms

20260206_signal_username.sql

fix: improved discord & signal comms

20260316_cross_pds_delegation.sql

feat: cross-pds delegation

20260318_drop_backups.sql

fix(backups): remove useless backups concept

20260321_signal_protocol_tables.sql

feat(signal): add postgres-backed signal protocol store

20260407_inline_event_blocks.sql

feat(tranquil-store): gc and hardening

20260408_repo_seq_created_at_index.sql

feat(tranquil-store): gc and hardening

20260523_add_inbound_migration_flag.sql

feat(auth): verification-gate override, inbound-migration bypass, store deleter improvement

20260529_firehose_outbox_sequencing.sql

fix(firehose): lost events if seq commits out of order

20260626_delegation_preset_scopes.sql

delegation: preset scopes grant identity & account

20260720_records_cid_index.sql

store: record-by-cid reverse index

20260721_backfill_invite_code_for_account.sql

invite: require owning account for generated codes

20260729_users_created_at_did_index.sql

list getRepos from old to new, and give owners transition access to delegated accounts

20260812_backfill_no_ref_takedowns.sql

20260813_record_blobs_backfill_marker.sql

20260814_database_hot_path_indexes.sql

20260906_blob_ownership_per_user.sql

Allow blobs to be owned by multiple accounts

20260921_drop_comms_metadata.sql

db: outbound message type instead of stinkier comms enqueue

20260927_oauth_request_auth_stage.sql

fix: oauth request auth