Index: branches/eam_branches/ipp-20220316/dbconfig/changes.txt
===================================================================
--- branches/eam_branches/ipp-20220316/dbconfig/changes.txt	(revision 42187)
+++ branches/eam_branches/ipp-20220316/dbconfig/changes.txt	(revision 42188)
@@ -2575,2 +2575,59 @@
       REFERENCES stackExternalCamera(ext_camera_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- EAM 2022.05.09 : adding fpcamRun, fpcamProcessedExp
+
+CREATE TABLE fpcamRun (
+    fpcam_id      BIGINT AUTO_INCREMENT,
+    cam_id        BIGINT,
+    chip_id       BIGINT,
+    state         VARCHAR(64),
+    workdir       VARCHAR(255),
+    workdir_state VARCHAR(64),
+    label         VARCHAR(64),
+    data_group    VARCHAR(64),
+    dist_group    VARCHAR(64),
+    reduction     VARCHAR(64),
+    dvodb         VARCHAR(255),
+    software_ver  VARCHAR(16),
+    note          VARCHAR(255),
+    PRIMARY KEY(fpcam_id),
+    KEY(cam_id),
+    KEY(chip_id),
+    KEY(state),
+    KEY(label),
+    INDEX(chip_id, cam_id),
+    FOREIGN KEY (cam_id) REFERENCES camRun(cam_id),
+    FOREIGN KEY (chip_id) REFERENCES chipRun(chip_id))
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fpcamProcessedExp (
+    fpcam_id     BIGINT,
+    path_base    VARCHAR(255),
+
+    zpt_obs      FLOAT,
+    zpt_stdev    FLOAT,
+    zpt_lq       FLOAT,
+    zpt_uq       FLOAT,
+
+    dtime_script FLOAT,
+
+    hostname     VARCHAR(64),
+    n_stars      INT,
+    fault        SMALLINT NOT NULL,
+    epoch        TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+
+    software_ver VARCHAR(16),
+
+    deteff_obs   FLOAT,
+    deteff_err   FLOAT,
+    deteff_lq    FLOAT,
+    deteff_uq    FLOAT,
+
+    quality      SMALLINT
+
+    PRIMARY KEY(fpcam_id),
+    KEY(fault),
+    FOREIGN KEY (fpcam_id) REFERENCES fpcamRun(fpcam_id),
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
Index: branches/eam_branches/ipp-20220316/dbconfig/fpcam.md
===================================================================
--- branches/eam_branches/ipp-20220316/dbconfig/fpcam.md	(revision 42188)
+++ branches/eam_branches/ipp-20220316/dbconfig/fpcam.md	(revision 42188)
@@ -0,0 +1,40 @@
+fpcamRun METADATA
+    fpcam_id      S64       0       # Primary Key AUTO_INCREMENT
+    cam_id        S64       0       # Key INDEX(cam_id, chip_id) fkey(chip_id) ref chipRun(chip_id)
+    chip_id       S64       0       # Key INDEX(cam_id, chip_id) fkey(cam_id)  ref camRun(cam_id)
+    state         STR       64      # key
+    workdir       STR       255 
+    workdir_state STR       64
+    label         STR       64      # key
+    data_group    STR       64      # key
+    dist_group    STR       64
+    reduction     STR       64
+    dvodb         STR       255
+    software_ver  STR       16
+    note          STR       255
+END
+
+fpcamProcessedExp METADATA
+    fpcam_id       S64      0       # Primary Key fkey(fpcam_id) ref fpcamRun(fpcam_id)
+    path_base      STR      255
+
+    zpt_obs        F32      0.0
+    zpt_stdev      F32      0.0
+    zpt_lq         F32      0.0
+    zpt_uq         F32      0.0
+
+    dtime_script   F32      0.0
+
+    hostname       STR      64
+    n_stars        S32      0
+    fault          S16      0       # Key NOT NULL
+    epoch          UTC      0001-01-01T00:00:00Z
+
+    software_ver   STR      16
+    deteff         F32      0
+    deteff_err     F32      0
+    deteff_lq      F32      0
+    deteff_uq      F32      0
+
+    quality        S16      0
+END
Index: branches/eam_branches/ipp-20220316/dbconfig/ipp.m4
===================================================================
--- branches/eam_branches/ipp-20220316/dbconfig/ipp.m4	(revision 42187)
+++ branches/eam_branches/ipp-20220316/dbconfig/ipp.m4	(revision 42188)
@@ -42,2 +42,3 @@
 include(ff.md)
 include(remote.md)
+include(fpcam.md)