151to160.sql 466 B

1234567891011
  1. ALTER TABLE `jl_user_profiles` ADD `remark` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注信息';
  2. CREATE TABLE IF NOT EXISTS `jl_share` (
  3. `sid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `hashcode` char(255) NOT NULL,
  5. `ids` int(11) NOT NULL,
  6. `idtype` tinyint(3) UNSIGNED NOT NULL,
  7. `intime` int(10) UNSIGNED NOT NULL,
  8. `endtime` int(10) UNSIGNED NOT NULL,
  9. PRIMARY KEY (`sid`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;