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

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