1 CREATE TABLE freshmeat (
2 projectname_short VARCHAR(64) NOT NULL,
3 latest_version VARCHAR(32) DEFAULT 'none'::VARCHAR NOT NULL,
5 url_homepage VARCHAR(128),
6 desc_short VARCHAR(96) NOT NULL
9 REVOKE ALL ON TABLE freshmeat FROM PUBLIC;
11 ALTER TABLE ONLY freshmeat
12 ADD CONSTRAINT freshmeat_pkey PRIMARY KEY (projectname_short, latest_version);