mirror of
https://github.com/Icinga/icingaweb2.git
synced 2025-07-31 01:34:09 +02:00
74 lines
3.1 KiB
SQL
74 lines
3.1 KiB
SQL
# Icinga Web 2 | (c) 2014 Icinga Development Team | GPLv2+
|
|
|
|
CREATE TABLE `icingaweb_group`(
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`parent` int(10) unsigned NULL DEFAULT NULL,
|
|
`ctime` timestamp NULL DEFAULT NULL,
|
|
`mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `idx_name` (`name`),
|
|
CONSTRAINT `fk_icingaweb_group_parent_id` FOREIGN KEY (`parent`)
|
|
REFERENCES `icingaweb_group` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE `icingaweb_group_membership`(
|
|
`group_id` int(10) unsigned NOT NULL,
|
|
`username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`ctime` timestamp NULL DEFAULT NULL,
|
|
`mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`group_id`,`username`),
|
|
CONSTRAINT `fk_icingaweb_group_membership_icingaweb_group` FOREIGN KEY (`group_id`)
|
|
REFERENCES `icingaweb_group` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE `icingaweb_user`(
|
|
`name` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`active` tinyint(1) NOT NULL,
|
|
`password_hash` varbinary(255) NOT NULL,
|
|
`ctime` timestamp NULL DEFAULT NULL,
|
|
`mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE `icingaweb_user_preference`(
|
|
`username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`section` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`value` varchar(255) NOT NULL,
|
|
`ctime` timestamp NULL DEFAULT NULL,
|
|
`mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`username`,`section`,`name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE `icingaweb_rememberme`(
|
|
id int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
username varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
passphrase varchar(256) NOT NULL,
|
|
random_iv varchar(32) NOT NULL,
|
|
http_user_agent text NOT NULL,
|
|
expires_at timestamp NULL DEFAULT NULL,
|
|
ctime timestamp NULL DEFAULT NULL,
|
|
mtime timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
|
|
CREATE TABLE `icingaweb_config_scope`(
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`module` varchar(254) NOT NULL DEFAULT 'default',
|
|
`name` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`hash` binary(20) NOT NULL COMMENT 'sha1(all option tuples)',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `idx_module_name` (`module`, `name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE `icingaweb_config_option`(
|
|
`scope_id` int(10) unsigned NOT NULL,
|
|
`name` varchar(254) NOT NULL,
|
|
`value` text DEFAULT NULL,
|
|
UNIQUE KEY `idx_scope_id_name` (`scope_id`, `name`),
|
|
CONSTRAINT `fk_scope_id_config_scope` FOREIGN KEY (`scope_id`)
|
|
REFERENCES `icingaweb_config_scope` (`id`)
|
|
ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|