mirror of
https://github.com/Icinga/icingaweb2.git
synced 2025-09-05 00:58:09 +02:00
75 lines
3.2 KiB
SQL
75 lines
3.2 KiB
SQL
# Icinga Web 2 enhanced Dashboards
|
|
|
|
CREATE TABLE icingaweb_dashboard_owner (
|
|
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
username varchar(254) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
|
|
PRIMARY KEY (id),
|
|
UNIQUE KEY idx_icingaweb_dashboard_user_username (username)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE icingaweb_dashboard_home (
|
|
id int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
user_id int(10) unsigned NOT NULL,
|
|
name varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
label varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
priority tinyint NOT NULL,
|
|
type enum('public', 'private', 'shared') DEFAULT 'private',
|
|
disabled enum ('n', 'y') DEFAULT 'n',
|
|
PRIMARY KEY (id),
|
|
UNIQUE KEY idx_icingaweb_dashboard_home_user_name (user_id, name),
|
|
CONSTRAINT `fk_dashboard_home_dashboard_user` FOREIGN KEY (`user_id`)
|
|
REFERENCES icingaweb_dashboard_owner (id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE icingaweb_dashboard (
|
|
id binary(20) NOT NULL,
|
|
home_id int(10) unsigned NOT NULL,
|
|
name varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
label varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
priority tinyint NOT NULL,
|
|
PRIMARY KEY (id),
|
|
KEY fk_dashboard_dashboard_home (home_id),
|
|
CONSTRAINT fk_icingaweb_dashboard_icingaweb_dashboard_home FOREIGN KEY (home_id)
|
|
REFERENCES icingaweb_dashboard_home (id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE icingaweb_dashlet (
|
|
id binary(20) NOT NULL,
|
|
dashboard_id binary(20) NOT NULL,
|
|
name varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
label varchar(254) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
url varchar(2048) NOT NULL COLLATE utf8mb4_bin,
|
|
priority tinyint NOT NULL,
|
|
disabled enum ('n', 'y') DEFAULT 'n',
|
|
description text DEFAULT NULL COLLATE utf8mb4_unicode_ci,
|
|
PRIMARY KEY (id),
|
|
KEY `fk_icingaweb_dashlet_icingaweb_dashboard` (`dashboard_id`),
|
|
CONSTRAINT fk_icingaweb_dashlet_icingaweb_dashboard FOREIGN KEY (dashboard_id)
|
|
REFERENCES icingaweb_dashboard (id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE icingaweb_module_dashlet (
|
|
id binary(20) NOT NULL,
|
|
name varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
label varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
module varchar(64) NOT NULL COLLATE utf8mb4_unicode_ci,
|
|
pane varchar(64) DEFAULT NULL COLLATE utf8mb4_unicode_ci,
|
|
url varchar(2048) NOT NULL COLLATE utf8mb4_bin,
|
|
description text DEFAULT NULL COLLATE utf8mb4_unicode_ci,
|
|
priority tinyint DEFAULT 0,
|
|
PRIMARY KEY (id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE icingaweb_system_dashlet (
|
|
dashlet_id binary(20) NOT NULL,
|
|
module_dashlet_id binary(20) DEFAULT NULL,
|
|
|
|
PRIMARY KEY (dashlet_id),
|
|
|
|
CONSTRAINT fk_icingaweb_system_dashlet_icingaweb_dashlet FOREIGN KEY (dashlet_id)
|
|
REFERENCES icingaweb_dashlet (id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
CONSTRAINT fk_icingaweb_system_dashlet_icingaweb_module_dashlet FOREIGN KEY (module_dashlet_id)
|
|
REFERENCES icingaweb_module_dashlet (id) ON DELETE SET NULL ON UPDATE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|