blob: 0538e3d5f8b8d35dff331711e5686994a9c8a71f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
ALTER TABLE users ADD COLUMN pvotes smallint NOT NULL DEFAULT 1;
ALTER TABLE users ADD COLUMN pfind smallint NOT NULL DEFAULT 1;
UPDATE users
SET registered = 1191004915
WHERE registered = 0;
UPDATE votes
SET date = 1191004915
WHERE date = 0;
ALTER TABLE vnr RENAME COLUMN relation TO rel_old;
ALTER TABLE vnr ADD COLUMN relation varchar(32) NOT NULL DEFAULT 'Original release';
|