The Things Network LoRaWAN Stack V3 学习笔记 2.1.1 使用 CockroachDB Shell 操作 Identity Server

# cockroach sql --insecure --host=localhost:26257
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
#
# Server version: CockroachDB CCL v2.1.6 (x86_64-unknown-linux-gnu, built 2019/03/04 23:21:07, go1.10.7) (same version as client)
# Cluster ID: 56c72251-e347-4df5-8016-c0a220807a11
#
# Enter \? for a brief introduction.
#

\q

root@localhost:26257/defaultdb> SHOW DATABASES;
   database_name   
+-----------------+
  defaultdb        
  postgres         
  system           
  ttn_lorawan_dev  
(4 rows)

Time: 9.753064ms

root@localhost:26257/defaultdb> SHOW TABLES FROM ttn_lorawan_dev;
         table_name         
+--------------------------+
  access_tokens             
  accounts                  
  api_keys                  
  applications              
  attributes                
  authorization_codes       
  client_authorizations     
  clients                   
  contact_info_validations  
  contact_infos             
  end_device_locations      
  end_devices               
  gateway_antennas          
  gateways                  
  invitations               
  memberships               
  organizations             
  pictures                  
  user_sessions             
  users                     
(20 rows)

Time: 1.559261ms

root@localhost:26257/defaultdb> DROP DATABASE ttn_lorawan_dev CASCADE;
DROP DATABASE

Time: 586.676844ms