Changes to save de address field from geocoding and show it on markers

at
the map and on position's grid

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>