Card #61 GP Medicines, add optInStatus, optInHidden, optOutHidden, optInDate to UserFeature,
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_status" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_hidden" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_out_hidden" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_date" TIMESTAMP WITHOUT TIME ZONE;
Card #61 GP Medicines, add optInStatus, optInHidden, optOutHidden, optInDate to UserFeature,
UI to support opt in/out etc, hide feature is optInStatus === false to avoid showing those where user has opted out but is still in user feature list,
FeatureType.ECS -> FeatureType.GP_MEDICATION, including SQL
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_status" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_hidden" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_out_hidden" BOOLEAN;
ALTER TABLE "public"."pv_feature_user" ADD COLUMN "opt_in_date" TIMESTAMP WITHOUT TIME ZONE;
UPDATE pv_group SET code = 'GP_MEDICATION', group_name = 'Gp', group_short_name = 'Gp' WHERE code = 'ECS';
UPDATE pv_feature SET feature_name = 'GP_MEDICATION' WHERE feature_name = 'ECS'