Files
label_editor/server/migrations/20260202004312_add_settings.sql

13 lines
304 B
SQL

-- Add migration script here
-- Create Label
CREATE TABLE settings
(
id bigint NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 ),
mhd text NOT NULL,
bio text NOT NULL
);
-- Insert default values
INSERT INTO settings (mhd, bio) VALUES ('Mindestens haltbar bis:', 'DE-ÖKO 006');