-
Notifications
You must be signed in to change notification settings - Fork 9
/
schema.db
83 lines (83 loc) · 1.56 KB
/
schema.db
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
CREATE TABLE IF NOT EXISTS qsos(
"app" TEXT,
"contestname" TEXT,
"contestnr" TEXT,
"timestamp" TEXT,
"mycall" TEXT,
"band" TEXT,
"rxfreq" TEXT,
"txfreq" TEXT,
"operator" TEXT,
"mode" TEXT,
"call" TEXT,
"countryprefix" TEXT,
"wpxprefix" TEXT,
"stationprefix" TEXT,
"continent" TEXT,
"snt" TEXT,
"sntnr" TEXT,
"rcv" TEXT,
"rcvnr" TEXT,
"gridsquare" TEXT,
"exchange1" TEXT,
"section" TEXT,
"comment" TEXT,
"qth" TEXT,
"name" TEXT,
"power" TEXT,
"misctext" TEXT,
"zone" TEXT,
"prec" TEXT,
"ck" TEXT,
"ismultiplier1" TEXT,
"ismultiplier2" TEXT,
"ismultiplier3" TEXT,
"points" TEXT,
"radionr" TEXT,
"run1run2" TEXT,
"RoverLocation" TEXT,
"RadioInterfaced" TEXT,
"NetworkedCompNr" TEXT,
"IsOriginal" TEXT,
"NetBiosName" TEXT,
"IsRunQSO" TEXT,
"StationName" TEXT,
"ID" TEXT,
"IsClaimedQso" TEXT,
"lat" TEXT,
"lon" TEXT,
"isbusted" TEXT,
"distance" TEXT
);
CREATE TABLE IF NOT EXISTS radio(
"timestamp" TEXT,
"app" TEXT,
"StationName" TEXT,
"RadioNr" TEXT,
"Freq" TEXT,
"TXFreq" TEXT,
"Mode" TEXT,
"OpCall" TEXT,
"IsRunning" TEXT,
"FocusEntry" TEXT,
"EntryWindowHwnd" TEXT,
"antenna" TEXT,
"Rotors" TEXT,
"FocusRadioNr" TEXT,
"IsStereo" TEXT,
"IsSplit" TEXT,
"ActiveRadioNr" TEXT,
"IsTransmitting" TEXT,
"FunctionKeyCaption" TEXT,
"RadioName" TEXT,
"AuxAntSelected" TEXT,
"AuxAntSelectedName" TEXT
);
CREATE TABLE IF NOT EXISTS spots(
"timestamp" TEXT,
"call" TEXT type UNIQUE,
"lat" TEXT,
"lon" TEXT,
"grid" TEXT
);
CREATE INDEX call_idx on spots(call);