path: root/scripts/cln_schema.sql

--
-- 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