summaryrefslogtreecommitdiff
path: root/util/updates/2020-08-24-reviews-nosummary.sql
blob: 7333a2fc8dc63a9b120f9c3a1b891dd2441dfcfa (plain)
1
2
3
4
5
6
ALTER TABLE reviews ADD COLUMN isfull boolean NOT NULL DEFAULT false;
UPDATE reviews SET isfull = text <> '';
UPDATE reviews SET text = summary WHERE NOT isfull;
UPDATE reviews SET text = summary || text WHERE isfull;
ALTER TABLE reviews ALTER COLUMN isfull DROP DEFAULT;
ALTER TABLE reviews DROP COLUMN summary;