Changeset 23713 for trunk/dbconfig

Timestamp:

Apr 6, 2009, 7:56:19 AM (17 years ago)

Author:

bills

Message:

change order of changes: can't set quality until the column is added.

File:

• trunk/dbconfig/changes.txt (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -981 +981 @@
 ALTER TABLE rawImfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
 
-UPDATE TABLE warpSkyfile SET quality = 8007 WHERE ignored != 0;
-ALTER TABLE warpSkyfile DROP COLUMN ignored;
 
 ALTER TABLE diffSkyfile ADD KEY(quality);
@@ -991 +989 @@
 ALTER TABLE rawImfile ADD KEY(quality);
 
+UPDATE TABLE warpSkyfile SET quality = 8007 WHERE ignored != 0;
+ALTER TABLE warpSkyfile DROP COLUMN ignored;
+
 -- Version 1.1.52