Changeset 38948 for trunk/ippToPsps/test/gpc1schema.sql

Timestamp:

Oct 23, 2015, 9:40:40 AM (11 years ago)

Author:

eugene

Message:

adding filter to rawExp

File:

• trunk/ippToPsps/test/gpc1schema.sql (modified) (1 diff)

trunk/ippToPsps/test/gpc1schema.sql

@@ -2 +2 @@
   CREATE TABLE ippToPspsFake       ( my_id INT  );
   CREATE TABLE skycell             ( skycell_id CHAR(64), radeg REAL, decdeg REAL );
-  CREATE TABLE rawExp              ( exp_id INT, exp_name CHAR(64), exp_time REAL, bg REAL, bg_stdev REAL, ra FLOAT, decl FLOAT, dateobs DATETIME );
+  CREATE TABLE rawExp              ( exp_id INT, exp_name CHAR(64), exp_time REAL, filter CHAR(64), bg REAL, bg_stdev REAL, ra FLOAT, decl FLOAT, dateobs DATETIME );
   CREATE TABLE chipRun             ( exp_id INT, chip_id INT );
   CREATE TABLE camRun              ( chip_id INT, cam_id INT, dist_group CHAR(64), software_ver CHAR(16) );