text: running recipe
  recipe finished, closing ledger
  ledger closed
  --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 9.6.5
  -- Dumped by pg_dump version 9.6.5
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET idle_in_transaction_session_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  SET row_security = off;
  
  SET search_path = public, pg_catalog;
  
  DROP INDEX IF EXISTS public.signersaccount;
  DROP INDEX IF EXISTS public.sellingissuerindex;
  DROP INDEX IF EXISTS public.scpquorumsbyseq;
  DROP INDEX IF EXISTS public.scpenvsbyseq;
  DROP INDEX IF EXISTS public.priceindex;
  DROP INDEX IF EXISTS public.ledgersbyseq;
  DROP INDEX IF EXISTS public.histfeebyseq;
  DROP INDEX IF EXISTS public.histbyseq;
  DROP INDEX IF EXISTS public.buyingissuerindex;
  DROP INDEX IF EXISTS public.accountbalances;
  ALTER TABLE IF EXISTS ONLY public.txhistory DROP CONSTRAINT IF EXISTS txhistory_pkey;
  ALTER TABLE IF EXISTS ONLY public.txfeehistory DROP CONSTRAINT IF EXISTS txfeehistory_pkey;
  ALTER TABLE IF EXISTS ONLY public.trustlines DROP CONSTRAINT IF EXISTS trustlines_pkey;
  ALTER TABLE IF EXISTS ONLY public.storestate DROP CONSTRAINT IF EXISTS storestate_pkey;
  ALTER TABLE IF EXISTS ONLY public.signers DROP CONSTRAINT IF EXISTS signers_pkey;
  ALTER TABLE IF EXISTS ONLY public.scpquorums DROP CONSTRAINT IF EXISTS scpquorums_pkey;
  ALTER TABLE IF EXISTS ONLY public.pubsub DROP CONSTRAINT IF EXISTS pubsub_pkey;
  ALTER TABLE IF EXISTS ONLY public.publishqueue DROP CONSTRAINT IF EXISTS publishqueue_pkey;
  ALTER TABLE IF EXISTS ONLY public.peers DROP CONSTRAINT IF EXISTS peers_pkey;
  ALTER TABLE IF EXISTS ONLY public.offers DROP CONSTRAINT IF EXISTS offers_pkey;
  ALTER TABLE IF EXISTS ONLY public.ledgerheaders DROP CONSTRAINT IF EXISTS ledgerheaders_pkey;
  ALTER TABLE IF EXISTS ONLY public.ledgerheaders DROP CONSTRAINT IF EXISTS ledgerheaders_ledgerseq_key;
  ALTER TABLE IF EXISTS ONLY public.ban DROP CONSTRAINT IF EXISTS ban_pkey;
  ALTER TABLE IF EXISTS ONLY public.accounts DROP CONSTRAINT IF EXISTS accounts_pkey;
  ALTER TABLE IF EXISTS ONLY public.accountdata DROP CONSTRAINT IF EXISTS accountdata_pkey;
  DROP TABLE IF EXISTS public.txhistory;
  DROP TABLE IF EXISTS public.txfeehistory;
  DROP TABLE IF EXISTS public.trustlines;
  DROP TABLE IF EXISTS public.storestate;
  DROP TABLE IF EXISTS public.signers;
  DROP TABLE IF EXISTS public.scpquorums;
  DROP TABLE IF EXISTS public.scphistory;
  DROP TABLE IF EXISTS public.pubsub;
  DROP TABLE IF EXISTS public.publishqueue;
  DROP TABLE IF EXISTS public.peers;
  DROP TABLE IF EXISTS public.offers;
  DROP TABLE IF EXISTS public.ledgerheaders;
  DROP TABLE IF EXISTS public.ban;
  DROP TABLE IF EXISTS public.accounts;
  DROP TABLE IF EXISTS public.accountdata;
  DROP EXTENSION IF EXISTS plpgsql;
  DROP SCHEMA IF EXISTS public;
  --
  -- Name: public; Type: SCHEMA; Schema: -; Owner: -
  --
  
  CREATE SCHEMA public;
  
  
  --
  -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: -
  --
  
  COMMENT ON SCHEMA public IS 'standard public schema';
  
  
  --
  -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
  --
  
  CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
  
  
  --
  -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
  --
  
  COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
  
  
  SET search_path = public, pg_catalog;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: accountdata; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE accountdata (
      accountid character varying(56) NOT NULL,
      dataname character varying(64) NOT NULL,
      datavalue character varying(112) NOT NULL,
      lastmodified integer DEFAULT 0 NOT NULL
  );
  
  
  --
  -- Name: accounts; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE accounts (
      accountid character varying(56) NOT NULL,
      balance bigint NOT NULL,
      seqnum bigint NOT NULL,
      numsubentries integer NOT NULL,
      inflationdest character varying(56),
      homedomain character varying(32) NOT NULL,
      thresholds text NOT NULL,
      flags integer NOT NULL,
      lastmodified integer NOT NULL,
      CONSTRAINT accounts_balance_check CHECK ((balance >= 0)),
      CONSTRAINT accounts_numsubentries_check CHECK ((numsubentries >= 0))
  );
  
  
  --
  -- Name: ban; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE ban (
      nodeid character(56) NOT NULL
  );
  
  
  --
  -- Name: ledgerheaders; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE ledgerheaders (
      ledgerhash character(64) NOT NULL,
      prevhash character(64) NOT NULL,
      bucketlisthash character(64) NOT NULL,
      ledgerseq integer,
      closetime bigint NOT NULL,
      data text NOT NULL,
      CONSTRAINT ledgerheaders_closetime_check CHECK ((closetime >= 0)),
      CONSTRAINT ledgerheaders_ledgerseq_check CHECK ((ledgerseq >= 0))
  );
  
  
  --
  -- Name: offers; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE offers (
      sellerid character varying(56) NOT NULL,
      offerid bigint NOT NULL,
      sellingassettype integer NOT NULL,
      sellingassetcode character varying(12),
      sellingissuer character varying(56),
      buyingassettype integer NOT NULL,
      buyingassetcode character varying(12),
      buyingissuer character varying(56),
      amount bigint NOT NULL,
      pricen integer NOT NULL,
      priced integer NOT NULL,
      price double precision NOT NULL,
      flags integer NOT NULL,
      lastmodified integer NOT NULL,
      CONSTRAINT offers_amount_check CHECK ((amount >= 0)),
      CONSTRAINT offers_offerid_check CHECK ((offerid >= 0))
  );
  
  
  --
  -- Name: peers; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE peers (
      ip character varying(15) NOT NULL,
      port integer DEFAULT 0 NOT NULL,
      nextattempt timestamp without time zone NOT NULL,
      numfailures integer DEFAULT 0 NOT NULL,
      CONSTRAINT peers_numfailures_check CHECK ((numfailures >= 0)),
      CONSTRAINT peers_port_check CHECK (((port > 0) AND (port <= 65535)))
  );
  
  
  --
  -- Name: publishqueue; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE publishqueue (
      ledger integer NOT NULL,
      state text
  );
  
  
  --
  -- Name: pubsub; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE pubsub (
      resid character(32) NOT NULL,
      lastread integer
  );
  
  
  --
  -- Name: scphistory; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE scphistory (
      nodeid character(56) NOT NULL,
      ledgerseq integer NOT NULL,
      envelope text NOT NULL,
      CONSTRAINT scphistory_ledgerseq_check CHECK ((ledgerseq >= 0))
  );
  
  
  --
  -- Name: scpquorums; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE scpquorums (
      qsethash character(64) NOT NULL,
      lastledgerseq integer NOT NULL,
      qset text NOT NULL,
      CONSTRAINT scpquorums_lastledgerseq_check CHECK ((lastledgerseq >= 0))
  );
  
  
  --
  -- Name: signers; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE signers (
      accountid character varying(56) NOT NULL,
      publickey character varying(56) NOT NULL,
      weight integer NOT NULL
  );
  
  
  --
  -- Name: storestate; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE storestate (
      statename character(32) NOT NULL,
      state text
  );
  
  
  --
  -- Name: trustlines; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE trustlines (
      accountid character varying(56) NOT NULL,
      assettype integer NOT NULL,
      issuer character varying(56) NOT NULL,
      assetcode character varying(12) NOT NULL,
      tlimit bigint NOT NULL,
      balance bigint NOT NULL,
      flags integer NOT NULL,
      lastmodified integer NOT NULL,
      CONSTRAINT trustlines_balance_check CHECK ((balance >= 0)),
      CONSTRAINT trustlines_tlimit_check CHECK ((tlimit > 0))
  );
  
  
  --
  -- Name: txfeehistory; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE txfeehistory (
      txid character(64) NOT NULL,
      ledgerseq integer NOT NULL,
      txindex integer NOT NULL,
      txchanges text NOT NULL,
      CONSTRAINT txfeehistory_ledgerseq_check CHECK ((ledgerseq >= 0))
  );
  
  
  --
  -- Name: txhistory; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE txhistory (
      txid character(64) NOT NULL,
      ledgerseq integer NOT NULL,
      txindex integer NOT NULL,
      txbody text NOT NULL,
      txresult text NOT NULL,
      txmeta text NOT NULL,
      CONSTRAINT txhistory_ledgerseq_check CHECK ((ledgerseq >= 0))
  );
  
  
  --
  -- Data for Name: accountdata; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: accounts; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO accounts VALUES ('GBRPYHIL2CI3FNQ4BXLFMNDLFJUNPU2HY3ZMFSHONUCEOASW7QC7OX2H', 999999998999999900, 1, 0, NULL, '', 'AQAAAA==', 0, 2);
  INSERT INTO accounts VALUES ('GCXKG6RN4ONIEPCMNFB732A436Z5PNDSRLGWK7GBLCMQLIFO4S7EYWVU', 999999900, 8589934593, 0, NULL, '', 'AQAAAA==', 0, 3);
  
  
  --
  -- Data for Name: ban; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: ledgerheaders; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO ledgerheaders VALUES ('63d98f536ee68d1b27b5b89f23af5311b7569a24faf1403ad0b52b633b07be99', '0000000000000000000000000000000000000000000000000000000000000000', '572a2e32ff248a07b0e70fd1f6d318c1facd20b6cc08c33d5775259868125a16', 1, 0, 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABXKi4y/ySKB7DnD9H20xjB+s0gtswIwz1XdSWYaBJaFgAAAAEN4Lazp2QAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZAX14QAAAABkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
  INSERT INTO ledgerheaders VALUES ('636c66f80f6ff82f72b9d770724cc2f7e5720f4e6cc3e4d02d4388722ed645ae', '63d98f536ee68d1b27b5b89f23af5311b7569a24faf1403ad0b52b633b07be99', '1cacc9fc144882c3d024d85dbebd2676445b1fbcb3617ff0f425eeb1b53b3f53', 2, 1508958279, 'AAAACGPZj1Nu5o0bJ7W4nyOvUxG3Vpok+vFAOtC1K2M7B76ZoHUUqPO1SoXWBQWiQne6+AHcM0CVKtgN/zEmvaDE04AAAAAAWfDgRwAAAAIAAAAIAAAAAQAAAAgAAAAIAAAAAwAAJxAAAAAAEtgyinnIssW5tBeb2/tNZBp1rtCbIvdoa9kC/D9mgLwcrMn8FEiCw9Ak2F2+vSZ2RFsfvLNhf/D0Je6xtTs/UwAAAAIN4Lazp2QAAAAAAAAAAABkAAAAAAAAAAAAAAAAAAAAZAX14QAAACcQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
  INSERT INTO ledgerheaders VALUES ('8864dde81bd29ddba26fe3840e172a80ec323a5343bfa757cc4381779f6b56c5', '636c66f80f6ff82f72b9d770724cc2f7e5720f4e6cc3e4d02d4388722ed645ae', 'b5ad6ca954a8038442bcb82fdb51818da3242e51ff34cb275c860bbec88026df', 3, 1508958280, 'AAAACGNsZvgPb/gvcrnXcHJMwvflcg9ObMPk0C1DiHIu1kWuZ6nhFhoypreBud6Usl72BqBcGHP4WUIf6c+xZFR+s3UAAAAAWfDgSAAAAAAAAAAAHwHNsmRY+V05R8QcxzL6y8Pg5b8K5XPCts8of63QFDq1rWypVKgDhEK8uC/bUYGNoyQuUf80yydchgu+yIAm3wAAAAMN4Lazp2QAAAAAAAAAAADIAAAAAAAAAAAAAAAAAAAAZAX14QAAACcQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
  
  
  --
  -- Data for Name: offers; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: peers; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: publishqueue; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: pubsub; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: scphistory; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO scphistory VALUES ('GCINGCL523E6JYXFJ4K45S6QJKOVJDVGTBLY3PEHPEYRB6E4E3SE7T6R', 2, 'AAAAAJDTCX3WyeTi5U8VzsvQSp1UjqaYV428h3kxEPicJuRPAAAAAAAAAAIAAAACAAAAAQAAAEigdRSo87VKhdYFBaJCd7r4AdwzQJUq2A3/MSa9oMTTgAAAAABZ8OBHAAAAAgAAAAgAAAABAAAACAAAAAgAAAADAAAnEAAAAAAAAAABB9WaOAMcw7jjZuhinHYT57R/iSuhkFS4UvcuBuPsGXUAAABAvlbmsML18iUnP4PKYYBme51LFahTguF+FOMg+Ij5A4d62y6itXMprk4BTERVZaZJYSwAiqIcS5HCdhDwmuawAg==');
  INSERT INTO scphistory VALUES ('GCINGCL523E6JYXFJ4K45S6QJKOVJDVGTBLY3PEHPEYRB6E4E3SE7T6R', 3, 'AAAAAJDTCX3WyeTi5U8VzsvQSp1UjqaYV428h3kxEPicJuRPAAAAAAAAAAMAAAACAAAAAQAAADBnqeEWGjKmt4G53pSyXvYGoFwYc/hZQh/pz7FkVH6zdQAAAABZ8OBIAAAAAAAAAAAAAAABB9WaOAMcw7jjZuhinHYT57R/iSuhkFS4UvcuBuPsGXUAAABAKuyN3MAX4OnfqVJ1ZxjJviInkWoeUTU4vEAi1HEntqWfk6tzqa0Tk1odk7WN+wCLw9i8g/JvKJf9aTXne/lSDQ==');
  
  
  --
  -- Data for Name: scpquorums; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO scpquorums VALUES ('07d59a38031cc3b8e366e8629c7613e7b47f892ba19054b852f72e06e3ec1975', 3, 'AAAAAQAAAAEAAAAAkNMJfdbJ5OLlTxXOy9BKnVSOpphXjbyHeTEQ+Jwm5E8AAAAA');
  
  
  --
  -- Data for Name: signers; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: storestate; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO storestate VALUES ('databaseschema                  ', '5');
  INSERT INTO storestate VALUES ('forcescponnextlaunch            ', 'false');
  INSERT INTO storestate VALUES ('lastclosedledger                ', '8864dde81bd29ddba26fe3840e172a80ec323a5343bfa757cc4381779f6b56c5');
  INSERT INTO storestate VALUES ('historyarchivestate             ', '{
      "version": 1,
      "server": "v0.6.3-66-gd66575cf",
      "currentLedger": 3,
      "currentBuckets": [
          {
              "curr": "a8a9304e6c0912dbcfd8d17f5c985c447f165e61e2cc1ba33fc9bb56e03beee1",
              "next": {
                  "state": 0
              },
              "snap": "ef31a20a398ee73ce22275ea8177786bac54656f33dcc4f3fec60d55ddf163d9"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 1,
                  "output": "ef31a20a398ee73ce22275ea8177786bac54656f33dcc4f3fec60d55ddf163d9"
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          },
          {
              "curr": "0000000000000000000000000000000000000000000000000000000000000000",
              "next": {
                  "state": 0
              },
              "snap": "0000000000000000000000000000000000000000000000000000000000000000"
          }
      ]
  }');
  INSERT INTO storestate VALUES ('lastscpdata                     ', 'AAAAAgAAAACQ0wl91snk4uVPFc7L0EqdVI6mmFeNvId5MRD4nCbkTwAAAAAAAAADAAAAAwfVmjgDHMO442boYpx2E+e0f4kroZBUuFL3Lgbj7Bl1AAAAAQAAADBnqeEWGjKmt4G53pSyXvYGoFwYc/hZQh/pz7FkVH6zdQAAAABZ8OBIAAAAAAAAAAAAAAABAAAAMGep4RYaMqa3gbnelLJe9gagXBhz+FlCH+nPsWRUfrN1AAAAAFnw4EgAAAAAAAAAAAAAAEBUOspXJj+20BeruOF6cr4x3J/zG2+gEQHINlPwkCYb4oPVbB++3p9hIe/Qq0URnZQH2xrC1uKUYAHymx/nGN8PAAAAAJDTCX3WyeTi5U8VzsvQSp1UjqaYV428h3kxEPicJuRPAAAAAAAAAAMAAAACAAAAAQAAADBnqeEWGjKmt4G53pSyXvYGoFwYc/hZQh/pz7FkVH6zdQAAAABZ8OBIAAAAAAAAAAAAAAABB9WaOAMcw7jjZuhinHYT57R/iSuhkFS4UvcuBuPsGXUAAABAKuyN3MAX4OnfqVJ1ZxjJviInkWoeUTU4vEAi1HEntqWfk6tzqa0Tk1odk7WN+wCLw9i8g/JvKJf9aTXne/lSDQAAAAFjbGb4D2/4L3K513ByTML35XIPTmzD5NAtQ4hyLtZFrgAAAAEAAAAArqN6LeOagjxMaUP96Bzfs9e0corNZXzBWJkFoK7kvkwAAABkAAAAAgAAAAEAAAAAAAAAAAAAAAEAAAAAAAAAAQAAAACuo3ot45qCPExpQ/3oHN+z17Ryis1lfMFYmQWgruS+TAAAAAAAAAAAAvrwgAAAAAAAAAABruS+TAAAAECxaubprwZCyJVYV7eWzAQjzwKrnqKPbO2UeeoiJHBaE0FHVgxceU3By4gJfMn7ZK7HotCmOktpu7ANRaEdYhkAAAAAAQAAAAEAAAABAAAAAJDTCX3WyeTi5U8VzsvQSp1UjqaYV428h3kxEPicJuRPAAAAAA==');
  
  
  --
  -- Data for Name: trustlines; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  
  
  --
  -- Data for Name: txfeehistory; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO txfeehistory VALUES ('2374e99349b9ef7dba9a5db3339b78fda8f34777b1af33ba468ad5c0df946d4d', 2, 1, 'AAAAAgAAAAMAAAABAAAAAAAAAABi/B0L0JGythwN1lY0aypo19NHxvLCyO5tBEcCVvwF9w3gtrOnZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAEAAAACAAAAAAAAAABi/B0L0JGythwN1lY0aypo19NHxvLCyO5tBEcCVvwF9w3gtrOnY/+cAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAA==');
  INSERT INTO txfeehistory VALUES ('f5971def3ff08c05ce222e7d71bf43703bb98ea1f776ea73085265d35dfd42ab', 3, 1, 'AAAAAgAAAAMAAAACAAAAAAAAAACuo3ot45qCPExpQ/3oHN+z17Ryis1lfMFYmQWgruS+TAAAAAA7msoAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAEAAAADAAAAAAAAAACuo3ot45qCPExpQ/3oHN+z17Ryis1lfMFYmQWgruS+TAAAAAA7msmcAAAAAgAAAAEAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAA==');
  
  
  --
  -- Data for Name: txhistory; Type: TABLE DATA; Schema: public; Owner: -
  --
  
  INSERT INTO txhistory VALUES ('2374e99349b9ef7dba9a5db3339b78fda8f34777b1af33ba468ad5c0df946d4d', 2, 1, 'AAAAAGL8HQvQkbK2HA3WVjRrKmjX00fG8sLI7m0ERwJW/AX3AAAAZAAAAAAAAAABAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAArqN6LeOagjxMaUP96Bzfs9e0corNZXzBWJkFoK7kvkwAAAAAO5rKAAAAAAAAAAABVvwF9wAAAECDzqvkQBQoNAJifPRXDoLhvtycT3lFPCQ51gkdsFHaBNWw05S/VhW0Xgkr0CBPE4NaFV2Kmcs3ZwLmib4TRrML', 'I3Tpk0m57326ml2zM5t4/ajzR3exrzO6RorVwN+UbU0AAAAAAAAAZAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAA==', 'AAAAAAAAAAEAAAACAAAAAAAAAAIAAAAAAAAAAK6jei3jmoI8TGlD/egc37PXtHKKzWV8wViZBaCu5L5MAAAAADuaygAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAIAAAAAAAAAAGL8HQvQkbK2HA3WVjRrKmjX00fG8sLI7m0ERwJW/AX3DeC2s2vJNZwAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAA');
  INSERT INTO txhistory VALUES ('f5971def3ff08c05ce222e7d71bf43703bb98ea1f776ea73085265d35dfd42ab', 3, 1, 'AAAAAK6jei3jmoI8TGlD/egc37PXtHKKzWV8wViZBaCu5L5MAAAAZAAAAAIAAAABAAAAAAAAAAAAAAABAAAAAAAAAAEAAAAArqN6LeOagjxMaUP96Bzfs9e0corNZXzBWJkFoK7kvkwAAAAAAAAAAAL68IAAAAAAAAAAAa7kvkwAAABAsWrm6a8GQsiVWFe3lswEI88Cq56ij2ztlHnqIiRwWhNBR1YMXHlNwcuICXzJ+2Sux6LQpjpLabuwDUWhHWIZAA==', '9Zcd7z/wjAXOIi59cb9DcDu5jqH3dupzCFJl0139QqsAAAAAAAAAZAAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAA==', 'AAAAAAAAAAEAAAAA');
  
  
  --
  -- Name: accountdata accountdata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY accountdata
      ADD CONSTRAINT accountdata_pkey PRIMARY KEY (accountid, dataname);
  
  
  --
  -- Name: accounts accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY accounts
      ADD CONSTRAINT accounts_pkey PRIMARY KEY (accountid);
  
  
  --
  -- Name: ban ban_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY ban
      ADD CONSTRAINT ban_pkey PRIMARY KEY (nodeid);
  
  
  --
  -- Name: ledgerheaders ledgerheaders_ledgerseq_key; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY ledgerheaders
      ADD CONSTRAINT ledgerheaders_ledgerseq_key UNIQUE (ledgerseq);
  
  
  --
  -- Name: ledgerheaders ledgerheaders_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY ledgerheaders
      ADD CONSTRAINT ledgerheaders_pkey PRIMARY KEY (ledgerhash);
  
  
  --
  -- Name: offers offers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY offers
      ADD CONSTRAINT offers_pkey PRIMARY KEY (offerid);
  
  
  --
  -- Name: peers peers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY peers
      ADD CONSTRAINT peers_pkey PRIMARY KEY (ip, port);
  
  
  --
  -- Name: publishqueue publishqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY publishqueue
      ADD CONSTRAINT publishqueue_pkey PRIMARY KEY (ledger);
  
  
  --
  -- Name: pubsub pubsub_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY pubsub
      ADD CONSTRAINT pubsub_pkey PRIMARY KEY (resid);
  
  
  --
  -- Name: scpquorums scpquorums_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY scpquorums
      ADD CONSTRAINT scpquorums_pkey PRIMARY KEY (qsethash);
  
  
  --
  -- Name: signers signers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY signers
      ADD CONSTRAINT signers_pkey PRIMARY KEY (accountid, publickey);
  
  
  --
  -- Name: storestate storestate_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY storestate
      ADD CONSTRAINT storestate_pkey PRIMARY KEY (statename);
  
  
  --
  -- Name: trustlines trustlines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY trustlines
      ADD CONSTRAINT trustlines_pkey PRIMARY KEY (accountid, issuer, assetcode);
  
  
  --
  -- Name: txfeehistory txfeehistory_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY txfeehistory
      ADD CONSTRAINT txfeehistory_pkey PRIMARY KEY (ledgerseq, txindex);
  
  
  --
  -- Name: txhistory txhistory_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY txhistory
      ADD CONSTRAINT txhistory_pkey PRIMARY KEY (ledgerseq, txindex);
  
  
  --
  -- Name: accountbalances; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX accountbalances ON accounts USING btree (balance) WHERE (balance >= 1000000000);
  
  
  --
  -- Name: buyingissuerindex; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX buyingissuerindex ON offers USING btree (buyingissuer);
  
  
  --
  -- Name: histbyseq; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX histbyseq ON txhistory USING btree (ledgerseq);
  
  
  --
  -- Name: histfeebyseq; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX histfeebyseq ON txfeehistory USING btree (ledgerseq);
  
  
  --
  -- Name: ledgersbyseq; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX ledgersbyseq ON ledgerheaders USING btree (ledgerseq);
  
  
  --
  -- Name: priceindex; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX priceindex ON offers USING btree (price);
  
  
  --
  -- Name: scpenvsbyseq; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX scpenvsbyseq ON scphistory USING btree (ledgerseq);
  
  
  --
  -- Name: scpquorumsbyseq; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX scpquorumsbyseq ON scpquorums USING btree (lastledgerseq);
  
  
  --
  -- Name: sellingissuerindex; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX sellingissuerindex ON offers USING btree (sellingissuer);
  
  
  --
  -- Name: signersaccount; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX signersaccount ON signers USING btree (accountid);
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  