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