宁波妈妈网

回帖：update f_posts_re_18 set to_id=0 where to_id is NULL;
ALTER TABLE `f_posts_re_18`
MODIFY COLUMN `to_id`int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '回复对象ID' AFTER `uid`,
MODIFY COLUMN `nickname`varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `to_id`,
ADD COLUMN `to_name`varchar(50) NULL DEFAULT NULL COMMENT '回复对象用户昵称' AFTER `to_id`

北斗星回帖于2019-01-31 12:29

下一楼›：ALTER TABLE `f_threads`
ADD INDEX `reply_num` (`reply_num`) USING BTREE,
ADD INDEX ..(北斗星)
‹上一楼：ALTER TABLE `f_threads`
ADD COLUMN `cid`tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT ..(北斗星)

查看全部回帖(8)

«返回主帖