[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_herald.herald_transcript
   2    ADD garbageCollected BOOL NOT NULL DEFAULT 0;
   3  
   4  UPDATE {$NAMESPACE}_herald.herald_transcript
   5    SET garbageCollected = 1
   6    WHERE objectTranscript = "";
   7  
   8  ALTER TABLE {$NAMESPACE}_herald.herald_transcript
   9    ADD KEY (garbageCollected, time);