 
 
 --
+-- Name: ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY ar_internal_metadata
+    ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
+
+
+--
 -- Name: chembl_molecule_synonyms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: chembl_molecule_synonyms; Type: TABLE; Schema: public; Owner: -; Tablespace: 



--
-- Name: chembl_molecule_synonyms_molregno_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX chembl_molecule_synonyms_molregno_idx ON chembl_molecule_synonyms USING btree (molregno);


--
-- Name: chembl_molecule_synonyms_upper_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX chembl_molecule_synonyms_upper_idx ON chembl_molecule_synonyms USING btree (upper((synonym)::text));


--
-- Name: chembl_molecules_molregno_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX chembl_molecules_molregno_idx ON chembl_molecules USING btree (molregno);


--
-- Name: chembl_molecules_upper_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX chembl_molecules_upper_idx ON chembl_molecules USING btree (upper((pref_name)::text));


--
-- Name: chembl_molecules_upper_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX chembl_molecules_upper_idx1 ON chembl_molecules USING btree (upper((chembl_id)::text));


--
-- Name: drug_claim_aliases_drug_claim_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

