14 lines
264 B
MySQL
14 lines
264 B
MySQL
|
-- 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;
|