USE idoit_mandant;

SHOW CREATE table isys_ac_type;

DROP table isys_catg_ip_list_2_isys_netp_port;

CREATE TABLE `isys_catg_ip_list_2_isys_netp_port` (
  `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` int(10) unsigned NOT NULL,
  `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` int(10) unsigned NOT NULL,
  KEY `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id`),
  KEY `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` (`isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `isys_catg_ip_list_2_isys_netp_port`
  ADD CONSTRAINT `isys_catg_ip_list_2_isys_netp_port_ibfk_2` FOREIGN KEY (`isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id`) REFERENCES `isys_catg_ip_list` (`isys_catg_ip_list__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_catg_ip_list_2_isys_netp_port_ibfk_1` FOREIGN KEY (`isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id`) REFERENCES `isys_netp_port` (`isys_netp_port__id`) ON DELETE CASCADE ON UPDATE CASCADE;

DROP TABLE isys_catg_ip_list_2_isys_catg_port_list;

DROP TABLE isys_catg_ip_list_2_isys_netp_port;

CREATE TABLE `isys_catg_ip_list_2_isys_netp_port` (
  `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` int(10) unsigned NOT NULL,
  `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` int(10) unsigned NOT NULL,
  KEY `isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id` (`isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id`),
  KEY `isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id` (`isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `isys_catg_ip_list_2_isys_netp_port`
  ADD CONSTRAINT `isys_catg_ip_list_2_isys_netp_port_ibfk_2` FOREIGN KEY (`isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id`) REFERENCES `isys_catg_ip_list` (`isys_catg_ip_list__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_catg_ip_list_2_isys_netp_port_ibfk_1` FOREIGN KEY (`isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id`) REFERENCES `isys_netp_port` (`isys_netp_port__id`) ON DELETE CASCADE ON UPDATE CASCADE;

DROP TABLE isys_catg_fc_port_list;

DROP TABLE isys_cats_access_point_list;

CREATE TABLE `isys_cats_access_point_list` (
  `isys_cats_access_point_list__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_cats_access_point_list__isys_obj__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_cats_distributor__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_wlan_encryption__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_wlan_function__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_wlan_channel__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_wlan_standard__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__isys_wlan_auth__id` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isys_cats_access_point_list__description` text COLLATE utf8_unicode_ci,
  `isys_cats_access_point_list__ssid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isys_cats_access_point_list__key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `isys_cats_access_point_list__wep` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__wpa` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__psk` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__tkip` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__pbnac` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__encryption` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__cipher` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__broadcast_ssid` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__mac_filter` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__status` int(10) unsigned DEFAULT NULL,
  `isys_cats_access_point_list__property` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`isys_cats_access_point_list__id`),
  KEY `isys_cats_access_point_list_FKIndex1` (`isys_cats_access_point_list__isys_wlan_standard__id`),
  KEY `isys_cats_access_point_list_FKIndex2` (`isys_cats_access_point_list__isys_wlan_channel__id`),
  KEY `isys_cats_access_point_list_FKIndex3` (`isys_cats_access_point_list__isys_wlan_function__id`),
  KEY `isys_cats_access_point_list_FKIndex4` (`isys_cats_access_point_list__isys_wlan_encryption__id`),
  KEY `isys_cats_access_point_list__isys_wlan_auth__id` (`isys_cats_access_point_list__isys_wlan_auth__id`),
  KEY `isys_cats_access_point_list__i_2` (`isys_cats_access_point_list__isys_wlan_auth__id`),
  KEY `isys_cats_access_point_list__isys_cats_distributor__id` (`isys_cats_access_point_list__isys_cats_distributor__id`),
  KEY `isys_cats_access_point_list__isys_obj__id` (`isys_cats_access_point_list__isys_obj__id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

ALTER TABLE `isys_cats_access_point_list`
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_12` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_auth__id`) REFERENCES `isys_wlan_auth` (`isys_wlan_auth__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_10` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_channel__id`) REFERENCES `isys_wlan_channel` (`isys_wlan_channel__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_11` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_standard__id`) REFERENCES `isys_wlan_standard` (`isys_wlan_standard__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_6` FOREIGN KEY (`isys_cats_access_point_list__isys_cats_distributor__id`) REFERENCES `isys_cats_distributor` (`isys_cats_distributor__id`),
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_7` FOREIGN KEY (`isys_cats_access_point_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_8` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_encryption__id`) REFERENCES `isys_wlan_encryption` (`isys_wlan_encryption__id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `isys_cats_access_point_list_ibfk_9` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_function__id`) REFERENCES `isys_wlan_function` (`isys_wlan_function__id`) ON DELETE SET NULL ON UPDATE CASCADE;