-- Table structure for table `mdl_mnet_host2service`
-- 

DROP TABLE IF EXISTS `mdl_mnet_host2service`;
CREATE TABLE IF NOT EXISTS `mdl_mnet_host2service` (
  `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `hostid` bigint(10) unsigned NOT NULL DEFAULT '0',
  `serviceid` bigint(10) unsigned NOT NULL DEFAULT '0',
  `publish` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `subscribe` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnethost_hosser_uix` (`hostid`,`serviceid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Information about the services for a given host' AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `mdl_mnet_host2service`
-- 

INSERT INTO `mdl_mnet_host2service` (`id`, `hostid`, `serviceid`, `publish`, `subscribe`) VALUES (1, 0, 1, 1, 0),
(2, 0, 4, 1, 0);