5 lines
228 B
SQL
5 lines
228 B
SQL
ALTER TABLE users RENAME COLUMN HashedPassword TO HashedPasswordOld;
|
|
ALTER TABLE users ADD COLUMN HashedPassword char(60) NULL;
|
|
UPDATE users SET HashedPassword=HashedPasswordOld;
|
|
ALTER TABLE users DROP COLUMN HashedPasswordOld;
|