SQLite format 3@ .) 9M'indexsqlite_autoindex_domain_blocks_1domain_blockstableblocksblocksCREATE TABLE "blocks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "blocksrctarget" UNIQUE ("account_id", "target_account_id"))+?indexsqlite_autoindex_blocks_3blocks+?indexsqlite_autoindex_blocks_2blocks+?indexsqlite_autoindex_blocks_1blocks%%tableapplicationsapplicationsCREATE TABLE "applications" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "name" VARCHAR NOT NULL, "website" VARCHAR, "redirect_uri" VARCHAR NOT NULL, "client_id" CHAR(26) NOT NULL, "client_secret" VARCHAR NOT NULL, "scopes" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))7K%indexsqlite_autoindex_applications_1applicationsWtableaccountsaccountsCREATE TABLE "accounts" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "username" VARCHAR NOT NULL, "domain" VARCHAR, "avatar_media_attachment_id" CHAR(26), "avatar_remote_url" VARCHAR, "header_media_attachment_id" CHAR(26), "header_remote_url" VARCHAR, "display_name" VARCHAR, "fields" VARCHAR, "note" VARCHAR, "memorial" BOOLEAN DEFAULT false, "also_known_as" CHAR(26), "moved_to_account_id" CHAR(26), "bot" BOOLEAN DEFAULT false, "reason" VARCHAR, "locked" BOOLEAN DEFAULT true, "discoverable" BOOLEAN DEFAULT false, "privacy" VARCHAR, "sensitive" BOOLEAN DEFAULT false, "language" VARCHAR NOT NULL DEFAULT 'en', "uri" VARCHAR NOT NULL, "url" VARCHAR, "last_webfingered_at" timestamptz, "inbox_uri" VARCHAR, "outbox_uri" VARCHAR, "following_uri" VARCHAR, "followers_uri" VARCHAR, "featured_collection_uri" VARCHAR, "actor_type" VARCHAR NOT NULL, "private_key" VARCHAR, "public_key" VARCHAR, "public_key_uri" VARCHAR NOT NULL, "sensitized_at" timestamptz, "silenced_at" timestamptz, "suspended_at" timestamptz, "hide_collections" BOOLEAN DEFAULT false, "suspension_origin" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), UNIQUE ("url"), UNIQUE ("inbox_uri"), UNIQUE ("outbox_uri"), UNIQUE ("following_uri"), UNIQUE ("followers_uri"), UNIQUE ("featured_collection_uri"), UNIQUE ("public_key_uri"), CONSTRAINT "userdomain" UNIQUE ("username", "domain"))0Eindexsqlite_autoindex_accounts_10accounts/Cindexsqlite_autoindex_accounts_9accounts/ Cindexsqlite_autoindex_accounts_8accounts/ Cindexsqlite_autoindex_accounts_7accounts / Cindexsqlite_autoindex_accounts_6accounts / Cindexsqlite_autoindex_accounts_5accounts / Cindexsqlite_autoindex_accounts_4accounts /Cindexsqlite_autoindex_accounts_3accounts /Cindexsqlite_autoindex_accounts_2accounts/Cindexsqlite_autoindex_accounts_1accounts233 tablebun_migration_locksbun_migration_locksCREATE TABLE bun_migration_locks ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "table_name" VARCHAR, UNIQUE ("table_name"))EY3indexsqlite_autoindex_bun_migration_locks_1bun_migration_locksP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)V))gtablebun_migrationsbun_migrationsCREATE TABLE bun_migrations ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARC`Qӂ,gHp=h$RrBG7< `8pH X 0  h @  x P ( ` 8  p H X0h@xP(`8pH X0h@xP(&a) 3202501191127452025-05-05 17:23:26&`) 3202501061655292025-05-05 17:23:26&_) 3202501061145122025-05-05 17:23:26&^) 3202412031246082025-05-05 17:23:26&]) 3202411240126362025-05-05 17:23:26&\) 3202411240126352025-05-05 17:23:26&[) 3202411211216232025-05-05 17:23:26&Z) 3202411131521262025-05-05 17:23:26&Y) 3202411131510422025-05-05 17:23:26&X) 3202410221530162025-05-05 17:23:26&W) 3202410181510362025-05-05 17:23:26&V) 3202410111157132025-05-05 17:23:26&U) 3202410051004382025-05-05 17:23:26&T) 3202409242229382025-05-05 17:23:26&S) 3202409061444322025-05-05 17:23:26&R) 3202409040844062025-05-05 17:23:26&Q) 3202409032128422025-05-05 17:23:26&P) 3202408091344482025-05-05 17:23:26&O) 3202407252119332025-05-05 17:23:26&N) 3202407222225562025-05-05 17:23:26&M) 3202407161513272025-05-05 17:23:26&L) 3202407152042032025-05-05 17:23:26&K) 3202407120055362025-05-05 17:23:26&J) 3202406200745302025-05-05 17:23:25&I) 3202406171342102025-05-05 17:23:25&H) 3202406130918532025-05-05 17:23:25&G) 3202406111907332025-05-05 17:23:25&F) 3202405280716202025-05-05 17:23:25&E) 3202404261228212025-05-05 17:23:25&D) 3202404141223482025-05-05 17:23:25&C) 3202404021133052025-05-05 17:23:25&B) 3202404011303382025-05-05 17:23:25&A) 3202403201144472025-05-05 17:23:25&@) 3202403181153362025-05-05 17:23:25&?) 3202403101200462025-05-05 17:23:25&>) 3202402281136082025-05-05 17:23:25&=) 3202402202045262025-05-05 17:23:25&<) 3202401291707252025-05-05 17:23:25&;) 3202401260640042025-05-05 17:23:25&:) 3202401141126372025-05-05 17:23:25&9) 3202401031709452025-05-05 17:23:25&8) 3202312271108452025-05-05 17:23:25&7) 3202312151159202025-05-05 17:23:25&6) 3202312121447152025-05-05 17:23:25&5) 3202312081522422025-05-05 17:23:25&4) 3202311301036432025-05-05 17:23:25&3) 3202311281408472025-05-05 17:23:25&2) 3202311101423302025-05-05 17:23:25&1) 3202310291438192025-05-05 17:23:25&0) 3202310161132352025-05-05 17:23:25&/) 3202310021533272025-05-05 17:23:25&.) 3202309080831212025-05-05 17:23:25&-) 3202309051339042025-05-05 17:23:25&,) 3202308281013222025-05-05 17:23:25&+) 3202308210753422025-05-05 17:23:25&*) 3202308171747002025-05-05 17:23:25&)) 3202308151645002025-05-05 17:23:25&() 3202307241000002025-05-05 17:23:25&') 3202307181615202025-05-05 17:23:25&&) 3202307130259392025-05-05 17:23:25&%) 3202307112148152025-05-05 17:23:25&$) 3202306201039322025-05-05 17:23:25&#) 3202305211058502025-05-05 17:23:25&") 3202305151739192025-05-05 17:23:25&!) 3202305111814302025-05-05 17:23:24& ) 3202304301057352025-05-05 17:23:24&) 3202304051300212025-05-05 17:23:24&) 3202303282030242025-05-05 17:23:24&) 3202302211509572025-05-05 17:23:24&) 3202302022127002025-05-05 17:23:24&) 3202301261707192025-05-05 17:23:24&) 3202301051711442025-05-05 17:23:24&) 3202212201345142025-05-05 17:23:24&) 3202211081424192025-05-05 17:23:24&) 3202211032035532025-05-05 17:23:24&) 3202210311456492025-05-05 17:23:24&) 3202210111257322025-05-05 17:23:24&) 3202210061148422025-05-05 17:23:24&) 3202209261152332025-05-05 17:23:24&) 3202209221424082025-05-05 17:23:24&) 3202209161227012025-05-05 17:23:24&) 3202209051505052025-05-05 17:23:24&) 3202209031410162025-05-05 17:23:24&) 3202208300147322025-05-05 17:23:24& ) 3202208270851212025-05-05 17:23:24& ) 3202208231402282025-05-05 17:23:24& ) 3202208041201322025-05-05 17:23:24& ) 3202207101530202025-05-05 17:23:24& ) 3202206120918002025-05-05 17:23:24&) 3202205181236212025-05-05 17:23:24&) 3202205111652122025-05-05 17:23:24&) 3202205061108222025-05-05 17:23:24&) 3202205021138062025-05-05 17:23:24&) 3202203151608142025-05-05 17:23:24&) 3202203051303282025-05-05 17:23:24&) 3202202141756502025-05-05 17:23:24&) 3202111131143072025-05-05 17: a )bun_migrationsn   ~W%% .c https://bgmcd.org/users/bgmcd.org/following      UoN- X, X * U8+Qrouter_sessionssqlite_autoindex_router_sessions_11 12%Kapplicationssqlite_autoindex_applications_11 1-%Aapplicationsapplications_client_id_idx1 16%Sapplicationsapplications_managed_by_user_id_idx1 1,Einstancessqlite_autoindex_instances_11 1,Einstancessqlite_autoindex_instances_21 1,Einstancessqlite_autoindex_instances_31 14'Maccount_statssqlite_autoindex_account_stats_11 1@ 3Yadvanced_migrationssqlite_autoindex_advanced_migrations_11 1* Caccountssqlite_autoindex_accounts_11 1* Caccountssqlite_autoindex_accounts_21 1* Caccountssqlite_autoindex_accounts_31 1, Caccountssqlite_autoindex_accounts_41 1 1)Aaccountsaccounts_following_uri_idx1 1"3accountsaccounts_domain_idx1 1-accountsaccounts_uri_idx1 1-accountsaccounts_url_idx1 1%9accountsaccounts_inbox_uri_idx1 1&;accountsaccounts_outbox_uri_idx1 1)Aaccountsaccounts_followers_uri_idx1 1)bun_migrations110     JJ3 AI/7AU)01JTGQJQ86KB1SJAJ5EBSSEGRKbgmcd.org instance applicationhttps://bgmcd.org["https://bgmcd.org"]01PG1Z78MWJV15N4MH23GEWA8128c86811-b615-4e1a-b795-b5620b84dd24write:accounts A 01JTGQJQ86KB1SJAJ5EBSSEGRK       [' uH # L F[[~OtableaccountsaccountsCREATE TABLE "accounts" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "username" VARCHAR NOT NULL, "domain" VARCHAR, "avatar_media_attachment_id" CHAR(26), "avj$'tablementionsmentions'CREATE TABLE "mentions" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "status_id" CHAR(26) NOT NULL, "origin_account_id" CHAR(26) NOT NULL, "origin_account_uri" VARCHAR NOT NULL, "target_account_id" CHAR(26) NOT NULL, "silent" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"))=!Q+indexsqlite_autoindex_follow_requests_3follow_requests$= Q+indexsqlite_autoindex_follow_requests_2follow_requests#=Q+indexsqlite_autoindex_follow_requests_1follow_requests"x++'tablefollow_requestsfollow_requests!CREATE TABLE "follow_requests" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "show_reblogs" BOOLEAN DEFAULT true, "notify" BOOLEAN DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "frsrctarget" UNIQUE ("account_id", "target_account_id"))-Aindexsqlite_autoindex_follows_3follows -Aindexsqlite_autoindex_follows_2follows-Aindexsqlite_autoindex_follows_1follows^tablefollowsfollowsCREATE TABLE "follows" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "show_reblogs" BOOLEAN DEFAULT true, "notify" BOOLEAN DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "srctarget" UNIQUE ("account_id", "target_account_id"))+?indexsqlite_autoindex_blocks_3blocks+?indexsqlite_autoindex_blocks_2blocks+?indexsqlite_autoindex_blocks_1blockstableblocksblocksCREATE TABLE "blocks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "blocksrctarget" UNIQUE ("account_id", "target_account_id"))9K%indexsqlite_autoindex_applications_1applicationsEY3indexsqlite_autoindex_email_domain_blocks_1email_domain_blocksdQ33Itableemail_domain_blocksemail_domain_blocksCREATE TABLE "email_domain_blocks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "created_by_account_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))9M'indexsqlite_autoindex_domain_blocks_1domain_blocks3''%tabledomain_blocksdomain_blocksCREATE TABLE "domain_blocks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "created_by_account_id" CHAR(26) NOT NULL, "private_comment" VARCHAR, "public_comment" VARCHAR, "obfuscate" BOOLEAN DEFAULT false, "subscription_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"))233 tablebun_migration_locksbun_migration_locksCREATE TABLE bun_migration_locks ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "table_name" VARCHAR, UNIQUE ("table_name"))EY3indexsqlite_autoindex_bun_migration_locks_1bun_migration_locksP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)V))gtablebun_migrationsbun_migrationsCREATE TABLE bun_migrations ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR, "group_id" INTEGER, "migrated_at" TIMESTAMP NOT NULL DEFAULT current_timestamp)  v 1 i @ P6tableusersusers:CREATE TABLE "users" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "email" VARCHAR, "account_id" CHAR(26) NOT NULL, "encrypted_password" VARCHAR NOT NULL, "sign_up_ip" BLOB, "invite_id" CHAR(26), "locale" VARCHAR, "created_by_application_id" CHAR(26), "last_emailed_at" timestamptz, "confirmation_token" VARCHAR, "confirmation_sent_at" timestamptz, "confirmed_at" timestamptz, "unconfirmed_email" VARCHAR, "moderator" BOOLEAN NOT NULL DEFAULT false, "admin" BOOLEAN NOT NULL DEFAULT false, "disabled" BOOLEAN NOT NULL DEFAULT false, "approved" BOOLEAN NOT NULL DEFAULT false, "reset_password_token" VARCHAR, "reset_password_sent_at" timestamptz, "external_id" TEXT, "reason" TEXT, "two_factor_secret" VARCHAR, "two_factor_backups" VARCHAR, "two_factor_enabled_at" timestamptz, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("email"), UNIQUE ("account_id"))k&)tablestatusesstatuses)CREATE TABLE "statuses" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "url" VARCHAR, "content" VARCHAR, "attachments" VARCHAR, "tags" VARCHAR, "mentions" VARCHAR, "emojis" VARCHAR, "local" BOOLEAN NOT NULL DEFAULT false, "account_id" CHAR(26) NOT NULL, "account_uri" VARCHAR NOT NULL, "in_reply_to_id" CHAR(26), "in_reply_to_uri" VARCHAR, "in_reply_to_account_id" CHAR(26), "boost_of_id" CHAR(26), "boost_of_account_id" CHAR(26), "content_warning" VARCHAR, "sensitive" BOOLEAN NOT NULL DEFAULT false, "language" VARCHAR, "created_with_application_id" CHAR(26), "activity_streams_type" VARCHAR NOT NULL, "text" VARCHAR, "federated" BOOLEAN NOT NULL, "pinned_at" TIMESTAMPTZ, "fetched_at" TIMESTAMPTZ, "poll_id" CHAR(26), "thread_id" CHAR(26), "interaction_policy" JSONB, "pending_approval" BOOLEAN NOT NULL DEFAULT false, "approved_by_uri" varchar, "edits" VARCHAR, "visibility" SMALLINT NOT NULL DEFAULT 0, "edited_at" timestamptz, "content_type" INTEGER, "content_warning_text" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"))/%Cindexsqlite_autoindex_mentions_1mentions()7=indexsqlite_autoindex_users_1users;'5;indexsqlite_autoindex_tags_2tags9'4;indexsqlite_autoindex_tags_1tags8[3tabletagstags7CREATE TABLE "tags" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "name" VARCHAR NOT NULL, "useable" BOOLEAN NOT NULL DEFAULT true, "listable" BOOLEAN NOT NULL DEFAULT true, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("name"))?0S-indexsqlite_autoindex_status_bookmarks_1status_bookmarks4h/--tablestatus_bookmarksstatus_bookmarks3CREATE TABLE "status_bookmarks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"));,O)indexsqlite_autoindex_status_to_tags_1status_to_tags09+))-tablestatus_to_tagsstatus_to_tags/CREATE TABLE "status_to_tags" ("status_id" CHAR(26) NOT NULL, "tag_id" CHAR(26) NOT NULL, CONSTRAINT "statustag" UNIQUE ("status_id", "tag_id"))?*S-indexsqlite_autoindex_status_to_emojis_1status_to_emojis.E)--=tablestatus_to_emojisstatus_to_emojis-CREATE TABLE "status_to_emojis" ("status_id" CHAR(26) NOT NULL, "emoji_id" CHAR(26) NOT NULL, CONSTRAINT "statusemoji" UNIQUE ("status_id", "emoji_id"))/(Cindexsqlite_autoindex_statuses_2statuses+/'Cindexsqlite_autoindex_statuses_1statuses*                   @JxMMMMMJ6stableusersusers:CREATE T(6/tableusersusers:C 6ytableusersusers:CREATn6;tableusersuserV6 tableusersusers:CREATE TABLE "user*63tableusersusers:CR6{tableusersusers:CREAp6?tableusersusers:CREATE TABLE "users" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "email" VARCHAR, "account_id" CHAR(26) NOT NULL, "encrypted_password" VARCHAR NOT NULL, "sign_up_ip" BLOB, "invite_id" CHAR(26), "locale" VARCHAR, "created_by_application_id" CHAR(26), "last_emailed_at" timestamptz, "confirmation_token" VARCHAR, "confirmation_sent_at" timestamptz, "confirmed_at" timestamptz, "unconfirmed_email" VARCHAR, "moderator" BOOLEAN NOT NULL DEFAULT false, "admin" BOOLEAN NOT NULL DEFAULT false, "disabled" BOOLEAN NOT NULL DEFAULT false, "approved" BOOLEAN NOT NULL DEFAULT false, "reset_password_token" VARCHAR, "reset_password_sent_at" timestamptz, "external_id" TEXT, "reason" TEXT, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("email"), UNIQUE ("account_id")))7=indexsqlite_autoindex_users_1users;'5;indexsqlite_autoindex_tags_2tags9'4;indexsqlite_autoindex_tags_1tags8tabletagstags7C3itabletagstags7CREATE TABLE "t3tabletagstags7CREATE TABLE "tags" ("id" CHAR(26) NOT NU[3tabletagstags7CREATE TABLE "tags" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "name" VARCHAR NOT NULL, "useable" BOOLEAN NOT NULL DEFAULT true, "listable" BOOLEAN NOT NULL DEFAULT true, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("name")) K%indexsqlite_autoindex_status_mutes_1status_mutes6 _%%{tablestatus_mutesstatus_mutes5CREATE TABLE "status_mutes" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))?0S-indexsqlite_autoindex_status_bookmarks_1status_bookmarks4h/--tablestatus_bookmarksstatus_bookmarks3CREATE TABLE "status_bookmarks" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))K%indexsqlite_autoindex_status_faves_1status_faves2w%%+tablestatus_favesstatus_faves1CREATE TABLE "status_faves" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, "uri" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"));,O)indexsqlite_autoindex_status_to_tags_1status_to_tags09+))-tablestatus_to_tagsstatus_to_tags/CREATE TABLE "status_to_tags" ("status_id" CHAR(26) NOT NULL, "tag_id" CHAR(26) NOT NULL, CONSTRAINT "statustag" UNIQUE ("status_id", "tag_id"))?*S-indexsqlite_autoindex_status_to_emojis_1status_to_emojis.E)--=tablestatus_to_emojisstatus_to_emojis-CREATE TABLE "status_to_emojis" ("status_id" CHAR(26) NOT NULL, "emoji_id" CHAR(26) NOT NULL, CONSTRAINT "statusemoji" UNIQUE ("status_id", "emoji_id"))/(Cindexsqlite_autoindex_statuses_2statuses+/'CindexsqliteA 01PG1Z78MWJV15N4MH23GEWA81                     @?>  -  (l-!!!!!! F+G?indexsqlite_autoindex_tokens_1tokensL.D++tablerouter_sessionsrouter_sessionsICREATE TABLE "router1I9tableclientsclientsNCREATE TABLE "clients" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "secret" VARCHAR NOT NULL, "domain" VARCHAR NOT NULL, "user_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"))+H?indexsqlite_autoindex_tokens_2tokensM+G?indexsqlite_autoindex_tokens_1tokensLtabletokenstokensKCREATE TABLE "tokens" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "client_id" CHAR(26) NOT NULL, "user_id" CHAR(26), "redirect_uri" VARCHAR NOT NULL, "scope" VARCHAR NOT NULL, "code" VARCHAR NOT NULL DEFAULT '', "code_challenge" VARCHAR, "code_challenge_method" VARCHAR, "code_create_at" timestamptz, "code_expires_at" timestamptz, "access" VARCHAR NOT NULL DEFAULT '', "access_create_at" timestamptz, "access_expires_at" timestamptz, "refresh" VARCHAR NOT NULL DEFAULT '', "refresh_create_at" timestamptz, "refresh_expires_at" timestamptz, PRIMARY KEY ("id", "code", "access", "refresh"), UNIQUE ("id"))=EQ+indexsqlite_autoindex_router_sessions_1router_sessionsJ.D++tablerouter_sessionsrouter_sessionsICREATE TABLE "router_sessions" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "auth" bytea NOT NULL, "crypt" bytea NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))9CM'indexsqlite_autoindex_notifications_1notificationsH ''tablenotificationsnotificationsGCREATE TABLE "notifications" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "notification_type" VARCHAR NOT NULL, "target_account_id" CHAR(26) NOT NULL, "origin_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26), "read" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"))1AEindexsqlite_autoindex_instances_3instancesF1@Eindexsqlite_autoindex_instances_2instancesE1?Eindexsqlite_autoindex_instances_1instancesD !tableinstancesinstancesCCREATE TABLE "instances" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "title" VARCHAR, "uri" VARCHAR NOT NULL, "suspended_at" timestamptz, "domain_block_id" CHAR(26), "short_description" VARCHAR, "description" VARCHAR, "terms" VARCHAR, "contact_email" VARCHAR, "contact_account_username" VARCHAR, "contact_account_id"_B''}tablenotificationsnotificati9B5B'')tablenotificationsnotificationsGCREATE TABLE "notifications" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "target_account_id" CHAR(26) NOT NULL, "origin_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26), "read" BOOLEAN NOT NULL DEFAULT false, "notification_type" SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY ("id"), UNIQUE ("id"))G>]tableinstancesinstancesCCREATE TABLE "instances" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "title" VARCHAR, "uri" VARCHAR NOT NULL, "suspended_at" timestamptz, "domain_block_id" CHAR(26), "short_description" VARCHAR, "description" VARCHAR, "terms" VARCHAR, "contact_email" VARCHAR, "contact_account_username" VARCHAR, "contact_account_id" CHAR(26), "reputation" INTEGER NOT NULL DEFAULT 0, "version" VARCHAR, "short_description_text" TEXT, "description_text" TEXT, "terms_text" TEXT, "custom_css" TEXT, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("domain"), UNIQUE ("uri")))9=indexsqlite_autoindex_users_3users=)8=indexsqlite_autoindex_users_2users< xA33/  016MGDGH1GRA8G60706QHE21EB2025-05-05 17:23:272025-05-05 17:23:27bgmcd.orgbgmcd.orghttps://bgmcd.org A 016MGDGH1GRA8G60706QHE21EB   bgmcd.org / https://bgmcd.org   wwA33LL01JTGQKKMRMJZH9KFJQV0WHPGN2025-05-05 17:23:562025-05-05 17:23:56Z9z݆gX2_-^C4\AݞLZ X-} A 01JTGQKKMRMJZH9KFJQV0WHPGN     |^MLKl*A33 OE[]ccyea01PG1Z78MWJV15N4MH23GEWA812025-05-05 17:23:272025-05-05 17:23:27bgmcd.orgbgmcd.orgnullnullhttps://bgmcd.org/users/bgmcd.orghttps://bgmcd.org/@bgmcd.orghttps://bgmcd.org/users/bgmcd.org/inboxhttps://bgmcd.org/users/bgmcd.org/outboxhttps://bgmcd.org/users/bgmcd.org/followinghttps://bgmcd.org/users/bgmcd.org/followershttps://bgmcd.org/users/bgmcd.org/collections/featured{"N":22313998837486645693515795753744069874536507691112166841086971738771060016174433109191852568240237452320138724787846584325592164421872766177188506906613403134660311373796849853923392704926654370439852100936428445888489307324549163546663349439677163779367287570329190562713265142314147131856849189057079131171724808526563098446635478872787589940736928263221817895387193152929274532516667477484817326945184502489535546274745942141697429890243847092969391596839797218837225926959225241711811330027725106977940446985466298060150825999868508950111842195837314847609349679205879958719203323299617711472963216038092788344567,"E":65537,"D":3193356349799155438294164340362934393598698531134183938882687763216713793608190917056172623670982606242436808211929339371495932223213523261300502102280041930512215395499346243800410457901751550122150431888593655400585031560751126919208318268989000398045162124023337630463520053859108380757211781805184020801330501820355374116464032397520676130209946442689962492102122817967522335762781394458380676241764734583607117806806554341569600265182866271433487304515524484965646577644786841193323889886811995977437892713710129195964769690369839362128353633143911461109275938813097697288124476776419475542715680534442829058145,"Primes":[138617402388893766059994442923076381210614650379451003494783471191918593325391641838668704862583524150869426170648650180829000248524842876332690533097440316076967582704174245601336071064199523795232419987806351219997516916368304688350514492204976522219748397384593878082932491246675578930003319642978807946023,160975450794297070947241415010845626317095144501171471815981158319346415906767439375875204995860877005276667102212106772314544091096389137104079518158187143596852889611016961428007216367086967085752362771364954078031215982128185680270133327328625197474192687941982979327835622062942860910274369666701602961329],"Precomputed":{"Dp":122876817550128680581280454729635509199851352881489937715022746828425327360706584564710902375631930597139925742463544749611071142073191432329030265655977465591824949527732468654494698391361693926850900089897462107294440472655395591341122410617637533887060487145551083315195432793317023329394736632113979090043,"Dq":51419199641848343427522647997879706750722031142522904481373110887852630889303287851054694926276021167103494958843222045129204357889616708060130928073050180265445754171186185979429987143576888917300760826033445972038779244852090254829714071048376335259849393920647446316567906865826111208869549332479841255969,"Qinv":1599104070221314900897365126850505648014300812595534554850760187258163753344608883115062518538333067111171661543698447637716195840184681394991751128133619067887223230572797616806288376663474432684117306855817889319127756280376948006403403940277278128908095925340432367157012787629030784746631576922037290595,"CRTValues":[]}}{"N":22313998837486645693515795753744069874536507691112166841086971738771060016174433109191852568240237452320138724787846584325592164421872766177188506906613403134660311373796849853923392704926654370439852100936428445888489307324549163546663349439677163779367287570329190562713265142314147131856849189057079131171724808526563098446635478872787589940736928263221817895387193152929274532516667477484817326945184502489535546274745942141697429890243847092969391596839797218837225926959225241711811330027725106977940446985466298060150825999868508950111842195837314847609349679205879958719203323299617711472963216038092788344567,"E":65537}https://bgmcd.org/users/bgmcd.org/main-key    ++ 7p _ P ' ppp;|]A%indexstatus_faves_status_id_idxstatus_favesaCREATE INDEX "status_faves_status_id_idx" ON "status_faves" ("status_id")g\5indexinstances_domain_idxinstances`CREATE INDEX "instances_domain_idx" ON "instances" ("domain")BK//3tablemedia_attachmentsmedia_attachmentsPCREATE TABLE "media_attachments" ("id" CHAR(26) NOT NULL, "created_at" t|rA%indexapplications_client_id_idxapplicationswCREATE INDEX "applications_client_id_idx" ON "applications" ("client_id")=//5tablemedia_attachmentsmedia_attachmentsPCREATE TABLK//;tablemedia_attachmentsmedia_attachmentsPCREATE TABLE "media_attachments" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "status_id" CHAR(26), "url" VARCHAR, "remote_url" VARCHAR, "original_width" INTEGER, "original_height" INTEGER, "original_size" INTEGER, "original_aspect" DOUBLE PRECISION, "small_width" INTEGER, "small_height" INTEGER, "small_size" INTEGER, "small_aspect" DOUBLE PRECISION, "focus_x" REAL, "focus_y" REAL, "account_id" CHAR(26) NOT NULL, "description" VARCHAR, "scheduled_status_id" CHAR(26), "blurhash" VARCHAR, "processing" INTEGER NOT NULL DEFAULT 2, "file_path" VARCHAR NOT NULL, "file_content_type" VARCHAR NOT NULL, "file_file_size" INTEGER NOT NULL, "thumbnail_path" VARCHAR NOT NULL, "thumbnail_content_type" VARCHAR NOT NULL, "thumbnail_file_size" INTEGER NOT NULL, "thumbnail_url" VARCHAR, "thumbnail_remote_url" VARCHAR, "avatar" BOOLEAN NOT NULL DEFAULT false, "header" BOOLEAN NOT NULL DEFAULT false, "cached" BOOLEAN NOT NULL, "original_duration" REAL, "original_framerate" REAL, "original_bitrate" INTEGER, "type" INTEGER NOT NULL DEFAULT 0, PRIMARY KEY ("id"), UNIQUE ("id")) 1indexstatuses_local_idxstatuses^CREATE INDEX "statuses_local_idx" ON "statuses" ("local") [-windexstatuses_uri_idxstatusesWCREATE INDEX "statuses_uri_idx" ON "statuses" ("uri")RS'Cindexnotifications_target_account_id_idxnotificationsVCREATE INDEX "notifications_target_account_id_idx" ON "notifications" ("target_account_id") zE-indexaccounts_usereM/7indexmedia_attachments_account_id_idxmedia_attachmentsjCREATE INDEX "media_attachments_account_id_idx" ON "media_attachments" ("account_id")dK/3indexmedia_attachments_status_id_idxmedia_attachmentsiCREATE INDEX "media_attachments_status_id_idx" ON "media_attachments" ("status_id")l^9indexmentions_status_id_idxmentionsbCREATE INDEX "mentions_status_id_idx" ON "mentions" ("status_id")w[='indexdomain_blocks_domain_idxdomain_blocks_CREATE INDEX "domain_blocks_domain_idx" ON "domain_blocks" ("domain")ALU/indexsqlite_autoindex_media_attachments_1media_attachmentsQ iq;indexstatuseZg/{indextokens_access_idxtokenslCREATE INDEX "tokens_access_idx" ON "tokens" ("access")rX=indexstatuses_boost_of_id_idxstatuses\CREATE INDEX "statuses_boost_of_id_idx" ON "statuses" ("boost_of_id"){WC#indexstatuses_in_reply_to_id_idxstatuses[CREATE INDEX "statuses_in_reply_to_id_idx" ON "statuses" ("in_reply_to_id") VM7indexstatuses_boost_of_account_id_idxstatusesZCREATE INDEX "statuses_boost_of_account_id_idx" ON "statuses" ("boost_of_account_id")p1SCindexstatuses_in_reply_to_account_id_idcp5indexusers_account_id_idxusersuCREATE INDEX "users_account_id_idx" ON "users" ("account_id")oT;indexstatuses_account_id_idxstatusesXCREATE INDEX "statuses_account_id_idx" ON "statuses" ("account_id")Aindexsqlite_autoindex_clients_1clientsO49tableclientsclientsNCREATE TABLE "clients" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "secret" VARCHAR NOT NULL, "domain" VARCHAR NOT NULL, "user_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"))+H?indexsqlite_autoindex_tokens_2tokensM           vv||z;cBCKaex72zBmCd8ya1z73hGr69VoTItKWVCXMgQA33GbUh33ejVXNMsFbs5-tvXtCDZnpWvSCOMPfuzjw1bmPcz0dNuPsSkoRUsDii88002_nsmhMTJN2Iz_venxDnRv__4      fef     r @ ; I~  ]]]wGMindexstatuses|{91indexfollows_account_id_idxfollowsfCREATE INDEX "follows_account_id_idx" ON "follows" ("account_id", updated_at DESC)?indexaccounts_suspended_at_idxaccountstCREATE INDEX "accounts_suspended_at_idx" ON "accounts" ("suspended_at")C#indexaccounts_public_key_uri_idxaccountssCREATE INDEX "acco|GMindexfollows_target_account_id_idxfollowscCREATE INDEX "follows_target_account_id_idx" ON "follows" ("target_account_id", updated_at DESC)lI7/indexadmin_account_actions_type_idxadmin_account_actionsqCREATE INDEX "admin_account_actions_type_idx" ON "admin_account_actions" ("type")v\c7cindexadmin_account_actions_target_account_id_idxadOAindexstatuses_account_id_pinned_at_idxstatusesCREATE INDEX "statuses_account_id_pinned_at_idx" ON "statuses" ("account_id", "pinned_at")E)indexreport_target_account_id_idxreportsCREATE INDEX "report_target_account_id_idx" ON "reports" ("target_account_id")j7 indexreport_account_id_idxreportsCREATE INDEX "report_account_id_idx" ON "reports" ("account_id")tablereportsreportsCREATE TABLE "reports" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "comment" VARCHAR, "statuses" VARCHAR, "rules" VARCHAR, "forwarded" BOOLEAN NOT NULL DEFAULT false, "action_taken" VARCHAR, "action_taken_at" timestamptz, "action_taken_by_account_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"))4 !!1tabletombstonestombstonesCREATE TABLE "tombstones" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "uri" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"))yI+Qindexfollow_requests_account_id_idxfollow_requestsdCREATE INDEX "follow_requests_account_id_idx" ON "follow_requests" ("account_id", updated_at DESC)~xE'indexstatuses_in_reply_to_uri_idxstatuses}CREATE INDEX "statuses_in_reply_to_uri_idx" ON "statuses" ("in_reply_to_uri") 4 A%in4G!indexsqlite_autoindex_tombstones_1tombstones rE/indexstatuses_public_timeline_idxstatuseszCREATE INDEX "statuses_public_timeline_idx" ON "statuses" ("visibility", id DESC)~A+indexstatuses_account_id_id_idxstatuses{CREATE INDEX "statuses_account_id_id_idx" ON "statuses" ("account_id", id DESC)Z-windexstatuses_url_idxstatusesCREATE INDEX "statuses_url_idx" ON "statuses" ("url")BU/indexsqlite_autoindex_account_to_emojis_1account_to_emojisK//Etableaccount_to_emojisaccount_to_emojisACREATE TABLE "account_to_emojis" ("account_id" CHAR(26) NOT NULL, "emoji_id" CHAR(26) NOT NULL, CONSTRAINT "accountemoji" UNIQUE ("account_id", "emoji_id"))|GMindexfollows_target_account_id_idxfollowscCREATE INDEX "follows_target_account_id_idx" ON "follows" ("target_account_id", updated_at DESC)|{91indexfollows_account_id_idxfollowsfCREATE INDEX "follows_account_id_idx" ON "follows" ("account_id", updated_at DESC)1zW+mindexfollow_requests_target_account_id_idxfollow_requestseCREATE INDEX "follow_requests_target_account_id_idx" ON "follow_requests" ("target_account_id", updated_at DESC)>{%indexstatus_mutes_account_id_target_account_id_statu.Aindexsqlite_autoindex_reports_2reports.Aindexsqlite_autoindex_reports_1reports4G!indexsqlite_autoindex_tombstones_2tombstones@ S-indexsqlite_autoindex_emoji_categories_2emoji_categories@ S-indexsqlite_autoindex_emoji_categories_1emoji_categories- -- tableemoji_categoriesemoji_categoriesCREATE TABLE "emoji_categories" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "name" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("name"))         | B  L O`BUtableac01tableacc w==%indexlist_entries_list_id_idxlist_entriesCREATE INDEX "list_entries_list_id_idx" ON "list_entries" ("list_id")8;K%indexsqlite_autoindex_list_entries_2list_entries8:K%indexsqlite_autoindex_list_entries_1list_entriesu9%%+tablelist_entrieslist_entriesCREATE TABLE "list_entries" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "list_id" CHAR(26) NOT NULL, "follow_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "listentrylistfollow" UNIQUE ("list_id", "follow_id"))d85indexlists_account_id_idxlistsCREATE INDEX "lists_account_id_idx" ON "lists" ("account_id"))6=indexsqlite_autoindex_lists_2listst)5=indexsqlite_autoindex_lists_1listsx;4UtablelistslistssCREATE TABLE "lists" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "title" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "replies_policy" VARCHAR NOT NULL DEFAULT 'followed', "exclusive" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "listaccounttitle" UNIQUE ("title", "account_id"))|3A%indexstatus_faves_status_id_idxstatus_favesaCREATE INDEX "status_faves_status_id_idx" ON "status_faves" ("status_id")2C%#indexstatus_faves_account_id_idxstatus_faves2CREATE INDEX "status_faves_account_id_idx" ON "status_faves" ("account_id")70K%indexsqlite_autoindex_status_faves_3status_favesU7/K%indexsqlite_autoindex_status_faves_2status_favesT7.K%indexsqlite_autoindex_status_faves_1status_favesS-%%ytablestatus_favesstatus_faves&CREATE TABLE "status_faves" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, "uri" VARCHAR NOT NULL, "pending_approval" BOOLEAN NOT NULL DEFAULT false, "approved_by_uri" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "statusfaveaccountstatus" UNIQUE ("account_id", "status_id"))e3indexaccounts_domain_idxaccountsCREATE INDEX "accounts_domain_idx" ON "accounts" ("domain")Eindexsqlite_autoindex_accounts_10accountsCindexsqlite_autoindex_accounts_9accountsCindexsqlite_autoindex_accounts_8accountseCindexsqlite_autoindex_accounts_7accounts2Cindexsqlite_autoindex_accounts_6accountsCindexsqlite_autoindex_accounts_5accountsCindexsqlite_autoindex_accounts_4accountsCindexsqlite_autoindex_accounts_3accountsfCindexsqlite_autoindex_accounts_2accounts3Cindexsqlite_autoindex_accounts_1accounts ponm   xxa21&      65         j 6< 6DDDCWindexemojis_av:JM'indexsqlite_autoindex_account_notes_2account_notes:IM'indexsqlite_autoindex_account_notes_1account_notesA%indexlist_entries_follow_id_idxlist_entriesCREATE INDEX "list_entries_follow_id_idx" ON "list_entries" ("follow_id")=%indexlist_entries_list_id_idxlist_entriesCREATE INDEX "list_entries_list_id_idx" ON "list_entries" ("list_id")8;K%indexsqlite_autoindex_list_entries_2list_entries8:K%indexsqlite_autoindex_list_entries_1list_entriesu9%%+tablelist_entrieslist_entriesCREATE TABLE "list_entries" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "list_id" CHAR(26) NOT NULL, "follow_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "listentrylistfollow" UNIQUE ("list_id", "follow_id"))d85indexlists_account_id_idxlistsCREATE INDEX "lists_account_id_idx" ON "lists" ("account_id"))6=indexsqlite_autoindex_lists_2listst)5=indexsqlite_autoindex_lists_1listsx;4UtablelistslistssCREATE TABLE "lists" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "title" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "replies_policy" VARCHAR NOT NULL DEFAULT 'followed', "exclusive" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "listaccounttitle" UNIQUE ("title", "account_id"))|3A%indexstatus_faves_status_id_idxstatus_favesaCREATE INDEX "status_faves_status_id_idx" ON "status_faves" ("status_id")2C%#indexstatus_faves_account_id_idxstatus_faves2CREATE INDEX "status_faves_account_id_idx" ON "status_faves" ("account_id")70K%indexsqlite_autoindex_status_faves_3status_favesU7/K%indexsqlite_autoindex_status_faves_2status_favesT7.K%indexsqlite_autoindex_status_faves_1status_favesS   ) V N  c9Z)V9^M'indexsqlite_auOh11Gtablethread_to_statusesthread_to_statusesCREATE TABLE "thread_to_statuses" ("thread_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, CONSTRAINT "statusthread" UNIQUE ("thread_id", "status_id")).gAindexsqlite_autoindex_threads_1threadsnf1tablethreadsthreadsCREATE TABLE "threads" ("id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"))4eG!indexsqlite_autoindex_poll_votes_2poll_votes4dG!indexsqlite_autoindex_poll_votes_1poll_votesOc!!gtablepoll_votespoll_votesCREATE TABLE "poll_votes" ("id" CHAR(26) NOT NULL, "choices" VARCHAR NOT NULL, "account_id" CHAR(26) NOT NULL, "poll_id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "in_poll_by_account" UNIQUE ("account_id", "poll_id"))*b=indexsqlite_autoindex_polls_2polls*a=indexsqlite_autoindex_polls_1pollsy`QtablepollspollsqCREATE TABLE "polls" ("id" CHAR(26) NOT NULL, "multiple" BOOLEAN NOT NULL DEFAULT false, "hide_counts" BOOLEAN NOT NULL DEFAULT false, "options" VARCHAR NOT NULL, "votes" VARCHAR NOT NULL, "voters" INTEGER NOT NULL, "status_id" CHAR(26) NOT NULL, "closed_at" timestamptz, "expires_at" TIMESTAMPTZ, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("status_id"))w_='indexdomain_allows_domain_idxdomain_allowsoCREATE INDEX "domain_allows_domain_idx" ON "domain_allows" ("domain")9^M'indexsqlite_autoindex_domain_allows_1domain_allowsn<]''7tabledomain_allowsdomain_allowsmCREATE TABLE "domain_allows" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "created_by_account_id" CHAR(26) NOT NULL, "private_comment" VARCHAR, "public_comment" VARCHAR, "obfuscate" BOOLEAN NOT NULL DEFAULT false, "subscription_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id")):WM'indexsqlite_autoindex_admin_actions_1admin_actionssV''#tableadmin_actionsadmin_actionsCREATE TABLE "admin_actions" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "completed_at" timestamptz, "target_category" INTEGER NOT NULL, "target_id" VARCHAR NOT NULL, "type" INTEGER NOT NULL, "account_id" CHAR(26) NOT NULL, "text" VARCHAR, "send_email" BOOLEAN NOT NULL DEFAULT false, "reports" VARCHAR, "errors" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"))UG/Eindexmedia_attachments_cleanup_idxmedia_attachmentskCREATE INDEX "media_attachments_cleanup_idx" ON "media_attachments" ("cached", "created_at")*T=indexsqlite_autoindex_rules_2rules*S=indexsqlite_autoindex_rules_1rulesHRmtablerulesrulesCREATE TABLE "rules" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "text" VARCHAR, "order" INTEGER NOT NULL, "deleted" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("order"))QE)'indexstatus_to_tags_status_id_idxstatus_to_tagsCREATE INDEX "status_to_tags_status_id_idx" ON "status_to_tags" ("status_id")|P?)indexstatus_to_tags_tag_id_idxstatus_to_tagsCREATE INDEX "status_to_tags_tag_id_idx" ON "status_to_tags" ("tag_id")OK)Aindexstatus_to_tags_tag_timeline_idxstatus_to_tagsCREATE INDEX "status_to_tags_tag_timeline_idx" ON "status_to_tags" ("tag_id", "status_id").MAindexsqlite_autoindex_markers_1markersbLtablemarkersmarkersCREATE TABLE "markers" ("account_id" CHAR(26) NOT NULL, "name" VARCHAR NOT NULL, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "version" INTEGER NOT NULL DEFAULT 0, "last_read_id" CHAR(26) NOT NULL, PRIMARY KEY ("account_id", "name"), CONSTRAINT "markers_account_id_timeline_uniq" UNIQUE ("account_id", "name")):JM'indexsqlite_autoindex_account_notes_2account_notes:IM'indexsqlite_autoindex_account_notes_1account_notes              'G- [ ! w ] b  N8GGGGPctablefiltersfilters>CREATE T=Q+indexsqlite_autoindex_filter_keywords_2filter_keywords~=Q+indexsqlite_autoindex_filter_keywords_1filter_keywordsv\++otablefilter_keywordsfilter_keywordsgCREATE TABLE "filter_keywords" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "filter_id" CHAR(26) NOT NULL, "keyword" VARCHAR NOT NULL, "whole_word" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "filter_keywords_filter_id_keyword_uniq" UNIQUE ("filter_id", "keyword"))Aindexsqlite_autoindex_filters_2filters`Aindexsqlite_autoindex_filters_1filtersWgtablefiltersfilters>CREATE TABLE "filters" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "expires_at" timestamptz, "account_id" CHAR(26) NOT NULL, "title" VARCHAR NOT NULL, "action" VARCHAR NOT NULL, "context_home" BOOLEAN NOT NULL DEFAULT false, "context_notifications" BOOLEAN NOT NULL DEFAULT false, "context_public" BOOLEAN NOT NULL DEFAULT false, "context_thread" BOOLEAN NOT NULL DEFAULT false, "context_account" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("title"))G[5indexsqlite_autoindex_header_filter_blocks_1header_filter_blocks%b~55gtableheader_filter_blocksheader_filter_blocksCREATE TABLE "header_filter_blocks" ("id" CHAR(26) NOT NULL, "header" VARCHAR NOT NULL, "regex" VARCHAR NOT NULL, "author_id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, PRIMARY KEY ("id"), UNIQUE ("id"))G}[5indexsqlite_autoindex_header_filter_allows_1header_filter_allowsb|55gtableheader_filter_allowsheader_filter_allowsCREATE TABLE "header_filter_allows" ("id" CHAR(26) NOT NULL, "header" VARCHAR NOT NULL, "regex" VARCHAR NOT NULL, "author_id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, PRIMARY KEY ("id"), UNIQUE ("id"))f{5indexstatuses_poll_id_idxstatuses1CREATE INDEX "statuses_poll_id_idx" ON "statuses" ("poll_id")Zv%%ytablesqlite_stat4sqlite_stat4 CREATE TABLE sqlite_stat4(tbl,idx,neq,nlt,ndlt,sample)Ku%%[tablesqlite_stat1sqlite_stat1 CREATE TABLE sqlite_stat1(tbl,idx,stat)tE''indexadmin_actions_account_id_idxadmin_actions CREATE INDEX "admin_actions_account_id_idx" ON "admin_actions" ("account_id")qs9'indexadmin_actions_type_idxadmin_actions CREATE INDEX "admin_actions_type_idx" ON "admin_actions" ("type")rC'#indexadmin_actions_target_id_idxadmin_actions CREATE INDEX "admin_actions_target_id_idx" ON "admin_actions" ("target_id")qO';indexadmin_actions_target_category_idxadmin_actionsCREATE INDEX "admin_actions_target_category_idx" ON "admin_actions" ("target_category")mp9indexstatuses_thread_id_idxstatusesCREATE INDEX "statuses_thread_id_idx" ON "statuses" ("thread_id")7lK%indexsqlite_autoindex_thread_mutes_2thread_mutesy7kK%indexsqlite_autoindex_thread_mutes_1thread_mutes6j%%Qtablethread_mutesthread_mutes5CREATE TABLE "thread_mutes" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "thread_id" CHAR(26) NOT NULL, "account_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "thread_mute_thread_id_account_id" UNIQUE ("thread_id", "account_id"))DiW1indexsqlite_autoindex_thread_to_statuses_1thread_to_statusesāOh11Gtablethread_to_statusesthread_to_statusesCREATE TABLE "thread_to_statuses" ("thread_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, CONSTRAINT "statusthread" UNIQUE ("thread_id", "status_id"))  $O https://bgmcd.org/users/bgmcd.org E https://bgmcd.org/@bgmcd.org *[ https://bgmcd.org/users/bgmcd.org/inbox +] https://bgmcd.org/users/bgmcd.org/outbox .c https://bgmcd.org/users/bgmcd.org/followers                  a C &  aQYU--[tableaccount_settingsaccount_settingsCREATE TABLE "account_settings" ("account_id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "sensitive" BOOLEAN NOT NULL DEFAULT false, "language" VARCHAR NOT NULL DEFAULT 'en', "status_content_type" VARCHAR, "theme" VARCHAR, "custom_css" VARCHAR, "enable_rss" BOOLEAN NOT NULL DEFAULT false, "hide_collections" BOOLEAN NOT NULL DEFAULT false, "interaction_policy_direct" JSONB, "interaction_policy_mutuals_only" JSONB, "interaction_policy_followers_only" JSONB, "interaction_policy_unlocked" JSONB, "interaction_policy_public" JSONB, "privacy" SMALLINT NOT NULL DEFAULT 3, "web_visibility" SMALLINT NOT NULL DEFAULT 3, "web_layout" SMALLINT NOT NULL DEFAULT 1, PRIMARY KEY ("account_id"), UNIQUE ("account_id"))''ctableaccount_statsaccount_statsCREATE TABLE "account_stats" ("account_id" CHAR(26) NOT NULL, "regenerated_at" timestamptz, "followers_count" INTEGER NOT NULL, "following_count" INTEGER NOT NULL, "follow_requests_count" INTEGER NOT NULL, "statuses_count" INTEGER NOT NULL, "statuses_pinned_count" INTEGER NOT NULL, "last_status_at" timestamptz, PRIMARY KEY ("account_id"), UNIQUE ("account_id"))8K%indexsqlite_autoindex_denied_users_1denied_users̄%%Itabledenied_usersdenied_usersCREATE TABLE "denied_users" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "email" VARCHAR NOT NULL, "username" VARCHAR NOT NULL, "sign_up_ip" BLOB, "invite_id" CHAR(26), "locale" VARCHAR, "created_by_application_id" CHAR(26), "sign_up_reason" VARCHAR, "private_comment" VARCHAR, "send_email" BOOLEAN NOT NULL DEFAULT false, "message" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"))@S-indexsqlite_autoindex_account_settings_1account_settings?qindexstatuses_account_view_idxstatusesCREATE INDEX "statuses_account_view_idx" ON "statuses" ("account_id", "in_reply_to_account_id", "in_reply_to_uri", (mentions IS NULL OR json_array_length(mentions) = 0), id DESC)CctablemovesmovesCREATE TABLE "moves" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "attempted_at" timestamptz, "succeeded_at" timestamptz, "origin_uri" VARCHAR NOT NULL, "target_uri" VARCHAR NOT NULL, "uri" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), CONSTRAINT "moveorigintarget" UNIQUE ("origin_uri", "target_uri"))*=indexsqlite_autoindex_moves_3moves*=indexsqlite_autoindex_moves_2moves*=indexsqlite_autoindex_moves_1movesŁ G++indexfilter_statuses_filter_id_idxfilter_statusesCREATE INDEX "filter_statuses_filter_id_idx" ON "filter_statuses" ("filter_id") I+/indexfilter_statuses_account_id_idxfilter_statusesCREATE INDEX "filter_statuses_account_id_idx" ON "filter_statuses" ("account_id") G++indexfilter_keywords_filter_id_idxfilter_keywordsCREATE INDEX "filter_keywords_filter_id_idx" ON "filter_keywords" ("filter_id") I+/indexfilter_keywords_account_id_idxfilter_keywordsCREATE INDEX "filter_keywords_account_id_idx" ON "filter_keywords" ("account_id")>Q+indexsqlite_autoindex_filter_statuses_2filter_statuses>Q+indexsqlite_autoindex_filter_statuses_1filter_statuses7++#tablefilter_statusesfilter_statusesCREATE TABLE "filter_statuses" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "filter_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "filter_statuses_filter_id_status_id_uniq" UNIQUE ("filter_id", "status_id"))=Q+indexsqlite_autoindex_filter_keywords_2filter_keywords~=Q+indexsqlite_autoindex_filter_keywords_1filter_keywordsv   `W>                               C AM01PG1Z78MWJV15N4MH23GEWA812025-05-10 19:03:12.472694+00:00 A 01PG1Z78MWJV15N4MH23GEWA81    > 0Gpx m  7 (O%;indexstatus_faves_pending_approval_idxstatus_favesCREATE INDEX "status_faves_pending_approval_idx" ON "status_faves" ("pending_approval")'G+indexstatuses_pending_approval_idxstatusesCREATE INDEX "statuses_pending_approval_idx" ON "statuses" ("pending_approval")k&%%tableworker_tasksworker_tasksCREATE TABLE "worker_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "worker_typ'+'' tablefollowed_tagsfollowed_tagsCREATE TABLE "followed_tags" ("account_id" CHAR(26) NOT NULL, "tag_id" CHAR(26) NOT NULL, PRIMARY KEY ("account_id", "tag_id"))F*Y3indexsqlite_autoindex_advanced_migrations_1advanced_migrations$M'7indexconversations_last_status_id_idxconversationsCREATE INDEX "conversations_last_status_id_idx" ON "conversations" ("last_status_id")"==Atableconversation_to_statusesconversation_to_statusesCREATE TABLE "conversation_to_statuses" ("conversation_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, CONSTRAINT "conversation_to_statuses_conversation_id_status_id_uniq" UNIQUE ("conversation_id", "status_id"))P#c=indexsqlite_autoindex_conversation_to_statuses_1conversation_to_statusesڅ$''tableconversationsconversationsCREATE TABLE "conversations" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "other_account_ids" VARCHAR, "other_accounts_key" VARCHAR NOT NULL, "thread_id" CHAR(26) NOT NULL, "last_status_id" CHAR(26) NOT NULL, "read" BOOLEAN DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "conversations_account_id_last_status_id_uniq" UNIQUE ("account_id", "last_status_id"), CONSTRAINT "conversations_thread_id_account_id_other_accounts_key_uniq" UNIQUE ("account_id", "other_accounts_key", "thread_id")):!M'indexsqlite_autoindex_conversations_3conversations: M'indexsqlite_autoindex_conversations_2conversations:M'indexsqlite_autoindex_conversations_1conversations  x?!indexuser_mutes_account_id_idxuser_mutesCREATE INDEX "user_mutes_account_id_idx" ON "user_mutes" ("account_id")4G!indexsqlite_autoindex_user_mutes_2user_mutes4G!indexsqlite_autoindex_user_mutes_1user_mutesуh!!tableuser_mutesuser_mutesCREATE TABLE "user_mutes" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "expires_at" timestamptz, "account_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "notifications" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "user_mutes_account_id_target_account_id_uniq" UNIQUE ("account_id", "target_account_id"))3Gindexaccounts_paging_idxaccountsCREATE INDEX "accounts_paging_idx" ON accounts (COALESCE("domain", '') || '/@' || "username"):M'indexsqlite_autoindex_account_stats_1account_stats:,M'indexsqlite_autoindex_followed_tags_1followed_tagsI)337tableadvanced_migrationsadvanced_migrationsCREATE TABLE "advanced_migrations" ("id" VARCHAR NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "state_json" BLOB, "finished" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"))(O%;indexstatus_faves_pending_approval_idxstatus_favesCREATE INDEX "status_faves_pending_approval_idx" ON "status_faves" ("pending_approval")'G+indexstatuses_pending_approval_idxstatusesCREATE INDEX "statuses_pending_approval_idx" ON "statuses" ("pending_approval")k&%%tableworker_tasksworker_tasksCREATE TABLE "worker_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "worker_type" INTEGER NOT NULL, "task_data" BLOB NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp)%E''indexconversations_account_id_idxconversationsCREATE INDEX "conversations_account_id_idx" ON "conversations" ("account_id")             jjM?? 20240611190733_add_conversations2025-05-05 17:23:56+00:002025-05-05 17:23:56+00:00{"MinID":"00000000000000000000000000","MaxIDInclusive":""} #M 20240611190733_add_conversations        h  d C&T < 3 3#:U5Gindexinteraction_requests_accepted_at_idxinteraction_requestsCREATE INDEX "interaction_requests_accepted_at_idx" ON "interaction_requests" ("accepted_at")9U-Gindexsin_bin_statuses_in_reply_to_uri_idxsin_bin_statusesCREATE INDk?9indexfilters_account_id_idxfilters>CREATE INDEX "filters_account_id_idx" ON "filters" ("account_id").>Aindexsqlite_autoindex_filters_2filters.=Aindexsqlite_autoindex_filters_1filters<tablefiltersfiltersCREATE TABLE "filters" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "expires_at" timestamptz, "account_id" CHAR(26) NOT NULL, "title" VARCHAR NOT NULL, "action" VARCHAR NOT NULL, "context_home" BOOLEAN NOT NULL DEFAULT false, "context_notifications" BOOLEAN NOT NULL DEFAULT false, "context_public" BOOLEAN NOT NULL DEFAULT false, "context_thread" BOOLEAN NOT NULL DEFAULT false, "context_account" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "filters_account_id_title_uniq" UNIQUE ("account_id", "title"))#;U5Gindexinteraction_requests_rejected_at_idxinteraction_requestsCREATE INDEX "interaction_requests_rejected_at_idx" ON "interaction_requests" ("rejected_at")#:U5Gindexinteraction_requests_accepted_at_idxinteraction_requestsCREATE INDEX "interaction_requests_accepted_at_idx" ON "interaction_requests" ("accepted_at")9U-Gindexsin_bin_statuses_in_reply_to_uri_idxsin_bin_statusesCREATE INDEX "sin_bin_statuses_in_reply_to_uri_idx" ON "sin_bin_statuses" ("in_reply_to_uri")8C-#indexsin_bin_statuses_domain_idxsin_bin_statusesCREATE INDEX "sin_bin_statuses_domain_idx" ON "sin_bin_statuses" ("domain")7M-7indexsin_bin_statuses_account_uri_idxsin_bin_statusesCREATE INDEX "sin_bin_statuses_account_uri_idx" ON "sin_bin_statuses" ("account_uri")@6S-indexsqlite_autoindex_sin_bin_statuses_2sin_bin_statuses@5S-indexsqlite_autoindex_sin_bin_statuses_1sin_bin_statuses44--tablesin_bin_statusessin_bin_statusesCREATE TABLE "sin_bin_statuses" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "url" VARCHAR, "domain" VARCHAR, "account_uri" VARCHAR NOT NULL, "in_reply_to_uri" VARCHAR, "content" VARCHAR, "attachment_links" VARCHAR, "mention_target_ur_is" VARCHAR, "emoji_links" VARCHAR, "poll_options" VARCHAR, "content_warning" VARCHAR, "sensitive" BOOLEAN NOT NULL DEFAULT false, "language" VARCHAR, "activity_streams_type" VARCHAR NOT NULL, "visibility" SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"))3Q5?indexinteraction_requests_status_id_idxinteraction_requestsCREATE INDEX "interaction_requests_status_id_idx" ON "interaction_requests" ("status_id")D2k5sindexinteraction_requests_interacting_account_id_idxinteraction_requestsCREATE INDEX "interaction_requests_interacting_account_id_idx" ON "interaction_requests" ("interacting_account_id")51a5_indexinteraction_requests_target_account_id_idxinteraction_requestsCREATE INDEX "interaction_requests_target_account_id_idx" ON "interaction_requests" ("target_account_id")H0[5indexsqlite_autoindex_interaction_requests_3interaction_requestsH/[5indexsqlite_autoindex_interaction_requests_2interaction_requestsH.[5indexsqlite_autoindex_interaction_requests_1interaction_requests~-55tableinteraction_requestsinteraction_requestsCREATE TABLE "interaction_requests" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "status_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "interacting_account_id" CHAR(26) NOT NULL, "interaction_uri" VARCHAR NOT NULL, "interaction_type" INTEGER NOT NULL, "accepted_at" timestamptz, "rejected_at" timestamptz, "uri" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("interaction_uri"), UNIQUE ("uri"))               GG p  2 >aG > >^TqKindexsqlite_autoindex_domain_permission_subscriptRKKtabledomain_permission_subscriptionsdomain_permission_subscriptionsCREATE TABLE "domain_permission_subscriptions" ("id" CHAR(26) NOT NULL, "priority" INTEGER, "title" VARCHAR, "permission_type" INTEGER NOT NULL, "as_draft" BOOLEAN NOT NULL DEFAULT true, "adopt_orphans" BOOLEAN NOT NULL DEFAULT false, "created_by_account_id" CHAR(26) NOT NULL, "uri" VARCHAR NOT NULL, "content_type" INTEGER NOT NULL, "fetch_username" VARCHAR, "fetch_passwok?9indexfilters_account_id_idxfilters>CREATE INDEX "filters_account_id_idx" ON "filters" ("account_id").>Aindexsqlite_autoindex_filters_2filters.=Aindexsqlite_autoindex_filters_1filters(QW9Kindexweb_push_subscriptions_account_id_idxweb_push_subscriptionsCREATE INDEX "web_push_subscriptions_account_id_idx" ON "web_push_subscriptions" ("account_id")LP_9indexsqlite_autoindex_web_push_subscriptions_2web_push_subscriptionsLO_9indexsqlite_autoindex_web_push_subscriptions_1web_push_subscriptions|N99tableweb_push_subscriptionsweb_push_subscriptionsCREATE TABLE "web_push_subscriptions" ("id" CHAR(26) NOT NULL, "account_id" CHAR(26) NOT NULL, "token_id" CHAR(26) NOT NULL, "endpoint" VARCHAR NOT NULL, "auth" VARCHAR NOT NULL, "p256dh" VARCHAR NOT NULL, "notification_flags" INTEGER NOT NULL, "policy" INTEGER NOT NULL DEFAULT 1, PRIMARY KEY ("id"), UNIQUE ("token_id")),M++tablevapid_key_pairsvapid_key_pairs]CREATE TABLE "vapid_key_pairs" ("id" INTEGER NOT NULL, "public" VARCHAR NOT NULL, "private" VARCHAR NOT NULL, PRIMARY KEY ("id"))oJ;indexstatuses_visibility_idxstatusesrCREATE INDEX "statuses_visibility_idx" ON "statuses" ("visibility")8IK%indexsqlite_autoindex_status_edits_1status_editsWH%%otablestatus_editsstatus_editsCREATE TABLE "status_edits" ("id" CHAR(26) NOT NULL, "content" VARCHAR, "content_warning" VARCHAR, "text" VARCHAR, "language" VARCHAR, "sensitive" BOOLEAN NOT NULL DEFAULT false, "attachments" VARCHAR, "attachment_descriptions" VARCHAR, "poll_options" VARCHAR, "poll_votes" VARCHAR, "status_id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "content_type" INTEGER, PRIMARY KEY ("id"), UNIQUE ("id"))?Ge=gindexdomain_permission_drafts_subscription_id_idxdomain_permission_draftsCREATE INDEX "domain_permission_drafts_subscription_id_idx" ON "domain_permission_drafts" ("subscription_id")$FS=Cindexdomain_permission_drafts_domain_idxdomain_permission_draftsCREATE INDEX "domain_permission_drafts_domain_idx" ON "domain_permission_drafts" ("domain")TEgAindexsqlite_autoindex_domain_permission_excludes_2domain_permission_excludesTDgAindexsqlite_autoindex_domain_permission_excludes_1domain_permission_excludesCAA3tabledomain_permission_excludesdomain_permission_excludesCREATE TABLE "domain_permission_excludes" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "domain" VARCHAR NOT NULL, "created_by_account_id" CHAR(26) NOT NULL, "private_comment" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("domain"))PBc=indexsqlite_autoindex_domain_permission_drafts_2domain_permission_draftsOAc=indexsqlite_autoindex_domain_permission_drafts_1domain_permission_drafts` @==+tabledomain_permission_draftsdomain_permission_draftsWCREATE TABLE "domain_permission_drafts" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "permission_type" INTEGER NOT NULL, "domain" VARCHAR NOT NULL, "created_by_account_id" CHAR(26) NOT NULL, "private_comment" VARCHAR, "public_comment" VARCHAR, "obfuscate" BOOLEAN NOT NULL DEFAULT false, "subscription_id" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "domain_permission_drafts_permission_type_domain_subscription_id_uniq" UNIQUE ("permission_type", "domain", "subscription_id"))                ! q} rO! ) h~: - 8gK%indexsqlite_autoindex_new_accounts_1new_accounts 'eEyindexstatuses_public_timeline_idxstatuses|CREATE INDEX "statuses_public_timeline_idx" ON "statuses" ("visibility", "boost_of_id", "pending_approval", "id" DESC)dc5indextokens_client_id_idxtokenswCREATE INDEX "tokens_client_id_idx" ON "tokens" ("client_id") b1Yindexstatuses_local_idxstatuses^CREATE INDEX "statuses_local_idx" ON "statuses" ("local", "visibility", "pending_approval", "id" DESC)+_?indexsqlite_autoindex_tokens_2tokensM+^?indexsqlite_autoindex_tokens_1tokensL\S%Cindexapplications_managed_by_user_id_idxapplicationsNCREATE INDEX "applications_managed_by_user_id_idx" ON "applications" ("managed_by_user_id")|[A%indexapplications_client_id_idxapplications,CREATE INDEX "applications_client_id_idx" ON "applications" ("client_id")) 3202402281136082025-05-05 17:23:25&=) 3202402202045262025-05-05 17:23:25&<) 3202401291707252025-05-05 17:23:25&;) 3202401260640042025-05-05 17:23:25&:) 3202401141126372025-05-05 17:23:25&9) 3202401031709452025-05-05 17:23:25&8) 3202312271108452025-05-05 17:23:25&7) 3202312151159202025-05-05 17:23:25&6) 3202312121447152025-05-05 17:23:25&5) 3202312081522422025-05-05 17:23:25&4) 3202311301036432025-05-05 17:23:25&3) 3202311281408472025-05-05 17:23:25&2) 3202311101423302025-05-05 17:23:25&1) 3202310291438192025-05-05 17:23:25&0) 3202310161132352025-05-05 17:23:25&/) 3202310021533272025-05-05 17:23:25&.) 3202309080831212025-05-05 17:23:25&-) 3202309051339042025-05-05 17:23:25&,) 3202308281013222025-05-05 17:23:25&+) 3202308210753422025-05-05 17:23:25&*) 3202308171747002025-05-05 17:23:25&)) 3202308151645002025-05-05 17:23:25&() 3202307241000002025-05-05 17:23:25&') 3202307181615202025-05-05 17:23:25&&) 3202307130259392025-05-05 17:23:25&%) 3202307112148152025-05-05 17:23:25&$) 3202306201039322025-05-05 17:23:25&#) 3202305211058502025-05-05 17:23:25&") 3202305151739192025-05-05 17:23:25&!) 3202305111814302025-05-05 17:23:24& ) 3202304301057352025-05-05 17:23:24&) 3202304051300212025-05-05 17:23:24&) 3202303282030242025-05-05 17:23:24&) 3202302211509572025-05-05 17:23:24&) 3202302022127002025-05-05 17:23:24&) 3202301261707192025-05-05 17:23:24&) 3202301051711442025-05-05 17:23:24&) 3202212201345142025-05-05 17:23:24&) 3202211081424192025-05-05 17:23:24&) 3202211032035532025-05-05 17:23:24&) 3202210311456492025-05-05 17:23:24&) 3202210111257322025-05-05 17:23:24&) 3202210061148422025-05-05 17:23:24&) 3202209261152332025-05-05 17:23:24&) 3202209221424082025-05-05 17:23:24&) 3202209161227012025-05-05 17:23:24&) 3202209051505052025-05-05 17:23:24&) 3202209031410162025-05-05 17:23:24&) 3202208300147322025-05-05 17:23:24& ) 3202208270851212025-05-05 17:23:24& ) 3202208231402282025-05-05 17:23:24& ) 3202208041201322025-05-05 17:23:24& ) 3202207101530202025-05-05 17:23:24& ) 3202206120918002025-05-05 17:23:24&) 3202205181236212025-05-05 17:23:24&) 3202205111652122025-05-05 17:23:24&) 3202205061108222025-05-05 17:23:24&) 3202205021138062025-05-05 17:23:24&) 3202203151608142025-05-05 17:23:24&) 3202203051303282025-05-05 17:23:24&) 3202202141756502025-05-05 17:23:24&) 3202111131143072025-05-05 17:23:24 `8pH &n) 3202503241735342025-05-05 17:23:26&m) 3202503211312302025-05-05 17:23:26&l) 3202503180938282025-05-05 17:23:26&k) 3202503141209452025-05-05 17:23:26&j) 3202503101441022025-05-05 17:23:26&i) 3202503100941082025-05-05 17:23:26&h) 3202503052058202025-05-05 17:23:26&g) 3202502260134422025-05-05 17:23:26&f) 3202502241056542025-05-05 17:23:26&e) 3202501311847552025-05-05 17:23:26&d) 3202501261628252025-05-05 17:23:26&c) 3202501241644002025-05-05 17:23:26&b) 3202501191127462025-05-05 17:23:26 A 01PG1Z78MWJV15N4MH23GEWA81 $O https://bgmcd.org/users/bgmcd.org -a https://bgmcd.org/users/bgmcd.org/main-key   bgmcd.org " [ r? +g 'yqAindexaccounts_followers_uri_idxaccountsCREATE INDEX "accounts_followers_uri_idx" ON "accounts" ("followers_uri")pp;indexaccounts_outbox_uri_idxaccountsCREATE INDEX "accounts_outbox_uri_idx" ON "accounts" ("outbox_uri")mo9indexaccounts_inbox_uri_idxaccountsCREATE INDEX "accounts_inbox_uri_idx" ON "accounts" ("inbox_uri")Zn-windexaccounts_url_idxaccountsCREATE INDEX "accounts_url_idx" ON "accounts" ("url")Zm-windexaccounts_uri_idxaccountsCREATE INDEX "accounts_uri_idx" ON "accounts" ("uri")dl3indexaccounts_domain_idxaccountsCREATE INDEX "accounts_domain_idx" ON "accounts" ("domain")xkAindexaccounts_following_uri_idxaccountsCREATE INDEX "accounts_following_uri_idx" ON "accounts" ("following_uri")0jCindexsqlite_autoindex_accounts_4accounts0iCindexsqlite_autoindex_accounts_3accounts0hCindexsqlite_autoindex_accounts_2accounts 0gCindexsqlite_autoindex_accounts_1accounts 8fCtableaccountsaccountsOCREATE TABLE "accounts" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "fetched_at" timestamptz, "username" VARCHAR NOT NULL, "domain" VARCHAR, "avatar_media_attachment_id" CHAR(26), "avatar_remote_url" VARCHAR, "header_media_attachment_id" CHAR(26), "header_remote_url" VARCHAR, "display_name" VARCHAR, "emojis" VARCHAR, "fields" VARCHAR, "fields_raw" VARCHAR, "note" VARCHAR, "note_raw" VARCHAR, "memorialized_at" timestamptz, "also_known_as_uris" VARCHAR, "moved_to_uri" VARCHAR, "move_id" CHAR(26), "locked" BOOLEAN NOT NULL DEFAULT true, "discoverable" BOOLEAN NOT NULL DEFAULT false, "uri" VARCHAR NOT NULL, "url" VARCHAR, "inbox_uri" VARCHAR, "shared_inbox_uri" VARCHAR, "outbox_uri" VARCHAR, "following_uri" VARCHAR, "followers_uri" VARCHAR, "featured_collection_uri" VARCHAR, "actor_type" INTEGER NOT NULL, "private_key" VARCHAR, "public_key" VARCHAR NOT NULL, "public_key_uri" VARCHAR NOT NULL, "public_key_expires_at" timestamptz, "sensitized_at" timestamptz, "silenced_at" timestamptz, "suspended_at" timestamptz, "suspension_origin" CHAR(26), PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"), UNIQUE ("public_key_uri"), CONSTRAINT "accounts_username_domain_uniq" UNIQUE ("username", "domain"))))'eEyindexstatuses_public_timeline_idxstatuses|CREATE INDEX "statuses_public_timeline_idx" ON "statuses" ("visibility", "boost_of_id", "pending_approval", "id" DESC)CdG/indexstatuses_profile_web_view_idxstatuseszCREATE INDEX "statuses_profile_web_view_idx" ON "statuses" ("account_id", "visibility", "in_reply_to_uri", "boost_of_id", "federated", "id" DESC)dc5indextokens_client_id_idxtokenswCREATE INDEX "tokens_client_id_idx" ON "tokens" ("client_id") b1Yindexstatuses_local_idxstatuses^CREATE INDEX "statuses_local_idx" ON "statuses" ("local", "visibility", "pending_approval", "id" DESC)ba??Wviewstatuses_local_count_viewstatuses_local_count_viewCREATE VIEW "statuses_local_count_view" AS SELECT COUNT(*) FROM "statuses" WHERE ("local" = TRUE) AND ("visibility" IN (2, 3, 4, 5)) AND ("pending_approval" = FALSE)