forked from Gitlink/microservices
15 lines
867 B
SQL
15 lines
867 B
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
ALTER TABLE `ruoyi-gitlink`.`cms_doc`
|
|
ADD COLUMN `publish_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布人' AFTER `sort`;
|
|
|
|
ALTER TABLE `ruoyi-gitlink`.`cms_doc`
|
|
ADD COLUMN `publish_user_image` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布人头像' AFTER `publish_user`;
|
|
|
|
ALTER TABLE `ruoyi-gitlink`.`cms_doc`
|
|
ADD COLUMN `publish_user_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布人访问地址' AFTER `publish_user_image`;
|
|
|
|
ALTER TABLE `ruoyi-gitlink`.`cms_doc`
|
|
ADD COLUMN `publish_user_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布人昵称' AFTER `publish_user_url`;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |