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
|
