schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

CREATE TABLE IF NOT EXISTS location (
	timestamp 	REAL NOT NULL,
	latitude 	REAL NOT NULL,
	longitude 	REAL NOT NULL,
	accuracy	REAL NOT NULL,	
	heading		REAL NOT NULL
);

CREATE TABLE IF NOT EXISTS shape (
	id			INTEGER NOT NULL,
	kind		VARCHAR NOT NULL
);

CREATE TABLE IF NOT EXISTS shape_point (
	shape		INTEGER NOT NULL,
	latitude	REAL NOT NULL,
	longitude	REAL NOT NULL
);