14 lines
281 B
MySQL
14 lines
281 B
MySQL
|
-- 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 <> '');
|