--
-- PostgreSQL database dump
--

CREATE TABLE chsaw_pdb (
    code character(4) NOT NULL,
    deposited date NOT NULL,
    lastrev date DEFAULT now(),
    experiment integer NOT NULL,
    resolution double precision NOT NULL,
    header character varying(40) NOT NULL,
    title text
);


REVOKE ALL ON TABLE chsaw_pdb FROM PUBLIC;
GRANT SELECT ON TABLE chsaw_pdb TO PUBLIC;


CREATE UNIQUE INDEX chsaw_pdb_code_key ON chsaw_pdb USING btree (code);