lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README | LICENSE

0019_repair_missing_indexes.up.sql (317B)

      1 CREATE UNIQUE INDEX IF NOT EXISTS farm_pubkey_d_tag_idx ON farm(pubkey, d_tag);
      2 CREATE INDEX IF NOT EXISTS gcs_location_geohash_idx ON gcs_location(geohash);
      3 CREATE UNIQUE INDEX IF NOT EXISTS plot_farm_d_tag_idx ON plot(farm_id, d_tag);
      4 CREATE INDEX IF NOT EXISTS nostr_event_head_kind_idx ON nostr_event_head(kind);