File "nds.sql"
Full path: /opt/updates.edris.fr/NDS/Server/NSAS/RESSOURCES/nds.sql
File size: 72.7 KB
MIME-type: text/plain
Charset: utf-8
Download Open Edit Advanced Editor Back
/*
EDRIS NDS Database creation
Author : MAILLET Pierre-Yves
*/
CREATE DATABASE nds
CHARACTER SET = 'utf8mb3'
COLLATE = 'utf8mb3_general_ci';
USE nds;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for color
-- ----------------------------
DROP TABLE IF EXISTS `color`;
CREATE TABLE `color` (
`color_id` int(11) NOT NULL AUTO_INCREMENT,
`color_name` text DEFAULT NULL,
`color_bg_host_up` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_host_down` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_host_unreachable` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_host_ack` varchar(7) DEFAULT NULL,
`color_bg_service_ok` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_service_warning` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_service_unknown` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_service_pending` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_service_critical` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_bg_service_ack` varchar(7) DEFAULT NULL,
`color_background` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`color_text_host_up` varchar(7) DEFAULT '#000000',
`color_text_host_down` varchar(7) DEFAULT '#000000',
`color_text_host_unreachable` varchar(7) DEFAULT '#000000',
`color_text_host_ack` varchar(7) DEFAULT NULL,
`color_text_service_ok` varchar(7) DEFAULT '#000000',
`color_text_service_warning` varchar(7) DEFAULT '#000000',
`color_text_service_unknown` varchar(7) DEFAULT '#000000',
`color_text_service_pending` varchar(7) DEFAULT '#000000',
`color_text_service_critical` varchar(7) DEFAULT '#000000',
`color_text_service_ack` varchar(7) DEFAULT NULL,
`color_rect_blink_text` varchar(7) DEFAULT '#0000FF',
`color_infos_text` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '000000',
PRIMARY KEY (`color_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Définie les couleurs associés à une écran';
-- ----------------------------
-- Records of color
-- ----------------------------
BEGIN;
INSERT INTO `color` VALUES (1, 'default', '#19EE11', '#F91E05', '#82CFD8', '#00BFFF', '#13EB3A', '#faa500', '#C0C0C0', '#D4D5CC', '#F91E05', '#00BFFF', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#FFFFFF', '#FFFFFF');
INSERT INTO `color` VALUES (2, 'Style', '#33ff00', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#19EE11', '#F91E05', '#82CFD8', '#00BFFF', '#13EB3A', '#F8C706', '#2AD1D4', '#D4D5CC', '#F91D05', '#00BFFF', '#0000FF', '#FFFFFF');
INSERT INTO `color` VALUES (8, 'test2', '#660099', '#F91E05', '#82CFD8', '#00BFFF', '#13EB3A', '#F8C706', '#C0C0C0', '#D4D5CC', '#F91E05', '#00BFFF', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#000000', '#FFFFFF', '#FFFFFF');
COMMIT;
-- ----------------------------
-- Table structure for color_view_relation
-- ----------------------------
DROP TABLE IF EXISTS `color_view_relation`;
CREATE TABLE `color_view_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`view_view_id` int(11) NOT NULL,
`color_color_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `color_color_id` (`color_color_id`),
KEY `view_view_id` (`view_view_id`),
CONSTRAINT `color_view_relation_ibfk_2` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `color_view_relation_ibfk_3` FOREIGN KEY (`color_color_id`) REFERENCES `color` (`color_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for component
-- ----------------------------
DROP TABLE IF EXISTS `component`;
CREATE TABLE `component` (
`component_id` int(11) NOT NULL AUTO_INCREMENT,
`component_type` enum('rect','infos','detailspages','details','link','rectVirtualHost','nla','widget','graphs','container','nlaVirtualHost','stack','timeline','containerVirtualHost','larkmirror','train','workflow','eventslog','dragtv5','draw','droptv5','eventboard','eventGroupSummaries','workflowSubtitleAlerts','eventGroupCounters','conductorTrain','conductorAlerts','filteredRect','osMap') DEFAULT NULL,
`component_font` varchar(255) DEFAULT 'Arial' COMMENT 'Police d''écriture',
`component_isOpaque` tinyint(1) NOT NULL DEFAULT 1,
`component_font_size` int(11) DEFAULT 16 COMMENT 'Taille de la police',
`component_font_style` enum('plain','italic','bold') DEFAULT 'plain' COMMENT 'Style de la police ',
`component_icon` text DEFAULT NULL COMMENT 'Inutilisé',
`component_text` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`component_x` int(11) DEFAULT NULL COMMENT 'Position X',
`component_y` int(11) DEFAULT NULL COMMENT 'Position Y',
`component_width` int(11) DEFAULT NULL COMMENT 'Largeur',
`component_height` int(11) DEFAULT NULL COMMENT 'Hauteur',
`component_HAlignement` enum('RIGHT','CENTER','LEFT') DEFAULT 'LEFT' COMMENT 'Alignement Horizontal du component',
`component_HTextPosition` enum('RIGHT','CENTER','LEFT') DEFAULT 'RIGHT' COMMENT 'Alignement Horizontal du texte',
`component_iconTextGap` text DEFAULT NULL COMMENT 'Inutilisé',
`component_toolTipText` text DEFAULT NULL COMMENT 'Pourra etre rempli de la description de l''host',
`component_VAlignement` enum('TOP','CENTER','BOTTOM') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'CENTER' COMMENT 'Alignement Vertical du component',
`component_VTextPosition` enum('TOP','CENTER','BOTTOM') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'CENTER' COMMENT 'Alignement Vertical du text',
`component_defil` tinyint(1) DEFAULT 0,
`component_component_num` int(11) NOT NULL,
`component_zone_id` int(11) NOT NULL COMMENT 'Numéro du component (zone rect)',
`component_view_id` int(11) DEFAULT NULL,
`component_external_id` int(11) DEFAULT NULL COMMENT 'Contient l''id dans la table correspondant au type.\r\nPour un graph cela correspond au graph.graph_id',
`component_layer` tinyint(11) DEFAULT 0,
`component_action` text DEFAULT NULL,
`component_background` text DEFAULT NULL,
`component_foreground` text DEFAULT NULL,
`component_xml_external_id` text DEFAULT NULL,
`component_data_uid` text DEFAULT NULL,
`component_model_component_id` int(11) DEFAULT NULL,
`component_model_zone_id` int(11) DEFAULT NULL,
PRIMARY KEY (`component_id`),
KEY `component_view_id` (`component_view_id`),
KEY `component_zone_id` (`component_zone_id`),
CONSTRAINT `component_ibfk_1` FOREIGN KEY (`component_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `component_ibfk_2` FOREIGN KEY (`component_zone_id`) REFERENCES `zone` (`zone_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=295359 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Définie les variables pour un LABEL';
-- ----------------------------
-- Table structure for device
-- ----------------------------
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device` (
`device_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`device_uuid` varchar(255) NOT NULL,
`device_valid` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'if 0, player can''t complete connection (not validated by admin)',
`device_type` text NOT NULL,
`device_comment` text DEFAULT NULL,
`device_info` text DEFAULT NULL,
`device_conf` text DEFAULT NULL,
`device_online` int(11) DEFAULT NULL,
`device_token` text DEFAULT NULL,
`device_display_week_program` int(4) DEFAULT NULL,
`device_creation_date` timestamp NOT NULL DEFAULT current_timestamp(),
`device_connection_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`device_hidden` int(11) DEFAULT 0,
`device_anonymization` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Anonymization activation',
`device_anonymizationParameters` text DEFAULT NULL,
PRIMARY KEY (`device_uuid`),
KEY `device_display_week_program` (`device_display_week_program`),
CONSTRAINT `device_ibfk_1` FOREIGN KEY (`device_display_week_program`) REFERENCES `display_week_program` (`display_week_program_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for device_device_group_relation
-- ----------------------------
DROP TABLE IF EXISTS `device_device_group_relation`;
CREATE TABLE `device_device_group_relation` (
`device_device_group_relation_id` int(11) NOT NULL AUTO_INCREMENT,
`device_group_id` int(11) NOT NULL,
`device_uuid` varchar(255) NOT NULL,
PRIMARY KEY (`device_device_group_relation_id`),
KEY `FK_device_device_group_relation_device_group` (`device_group_id`),
KEY `FK_device_device_group_relation_device` (`device_uuid`),
CONSTRAINT `FK_device_device_group_relation_device` FOREIGN KEY (`device_uuid`) REFERENCES `device` (`device_uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_device_device_group_relation_device_group` FOREIGN KEY (`device_group_id`) REFERENCES `device_group` (`device_group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for device_group
-- ----------------------------
DROP TABLE IF EXISTS `device_group`;
CREATE TABLE `device_group` (
`device_group_id` int(11) NOT NULL AUTO_INCREMENT,
`device_group_name` text DEFAULT NULL,
PRIMARY KEY (`device_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for display
-- ----------------------------
DROP TABLE IF EXISTS `display`;
CREATE TABLE `display` (
`display_id` int(11) NOT NULL AUTO_INCREMENT,
`display_device_uuid` varchar(255) DEFAULT NULL,
`display_conf` text DEFAULT NULL,
`display_height` int(11) DEFAULT NULL,
`display_width` int(11) DEFAULT NULL,
`display_x` int(11) NOT NULL,
`display_y` int(11) NOT NULL,
`display_remote_id` int(11) NOT NULL,
`display_mode` text DEFAULT NULL,
PRIMARY KEY (`display_id`),
KEY `display_device_uuid` (`display_device_uuid`) USING BTREE,
CONSTRAINT `display_ibfk_1` FOREIGN KEY (`display_device_uuid`) REFERENCES `device` (`device_uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=718 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for display_command
-- ----------------------------
DROP TABLE IF EXISTS `display_command`;
CREATE TABLE `display_command` (
`display_command_id` int(11) NOT NULL AUTO_INCREMENT,
`display_command_name` text NOT NULL,
`display_command_on` text DEFAULT NULL,
`display_command_off` text DEFAULT NULL,
`display_command_input` text DEFAULT NULL,
`display_command_inputList` text DEFAULT NULL COMMENT 'Caractère = et ; interdit ! car séparateur',
`display_command_ratio` text DEFAULT NULL,
`display_command_ratioList` text DEFAULT NULL,
`display_command_volume` text DEFAULT NULL,
`display_command_contrast` text DEFAULT NULL,
`display_command_backlight` text DEFAULT NULL,
`display_command_luminosity` text DEFAULT NULL,
`display_command_ecoenergy` text DEFAULT NULL,
`display_command_stop` text DEFAULT NULL,
`display_command_return` text DEFAULT NULL,
PRIMARY KEY (`display_command_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Command to control view by serial port';
-- ----------------------------
-- Records of display_command
-- ----------------------------
BEGIN;
INSERT INTO `display_command` VALUES (1, 'LG-42LY95', 'ka 0 1', 'ka 0 0', 'kb 0 [LIST]', '0=DTV;1=Analogique;2=AV1;3=AV2;4=AV3;5=Composant;6=RGB-PC;7=HDMI1;8=HDMI2;9=HDMI3', 'kc 0 [LIST]', '1=Normal view;2=16:9;3=Horizon;4=Zoom1;5=Zoom2;6=Original;7=14:9;8=Plein écran;9=1:1 Pixel', 'kf 0 [0-64]', 'kg 0 [0-64]', NULL, 'kh 0 [0-64]', 'jq 0 [0,1]', 'x', 'OK');
INSERT INTO `display_command` VALUES (2, 'LG-42SL9000', 'ka 0 01', 'ka 0 00', 'xb 0 [LIST]', '0=DTV;8=Analogique;32=AV1;33=AV2;34=AV3;35=AV4;64=Composant;96=RVB;144=HDMI1;145=HDMI2;146=HDMI3', 'kc 0 [LIST]', '1=Normal view;2=16:9;4=Zoom1;6=Format Original;7=14:9;9=Plein écran;0B=Signal Original;10=Zoom cinéma', 'kf 0 [00-64]', 'kg 0 [00-64]', 'mg 0 [00-64]', 'kh 0 [00-64]', 'jq 0 [0-4]', 'x', 'OK');
COMMIT;
-- ----------------------------
-- Table structure for display_day_program
-- ----------------------------
DROP TABLE IF EXISTS `display_day_program`;
CREATE TABLE `display_day_program` (
`display_day_program_id` int(11) NOT NULL AUTO_INCREMENT,
`display_day_program_name` text NOT NULL,
`display_day_program_serial_adapter_id` int(11) DEFAULT NULL,
`display_day_program_display_command_id` int(11) DEFAULT NULL,
PRIMARY KEY (`display_day_program_id`),
KEY `display_day_program_idbfk_1` (`display_day_program_serial_adapter_id`),
KEY `display_day_program_idbfk_2` (`display_day_program_display_command_id`),
CONSTRAINT `display_day_program_idbfk_1` FOREIGN KEY (`display_day_program_serial_adapter_id`) REFERENCES `serial_adapter` (`serial_adapter_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `display_day_program_idbfk_2` FOREIGN KEY (`display_day_program_display_command_id`) REFERENCES `display_command` (`display_command_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of display_day_program
-- ----------------------------
BEGIN;
INSERT INTO `display_day_program` VALUES (3, 'LG42-Jours de la semaine', 1, 1);
INSERT INTO `display_day_program` VALUES (4, 'LG42-JourDuWeekEnd', 1, 1);
INSERT INTO `display_day_program` VALUES (5, '8h30 18h00', 1, 1);
COMMIT;
-- ----------------------------
-- Table structure for display_period_program
-- ----------------------------
DROP TABLE IF EXISTS `display_period_program`;
CREATE TABLE `display_period_program` (
`display_period_program_id` int(11) NOT NULL AUTO_INCREMENT,
`display_period_program_display_day_program_id` int(11) NOT NULL,
`display_period_program_start` int(11) NOT NULL COMMENT 'Heure au format [heure][minute] : ex: 10h03 = 1003',
`display_period_program_end` int(11) NOT NULL COMMENT 'Heure au format [heure][minute] : ex: 10h03 = 1003',
`display_period_program_powerStatus` int(1) NOT NULL DEFAULT 1,
`display_period_program_input` text DEFAULT NULL,
`display_period_program_ratio` text DEFAULT NULL,
`display_period_program_backlight` text DEFAULT NULL,
`display_period_program_luminosity` text DEFAULT NULL,
`display_period_program_contrast` text DEFAULT NULL,
`display_period_program_volume` text DEFAULT NULL,
`display_period_program_ecoenergy` text DEFAULT NULL,
PRIMARY KEY (`display_period_program_id`),
KEY `displayPeriodProgram_displayDayProgram_id` (`display_period_program_display_day_program_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of display_period_program
-- ----------------------------
BEGIN;
INSERT INTO `display_period_program` VALUES (5, 3, 0, 830, 0, NULL, '', NULL, '', '', '', '');
INSERT INTO `display_period_program` VALUES (6, 3, 830, 1200, 1, '7', '9', '100', '64', '64', '32', '0');
INSERT INTO `display_period_program` VALUES (8, 3, 1200, 1830, 1, '7', '9', '100', '64', '64', '32', '0');
INSERT INTO `display_period_program` VALUES (9, 3, 1830, 2359, 0, NULL, '', NULL, '', '', '', '');
INSERT INTO `display_period_program` VALUES (10, 4, 0, 2359, 0, '0', '', '0', '', '', '', '');
INSERT INTO `display_period_program` VALUES (11, 5, 0, 830, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (12, 5, 830, 1800, 1, '7', '9', '100', '64', '64', '0', NULL);
INSERT INTO `display_period_program` VALUES (13, 5, 1800, 2359, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (14, -1, 0, 0, 1, NULL, '', '', '', '', '', '');
INSERT INTO `display_period_program` VALUES (15, -1, 0, 0, 1, NULL, '', '', '', '', '', '');
INSERT INTO `display_period_program` VALUES (16, 6, 1, 1300, 1, NULL, '', '', '', '', '41', '');
INSERT INTO `display_period_program` VALUES (17, 6, 1301, 2300, 0, NULL, '', '', '', '', '', '');
INSERT INTO `display_period_program` VALUES (18, 8, 0, 2300, 0, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (19, 8, 2300, 2359, 1, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (20, 9, 0, 0, 0, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (21, 12, 0, 1600, 0, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (22, 12, 1200, 700, 0, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (23, 13, 0, 2300, 0, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (24, 6, 2301, 2302, 1, NULL, NULL, NULL, '', NULL, NULL, NULL);
INSERT INTO `display_period_program` VALUES (25, 7, 200, 201, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;
-- ----------------------------
-- Table structure for display_plan_relation
-- ----------------------------
DROP TABLE IF EXISTS `display_plan_relation`;
CREATE TABLE `display_plan_relation` (
`display_plan_relation` int(11) NOT NULL AUTO_INCREMENT,
`display_id` int(11) NOT NULL,
`plan_id` int(11) NOT NULL,
PRIMARY KEY (`display_plan_relation`),
KEY `display_id` (`display_id`),
KEY `display_plan_relation_ibfk_2` (`plan_id`),
CONSTRAINT `display_plan_relation_ibfk_1` FOREIGN KEY (`display_id`) REFERENCES `display` (`display_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `display_plan_relation_ibfk_2` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=514 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for display_view_relation
-- ----------------------------
DROP TABLE IF EXISTS `display_view_relation`;
CREATE TABLE `display_view_relation` (
`display_view_relation_id` int(11) NOT NULL AUTO_INCREMENT,
`display_display_id` int(11) NOT NULL,
`view_view_id` int(11) NOT NULL,
`view_zoneToShow` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`wall_uuid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
PRIMARY KEY (`display_view_relation_id`),
KEY `display_display_id` (`display_display_id`) USING BTREE,
KEY `view_view_id` (`view_view_id`) USING BTREE,
CONSTRAINT `display_view_relation_ibfk_1` FOREIGN KEY (`display_display_id`) REFERENCES `display` (`display_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `display_view_relation_ibfk_2` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6420 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for display_virtualElement_relation
-- ----------------------------
DROP TABLE IF EXISTS `display_virtualElement_relation`;
CREATE TABLE `display_virtualElement_relation` (
`display_virtualElement_relation_id` int(11) NOT NULL AUTO_INCREMENT,
`virtualElement_vitualElement_id` int(11) NOT NULL,
`display_display_id` int(11) NOT NULL,
PRIMARY KEY (`display_virtualElement_relation_id`),
KEY `virtualElement_vitualElement_id` (`virtualElement_vitualElement_id`),
KEY `display_display_id` (`display_display_id`),
CONSTRAINT `display_virtualElement_relation_ibfk_1` FOREIGN KEY (`virtualElement_vitualElement_id`) REFERENCES `virtualHost` (`virtualHost_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `display_virtualElement_relation_ibfk_2` FOREIGN KEY (`display_display_id`) REFERENCES `display` (`display_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for display_week_program
-- ----------------------------
DROP TABLE IF EXISTS `display_week_program`;
CREATE TABLE `display_week_program` (
`display_week_program_id` int(11) NOT NULL AUTO_INCREMENT,
`display_week_program_name` text NOT NULL,
`display_week_program_serial_adapter_id` int(11) NOT NULL,
`display_week_program_display_command_id` int(11) NOT NULL,
`display_week_program_monday` int(11) DEFAULT NULL,
`display_week_program_tuesday` int(11) DEFAULT NULL,
`display_week_program_wednesday` int(11) DEFAULT NULL,
`display_week_program_thursday` int(11) DEFAULT NULL,
`display_week_program_friday` int(11) DEFAULT NULL,
`display_week_program_saturday` int(11) DEFAULT NULL,
`display_week_program_sunday` int(11) DEFAULT NULL,
PRIMARY KEY (`display_week_program_id`),
KEY `display_week_program_monday` (`display_week_program_monday`) USING BTREE,
KEY `display_week_program_tuesday` (`display_week_program_tuesday`) USING BTREE,
KEY `display_week_program_wednesday` (`display_week_program_wednesday`) USING BTREE,
KEY `display_week_program_thursday` (`display_week_program_thursday`) USING BTREE,
KEY `display_week_program_friday` (`display_week_program_friday`) USING BTREE,
KEY `display_week_program_saturday` (`display_week_program_saturday`) USING BTREE,
KEY `display_week_program_sunday` (`display_week_program_sunday`) USING BTREE,
KEY `display_week_program_ibfk_8` (`display_week_program_serial_adapter_id`),
KEY `display_week_program_ibfk_9` (`display_week_program_display_command_id`),
CONSTRAINT `display_week_program_ibfk_1` FOREIGN KEY (`display_week_program_monday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_2` FOREIGN KEY (`display_week_program_tuesday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_3` FOREIGN KEY (`display_week_program_wednesday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_4` FOREIGN KEY (`display_week_program_thursday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_5` FOREIGN KEY (`display_week_program_friday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_6` FOREIGN KEY (`display_week_program_saturday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `display_week_program_ibfk_7` FOREIGN KEY (`display_week_program_sunday`) REFERENCES `display_day_program` (`display_day_program_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 1016832 kB; (`displayWeekProgram_sunday`) REFER';
-- ----------------------------
-- Records of display_week_program
-- ----------------------------
BEGIN;
INSERT INTO `display_week_program` VALUES (2, 'CRT 8h30 - 18h30', 1, 1, 3, 3, 3, 3, 3, 4, 4);
INSERT INTO `display_week_program` VALUES (3, 'CRT Angers 8h30 - 18h00', 1, 1, 5, 5, 5, 5, 5, 4, 4);
INSERT INTO `display_week_program` VALUES (4, 'SEMAINE', -1, -1, 3, 3, 3, 3, 3, 3, 4);
COMMIT;
-- ----------------------------
-- Table structure for filter
-- ----------------------------
DROP TABLE IF EXISTS `filter`;
CREATE TABLE `filter` (
`filter_id` int(11) NOT NULL AUTO_INCREMENT,
`filter_type` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`filter_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`filter_description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`filter_rules` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
PRIMARY KEY (`filter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of filter
-- ----------------------------
BEGIN;
INSERT INTO `filter` VALUES (4, 'stack', 'TV5 STACK', 'TV5 STACK', '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><rules type=\"stack\"><rule enabled=\"true\">DEM;INGESTIMX30;;;IMX30;</rule><rule enabled=\"true\">DEM;INGESTK7;;;NUMK7;</rule><rule enabled=\"true\">DEM;INGESTFILE;;;FICHIERS;</rule><rule enabled=\"true\">DEM;INGESTSUBTITLE;;;SOUS_TITRES;</rule><rule enabled=\"true\">DEM;INGESTFLUX;;;LIVE;</rule><rule enabled=\"true\">DEM;;;;TYPE_INDEFINI;</rule><rule enabled=\"true\">ACQ;;;;NUM;</rule><rule enabled=\"true\">QC;;NPAD;;QC;</rule><rule enabled=\"true\">QC;;;NPAD;QC;</rule><rule enabled=\"true\">QC;;PAD;PAD;PAD-PAD;</rule><rule enabled=\"true\">QC;;PAD;Indiffusable;PAD-Indiffusable;</rule><rule enabled=\"true\">QC;;Indiffusable;PAD;Indiffusable-PAD;</rule><rule enabled=\"true\">QC;;Indiffusable;Indiffusable;Indiffusable-Indiffusable;</rule><rule enabled=\"true\">QC;;;;QC;</rule><rule enabled=\"true\">QC;;Indiffusable;;technique;</rule><rule enabled=\"true\">QC;;NPAD;;QC;</rule><rule enabled=\"true\">QC;;PAD;NPAD;QC;</rule><rule enabled=\"true\">QC;;PAD;PAD;PAD;</rule><rule enabled=\"true\">QC;;PAD;Indiffusable;edito;</rule><rule enabled=\"true\">QC;;;;QC;</rule></rules>');
COMMIT;
-- ----------------------------
-- Table structure for graph
-- ----------------------------
DROP TABLE IF EXISTS `graph`;
CREATE TABLE `graph` (
`graph_id` int(11) NOT NULL AUTO_INCREMENT,
`graph_duration` int(11) NOT NULL DEFAULT 14480,
`ods_index_id` int(11) DEFAULT NULL,
`graph_type` enum('thermometer','meter','battery','batteryLoad','batteryCapacity','isilon','pie3d','lcd','hbar','meterSteelSeries1','meterSteelSeries2','temperatureArea','xy','flatSimpleCircleGauge','flatDoubleCircleGauge','flatSimpleBarGauge','topList','flatPercentCircleGauge','test','waterTower','waterSeal') DEFAULT NULL,
`graph_nagios_object_id` int(11) DEFAULT NULL,
`graph_data_uid` text DEFAULT NULL,
`graph_model_graph_id` int(11) DEFAULT NULL,
PRIMARY KEY (`graph_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5861 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group
-- ----------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`group_is_admin` tinyint(1) NOT NULL DEFAULT 0,
`group_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`group_quota_img` int(11) DEFAULT 0,
`group_quota_space_img` int(11) DEFAULT 0,
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group
-- ----------------------------
BEGIN;
INSERT INTO `group` VALUES (8, 1, 'ADMIN', 0, 0);
INSERT INTO `group` VALUES (24, 0, 'Trainees', 0, 0);
INSERT INTO `group` VALUES (25, 0, 'ReFactory', 0, 0);
COMMIT;
-- ----------------------------
-- Table structure for group_device_group_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_device_group_relation`;
CREATE TABLE `group_device_group_relation` (
`device_group_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `widget_widget_id` (`device_group_id`),
CONSTRAINT `FK_group_device_group_relation_device_group` FOREIGN KEY (`device_group_id`) REFERENCES `device_group` (`device_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_group_device_group_relation_group` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group_device_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_device_relation`;
CREATE TABLE `group_device_relation` (
`group_group_id` int(11) NOT NULL,
`device_device_uuid` varchar(255) NOT NULL,
KEY `group_group_id` (`group_group_id`) USING BTREE,
KEY `device_device_uuid` (`device_device_uuid`) USING BTREE,
CONSTRAINT `group_device_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_device_relation_ibfk_2` FOREIGN KEY (`device_device_uuid`) REFERENCES `device` (`device_uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group_object_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_object_relation`;
CREATE TABLE `group_object_relation` (
`nagios_object_id` int(11) DEFAULT NULL,
`group_group_id` int(11) NOT NULL,
`data_uid` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
KEY `group_group_id` (`group_group_id`),
CONSTRAINT `group_object_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group_plan_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_plan_relation`;
CREATE TABLE `group_plan_relation` (
`plan_plan_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `plan_plan_id` (`plan_plan_id`) USING BTREE,
CONSTRAINT `FK_group_plan_relation_plan` FOREIGN KEY (`plan_plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_plan_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group_topology_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_topology_relation`;
CREATE TABLE `group_topology_relation` (
`topology_topology_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `FK_group_topology_relation_topology` (`topology_topology_id`),
KEY `FK_group_topology_relation_group` (`group_group_id`),
CONSTRAINT `FK_group_topology_relation_group` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_group_topology_relation_topology` FOREIGN KEY (`topology_topology_id`) REFERENCES `topology` (`topology_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group_topology_relation
-- ----------------------------
BEGIN;
INSERT INTO `group_topology_relation` VALUES (44, 8);
INSERT INTO `group_topology_relation` VALUES (45, 8);
INSERT INTO `group_topology_relation` VALUES (46, 8);
INSERT INTO `group_topology_relation` VALUES (47, 8);
INSERT INTO `group_topology_relation` VALUES (48, 8);
INSERT INTO `group_topology_relation` VALUES (49, 8);
INSERT INTO `group_topology_relation` VALUES (50, 8);
INSERT INTO `group_topology_relation` VALUES (51, 8);
INSERT INTO `group_topology_relation` VALUES (52, 8);
INSERT INTO `group_topology_relation` VALUES (53, 8);
INSERT INTO `group_topology_relation` VALUES (10, 8);
INSERT INTO `group_topology_relation` VALUES (54, 8);
INSERT INTO `group_topology_relation` VALUES (55, 8);
INSERT INTO `group_topology_relation` VALUES (11, 8);
INSERT INTO `group_topology_relation` VALUES (56, 8);
INSERT INTO `group_topology_relation` VALUES (12, 8);
INSERT INTO `group_topology_relation` VALUES (57, 8);
INSERT INTO `group_topology_relation` VALUES (13, 8);
INSERT INTO `group_topology_relation` VALUES (14, 8);
INSERT INTO `group_topology_relation` VALUES (58, 8);
INSERT INTO `group_topology_relation` VALUES (15, 8);
INSERT INTO `group_topology_relation` VALUES (59, 8);
INSERT INTO `group_topology_relation` VALUES (16, 8);
INSERT INTO `group_topology_relation` VALUES (17, 8);
INSERT INTO `group_topology_relation` VALUES (18, 8);
INSERT INTO `group_topology_relation` VALUES (19, 8);
INSERT INTO `group_topology_relation` VALUES (1, 8);
INSERT INTO `group_topology_relation` VALUES (2, 8);
INSERT INTO `group_topology_relation` VALUES (3, 8);
INSERT INTO `group_topology_relation` VALUES (4, 8);
INSERT INTO `group_topology_relation` VALUES (5, 8);
INSERT INTO `group_topology_relation` VALUES (6, 8);
INSERT INTO `group_topology_relation` VALUES (7, 8);
INSERT INTO `group_topology_relation` VALUES (8, 8);
INSERT INTO `group_topology_relation` VALUES (9, 8);
INSERT INTO `group_topology_relation` VALUES (60, 8);
INSERT INTO `group_topology_relation` VALUES (61, 8);
INSERT INTO `group_topology_relation` VALUES (62, 8);
INSERT INTO `group_topology_relation` VALUES (63, 8);
INSERT INTO `group_topology_relation` VALUES (20, 8);
INSERT INTO `group_topology_relation` VALUES (64, 8);
INSERT INTO `group_topology_relation` VALUES (21, 8);
INSERT INTO `group_topology_relation` VALUES (65, 8);
INSERT INTO `group_topology_relation` VALUES (22, 8);
INSERT INTO `group_topology_relation` VALUES (66, 8);
INSERT INTO `group_topology_relation` VALUES (23, 8);
INSERT INTO `group_topology_relation` VALUES (67, 8);
INSERT INTO `group_topology_relation` VALUES (24, 8);
INSERT INTO `group_topology_relation` VALUES (68, 8);
INSERT INTO `group_topology_relation` VALUES (25, 8);
INSERT INTO `group_topology_relation` VALUES (69, 8);
INSERT INTO `group_topology_relation` VALUES (26, 8);
INSERT INTO `group_topology_relation` VALUES (27, 8);
INSERT INTO `group_topology_relation` VALUES (28, 8);
INSERT INTO `group_topology_relation` VALUES (29, 8);
INSERT INTO `group_topology_relation` VALUES (70, 8);
INSERT INTO `group_topology_relation` VALUES (71, 8);
INSERT INTO `group_topology_relation` VALUES (30, 8);
INSERT INTO `group_topology_relation` VALUES (31, 8);
INSERT INTO `group_topology_relation` VALUES (32, 8);
INSERT INTO `group_topology_relation` VALUES (33, 8);
INSERT INTO `group_topology_relation` VALUES (34, 8);
INSERT INTO `group_topology_relation` VALUES (35, 8);
INSERT INTO `group_topology_relation` VALUES (36, 8);
INSERT INTO `group_topology_relation` VALUES (37, 8);
INSERT INTO `group_topology_relation` VALUES (38, 8);
INSERT INTO `group_topology_relation` VALUES (39, 8);
INSERT INTO `group_topology_relation` VALUES (40, 8);
INSERT INTO `group_topology_relation` VALUES (41, 8);
INSERT INTO `group_topology_relation` VALUES (42, 8);
INSERT INTO `group_topology_relation` VALUES (43, 8);
INSERT INTO `group_topology_relation` VALUES (15, 24);
INSERT INTO `group_topology_relation` VALUES (60, 24);
INSERT INTO `group_topology_relation` VALUES (61, 24);
INSERT INTO `group_topology_relation` VALUES (62, 24);
INSERT INTO `group_topology_relation` VALUES (45, 24);
INSERT INTO `group_topology_relation` VALUES (46, 24);
INSERT INTO `group_topology_relation` VALUES (47, 24);
INSERT INTO `group_topology_relation` VALUES (1, 24);
INSERT INTO `group_topology_relation` VALUES (17, 24);
INSERT INTO `group_topology_relation` VALUES (21, 24);
INSERT INTO `group_topology_relation` VALUES (11, 24);
INSERT INTO `group_topology_relation` VALUES (8, 24);
INSERT INTO `group_topology_relation` VALUES (49, 24);
INSERT INTO `group_topology_relation` VALUES (2, 24);
INSERT INTO `group_topology_relation` VALUES (25, 24);
INSERT INTO `group_topology_relation` VALUES (27, 24);
INSERT INTO `group_topology_relation` VALUES (28, 24);
INSERT INTO `group_topology_relation` VALUES (29, 24);
INSERT INTO `group_topology_relation` VALUES (30, 24);
INSERT INTO `group_topology_relation` VALUES (13, 24);
INSERT INTO `group_topology_relation` VALUES (12, 24);
INSERT INTO `group_topology_relation` VALUES (6, 24);
INSERT INTO `group_topology_relation` VALUES (41, 24);
INSERT INTO `group_topology_relation` VALUES (42, 24);
INSERT INTO `group_topology_relation` VALUES (43, 24);
INSERT INTO `group_topology_relation` VALUES (44, 24);
INSERT INTO `group_topology_relation` VALUES (4, 24);
INSERT INTO `group_topology_relation` VALUES (34, 24);
INSERT INTO `group_topology_relation` VALUES (36, 24);
INSERT INTO `group_topology_relation` VALUES (5, 24);
INSERT INTO `group_topology_relation` VALUES (37, 24);
INSERT INTO `group_topology_relation` VALUES (39, 24);
INSERT INTO `group_topology_relation` VALUES (40, 24);
INSERT INTO `group_topology_relation` VALUES (14, 25);
INSERT INTO `group_topology_relation` VALUES (1, 25);
INSERT INTO `group_topology_relation` VALUES (17, 25);
INSERT INTO `group_topology_relation` VALUES (18, 25);
INSERT INTO `group_topology_relation` VALUES (19, 25);
INSERT INTO `group_topology_relation` VALUES (20, 25);
INSERT INTO `group_topology_relation` VALUES (21, 25);
INSERT INTO `group_topology_relation` VALUES (22, 25);
INSERT INTO `group_topology_relation` VALUES (23, 25);
INSERT INTO `group_topology_relation` VALUES (24, 25);
INSERT INTO `group_topology_relation` VALUES (66, 25);
INSERT INTO `group_topology_relation` VALUES (67, 25);
INSERT INTO `group_topology_relation` VALUES (68, 25);
INSERT INTO `group_topology_relation` VALUES (11, 25);
INSERT INTO `group_topology_relation` VALUES (2, 25);
INSERT INTO `group_topology_relation` VALUES (25, 25);
INSERT INTO `group_topology_relation` VALUES (26, 25);
INSERT INTO `group_topology_relation` VALUES (27, 25);
INSERT INTO `group_topology_relation` VALUES (28, 25);
INSERT INTO `group_topology_relation` VALUES (29, 25);
INSERT INTO `group_topology_relation` VALUES (30, 25);
INSERT INTO `group_topology_relation` VALUES (69, 25);
INSERT INTO `group_topology_relation` VALUES (70, 25);
INSERT INTO `group_topology_relation` VALUES (71, 25);
INSERT INTO `group_topology_relation` VALUES (13, 25);
INSERT INTO `group_topology_relation` VALUES (12, 25);
INSERT INTO `group_topology_relation` VALUES (6, 25);
INSERT INTO `group_topology_relation` VALUES (41, 25);
INSERT INTO `group_topology_relation` VALUES (43, 25);
INSERT INTO `group_topology_relation` VALUES (44, 25);
INSERT INTO `group_topology_relation` VALUES (4, 25);
INSERT INTO `group_topology_relation` VALUES (34, 25);
INSERT INTO `group_topology_relation` VALUES (35, 25);
INSERT INTO `group_topology_relation` VALUES (36, 25);
INSERT INTO `group_topology_relation` VALUES (5, 25);
INSERT INTO `group_topology_relation` VALUES (37, 25);
INSERT INTO `group_topology_relation` VALUES (38, 25);
INSERT INTO `group_topology_relation` VALUES (39, 25);
INSERT INTO `group_topology_relation` VALUES (40, 25);
INSERT INTO `group_topology_relation` VALUES (64, 25);
INSERT INTO `group_topology_relation` VALUES (65, 25);
INSERT INTO `group_topology_relation` VALUES (63, 25);
COMMIT;
-- ----------------------------
-- Table structure for group_view_group_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_view_group_relation`;
CREATE TABLE `group_view_group_relation` (
`view_group_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `widget_widget_id` (`view_group_id`),
CONSTRAINT `FK_group_view_group_relation_view_group` FOREIGN KEY (`view_group_id`) REFERENCES `view_group` (`view_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_view_group_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group_view_group_relation
-- ----------------------------
BEGIN;
INSERT INTO `group_view_group_relation` VALUES (1, 24);
COMMIT;
-- ----------------------------
-- Table structure for group_view_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_view_relation`;
CREATE TABLE `group_view_relation` (
`view_view_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `view_view_id` (`view_view_id`),
CONSTRAINT `group_view_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_view_relation_ibfk_2` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for group_virtualHost_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_virtualHost_relation`;
CREATE TABLE `group_virtualHost_relation` (
`virtualHost_virtualHost_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `virtualHost_virtualHost_id` (`virtualHost_virtualHost_id`),
CONSTRAINT `group_virtualHost_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_virtualHost_relation_ibfk_2` FOREIGN KEY (`virtualHost_virtualHost_id`) REFERENCES `virtualHost` (`virtualHost_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group_virtualHost_relation
-- ----------------------------
BEGIN;
INSERT INTO `group_virtualHost_relation` VALUES (144, 24);
COMMIT;
-- ----------------------------
-- Table structure for group_widget_relation
-- ----------------------------
DROP TABLE IF EXISTS `group_widget_relation`;
CREATE TABLE `group_widget_relation` (
`widget_widget_id` int(11) NOT NULL,
`group_group_id` int(11) NOT NULL,
KEY `group_group_id` (`group_group_id`),
KEY `widget_widget_id` (`widget_widget_id`),
CONSTRAINT `group_widget_relation_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `group_widget_relation_ibfk_2` FOREIGN KEY (`widget_widget_id`) REFERENCES `widget` (`widget_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for link
-- ----------------------------
DROP TABLE IF EXISTS `link`;
CREATE TABLE `link` (
`link_id` int(11) NOT NULL AUTO_INCREMENT,
`link_x1` int(11) DEFAULT NULL,
`link_y1` int(11) DEFAULT NULL,
`link_x2` int(11) DEFAULT NULL,
`link_y2` int(11) DEFAULT NULL,
`link_nagios_object_id` int(11) DEFAULT NULL,
`link_x3` int(11) DEFAULT NULL,
`link_y3` int(11) DEFAULT NULL,
`link_percentage1` int(11) DEFAULT 75,
`link_percentage2` int(11) DEFAULT 75,
`link_data_uid` text DEFAULT NULL,
`link_model_link_id` int(11) DEFAULT NULL,
`link_strokesize1` int(11) DEFAULT 7,
`link_strokesize2` int(11) DEFAULT 7,
PRIMARY KEY (`link_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16319 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT,
`level` text DEFAULT NULL,
`message` text DEFAULT NULL,
`time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`user` text NOT NULL,
`controller` text DEFAULT NULL,
`version` text DEFAULT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38359 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for plan
-- ----------------------------
DROP TABLE IF EXISTS `plan`;
CREATE TABLE `plan` (
`plan_id` int(11) NOT NULL AUTO_INCREMENT,
`plan_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`plan_home_view_id` int(11) NOT NULL,
`plan_is_superplan` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`plan_id`),
KEY `plan_home_view_id` (`plan_home_view_id`),
CONSTRAINT `plan_ibfk_1` FOREIGN KEY (`plan_home_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for plan_link
-- ----------------------------
DROP TABLE IF EXISTS `plan_link`;
CREATE TABLE `plan_link` (
`plan_link_id` int(11) NOT NULL AUTO_INCREMENT,
`plan_id` int(11) NOT NULL,
`view_id` int(11) NOT NULL,
`element_id` int(11) NOT NULL,
`sub_plan_id` int(11) DEFAULT NULL,
PRIMARY KEY (`plan_link_id`),
KEY `plan_id` (`plan_id`),
KEY `view_id` (`view_id`),
KEY `element_id` (`element_id`),
CONSTRAINT `plan_link_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `plan_link_ibfk_2` FOREIGN KEY (`view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `plan_link_ibfk_3` FOREIGN KEY (`element_id`) REFERENCES `component` (`component_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3111 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for plan_view_relation
-- ----------------------------
DROP TABLE IF EXISTS `plan_view_relation`;
CREATE TABLE `plan_view_relation` (
`plan_view_relation_id` int(11) NOT NULL AUTO_INCREMENT,
`plan_id` int(11) NOT NULL,
`view_id` int(11) NOT NULL,
`sub_plan_id` int(11) DEFAULT NULL,
PRIMARY KEY (`plan_view_relation_id`),
KEY `plan_id` (`plan_id`),
KEY `view_id` (`view_id`),
CONSTRAINT `plan_view_relation_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `plan_view_relation_ibfk_2` FOREIGN KEY (`view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1981 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for serial_adapter
-- ----------------------------
DROP TABLE IF EXISTS `serial_adapter`;
CREATE TABLE `serial_adapter` (
`serial_adapter_id` int(11) NOT NULL AUTO_INCREMENT,
`serial_adapter_name` text NOT NULL,
`serial_adapter_device` text NOT NULL,
`serial_adapter_rate` int(11) NOT NULL DEFAULT 9600,
`serial_adapter_bits` enum('5','6','7','8') NOT NULL DEFAULT '8',
`serial_adapter_stop` enum('2','3','1') NOT NULL DEFAULT '1' COMMENT '3 => 1,5',
`serial_adapter_parity` enum('NONE','ODD','SPACE','EVEN','MARK') NOT NULL DEFAULT 'NONE',
PRIMARY KEY (`serial_adapter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Serial adapter description for player to control display(s)';
-- ----------------------------
-- Records of serial_adapter
-- ----------------------------
BEGIN;
INSERT INTO `serial_adapter` VALUES (1, 'LG-ATEN', '/dev/cu.UC-232AC', 9600, '8', '1', 'NONE');
COMMIT;
-- ----------------------------
-- Table structure for topology
-- ----------------------------
DROP TABLE IF EXISTS `topology`;
CREATE TABLE `topology` (
`topology_id` int(11) NOT NULL AUTO_INCREMENT,
`topology_controller` text NOT NULL,
`topology_action` text NOT NULL,
`topology_description` text NOT NULL,
PRIMARY KEY (`topology_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of topology
-- ----------------------------
BEGIN;
INSERT INTO `topology` VALUES (1, 'ControllerDevice', 'index', 'ControllerDevice_index');
INSERT INTO `topology` VALUES (2, 'ControllerView', 'index', 'ControllerView_index');
INSERT INTO `topology` VALUES (3, 'ControllerWall', 'index', 'ControllerWall_index');
INSERT INTO `topology` VALUES (4, 'ControllerVirtualHost', 'index', 'ControllerVirtualHost_index');
INSERT INTO `topology` VALUES (5, 'ControllerWidget', 'index', 'ControllerWidget_index');
INSERT INTO `topology` VALUES (6, 'ControllerViewNavigation', 'index', 'ControllerViewNavigation_index');
INSERT INTO `topology` VALUES (7, 'ControllerColor', 'index', 'ControllerColor_index');
INSERT INTO `topology` VALUES (8, 'ControllerUser', 'index', 'ControllerUser_index');
INSERT INTO `topology` VALUES (9, 'ControllerUserGroup', 'index', 'ControllerUserGroup_index');
INSERT INTO `topology` VALUES (10, 'ControllerDisplaySetting', 'index', 'ControllerDisplaySetting_index');
INSERT INTO `topology` VALUES (11, 'ControllerListObject', 'index', 'ControllerListObject_index');
INSERT INTO `topology` VALUES (12, 'ControllerViewDesign', 'index', 'ControllerViewDesign_index');
INSERT INTO `topology` VALUES (13, 'ControllerViewAssignment', 'index', 'ControllerViewAssignment_index');
INSERT INTO `topology` VALUES (14, 'ControllerAppLoadRessource', 'index', 'ControllerAppLoadRessource_index');
INSERT INTO `topology` VALUES (15, 'ControllerAbout', 'index', 'ControllerAbout_index');
INSERT INTO `topology` VALUES (16, 'ControllerLogs', 'index', 'ControllerLogs_index');
INSERT INTO `topology` VALUES (17, 'ControllerDevice', 'edit', 'ControllerDevice_edit');
INSERT INTO `topology` VALUES (18, 'ControllerDevice', 'erase', 'ControllerDevice_erase');
INSERT INTO `topology` VALUES (19, 'ControllerDevice', 'send_push', 'ControllerDevice_send_push');
INSERT INTO `topology` VALUES (20, 'ControllerDevice', 'locate', 'ControllerDevice_locate');
INSERT INTO `topology` VALUES (21, 'ControllerDevice', 'restart', 'ControllerDevice_restart');
INSERT INTO `topology` VALUES (22, 'ControllerDevice', 'activate', 'ControllerDevice_activate');
INSERT INTO `topology` VALUES (23, 'ControllerDevice', 'hide', 'ControllerDevice_hide');
INSERT INTO `topology` VALUES (24, 'ControllerDevice', 'update', 'ControllerDevice_update');
INSERT INTO `topology` VALUES (25, 'ControllerView', 'add', 'ControllerView_add');
INSERT INTO `topology` VALUES (26, 'ControllerView', 'erase', 'ControllerView_erase');
INSERT INTO `topology` VALUES (27, 'ControllerView', 'duplicate', 'ControllerView_duplicate');
INSERT INTO `topology` VALUES (28, 'ControllerView', 'copy', 'ControllerView_copy');
INSERT INTO `topology` VALUES (29, 'ControllerView', 'past', 'ControllerView_past');
INSERT INTO `topology` VALUES (30, 'ControllerView', 'reload', 'ControllerView_reload');
INSERT INTO `topology` VALUES (31, 'ControllerWall', 'add', 'ControllerWall_add');
INSERT INTO `topology` VALUES (32, 'ControllerWall', 'erase', 'ControllerWall_erase');
INSERT INTO `topology` VALUES (33, 'ControllerWall', 'edit', 'ControllerWall_edit');
INSERT INTO `topology` VALUES (34, 'ControllerVirtualHost', 'add', 'ControllerVirtualHost_add');
INSERT INTO `topology` VALUES (35, 'ControllerVirtualHost', 'erase', 'ControllerVirtualHost_erase');
INSERT INTO `topology` VALUES (36, 'ControllerVirtualHost', 'edit', 'ControllerVirtualHost_edit');
INSERT INTO `topology` VALUES (37, 'ControllerWidget', 'add', 'ControllerWidget_add');
INSERT INTO `topology` VALUES (38, 'ControllerWidget', 'erase', 'ControllerWidget_erase');
INSERT INTO `topology` VALUES (39, 'ControllerWidget', 'edit', 'ControllerWidget_edit');
INSERT INTO `topology` VALUES (40, 'ControllerWidget', 'view', 'ControllerWidget_view');
INSERT INTO `topology` VALUES (41, 'ControllerViewNavigation', 'add_plan', 'ControllerViewNavigation_add_plan');
INSERT INTO `topology` VALUES (42, 'ControllerViewNavigation', 'add_superplan', 'ControllerViewNavigation_add_superplan');
INSERT INTO `topology` VALUES (43, 'ControllerViewNavigation', 'edit', 'ControllerViewNavigation_edit');
INSERT INTO `topology` VALUES (44, 'ControllerViewNavigation', 'erase', 'ControllerViewNavigation_erase');
INSERT INTO `topology` VALUES (45, 'ControllerColor', 'add', 'ControllerColor_add');
INSERT INTO `topology` VALUES (46, 'ControllerColor', 'edit', 'ControllerColor_edit');
INSERT INTO `topology` VALUES (47, 'ControllerColor', 'erase', 'ControllerColor_erase');
INSERT INTO `topology` VALUES (48, 'ControllerUser', 'add', 'ControllerUser_add');
INSERT INTO `topology` VALUES (49, 'ControllerUser', 'edit', 'ControllerUser_edit');
INSERT INTO `topology` VALUES (50, 'ControllerUser', 'erase', 'ControllerUser_erase');
INSERT INTO `topology` VALUES (51, 'ControllerUserGroup', 'add', 'ControllerUserGroup_add');
INSERT INTO `topology` VALUES (52, 'ControllerUserGroup', 'edit', 'ControllerUserGroup_edit');
INSERT INTO `topology` VALUES (53, 'ControllerUserGroup', 'erase', 'ControllerUserGroup_erase');
INSERT INTO `topology` VALUES (54, 'ControllerDisplaySetting', 'add_day', 'ControllerDisplaySetting_add_day');
INSERT INTO `topology` VALUES (55, 'ControllerDisplaySetting', 'edit_day', 'ControllerDisplaySetting_edit_day');
INSERT INTO `topology` VALUES (56, 'ControllerDisplaySetting', 'erase_day', 'ControllerDisplaySetting_erase_day');
INSERT INTO `topology` VALUES (57, 'ControllerDisplaySetting', 'add_week', 'ControllerDisplaySetting_add_week');
INSERT INTO `topology` VALUES (58, 'ControllerDisplaySetting', 'edit_week', 'ControllerDisplaySetting_edit_week');
INSERT INTO `topology` VALUES (59, 'ControllerDisplaySetting', 'erase_week', 'ControllerDisplaySetting_erase_week');
INSERT INTO `topology` VALUES (60, 'ControllerAbout', 'put_licence', 'ControllerAbout_put_licence');
INSERT INTO `topology` VALUES (61, 'ControllerAbout', 'view_nds_uuid', 'ControllerAbout_view_nds_uuid');
INSERT INTO `topology` VALUES (62, 'ControllerAbout', 'reload_nds', 'ControllerAbout_reload_nds');
INSERT INTO `topology` VALUES (63, 'SoundMosaics', 'add', 'SoundMosaics_add');
INSERT INTO `topology` VALUES (64, 'ImageMosaics', 'add', 'ImageMosaics_add');
INSERT INTO `topology` VALUES (65, 'ImageMosaics', 'erase', 'ImageMosaics_erase');
INSERT INTO `topology` VALUES (66, 'ControllerDevice', 'add_device_group', 'ControllerDevice_add_device_group');
INSERT INTO `topology` VALUES (67, 'ControllerDevice', 'remove_device_group', 'ControllerDevice_remove_device_group');
INSERT INTO `topology` VALUES (68, 'ControllerDevice', 'edit_device_group', 'ControllerDevice_edit_device_group');
INSERT INTO `topology` VALUES (69, 'ControllerView', 'add_view_group', 'ControllerView_add_view_group');
INSERT INTO `topology` VALUES (70, 'ControllerView', 'remove_view_group', 'ControllerView_remove_view_group');
INSERT INTO `topology` VALUES (71, 'ControllerView', 'edit_view_group', 'ControllerView_edit_view_group');
COMMIT;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` text DEFAULT NULL,
`last_name` text DEFAULT NULL,
`login` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`is_admin` tinyint(1) DEFAULT NULL,
`group_group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`user_id`),
KEY `group_group_id` (`group_group_id`),
CONSTRAINT `user_ibfk_1` FOREIGN KEY (`group_group_id`) REFERENCES `group` (`group_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (8, 'Pierre-Yves', 'Maillet', 'pymaillet', '16fdbdb2dee42bc784444b44881fdb5a', 1, 8);
INSERT INTO `user` VALUES (19, 'Yohann', 'Mainfroid', 'admin', 'bd4a7bdeca38db5b04f5b860fcce96df', 1, 8);
INSERT INTO `user` VALUES (71, 'ADMIN', 'ADMIN', 'ymainfroid', 'd7c6195e92acdb1e9c7cc139f90625be', 1, 8);
INSERT INTO `user` VALUES (75, 'Regie', 'HippSystems', 'reghipp', '2107a9f7eb2de66e7ac4a67b5ee6e95b', 0, 8);
INSERT INTO `user` VALUES (76, 'REST', 'REST', 'REST', '50780f47f6839d47d60bc4555ee00c3f', 1, 8);
INSERT INTO `user` VALUES (78, 'nds', 'nds', 'nds', '9f7f34ac5da5b793bc98646aa032d1c', 1, 8);
INSERT INTO `user` VALUES (79, 'Francois', 'Frelat', 'ffrelat', 'a89573f492714974b2b9c4cdbdb2918b', 1, 8);
INSERT INTO `user` VALUES (81, 'test', 'test', 'test', '98f6bcd4621d373cade4e832627b4f6', 0, 24);
INSERT INTO `user` VALUES (82, 'Kevin', 'Monnier', 'kmonnier', '72774327b23dbce59e196ac4ee7714c4', 0, 25);
COMMIT;
-- ----------------------------
-- Table structure for view
-- ----------------------------
DROP TABLE IF EXISTS `view`;
CREATE TABLE `view` (
`view_id` int(11) NOT NULL AUTO_INCREMENT,
`view_name` text NOT NULL COMMENT 'Nom de l''écran',
`view_description` text DEFAULT NULL COMMENT 'Description',
`view_ipaddr` varchar(255) DEFAULT NULL COMMENT 'Adresse IPv4',
`view_macaddr` varchar(255) DEFAULT NULL COMMENT 'Adresse Mac',
`view_width` int(11) DEFAULT NULL COMMENT 'Résolution de l''écran (Largeur)',
`view_height` int(11) DEFAULT NULL COMMENT 'Résolution de l''écran (Hauteur)',
`view_turnoff_hour` int(11) DEFAULT 9 COMMENT 'Heure d''extinction de l''écran',
`view_turnoff_min` int(11) DEFAULT 0 COMMENT 'Minutes d''extinction de l''écran',
`view_turnon_hour` int(11) DEFAULT 18 COMMENT 'Heure d''allumage de l''écran',
`view_turnon_min` int(11) DEFAULT 0 COMMENT 'Minutes d''allumage de l''écran',
`view_enable_control` tinyint(1) DEFAULT 0 COMMENT 'Active ou non la gestion d''extinction de l''écran',
`view_rectInterval` int(11) DEFAULT 500,
`view_infosInterval` int(11) DEFAULT 500,
`view_detailsInterval` int(11) DEFAULT 30,
`view_nbRect` int(11) DEFAULT 0,
`view_nbDetails` int(11) DEFAULT 0,
`view_nbInfos` int(11) DEFAULT 0,
`view_nbSeparator` int(11) DEFAULT 0,
`view_nbGraphs` int(11) DEFAULT 0,
`view_graphsInterval` int(11) DEFAULT 5000 COMMENT 'Millisecond',
`view_online` tinyint(1) DEFAULT 0,
`view_isTemplate` tinyint(1) DEFAULT 0,
`view_cmd` text DEFAULT NULL,
`view_serial_adapter_id` int(11) DEFAULT NULL,
`view_display_week_program_id` int(11) DEFAULT NULL,
`view_display_command_id` int(11) DEFAULT NULL,
`view_deviceToken` text DEFAULT NULL,
`view_isWall` tinyint(1) DEFAULT NULL,
`view_color_id` int(11) DEFAULT 1,
`view_model_id` int(11) DEFAULT NULL,
`view_model_prefix_target` text DEFAULT NULL,
`view_model_prefix_replacement` text DEFAULT NULL,
PRIMARY KEY (`view_id`),
KEY `view_display_week_program_id` (`view_display_week_program_id`) USING BTREE,
KEY `view_display_command_id` (`view_display_command_id`) USING BTREE,
KEY `view_serial_adapter_id` (`view_serial_adapter_id`) USING BTREE,
CONSTRAINT `view_ibfk_7` FOREIGN KEY (`view_display_week_program_id`) REFERENCES `display_week_program` (`display_week_program_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `view_ibfk_8` FOREIGN KEY (`view_display_command_id`) REFERENCES `display_command` (`display_command_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `view_ibfk_9` FOREIGN KEY (`view_serial_adapter_id`) REFERENCES `serial_adapter` (`serial_adapter_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=869 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Définie les variables pour un écran';
-- ----------------------------
-- Table structure for view_data_uid_relation
-- ----------------------------
DROP TABLE IF EXISTS `view_data_uid_relation`;
CREATE TABLE `view_data_uid_relation` (
`nagios_object_id` int(11) DEFAULT NULL COMMENT 'Correspond au host_object_id de la table de NDOutils',
`view_view_id` int(11) DEFAULT NULL,
`data_uid` text NOT NULL,
KEY `view_view_id` (`view_view_id`),
CONSTRAINT `view_data_uid_relation_ibfk_1` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for view_filter_relation
-- ----------------------------
DROP TABLE IF EXISTS `view_filter_relation`;
CREATE TABLE `view_filter_relation` (
`view_filter_relation` int(11) NOT NULL AUTO_INCREMENT,
`view_id` int(11) NOT NULL,
`filter_id` int(11) NOT NULL,
`filter_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`view_filter_relation`),
KEY `view_id` (`view_id`),
KEY `filter_id` (`filter_id`),
CONSTRAINT `view_filter_relation_ibfk_1` FOREIGN KEY (`view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for view_group
-- ----------------------------
DROP TABLE IF EXISTS `view_group`;
CREATE TABLE `view_group` (
`view_group_id` int(11) NOT NULL AUTO_INCREMENT,
`view_group_name` text DEFAULT NULL,
PRIMARY KEY (`view_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of view_group
-- ----------------------------
BEGIN;
INSERT INTO `view_group` VALUES (1, 'sauvegarde');
COMMIT;
-- ----------------------------
-- Table structure for view_user_relation
-- ----------------------------
DROP TABLE IF EXISTS `view_user_relation`;
CREATE TABLE `view_user_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`view_view_id` int(11) NOT NULL,
`user_user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `view_view_id` (`view_view_id`),
KEY `user_user_id` (`user_user_id`),
CONSTRAINT `view_user_relation_ibfk_1` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `view_user_relation_ibfk_2` FOREIGN KEY (`user_user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for view_view_group_relation
-- ----------------------------
DROP TABLE IF EXISTS `view_view_group_relation`;
CREATE TABLE `view_view_group_relation` (
`view_view_group_relation_id` int(11) NOT NULL AUTO_INCREMENT,
`view_group_id` int(11) NOT NULL,
`view_id` int(11) NOT NULL,
PRIMARY KEY (`view_view_group_relation_id`),
KEY `FK_device_device_group_relation_device_group` (`view_group_id`),
KEY `FK_device_device_group_relation_device` (`view_id`),
CONSTRAINT `view_view_group_relation_ibfk_1` FOREIGN KEY (`view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `view_view_group_relation_ibfk_2` FOREIGN KEY (`view_group_id`) REFERENCES `view_group` (`view_group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for view_virtualHost_relation
-- ----------------------------
DROP TABLE IF EXISTS `view_virtualHost_relation`;
CREATE TABLE `view_virtualHost_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`virtualHost_id` int(11) DEFAULT NULL,
`view_view_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `virtualHost_id` (`virtualHost_id`),
KEY `view_view_id` (`view_view_id`),
CONSTRAINT `view_virtualHost_relation_ibfk_1` FOREIGN KEY (`virtualHost_id`) REFERENCES `virtualHost` (`virtualHost_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `view_virtualHost_relation_ibfk_2` FOREIGN KEY (`view_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for virtualElement_events
-- ----------------------------
DROP TABLE IF EXISTS `virtualElement_events`;
CREATE TABLE `virtualElement_events` (
`virtualElement_history` int(11) NOT NULL AUTO_INCREMENT,
`virtualElement_virtualElement_id` int(11) NOT NULL,
`virtualElement_time` datetime NOT NULL,
`virtualElement_state` float NOT NULL,
`virtualElement_output` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
PRIMARY KEY (`virtualElement_history`),
KEY `virtualElement_virtualElement_id` (`virtualElement_virtualElement_id`) USING BTREE,
CONSTRAINT `virtualElement_events_ibfk_1` FOREIGN KEY (`virtualElement_virtualElement_id`) REFERENCES `virtualHost` (`virtualHost_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12320148 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for virtualHost
-- ----------------------------
DROP TABLE IF EXISTS `virtualHost`;
CREATE TABLE `virtualHost` (
`virtualHost_id` int(11) NOT NULL AUTO_INCREMENT,
`virtualHost_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`virtualHost_equation` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`virtualHost_description` text DEFAULT NULL,
`virtualHost_current_state` int(11) DEFAULT 0,
`virtualHost_output` text DEFAULT NULL,
`virtualHost_last_check` datetime DEFAULT NULL,
`virtualHost_problem_has_been_acknowledged` tinyint(4) DEFAULT 0,
`virtualHost_view_id` int(11) DEFAULT NULL,
`virtualHost_definition` text DEFAULT NULL,
PRIMARY KEY (`virtualHost_id`),
KEY `virtualHost_view_id` (`virtualHost_view_id`),
CONSTRAINT `virtualHost_ibfk_1` FOREIGN KEY (`virtualHost_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of virtualHost
-- ----------------------------
BEGIN;
INSERT INTO `virtualHost` VALUES (136, 'TEST 2', NULL, NULL, 0, 'All elements are ok', '2024-06-18 14:14:43', 0, NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><virtualElement><elements><element id=\"0\" virtualElement=\"false\">EDRIS-1-Host-Test saturation</element><element id=\"1\" virtualElement=\"false\">EDRIS-1-Host-EDRISRT</element><element id=\"2\" virtualElement=\"false\">NDS-Server-1-Host-PyMac.local</element><element id=\"3\" virtualElement=\"true\">141</element><element id=\"4\" virtualElement=\"true\">142</element><element id=\"5\" virtualElement=\"true\">143</element><element id=\"6\" virtualElement=\"true\">144</element><element id=\"7\" virtualElement=\"true\">133</element><element id=\"8\" virtualElement=\"true\">140</element></elements><formula>[0]*0.0+[1]*0.0+[2]*0.0+[3]*0.0+[4]*0.0+[5]*0.0+[6]*0.0+[7]*0.0+[8]*1.0</formula></virtualElement>');
INSERT INTO `virtualHost` VALUES (142, 'RED', NULL, NULL, 3, 'All elements are ok', '2024-06-18 14:14:43', 0, NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><virtualElement><elements><element id=\"0\" virtualElement=\"false\">HIPPSYSTEMS-1-Host-4GRouter-358481084116417</element><element id=\"1\" virtualElement=\"false\">NDS-Server-1-Host-PyMac.local</element></elements><formula>[0]*0.5+[1]*0.5</formula></virtualElement>');
INSERT INTO `virtualHost` VALUES (143, 'RED', NULL, NULL, 3, 'All elements are ok', '2024-06-18 14:14:43', 0, NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><virtualElement><elements><element id=\"0\" virtualElement=\"false\">HIPPSYSTEMS-1-Host-4GRouter-358481084116417</element><element id=\"1\" virtualElement=\"false\">NDS-Server-1-Host-PyMac.local</element></elements><formula>[0]*0.5+[1]*0.5</formula></virtualElement>');
INSERT INTO `virtualHost` VALUES (144, 'RED', NULL, NULL, 3, 'All elements are ok', '2024-06-18 14:14:43', 0, NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><virtualElement><elements><element id=\"0\" virtualElement=\"false\">HIPPSYSTEMS-1-Host-4GRouter-358481084116573</element></elements><formula>[0]*1.0</formula></virtualElement>');
COMMIT;
-- ----------------------------
-- Table structure for wall
-- ----------------------------
DROP TABLE IF EXISTS `wall`;
CREATE TABLE `wall` (
`wall_uuid` varchar(255) NOT NULL DEFAULT '',
`wall_name` varchar(255) NOT NULL,
`wall_description` varchar(255) DEFAULT NULL,
`wall_columns` int(11) NOT NULL,
`wall_rows` int(11) NOT NULL,
`wall_creation_date` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
`wall_color_id` int(11) NOT NULL,
`wall_display_height` int(11) DEFAULT NULL,
`wall_display_witdh` int(11) DEFAULT NULL,
`wall_detailsInterval` int(11) DEFAULT NULL,
`wall_display_xml` text DEFAULT NULL,
PRIMARY KEY (`wall_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of wall
-- ----------------------------
BEGIN;
INSERT INTO `wall` VALUES ('4fb1f0e0-a46a-41d3-b465-33cb4305b265', 'TEST 2 ', 'TEST 2', 2, 2, '2023-07-19 10:40:45', 0, 1080, 1920, 20, '<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><Displays><Display DisplayId=\"681\" XOrigine=\"0\" XWidth=\"1920\" YHeight=\"1200\" YOrigine=\"0\"/><Display DisplayId=\"707\" XOrigine=\"1920\" XWidth=\"1920\" YHeight=\"1080\" YOrigine=\"0\"/><Display DisplayId=\"\" XOrigine=\"0\" XWidth=\"\" YHeight=\"\" YOrigine=\"1080\"/><Display DisplayId=\"\" XOrigine=\"1920\" XWidth=\"\" YHeight=\"\" YOrigine=\"1080\"/></Displays>');
COMMIT;
-- ----------------------------
-- Table structure for widget
-- ----------------------------
DROP TABLE IF EXISTS `widget`;
CREATE TABLE `widget` (
`widget_id` int(11) NOT NULL AUTO_INCREMENT,
`widget_type` enum('meteo','rss','vlc','stocks','partner','calendar','rss-scrolling','ipcamera','imageviewer','circlegaugeclock','clock','j3tel','weather','currentweather') NOT NULL,
`widget_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`widget_description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`widget_address` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`widget_username` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`widget_password` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
PRIMARY KEY (`widget_id`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of widget
-- ----------------------------
BEGIN;
INSERT INTO `widget` VALUES (22, 'rss', 'Melis@', '', 'http://www.melisa.fr/site/rss.xml', '', '');
INSERT INTO `widget` VALUES (61, 'clock', 'Horloge Paris', 'Europe / Paris', 'Europe/Paris', '', '');
INSERT INTO `widget` VALUES (105, 'weather', 'Angers', '', 'q=Angers,FR', '', '');
INSERT INTO `widget` VALUES (113, 'rss', 'FLUX RSS CERT', '', 'https://www.cert.ssi.gouv.fr/alerte/feed/', '', '');
INSERT INTO `widget` VALUES (114, 'rss', 'FLUX RSS CERT SCADA', '', 'http://www.cert.ssi.gouv.fr/site/cert-fr_scada.rss', '', '');
INSERT INTO `widget` VALUES (115, 'rss', 'Europol', '', 'https://www.europol.europa.eu/rss.xml', '', '');
INSERT INTO `widget` VALUES (116, 'weather', 'Paris', '', 'q=Paris,FR', '', '');
INSERT INTO `widget` VALUES (147, 'rss', 'Portail EDRIS', '', 'https://tickets.edris.fr/news', '', '');
INSERT INTO `widget` VALUES (191, 'rss', 'RSS SSI GOUV', '3820', 'https://www.cert.ssi.gouv.fr/alerte/feed/', '', '');
INSERT INTO `widget` VALUES (193, 'rss-scrolling', 'FLUX RSS CERT DEFILANT', '2232', 'https://www.cert.ssi.gouv.fr/alerte/feed/', '', '');
COMMIT;
-- ----------------------------
-- Table structure for zone
-- ----------------------------
DROP TABLE IF EXISTS `zone`;
CREATE TABLE `zone` (
`zone_id` int(11) NOT NULL AUTO_INCREMENT,
`zone_view_id` int(11) DEFAULT NULL,
`zone_type` enum('rect','infos','detailspages','details','link','widget','nla','container','stack','larkmirror','train','timeline','graphs','workflow','droptv5','dragtv5','draw','eventslog','eventboard','eventGroupSummaries','workflowSubtitleAlerts','eventGroupCounters','conductorTrain','conductorAlerts','filteredRect','osMap') DEFAULT NULL,
`zone_font` varchar(255) DEFAULT 'Arial' COMMENT 'Police d''écriture',
`zone_font_size` int(11) DEFAULT 16 COMMENT 'Taille de la police',
`zone_font_style` enum('plain','italic','bold') DEFAULT 'plain' COMMENT 'Style de la police ',
`zone_icon` text DEFAULT NULL COMMENT 'Inutilisé',
`zone_text` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`zone_x` int(11) DEFAULT NULL COMMENT 'Position X',
`zone_y` int(11) DEFAULT NULL COMMENT 'Position Y',
`zone_width` int(11) DEFAULT NULL COMMENT 'Largeur',
`zone_height` int(11) DEFAULT NULL COMMENT 'Hauteur',
`zone_nb_rect` int(11) DEFAULT NULL,
`zone_rect_height` int(11) DEFAULT NULL,
`zone_rect_width` int(11) DEFAULT NULL,
`zone_nbrect_height` int(11) DEFAULT NULL,
`zone_nbrect_width` int(11) DEFAULT NULL,
`zone_type_conf` int(11) DEFAULT NULL,
`zone_rect_width_space` int(11) DEFAULT 4,
`zone_rect_height_space` int(11) DEFAULT 4,
`zone_rect_marge_max` int(11) DEFAULT 4,
`zone_rect_ratio_hl` double DEFAULT 0.2,
`zone_change` int(11) DEFAULT 0,
`link_x1` int(11) DEFAULT NULL,
`link_x2` int(11) DEFAULT NULL,
`link_y1` int(11) DEFAULT NULL,
`link_y2` int(11) DEFAULT NULL,
`link_x3` int(11) DEFAULT NULL,
`link_y3` int(11) DEFAULT NULL,
`zone_isOpaque` tinyint(1) DEFAULT 1,
`zone_layer` tinyint(1) DEFAULT 0,
`zone_model_zone_id` int(11) DEFAULT NULL,
`zone_model_view_id` int(11) DEFAULT NULL,
`zone_isLock` tinyint(1) DEFAULT 0,
`zone_extended_configuration` text DEFAULT NULL,
PRIMARY KEY (`zone_id`),
KEY `zone_id` (`zone_id`),
KEY `zone_view_id` (`zone_view_id`),
CONSTRAINT `zone_ibfk_1` FOREIGN KEY (`zone_view_id`) REFERENCES `view` (`view_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=80302 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=DYNAMIC COMMENT='Définie les variables pour un LABEL';
SET FOREIGN_KEY_CHECKS = 1;