Changeset 33720 for trunk/ippTools/share

Timestamp:

Apr 5, 2012, 1:00:05 PM (14 years ago)

Author:

bills

Message:

Add table skycell to the database and the program
sctool (skycelltool but easier to type)

Location:

trunk/ippTools/share

Files:

• pxadmin_create_tables.sql (modified) (1 diff)
• pxadmin_drop_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2127 +2127 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE skycell (
+    tess_id     VARCHAR(64),
+    skycell_id  VARCHAR(64),
+    radeg       float,
+    decdeg      float,
+    glong       float,
+    glat        float,
+    width       float,
+    height      float,
+    PRIMARY KEY (tess_id, skycell_id),
+    KEY(radeg),
+    KEY(decdeg),
+    KEY(glong),
+    KEY(glat)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
 
 -- This comment line is here to avoid empty query error.

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -108 +108 @@
 DROP TABLE IF EXISTS skycalRun;
 DROP TABLE IF EXISTS skycalResult;
+DROP TABLE IF EXISTS skycell;
 
 SET FOREIGN_KEY_CHECKS=1