ALTER TABLE `jl_user_profiles` ADD `remark` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注信息';

CREATE TABLE IF NOT EXISTS `jl_share` (
  `sid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `hashcode` char(255) NOT NULL,
  `ids` int(11) NOT NULL,
  `idtype` tinyint(3) UNSIGNED NOT NULL,
  `intime` int(10) UNSIGNED NOT NULL,
  `endtime` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;