summaryrefslogtreecommitdiff
path: root/util/updates/update_1.2.sql
blob: c1b48b84d0e07b48a97542a97efb974be680a4a1 (plain)
1
2
3
4
5
6
7
8
9
CREATE TABLE vnlists (
  uid integer NOT NULL DEFAULT 0,
  vid integer NOT NULL DEFAULT 0,
  status smallint NOT NULL DEFAULT 0,
  added bigint NOT NULL DEFAULT 0,
  PRIMARY KEY(uid, vid)
) WITHOUT OIDS;

ALTER TABlE users ADD COLUMN plist smallint NOT NULL DEFAULT 1;