text: -- Schema update to query.sql must be referenced in queries located in query.sql
  -- and compiled into code with sqlc. Read README.md for details.
  
  CREATE TABLE IF NOT EXISTS ap_followers (
  		"iri" TEXT NOT NULL,
  		"inbox" TEXT NOT NULL,
  		"name" TEXT,
  		"username" TEXT NOT NULL,
  		"image" TEXT,
      "request" TEXT NOT NULL,
  		"created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  		"approved_at" TIMESTAMP,
      "disabled_at" TIMESTAMP,
  		PRIMARY KEY (iri));
  		CREATE INDEX iri_index ON ap_followers (iri);
      CREATE INDEX approved_at_index ON ap_followers (approved_at);
  
  
  CREATE TABLE IF NOT EXISTS ap_outbox (
  		"iri" TEXT NOT NULL,
  		"value" BLOB,
  		"type" TEXT NOT NULL,
  		"created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
      "live_notification" BOOLEAN DEFAULT FALSE,
  		PRIMARY KEY (iri));
  		CREATE INDEX iri ON ap_outbox (iri);
  		CREATE INDEX type ON ap_outbox (type);
      CREATE INDEX live_notification ON ap_outbox (live_notification);
  
  CREATE TABLE IF NOT EXISTS ap_accepted_activities (
      "id" INTEGER NOT NULL PRIMARY KEY,
  		"iri" TEXT NOT NULL,
      "actor" TEXT NOT NULL,
      "type" TEXT NOT NULL,
  		"timestamp" TIMESTAMP NOT NULL
  	);
  	CREATE INDEX iri_actor_index ON ap_accepted_activities (iri,actor);
  
    CREATE TABLE IF NOT EXISTS ip_bans (
      "ip_address" TEXT NOT NULL PRIMARY KEY,
      "notes" TEXT,
      "created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    );
  