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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<!-- Global confiduration -->
<entry key="database.driver">org.postgresql.Driver</entry>
<entry key="database.url">jdbc:postgresql:traccar</entry>
<entry key="database.user">postgres</entry>
<entry key="database.password">postgres</entry>
<!-- Database refresh delay in seconds -->
<entry key="database.refreshDelay">300</entry>
<!-- Create database schema -->
<entry key="database.initialize">
CREATE SEQUENCE devicesSQ START 1 INCREMENT 1;
CREATE SEQUENCE positionsSQ START 1 INCREMENT 1;
CREATE TABLE devices (id int8 NOT NULL,imei varchar(16) NOT NULL,phonenumber varchar(255),uniqueid varchar(255),CONSTRAINT devices_pkey PRIMARY KEY (id)) WITH (OIDS=FALSE);
ALTER TABLE devices OWNER TO postgres;
CREATE TABLE positions (id int8 NOT NULL,address varchar(255),altitude float8,course float8,extendedinfo varchar(255),latitude float8 NOT NULL,longitude float8 NOT NULL,power float8 NOT NULL,speed float8,"time" timestamp NOT NULL,"valid" bool,device_id int8 NOT NULL,"mode" int4,CONSTRAINT positions_pkey PRIMARY KEY (id),CONSTRAINT fk_device FOREIGN KEY (device_id) REFERENCES devices (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION) WITH (OIDS=FALSE);
ALTER TABLE positions OWNER TO postgres;
</entry>
<!-->
id - Long
imei - String
<-->
<entry key="database.selectDevice">
SELECT id, imei
FROM devices
</entry>
<!-->
imei - String
<-->
<entry key="database.insertDevice">
INSERT INTO devices (id,imei)
VALUES (nextval('devicesSQ'),:imei)
</entry>
<!-->
id - Long
imei - String
<-->
<entry key="database.updateDevice">
UPDATE devices
SET imei = :imei
WHERE id = :id
</entry>
<!-->
id - Long
<-->
<entry key="database.deleteDevice">
DELETE FROM devices
WHERE id = :id
</entry>
<!-->
device_id - Long
<-->
<entry key="database.selectPosition">
SELECT *
FROM positions
WHERE device_id = :device_id
</entry>
<!-->
device_id - Long
time - Date
valid - Boolean
latitude - Double
longitude - Double
speed - Double
course - Double
power - Double (NULL for some protocols)
mode - Integer
extended_info - String (XML)
<-->
<entry key="database.insertPosition">
INSERT INTO positions (id, device_id, time, valid, latitude, longitude, speed, course, power, mode)
VALUES (nextval('positionsSQ'),:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power, :mode)
</entry>
<!-- Web interface port -->
<entry key="http.enable">true</entry>
<entry key="http.port">8082</entry>
<!-- Logging options -->
<entry key="logger.enable">false</entry>
<entry key="logger.file">jornadaLOG</entry>
<!-- Xexun server configuration -->
<entry key="xexun.enable">false</entry>
<entry key="xexun.port">5000</entry>
<entry key="xexun.resetDelay">0</entry>
<!-- Gps103 server configuration -->
<entry key="gps103.enable">false</entry>
<entry key="gps103.port">5001</entry>
<entry key="gps103.resetDelay">0</entry>
<!-- Tk103 server configuration -->
<entry key="tk103.enable">false</entry>
<entry key="tk103.port">5002</entry>
<entry key="tk103.resetDelay">0</entry>
<!-- Gl100 server configuration -->
<entry key="gl100.enable">false</entry>
<entry key="gl100.port">5003</entry>
<entry key="gl100.resetDelay">0</entry>
<!-- Gl200 server configuration -->
<entry key="gl200.enable">false</entry>
<entry key="gl200.port">5004</entry>
<entry key="gl200.resetDelay">0</entry>
<!-- T55 server configuration -->
<entry key="t55.enable">false</entry>
<entry key="t55.port">5005</entry>
<entry key="t55.resetDelay">0</entry>
<!-- Xexun 2 server configuration -->
<entry key="xexun2.enable">false</entry>
<entry key="xexun2.port">5006</entry>
<entry key="xexun2.resetDelay">0</entry>
<!-- AVL-08 server configuration -->
<entry key="avl08.enable">false</entry>
<entry key="avl08.port">5007</entry>
<entry key="avl08.resetDelay">0</entry>
<!-- Enfora server configuration -->
<entry key="enfora.enable">false</entry>
<entry key="enfora.port">5008</entry>
<entry key="enfora.resetDelay">0</entry>
<!-- Meiligao server configuration -->
<entry key="meiligao.enable">false</entry>
<entry key="meiligao.port">5009</entry>
<entry key="meiligao.resetDelay">0</entry>
<!-- ST-210 server configuration -->
<entry key="st210.enable">true</entry>
<entry key="st210.port">8801</entry>
<entry key="st210.resetDelay">0</entry>
</properties>
|
