mirror of https://github.com/rocboss/paopao-ce
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
307 B
10 lines
307 B
ALTER TABLE `p_user` ADD COLUMN `salt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '盐值';
|
|
|
|
UPDATE
|
|
`p_user`
|
|
SET
|
|
`salt` = SUBSTRING_INDEX(`password`, ':', -1),
|
|
`password` = SUBSTRING_INDEX(`password`, ':', 1);
|
|
|
|
ALTER TABLE `p_user` MODIFY COLUMN `password` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '密码';
|