Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 27450)
+++ trunk/dbconfig/changes.txt	(revision 27546)
@@ -1540,2 +1540,50 @@
 ALTER TABLE magicDSFile ADD COLUMN nondiff_frac FLOAT AFTER streak_frac;
 ALTER TABLE distRun ADD COLUMN alternate TINYINT DEFAULT 0 AFTER no_magic;
+
+-- Tables for static sky analysis
+
+-- A static sky analysis set
+CREATE TABLE staticskyRun (
+      ss_id BIGINT AUTO_INCREMENT, -- unique identifier
+      state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
+      workdir VARCHAR(255) NOT NULL, -- working directory
+      label VARCHAR(64),             -- processing label
+      data_group VARCHAR(64),        -- group for data
+      dist_group VARCHAR(64),        -- group for distribution
+      reduction VARCHAR(64),         -- reduction class (for altering recipe)
+      note VARCHAR(255),             -- note
+      registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+      PRIMARY KEY(dqstats_id),
+      KEY(state),
+      KEY(label),
+      KEY(data_group),
+      KEY(dist_group)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Inputs for static sky analysis
+CREATE TABLE staticskyInput (
+      ss_id BIGINT,             -- static sky identifier
+      stack_id BIGINT,          -- stack identifier
+      PRIMARY KEY(ss_id,stack_id),
+      KEY(stack_id),
+      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+      FOREIGN KEY(stack_id) REFERENCES stackSumSkyfile(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Result of static sky analysis
+CREATE TABLE staticskyResult (
+      ss_id BIGINT,             -- static sky identifier
+      path_base VARCHAR(255) NOT NULL, -- root name for outputs
+      dtime_phot FLOAT,                -- elapsed time for photometry
+      dtime_script FLOAT,              -- elapsed time for script
+      sources INT,                     -- number of sources
+      hostname VARCHAR(64) NOT NULL,   -- host that executed script
+      good_frac FLOAT,                 -- good fraction of skycell
+      quality SMALLINT NOT NULL,       -- bad quality flag
+      fault SMALLINT NOT NULL,         -- fault code
+      PRIMARY KEY(ss_id),
+      KEY(good_frac),
+      KEY(fault),
+      KEY(quality),
+      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+) ENGINE=innodb DEFAULT CHARSET=latin1;
Index: trunk/dbconfig/staticsky.md
===================================================================
--- trunk/dbconfig/staticsky.md	(revision 27546)
+++ trunk/dbconfig/staticsky.md	(revision 27546)
@@ -0,0 +1,30 @@
+# Tables for static sky analysis
+
+staticskyRun METADATA
+    ss_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
+    note        STR         255
+END
+
+staticskyInput METADATA
+    ss_id       S64         0       # Primary Key fkey(ss_id) ref staticskyRun(ss_id)
+    stack_id    S64         0       # Primary Key fkey(stack_id) ref stackSumSkyfile(stack_id)
+END
+
+staticSkyResult METADATA
+    ss_id              S64    0       # Primary Key fkey(ss_id) ref staticskyRun(ss_id)
+    path_base          STR    255
+    dtime_phot         F32    0.0
+    dtime_script       F32    0.0
+    sources            S32    0
+    hostname           STR    64
+    good_frac          F32    0.0     # Key
+    fault              S16    0       # Key
+    quality            S16    0	      # Key
+END