bretton.dev / coves
A community based topic aggregation platform built on atproto
Star
Fork 0
Watch
coves internal db migrations
60 files
001_create_users_table.sql
002_create_identity_cache_table.sql
003_create_oauth_tables.sql
004_add_oauth_indexes.sql
005_create_communities_tables.sql
006_encrypt_community_credentials.sql
007_add_password_encryption.sql
008_add_content_visibility_to_subscriptions.sql
009_create_community_blocks_table.sql
010_migrate_community_handles_to_singular.sql
011_create_posts_table.sql
012_create_aggregators_tables.sql
013_create_votes_table.sql
014_remove_votes_voter_fk.sql
015_alter_content_labels_to_jsonb.sql
016_create_comments_table.sql
017_create_unfurl_cache.sql
018_migrate_comment_namespace.sql
019_update_oauth_for_indigo.sql
020_add_mobile_oauth_csrf.sql
021_add_comment_deletion_metadata.sql
022_migrate_community_handles_to_c_prefix.sql
023_create_bluesky_post_cache.sql
024_add_aggregator_api_keys.sql
025_encrypt_aggregator_oauth_tokens.sql
026_add_author_posts_index.sql
027_add_user_profile_fields.sql
028_create_admin_reports_table.sql
029_create_user_blocks_table.sql
030_create_community_suggestions.sql
031_add_bridged_vote_stats.sql
032_create_jetstream_cursors_and_dead_letters.sql
033_create_jetstream_record_revs.sql
034_author_owned_posts.sql
035_create_post_submissions.sql
036_deleted_accounts_and_queue_index.sql
037_create_post_rematerialization_ledger.sql
038_add_community_origin.sql
039_index_community_name_origin.sql
040_recount_vote_drift.sql
041_clamp_future_comment_created_at.sql
042_index_dead_letter_retention.sql
043_add_bridged_vote_poll_watermark.sql
044_posts_search_vector.sql
045_recount_community_subscribers.sql
046_drop_encryption_keys.sql
047_web_oauth_binding.sql
048_discover_hot_snapshots.sql
049_read_path_indexes.sql
050_moderation_state.sql
051_moderation_action_log_indexes.sql
052_moderation_media_purges.sql
053_notifications.sql
054_votes_upvote_history_index.sql
055_notification_public_post_withdrawals.sql
056_moderation_content_snapshots.sql
057_users_profile_origin.sql
058_communities_origin_display.sql
059_users_origin_username_index.sql
embed.go