[Firebug-cvs] fireboard/beta/bin firebug.sql,1.2,1.3

[David M. D. <do...@us...>]

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