From 3a78e641bacccaca181bbd292f0f2f0d579b5caf Mon Sep 17 00:00:00 2001
From: Leandro Silva Ferreira <leandrosilvaferreira@gmail.com>
Date: Wed, 15 Aug 2012 11:04:16 -0400
Subject: Changes to save de address field from geocoding and show it on
 markers at the map and on position's grid

---
 setup/windows/windowsPG.cfg | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'setup/windows/windowsPG.cfg')

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>
-- 
cgit v1.2.3