-- Table structure for table `isys_catg_graphic_list`
--

CREATE TABLE `isys_catg_graphic_list` (
  `isys_catg_graphic_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_graphic_list__isys_memory_unit__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_graphic_list__isys_graphic_manufacturer__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_graphic_list__title` varchar(255) DEFAULT NULL,
  `isys_catg_graphic_list__memory` bigint(20) DEFAULT NULL,
  `isys_catg_graphic_list__description` longtext DEFAULT NULL,
  `isys_catg_graphic_list__status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `isys_catg_graphic_list__property` int(10) unsigned DEFAULT NULL,
  `isys_catg_graphic_list__isys_obj__id` int(10) unsigned NOT NULL,
  `isys_catg_graphic_list__firmware` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`isys_catg_graphic_list__id`),
  KEY `isys_catg_graphic_list_FKIndex2` (`isys_catg_graphic_list__isys_memory_unit__id`),
  KEY `isys_catg_graphic_list_FKIndex3` (`isys_catg_graphic_list__isys_graphic_manufacturer__id`),
  KEY `isys_catg_graphic_list__isys_obj__id` (`isys_catg_graphic_list__isys_obj__id`),
  KEY `isys_catg_graphic_list__status` (`isys_catg_graphic_list__status`),
  CONSTRAINT `isys_catg_graphic_list_ibfk_1` FOREIGN KEY (`isys_catg_graphic_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_graphic_list`
--

INSERT INTO `isys_catg_graphic_list` VALUES
(1,NULL,NULL,' VMware SVGA II Adapter (prog-if 00 [VGA controller])',0,'',2,NULL,7031,''),
(2,NULL,NULL,' VMware SVGA II Adapter (prog-if 00 [VGA controller])',0,'',2,NULL,8794,''),
(3,NULL,NULL,'Microsoft Remote Display Adapter',0,'',2,NULL,8807,''),
(4,2,NULL,'VMware SVGA 3D',33554432,'',2,NULL,8807,'');
COMMIT;

--
-- Table structure for table `isys_catg_guest_systems_list`
--

CREATE TABLE `isys_catg_guest_systems_list` (
  `isys_catg_guest_systems_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_guest_systems_list__isys_obj__id` int(10) unsigned NOT NULL,
  `isys_catg_guest_systems_list__status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `isys_catg_guest_systems_list__property` int(10) unsigned NOT NULL,
  `isys_catg_guest_systems_list__isys_connection__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_guest_systems_list__description` longtext DEFAULT NULL,
  PRIMARY KEY (`isys_catg_guest_systems_list__id`),
  KEY `isys_catg_guest_systems_list__isys_obj__id` (`isys_catg_guest_systems_list__isys_obj__id`),
  KEY `isys_catg_guest_systems_list__isys_connection__id` (`isys_catg_guest_systems_list__isys_connection__id`),
  CONSTRAINT `isys_catg_guest_systems_list_ibfk_1` FOREIGN KEY (`isys_catg_guest_systems_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `isys_catg_guest_systems_list_ibfk_2` FOREIGN KEY (`isys_catg_guest_systems_list__isys_connection__id`) REFERENCES `isys_connection` (`isys_connection__id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_guest_systems_list`
--

COMMIT;

--
-- Table structure for table `isys_catg_hba_list`
--

CREATE TABLE `isys_catg_hba_list` (
  `isys_catg_hba_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_hba_list__isys_controller_manufacturer__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_hba_list__isys_controller_model__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_hba_list__isys_hba_type__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_hba_list__title` varchar(255) DEFAULT NULL,
  `isys_catg_hba_list__description` longtext DEFAULT NULL,
  `isys_catg_hba_list__portcount` int(10) unsigned DEFAULT 0,
  `isys_catg_hba_list__status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `isys_catg_hba_list__property` int(10) unsigned DEFAULT 0,
  `isys_catg_hba_list__isys_obj__id` int(10) unsigned NOT NULL,
  `isys_catg_hba_list__const` varchar(255) DEFAULT NULL,
  `isys_catg_hba_list__sort` int(10) unsigned DEFAULT NULL,
  `isys_catg_hba_list__firmware` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`isys_catg_hba_list__id`),
  KEY `isys_catg_hba_list_FKIndex1` (`isys_catg_hba_list__isys_hba_type__id`),
  KEY `isys_catg_hba_list_FKIndex2` (`isys_catg_hba_list__isys_controller_manufacturer__id`),
  KEY `isys_catg_hba_list_FKIndex3` (`isys_catg_hba_list__isys_controller_model__id`),
  KEY `isys_catg_hba_list_FKIndex4` (`isys_catg_hba_list__isys_obj__id`),
  KEY `isys_catg_hba_list__title` (`isys_catg_hba_list__title`),
  KEY `isys_catg_hba_list__status` (`isys_catg_hba_list__status`),
  CONSTRAINT `isys_catg_hba_list_ibfk_1` FOREIGN KEY (`isys_catg_hba_list__isys_hba_type__id`) REFERENCES `isys_hba_type` (`isys_hba_type__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `isys_catg_hba_list_ibfk_2` FOREIGN KEY (`isys_catg_hba_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `isys_catg_hba_list_ibfk_3` FOREIGN KEY (`isys_catg_hba_list__isys_controller_manufacturer__id`) REFERENCES `isys_controller_manufacturer` (`isys_controller_manufacturer__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `isys_catg_hba_list_ibfk_4` FOREIGN KEY (`isys_catg_hba_list__isys_controller_model__id`) REFERENCES `isys_controller_model` (`isys_controller_model__id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_hba_list`
--

COMMIT;

--
-- Table structure for table `isys_catg_identifier_list`
--

CREATE TABLE `isys_catg_identifier_list` (
  `isys_catg_identifier_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_identifier_list__isys_catg_identifier_type__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_identifier_list__key` varchar(255) DEFAULT NULL,
  `isys_catg_identifier_list__value` varchar(255) NOT NULL,
  `isys_catg_identifier_list__datetime` datetime DEFAULT NULL,
  `isys_catg_identifier_list__group` varchar(255) DEFAULT NULL,
  `isys_catg_identifier_list__last_scan` varchar(255) DEFAULT NULL,
  `isys_catg_identifier_list__description` longtext DEFAULT NULL,
  `isys_catg_identifier_list__status` tinyint(3) unsigned NOT NULL DEFAULT 2,
  `isys_catg_identifier_list__isys_obj__id` int(10) unsigned NOT NULL,
  `isys_catg_identifier_list__last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`isys_catg_identifier_list__id`),
  KEY `isys_catg_identifier_list__key` (`isys_catg_identifier_list__key`),
  KEY `isys_catg_identifier_list__isys_catg_identifier_type__id` (`isys_catg_identifier_list__isys_catg_identifier_type__id`),
  KEY `isys_catg_identifier_list__isys_obj__id` (`isys_catg_identifier_list__isys_obj__id`),
  KEY `isys_catg_identifier_list__group` (`isys_catg_identifier_list__group`),
  KEY `identifier_search_index` (`isys_catg_identifier_list__isys_obj__id`,`isys_catg_identifier_list__isys_catg_identifier_type__id`,`isys_catg_identifier_list__key`),
  KEY `identifier_universal` (`isys_catg_identifier_list__key`,`isys_catg_identifier_list__isys_catg_identifier_type__id`,`isys_catg_identifier_list__value`,`isys_catg_identifier_list__isys_obj__id`,`isys_catg_identifier_list__status`),
  CONSTRAINT `isys_catg_identifier_list__isys_obj__id` FOREIGN KEY (`isys_catg_identifier_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `isys_catg_identifier_list_ibfk_7` FOREIGN KEY (`isys_catg_identifier_list__isys_catg_identifier_type__id`) REFERENCES `isys_catg_identifier_type` (`isys_catg_identifier_type__id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_identifier_list`
--

COMMIT;

--
-- Table structure for table `isys_catg_identifier_type`
--

CREATE TABLE `isys_catg_identifier_type` (
  `isys_catg_identifier_type__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_identifier_type__title` varchar(255) DEFAULT NULL,
  `isys_catg_identifier_type__description` longtext DEFAULT NULL,
  `isys_catg_identifier_type__const` varchar(255) DEFAULT NULL,
  `isys_catg_identifier_type__property` int(10) DEFAULT NULL,
  `isys_catg_identifier_type__sort` int(10) unsigned DEFAULT NULL,
  `isys_catg_identifier_type__status` tinyint(3) unsigned NOT NULL DEFAULT 2,
  PRIMARY KEY (`isys_catg_identifier_type__id`),
  KEY `isys_catg_identifier_type__title` (`isys_catg_identifier_type__title`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_identifier_type`
--

INSERT INTO `isys_catg_identifier_type` VALUES
(1,'OCS',NULL,'C__CATG__IDENTIFIER_TYPE__OCS',NULL,NULL,2),
(2,'JDisc',NULL,'C__CATG__IDENTIFIER_TYPE__JDISC',NULL,NULL,2),
(3,'Loginventory',NULL,'C__CATG__IDENTIFIER_TYPE__LOGINVENTORY',NULL,NULL,2),
(4,'openITCOCKPIT',NULL,'C__CATG__IDENTIFIER_TYPE__OPENITCOCKPIT',NULL,NULL,2),
(5,'((OTRS)) Community Edition',NULL,'C__CATG__IDENTIFIER_TYPE__OTRS',NULL,NULL,2),
(6,'RT',NULL,'C__CATG__IDENTIFIER_TYPE__RT',NULL,NULL,2),
(7,'JIRA',NULL,'C__CATG__IDENTIFIER_TYPE__JIRA',NULL,NULL,2),
(8,'H-Inventory',NULL,'C__CATG__IDENTIFIER_TYPE__H_INVENTORY',NULL,NULL,2),
(9,'JDisc Unique-IDs',NULL,'C__CATG__IDENTIFIER_TYPE__JDISC_UNIQUE_IDS',NULL,NULL,2);
COMMIT;

--
-- Table structure for table `isys_catg_image_list`
--

CREATE TABLE `isys_catg_image_list` (
  `isys_catg_image_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_image_list__image_link` varchar(255) DEFAULT NULL,
  `isys_catg_image_list__title` varchar(255) DEFAULT NULL,
  `isys_catg_image_list__description` longtext DEFAULT NULL,
  `isys_catg_image_list__status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `isys_catg_image_list__property` int(10) unsigned DEFAULT NULL,
  `isys_catg_image_list__isys_obj__id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`isys_catg_image_list__id`),
  KEY `isys_catg_image_list__isys_obj__id` (`isys_catg_image_list__isys_obj__id`),
  CONSTRAINT `isys_catg_image_list_ibfk_2` FOREIGN KEY (`isys_catg_image_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_image_list`
--

INSERT INTO `isys_catg_image_list` VALUES
(1,'1781__1552988596__bludenz-die-alpenstadt-2x.png',NULL,'',2,NULL,1781),
(2,'1774__1604497409__logofrastanz.png',NULL,'',2,NULL,1774),
(3,'1781__1552988596__bludenz-die-alpenstadt-2x.png',NULL,'',2,NULL,1775),
(4,'1781__1552988596__bludenz-die-alpenstadt-2x.png',NULL,'',2,NULL,8582),
(5,'1781__1552988596__bludenz-die-alpenstadt-2x.png',NULL,'',2,NULL,8576);
COMMIT;

--
-- Table structure for table `isys_catg_images_list`
--

CREATE TABLE `isys_catg_images_list` (
  `isys_catg_images_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_images_list__isys_obj__id` int(10) unsigned NOT NULL,
  `isys_catg_images_list__filename` varchar(255) DEFAULT NULL,
  `isys_catg_images_list__filecontent` mediumblob DEFAULT NULL,
  `isys_catg_images_list__filemime` varchar(32) NOT NULL,
  `isys_catg_images_list__uploaded` datetime NOT NULL,
  `isys_catg_images_list__status` tinyint(3) unsigned NOT NULL DEFAULT 2,
  `isys_catg_images_list__order` int(5) unsigned DEFAULT 99999,
  PRIMARY KEY (`isys_catg_images_list__id`),
  KEY `isys_catg_images_list__isys_obj__id` (`isys_catg_images_list__isys_obj__id`),
  KEY `isys_catg_images_list__status` (`isys_catg_images_list__status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `isys_catg_images_list`
--

INSERT INTO `isys_catg_images_list` VALUES
(1,221,'Router-VS-Ludesch.png','[encoded data, 509123 characters]