069.heraldxscript.sql
60af8feab740production

069.heraldxscript.sql
View Options

			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);