learn-request-queue/db/05-config.sql

15 lines
693 B
MySQL
Raw Permalink Normal View History

2020-08-08 04:32:06 +00:00
CREATE TABLE config (
rowlock bool DEFAULT TRUE UNIQUE NOT NULL CHECK (rowlock = TRUE),
2021-06-07 06:11:30 +00:00
normaluservotepoints int NOT NULL DEFAULT 10,
followervotepoints int NOT NULL DEFAULT 50,
subscribervotepoints int NOT NULL DEFAULT 100,
normaluserratelimit int NOT NULL DEFAULT 1,
followerratelimit int NOT NULL DEFAULT 2,
subscriberratelimit int NOT NULL DEFAULT 3,
title varchar NOT NULL DEFAULT '{username}''s Learn Request Queue',
colors jsonb NOT NULL DEFAULT '{"bg": {"primary": "#444444","table": "#282828","navbar": "#666666","error": "#ff0000"},"fg": {"primary": "#dddddd","ahover": "#ffffff","title": "#eeeeee"}}',
2020-08-08 04:32:06 +00:00
PRIMARY KEY (rowLock)
);
2021-06-07 06:11:30 +00:00
INSERT INTO config (rowlock) VALUES (true);