bitque/migrations/2021-04-26-100410_add_user_settings/up.sql

13 lines
374 B
SQL

CREATE TYPE "TextEditorModeMapping" AS ENUM (
'md_only',
'rte_only',
'mixed'
);
CREATE TABLE IF NOT EXISTS user_settings
(
id serial not null unique primary key,
user_id int references users (id) not null,
text_editor_mode "TextEditorModeMapping" DEFAULT 'md_only' NOT NULL
);