Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 18574)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 18576)
@@ -713,10 +713,97 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE stackRun (stack_id BIGINT AUTO_INCREMENT, state VARCHAR(64), workdir VARCHAR(255), dvodb VARCHAR(255), registered DATETIME, skycell_id VARCHAR(64), tess_id VARCHAR(64), PRIMARY KEY(stack_id), KEY(stack_id), KEY(state), KEY(skycell_id), KEY(tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE stackInputSkyfile (stack_id BIGINT, warp_id BIGINT, PRIMARY KEY(stack_id, warp_id), FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id), FOREIGN KEY (warp_id)  REFERENCES  warpSkyfile(warp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE stackSumSkyfile (stack_id BIGINT, uri VARCHAR(255), path_base VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, dtime_stack FLOAT, hostname VARCHAR(64), good_frac FLOAT, fault SMALLINT, PRIMARY KEY(stack_id), KEY(dtime_stack), KEY(good_frac), KEY(fault), FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE diffRun (diff_id BIGINT AUTO_INCREMENT, state VARCHAR(64), workdir VARCHAR(255), dvodb VARCHAR(255), registered DATETIME, skycell_id VARCHAR(64), tess_id VARCHAR(64), PRIMARY KEY(diff_id), KEY(diff_id), KEY(state), KEY(skycell_id), KEY(tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE diffInputSkyfile (diff_id BIGINT, template TINYINT, stack_id BIGINT, warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64), kind VARCHAR(64), PRIMARY KEY(diff_id, template), KEY(stack_id), KEY(warp_id), KEY(skycell_id), KEY(tess_id), KEY(kind), FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id), FOREIGN KEY (stack_id)  REFERENCES  stackSumSkyfile(stack_id), FOREIGN KEY (warp_id, skycell_id, tess_id)  REFERENCES  warpSkyfile(warp_id, skycell_id, tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE diffSkyfile (diff_id BIGINT, uri VARCHAR(255), path_base VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, stamps_num INT, stamps_rms FLOAT, sources INT, dtime_diff FLOAT, hostname VARCHAR(64), good_frac FLOAT, fault SMALLINT, PRIMARY KEY(diff_id), KEY(good_frac), KEY(fault), FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
+CREATE TABLE stackRun (
+	stack_id BIGINT AUTO_INCREMENT,
+	state VARCHAR(64),
+	workdir VARCHAR(255),
+	dvodb VARCHAR(255),
+	registered DATETIME,
+	skycell_id VARCHAR(64),
+	tess_id VARCHAR(64),
+	filter VARCHAR(64),
+	PRIMARY KEY(stack_id),
+	KEY(stack_id),
+	KEY(state),
+	KEY(skycell_id),
+	KEY(tess_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackInputSkyfile (
+	stack_id BIGINT,
+	warp_id BIGINT,
+	PRIMARY KEY(stack_id, warp_id),
+	FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id),
+	FOREIGN KEY (warp_id)  REFERENCES  warpSkyfile(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackSumSkyfile (
+	stack_id BIGINT,
+	uri VARCHAR(255),
+	path_base VARCHAR(255),
+	bg DOUBLE,
+	bg_stdev DOUBLE,
+	dtime_stack FLOAT,
+	hostname VARCHAR(64),
+	good_frac FLOAT,
+	fault SMALLINT,
+	PRIMARY KEY(stack_id),
+	KEY(dtime_stack),
+	KEY(good_frac),
+	KEY(fault),
+	FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE diffRun (
+	diff_id BIGINT AUTO_INCREMENT,
+	state VARCHAR(64),
+	workdir VARCHAR(255),
+	dvodb VARCHAR(255),
+	registered DATETIME,
+	skycell_id VARCHAR(64),
+	tess_id VARCHAR(64),
+	PRIMARY KEY(diff_id),
+	KEY(diff_id),
+	KEY(state),
+	KEY(skycell_id),
+	KEY(tess_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE diffInputSkyfile (
+	diff_id BIGINT,
+	template TINYINT,
+	stack_id BIGINT,
+	warp_id BIGINT,
+	skycell_id VARCHAR(64),
+	tess_id VARCHAR(64),
+	kind VARCHAR(64),
+	PRIMARY KEY(diff_id, template),
+	KEY(stack_id),
+	KEY(warp_id),
+	KEY(skycell_id),
+	KEY(tess_id),
+	KEY(kind),
+	FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id),
+	FOREIGN KEY (stack_id)  REFERENCES  stackSumSkyfile(stack_id),
+	FOREIGN KEY (warp_id, skycell_id, tess_id)  REFERENCES  warpSkyfile(warp_id, skycell_id, tess_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE diffSkyfile (
+	diff_id BIGINT,
+	uri VARCHAR(255),
+	path_base VARCHAR(255),
+	bg DOUBLE,
+	bg_stdev DOUBLE,
+	stamps_num INT,
+	stamps_rms FLOAT,
+	sources INT,
+	dtime_diff FLOAT,
+	hostname VARCHAR(64),
+	good_frac FLOAT,
+	fault SMALLINT,
+	PRIMARY KEY(diff_id),
+	KEY(good_frac),
+	KEY(fault),
+	FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
 
 CREATE TABLE magicRun (