CREATE TABLE `ke_tag_relation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_id` int(10) NOT NULL,
  `object_id` int(10) NOT NULL,
  `type` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

INSERT INTO `ke_tag_relation` VALUES ('1', '5', '0', '0');
INSERT INTO `ke_tag_relation` VALUES ('2', '19', '28', '0');
INSERT INTO `ke_tag_relation` VALUES ('9', '28', '14', '0');

ALTER TABLE `ke_document` DROP COLUMN  tag;
ALTER TABLE `ke_goods` ALTER   comment_count  SET DEFAULT '0';
ALTER TABLE `ke_goods` ALTER   goods_type  SET DEFAULT '';
ALTER TABLE `ke_goods` ALTER   pic_url  SET DEFAULT '';
ALTER TABLE `ke_goods` MODIFY  click_url  TEXT NOT NULL DEFAULT '';
ALTER TABLE `ke_goods` DROP COLUMN  shop_url;
ALTER TABLE `ke_goods` DROP COLUMN  sclick_url;
ALTER TABLE `ke_goods` DROP COLUMN  tag;
ALTER TABLE `ke_collect_goods` DROP COLUMN  click_url;
ALTER TABLE `ke_collect_goods` MODIFY pic_url VARCHAR(255) NOT NULL DEFAULT '';
DELETE FROM `ke_attribute` WHERE id = '33';
UPDATE `ke_hooks` SET addons='Attachment,UrlToBaidu' WHERE id='6';