DROP TABLE IF EXISTS `HYCLOUDSITERELATION`;
CREATE TABLE `HYCLOUDSITERELATION` (
  `SRCSITECODE` varchar(200) NOT NULL,
  `SITEID` int(11) NOT NULL,
  PRIMARY KEY (`SRCSITECODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `HYCLOUDCHANNELRELATION`;
CREATE TABLE `HYCLOUDCHANNELRELATION` (
  `SRCCHANNELCODE` varchar(200) NOT NULL,
  `CHANNELID` int(11) NOT NULL,
  PRIMARY KEY (`SRCCHANNELCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;