Changeset 19760 for trunk/ippTools/share

Timestamp:

Sep 25, 2008, 2:05:59 PM (18 years ago)

Author:

bills

Message:

add table pstampProject

Location:

trunk/ippTools/share

Files:

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

trunk/ippTools/share/Makefile.am

@@ -118 +118 @@
      pstamptool_pendingjob.sql \
      pstamptool_pendingreq.sql \
+     pstamptool_project.sql \
      pxadmin_create_tables.sql \
      pxadmin_drop_tables.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1047 +1047 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE pstampProject (
+        proj_id BIGINT AUTO_INCREMENT,
+        name VARCHAR(64) UNIQUE,
+        state VARCHAR(64),
+        dbname VARCHAR(64),
+        dvodb VARCHAR(64),
+        camera VARCHAR(64),
+        telescope VARCHAR(64),
+        need_magic TINYINT,
+        PRIMARY KEY(proj_id),
+        KEY(proj_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE pstampRequest (
         req_id BIGINT AUTO_INCREMENT,

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -53 +53 @@
 DROP TABLE IF EXISTS flatcorrCamLink;
 DROP TABLE IF EXISTS pstampDataStore;
+DROP TABLE IF EXISTS pstampProject;
 DROP TABLE IF EXISTS pstampRequest;
 DROP TABLE IF EXISTS pstampJob;