resources/sql/patches/069.heraldxscript.sql at upstream/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / 069.heraldxscript.sql

at upstream/main 9 lines 289 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

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