allow users to choose if client is involved in a step or not95cab6e6 months ago9 lines · 712 B | 1 | ALTER TABLE "settings" ALTER COLUMN "client_involvement" DROP DEFAULT;--> statement-breakpoint |
| 2 | ALTER TABLE "settings" ALTER COLUMN |
| 3 | CASE "client_involvement"::text |
| 4 | WHEN 'full' THEN ' |
| 5 | WHEN 'partial' THEN ' |
| 6 | WHEN 'none' THEN ' |
| 7 | END |
| 8 | );--> statement-breakpoint |
| 9 | DROP TYPE "public"."client_involvement |
"
client_involvement
"
SET
DATA
TYPE
jsonb
USING
(
{"proposals":"on","requirements":"on","milestones":"on","timesheets":"on","expenses":"on","invoices":"on"}
'
::jsonb
{"proposals":"off","requirements":"off","milestones":"off","timesheets":"off","expenses":"off","invoices":"on"}
'
::jsonb
{"proposals":"off","requirements":"off","milestones":"off","timesheets":"off","expenses":"off","invoices":"off"}
'
::jsonb
"
;