Changeset 19760 for trunk/dbconfig/changes.txt

Timestamp:

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

Author:

bills

Message:

add table pstampProject

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -521 +521 @@
 ALTER TABLE rawImfile ADD COLUMN moon_alt   FLOAT AFTER moon_angle;
 ALTER TABLE rawImfile ADD COLUMN moon_phase FLOAT AFTER moon_alt;
+
+CREATE TABLE pstampProject (
+        proj_id BIGINT AUTO_INCREMENT,
+        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;
+
+