github.com/0xPolygon/supernets2-node@v0.0.0-20230711153321-2fe574524eaa/db/scripts/single_db_server.sql (about)

     1  CREATE DATABASE state_db;
     2  CREATE DATABASE pool_db;
     3  CREATE DATABASE rpc_db;
     4  
     5  CREATE DATABASE prover_db;
     6  \connect prover_db;
     7  
     8  CREATE SCHEMA state;
     9  
    10  CREATE TABLE state.nodes (hash BYTEA PRIMARY KEY, data BYTEA NOT NULL);
    11  CREATE TABLE state.program (hash BYTEA PRIMARY KEY, data BYTEA NOT NULL);
    12  
    13  CREATE USER prover_user with password 'prover_pass';
    14  GRANT CONNECT ON DATABASE prover_db TO prover_user;
    15  GRANT USAGE ON SCHEMA state TO prover_user;
    16  GRANT ALL PRIVILEGES ON TABLE state.nodes TO prover_user;
    17  GRANT ALL PRIVILEGES ON TABLE state.program TO prover_user;