app/migrations/20220203034730_create-initi...

36 lines
1023 B
MySQL
Raw Permalink Normal View History

2022-02-03 21:55:10 +00:00
-- Add migration script here
CREATE TABLE application (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
app_name TEXT NOT NULL,
url TEXT NOT NULL,
description TEXT,
2022-02-12 08:03:27 +00:00
active Boolean DEFAULT 1 NOT NULL,
glyph TEXT,
application_category_id INTEGER,
2022-02-12 08:03:27 +00:00
enable_healthcheck Boolean DEFAULT 0 NOT NULL
);
CREATE TABLE application_category (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
category_name TEXT NOT NULL,
glyph TEXT,
active BOOLEAN NOT NULL DEFAULT 1
);
CREATE TABLE bookmark (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
bookmark_name TEXT NOT NULL,
url TEXT NOT NULL,
active BOOLEAN NOT NULL DEFAULT 1,
bookmark_category_id INTEGER
);
CREATE TABLE bookmark_category (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
category_name TEXT NOT NULL,
active BOOLEAN NOT NULL DEFAULT 1,
glyph TEXT
);
CREATE TABLE setting (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
setting_name TEXT NOT NULL,
setting_value TEXT NOT NULL
);