Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28089)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28091)
@@ -1617,5 +1617,5 @@
 -- A static sky analysis set
 CREATE TABLE staticskyRun (
-      ss_id BIGINT AUTO_INCREMENT, -- unique identifier
+      sky_id BIGINT AUTO_INCREMENT, -- unique identifier
       state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
       workdir VARCHAR(255) NOT NULL, -- working directory
@@ -1626,5 +1626,5 @@
       note VARCHAR(255),             -- note
       registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
-      PRIMARY KEY(ss_id),
+      PRIMARY KEY(sky_id),
       KEY(state),
       KEY(label),
@@ -1635,9 +1635,9 @@
 -- Inputs for static sky analysis
 CREATE TABLE staticskyInput (
-      ss_id BIGINT,             -- static sky identifier
+      sky_id BIGINT,             -- static sky identifier
       stack_id BIGINT,          -- stack identifier
-      PRIMARY KEY(ss_id,stack_id),
+      PRIMARY KEY(sky_id,stack_id),
       KEY(stack_id),
-      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+      FOREIGN KEY(sky_id) REFERENCES staticskyRun(sky_id),
       FOREIGN KEY(stack_id) REFERENCES stackSumSkyfile(stack_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1645,5 +1645,5 @@
 -- Result of static sky analysis
 CREATE TABLE staticskyResult (
-      ss_id BIGINT,             -- static sky identifier
+      sky_id BIGINT,             -- static sky identifier
       path_base VARCHAR(255) NOT NULL, -- root name for outputs
       dtime_phot FLOAT,                -- elapsed time for photometry
@@ -1654,9 +1654,9 @@
       quality SMALLINT NOT NULL,       -- bad quality flag
       fault SMALLINT NOT NULL,         -- fault code
-      PRIMARY KEY(ss_id),
+      PRIMARY KEY(sky_id),
       KEY(good_frac),
       KEY(fault),
       KEY(quality),
-      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id)
+      FOREIGN KEY(sky_id) REFERENCES staticskyRun(sky_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
