69 lines
2.9 KiB
SQL
69 lines
2.9 KiB
SQL
|
CREATE TABLE IF NOT EXISTS `glpi_plugin_urbackup_configs` (
|
||
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`value` TEXT DEFAULT NULL,
|
||
|
|
`date_creation` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
`date_mod` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `name` (`name`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `glpi_plugin_urbackup_assettypes` (
|
||
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`itemtype` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`is_active` TINYINT NOT NULL DEFAULT 0,
|
||
|
|
`is_default` TINYINT NOT NULL DEFAULT 0,
|
||
|
|
`date_creation` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
`date_mod` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `itemtype` (`itemtype`),
|
||
|
|
KEY `is_active` (`is_active`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `glpi_plugin_urbackup_servers` (
|
||
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`entities_id` INT UNSIGNED NOT NULL DEFAULT 0,
|
||
|
|
`is_recursive` TINYINT NOT NULL DEFAULT 0,
|
||
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`locations_id` INT UNSIGNED NOT NULL DEFAULT 0,
|
||
|
|
`ip_address` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`port` INT UNSIGNED NOT NULL DEFAULT 55414,
|
||
|
|
`protocol` VARCHAR(10) NOT NULL DEFAULT 'http',
|
||
|
|
`server_version` VARCHAR(64) DEFAULT NULL,
|
||
|
|
`api_username` VARCHAR(255) DEFAULT NULL,
|
||
|
|
`api_password` TEXT DEFAULT NULL,
|
||
|
|
`ignore_ssl` TINYINT NOT NULL DEFAULT 0,
|
||
|
|
`is_active` TINYINT NOT NULL DEFAULT 1,
|
||
|
|
`last_api_status` TINYINT NOT NULL DEFAULT 0,
|
||
|
|
`last_api_message` TEXT DEFAULT NULL,
|
||
|
|
`last_api_check` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
`comment` TEXT DEFAULT NULL,
|
||
|
|
`date_creation` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
`date_mod` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `name` (`name`),
|
||
|
|
KEY `entities_id` (`entities_id`),
|
||
|
|
KEY `locations_id` (`locations_id`),
|
||
|
|
KEY `is_active` (`is_active`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `glpi_plugin_urbackup_serverassets` (
|
||
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`plugin_urbackup_servers_id` INT UNSIGNED NOT NULL DEFAULT 0,
|
||
|
|
`itemtype` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`items_id` INT UNSIGNED NOT NULL DEFAULT 0,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `plugin_urbackup_servers_id` (`plugin_urbackup_servers_id`),
|
||
|
|
KEY `item` (`itemtype`, `items_id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `glpi_plugin_urbackup_profiles` (
|
||
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`profiles_id` INT UNSIGNED NOT NULL DEFAULT 0,
|
||
|
|
`rightname` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`rights` INT NOT NULL DEFAULT 0,
|
||
|
|
`date_creation` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
`date_mod` TIMESTAMP NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `profile_right` (`profiles_id`, `rightname`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|