LewisandTangled 7098e8f5a9 db: outbound message type instead of stinkier comms enqueue ...

Typing a struct for enqueuing messages out to comms.

Also, after recent PRs showing me the way in which the
previously unused metadata field would possibly be used going
forward, I think I deem it too much of a hazard to be
left alive, hence removing it and migrating any inflight
comms to extract html_body (only existing use for it).

Lewis: May this revision serve well! <did:plc:3fwecdnvtcscjnrx2p4n7alz>

2026-10-15 18:21:22 +00:00

..

20251211_initial_schema.sql

Better handles

2025-12-21 17:53:25 +02:00

20251225_passwordless_accounts.sql

Passkey-only accounts

2025-12-21 23:16:39 +02:00

20251226_trusted_devices.sql

Passkey-only accounts

2025-12-21 23:16:39 +02:00

20251227_reauth_tracking.sql

Passkey-only accounts

2025-12-21 23:16:39 +02:00

20251228_add_passkey_recovery_comms_type.sql

Passkey-only accounts

2025-12-21 23:16:39 +02:00

20251229_legacy_login_security.sql

Security improvements

2025-12-22 21:09:09 +02:00

20251230_add_preferred_locale.sql

Locales in frontend, why not

2025-12-22 18:02:32 +02:00

20251231_server_config.sql

Generic cosmetic per-server config

2025-12-23 20:35:17 +02:00

20251232_add_migration_verification_comms_type.sql

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

2025-12-24 23:57:49 +02:00

20251233_remove_channel_verifications.sql

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

2025-12-24 23:57:49 +02:00

20251234_app_password_scopes.sql

App password scopes

2025-12-25 21:17:09 +02:00

20251235_session_token_scope.sql

App password scopes

2025-12-25 21:17:09 +02:00

20251236_oauth_refresh_grace_period.sql

App password scopes

2025-12-25 21:17:09 +02:00

20251237_account_delegation.sql

Delegated accounts

2025-12-26 20:15:45 +02:00

20251238_add_rev_to_repo_seq.sql

Store rev properly like a good boy

2025-12-28 02:24:09 +02:00

20251239_add_delete_after.sql

Account lifecycle conf. vs ref

2025-12-29 21:51:09 +02:00

20251240_add_block_count.sql

Account lifecycle conf. vs ref

2025-12-29 21:51:09 +02:00

20251241_session_app_password_name.sql

App password conf. vs ref

2025-12-29 19:36:01 +02:00

20251242_invite_code_for_account.sql

Invite codes conf. vs ref

2025-12-29 20:00:58 +02:00

20251243_record_blobs.sql

Fixed migration problem

2025-12-30 23:45:44 +02:00

20251244_did_web_overrides.sql

pds-hosted did migrates away

2025-12-30 21:16:49 +02:00

20260101_account_backups.sql

Backups, adversarial migrations

2026-01-02 00:24:32 +02:00

20260102_composite_indexes.sql

Performance improvements

2026-01-03 00:58:28 +02:00

20260106_clear_user_blocks.sql

Remove old user blocks

2026-01-06 19:49:42 +02:00

20260107_add_repo_rev_to_user_blocks.sql

migrations for repo_rev tracking and backlinks table

2026-01-14 22:22:07 +02:00

20260114_backlinks.sql

migrations for repo_rev tracking and backlinks table

2026-01-14 22:22:07 +02:00

20260115_sso_external_identities.sql

sso signup & login

2026-01-18 01:15:13 +02:00

20260116_sso_auth_state_did.sql

sso signup & login

2026-01-18 01:15:13 +02:00

20260117_handle_reservations.sql

sso signup & login

2026-01-18 01:15:13 +02:00

20260118_external_identity_email_verified.sql

sso signup & login

2026-01-18 01:15:13 +02:00

20260119_add_apple_sso_provider.sql

sso signup & login

2026-01-18 01:15:13 +02:00

20260120_remove_email_uniqueness.sql

feat: oauth prompt=create, other frontend fixes

2026-01-19 17:44:24 +00:00

20260121_preferences_allow_duplicate_types.sql

fix: no preference dedup needed

2026-01-27 15:12:15 +00:00

20260122_backup_storage_key_unique.sql

fix: better dashboard UX

2026-02-02 19:29:03 +00:00

20260203_telegram_chat_id.sql

fix: telegram comms ux improvements

2026-02-04 19:08:44 +00:00

20260204_channel_verified_comms_type.sql

fix: telegram comms ux improvements

2026-02-04 19:08:44 +00:00

20260205_discord_username.sql

fix: improved discord & signal comms

2026-02-05 16:13:45 +00:00

20260206_signal_username.sql

fix: improved discord & signal comms

2026-02-05 16:13:45 +00:00

20260316_cross_pds_delegation.sql

feat: cross-pds delegation

2026-03-17 19:22:34 +00:00

20260318_drop_backups.sql

fix(backups): remove useless backups concept

2026-03-18 12:17:33 +00:00

20260321_signal_protocol_tables.sql

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

2026-03-22 07:14:19 +00:00

20260407_inline_event_blocks.sql

feat(tranquil-store): gc and hardening

2026-04-10 13:57:47 +03:00

20260408_repo_seq_created_at_index.sql

feat(tranquil-store): gc and hardening

2026-04-10 13:57:47 +03:00

20260523_add_inbound_migration_flag.sql

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

2026-05-23 23:02:43 +03:00

20260529_firehose_outbox_sequencing.sql

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

2026-05-30 21:10:38 +03:00

20260626_delegation_preset_scopes.sql

delegation: preset scopes grant identity & account

2026-06-27 23:11:24 +03:00

20260720_records_cid_index.sql

store: record-by-cid reverse index

2026-07-25 08:27:40 +03:00

20260721_backfill_invite_code_for_account.sql

invite: require owning account for generated codes

2026-07-25 08:27:39 +03:00

20260906_blob_ownership_per_user.sql

Allow blobs to be owned by multiple accounts

2026-09-12 15:34:46 +00:00

20260921_drop_comms_metadata.sql

db: outbound message type instead of stinkier comms enqueue

2026-10-15 18:21:22 +00:00

20260927_oauth_request_auth_stage.sql

fix: oauth request auth

2026-10-06 07:40:12 +00:00