-- SPDX-FileCopyrightText: 2024 Simon Bruder <simon@sbruder.de>
--
-- SPDX-License-Identifier: AGPL-3.0-or-later

ALTER TABLE items
  ALTER name DROP NOT NULL;

UPDATE items
  SET name = NULL
  WHERE name = '';

ALTER TABLE items
  ADD CONSTRAINT name_not_empty CHECK(name <> '');
