How to use H2 shell for traccar server

How to use H2 shell

H2 is one of the fastest database which comes under modified version of the MPL 1.1 ( Mozilla Public License ) or under the (unmodified) EPL 1.0 ( Eclipse Public License ).

H2 Shell is a command line database tool which can be used for any of the database sql operation. To run the H2 shell go to the bin directory of your H2 installation and run the following.

cd /opt/traccar

java -cp /opt/traccar/lib/h2-1.4.196.jar  org.h2.tools.Shell

Once you run the tool it will ask some connection details.

URL       jdbc:h2:./data/database
Driver    org.h2.Driver
User      sa
Password  

Password  
Connected
Commands are case insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list mode
maxwidth       Set maximum column width (default is 100)
show           List all tables
describe       Describe a table
quit or exit   Close the connection and exit
sql>