quilling.dev
1-- Insert/update labeler definition
2-- Parameters: $1=labeler_actor_id, $2=label_identifier, $3=severity, $4=blurs,
3-- $5=default_setting, $6=adult_only, $7=locales
4INSERT INTO labeler_defs (labeler_actor_id, label_identifier, severity, blurs, default_setting, adult_only, locales)
5VALUES ($1, $2, $3::text::label_severity, $4::text::label_blurs, $5::text::label_default_setting, $6, $7)
6ON CONFLICT (labeler_actor_id, label_identifier) DO UPDATE
7 SET severity=EXCLUDED.severity,
8 blurs=EXCLUDED.blurs,
9 default_setting=EXCLUDED.default_setting,
10 adult_only=EXCLUDED.adult_only,
11 locales=EXCLUDED.locales