Changeset 19760 for trunk/dbconfig

Timestamp:

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

Author:

bills

Message:

add table pstampProject

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• pstamp.md (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;
+
+

trunk/dbconfig/pstamp.md

@@ -5 +5 @@
     outProduct  STR         64
     uri         STR         255
+END
+
+pstampProject METADATA
+    proj_id     S64         0       # Primary Key AUTO_INCREMENT
+    name        STR         64      # UNIQUE
+    state       STR         64
+    dbname      STR         64
+    dvodb       STR         64
+    camera      STR         64
+    telescope   STR         64
+    need_magic  BOOL        f
 END