diff options
Diffstat (limited to 'scripts/cln_schema.sql')
| -rw-r--r-- | scripts/cln_schema.sql | 1783 |
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 + |