Update of /cvsroot/firebug/fireboard/beta/bin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18669
Modified Files:
firebug.sql
Log Message:
Added a handy view joining two of the tables
for emitting data to gmaps application.
Index: firebug.sql
===================================================================
RCS file: /cvsroot/firebug/fireboard/beta/bin/firebug.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** firebug.sql 19 Jun 2005 22:26:32 -0000 1.2
--- firebug.sql 19 Jun 2005 22:47:33 -0000 1.3
***************
*** 49,50 ****
--- 49,56 ----
DELETE FROM gga_l WHERE nodeid = NEW.nodeid;
INSERT INTO gga_l VALUES (NEW.*); );
+
+
+ create view location_conditions as -- select * from task_query_log;
+ select gga.nodeid, latitudedegree, latitudeminutes, longitudedegree,
+ longitudeminute, temperature, humidity, pressure
+ from gga, xbow_weather where gga.nodeid = xbow_weather.nodeid;
\ No newline at end of file
|
