Something went wrong. Try again.
grain.social is a photo sharing platform built on atproto.
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381-- This file is auto-generated by hatk on startup. Do not edit.-- Database engine: sqlite
CREATE TABLE _cursor ( key TEXT PRIMARY KEY, value TEXT NOT NULL);
CREATE TABLE _labels ( id INTEGER PRIMARY KEY AUTOINCREMENT, src TEXT NOT NULL, uri TEXT NOT NULL, val TEXT NOT NULL, neg INTEGER DEFAULT 0, cts TEXT NOT NULL, exp TEXT);
CREATE TABLE _mutes ( did TEXT NOT NULL, subject TEXT NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY (did, subject));
CREATE TABLE _oauth_codes ( code TEXT PRIMARY KEY, request_uri TEXT NOT NULL, created_at INTEGER NOT NULL);
CREATE TABLE _oauth_dpop_jtis ( jti TEXT PRIMARY KEY, expires_at INTEGER NOT NULL);
CREATE TABLE _oauth_keys ( kid TEXT PRIMARY KEY, private_key TEXT NOT NULL, public_key TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE _oauth_refresh_tokens ( token TEXT PRIMARY KEY, client_id TEXT NOT NULL, did TEXT NOT NULL, dpop_jkt TEXT NOT NULL, scope TEXT, created_at INTEGER NOT NULL, expires_at INTEGER, revoked INTEGER NOT NULL DEFAULT 0);
CREATE TABLE _oauth_requests ( request_uri TEXT PRIMARY KEY, client_id TEXT NOT NULL, redirect_uri TEXT NOT NULL, scope TEXT, state TEXT, code_challenge TEXT NOT NULL, code_challenge_method TEXT NOT NULL DEFAULT 'S256', dpop_jkt TEXT NOT NULL, pds_request_uri TEXT, pds_auth_server TEXT, pds_endpoint TEXT, pds_code_verifier TEXT, pds_state TEXT, did TEXT, login_hint TEXT, expires_at INTEGER NOT NULL);
CREATE TABLE _oauth_sessions ( did TEXT PRIMARY KEY, pds_endpoint TEXT NOT NULL, pds_auth_server TEXT, access_token TEXT NOT NULL, refresh_token TEXT, dpop_jkt TEXT NOT NULL, token_expires_at INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE _preferences ( did TEXT NOT NULL, key TEXT NOT NULL, value TEXT NOT NULL, updated_at TEXT DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (did, key));
CREATE TABLE _push_tokens ( did TEXT NOT NULL, token TEXT NOT NULL, platform TEXT NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY (did, token));
CREATE TABLE _reports ( id INTEGER PRIMARY KEY AUTOINCREMENT, subject_uri TEXT NOT NULL, subject_did TEXT NOT NULL, label TEXT NOT NULL, reason TEXT, reported_by TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'open', resolved_by TEXT, resolved_at TEXT, created_at TEXT NOT NULL);
CREATE TABLE _repos ( did TEXT PRIMARY KEY, status TEXT NOT NULL DEFAULT 'pending', handle TEXT, backfilled_at TEXT, rev TEXT, retry_count INTEGER NOT NULL DEFAULT 0, retry_after INTEGER NOT NULL DEFAULT 0);
CREATE TABLE "app.bsky.actor.profile" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, display_name TEXT, description TEXT, avatar TEXT, banner TEXT, created_at TEXT);
CREATE TABLE "app.bsky.feed.post" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, tags TEXT, text TEXT NOT NULL, embed TEXT, langs TEXT, reply TEXT, facets TEXT, labels TEXT, created_at TEXT NOT NULL);
CREATE TABLE "app.bsky.feed.post__embed_external" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, uri TEXT, thumb TEXT, title TEXT, description TEXT);
CREATE TABLE "app.bsky.feed.post__embed_images" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, alt TEXT, image TEXT, aspect_ratio TEXT);
CREATE TABLE "app.bsky.feed.post__embed_record" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, uri TEXT, cid TEXT);
CREATE TABLE "app.bsky.feed.post__embed_recordWithMedia" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, media TEXT NOT NULL, record TEXT NOT NULL);
CREATE TABLE "app.bsky.feed.post__embed_video" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, alt TEXT, video TEXT NOT NULL, captions TEXT, aspect_ratio TEXT, presentation TEXT);
CREATE TABLE "app.bsky.feed.post__entities" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, type TEXT NOT NULL, index TEXT NOT NULL, value TEXT NOT NULL);
CREATE TABLE "app.bsky.feed.post__labels_self_labels" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, val TEXT);
CREATE TABLE "app.bsky.feed.postgate" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, post TEXT NOT NULL, created_at TEXT NOT NULL, embedding_rules TEXT, detached_embedding_uris TEXT);
CREATE TABLE "app.bsky.feed.threadgate" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, post TEXT NOT NULL, allow TEXT, created_at TEXT NOT NULL, hidden_replies TEXT);
CREATE TABLE "app.bsky.graph.follow" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, subject TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE "com.germnetwork.declaration" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, version TEXT NOT NULL, current_key BLOB NOT NULL, message_me TEXT, key_package BLOB, continuity_proofs TEXT);
CREATE TABLE "social.grain.actor.profile" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, display_name TEXT, description TEXT, avatar TEXT, created_at TEXT);
CREATE TABLE "social.grain.comment" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, text TEXT NOT NULL, facets TEXT, subject TEXT NOT NULL, focus TEXT, reply_to TEXT, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.favorite" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, created_at TEXT NOT NULL, subject TEXT NOT NULL);
CREATE TABLE "social.grain.gallery" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, title TEXT NOT NULL, description TEXT, facets TEXT, labels TEXT, location TEXT, address TEXT, updated_at TEXT, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.gallery.item" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, created_at TEXT NOT NULL, gallery TEXT NOT NULL, item TEXT NOT NULL, position INTEGER);
CREATE TABLE "social.grain.gallery__labels_self_labels" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, val TEXT);
CREATE TABLE "social.grain.graph.block" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, subject TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.graph.follow" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, subject TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.photo" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, photo TEXT NOT NULL, alt TEXT, aspect_ratio TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.photo.exif" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, photo TEXT NOT NULL, created_at TEXT NOT NULL, date_time_original TEXT, exposure_time INTEGER, f_number INTEGER, flash TEXT, focal_length_in35mm_format INTEGER, i_s_o INTEGER, lens_make TEXT, lens_model TEXT, make TEXT, model TEXT);
CREATE TABLE "social.grain.story" ( uri TEXT PRIMARY KEY, cid TEXT, did TEXT NOT NULL, indexed_at TEXT NOT NULL, media TEXT NOT NULL, aspect_ratio TEXT NOT NULL, location TEXT, address TEXT, labels TEXT, created_at TEXT NOT NULL);
CREATE TABLE "social.grain.story__labels_self_labels" ( parent_uri TEXT NOT NULL, parent_did TEXT NOT NULL, val TEXT);