github.com/status-im/status-go@v1.1.0/appdatabase/migrationsprevnodecfg/sql/1640111208_nodeconfig.up.sql (about)

     1  CREATE TABLE node_config (
     2    network_id UNSIGNED INT NOT NULL,
     3    data_dir VARCHAR NOT NULL,
     4    keystore_dir VARCHAR NOT NULL,
     5    node_key VARCHAR NOT NULL DEFAULT "",
     6    no_discovery BOOLEAN DEFAULT false,
     7    rendezvous BOOLEAN DEFAULT false,
     8    listen_addr VARCHAR NOT NULL DEFAULT "",
     9    advertise_addr VARCHAR NOT NULL DEFAULT "",
    10    name VARCHAR NOT NULL DEFAULT "",
    11    version VARCHAR NOT NULL DEFAULT "",
    12    api_modules VARCHAR NOT NULL DEFAULT "",
    13    tls_enabled BOOLEAN DEFAULT false,
    14    max_peers UNSIGNED INT,
    15    max_pending_peers UNSIGNED INT,
    16    enable_status_service BOOLEAN DEFAULT false,
    17    enable_ntp_sync BOOLEAN DEFAULT false,
    18    waku_enabled BOOLEAN DEFAULT false,
    19    waku2_enabled BOOOLEAN DEFAULT false,
    20    bridge_enabled BOOLEAN DEFAULT false,
    21    wallet_enabled BOOLEAN DEFAULT false,
    22    local_notifications_enabled BOOLEAN DEFAULT false,
    23    browser_enabled BOOLEAN DEFAULT false,
    24    permissions_enabled BOOLEAN DEFAULT false,
    25    mailservers_enabled BOOLEAN DEFAULT false,
    26    swarm_enabled BOOLEAN DEFAULT false,
    27    mailserver_registry_address VARCHAR NOT NULL DEFAULT "",
    28    web3provider_enabled BOOLEAN DEFAULT false,
    29    ens_enabled BOOLEAN DEFAULT false,
    30    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
    31  ) WITHOUT ROWID;
    32  
    33  CREATE TABLE http_config (
    34    enabled BOOLEAN DEFAULT false,
    35    host VARCHAR NOT NULL DEFAULT "",
    36    port UNSIGNED INT,
    37    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
    38  ) WITHOUT ROWID;
    39  
    40  CREATE TABLE http_virtual_hosts (
    41    host VARCHAR NOT NULL,
    42    synthetic_id VARCHAR DEFAULT 'id',
    43    PRIMARY KEY(host, synthetic_id)
    44  ) WITHOUT ROWID;
    45  
    46  CREATE TABLE http_cors (
    47    cors VARCHAR NOT NULL,
    48    synthetic_id VARCHAR DEFAULT 'id',
    49    PRIMARY KEY(cors, synthetic_id)
    50  ) WITHOUT ROWID;
    51  
    52  CREATE TABLE ipc_config (  
    53    enabled BOOLEAN DEFAULT false,
    54    file VARCHAR NOT NULL DEFAULT "",
    55    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
    56  ) WITHOUT ROWID;
    57  
    58  CREATE TABLE log_config (
    59    enabled BOOLEAN DEFAULT false,
    60    mobile_system BOOLEAN DEFAULT false,
    61    log_dir VARCHAR NOT NULL DEFAULT "",
    62    file VARCHAR NOT NULL DEFAULT "",
    63    log_level VARCHAR NOT NULL DEFAULT "INFO",
    64    max_backups UNSIGNED INT,
    65    max_size UNSIGNED INT,
    66    compress_rotated BOOLEAN DEFAULT false,
    67    log_to_stderr BOOLEAN DEFAULT false,
    68    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
    69  ) WITHOUT ROWID;
    70    
    71  CREATE TABLE upstream_config (
    72    enabled BOOLEAN DEFAULT false,
    73    url VARCHAR NOT NULL DEFAULT "",
    74    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
    75  ) WITHOUT ROWID;
    76  
    77  CREATE TABLE network_config (
    78    chain_id  UNSIGNED INT,
    79    chain_name VARCHAR NOT NULL DEFAULT "",
    80    rpc_url VARCHAR NOT NULL DEFAULT "",
    81    block_explorer_url VARCHAR NOT NULL DEFAULT "",
    82    icon_url VARCHAR NOT NULL DEFAULT "",
    83    native_currency_name VARCHAR NOT NULL DEFAULT "",
    84    native_currency_symbol VARCHAR NOT NULL DEFAULT "",
    85    native_currency_decimals UNSIGNED INT,
    86    is_test BOOLEAN DEFAULT false,
    87    layer UNSIGNED INT,
    88    enabled BOOLEAN DEFAULT false,
    89    synthetic_id VARCHAR DEFAULT 'id',
    90    PRIMARY KEY (chain_id, synthetic_id)
    91  ) WITHOUT ROWID;
    92  
    93  CREATE TABLE cluster_config (
    94    enabled BOOLEAN DEFAULT false,
    95    fleet VARCHAR NOT NULL DEFAULT "",
    96    synthetic_id VARCHAR DEFAULT 'id',
    97    PRIMARY KEY (synthetic_id)
    98  ) WITHOUT ROWID;
    99  
   100  CREATE TABLE cluster_nodes (
   101    node VARCHAR NOT NULL,
   102    type  VARCHAR NOT NULL,
   103    synthetic_id VARCHAR DEFAULT 'id',
   104    PRIMARY KEY (node, type, synthetic_id)
   105  ) WITHOUT ROWID;
   106  
   107  CREATE TABLE light_eth_config (
   108    enabled BOOLEAN DEFAULT false,
   109    database_cache UNSIGNED INT,
   110    min_trusted_fraction UNSIGNED INT,
   111    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   112  ) WITHOUT ROWID;
   113  
   114  CREATE TABLE light_eth_trusted_nodes (
   115     node VARCHAR NOT NULL,
   116     synthetic_id VARCHAR DEFAULT 'id',
   117     PRIMARY KEY (node, synthetic_id)
   118  ) WITHOUT ROWID;
   119  
   120  CREATE TABLE register_topics (
   121    topic VARCHAR NOT NULL,
   122    synthetic_id VARCHAR DEFAULT 'id',
   123    PRIMARY KEY (topic, synthetic_id)
   124  ) WITHOUT ROWID;
   125  
   126  CREATE TABLE require_topics (
   127    topic VARCHAR NOT NULL,
   128    min UNSIGNED INT NOT NULL DEFAULT 0,
   129    max UNSIGNED INT NOT NULL DEFAULT 0,
   130    synthetic_id VARCHAR DEFAULT 'id',
   131    PRIMARY KEY (topic, synthetic_id)
   132  ) WITHOUT ROWID;
   133     
   134  CREATE TABLE push_notifications_server_config (
   135    enabled BOOLEAN DEFAULT false,
   136    identity VARCHAR NOT NULL DEFAULT "",
   137    gorush_url VARCHAR NOT NULL DEFAULT "",
   138    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   139  ) WITHOUT ROWID;
   140    
   141  CREATE TABLE waku_config (
   142    enabled BOOLEAN DEFAULT false,
   143    light_client BOOLEAN DEFAULT false,
   144    full_node BOOLEAN DEFAULT false,
   145    enable_mailserver BOOLEAN DEFAULT false,
   146    data_dir VARCHAR NOT NULL DEFAULT "",
   147    minimum_pow REAL,
   148    mailserver_password VARCHAR NOT NULL DEFAULT "",
   149    mailserver_rate_limit UNSIGNED INT,
   150    mailserver_data_retention UNSIGNED INT,
   151    ttl UNSIGNED INT,
   152    max_message_size UNSIGNED INT,
   153    enable_rate_limiter BOOLEAN DEFAULT false,
   154    packet_rate_limit_ip UNSIGNED INT,
   155    packet_rate_limit_peer_id UNSIGNED INT,
   156    bytes_rate_limit_ip UNSIGNED INT,
   157    bytes_rate_limit_peer_id UNSIGNED INT,
   158    rate_limit_tolerance UNSIGNED INT,
   159    bloom_filter_mode BOOLEAN DEFAULT false,
   160    enable_confirmations BOOLEAN DEFAULT false,
   161    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   162  ) WITHOUT ROWID;
   163  
   164  CREATE TABLE waku_config_db_pg (
   165    enabled BOOLEAN DEFAULT false,
   166    uri VARCHAR NOT NULL DEFAULT "",
   167    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   168  ) WITHOUT ROWID;
   169  
   170  CREATE TABLE waku_softblacklisted_peers (
   171    peer_id VARCHAR NOT NULL,
   172    synthetic_id VARCHAR DEFAULT 'id',
   173    PRIMARY KEY (peer_id, synthetic_id)
   174  ) WITHOUT ROWID;
   175       
   176  CREATE TABLE wakuv2_config (
   177    enabled BOOLEAN DEFAULT false,
   178    host VARCHAR NOT NULL DEFAULT "",
   179    port UNSIGNED INT,
   180    keep_alive_interval UNSIGNED INT,
   181    light_client BOOLEAN DEFAULT false,
   182    full_node BOOLEAN DEFAULT false,
   183    discovery_limit UNSIGNED INT,
   184    persist_peers BOOLEAN DEFAULT false,
   185    data_dir VARCHAR NOT NULL DEFAULT "",
   186    max_message_size UNSIGNED INT,
   187    enable_confirmations BOOLEAN DEFAULT false,
   188    peer_exchange BOOLEAN DEFAULT true,
   189    enable_discv5 BOOLEAN DEFAULT false,
   190    udp_port UNSIGNED INT,
   191    auto_update BOOLEAN default false,
   192    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   193  ) WITHOUT ROWID;
   194  
   195  CREATE TABLE wakuv2_custom_nodes (
   196    name VARCHAR NOT NULL,
   197    multiaddress VARCHAR NOT NULL,
   198    synthetic_id VARCHAR DEFAULT 'id',
   199    PRIMARY KEY(name, synthetic_id)
   200  ) WITHOUT ROWID;
   201  
   202  CREATE TABLE shhext_config (
   203    pfs_enabled BOOLEAN DEFAULT false,
   204    backup_disabled_data_dir VARCHAR NOT NULL DEFAULT "",
   205    installation_id VARCHAR NOT NULL DEFAULT "",
   206    mailserver_confirmations BOOLEAN DEFAULT false,
   207    enable_connection_manager BOOLEAN DEFAULT false,
   208    enable_last_used_monitor BOOLEAN DEFAULT false,
   209    connection_target UNSIGNED INT,
   210    request_delay UNSIGNED BIGINT,
   211    max_server_failures UNSIGNED INT,
   212    max_message_delivery_attempts UNSIGNED INT,
   213    whisper_cache_dir VARCHAR NOT NULL DEFAULT "",
   214    disable_generic_discovery_topic BOOLEAN DEFAULT false,
   215    send_v1_messages BOOLEAN DEFAULT false,
   216    data_sync_enabled BOOLEAN DEFAULT false,
   217    verify_transaction_url VARCHAR NOT NULL DEFAULT "",
   218    verify_ens_url VARCHAR NOT NULL DEFAULT "",
   219    verify_ens_contract_address VARCHAR NOT NULL DEFAULT "",
   220    verify_transaction_chain_id UNSIGNED INT,
   221    anon_metrics_server_enabled BOOLEAN DEFAULT false,
   222    anon_metrics_send_id VARCHAR NOT NULL DEFAULT "",
   223    anon_metrics_server_postgres_uri VARCHAR NOT NULL DEFAULT "",
   224    bandwidth_stats_enabled BOOLEAN DEFAULT false,
   225    enable_mailserver_cycle BOOLEAN DEFAULT false,
   226    synthetic_id VARCHAR DEFAULT 'id' PRIMARY KEY
   227  ) WITHOUT ROWID;
   228  
   229  CREATE TABLE shhext_default_push_notification_servers (
   230    public_key VARCHAR NOT NULL DEFAULT "",
   231    synthetic_id VARCHAR DEFAULT 'id',
   232    PRIMARY KEY (public_key, synthetic_id)
   233  ) WITHOUT ROWID;