summaryrefslogtreecommitdiff
path: root/util/updates/update_1.1.sql
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';