CREATE TABLE `microsite_group_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `microsite_id` int(11) NOT NULL,
  `object_id` bigint(20) NOT NULL,
  `app_slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `type` varchar(20) COLLATE utf8_hungarian_ci NOT NULL DEFAULT 'local',
  `objectname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `material` varchar(100) COLLATE utf8_hungarian_ci NOT NULL,
  `picture` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
  `subscription_type` varchar(20) COLLATE utf8_hungarian_ci NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`id`),
  KEY `microsite_id` (`microsite_id`),
  KEY `object_id` (`object_id`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci