Changeset 20957 for branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql

Timestamp:

Dec 11, 2008, 9:43:20 AM (17 years ago)

Author:

bills

Message:

change order of columns to match final schema

File:

• branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql (modified) (1 diff)

branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql

@@ -1 +1 @@
 CREATE TEMPORARY TABLE skycellsToDiff (
 diff_id BIGINT,
+skycell_id VARCHAR(64),
 warp1 BIGINT,
+stack1 BIGINT,
 warp2 BIGINT,
-stack1 BIGINT,
 stack2 BIGINT,
-skycell_id VARCHAR(64),
-tess_id VARCHAR(64),
-PRIMARY KEY(diff_id, skycell_id)
+tess_id VARCHAR(64)
 ) ENGINE=MEMORY;