Viewing File: /home/ubuntu/code-backup/code_review/phabricator/resources/sql/patches/069.heraldxscript.sql

ALTER TABLE {$NAMESPACE}_herald.herald_transcript
  ADD garbageCollected BOOL NOT NULL DEFAULT 0;

UPDATE {$NAMESPACE}_herald.herald_transcript
  SET garbageCollected = 1
  WHERE objectTranscript = "";

ALTER TABLE {$NAMESPACE}_herald.herald_transcript
  ADD KEY (garbageCollected, time);