Index: /branches/eam_branches/ipp-20230313/dbconfig/changes.txt
===================================================================
--- /branches/eam_branches/ipp-20230313/dbconfig/changes.txt	(revision 42544)
+++ /branches/eam_branches/ipp-20230313/dbconfig/changes.txt	(revision 42545)
@@ -2632,2 +2632,57 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- EAM 2023.11.04 : adding xcstackRun, xcstackInputSkyfile, xcstackSumSkyfile
+
+
+CREATE TABLE xcstackRun (
+        xcstack_id BIGINT AUTO_INCREMENT,
+        state VARCHAR(64),
+        workdir VARCHAR(255),
+        label VARCHAR(64),
+        data_group VARCHAR(64),
+        dist_group VARCHAR(64),
+        reduction VARCHAR(64),
+        registered DATETIME,
+        skycell_id VARCHAR(64),
+        tess_id VARCHAR(64),
+        filter VARCHAR(64),
+        software_ver VARCHAR(16),
+        note VARCHAR(255),
+        PRIMARY KEY(xcstack_id),
+        KEY(xcstack_id),
+        KEY(state),
+        KEY(skycell_id),
+        KEY(tess_id),
+        KEY(label),
+        KEY(data_group),
+        KEY(dist_group)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE xcstackInputSkyfile (
+        xcstack_id BIGINT,
+        camera_id BIGINT,
+        stack_id BIGINT,
+        PRIMARY KEY(xcstack_id, stack_id),
+        FOREIGN KEY(xcstack_id) REFERENCES xcstackRun(xcstack_id),
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE xcstackSumSkyfile (
+        xcstack_id BIGINT,
+        path_base VARCHAR(255),
+        bg DOUBLE,
+        bg_stdev DOUBLE,
+        dtime_stack FLOAT,
+        dtime_script FLOAT,
+        hostname VARCHAR(64),
+        good_frac FLOAT,
+        fault SMALLINT,
+        software_ver VARCHAR(16),
+        quality SMALLINT NOT NULL DEFAULT 0,
+        PRIMARY KEY(xcstack_id),
+        KEY(dtime_stack),
+        KEY(good_frac),
+        KEY(fault),
+        KEY(quality),
+        FOREIGN KEY(xcstack_id) REFERENCES xcstackRun(xcstack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
Index: /branches/eam_branches/ipp-20230313/dbconfig/ff.md
===================================================================
--- /branches/eam_branches/ipp-20230313/dbconfig/ff.md	(revision 42544)
+++ /branches/eam_branches/ipp-20230313/dbconfig/ff.md	(revision 42545)
@@ -1,3 +1,4 @@
 
+## why is ff_id not marked here for AUTO_INCREMENT?
 fullForceRun METADATA
     ff_id           S64         0
Index: /branches/eam_branches/ipp-20230313/dbconfig/ipp.m4
===================================================================
--- /branches/eam_branches/ipp-20230313/dbconfig/ipp.m4	(revision 42544)
+++ /branches/eam_branches/ipp-20230313/dbconfig/ipp.m4	(revision 42545)
@@ -43,2 +43,3 @@
 include(remote.md)
 include(fpcam.md)
+include(xcstack.md)
Index: /branches/eam_branches/ipp-20230313/dbconfig/xcstack.md
===================================================================
--- /branches/eam_branches/ipp-20230313/dbconfig/xcstack.md	(revision 42545)
+++ /branches/eam_branches/ipp-20230313/dbconfig/xcstack.md	(revision 42545)
@@ -0,0 +1,42 @@
+
+xcstackRun METADATA
+    xcstack_id   S64         0       # Primary Key AUTO_INCREMENT
+    state        STR         64      # Key
+    workdir      STR         255
+    label        STR         64      # Key
+    data_group   STR         64      # Key
+    dist_group   STR         64      # Key
+    reduction    STR         64      # Reduction class
+    registered   TAI         NULL
+    skycell_id   STR         64      # Key
+    tess_id      STR         64      # Key
+    filter       STR         64
+    software_ver STR         16
+    note         STR         255
+END
+
+xcstackInputSkyfile METADATA
+    xcstack_id    S64         0       # Primary Key fkey(xcstack_id) ref xcstackRun(xcstack_id)
+    camera_id     S64         0       # Primary Key fkey(warp_id) ref warpSkyfile(warp_id)
+    stack_id      S64         0
+END
+
+xcstackSumSkyfile METADATA
+    xcstack_id         S64    0       # Primary Key fkey(xcstack_id) ref xcstackRun(xcstack_id)
+    path_base          STR    255
+    bg                 F64    0.0
+    bg_stdev           F64    0.0
+    dtime_stack        F32    0.0 # Key
+    dtime_script       F32    0.0
+    hostname           STR    64
+    good_frac          F32    0.0     # Key
+    fault              S16    0       # Key
+    software_ver       STR    16
+    quality            S16    0
+END
+
+xcstackCamera METADATA
+    camera_id  S64      0       # Primary Key AUTO_INCREMENT
+    camera     STR     64
+END
+