Files
indexer/scripts/init-databases.sql
zeekay 84ec184f6a Add complete chain adapters for all LUX native chains
- P-Chain: Validators, delegators, staking, networks (linear chain)
- X-Chain: Assets, UTXOs, transfers (DAG)
- A-Chain: AI attestations, models, inference, providers, receipts (DAG)
- B-Chain: Cross-chain bridge transfers and proofs (DAG)
- Q-Chain: Quantum finality proofs, stamps, Corona keys (DAG)
- T-Chain: MPC/Teleport sessions, threshold signatures (DAG)
- Z-Chain: ZK privacy, shielded transfers, nullifiers (DAG)

All adapters implement dag.Adapter or chain.Adapter interfaces with:
- Complete database schemas with proper indexes
- JSON-RPC integration using correct method prefixes
- Store/query methods for chain-specific data types
- Extended statistics tracking

Includes docker-compose.yml for full stack deployment.
2025-12-12 00:07:56 +00:00

53 lines
1.7 KiB
SQL

-- LUX Indexer Database Initialization
-- Creates databases for all chain indexers
-- P-Chain (Platform)
CREATE DATABASE explorer_pchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_pchain TO blockscout;
-- X-Chain (Exchange)
CREATE DATABASE explorer_xchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_xchain TO blockscout;
-- A-Chain (AI)
CREATE DATABASE explorer_achain;
GRANT ALL PRIVILEGES ON DATABASE explorer_achain TO blockscout;
-- B-Chain (Bridge)
CREATE DATABASE explorer_bchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_bchain TO blockscout;
-- Q-Chain (Quantum)
CREATE DATABASE explorer_qchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_qchain TO blockscout;
-- T-Chain (Teleport)
CREATE DATABASE explorer_tchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_tchain TO blockscout;
-- Z-Chain (Privacy)
CREATE DATABASE explorer_zchain;
GRANT ALL PRIVILEGES ON DATABASE explorer_zchain TO blockscout;
-- Testnet databases
CREATE DATABASE explorer_pchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_pchain_test TO blockscout;
CREATE DATABASE explorer_xchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_xchain_test TO blockscout;
CREATE DATABASE explorer_achain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_achain_test TO blockscout;
CREATE DATABASE explorer_bchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_bchain_test TO blockscout;
CREATE DATABASE explorer_qchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_qchain_test TO blockscout;
CREATE DATABASE explorer_tchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_tchain_test TO blockscout;
CREATE DATABASE explorer_zchain_test;
GRANT ALL PRIVILEGES ON DATABASE explorer_zchain_test TO blockscout;