Page Menu
Home
GitPull.it
Search
Configure Global Search
Log In
Files
F15187013
database_schema.txt
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Authored By
Unknown
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);
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Thu, Nov 19, 09:35 (29 m, 10 s)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263847
Default Alt Text
database_schema.txt (395 B)
Attached To
Mode
R4 Libre BusTO
Attached
Detach File
Event Timeline