blob: d2f7ae16f8d478665c0a2e54c80d01692b980736 (
plain)
1
2
3
4
5
6
7
8
|
-- Support a '0' weight.
ALTER TABLE chars ALTER COLUMN weight DROP DEFAULT;
ALTER TABLE chars ALTER COLUMN weight DROP NOT NULL;
ALTER TABLE chars_hist ALTER COLUMN weight DROP DEFAULT;
ALTER TABLE chars_hist ALTER COLUMN weight DROP NOT NULL;
UPDATE chars SET weight = NULL WHERE weight = 0;
UPDATE chars_hist SET weight = NULL WHERE weight = 0;
|