[Firebug-cvs] fireboard/beta/bin firebug.sql,1.2,1.3
Brought to you by:
doolin
From: David M. D. <do...@us...> - 2005-06-19 22:47:43
|
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 |