Page MenuHomeGitPull.it

database_schema.txt
No OneTemporary

Authored By
Unknown
Size
395 B
Referenced Files
None
Subscribers
None

database_schema.txt

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);

File Metadata

Mime Type
text/plain
Expires
Thu, Nov 19, 08:33 (4 h, 18 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263847
Default Alt Text
database_schema.txt (395 B)

Event Timeline