8 lines
266 B
MySQL
8 lines
266 B
MySQL
|
-- locidispid must be bigint
|
||
|
|
|
||
|
|
ALTER TABLE users DROP COLUMN locidispid;
|
||
|
|
ALTER TABLE users ADD COLUMN locidispid BIGINT;
|
||
|
|
ALTER TABLE users ALTER COLUMN locidispid SET DEFAULT 0;
|
||
|
|
UPDATE users SET locidispid = 0;
|
||
|
|
ALTER TABLE users ALTER COLUMN locidispid SET NOT NULL;
|