catch reverse errors

1 files changed, 1783 insertions, 0 deletions

diff --git a/scripts/cln_schema.sql b/scripts/cln_schema.sql
new file mode 100644
index 00000000..e8bfa499
--- /dev/null
+++ b/scripts/cln_schema.sql
@@ -0,0 +1,1783 @@
+--
+-- PostgreSQL database dump
+--
+
+\restrict 3gmSHpmWoAvp3M9hYnbn0eAJg2qkrJcZzqafmBmvLGVxDFS2cVhidb6yKDBdS99
+
+-- Dumped from database version 18.3 (Debian 18.3-1.pgdg13+1)
+-- Dumped by pg_dump version 18.3 (Debian 18.3-1.pgdg13+1)
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+SET default_tablespace = '';
+
+SET default_table_access_method = heap;
+
+--
+-- Name: addresses; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.addresses (
+    keyidx bigint,
+    addrtype integer
+);
+
+
+ALTER TABLE public.addresses OWNER TO lightning;
+
+--
+-- Name: blocks; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.blocks (
+    height integer,
+    hash bytea,
+    prev_hash bytea
+);
+
+
+ALTER TABLE public.blocks OWNER TO lightning;
+
+--
+-- Name: chain_moves; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.chain_moves (
+    id bigint NOT NULL,
+    account_channel_id bigint,
+    account_nonchannel_id bigint,
+    tag_bitmap bigint NOT NULL,
+    credit_or_debit bigint NOT NULL,
+    "timestamp" bigint NOT NULL,
+    utxo bytea NOT NULL,
+    spending_txid bytea,
+    peer_id bytea,
+    payment_hash bytea,
+    block_height integer NOT NULL,
+    output_sat bigint NOT NULL,
+    originating_channel_id bigint,
+    originating_nonchannel_id bigint,
+    output_count integer
+);
+
+
+ALTER TABLE public.chain_moves OWNER TO lightning;
+
+--
+-- Name: chain_moves_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.chain_moves_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.chain_moves_id_seq OWNER TO lightning;
+
+--
+-- Name: chain_moves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.chain_moves_id_seq OWNED BY public.chain_moves.id;
+
+
+--
+-- Name: channel_blockheights; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_blockheights (
+    channel_id bigint,
+    hstate integer,
+    blockheight integer
+);
+
+
+ALTER TABLE public.channel_blockheights OWNER TO lightning;
+
+--
+-- Name: channel_configs; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_configs (
+    id bigint NOT NULL,
+    dust_limit_satoshis bigint,
+    max_htlc_value_in_flight_msat bigint,
+    channel_reserve_satoshis bigint,
+    htlc_minimum_msat bigint,
+    to_self_delay integer,
+    max_accepted_htlcs integer,
+    max_dust_htlc_exposure_msat bigint DEFAULT 50000000
+);
+
+
+ALTER TABLE public.channel_configs OWNER TO lightning;
+
+--
+-- Name: channel_configs_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channel_configs_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channel_configs_id_seq OWNER TO lightning;
+
+--
+-- Name: channel_configs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channel_configs_id_seq OWNED BY public.channel_configs.id;
+
+
+--
+-- Name: channel_feerates; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_feerates (
+    channel_id bigint,
+    hstate integer,
+    feerate_per_kw integer
+);
+
+
+ALTER TABLE public.channel_feerates OWNER TO lightning;
+
+--
+-- Name: channel_funding_inflights; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_funding_inflights (
+    channel_id bigint NOT NULL,
+    funding_tx_id bytea NOT NULL,
+    funding_tx_outnum integer,
+    funding_feerate integer,
+    funding_satoshi bigint,
+    our_funding_satoshi bigint,
+    funding_psbt bytea,
+    last_tx bytea,
+    last_sig bytea,
+    funding_tx_remote_sigs_received integer,
+    lease_commit_sig bytea,
+    lease_chan_max_msat bigint,
+    lease_chan_max_ppt integer,
+    lease_expiry integer DEFAULT 0,
+    lease_blockheight_start integer DEFAULT 0,
+    lease_fee bigint DEFAULT 0,
+    lease_satoshi bigint,
+    splice_amnt bigint DEFAULT 0,
+    i_am_initiator integer DEFAULT 0,
+    force_sign_first integer DEFAULT 0,
+    remote_funding bytea,
+    locked_scid bigint DEFAULT 0,
+    i_sent_sigs integer DEFAULT 0
+);
+
+
+ALTER TABLE public.channel_funding_inflights OWNER TO lightning;
+
+--
+-- Name: channel_funding_inflights_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channel_funding_inflights_channel_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channel_funding_inflights_channel_id_seq OWNER TO lightning;
+
+--
+-- Name: channel_funding_inflights_channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channel_funding_inflights_channel_id_seq OWNED BY public.channel_funding_inflights.channel_id;
+
+
+--
+-- Name: channel_htlcs; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_htlcs (
+    id bigint NOT NULL,
+    channel_id bigint,
+    channel_htlc_id bigint,
+    direction integer,
+    origin_htlc bigint,
+    msatoshi bigint,
+    cltv_expiry integer,
+    payment_hash bytea,
+    payment_key bytea,
+    routing_onion bytea,
+    failuremsg bytea,
+    malformed_onion integer,
+    hstate integer,
+    shared_secret bytea,
+    received_time bigint,
+    partid bigint,
+    localfailmsg bytea,
+    we_filled integer,
+    groupid bigint,
+    min_commit_num bigint DEFAULT 0,
+    max_commit_num bigint,
+    fail_immediate integer DEFAULT 0,
+    fees_msat bigint DEFAULT 0,
+    updated_index bigint DEFAULT 0
+);
+
+
+ALTER TABLE public.channel_htlcs OWNER TO lightning;
+
+--
+-- Name: channel_htlcs_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channel_htlcs_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channel_htlcs_id_seq OWNER TO lightning;
+
+--
+-- Name: channel_htlcs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channel_htlcs_id_seq OWNED BY public.channel_htlcs.id;
+
+
+--
+-- Name: channel_moves; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_moves (
+    id bigint NOT NULL,
+    account_channel_id bigint,
+    account_nonchannel_id bigint,
+    tag_bitmap bigint NOT NULL,
+    credit_or_debit bigint NOT NULL,
+    "timestamp" bigint NOT NULL,
+    payment_hash bytea,
+    payment_part_id bigint,
+    payment_group_id bigint,
+    fees bigint NOT NULL
+);
+
+
+ALTER TABLE public.channel_moves OWNER TO lightning;
+
+--
+-- Name: channel_moves_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channel_moves_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channel_moves_id_seq OWNER TO lightning;
+
+--
+-- Name: channel_moves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channel_moves_id_seq OWNED BY public.channel_moves.id;
+
+
+--
+-- Name: channel_state_changes; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channel_state_changes (
+    channel_id bigint,
+    "timestamp" bigint,
+    old_state integer,
+    new_state integer,
+    cause integer,
+    message text
+);
+
+
+ALTER TABLE public.channel_state_changes OWNER TO lightning;
+
+--
+-- Name: channels; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channels (
+    id bigint NOT NULL,
+    peer_id bigint,
+    short_channel_id text,
+    channel_config_local bigint,
+    channel_config_remote bigint,
+    state integer,
+    funder integer,
+    channel_flags integer,
+    minimum_depth integer,
+    next_index_local bigint,
+    next_index_remote bigint,
+    next_htlc_id bigint,
+    funding_tx_id bytea,
+    funding_tx_outnum integer,
+    funding_satoshi bigint,
+    funding_locked_remote integer,
+    push_msatoshi bigint,
+    msatoshi_local bigint,
+    fundingkey_remote bytea,
+    revocation_basepoint_remote bytea,
+    payment_basepoint_remote bytea,
+    htlc_basepoint_remote bytea,
+    delayed_payment_basepoint_remote bytea,
+    per_commit_remote bytea,
+    old_per_commit_remote bytea,
+    local_feerate_per_kw integer,
+    remote_feerate_per_kw integer,
+    shachain_remote_id bigint,
+    shutdown_scriptpubkey_remote bytea,
+    shutdown_keyidx_local bigint,
+    last_sent_commit_state bigint,
+    last_sent_commit_id integer,
+    last_tx bytea,
+    last_sig bytea,
+    closing_fee_received integer,
+    closing_sig_received bytea,
+    first_blocknum bigint,
+    last_was_revoke integer,
+    in_payments_offered integer DEFAULT 0,
+    in_payments_fulfilled integer DEFAULT 0,
+    in_msatoshi_offered bigint DEFAULT 0,
+    in_msatoshi_fulfilled bigint DEFAULT 0,
+    out_payments_offered integer DEFAULT 0,
+    out_payments_fulfilled integer DEFAULT 0,
+    out_msatoshi_offered bigint DEFAULT 0,
+    out_msatoshi_fulfilled bigint DEFAULT 0,
+    min_possible_feerate integer,
+    max_possible_feerate integer,
+    msatoshi_to_us_min bigint,
+    msatoshi_to_us_max bigint,
+    future_per_commitment_point bytea,
+    last_sent_commit bytea,
+    feerate_base integer,
+    feerate_ppm integer,
+    remote_upfront_shutdown_script bytea,
+    remote_ann_node_sig bytea,
+    remote_ann_bitcoin_sig bytea,
+    option_static_remotekey integer DEFAULT 0,
+    shutdown_scriptpubkey_local bytea,
+    our_funding_satoshi bigint DEFAULT 0,
+    option_anchor_outputs integer DEFAULT 0,
+    full_channel_id bytea,
+    funding_psbt bytea,
+    closer integer DEFAULT 2,
+    state_change_reason integer DEFAULT 0,
+    funding_tx_remote_sigs_received integer DEFAULT 0,
+    revocation_basepoint_local bytea,
+    payment_basepoint_local bytea,
+    htlc_basepoint_local bytea,
+    delayed_payment_basepoint_local bytea,
+    funding_pubkey_local bytea,
+    shutdown_wrong_txid bytea,
+    shutdown_wrong_outnum integer,
+    local_static_remotekey_start bigint DEFAULT 0,
+    remote_static_remotekey_start bigint DEFAULT 0,
+    lease_commit_sig bytea,
+    lease_chan_max_msat integer,
+    lease_chan_max_ppt integer,
+    lease_expiry integer DEFAULT 0,
+    htlc_maximum_msat bigint DEFAULT '2100000000000000'::bigint,
+    htlc_minimum_msat bigint DEFAULT 0,
+    alias_local bigint,
+    alias_remote bigint,
+    scid bigint,
+    require_confirm_inputs_remote integer DEFAULT 0,
+    require_confirm_inputs_local integer DEFAULT 0,
+    channel_type bytea,
+    ignore_fee_limits integer DEFAULT 0,
+    remote_feerate_base integer,
+    remote_feerate_ppm integer,
+    remote_cltv_expiry_delta integer,
+    remote_htlc_maximum_msat bigint,
+    remote_htlc_minimum_msat bigint,
+    last_stable_connection bigint DEFAULT 0,
+    close_attempt_height integer DEFAULT 0,
+    old_scids bytea,
+    withheld integer DEFAULT 0
+);
+
+
+ALTER TABLE public.channels OWNER TO lightning;
+
+--
+-- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channels_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channels_id_seq OWNER TO lightning;
+
+--
+-- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channels_id_seq OWNED BY public.channels.id;
+
+
+--
+-- Name: channeltxs; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.channeltxs (
+    id bigint NOT NULL,
+    channel_id bigint,
+    type integer,
+    transaction_id bytea,
+    input_num integer,
+    blockheight integer
+);
+
+
+ALTER TABLE public.channeltxs OWNER TO lightning;
+
+--
+-- Name: channeltxs_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.channeltxs_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.channeltxs_id_seq OWNER TO lightning;
+
+--
+-- Name: channeltxs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.channeltxs_id_seq OWNED BY public.channeltxs.id;
+
+
+--
+-- Name: datastore; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.datastore (
+    key bytea NOT NULL,
+    data bytea,
+    generation bigint
+);
+
+
+ALTER TABLE public.datastore OWNER TO lightning;
+
+--
+-- Name: db_upgrades; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.db_upgrades (
+    upgrade_from integer,
+    lightning_version text
+);
+
+
+ALTER TABLE public.db_upgrades OWNER TO lightning;
+
+--
+-- Name: forwards; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.forwards (
+    in_channel_scid bigint NOT NULL,
+    in_htlc_id bigint NOT NULL,
+    out_channel_scid bigint,
+    out_htlc_id bigint,
+    in_msatoshi bigint,
+    out_msatoshi bigint,
+    state integer,
+    received_time bigint,
+    resolved_time bigint,
+    failcode integer,
+    forward_style integer,
+    rowid bigint,
+    updated_index bigint DEFAULT 0
+);
+
+
+ALTER TABLE public.forwards OWNER TO lightning;
+
+--
+-- Name: htlc_sigs; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.htlc_sigs (
+    channelid integer,
+    signature bytea,
+    inflight_tx_id bytea,
+    inflight_tx_outnum integer
+);
+
+
+ALTER TABLE public.htlc_sigs OWNER TO lightning;
+
+--
+-- Name: invoice_fallbacks; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.invoice_fallbacks (
+    scriptpubkey bytea NOT NULL,
+    invoice_id bigint
+);
+
+
+ALTER TABLE public.invoice_fallbacks OWNER TO lightning;
+
+--
+-- Name: invoicerequests; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.invoicerequests (
+    invreq_id bytea NOT NULL,
+    bolt12 text,
+    label text,
+    status integer
+);
+
+
+ALTER TABLE public.invoicerequests OWNER TO lightning;
+
+--
+-- Name: invoices; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.invoices (
+    id bigint NOT NULL,
+    state integer,
+    msatoshi bigint,
+    payment_hash bytea,
+    payment_key bytea,
+    label text,
+    expiry_time bigint,
+    pay_index bigint,
+    msatoshi_received bigint,
+    paid_timestamp bigint,
+    bolt11 text,
+    description text,
+    features bytea DEFAULT '\x'::bytea,
+    local_offer_id bytea,
+    updated_index bigint DEFAULT 0,
+    paid_txid bytea,
+    paid_outnum integer
+);
+
+
+ALTER TABLE public.invoices OWNER TO lightning;
+
+--
+-- Name: invoices_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.invoices_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.invoices_id_seq OWNER TO lightning;
+
+--
+-- Name: invoices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.invoices_id_seq OWNED BY public.invoices.id;
+
+
+--
+-- Name: local_anchors; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.local_anchors (
+    channel_id bigint NOT NULL,
+    commitment_index bigint,
+    commitment_txid bytea,
+    commitment_anchor_outnum integer,
+    commitment_fee bigint,
+    commitment_weight integer
+);
+
+
+ALTER TABLE public.local_anchors OWNER TO lightning;
+
+--
+-- Name: local_anchors_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.local_anchors_channel_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.local_anchors_channel_id_seq OWNER TO lightning;
+
+--
+-- Name: local_anchors_channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.local_anchors_channel_id_seq OWNED BY public.local_anchors.channel_id;
+
+
+--
+-- Name: move_accounts; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.move_accounts (
+    id bigint NOT NULL,
+    name text
+);
+
+
+ALTER TABLE public.move_accounts OWNER TO lightning;
+
+--
+-- Name: move_accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.move_accounts_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.move_accounts_id_seq OWNER TO lightning;
+
+--
+-- Name: move_accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.move_accounts_id_seq OWNED BY public.move_accounts.id;
+
+
+--
+-- Name: network_events; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.network_events (
+    id bigint NOT NULL,
+    peer_id bytea NOT NULL,
+    type integer NOT NULL,
+    "timestamp" bigint,
+    reason text,
+    duration_nsec bigint,
+    connect_attempted integer NOT NULL
+);
+
+
+ALTER TABLE public.network_events OWNER TO lightning;
+
+--
+-- Name: network_events_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.network_events_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.network_events_id_seq OWNER TO lightning;
+
+--
+-- Name: network_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.network_events_id_seq OWNED BY public.network_events.id;
+
+
+--
+-- Name: offers; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.offers (
+    offer_id bytea NOT NULL,
+    bolt12 text,
+    label text,
+    status integer
+);
+
+
+ALTER TABLE public.offers OWNER TO lightning;
+
+--
+-- Name: outputs; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.outputs (
+    prev_out_tx bytea NOT NULL,
+    prev_out_index integer NOT NULL,
+    value bigint,
+    type integer,
+    status integer,
+    keyindex integer,
+    channel_id bigint,
+    peer_id bytea,
+    commitment_point bytea,
+    confirmation_height integer,
+    spend_height integer,
+    scriptpubkey bytea,
+    reserved_til integer,
+    option_anchor_outputs integer DEFAULT 0,
+    csv_lock integer DEFAULT 1,
+    is_in_coinbase integer DEFAULT 0
+);
+
+
+ALTER TABLE public.outputs OWNER TO lightning;
+
+--
+-- Name: payments; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.payments (
+    id bigint CONSTRAINT payments_id_not_null1 NOT NULL,
+    "timestamp" integer,
+    status integer,
+    payment_hash bytea,
+    destination bytea,
+    msatoshi bigint,
+    payment_preimage bytea,
+    path_secrets bytea,
+    route_nodes bytea,
+    route_channels bytea,
+    failonionreply bytea,
+    faildestperm integer,
+    failindex integer,
+    failcode integer,
+    failnode bytea,
+    failupdate bytea,
+    msatoshi_sent bigint,
+    faildetail text,
+    description text,
+    faildirection integer,
+    bolt11 text,
+    total_msat bigint,
+    partid bigint,
+    groupid bigint DEFAULT 0 NOT NULL,
+    local_offer_id bytea,
+    paydescription text,
+    completed_at integer,
+    failscid bigint,
+    local_invreq_id bytea,
+    updated_index bigint DEFAULT 0
+);
+
+
+ALTER TABLE public.payments OWNER TO lightning;
+
+--
+-- Name: payments_id_seq1; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.payments_id_seq1
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.payments_id_seq1 OWNER TO lightning;
+
+--
+-- Name: payments_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.payments_id_seq1 OWNED BY public.payments.id;
+
+
+--
+-- Name: peers; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.peers (
+    id bigint NOT NULL,
+    node_id bytea,
+    address text,
+    feature_bits bytea,
+    last_known_address bytea
+);
+
+
+ALTER TABLE public.peers OWNER TO lightning;
+
+--
+-- Name: peers_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.peers_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.peers_id_seq OWNER TO lightning;
+
+--
+-- Name: peers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.peers_id_seq OWNED BY public.peers.id;
+
+
+--
+-- Name: penalty_bases; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.penalty_bases (
+    channel_id bigint NOT NULL,
+    commitnum bigint NOT NULL,
+    txid bytea,
+    outnum integer,
+    amount bigint
+);
+
+
+ALTER TABLE public.penalty_bases OWNER TO lightning;
+
+--
+-- Name: runes; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.runes (
+    id bigint NOT NULL,
+    rune text,
+    last_used_nsec bigint
+);
+
+
+ALTER TABLE public.runes OWNER TO lightning;
+
+--
+-- Name: runes_blacklist; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.runes_blacklist (
+    start_index bigint,
+    end_index bigint
+);
+
+
+ALTER TABLE public.runes_blacklist OWNER TO lightning;
+
+--
+-- Name: runes_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.runes_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.runes_id_seq OWNER TO lightning;
+
+--
+-- Name: runes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.runes_id_seq OWNED BY public.runes.id;
+
+
+--
+-- Name: shachain_known; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.shachain_known (
+    shachain_id bigint NOT NULL,
+    pos integer NOT NULL,
+    idx bigint,
+    hash bytea
+);
+
+
+ALTER TABLE public.shachain_known OWNER TO lightning;
+
+--
+-- Name: shachains; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.shachains (
+    id bigint NOT NULL,
+    min_index bigint,
+    num_valid bigint
+);
+
+
+ALTER TABLE public.shachains OWNER TO lightning;
+
+--
+-- Name: shachains_id_seq; Type: SEQUENCE; Schema: public; Owner: lightning
+--
+
+CREATE SEQUENCE public.shachains_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.shachains_id_seq OWNER TO lightning;
+
+--
+-- Name: shachains_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: lightning
+--
+
+ALTER SEQUENCE public.shachains_id_seq OWNED BY public.shachains.id;
+
+
+--
+-- Name: transaction_annotations; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.transaction_annotations (
+    txid bytea,
+    idx integer,
+    location integer,
+    type integer,
+    channel bigint
+);
+
+
+ALTER TABLE public.transaction_annotations OWNER TO lightning;
+
+--
+-- Name: transactions; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.transactions (
+    id bytea NOT NULL,
+    blockheight integer,
+    txindex integer,
+    rawtx bytea,
+    type bigint,
+    channel_id bigint
+);
+
+
+ALTER TABLE public.transactions OWNER TO lightning;
+
+--
+-- Name: utxoset; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.utxoset (
+    txid bytea NOT NULL,
+    outnum integer NOT NULL,
+    blockheight integer,
+    spendheight integer,
+    txindex integer,
+    scriptpubkey bytea,
+    satoshis bigint
+);
+
+
+ALTER TABLE public.utxoset OWNER TO lightning;
+
+--
+-- Name: vars; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.vars (
+    name character varying(32) NOT NULL,
+    val character varying(255),
+    intval integer,
+    blobval bytea
+);
+
+
+ALTER TABLE public.vars OWNER TO lightning;
+
+--
+-- Name: version; Type: TABLE; Schema: public; Owner: lightning
+--
+
+CREATE TABLE public.version (
+    version integer
+);
+
+
+ALTER TABLE public.version OWNER TO lightning;
+
+--
+-- Name: chain_moves id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves ALTER COLUMN id SET DEFAULT nextval('public.chain_moves_id_seq'::regclass);
+
+
+--
+-- Name: channel_configs id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_configs ALTER COLUMN id SET DEFAULT nextval('public.channel_configs_id_seq'::regclass);
+
+
+--
+-- Name: channel_funding_inflights channel_id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_funding_inflights ALTER COLUMN channel_id SET DEFAULT nextval('public.channel_funding_inflights_channel_id_seq'::regclass);
+
+
+--
+-- Name: channel_htlcs id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_htlcs ALTER COLUMN id SET DEFAULT nextval('public.channel_htlcs_id_seq'::regclass);
+
+
+--
+-- Name: channel_moves id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_moves ALTER COLUMN id SET DEFAULT nextval('public.channel_moves_id_seq'::regclass);
+
+
+--
+-- Name: channels id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channels ALTER COLUMN id SET DEFAULT nextval('public.channels_id_seq'::regclass);
+
+
+--
+-- Name: channeltxs id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channeltxs ALTER COLUMN id SET DEFAULT nextval('public.channeltxs_id_seq'::regclass);
+
+
+--
+-- Name: invoices id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoices ALTER COLUMN id SET DEFAULT nextval('public.invoices_id_seq'::regclass);
+
+
+--
+-- Name: local_anchors channel_id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.local_anchors ALTER COLUMN channel_id SET DEFAULT nextval('public.local_anchors_channel_id_seq'::regclass);
+
+
+--
+-- Name: move_accounts id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.move_accounts ALTER COLUMN id SET DEFAULT nextval('public.move_accounts_id_seq'::regclass);
+
+
+--
+-- Name: network_events id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.network_events ALTER COLUMN id SET DEFAULT nextval('public.network_events_id_seq'::regclass);
+
+
+--
+-- Name: payments id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.payments ALTER COLUMN id SET DEFAULT nextval('public.payments_id_seq1'::regclass);
+
+
+--
+-- Name: peers id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.peers ALTER COLUMN id SET DEFAULT nextval('public.peers_id_seq'::regclass);
+
+
+--
+-- Name: runes id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.runes ALTER COLUMN id SET DEFAULT nextval('public.runes_id_seq'::regclass);
+
+
+--
+-- Name: shachains id; Type: DEFAULT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.shachains ALTER COLUMN id SET DEFAULT nextval('public.shachains_id_seq'::regclass);
+
+
+--
+-- Name: blocks blocks_height_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.blocks
+    ADD CONSTRAINT blocks_height_key UNIQUE (height);
+
+
+--
+-- Name: chain_moves chain_moves_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves
+    ADD CONSTRAINT chain_moves_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: channel_blockheights channel_blockheights_channel_id_hstate_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_blockheights
+    ADD CONSTRAINT channel_blockheights_channel_id_hstate_key UNIQUE (channel_id, hstate);
+
+
+--
+-- Name: channel_configs channel_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_configs
+    ADD CONSTRAINT channel_configs_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: channel_feerates channel_feerates_channel_id_hstate_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_feerates
+    ADD CONSTRAINT channel_feerates_channel_id_hstate_key UNIQUE (channel_id, hstate);
+
+
+--
+-- Name: channel_funding_inflights channel_funding_inflights_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_funding_inflights
+    ADD CONSTRAINT channel_funding_inflights_pkey PRIMARY KEY (channel_id, funding_tx_id);
+
+
+--
+-- Name: channel_htlcs channel_htlcs_channel_id_channel_htlc_id_direction_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_htlcs
+    ADD CONSTRAINT channel_htlcs_channel_id_channel_htlc_id_direction_key UNIQUE (channel_id, channel_htlc_id, direction);
+
+
+--
+-- Name: channel_htlcs channel_htlcs_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_htlcs
+    ADD CONSTRAINT channel_htlcs_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: channel_moves channel_moves_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_moves
+    ADD CONSTRAINT channel_moves_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: channels channels_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channels
+    ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: channeltxs channeltxs_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channeltxs
+    ADD CONSTRAINT channeltxs_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: datastore datastore_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.datastore
+    ADD CONSTRAINT datastore_pkey PRIMARY KEY (key);
+
+
+--
+-- Name: forwards forwards_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.forwards
+    ADD CONSTRAINT forwards_pkey PRIMARY KEY (in_channel_scid, in_htlc_id);
+
+
+--
+-- Name: invoice_fallbacks invoice_fallbacks_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoice_fallbacks
+    ADD CONSTRAINT invoice_fallbacks_pkey PRIMARY KEY (scriptpubkey);
+
+
+--
+-- Name: invoicerequests invoicerequests_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoicerequests
+    ADD CONSTRAINT invoicerequests_pkey PRIMARY KEY (invreq_id);
+
+
+--
+-- Name: invoices invoices_label_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoices
+    ADD CONSTRAINT invoices_label_key UNIQUE (label);
+
+
+--
+-- Name: invoices invoices_payment_hash_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoices
+    ADD CONSTRAINT invoices_payment_hash_key UNIQUE (payment_hash);
+
+
+--
+-- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoices
+    ADD CONSTRAINT invoices_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: move_accounts move_accounts_name_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.move_accounts
+    ADD CONSTRAINT move_accounts_name_key UNIQUE (name);
+
+
+--
+-- Name: move_accounts move_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.move_accounts
+    ADD CONSTRAINT move_accounts_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: network_events network_events_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.network_events
+    ADD CONSTRAINT network_events_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: offers offers_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.offers
+    ADD CONSTRAINT offers_pkey PRIMARY KEY (offer_id);
+
+
+--
+-- Name: outputs outputs_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.outputs
+    ADD CONSTRAINT outputs_pkey PRIMARY KEY (prev_out_tx, prev_out_index);
+
+
+--
+-- Name: payments payments_payment_hash_partid_groupid_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.payments
+    ADD CONSTRAINT payments_payment_hash_partid_groupid_key UNIQUE (payment_hash, partid, groupid);
+
+
+--
+-- Name: payments payments_pkey1; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.payments
+    ADD CONSTRAINT payments_pkey1 PRIMARY KEY (id);
+
+
+--
+-- Name: peers peers_node_id_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.peers
+    ADD CONSTRAINT peers_node_id_key UNIQUE (node_id);
+
+
+--
+-- Name: peers peers_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.peers
+    ADD CONSTRAINT peers_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: penalty_bases penalty_bases_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.penalty_bases
+    ADD CONSTRAINT penalty_bases_pkey PRIMARY KEY (channel_id, commitnum);
+
+
+--
+-- Name: runes runes_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.runes
+    ADD CONSTRAINT runes_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: shachain_known shachain_known_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.shachain_known
+    ADD CONSTRAINT shachain_known_pkey PRIMARY KEY (shachain_id, pos);
+
+
+--
+-- Name: shachains shachains_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.shachains
+    ADD CONSTRAINT shachains_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: transaction_annotations transaction_annotations_txid_idx_key; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.transaction_annotations
+    ADD CONSTRAINT transaction_annotations_txid_idx_key UNIQUE (txid, idx);
+
+
+--
+-- Name: transactions transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.transactions
+    ADD CONSTRAINT transactions_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: utxoset utxoset_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.utxoset
+    ADD CONSTRAINT utxoset_pkey PRIMARY KEY (txid, outnum);
+
+
+--
+-- Name: vars vars_pkey; Type: CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.vars
+    ADD CONSTRAINT vars_pkey PRIMARY KEY (name);
+
+
+--
+-- Name: chain_moves_utxo_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX chain_moves_utxo_idx ON public.chain_moves USING btree (utxo);
+
+
+--
+-- Name: channel_htlcs_speedup_unresolved_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX channel_htlcs_speedup_unresolved_idx ON public.channel_htlcs USING btree (channel_id, direction) WHERE (hstate <> ALL (ARRAY[9, 19]));
+
+
+--
+-- Name: channel_htlcs_updated_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX channel_htlcs_updated_idx ON public.channel_htlcs USING btree (updated_index);
+
+
+--
+-- Name: channel_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX channel_idx ON public.htlc_sigs USING btree (channelid);
+
+
+--
+-- Name: channel_state_changes_channel_id; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX channel_state_changes_channel_id ON public.channel_state_changes USING btree (channel_id);
+
+
+--
+-- Name: forwards_created_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX forwards_created_idx ON public.forwards USING btree (rowid);
+
+
+--
+-- Name: forwards_updated_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX forwards_updated_idx ON public.forwards USING btree (updated_index);
+
+
+--
+-- Name: invoice_update_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX invoice_update_idx ON public.invoices USING btree (updated_index);
+
+
+--
+-- Name: invoices_pay_index; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE UNIQUE INDEX invoices_pay_index ON public.invoices USING btree (pay_index);
+
+
+--
+-- Name: local_anchors_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX local_anchors_idx ON public.local_anchors USING btree (channel_id);
+
+
+--
+-- Name: output_height_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX output_height_idx ON public.outputs USING btree (confirmation_height, spend_height);
+
+
+--
+-- Name: payments_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX payments_idx ON public.payments USING btree (payment_hash);
+
+
+--
+-- Name: payments_update_idx; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX payments_update_idx ON public.payments USING btree (updated_index);
+
+
+--
+-- Name: short_channel_id; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX short_channel_id ON public.utxoset USING btree (blockheight, txindex, outnum);
+
+
+--
+-- Name: utxoset_spend; Type: INDEX; Schema: public; Owner: lightning
+--
+
+CREATE INDEX utxoset_spend ON public.utxoset USING btree (spendheight);
+
+
+--
+-- Name: chain_moves chain_moves_account_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves
+    ADD CONSTRAINT chain_moves_account_channel_id_fkey FOREIGN KEY (account_channel_id) REFERENCES public.channels(id);
+
+
+--
+-- Name: chain_moves chain_moves_account_nonchannel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves
+    ADD CONSTRAINT chain_moves_account_nonchannel_id_fkey FOREIGN KEY (account_nonchannel_id) REFERENCES public.move_accounts(id);
+
+
+--
+-- Name: chain_moves chain_moves_originating_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves
+    ADD CONSTRAINT chain_moves_originating_channel_id_fkey FOREIGN KEY (originating_channel_id) REFERENCES public.channels(id);
+
+
+--
+-- Name: chain_moves chain_moves_originating_nonchannel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.chain_moves
+    ADD CONSTRAINT chain_moves_originating_nonchannel_id_fkey FOREIGN KEY (originating_nonchannel_id) REFERENCES public.move_accounts(id);
+
+
+--
+-- Name: channel_blockheights channel_blockheights_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_blockheights
+    ADD CONSTRAINT channel_blockheights_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channel_feerates channel_feerates_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_feerates
+    ADD CONSTRAINT channel_feerates_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channel_funding_inflights channel_funding_inflights_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_funding_inflights
+    ADD CONSTRAINT channel_funding_inflights_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channel_htlcs channel_htlcs_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_htlcs
+    ADD CONSTRAINT channel_htlcs_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channel_moves channel_moves_account_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_moves
+    ADD CONSTRAINT channel_moves_account_channel_id_fkey FOREIGN KEY (account_channel_id) REFERENCES public.channels(id);
+
+
+--
+-- Name: channel_moves channel_moves_account_nonchannel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_moves
+    ADD CONSTRAINT channel_moves_account_nonchannel_id_fkey FOREIGN KEY (account_nonchannel_id) REFERENCES public.move_accounts(id);
+
+
+--
+-- Name: channel_state_changes channel_state_changes_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channel_state_changes
+    ADD CONSTRAINT channel_state_changes_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channels channels_peer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channels
+    ADD CONSTRAINT channels_peer_id_fkey FOREIGN KEY (peer_id) REFERENCES public.peers(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channeltxs channeltxs_blockheight_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channeltxs
+    ADD CONSTRAINT channeltxs_blockheight_fkey FOREIGN KEY (blockheight) REFERENCES public.blocks(height) ON DELETE CASCADE;
+
+
+--
+-- Name: channeltxs channeltxs_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channeltxs
+    ADD CONSTRAINT channeltxs_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: channeltxs channeltxs_transaction_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.channeltxs
+    ADD CONSTRAINT channeltxs_transaction_id_fkey FOREIGN KEY (transaction_id) REFERENCES public.transactions(id) ON DELETE CASCADE;
+
+
+--
+-- Name: htlc_sigs htlc_sigs_channelid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.htlc_sigs
+    ADD CONSTRAINT htlc_sigs_channelid_fkey FOREIGN KEY (channelid) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: invoice_fallbacks invoice_fallbacks_invoice_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoice_fallbacks
+    ADD CONSTRAINT invoice_fallbacks_invoice_id_fkey FOREIGN KEY (invoice_id) REFERENCES public.invoices(id) ON DELETE CASCADE;
+
+
+--
+-- Name: invoices invoices_local_offer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.invoices
+    ADD CONSTRAINT invoices_local_offer_id_fkey FOREIGN KEY (local_offer_id) REFERENCES public.offers(offer_id);
+
+
+--
+-- Name: local_anchors local_anchors_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.local_anchors
+    ADD CONSTRAINT local_anchors_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id);
+
+
+--
+-- Name: outputs outputs_confirmation_height_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.outputs
+    ADD CONSTRAINT outputs_confirmation_height_fkey FOREIGN KEY (confirmation_height) REFERENCES public.blocks(height) ON DELETE SET NULL;
+
+
+--
+-- Name: outputs outputs_spend_height_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.outputs
+    ADD CONSTRAINT outputs_spend_height_fkey FOREIGN KEY (spend_height) REFERENCES public.blocks(height) ON DELETE SET NULL;
+
+
+--
+-- Name: payments payments_local_invreq_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.payments
+    ADD CONSTRAINT payments_local_invreq_id_fkey FOREIGN KEY (local_invreq_id) REFERENCES public.invoicerequests(invreq_id);
+
+
+--
+-- Name: payments payments_local_offer_id_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.payments
+    ADD CONSTRAINT payments_local_offer_id_fkey1 FOREIGN KEY (local_offer_id) REFERENCES public.offers(offer_id);
+
+
+--
+-- Name: penalty_bases penalty_bases_channel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.penalty_bases
+    ADD CONSTRAINT penalty_bases_channel_id_fkey FOREIGN KEY (channel_id) REFERENCES public.channels(id) ON DELETE CASCADE;
+
+
+--
+-- Name: shachain_known shachain_known_shachain_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.shachain_known
+    ADD CONSTRAINT shachain_known_shachain_id_fkey FOREIGN KEY (shachain_id) REFERENCES public.shachains(id) ON DELETE CASCADE;
+
+
+--
+-- Name: transaction_annotations transaction_annotations_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.transaction_annotations
+    ADD CONSTRAINT transaction_annotations_channel_fkey FOREIGN KEY (channel) REFERENCES public.channels(id);
+
+
+--
+-- Name: transactions transactions_blockheight_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.transactions
+    ADD CONSTRAINT transactions_blockheight_fkey FOREIGN KEY (blockheight) REFERENCES public.blocks(height) ON DELETE SET NULL;
+
+
+--
+-- Name: utxoset utxoset_blockheight_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.utxoset
+    ADD CONSTRAINT utxoset_blockheight_fkey FOREIGN KEY (blockheight) REFERENCES public.blocks(height) ON DELETE CASCADE;
+
+
+--
+-- Name: utxoset utxoset_spendheight_fkey; Type: FK CONSTRAINT; Schema: public; Owner: lightning
+--
+
+ALTER TABLE ONLY public.utxoset
+    ADD CONSTRAINT utxoset_spendheight_fkey FOREIGN KEY (spendheight) REFERENCES public.blocks(height) ON DELETE SET NULL;
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+\unrestrict 3gmSHpmWoAvp3M9hYnbn0eAJg2qkrJcZzqafmBmvLGVxDFS2cVhidb6yKDBdS99
+