Changeset 33720 for trunk/ippTools

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

Files:

• share/pxadmin_create_tables.sql (modified) (1 diff)
• share/pxadmin_drop_tables.sql (modified) (1 diff)
• src/Makefile.am (modified) (3 diffs)
• src/sctool.c (added)
• src/sctool.h (added)

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

trunk/ippTools/src/Makefile.am

@@ -31 +31 @@
         mergetool \
         laptool \
-        vptool
+        vptool \
+        sctool
 
 pkginclude_HEADERS = \
@@ -83 +84 @@
         mergetool.h \
         laptool.h \
-        vptool.h
+        vptool.h \
+        sctool.h
 
 lib_LTLIBRARIES = libpxtools.la
@@ -316 +318 @@
     vptoolConfig.c
 
+sctool_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS)
+sctool_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la
+sctool_SOURCES = \
+    sctool.c \
+    sctoolConfig.c
+
 clean-local:
         -rm -f TAGS