Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 36374)
+++ trunk/dbconfig/changes.txt	(revision 36441)
@@ -2432,2 +2432,64 @@
 UPDATE dbversion set schema_version = '1.1.77', updated= CURRENT_TIMESTAMP();
 
+--
+
+CREATE TABLE fullForceRun (
+    ff_id           BIGINT NOT NULL AUTO_INCREMENT,
+    skycal_id       BIGINT,
+    sources_path_base VARCHAR(255),
+    state           VARCHAR(64),
+    workdir         VARCHAR(255),
+    label           VARCHAR(64),
+    data_group      VARCHAR(64),
+    dist_group      VARCHAR(64),
+    note            VARCHAR(255),
+    reduction       VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+    PRIMARY KEY(ff_id),
+    KEY(state),
+    KEY(label),
+    KEY(data_group),
+    KEY(skycal_id),
+    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceInput (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    PRIMARY KEY(ff_id, warp_id),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceResult (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(16),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id, warp_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceSummary (
+    ff_id           BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(16),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+UPDATE dbversion set schema_version = '1.1.78', updated= CURRENT_TIMESTAMP();
+
Index: trunk/dbconfig/ff.md
===================================================================
--- trunk/dbconfig/ff.md	(revision 36441)
+++ trunk/dbconfig/ff.md	(revision 36441)
@@ -0,0 +1,41 @@
+
+fullForceRun METADATA
+    ff_id           S64         0
+    skycal_id       S64         0
+    sources_path_base STR       255
+    state           STR 	64
+    workdir         STR         255
+    label           STR 	64
+    data_group      STR 	64
+    dist_group      STR 	64
+    note            STR 	255
+    reduction       STR 	64
+    registered      TAI         NULL
+END
+
+fullForceInput METADATA
+    ff_id           S64         0
+    warp_id         S64         0
+END
+
+fullForceResult METADATA
+    ff_id           S64         0 
+    warp_id         S64         0
+    path_base       STR         255
+    dtime_script    F32         0.0
+    quality         S16         0
+    hostname        STR 	64
+    software_ver    STR 	16
+    fault           S16         0
+END
+
+fullForceSummary METADATA
+    ff_id           S64         0 
+    path_base       STR         255
+    dtime_script    F32         0.0
+    quality         S16         0
+    hostname        STR 	64
+    software_ver    STR 	16
+    fault           S16         0
+END
+
Index: trunk/dbconfig/ipp.m4
===================================================================
--- trunk/dbconfig/ipp.m4	(revision 36374)
+++ trunk/dbconfig/ipp.m4	(revision 36441)
@@ -40,2 +40,3 @@
 include(skycell.md)
 include(release.md)
+include(ff.md)