CREATE TABLE `ids` (
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `field_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `nextid` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`table_name`,`field_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

START TRANSACTION;
	SET @hostid = (SELECT nextid FROM ids WHERE table_name='hosts' AND field_name='hostid');
	UPDATE ids SET nextid = nextid+1 WHERE table_name='hosts' AND field_name='hostid';
	SET @hosttempateid = (SELECT nextid FROM ids WHERE table_name='hosts_templates' AND field_name='hosttemplateid');
	UPDATE ids SET nextid = nextid+1 WHERE table_name='hosts_templates' AND field_name='hosttemplateid';
	SET @hostgroupid = (SELECT nextid FROM ids WHERE table_name='hosts_groups' AND field_name='hostgroupid');
	UPDATE ids SET nextid = nextid+1 WHERE table_name='hosts_groups' AND field_name='hostgroupid';
	SET @interfaceid = (SELECT nextid FROM ids WHERE table_name='interface' AND field_name='interfaceid');
	UPDATE ids SET nextid = nextid+1 WHERE table_name='interface' AND field_name='interfaceid';
COMMIT;