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;
|