Project

General

Profile

Database structure

Very simple database structure.

Creating database:

sqlite3 name.db

Creating table:

Table name: CUSTOM_NAMES

CREATE TABLE CUSTOM_NAMES(
   ID INT PRIMARY KEY NOT NULL,
   NAME TEXT NOT NULL,
   LAT REAL NOT NULL,
   LON REAL NOT NULL
)

Creates:
  ID  |   NAME     |   LAT   |  LON

with examples:

  1   |   Test     | 5.233   | 2.4933
  2   |   Location | -33.233 | 4

Example for inserting values:

insert into CUSTOM_NAMES values (6, "test", 46.056947, 14.505751);