diff options
Diffstat (limited to 'setup/windows/windowsPG.cfg')
| -rw-r--r-- | setup/windows/windowsPG.cfg | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/setup/windows/windowsPG.cfg b/setup/windows/windowsPG.cfg index 28e29dbad..aaefc4b21 100644 --- a/setup/windows/windowsPG.cfg +++ b/setup/windows/windowsPG.cfg @@ -14,6 +14,7 @@ <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;
@@ -22,6 +23,7 @@ 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
@@ -80,13 +82,15 @@ 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)
+ INSERT INTO positions (id, device_id, time, valid, latitude, longitude, speed, course, power, mode, address)
+ VALUES (nextval('positionsSQ'),:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power, :mode, :address)
</entry>
<!-- Web interface port -->
<entry key="http.enable">true</entry>
<entry key="http.port">8082</entry>
+
+ <entry key="geocoder.enable">true</entry>
<!-- Logging options -->
<entry key="logger.enable">true</entry>
|