database_schema.txt
No OneTemporary
Actions

Size

395 B

Referenced Files

None

Subscribers

None

database_schema.txt
View Options

	CREATE TABLE routemap
	(
	route TEXT NOT NULL,
	stop TEXT NOT NULL
	);
	CREATE INDEX route_index ON routemap(route);
	CREATE INDEX stop_index ON routemap(stop);
	CREATE UNIQUE INDEX double_index ON routemap(route, stop);
	CREATE TABLE stops (ID TEXT PRIMARY KEY, name TEXT, location TEXT, type TEXT, lat DOUBLE, lon DOUBLE);

	CREATE TABLE favorites (ID TEXT PRIMARY KEY NOT NULL, username TEXT);