summaryrefslogtreecommitdiff
path: root/util/updates/update_2.3.sql
blob: d43718c933c269b145a56230a41519225e5b2b27 (plain)
1
2
3
4
5
6
7
8
9
10
11

-- some random VN quotes
CREATE TABLE quotes (
  vid integer NOT NULL REFERENCES vn (id),
  quote varchar(250) NOT NULL,
  PRIMARY KEY(vid, quote)
) WITHOUT OIDS;


-- catalog numbers for releases
ALTER TABLE releases_rev ADD COLUMN catalog varchar(50) NOT NULL DEFAULT '';