Changeset 24120 for branches/pap_magic/ippTools/share/pxadmin_create_tables.sql

Timestamp:

May 8, 2009, 5:21:35 PM (17 years ago)

Author:

Paul Price

Message:

Branching for magic development (make it work with warpwarp diffs).

Location:

branches/pap_magic

Files:

• . (copied) (copied from trunk )
• ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/pap_magic/ippTools/share/pxadmin_create_tables.sql

@@ -877 +877 @@
         KEY(state),
         KEY(skycell_id),
-        KEY(tess_id)
+        KEY(tess_id),
+        KEY(label)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -933 +934 @@
         registered DATETIME,
         tess_id VARCHAR(64),
+        bothways TINYINT DEFAULT 0,
+        exposure TINYINT DEFAULT 0,
         exp_id  BIGINT,
         magicked TINYINT,
@@ -939 +942 @@
         KEY(state),
         KEY(tess_id),
+        KEY(label),
         FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;