--
-- PostgreSQL database dump
--

CREATE TABLE chsaw_chain (
    pdb character(4) NOT NULL,
    code character(1) NOT NULL,
    chainid character(5) NOT NULL,
    chainid2 character varying(7) NOT NULL,
    residues integer DEFAULT 0,
    aminoacids integer DEFAULT 0,
    heterogens integer DEFAULT 0,
    solvent integer DEFAULT 0,
    "sequence" text,
    organism text,
    compound text,
    eccode character varying(15)
);


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


CREATE UNIQUE INDEX chsaw_chain_code_key ON chsaw_chain USING btree (code, pdb);

CREATE INDEX chsaw_chain_pdb_idx ON chsaw_chain USING btree (pdb);


CREATE UNIQUE INDEX chsaw_chain_chainid_idx ON chsaw_chain USING btree (chainid);

CREATE UNIQUE INDEX chsaw_chain_chainid2_idx ON chsaw_chain USING btree (chainid2);


ALTER TABLE ONLY chsaw_chain
    ADD CONSTRAINT chsaw_chain_pdb_check FOREIGN KEY (pdb) REFERENCES chsaw_pdb(code) ON UPDATE NO ACTION ON DELETE NO ACTION;