Changeset 19558 for trunk/dbconfig

Timestamp:

Sep 15, 2008, 2:21:00 PM (18 years ago)

Author:

bills

Message:

changes to support cleanup, purge, and update processing

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• fake.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -466 +466 @@
 UPDATE warpSkyfile SET data_state = 'full';
 
+ALTER TABLE fakeProcessedImfile add column data_state varchar(64) after path_base;
+update fakeProcessedImfile set data_state ='full';
+

trunk/dbconfig/fake.md

@@ -21 +21 @@
     hostname        STR     64
     path_base       STR     255
+    data_state      STR     64      # Key
     fault           S16     0       # Key NOT NULL
     epoch           UTC         0001-01-01T00:00:00Z