[Firebug-cvs] fireboard/beta/bin sirf_id28_1.pgsql,NONE,1.1 sirf_id28_2.pgsql,NONE,1.1 sirf_id28_3.pgsql,NONE,1.1 sirf_id2_1.pgsql,NONE,1.1 sirf_id2_2.pgsql,NONE,1.1 firebug-db-setup.sh,1.2,1.3 firebug.sql,1.5,1.6

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

Update of /cvsroot/firebug/fireboard/beta/bin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3786

Modified Files:
	firebug-db-setup.sh firebug.sql 
Added Files:
	sirf_id28_1.pgsql sirf_id28_2.pgsql sirf_id28_3.pgsql 
	sirf_id2_1.pgsql sirf_id2_2.pgsql 
Log Message:
autogenerated sirf table postgres sql scripts 
work.

--- NEW FILE: sirf_id28_3.pgsql ---
/**
 * This class is automatically generated by mig. DO NOT EDIT THIS FILE.
 * This code provides postgres table  to the 'SiRF_ID28_3'
 * message type.
 */

CREATE TABLE SiRF_ID28_3 (
   header_seqno smallint,
   header_am_type smallint,
   header_rsrvd1 smallint,
   header_rsrvd2 smallint,
   sync_flags smallint,
   cno1 smallint,
   cno2 smallint,
   cno3 smallint,
   cno4 smallint,
   cno5 smallint,
   cno6 smallint,
   cno7 smallint,
   cno8 smallint,
   cno9 smallint,
   cno10 smallint,
   delta_range_interval smallint,
   mean_delta_range_time smallint,
   extrapolation_time smallint,
   phase_error_count smallint,
   low_power_count smallint);




--- NEW FILE: sirf_id28_2.pgsql ---
/**
 * This class is automatically generated by mig. DO NOT EDIT THIS FILE.
 * This code provides postgres table  to the 'SiRF_ID28_2'
 * message type.
 */

CREATE TABLE SiRF_ID28_2 (
   header_seqno smallint,
   header_am_type smallint,
   header_rsrvd1 smallint,
   header_rsrvd2 smallint,
   pseudo_range integer,
   carrier_freq integer,
   carrier_phase integer,
   time_in_track smallint);




--- NEW FILE: sirf_id2_2.pgsql ---
/**
 * This class is automatically generated by mig. DO NOT EDIT THIS FILE.
 * This code provides postgres table  to the 'SiRF_ID2_2'
 * message type.
 */

CREATE TABLE SiRF_ID2_2 (
   header_seqno smallint,
   header_am_type smallint,
   header_rsrvd1 smallint,
   header_rsrvd2 smallint,
   gps_tow integer,
   sv_in_fix smallint,
   ch1 smallint,
   ch2 smallint,
   ch3 smallint,
   ch4 smallint,
   ch5 smallint,
   ch6 smallint,
   ch7 smallint,
   ch8 smallint,
   ch9 smallint,
   ch10 smallint,
   ch11 smallint,
   ch12 smallint);




Index: firebug.sql
===================================================================
RCS file: /cvsroot/firebug/fireboard/beta/bin/firebug.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** firebug.sql	20 Jun 2005 17:58:43 -0000	1.5
--- firebug.sql	15 Jul 2005 16:37:01 -0000	1.6
***************
*** 59,61 ****
  select gga_l.nodeid, latitudedegree, latitudeminutes, longitudedegree,
  longitudeminute, temperature, humidity, pressure 
! from gga_l, xbow_weather_l where gga_l.nodeid = xbow_weather_l.nodeid;
\ No newline at end of file
--- 59,62 ----
  select gga_l.nodeid, latitudedegree, latitudeminutes, longitudedegree,
  longitudeminute, temperature, humidity, pressure 
! from gga_l, xbow_weather_l where gga_l.nodeid = xbow_weather_l.nodeid;
! 

--- NEW FILE: sirf_id28_1.pgsql ---
/**
 * This class is automatically generated by mig. DO NOT EDIT THIS FILE.
 * This code provides postgres table  to the 'SiRF_ID28_1'
 * message type.
 */

CREATE TABLE SiRF_ID28_1 (
   header_seqno smallint,
   header_am_type smallint,
   header_rsrvd1 smallint,
   header_rsrvd2 smallint,
   channel smallint,
   time_tag integer,
   sat_id smallint,
   gps_sw_time integer);




--- NEW FILE: sirf_id2_1.pgsql ---
/**
 * This class is automatically generated by mig. DO NOT EDIT THIS FILE.
 * This code provides postgres table  to the 'SiRF_ID2_1'
 * message type.
 */

CREATE TABLE SiRF_ID2_1 (
   header_seqno smallint,
   header_am_type smallint,
   header_rsrvd1 smallint,
   header_rsrvd2 smallint,
   xpos integer,
   ypos integer,
   zpos integer,
   xvel smallint,
   yvel smallint,
   zvel smallint,
   mode1 smallint,
   gps_week smallint);




Index: firebug-db-setup.sh
===================================================================
RCS file: /cvsroot/firebug/fireboard/beta/bin/firebug-db-setup.sh,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** firebug-db-setup.sh	19 Jun 2005 22:26:32 -0000	1.2
--- firebug-db-setup.sh	15 Jul 2005 16:37:01 -0000	1.3
***************
*** 48,51 ****
--- 48,58 ----
  psql --echo-queries --dbname firebug  firebug < firebug.sql
  
+ psql --echo-queries --dbname firebug  firebug < sirf_id2_1.pgsql
+ psql --echo-queries --dbname firebug  firebug < sirf_id2_2.pgsql
+ psql --echo-queries --dbname firebug  firebug < sirf_id28_1.pgsql
+ psql --echo-queries --dbname firebug  firebug < sirf_id28_2.pgsql
+ psql --echo-queries --dbname firebug  firebug < sirf_id28_3.pgsql
+ 
+ 
  
  #### The following are just examples of how to set up