li7y/migrations/20240709133113_item_make_name_optional.down.sql

14 lines
264 B
MySQL
Raw Permalink Normal View History

-- SPDX-FileCopyrightText: 2024 Simon Bruder <simon@sbruder.de>
--
-- SPDX-License-Identifier: AGPL-3.0-or-later
ALTER TABLE items
DROP CONSTRAINT name_not_empty;
UPDATE items
SET name = ''
WHERE NAME IS NULL;
ALTER TABLE items
ALTER name SET NOT NULL;