Update of /cvsroot/firebug/firebug/web
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19192
Modified Files:
admin.html
Log Message:
Changed schema for collecting weather data.
Index: admin.html
===================================================================
RCS file: /cvsroot/firebug/firebug/web/admin.html,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** admin.html 14 Jul 2004 21:42:25 -0000 1.14
--- admin.html 14 Jul 2004 22:07:35 -0000 1.15
***************
*** 122,127 ****
<pre> USE DATABASE firebug;<br> </pre>
Then create the tables:
! <pre> CREATE TABLE current (mote_id INTEGER,<br> time TIMESTAMP,<br> temp FLOAT,<br> rel_hum FLOAT,<br> baro_pres FLOAT,<br> cnt INTEGER);<br> </pre>
! <pre> CREATE TABLE cumulative (mote_id INTEGER,<br> time TIMESTAMP,<br> temp FLOAT,<br> rel_hum FLOAT,<br> baro_pres FLOAT,<br> cnt INTEGER);<br> </pre>
Load the example.txt file using:
--- 122,144 ----
<pre> USE DATABASE firebug;<br> </pre>
Then create the tables:
! <pre>
! CREATE TABLE current (time TIMESTAMP,
! mote_id INTEGER,
! rel_hum FLOAT,
! sens_temp FLOAT,
! inter_temp FLOAT,
! pres FLOAT);
! </pre>
!
! <pre>
! CREATE TABLE cumulative (time TIMESTAMP,
! mote_id INTEGER,
! rel_hum FLOAT,
! sens_temp FLOAT,
! inter_temp FLOAT,
! pres FLOAT);
! </pre>
!
!
Load the example.txt file using:
|
