1 #ifndef FG_NAVCACHE_SCHEMA_HXX
2 #define FG_NAVCACHE_SCHEMA_HXX
4 const int SCHEMA_VERSION = 10;
7 "CREATE TABLE properties (key VARCHAR, value VARCHAR);" \
8 "CREATE TABLE stat_cache (path VARCHAR unique, stamp INT);"\
10 "CREATE TABLE positioned (type INT, ident VARCHAR collate nocase," \
11 "name VARCHAR collate nocase, airport INT64, lon FLOAT, lat FLOAT," \
12 "elev_m FLOAT, octree_node INT, cart_x FLOAT, cart_y FLOAT, cart_z FLOAT);" \
14 "CREATE INDEX pos_octree ON positioned(octree_node);" \
15 "CREATE INDEX pos_ident ON positioned(ident collate nocase);" \
16 "CREATE INDEX pos_name ON positioned(name collate nocase);" \
17 "CREATE INDEX pos_apt_type ON positioned(airport, type);"\
19 "CREATE TABLE airport (has_metar BOOL);" \
20 "CREATE TABLE comm (freq_khz INT,range_nm INT);" \
21 "CREATE INDEX comm_freq ON comm(freq_khz);" \
23 "CREATE TABLE runway (heading FLOAT, length_ft FLOAT, width_m FLOAT," \
24 "surface INT, displaced_threshold FLOAT,stopway FLOAT,reciprocal INT64,ils INT64);" \
25 "CREATE TABLE navaid (freq INT,range_nm INT,multiuse FLOAT, runway INT64,colocated INT64);" \
26 "CREATE INDEX navaid_freq ON navaid(freq);" \
28 "CREATE TABLE octree (children INT);" \
30 "CREATE TABLE airway (ident VARCHAR collate nocase, network INT);" \
31 "CREATE INDEX airway_ident ON airway(ident);" \
33 "CREATE TABLE airway_edge (network INT,airway INT64,a INT64,b INT64);" \
34 "CREATE INDEX airway_edge_from ON airway_edge(a);" \
36 "CREATE TABLE taxi_node (hold_type INT,on_runway BOOL,pushback BOOL);" \
37 "CREATE TABLE parking (heading FLOAT,radius INT,gate_type VARCHAR," \
38 "airlines VARCHAR,pushback INT64);" \
39 "CREATE TABLE groundnet_edge (airport INT64,a INT64,b INT64);" \
40 "CREATE INDEX groundnet_edge_airport ON groundnet_edge(airport);" \
41 "CREATE INDEX groundnet_edge_from ON groundnet_edge(a);"