firebug-cvs

[<do...@us...>]

Update of /cvsroot/firebug/firebug/web
In directory sc8-pr-cvs1:/tmp/cvs-serv14220/web

Modified Files:
	admin.html db_create.php 
Log Message:
Added time stamping capability to database logging.

Index: admin.html
===================================================================
RCS file: /cvsroot/firebug/firebug/web/admin.html,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** admin.html	10 Jul 2003 21:08:13 -0000	1.10
--- admin.html	18 Jul 2003 20:06:20 -0000	1.11
***************
*** 142,148 ****
  	<tr>
  	  <td>INTEGER</td>
! <!-- This needs to be a DATETIME or something 
!  similar for mysql. -->
! 	  <td>DECIMAL (9,3)</td>
  	  <td>FLOAT</td>
  	  <td>FLOAT</td>
--- 142,146 ----
  	<tr>
  	  <td>INTEGER</td>
! 	  <td>TIMESTAMP</td>
  	  <td>FLOAT</td>
  	  <td>FLOAT</td>
***************
*** 191,195 ****
        <pre>
        CREATE TABLE example (mote_id   INTEGER,
!                             time      DECIMAL(9,3),
                              temp      FLOAT,
                              rel_hum   FLOAT,
--- 189,193 ----
        <pre>
        CREATE TABLE example (mote_id   INTEGER,
!                             time      TIMESTAMP,
                              temp      FLOAT,
                              rel_hum   FLOAT,
***************
*** 219,223 ****
        <pre>
        CREATE TABLE example_current (mote_id   INTEGER,
!                                     time      DECIMAL(9,3),
                                      temp      FLOAT,
                                      rel_hum   FLOAT,
--- 217,221 ----
        <pre>
        CREATE TABLE example_current (mote_id   INTEGER,
!                                     time      TIMESTAMP,
                                      temp      FLOAT,
                                      rel_hum   FLOAT,
***************
*** 227,231 ****
        <pre>
        CREATE TABLE example_cumulative (mote_id   INTEGER,
!                                        time      DECIMAL(9,3),
                                         temp      FLOAT,
                                         rel_hum   FLOAT,
--- 225,229 ----
        <pre>
        CREATE TABLE example_cumulative (mote_id   INTEGER,
!                                        time      TIMESTAMP,
                                         temp      FLOAT,
                                         rel_hum   FLOAT,

Index: db_create.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/db_create.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** db_create.php	10 Jul 2003 09:01:09 -0000	1.7
--- db_create.php	18 Jul 2003 20:06:20 -0000	1.8
***************
*** 38,45 ****
  mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable");
  
! $statement = "CREATE TABLE current (mote_id INTEGER, time DECIMAL(9,3), temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable");
  
! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time DECIMAL(9,3), temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable");
  
--- 38,45 ----
  mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable");
  
! $statement = "CREATE TABLE current (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable");
  
! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable");