3 SELECT evergreen.upgrade_deps_block_check('1197', :eg_version);
5 INSERT INTO config.workstation_setting_type (name, grp, datatype, label)
7 'eg.hatch.enable.printing', 'gui', 'bool',
9 'eg.hatch.enable.printing',
10 'Use Hatch for printing',
19 PERFORM COUNT(*), workstation, name
20 FROM actor.workstation_setting GROUP BY 2, 3 HAVING COUNT(*) > 1;
27 The actor.workstation_setting table contains duplicate rows. The duplicates
28 should be removed before applying a new UNIQUE constraint. To find the rows,
29 execute the following SQL:
31 SELECT COUNT(*), workstation, name FROM actor.workstation_setting
32 GROUP BY 2, 3 HAVING COUNT(*) > 1;
34 Once the duplicates are cleared, execute the following SQL:
36 ALTER TABLE actor.workstation_setting
37 ADD CONSTRAINT ws_once_per_key UNIQUE (workstation, name);
44 ALTER TABLE actor.workstation_setting
45 ADD CONSTRAINT ws_once_per_key UNIQUE (workstation, name);