[2011-11-04 09:27:49]: Checking ::  SELECT isys_obj_type_2_isysgui_catg__id FROM isys_obj_type_2_isysgui_catg INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj_type_2_isysgui_catg__isys_obj_type__id INNER JOIN isysgui_catg ON isysgui_catg__id = isys_obj_type_2_isysgui_catg__isysgui_catg__id WHERE isys_obj_type__const = 'C__OBJTYPE__SIM_CARD' AND isysgui_catg__const = 'C__CATG__GLOBAL'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Add categories to sim card Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: SET @TYPEID = (SELECT isys_obj_type__id FROM isys_obj_type WHERE isys_obj_type__const = 'C__OBJTYPE__SIM_CARD')
[2011-11-04 09:27:49]: QUERY: SET @GLOBAL = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__GLOBAL')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg SET isys_obj_type_2_isysgui_catg__isysgui_catg__id = @GLOBAL, isys_obj_type_2_isysgui_catg__isys_obj_type__id = @TYPEID
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg_overview SET isys_obj_type__id = @TYPEID, isysgui_catg__id = @GLOBAL, isys_obj_type_2_isysgui_catg_overview__sort = 0
[2011-11-04 09:27:49]: QUERY: SET @RELATION = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__RELATION')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg SET isys_obj_type_2_isysgui_catg__isysgui_catg__id = @RELATION, isys_obj_type_2_isysgui_catg__isys_obj_type__id = @TYPEID
[2011-11-04 09:27:49]: QUERY: SET @LOGBOOK = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__LOGBOOK')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg SET isys_obj_type_2_isysgui_catg__isysgui_catg__id = @LOGBOOK, isys_obj_type_2_isysgui_catg__isys_obj_type__id = @TYPEID
[2011-11-04 09:27:49]: QUERY: SET @SIMCARD = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__SIM_CARD')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg SET isys_obj_type_2_isysgui_catg__isysgui_catg__id = @SIMCARD, isys_obj_type_2_isysgui_catg__isys_obj_type__id = @TYPEID
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_obj_type_2_isysgui_catg_overview SET isys_obj_type__id = @TYPEID, isysgui_catg__id = @SIMCARD, isys_obj_type_2_isysgui_catg_overview__sort = 1
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isys_cats_mobile_phone_list';
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Create new table for mobile phone Created.
[2011-11-04 09:27:49]: QUERY: CREATE TABLE isys_cats_mobile_phone_list ( isys_cats_mobile_phone_list__id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , isys_cats_mobile_phone_list__isys_obj__id INT( 10 ) UNSIGNED NOT NULL, isys_cats_mobile_phone_list__imei_number VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , isys_cats_mobile_phone_list__description TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , isys_cats_mobile_phone_list__status INT( 10 ) UNSIGNED NULL DEFAULT NULL, KEY `isys_cats_mobile_phone_list__isys_obj__id` (`isys_cats_mobile_phone_list__isys_obj__id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1
[2011-11-04 09:27:49]: QUERY: ALTER TABLE isys_cats_mobile_phone_list ADD CONSTRAINT `isys_cats_mobile_phone_list_ibfk_2` FOREIGN KEY (`isys_cats_mobile_phone_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_relation_type__id FROM isys_relation_type WHERE isys_relation_type__const = 'C__RELATION_TYPE__MOBILE_PHONE'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Updating value..  Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_relation_type (isys_relation_type__title, isys_relation_type__master, isys_relation_type__slave, isys_relation_type__type, isys_relation_type__default, isys_relation_type__const, isys_relation_type__category, isys_relation_type__editable, isys_relation_type__sort, isys_relation_type__status) VALUES('LC__CMDB__CATG__ASSIGNED_CARDS', 'LC__RELATION_TYPE__MASTER__ASSIGNED_CARDS', 'LC__RELATION_TYPE__SLAVE__ASSIGNED_CARDS', 1, 1, 'C__RELATION_TYPE__MOBILE_PHONE', 'C__CATG__ASSIGNED_CARDS', 0, 32, 2)
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__CELL_PHONE_CONTRACT' AND isysgui_cats__source_table = 'isys_cats_cp_contract_list'; 
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Updating value..  Value already existing.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isys_catg_sim_card_list';
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Create new table for sim card Created.
[2011-11-04 09:27:49]: QUERY: CREATE TABLE IF NOT EXISTS isys_catg_sim_card_list ( isys_catg_sim_card_list__id int(10) unsigned NOT NULL AUTO_INCREMENT, isys_catg_sim_card_list__isys_obj__id int(10) unsigned DEFAULT NULL, isys_catg_sim_card_list__isys_cp_contract_type__id int(10) unsigned DEFAULT NULL, isys_catg_sim_card_list__title varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__description text COLLATE utf8_unicode_ci, isys_catg_sim_card_list__status int(10) unsigned DEFAULT NULL, isys_catg_sim_card_list__property int(10) unsigned DEFAULT NULL, isys_catg_sim_card_list__serial_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__phone_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__pin varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__pin2 varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__puk varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__puk2 varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_pin varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_serial_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_phone_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_card_number varchar(255) COLLATE utf8_unicode_ci NOT NULL, isys_catg_sim_card_list__tc_pin2 varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_puk varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__tc_puk2 varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__optional_info text COLLATE utf8_unicode_ci, isys_catg_sim_card_list__twincard int(10) unsigned DEFAULT '0', isys_catg_sim_card_list__card_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__client_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, isys_catg_sim_card_list__end_date datetime DEFAULT NULL, isys_catg_sim_card_list__start_date datetime DEFAULT NULL, isys_catg_sim_card_list__threshold_date date NOT NULL, isys_catg_sim_card_list__isys_network_provider__id int(10) unsigned DEFAULT NULL, isys_catg_sim_card_list__isys_telephone_rate__id int(10) unsigned DEFAULT NULL, PRIMARY KEY (`isys_catg_sim_card_list__id`), KEY `isys_catg_sim_card_list__isys_cp_contract_type__id` (`isys_catg_sim_card_list__isys_cp_contract_type__id`), KEY `isys_catg_sim_card_list__isys_network_provider__id` (`isys_catg_sim_card_list__isys_network_provider__id`), KEY `isys_catg_sim_card_list__isys_telephone_rate__id` (`isys_catg_sim_card_list__isys_telephone_rate__id`), KEY `isys_catg_sim_card_list__isys_obj__id` (`isys_catg_sim_card_list__isys_obj__id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1
[2011-11-04 09:27:49]: QUERY: ALTER TABLE isys_catg_sim_card_list ADD CONSTRAINT `isys_catg_sim_card_list_ibfk_1` FOREIGN KEY (`isys_catg_sim_card_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `isys_catg_sim_card_list_ibfk_2` FOREIGN KEY (`isys_catg_sim_card_list__isys_cp_contract_type__id`) REFERENCES `isys_cp_contract_type` (`isys_cp_contract_type__id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `isys_catg_sim_card_list_ibfk_3` FOREIGN KEY (`isys_catg_sim_card_list__isys_network_provider__id`) REFERENCES `isys_network_provider` (`isys_network_provider__id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `isys_catg_sim_card_list_ibfk_4` FOREIGN KEY (`isys_catg_sim_card_list__isys_telephone_rate__id`) REFERENCES `isys_telephone_rate` (`isys_telephone_rate__id`) ON DELETE SET NULL ON UPDATE CASCADE
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: No Query found.
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Dropping FK isys_cats_person_list__isys_catg_relation_list__id .. Dropped.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW COLUMNS FROM `isys_cats_lic_item` WHERE (`Field` = 'isys_cats_lic_item__key')
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Adding field isys_cats_lic_item__key to table isys_cats_lic_item..  Already exists.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isysgui_cats';
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Updating value in table isysgui_cats..  Updated.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isysgui_cats';
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Updating value in table isysgui_cats..  Updated.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__property1_columnname = 'isys_catg_sim_card_list__start_date'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Updating value..  Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: SET @CATID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__SIM_CARD')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_property_2_cat (isys_property_2_cat__isysgui_catg__id, isys_property_2_cat__cat_type, isys_property_2_cat__property1_title, isys_property_2_cat__property1_columnname) VALUES (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__START_DATE', 'isys_catg_sim_card_list__start_date'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__END_DATE', 'isys_catg_sim_card_list__end_date'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__THRESHOLD', 'isys_catg_sim_card_list__threshold_date'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_catg_sim_card_list__card_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_catg_sim_card_list__phone_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__CLIENT_NUMBER', 'isys_catg_sim_card_list__client_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_catg_sim_card_list__pin'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_catg_sim_card_list__pin2'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_catg_sim_card_list__puk'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_catg_sim_card_list__puk2'), (@CATID, 'g', 'LC__CMDB__CATG__SERIAL', 'isys_catg_sim_card_list__serial_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__TWINCARD', 'isys_catg_sim_card_list__twincard'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_catg_sim_card_list__tc_card_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_catg_sim_card_list__tc_phone_number'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_catg_sim_card_list__tc_pin'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_catg_sim_card_list__tc_pin2'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_catg_sim_card_list__tc_puk'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_catg_sim_card_list__tc_puk2'), (@CATID, 'g', 'LC__CMDB__CATG__SERIAL', 'isys_catg_sim_card_list__tc_serial_number')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_property_2_cat (isys_property_2_cat__isysgui_catg__id, isys_property_2_cat__cat_type, isys_property_2_cat__property1_title, isys_property_2_cat__property1_columnname, isys_property_2_cat__property1_reference) VALUES (@CATID, 'g', 'LC__CMDB__CATG__TYPE', 'isys_catg_sim_card_list__isys_cp_contract_type__id', 'isys_cp_contract_type'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__NETWORK_PROVIDER', 'isys_catg_sim_card_list__isys_network_provider__id', 'isys_network_provider'), (@CATID, 'g', 'LC__CMDB__CATS_CP_CONTRACT__TELEPHONE_RATE', 'isys_catg_sim_card_list__isys_telephone_rate__id', 'isys_telephone_rate')
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__property1_columnname = 'isys_cats_krypto_card_list__certificate_number'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Updating value..  Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: SET @CATID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__KRYPTO_CARD')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_property_2_cat (isys_property_2_cat__isysgui_cats__id, isys_property_2_cat__cat_type, isys_property_2_cat__property1_title, isys_property_2_cat__property1_columnname) VALUES (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__CERTIFICATE_NUMBER', 'isys_cats_krypto_card_list__certificate_number'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__CERTGATE_CARD_NUMBER', 'isys_cats_krypto_card_list__certgate_card_number'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__CERTIFICATE_TITLE', 'isys_cats_krypto_card_list__certificate_title'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__CERTIFICATE_PASSWORD', 'isys_cats_krypto_card_list__certificate_password'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__CERTIFICATE_PROCEDURE', 'isys_cats_krypto_card_list__certificate_procedure'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__DATE_OF_ISSUE', 'isys_cats_krypto_card_list__date_of_issue'), (@CATID, 's', 'LC__CMDB__CATS__KRYPTO_CARD__IMEI_NUMBER', 'isys_cats_krypto_card_list__imei_number')
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__property1_columnname = 'isys_catg_tsi_service_list__tsi_service_id'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Updating value..  Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: SET @CATID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__TSI_SERVICE')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_property_2_cat (isys_property_2_cat__isysgui_catg__id, isys_property_2_cat__cat_type, isys_property_2_cat__property1_title, isys_property_2_cat__property1_columnname) VALUES (@CATID, 'g', 'LC__CMDB__CATG__TSI_SERVICE__TSI_SERVICE_ID', 'isys_catg_tsi_service_list__tsi_service_id')
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT * FROM isys_stor_raid_level WHERE isys_stor_raid_level__const = 'C__STOR_RAID_LEVEL__6'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Adding Raid Level 6 Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_stor_raid_level VALUES(NULL, '6', NULL, 'C__STOR_RAID_LEVEL__6', 70, 0, 2)
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: No Query found.
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Executing query.. OK
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT * FROM isys_stor_raid_level WHERE isys_stor_raid_level__const = 'C__STOR_RAID_LEVEL__6'; 
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Adding Raid Level 6 Value already existing.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isys_temp_unit';
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Updating value in table isys_temp_unit..  Updated.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isys_person_intern';
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Creating table isys_person_intern.. Table already existing.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: SHOW TABLES LIKE 'isys_person_extern';
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Creating table isys_person_extern.. Table already existing.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: No Query found.
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: Dropping FK isys_cats_net_list__isys_net_type__id .. Dropped.
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking :: No Query found.
[2011-11-04 09:27:49]: Result   :: True
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__property1_columnname = 'isys_cats_mobile_phone_list__imei_number'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Updating value..  Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: SET @CATID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__CELL_PHONE_CONTRACT')
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_property_2_cat (isys_property_2_cat__isysgui_cats__id, isys_property_2_cat__cat_type, isys_property_2_cat__property1_title, isys_property_2_cat__property1_columnname) VALUES (@CATID, 's', 'IMEI', 'isys_cats_mobile_phone_list__imei_number')
[2011-11-04 09:27:49]: --
[2011-11-04 09:27:49]: Checking ::  SELECT isys_relation_type__id FROM isys_relation_type WHERE isys_relation_type__const = 'C__RELATION_TYPE__ORGANIZATION'; 
[2011-11-04 09:27:49]: Result   :: False
[2011-11-04 09:27:49]: Relation Type organization Value(s) inserted/updated.
[2011-11-04 09:27:49]: QUERY: INSERT INTO isys_relation_type (isys_relation_type__title, isys_relation_type__master, isys_relation_type__slave, isys_relation_type__type, isys_relation_type__default, isys_relation_type__const, isys_relation_type__category, isys_relation_type__editable, isys_relation_type__sort, isys_relation_type__status) VALUES ('LC__CMDB__CATS__ORGANIZATION', 'LC__RELATION_TYPE__MASTER__BELONGS_TO', 'LC__RELATION_TYPE__SLAVE__BELONGS_TO', 1, 1, 'C__RELATION_TYPE__ORGANIZATION', 'C__CATS__PERSON', 0, 33, 2)
[2011-11-04 09:27:50]: --
[2011-11-04 09:27:50]: Checking ::  SELECT isys_obj__id FROM isys_obj INNER JOIN isys_catg_relation_list ON isys_catg_relation_list__isys_obj__id = isys_obj__id WHERE ISNULL(isys_catg_relation_list__isys_relation_type__id); 
[2011-11-04 09:27:50]: Result   :: True
[2011-11-04 09:27:50]: Fix for relation type organization Value already existing.
[2011-11-04 09:27:50]: --
[2011-11-04 09:27:50]: Checking :: No Query found.
[2011-11-04 09:27:50]: Result   :: True
[2011-11-04 09:27:50]: Dropping FK isys_catg_location_list__isys_catg_relation_list__id .. Dropped.
[2011-11-04 09:27:50]: --
[2011-11-04 09:27:50]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__order_no')
[2011-11-04 09:27:50]: Result   :: True
[2011-11-04 09:27:50]: Adding field isys_catg_global_list__order_no to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:51]: --
[2011-11-04 09:27:51]: Checking :: No Query found.
[2011-11-04 09:27:51]: Result   :: True
[2011-11-04 09:27:51]: Dropping FK isys_catg_global_list__isys_guarantee_period_unit__id .. Dropped.
[2011-11-04 09:27:51]: --
[2011-11-04 09:27:51]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__isys_guarantee_period_unit__id')
[2011-11-04 09:27:51]: Result   :: True
[2011-11-04 09:27:51]: Adding field isys_catg_global_list__isys_guarantee_period_unit__id to table isys_ca.. Already exists.
[2011-11-04 09:27:52]: --
[2011-11-04 09:27:52]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__guarantee_period')
[2011-11-04 09:27:52]: Result   :: True
[2011-11-04 09:27:52]: Adding field isys_catg_global_list__guarantee_period to table isys_catg_global_list.. Already exists.
[2011-11-04 09:27:53]: --
[2011-11-04 09:27:53]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__sysid')
[2011-11-04 09:27:53]: Result   :: True
[2011-11-04 09:27:53]: Adding field isys_catg_global_list__sysid to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:54]: --
[2011-11-04 09:27:54]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__price')
[2011-11-04 09:27:54]: Result   :: True
[2011-11-04 09:27:54]: Adding field isys_catg_global_list__price to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:55]: --
[2011-11-04 09:27:55]: Checking :: No Query found.
[2011-11-04 09:27:55]: Result   :: True
[2011-11-04 09:27:55]: Dropping FK isys_catg_global_list__isys_contact__id .. Dropped.
[2011-11-04 09:27:55]: --
[2011-11-04 09:27:55]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__isys_contact__id')
[2011-11-04 09:27:55]: Result   :: True
[2011-11-04 09:27:55]: Adding field isys_catg_global_list__isys_contact__id to table isys_catg_global_list.. Already exists.
[2011-11-04 09:27:56]: --
[2011-11-04 09:27:56]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__scantime')
[2011-11-04 09:27:56]: Result   :: True
[2011-11-04 09:27:56]: Adding field isys_catg_global_list__scantime to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:56]: --
[2011-11-04 09:27:56]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__imported')
[2011-11-04 09:27:56]: Result   :: True
[2011-11-04 09:27:56]: Adding field isys_catg_global_list__imported to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:57]: --
[2011-11-04 09:27:57]: Checking :: SHOW COLUMNS FROM `isys_catg_global_list` WHERE (`Field` = 'isys_catg_global_list__hostname')
[2011-11-04 09:27:57]: Result   :: True
[2011-11-04 09:27:57]: Adding field isys_catg_global_list__hostname to table isys_catg_global_list..  Already exists.
[2011-11-04 09:27:57]: --
[2011-11-04 09:27:57]: Checking :: SHOW TABLES LIKE 'isys_db_init';
[2011-11-04 09:27:57]: Result   :: True
[2011-11-04 09:27:57]: Version change Updated.