source: cats/ISOcat/trunk/mod-ISOcat-access-data/dbms/ISOcat-schema-constraints.sql @ 2159

--
-- TOC entry 2264 (class 2606 OID 359728)
-- Dependencies: 1763 1763
-- Name: DCRB primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_dcr_board
    ADD CONSTRAINT "DCRB primary key" PRIMARY KEY (id);


--
-- TOC entry 2198 (class 2606 OID 359730)
-- Dependencies: 1740 1740
-- Name: account primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_account
    ADD CONSTRAINT "account primary key" PRIMARY KEY (id);


--
-- TOC entry 2200 (class 2606 OID 359732)
-- Dependencies: 1742 1742
-- Name: adhoc group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_adhoc_group
    ADD CONSTRAINT "adhoc group primary key" PRIMARY KEY (id);


--
-- TOC entry 2205 (class 2606 OID 359734)
-- Dependencies: 1743 1743
-- Name: change request name unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "change request name unique" UNIQUE (name);


--
-- TOC entry 2207 (class 2606 OID 359736)
-- Dependencies: 1743 1743
-- Name: change request primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "change request primary key" PRIMARY KEY (id);


--
-- TOC entry 2214 (class 2606 OID 359738)
-- Dependencies: 1747 1747
-- Name: closed data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_closed_data_category
    ADD CONSTRAINT "closed data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2414 (class 2606 OID 359740)
-- Dependencies: 1806 1806 1806
-- Name: closed data category profile value domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_closed_data_category_conceptual_domains
    ADD CONSTRAINT "closed data category profile value domain primary key" PRIMARY KEY (dc, cd);


--
-- TOC entry 2216 (class 2606 OID 359742)
-- Dependencies: 1748 1748
-- Name: closed linguistic section primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_closed_linguistic_section
    ADD CONSTRAINT "closed linguistic section primary key" PRIMARY KEY (id);


--
-- TOC entry 2220 (class 2606 OID 359744)
-- Dependencies: 1749 1749
-- Name: complex data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_complex_data_category
    ADD CONSTRAINT "complex data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2222 (class 2606 OID 359746)
-- Dependencies: 1749 1749
-- Name: complex data category unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_complex_data_category
    ADD CONSTRAINT "complex data category unique" UNIQUE (id);


--
-- TOC entry 2224 (class 2606 OID 359748)
-- Dependencies: 1750 1750
-- Name: conceptual domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_conceptual_domain
    ADD CONSTRAINT "conceptual domain primary key" PRIMARY KEY (id);


--
-- TOC entry 2226 (class 2606 OID 359750)
-- Dependencies: 1752 1752
-- Name: conceptual domain rule primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_conceptual_domain_rule
    ADD CONSTRAINT "conceptual domain rule primary key" PRIMARY KEY (id);


--
-- TOC entry 2228 (class 2606 OID 359752)
-- Dependencies: 1753 1753
-- Name: constrained data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_constrained_data_category
    ADD CONSTRAINT "constrained data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2418 (class 2606 OID 359754)
-- Dependencies: 1807 1807 1807
-- Name: constrained data category schema specific domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_constrained_data_category_conceptual_domains
    ADD CONSTRAINT "constrained data category schema specific domain primary key" PRIMARY KEY (dc, cd);


--
-- TOC entry 2422 (class 2606 OID 359756)
-- Dependencies: 1808 1808 1808
-- Name: constrained linguistic section conceptual domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_constrained_linguistic_section_conceptual_domains
    ADD CONSTRAINT "constrained linguistic section conceptual domain primary key" PRIMARY KEY (ls, cd);


--
-- TOC entry 2230 (class 2606 OID 359758)
-- Dependencies: 1754 1754
-- Name: constrained linguistic section primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_constrained_linguistic_section
    ADD CONSTRAINT "constrained linguistic section primary key" PRIMARY KEY (id);


--
-- TOC entry 2233 (class 2606 OID 359760)
-- Dependencies: 1755 1755
-- Name: container data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_container_data_category
    ADD CONSTRAINT "container data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2251 (class 2606 OID 359762)
-- Dependencies: 1758 1758
-- Name: data category selection primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_data_category_selection
    ADD CONSTRAINT "data category selection primary key" PRIMARY KEY (id);


--
-- TOC entry 2426 (class 2606 OID 359764)
-- Dependencies: 1809 1809 1809
-- Name: data category selection user; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_data_category_selection_users
    ADD CONSTRAINT "data category selection user" PRIMARY KEY (dcs, "user");


--
-- TOC entry 2257 (class 2606 OID 359766)
-- Dependencies: 1760 1760
-- Name: data type primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_data_type
    ADD CONSTRAINT "data type primary key" PRIMARY KEY (id);


--
-- TOC entry 2259 (class 2606 OID 359768)
-- Dependencies: 1760 1760
-- Name: data type unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_data_type
    ADD CONSTRAINT "data type unique" UNIQUE (data_type);


--
-- TOC entry 2235 (class 2606 OID 359770)
-- Dependencies: 1756 1756
-- Name: datacategory primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_data_category
    ADD CONSTRAINT "datacategory primary key" PRIMARY KEY (id);


--
-- TOC entry 2283 (class 2606 OID 359772)
-- Dependencies: 1768 1768 1768
-- Name: dc language unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_language_section
    ADD CONSTRAINT "dc language unique" UNIQUE (dc, language);


--
-- TOC entry 2266 (class 2606 OID 359774)
-- Dependencies: 1764 1764
-- Name: decision group dc unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_decision_group
    ADD CONSTRAINT "decision group dc unique" UNIQUE (dc);


--
-- TOC entry 2268 (class 2606 OID 359776)
-- Dependencies: 1764 1764
-- Name: decision group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_decision_group
    ADD CONSTRAINT "decision group primary key" PRIMARY KEY (id);


--
-- TOC entry 2441 (class 2606 OID 359778)
-- Dependencies: 1812 1812 1812
-- Name: group members primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_group_members
    ADD CONSTRAINT "group members primary key" PRIMARY KEY ("group", member);


--
-- TOC entry 2273 (class 2606 OID 359780)
-- Dependencies: 1765 1765
-- Name: group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_group
    ADD CONSTRAINT "group primary key" PRIMARY KEY (id);


--
-- TOC entry 2277 (class 2606 OID 359782)
-- Dependencies: 1766 1766
-- Name: language name unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_language
    ADD CONSTRAINT "language name unique" UNIQUE (name);


--
-- TOC entry 2279 (class 2606 OID 359784)
-- Dependencies: 1766 1766
-- Name: language primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_language
    ADD CONSTRAINT "language primary key" PRIMARY KEY (id);


--
-- TOC entry 2287 (class 2606 OID 359786)
-- Dependencies: 1768 1768
-- Name: language section primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_language_section
    ADD CONSTRAINT "language section primary key" PRIMARY KEY (id);


--
-- TOC entry 2281 (class 2606 OID 359788)
-- Dependencies: 1766 1766
-- Name: language tag unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_language
    ADD CONSTRAINT "language tag unique" UNIQUE (tag);


--
-- TOC entry 2290 (class 2606 OID 359790)
-- Dependencies: 1770 1770
-- Name: linguistic section primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_linguistic_section
    ADD CONSTRAINT "linguistic section primary key" PRIMARY KEY (id);


--
-- TOC entry 2433 (class 2606 OID 359792)
-- Dependencies: 1810 1810 1810
-- Name: link dc rights primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_dc_access
    ADD CONSTRAINT "link dc rights primary key" PRIMARY KEY (dc, account);


--
-- TOC entry 2439 (class 2606 OID 359794)
-- Dependencies: 1811 1811 1811
-- Name: link dcs access primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_dcs_access
    ADD CONSTRAINT "link dcs access primary key" PRIMARY KEY (dcs, account);


--
-- TOC entry 2387 (class 2606 OID 359796)
-- Dependencies: 1800 1800
-- Name: lock primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY generic_lock
    ADD CONSTRAINT "lock primary key" PRIMARY KEY (id);


--
-- TOC entry 2374 (class 2606 OID 359798)
-- Dependencies: 1798 1798
-- Name: login unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_user
    ADD CONSTRAINT "login unique" UNIQUE (login);


--
-- TOC entry 2298 (class 2606 OID 359800)
-- Dependencies: 1772 1772
-- Name: message primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_message
    ADD CONSTRAINT "message primary key" PRIMARY KEY (id);


--
-- TOC entry 2398 (class 2606 OID 359802)
-- Dependencies: 1802 1802
-- Name: name primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY generic_name
    ADD CONSTRAINT "name primary key" PRIMARY KEY (id);


--
-- TOC entry 2363 (class 2606 OID 359804)
-- Dependencies: 1797 1797
-- Name: name unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_thematic_domain_group
    ADD CONSTRAINT "name unique" UNIQUE (name);


--
-- TOC entry 2389 (class 2606 OID 359806)
-- Dependencies: 1800 1800 1800
-- Name: one lock per object; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY generic_lock
    ADD CONSTRAINT "one lock per object" UNIQUE (type, lock);


--
-- TOC entry 2300 (class 2606 OID 359808)
-- Dependencies: 1774 1774
-- Name: open conceptual domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_open_conceptual_domain
    ADD CONSTRAINT "open conceptual domain primary key" PRIMARY KEY (id);


--
-- TOC entry 2449 (class 2606 OID 359810)
-- Dependencies: 1813 1813
-- Name: open data category conceptual domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_open_data_category_conceptual_domain
    ADD CONSTRAINT "open data category conceptual domain primary key" PRIMARY KEY (dc);


--
-- TOC entry 2302 (class 2606 OID 359812)
-- Dependencies: 1775 1775
-- Name: open data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_open_data_category
    ADD CONSTRAINT "open data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2304 (class 2606 OID 359814)
-- Dependencies: 1776 1776
-- Name: owner primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_owner
    ADD CONSTRAINT "owner primary key" PRIMARY KEY (id);


--
-- TOC entry 2210 (class 2606 OID 359816)
-- Dependencies: 1745 1745
-- Name: primary key change request vote; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_change_request_vote
    ADD CONSTRAINT "primary key change request vote" PRIMARY KEY (id);


--
-- TOC entry 2453 (class 2606 OID 359818)
-- Dependencies: 1814 1814 1814
-- Name: profile member primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_profile_members
    ADD CONSTRAINT "profile member primary key" PRIMARY KEY (profile, dc);


--
-- TOC entry 2309 (class 2606 OID 359820)
-- Dependencies: 1777 1777
-- Name: profile primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_profile
    ADD CONSTRAINT "profile primary key" PRIMARY KEY (id);


--
-- TOC entry 2311 (class 2606 OID 359822)
-- Dependencies: 1777 1777 1777
-- Name: profile sibling unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_profile
    ADD CONSTRAINT "profile sibling unique" UNIQUE (name, parent);


--
-- TOC entry 2316 (class 2606 OID 359824)
-- Dependencies: 1779 1779
-- Name: profile value domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_profile_value_domain
    ADD CONSTRAINT "profile value domain primary key" PRIMARY KEY (id);


--
-- TOC entry 2318 (class 2606 OID 359826)
-- Dependencies: 1780 1780
-- Name: registration authority primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_registration_authority
    ADD CONSTRAINT "registration authority primary key" PRIMARY KEY (id);


--
-- TOC entry 2320 (class 2606 OID 359828)
-- Dependencies: 1780 1780
-- Name: registration authority unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_registration_authority
    ADD CONSTRAINT "registration authority unique" UNIQUE (registration_authority);


--
-- TOC entry 2324 (class 2606 OID 359830)
-- Dependencies: 1782 1782
-- Name: registration group dc unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_registration_group
    ADD CONSTRAINT "registration group dc unique" UNIQUE (dc);


--
-- TOC entry 2326 (class 2606 OID 359832)
-- Dependencies: 1782 1782
-- Name: registration group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_registration_group
    ADD CONSTRAINT "registration group primary key" PRIMARY KEY (id);


--
-- TOC entry 2329 (class 2606 OID 359834)
-- Dependencies: 1783 1783
-- Name: rule primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_rule
    ADD CONSTRAINT "rule primary key" PRIMARY KEY (id);


--
-- TOC entry 2331 (class 2606 OID 359836)
-- Dependencies: 1785 1785
-- Name: rule type primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_rule_type
    ADD CONSTRAINT "rule type primary key" PRIMARY KEY (id);


--
-- TOC entry 2333 (class 2606 OID 359838)
-- Dependencies: 1785 1785
-- Name: rule type unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_rule_type
    ADD CONSTRAINT "rule type unique" UNIQUE (rule_type);


--
-- TOC entry 2336 (class 2606 OID 359840)
-- Dependencies: 1787 1787
-- Name: selected complex data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_selected_complex_data_category
    ADD CONSTRAINT "selected complex data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2338 (class 2606 OID 359842)
-- Dependencies: 1788 1788
-- Name: selected container data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_selected_container_data_category
    ADD CONSTRAINT "selected container data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2459 (class 2606 OID 359844)
-- Dependencies: 1815 1815 1815
-- Name: selected data category picklist primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_selected_data_category_picklist
    ADD CONSTRAINT "selected data category picklist primary key" PRIMARY KEY (cdc, sdc);


--
-- TOC entry 2341 (class 2606 OID 359846)
-- Dependencies: 1789 1789
-- Name: selected data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_selected_data_category
    ADD CONSTRAINT "selected data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2463 (class 2606 OID 359848)
-- Dependencies: 1816 1816 1816
-- Name: selected data category profile primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_selected_data_category_profiles
    ADD CONSTRAINT "selected data category profile primary key" PRIMARY KEY (dc, profile);


--
-- TOC entry 2344 (class 2606 OID 359850)
-- Dependencies: 1791 1791
-- Name: selected simple data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_selected_simple_data_category
    ADD CONSTRAINT "selected simple data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2349 (class 2606 OID 359852)
-- Dependencies: 1792 1792
-- Name: session primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_session
    ADD CONSTRAINT "session primary key" PRIMARY KEY (id);


--
-- TOC entry 2351 (class 2606 OID 359854)
-- Dependencies: 1794 1794
-- Name: simple data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_simple_data_category
    ADD CONSTRAINT "simple data category primary key" PRIMARY KEY (id);


--
-- TOC entry 2467 (class 2606 OID 359856)
-- Dependencies: 1817 1817 1817
-- Name: simple data category super primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_simple_data_category_super
    ADD CONSTRAINT "simple data category super primary key" PRIMARY KEY (dc, super);


--
-- TOC entry 2353 (class 2606 OID 359858)
-- Dependencies: 1794 1794
-- Name: simple data category unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_simple_data_category
    ADD CONSTRAINT "simple data category unique" UNIQUE (id);


--
-- TOC entry 2262 (class 2606 OID 359860)
-- Dependencies: 1762 1762
-- Name: status log primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_dc_status_log
    ADD CONSTRAINT "status log primary key" PRIMARY KEY (id);


--
-- TOC entry 2358 (class 2606 OID 359862)
-- Dependencies: 1796 1796
-- Name: submission group dc unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_submission_group
    ADD CONSTRAINT "submission group dc unique" UNIQUE (dc);


--
-- TOC entry 2360 (class 2606 OID 359864)
-- Dependencies: 1796 1796
-- Name: submission group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_submission_group
    ADD CONSTRAINT "submission group primary key" PRIMARY KEY (id);


--
-- TOC entry 2410 (class 2606 OID 359866)
-- Dependencies: 1804 1804
-- Name: text primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY generic_text
    ADD CONSTRAINT "text primary key" PRIMARY KEY (id);


--
-- TOC entry 2365 (class 2606 OID 359868)
-- Dependencies: 1797 1797
-- Name: thematic domain group primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_thematic_domain_group
    ADD CONSTRAINT "thematic domain group primary key" PRIMARY KEY (id);


--
-- TOC entry 2367 (class 2606 OID 359870)
-- Dependencies: 1797 1797
-- Name: thematic domain group unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_thematic_domain_group
    ADD CONSTRAINT "thematic domain group unique" UNIQUE (id);


--
-- TOC entry 2203 (class 2606 OID 359872)
-- Dependencies: 1742 1742
-- Name: unique adhoc group name; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_adhoc_group
    ADD CONSTRAINT "unique adhoc group name" UNIQUE (name);


--
-- TOC entry 2212 (class 2606 OID 359874)
-- Dependencies: 1745 1745 1745 1745
-- Name: unique change request vote; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_change_request_vote
    ADD CONSTRAINT "unique change request vote" UNIQUE (cr, judge, dc);


--
-- TOC entry 2313 (class 2606 OID 359876)
-- Dependencies: 1777 1777
-- Name: unique name; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_profile
    ADD CONSTRAINT "unique name" UNIQUE (name);


--
-- TOC entry 2376 (class 2606 OID 359878)
-- Dependencies: 1798 1798
-- Name: user primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_user
    ADD CONSTRAINT "user primary key" PRIMARY KEY (id);


--
-- TOC entry 2378 (class 2606 OID 359880)
-- Dependencies: 1798 1798
-- Name: user unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_user
    ADD CONSTRAINT "user unique" UNIQUE (id);


--
-- TOC entry 2380 (class 2606 OID 359882)
-- Dependencies: 1799 1799
-- Name: value domain primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY core_value_domain
    ADD CONSTRAINT "value domain primary key" PRIMARY KEY (id);


--
-- TOC entry 2471 (class 2606 OID 359884)
-- Dependencies: 1818 1818 1818
-- Name: value domain simple data category primary key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY link_value_domain_values
    ADD CONSTRAINT "value domain simple data category primary key" PRIMARY KEY (cd, dc);


--
-- TOC entry 2269 (class 1259 OID 359885)
-- Dependencies: 1764
-- Name: fki_data category foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_data category foreign key" ON core_decision_group USING btree (dc);


--
-- TOC entry 2236 (class 1259 OID 359886)
-- Dependencies: 1756
-- Name: fki_owner foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_owner foreign key" ON core_data_category USING btree (owner);


--
-- TOC entry 2237 (class 1259 OID 359887)
-- Dependencies: 1756
-- Name: fki_registration status foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_registration status foreign key" ON core_data_category USING btree (registration_status);


--
-- TOC entry 2454 (class 1259 OID 359888)
-- Dependencies: 1815
-- Name: fki_selected complex data category foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_selected complex data category foreign key" ON link_selected_data_category_picklist USING btree (cdc);


--
-- TOC entry 2455 (class 1259 OID 359889)
-- Dependencies: 1815
-- Name: fki_selected simple data category foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_selected simple data category foreign key" ON link_selected_data_category_picklist USING btree (sdc);


--
-- TOC entry 2390 (class 1259 OID 359890)
-- Dependencies: 1802
-- Name: fki_status foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_status foreign key" ON generic_name USING btree (status);


--
-- TOC entry 2401 (class 1259 OID 359891)
-- Dependencies: 1804
-- Name: fki_type foreign key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "fki_type foreign key" ON generic_text USING btree (text_type);


--
-- TOC entry 2201 (class 1259 OID 359892)
-- Dependencies: 1742
-- Name: idx_core_adhoc_group_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_adhoc_group_owner ON core_adhoc_group USING btree (owner);


--
-- TOC entry 2208 (class 1259 OID 359893)
-- Dependencies: 1743
-- Name: idx_core_change_request_tdg; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_change_request_tdg ON core_change_request USING btree (tdg);


--
-- TOC entry 2217 (class 1259 OID 359894)
-- Dependencies: 1748
-- Name: idx_core_closed_linguistic_section_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_closed_linguistic_section_cd ON core_closed_linguistic_section USING btree (cd);


--
-- TOC entry 2218 (class 1259 OID 359895)
-- Dependencies: 1748
-- Name: idx_core_closed_linguistic_section_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_closed_linguistic_section_dc ON core_closed_linguistic_section USING btree (dc);


--
-- TOC entry 2231 (class 1259 OID 359896)
-- Dependencies: 1754
-- Name: idx_core_constrained_linguistic_section_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_constrained_linguistic_section_dc ON core_constrained_linguistic_section USING btree (dc);


--
-- TOC entry 2238 (class 1259 OID 359897)
-- Dependencies: 1756
-- Name: idx_core_data_category_administration_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_administration_status ON core_data_category USING btree (administration_status);


--
-- TOC entry 2239 (class 1259 OID 359898)
-- Dependencies: 1756
-- Name: idx_core_data_category_identifier; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_identifier ON core_data_category USING btree (identifier);


--
-- TOC entry 2240 (class 1259 OID 359899)
-- Dependencies: 1756
-- Name: idx_core_data_category_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_name ON core_data_category USING btree (name);


--
-- TOC entry 2241 (class 1259 OID 359900)
-- Dependencies: 1756
-- Name: idx_core_data_category_next; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_next ON core_data_category USING btree (next);


--
-- TOC entry 2242 (class 1259 OID 359901)
-- Dependencies: 1756
-- Name: idx_core_data_category_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_owner ON core_data_category USING btree (owner);


--
-- TOC entry 2243 (class 1259 OID 359902)
-- Dependencies: 1756
-- Name: idx_core_data_category_pid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_pid ON core_data_category USING btree (pid);


--
-- TOC entry 2244 (class 1259 OID 359903)
-- Dependencies: 1756
-- Name: idx_core_data_category_previous; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_previous ON core_data_category USING btree (previous);


--
-- TOC entry 2245 (class 1259 OID 359904)
-- Dependencies: 1756
-- Name: idx_core_data_category_private; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_private ON core_data_category USING btree (private);


--
-- TOC entry 2246 (class 1259 OID 359905)
-- Dependencies: 1756
-- Name: idx_core_data_category_registration_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_registration_status ON core_data_category USING btree (registration_status);


--
-- TOC entry 2252 (class 1259 OID 359906)
-- Dependencies: 1758
-- Name: idx_core_data_category_selection_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_selection_name ON core_data_category_selection USING btree (name);


--
-- TOC entry 2253 (class 1259 OID 359907)
-- Dependencies: 1758
-- Name: idx_core_data_category_selection_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_selection_owner ON core_data_category_selection USING btree (owner);


--
-- TOC entry 2254 (class 1259 OID 359908)
-- Dependencies: 1758
-- Name: idx_core_data_category_selection_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_selection_parent ON core_data_category_selection USING btree (parent);


--
-- TOC entry 2255 (class 1259 OID 359909)
-- Dependencies: 1758
-- Name: idx_core_data_category_selection_private; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_selection_private ON core_data_category_selection USING btree (private);


--
-- TOC entry 2247 (class 1259 OID 359910)
-- Dependencies: 1756
-- Name: idx_core_data_category_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_category_type ON core_data_category USING btree (type);


--
-- TOC entry 2260 (class 1259 OID 359911)
-- Dependencies: 1760
-- Name: idx_core_data_type_super; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_data_type_super ON core_data_type USING btree (super);


--
-- TOC entry 2270 (class 1259 OID 359912)
-- Dependencies: 1764
-- Name: idx_core_decision_group_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_decision_group_dc ON core_decision_group USING btree (dc);


--
-- TOC entry 2271 (class 1259 OID 359913)
-- Dependencies: 1764
-- Name: idx_core_decision_group_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_decision_group_owner ON core_decision_group USING btree (owner);


--
-- TOC entry 2274 (class 1259 OID 359914)
-- Dependencies: 1766
-- Name: idx_core_language_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_language_name ON core_language USING btree (name);


--
-- TOC entry 2284 (class 1259 OID 359915)
-- Dependencies: 1768
-- Name: idx_core_language_section_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_language_section_dc ON core_language_section USING btree (dc);


--
-- TOC entry 2285 (class 1259 OID 359916)
-- Dependencies: 1768
-- Name: idx_core_language_section_language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_language_section_language ON core_language_section USING btree (language);


--
-- TOC entry 2275 (class 1259 OID 359917)
-- Dependencies: 1766
-- Name: idx_core_language_tag; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_language_tag ON core_language USING btree (tag);


--
-- TOC entry 2288 (class 1259 OID 359918)
-- Dependencies: 1770
-- Name: idx_core_linguistic_section; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_linguistic_section ON core_linguistic_section USING btree (language);


--
-- TOC entry 2291 (class 1259 OID 359919)
-- Dependencies: 1772
-- Name: idx_core_message_created; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_created ON core_message USING btree (created);


--
-- TOC entry 2292 (class 1259 OID 359920)
-- Dependencies: 1772
-- Name: idx_core_message_from; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_from ON core_message USING btree ("from");


--
-- TOC entry 2293 (class 1259 OID 359921)
-- Dependencies: 1772
-- Name: idx_core_message_read; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_read ON core_message USING btree (read);


--
-- TOC entry 2294 (class 1259 OID 359922)
-- Dependencies: 1772
-- Name: idx_core_message_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_status ON core_message USING btree (status);


--
-- TOC entry 2295 (class 1259 OID 359923)
-- Dependencies: 1772
-- Name: idx_core_message_to; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_to ON core_message USING btree ("to");


--
-- TOC entry 2296 (class 1259 OID 359924)
-- Dependencies: 1772
-- Name: idx_core_message_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_message_type ON core_message USING btree (type);


--
-- TOC entry 2305 (class 1259 OID 359925)
-- Dependencies: 1777
-- Name: idx_core_profile_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_profile_name ON core_profile USING btree (name);


--
-- TOC entry 2306 (class 1259 OID 359926)
-- Dependencies: 1777
-- Name: idx_core_profile_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_profile_parent ON core_profile USING btree (parent);


--
-- TOC entry 2307 (class 1259 OID 359927)
-- Dependencies: 1777
-- Name: idx_core_profile_tdg; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_profile_tdg ON core_profile USING btree (tdg);


--
-- TOC entry 2314 (class 1259 OID 359928)
-- Dependencies: 1779
-- Name: idx_core_profile_value_domain; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_profile_value_domain ON core_profile_value_domain USING btree (profile);


--
-- TOC entry 2321 (class 1259 OID 359929)
-- Dependencies: 1782
-- Name: idx_core_registration_group_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_registration_group_dc ON core_registration_group USING btree (dc);


--
-- TOC entry 2322 (class 1259 OID 359930)
-- Dependencies: 1782
-- Name: idx_core_registration_group_registration_authority; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_registration_group_registration_authority ON core_registration_group USING btree (registration_authority);


--
-- TOC entry 2327 (class 1259 OID 359931)
-- Dependencies: 1783
-- Name: idx_core_rule_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_rule_cd ON core_rule USING btree (cd);


--
-- TOC entry 2334 (class 1259 OID 359932)
-- Dependencies: 1787
-- Name: idx_core_selected_complex_data_category_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_selected_complex_data_category_dc ON core_selected_complex_data_category USING btree (dc);


--
-- TOC entry 2339 (class 1259 OID 359933)
-- Dependencies: 1789
-- Name: idx_core_selected_data_category_dcs; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_selected_data_category_dcs ON core_selected_data_category USING btree (dcs);


--
-- TOC entry 2342 (class 1259 OID 359934)
-- Dependencies: 1791
-- Name: idx_core_selected_simple_data_category_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_selected_simple_data_category_dc ON core_selected_simple_data_category USING btree (dc);


--
-- TOC entry 2345 (class 1259 OID 359935)
-- Dependencies: 1792
-- Name: idx_core_session_first_access; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_session_first_access ON core_session USING btree (first_access);


--
-- TOC entry 2346 (class 1259 OID 359936)
-- Dependencies: 1792
-- Name: idx_core_session_last_access; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_session_last_access ON core_session USING btree (last_access);


--
-- TOC entry 2347 (class 1259 OID 359937)
-- Dependencies: 1792
-- Name: idx_core_session_user; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_session_user ON core_session USING btree ("user");


--
-- TOC entry 2354 (class 1259 OID 359938)
-- Dependencies: 1796
-- Name: idx_core_submission_group_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_submission_group_dc ON core_submission_group USING btree (dc);


--
-- TOC entry 2355 (class 1259 OID 359939)
-- Dependencies: 1796
-- Name: idx_core_submission_group_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_submission_group_owner ON core_submission_group USING btree (owner);


--
-- TOC entry 2356 (class 1259 OID 359940)
-- Dependencies: 1796
-- Name: idx_core_submission_group_submission_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_submission_group_submission_date ON core_submission_group USING btree (submission_date);


--
-- TOC entry 2361 (class 1259 OID 359941)
-- Dependencies: 1797
-- Name: idx_core_thematic_domain_group_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_thematic_domain_group_name ON core_thematic_domain_group USING btree (name);


--
-- TOC entry 2368 (class 1259 OID 359942)
-- Dependencies: 1798
-- Name: idx_core_user_email; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_user_email ON core_user USING btree (email);


--
-- TOC entry 2369 (class 1259 OID 359943)
-- Dependencies: 1798
-- Name: idx_core_user_login; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_user_login ON core_user USING btree (login);


--
-- TOC entry 2370 (class 1259 OID 359944)
-- Dependencies: 1798
-- Name: idx_core_user_shib_principal; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_user_shib_principal ON core_user USING btree (shib_principal);


--
-- TOC entry 2371 (class 1259 OID 359945)
-- Dependencies: 1798
-- Name: idx_core_user_sync; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_user_sync ON core_user USING btree (sync);


--
-- TOC entry 2372 (class 1259 OID 359946)
-- Dependencies: 1798
-- Name: idx_core_user_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_core_user_type ON core_user USING btree (type);


--
-- TOC entry 2381 (class 1259 OID 359947)
-- Dependencies: 1800
-- Name: idx_generic_lock_first_access; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_lock_first_access ON generic_lock USING btree (first_access);


--
-- TOC entry 2382 (class 1259 OID 359948)
-- Dependencies: 1800
-- Name: idx_generic_lock_last_access; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_lock_last_access ON generic_lock USING btree (last_access);


--
-- TOC entry 2383 (class 1259 OID 359949)
-- Dependencies: 1800
-- Name: idx_generic_lock_lock; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_lock_lock ON generic_lock USING btree (lock);


--
-- TOC entry 2384 (class 1259 OID 359950)
-- Dependencies: 1800
-- Name: idx_generic_lock_session; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_lock_session ON generic_lock USING btree (session);


--
-- TOC entry 2385 (class 1259 OID 359951)
-- Dependencies: 1800
-- Name: idx_generic_lock_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_lock_type ON generic_lock USING btree (type);


--
-- TOC entry 2391 (class 1259 OID 359952)
-- Dependencies: 1802
-- Name: idx_generic_name_language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_language ON generic_name USING btree (language);


--
-- TOC entry 2392 (class 1259 OID 359953)
-- Dependencies: 1802
-- Name: idx_generic_name_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_name ON generic_name USING btree (name);


--
-- TOC entry 2393 (class 1259 OID 359954)
-- Dependencies: 1802
-- Name: idx_generic_name_name_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_name_type ON generic_name USING btree (name_type);


--
-- TOC entry 2394 (class 1259 OID 359955)
-- Dependencies: 1802
-- Name: idx_generic_name_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_owner ON generic_name USING btree (owner);


--
-- TOC entry 2395 (class 1259 OID 359956)
-- Dependencies: 1802
-- Name: idx_generic_name_owner_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_owner_type ON generic_name USING btree (owner_type);


--
-- TOC entry 2396 (class 1259 OID 359957)
-- Dependencies: 1802
-- Name: idx_generic_name_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_name_status ON generic_name USING btree (status);


--
-- TOC entry 2402 (class 1259 OID 359958)
-- Dependencies: 1804
-- Name: idx_generic_text_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_date ON generic_text USING btree (date);


--
-- TOC entry 2403 (class 1259 OID 359959)
-- Dependencies: 1804
-- Name: idx_generic_text_language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_language ON generic_text USING btree (language);


--
-- TOC entry 2404 (class 1259 OID 359960)
-- Dependencies: 1804
-- Name: idx_generic_text_owner; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_owner ON generic_text USING btree (owner);


--
-- TOC entry 2405 (class 1259 OID 359961)
-- Dependencies: 1804
-- Name: idx_generic_text_owner_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_owner_type ON generic_text USING btree (owner_type);


--
-- TOC entry 2406 (class 1259 OID 359962)
-- Dependencies: 1804
-- Name: idx_generic_text_text_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_text_type ON generic_text USING btree (text_type);


--
-- TOC entry 2407 (class 1259 OID 359963)
-- Dependencies: 1804
-- Name: idx_generic_text_timestamp; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_timestamp ON generic_text USING btree ("timestamp");


--
-- TOC entry 2408 (class 1259 OID 359964)
-- Dependencies: 1804
-- Name: idx_generic_text_user; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_generic_text_user ON generic_text USING btree ("user");


--
-- TOC entry 2442 (class 1259 OID 359965)
-- Dependencies: 1812
-- Name: idx_ling_group_members_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_ling_group_members_status ON link_group_members USING btree (status);


--
-- TOC entry 2415 (class 1259 OID 359966)
-- Dependencies: 1806
-- Name: idx_link_closed_data_category_conceptual_domain_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_closed_data_category_conceptual_domain_cd ON link_closed_data_category_conceptual_domains USING btree (cd);


--
-- TOC entry 2416 (class 1259 OID 359967)
-- Dependencies: 1806
-- Name: idx_link_closed_data_category_conceptual_domain_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_closed_data_category_conceptual_domain_dc ON link_closed_data_category_conceptual_domains USING btree (dc);


--
-- TOC entry 2419 (class 1259 OID 359968)
-- Dependencies: 1807
-- Name: idx_link_constrained_data_category_conceptual_domain_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_constrained_data_category_conceptual_domain_cd ON link_constrained_data_category_conceptual_domains USING btree (cd);


--
-- TOC entry 2420 (class 1259 OID 359969)
-- Dependencies: 1807
-- Name: idx_link_constrained_data_category_conceptual_domain_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_constrained_data_category_conceptual_domain_dc ON link_constrained_data_category_conceptual_domains USING btree (dc);


--
-- TOC entry 2423 (class 1259 OID 359970)
-- Dependencies: 1808
-- Name: idx_link_constrained_linguistic_section_conceptual_domain_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_constrained_linguistic_section_conceptual_domain_cd ON link_constrained_linguistic_section_conceptual_domains USING btree (cd);


--
-- TOC entry 2424 (class 1259 OID 359971)
-- Dependencies: 1808
-- Name: idx_link_constrained_linguistic_section_conceptual_domain_ls; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_constrained_linguistic_section_conceptual_domain_ls ON link_constrained_linguistic_section_conceptual_domains USING btree (ls);


--
-- TOC entry 2427 (class 1259 OID 359972)
-- Dependencies: 1809
-- Name: idx_link_data_category_selection_users_dcs; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_data_category_selection_users_dcs ON link_data_category_selection_users USING btree (dcs);


--
-- TOC entry 2428 (class 1259 OID 359973)
-- Dependencies: 1809
-- Name: idx_link_data_category_selection_users_user; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_data_category_selection_users_user ON link_data_category_selection_users USING btree ("user");


--
-- TOC entry 2429 (class 1259 OID 359974)
-- Dependencies: 1810
-- Name: idx_link_dc_access_account; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dc_access_account ON link_dc_access USING btree (account);


--
-- TOC entry 2430 (class 1259 OID 359975)
-- Dependencies: 1810
-- Name: idx_link_dc_access_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dc_access_dc ON link_dc_access USING btree (dc);


--
-- TOC entry 2431 (class 1259 OID 359976)
-- Dependencies: 1810
-- Name: idx_link_dc_access_rights; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dc_access_rights ON link_dc_access USING btree (rights);


--
-- TOC entry 2434 (class 1259 OID 359977)
-- Dependencies: 1811
-- Name: idx_link_dcs_access_account; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dcs_access_account ON link_dcs_access USING btree (account);


--
-- TOC entry 2435 (class 1259 OID 359978)
-- Dependencies: 1811
-- Name: idx_link_dcs_access_dcs; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dcs_access_dcs ON link_dcs_access USING btree (dcs);


--
-- TOC entry 2436 (class 1259 OID 360951)
-- Dependencies: 1811
-- Name: idx_link_dcs_access_propagate; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dcs_access_propagate ON link_dcs_access USING btree (propagate);


--
-- TOC entry 2437 (class 1259 OID 359980)
-- Dependencies: 1811
-- Name: idx_link_dcs_access_rights; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_dcs_access_rights ON link_dcs_access USING btree (rights);


--
-- TOC entry 2443 (class 1259 OID 359981)
-- Dependencies: 1812
-- Name: idx_link_group_members_group; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_group_members_group ON link_group_members USING btree ("group");


--
-- TOC entry 2444 (class 1259 OID 359982)
-- Dependencies: 1812
-- Name: idx_link_group_members_member; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_group_members_member ON link_group_members USING btree (member);


--
-- TOC entry 2445 (class 1259 OID 359983)
-- Dependencies: 1812
-- Name: idx_link_group_members_role; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_group_members_role ON link_group_members USING btree (role);


--
-- TOC entry 2446 (class 1259 OID 359984)
-- Dependencies: 1813
-- Name: idx_link_open_data_category_conceptual_domain_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_open_data_category_conceptual_domain_cd ON link_open_data_category_conceptual_domain USING btree (cd);


--
-- TOC entry 2447 (class 1259 OID 359985)
-- Dependencies: 1813
-- Name: idx_link_open_data_category_conceptual_domain_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_open_data_category_conceptual_domain_dc ON link_open_data_category_conceptual_domain USING btree (dc);


--
-- TOC entry 2450 (class 1259 OID 359986)
-- Dependencies: 1814
-- Name: idx_link_profile_members_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_profile_members_dc ON link_profile_members USING btree (dc);


--
-- TOC entry 2451 (class 1259 OID 359987)
-- Dependencies: 1814
-- Name: idx_link_profile_members_profile; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_profile_members_profile ON link_profile_members USING btree (profile);


--
-- TOC entry 2456 (class 1259 OID 359988)
-- Dependencies: 1815
-- Name: idx_link_selected_data_category_picklist_cdc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_selected_data_category_picklist_cdc ON link_selected_data_category_picklist USING btree (cdc);


--
-- TOC entry 2457 (class 1259 OID 359989)
-- Dependencies: 1815
-- Name: idx_link_selected_data_category_picklist_sdc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_selected_data_category_picklist_sdc ON link_selected_data_category_picklist USING btree (sdc);


--
-- TOC entry 2460 (class 1259 OID 359990)
-- Dependencies: 1816
-- Name: idx_link_selected_data_category_profiles_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_selected_data_category_profiles_dc ON link_selected_data_category_profiles USING btree (dc);


--
-- TOC entry 2461 (class 1259 OID 359991)
-- Dependencies: 1816
-- Name: idx_link_selected_data_category_profiles_profile; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_selected_data_category_profiles_profile ON link_selected_data_category_profiles USING btree (profile);


--
-- TOC entry 2464 (class 1259 OID 359992)
-- Dependencies: 1817
-- Name: idx_link_simple_data_category_super_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_simple_data_category_super_dc ON link_simple_data_category_super USING btree (dc);


--
-- TOC entry 2465 (class 1259 OID 359993)
-- Dependencies: 1817
-- Name: idx_link_simple_data_category_super_super; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_simple_data_category_super_super ON link_simple_data_category_super USING btree (super);


--
-- TOC entry 2468 (class 1259 OID 359994)
-- Dependencies: 1818
-- Name: idx_link_value_domain_values_cd; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_value_domain_values_cd ON link_value_domain_values USING btree (cd);


--
-- TOC entry 2469 (class 1259 OID 359995)
-- Dependencies: 1818
-- Name: idx_link_value_domain_values_dc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_link_value_domain_values_dc ON link_value_domain_values USING btree (dc);


--
-- TOC entry 2248 (class 1259 OID 359996)
-- Dependencies: 1756
-- Name: tsi_identifier search; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_identifier search" ON core_data_category USING gist (search);


--
-- TOC entry 2249 (class 1259 OID 359997)
-- Dependencies: 1756
-- Name: tsi_identifier search language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_identifier search language" ON core_data_category USING gist (search_language);


--
-- TOC entry 2399 (class 1259 OID 359998)
-- Dependencies: 1802
-- Name: tsi_name search; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_name search" ON generic_name USING gist (search);


--
-- TOC entry 2400 (class 1259 OID 359999)
-- Dependencies: 1802
-- Name: tsi_name_search language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_name_search language" ON generic_name USING gist (search_language);


--
-- TOC entry 2411 (class 1259 OID 360000)
-- Dependencies: 1804
-- Name: tsi_text search; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_text search" ON generic_text USING gist (search);


--
-- TOC entry 2412 (class 1259 OID 360001)
-- Dependencies: 1804
-- Name: tsi_text search language; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX "tsi_text search language" ON generic_text USING gist (search_language);


--
-- TOC entry 2570 (class 2620 OID 360002)
-- Dependencies: 23 1756
-- Name: core_data_category_delete_generic_name; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_data_category_delete_generic_name
    AFTER DELETE ON core_data_category
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_name();


--
-- TOC entry 2571 (class 2620 OID 360003)
-- Dependencies: 1756 24
-- Name: core_data_category_delete_generic_text; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_data_category_delete_generic_text
    AFTER DELETE ON core_data_category
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_text();


--
-- TOC entry 2572 (class 2620 OID 360004)
-- Dependencies: 36 1756
-- Name: core_data_category_update_search; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_data_category_update_search
    BEFORE INSERT OR UPDATE ON core_data_category
    FOR EACH ROW
    EXECUTE PROCEDURE update_search_identifier();


--
-- TOC entry 2573 (class 2620 OID 360005)
-- Dependencies: 1768 23
-- Name: core_language_section_delete_generic_name; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_language_section_delete_generic_name
    AFTER DELETE ON core_language_section
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_name();


--
-- TOC entry 2574 (class 2620 OID 360006)
-- Dependencies: 1768 24
-- Name: core_language_section_delete_generic_text; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_language_section_delete_generic_text
    AFTER DELETE ON core_language_section
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_text();


--
-- TOC entry 2575 (class 2620 OID 360007)
-- Dependencies: 24 1770
-- Name: core_linguistic_section_delete_generic_text; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER core_linguistic_section_delete_generic_text
    AFTER DELETE ON core_linguistic_section
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_text();


--
-- TOC entry 2576 (class 2620 OID 360008)
-- Dependencies: 37 1802
-- Name: generic_name_update_search; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER generic_name_update_search
    BEFORE INSERT OR UPDATE ON generic_name
    FOR EACH ROW
    EXECUTE PROCEDURE update_search_name();


--
-- TOC entry 2577 (class 2620 OID 360009)
-- Dependencies: 1804 24
-- Name: generic_text_delete_generic_text; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER generic_text_delete_generic_text
    AFTER DELETE ON generic_text
    FOR EACH ROW
    EXECUTE PROCEDURE delete_generic_text();


--
-- TOC entry 2578 (class 2620 OID 360010)
-- Dependencies: 38 1804
-- Name: generic_text_update_search; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER generic_text_update_search
    BEFORE INSERT OR UPDATE ON generic_text
    FOR EACH ROW
    EXECUTE PROCEDURE update_search_text();


--
-- TOC entry 2579 (class 2620 OID 360011)
-- Dependencies: 32 1817
-- Name: prevent_dc_super_cycles; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER prevent_dc_super_cycles
    BEFORE INSERT OR UPDATE ON link_simple_data_category_super
    FOR EACH ROW
    EXECUTE PROCEDURE prevent_super_cycle();


--
-- TOC entry 2537 (class 2606 OID 360012)
-- Dependencies: 1740 2197 1798
-- Name: account foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_user
    ADD CONSTRAINT "account foreign key" FOREIGN KEY (id) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2506 (class 2606 OID 360017)
-- Dependencies: 2197 1765 1740
-- Name: account foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_group
    ADD CONSTRAINT "account foreign key" FOREIGN KEY (id) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2514 (class 2606 OID 360022)
-- Dependencies: 1740 2197 1776
-- Name: account foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_owner
    ADD CONSTRAINT "account foreign key" FOREIGN KEY (id) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2552 (class 2606 OID 360027)
-- Dependencies: 1740 1810 2197
-- Name: account foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_dc_access
    ADD CONSTRAINT "account foreign key" FOREIGN KEY (account) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2554 (class 2606 OID 360032)
-- Dependencies: 1740 1811 2197
-- Name: account foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_dcs_access
    ADD CONSTRAINT "account foreign key" FOREIGN KEY (account) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2558 (class 2606 OID 360037)
-- Dependencies: 1774 1813 2299
-- Name: cd foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_open_data_category_conceptual_domain
    ADD CONSTRAINT "cd foreign key" FOREIGN KEY (cd) REFERENCES core_open_conceptual_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2544 (class 2606 OID 360042)
-- Dependencies: 2213 1747 1806
-- Name: closed data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_closed_data_category_conceptual_domains
    ADD CONSTRAINT "closed data category foreign key" FOREIGN KEY (dc) REFERENCES core_closed_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2483 (class 2606 OID 360047)
-- Dependencies: 1748 1747 2213
-- Name: closed data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_closed_linguistic_section
    ADD CONSTRAINT "closed data category foreign key" FOREIGN KEY (dc) REFERENCES core_closed_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2482 (class 2606 OID 360052)
-- Dependencies: 2219 1747 1749
-- Name: closed data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_closed_data_category
    ADD CONSTRAINT "closed data category foreign key" FOREIGN KEY (id) REFERENCES core_complex_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2484 (class 2606 OID 360057)
-- Dependencies: 2289 1748 1770
-- Name: closed linguistic section foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_closed_linguistic_section
    ADD CONSTRAINT "closed linguistic section foreign key" FOREIGN KEY (id) REFERENCES core_linguistic_section(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2486 (class 2606 OID 360062)
-- Dependencies: 2234 1756 1749
-- Name: complex data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_complex_data_category
    ADD CONSTRAINT "complex data category foreign key" FOREIGN KEY (id) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2523 (class 2606 OID 360067)
-- Dependencies: 1787 1749 2219
-- Name: complex data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_complex_data_category
    ADD CONSTRAINT "complex data category foreign key" FOREIGN KEY (dc) REFERENCES core_complex_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2522 (class 2606 OID 360072)
-- Dependencies: 1752 2225 1783
-- Name: conceptual domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_rule
    ADD CONSTRAINT "conceptual domain foreign key" FOREIGN KEY (cd) REFERENCES core_conceptual_domain_rule(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2548 (class 2606 OID 360077)
-- Dependencies: 1747 2213 1808
-- Name: conceptual domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_constrained_linguistic_section_conceptual_domains
    ADD CONSTRAINT "conceptual domain foreign key" FOREIGN KEY (cd) REFERENCES core_closed_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2546 (class 2606 OID 360082)
-- Dependencies: 1807 1752 2225
-- Name: constrained conceptual domain; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_constrained_data_category_conceptual_domains
    ADD CONSTRAINT "constrained conceptual domain" FOREIGN KEY (cd) REFERENCES core_conceptual_domain_rule(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2488 (class 2606 OID 360087)
-- Dependencies: 2223 1752 1750
-- Name: constrained conceptual domain; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_conceptual_domain_rule
    ADD CONSTRAINT "constrained conceptual domain" FOREIGN KEY (id) REFERENCES core_conceptual_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2490 (class 2606 OID 360092)
-- Dependencies: 1775 1753 2301
-- Name: constrained data category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_constrained_data_category
    ADD CONSTRAINT "constrained data category" FOREIGN KEY (id) REFERENCES core_open_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2547 (class 2606 OID 360097)
-- Dependencies: 2227 1753 1807
-- Name: constrained data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_constrained_data_category_conceptual_domains
    ADD CONSTRAINT "constrained data category foreign key" FOREIGN KEY (dc) REFERENCES core_constrained_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2491 (class 2606 OID 360102)
-- Dependencies: 1754 1770 2289
-- Name: constrained linguistic section foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_constrained_linguistic_section
    ADD CONSTRAINT "constrained linguistic section foreign key" FOREIGN KEY (id) REFERENCES core_linguistic_section(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2549 (class 2606 OID 360107)
-- Dependencies: 1808 1748 2215
-- Name: constrained linguistic section foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_constrained_linguistic_section_conceptual_domains
    ADD CONSTRAINT "constrained linguistic section foreign key" FOREIGN KEY (ls) REFERENCES core_closed_linguistic_section(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2525 (class 2606 OID 360112)
-- Dependencies: 1788 1755 2232
-- Name: container data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_container_data_category
    ADD CONSTRAINT "container data category foreign key" FOREIGN KEY (dc) REFERENCES core_container_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2519 (class 2606 OID 360117)
-- Dependencies: 1782 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_registration_group
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2532 (class 2606 OID 360122)
-- Dependencies: 1796 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_submission_group
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2560 (class 2606 OID 360127)
-- Dependencies: 1814 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_profile_members
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2507 (class 2606 OID 360132)
-- Dependencies: 1768 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_language_section
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2503 (class 2606 OID 360137)
-- Dependencies: 1764 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_decision_group
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2493 (class 2606 OID 360142)
-- Dependencies: 1755 1756 2234
-- Name: data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_container_data_category
    ADD CONSTRAINT "data category foreign key" FOREIGN KEY (id) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2550 (class 2606 OID 360147)
-- Dependencies: 1809 1758 2250
-- Name: data category selection foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_data_category_selection_users
    ADD CONSTRAINT "data category selection foreign key" FOREIGN KEY (dcs) REFERENCES core_data_category_selection(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2527 (class 2606 OID 360152)
-- Dependencies: 2250 1789 1758
-- Name: data category selection foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_data_category
    ADD CONSTRAINT "data category selection foreign key" FOREIGN KEY (dcs) REFERENCES core_data_category_selection(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2487 (class 2606 OID 360157)
-- Dependencies: 1750 2256 1760
-- Name: data type foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_conceptual_domain
    ADD CONSTRAINT "data type foreign key" FOREIGN KEY (data_type) REFERENCES core_data_type(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2559 (class 2606 OID 360162)
-- Dependencies: 2301 1775 1813
-- Name: dc foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_open_data_category_conceptual_domain
    ADD CONSTRAINT "dc foreign key" FOREIGN KEY (dc) REFERENCES core_open_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2553 (class 2606 OID 360167)
-- Dependencies: 1756 2234 1810
-- Name: dc foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_dc_access
    ADD CONSTRAINT "dc foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2500 (class 2606 OID 360172)
-- Dependencies: 1762 2234 1756
-- Name: dc foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_dc_status_log
    ADD CONSTRAINT "dc foreign key" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2555 (class 2606 OID 360177)
-- Dependencies: 1811 2250 1758
-- Name: dcs foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_dcs_access
    ADD CONSTRAINT "dcs foreign key" FOREIGN KEY (dcs) REFERENCES core_data_category_selection(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2474 (class 2606 OID 360182)
-- Dependencies: 1758 2250 1743
-- Name: dcs foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "dcs foreign key" FOREIGN KEY (dcs) REFERENCES core_data_category_selection(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2475 (class 2606 OID 360187)
-- Dependencies: 1743 1765 2272
-- Name: decision group dcrb foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "decision group dcrb foreign key" FOREIGN KEY (decision_group_dcrb) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2476 (class 2606 OID 360192)
-- Dependencies: 1765 1743 2272
-- Name: decision group tdg foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "decision group tdg foreign key" FOREIGN KEY (decision_group_tdg) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2479 (class 2606 OID 360197)
-- Dependencies: 1745 1743 2206
-- Name: foreign key cr; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request_vote
    ADD CONSTRAINT "foreign key cr" FOREIGN KEY (cr) REFERENCES core_change_request(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2480 (class 2606 OID 360202)
-- Dependencies: 1756 2234 1745
-- Name: foreign key dc; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request_vote
    ADD CONSTRAINT "foreign key dc" FOREIGN KEY (dc) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2481 (class 2606 OID 360207)
-- Dependencies: 2375 1745 1798
-- Name: foreign key judge; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request_vote
    ADD CONSTRAINT "foreign key judge" FOREIGN KEY (judge) REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2510 (class 2606 OID 360212)
-- Dependencies: 2375 1772 1798
-- Name: from foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_message
    ADD CONSTRAINT "from foreign key" FOREIGN KEY ("from") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2504 (class 2606 OID 360217)
-- Dependencies: 1765 2272 1764
-- Name: group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_decision_group
    ADD CONSTRAINT "group foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2520 (class 2606 OID 360222)
-- Dependencies: 2272 1782 1765
-- Name: group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_registration_group
    ADD CONSTRAINT "group foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2533 (class 2606 OID 360227)
-- Dependencies: 2272 1796 1765
-- Name: group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_submission_group
    ADD CONSTRAINT "group foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2535 (class 2606 OID 360232)
-- Dependencies: 1797 2272 1765
-- Name: group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_thematic_domain_group
    ADD CONSTRAINT "group foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2556 (class 2606 OID 360237)
-- Dependencies: 1765 2272 1812
-- Name: group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_group_members
    ADD CONSTRAINT "group foreign key" FOREIGN KEY ("group") REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2472 (class 2606 OID 360242)
-- Dependencies: 1742 2272 1765
-- Name: id foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_adhoc_group
    ADD CONSTRAINT "id foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2502 (class 2606 OID 360247)
-- Dependencies: 2272 1765 1763
-- Name: id foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_dcr_board
    ADD CONSTRAINT "id foreign key" FOREIGN KEY (id) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2542 (class 2606 OID 360252)
-- Dependencies: 1766 2278 1804
-- Name: language foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY generic_text
    ADD CONSTRAINT "language foreign key" FOREIGN KEY (language) REFERENCES core_language(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2508 (class 2606 OID 360257)
-- Dependencies: 1766 2278 1768
-- Name: language foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_language_section
    ADD CONSTRAINT "language foreign key" FOREIGN KEY (language) REFERENCES core_language(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2509 (class 2606 OID 360262)
-- Dependencies: 1770 2278 1766
-- Name: language foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_linguistic_section
    ADD CONSTRAINT "language foreign key" FOREIGN KEY (language) REFERENCES core_language(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2541 (class 2606 OID 360267)
-- Dependencies: 1802 1766 2278
-- Name: language foreignh key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY generic_name
    ADD CONSTRAINT "language foreignh key" FOREIGN KEY (language) REFERENCES core_language(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2557 (class 2606 OID 360272)
-- Dependencies: 1812 2375 1798
-- Name: member foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_group_members
    ADD CONSTRAINT "member foreign key" FOREIGN KEY (member) REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2494 (class 2606 OID 360277)
-- Dependencies: 1756 2234 1756
-- Name: next version foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_category
    ADD CONSTRAINT "next version foreign key" FOREIGN KEY (next) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2512 (class 2606 OID 360282)
-- Dependencies: 1774 1750 2223
-- Name: open conceptual domain; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_open_conceptual_domain
    ADD CONSTRAINT "open conceptual domain" FOREIGN KEY (id) REFERENCES core_conceptual_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2492 (class 2606 OID 360287)
-- Dependencies: 1775 1754 2301
-- Name: open data category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_constrained_linguistic_section
    ADD CONSTRAINT "open data category" FOREIGN KEY (dc) REFERENCES core_open_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2513 (class 2606 OID 360292)
-- Dependencies: 2219 1775 1749
-- Name: open data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_open_data_category
    ADD CONSTRAINT "open data category foreign key" FOREIGN KEY (id) REFERENCES core_complex_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2497 (class 2606 OID 360297)
-- Dependencies: 1776 2303 1758
-- Name: owner; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_category_selection
    ADD CONSTRAINT owner FOREIGN KEY (owner) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2495 (class 2606 OID 360302)
-- Dependencies: 1776 1756 2303
-- Name: owner foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_category
    ADD CONSTRAINT "owner foreign key" FOREIGN KEY (owner) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2534 (class 2606 OID 360307)
-- Dependencies: 1796 2303 1776
-- Name: owner foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_submission_group
    ADD CONSTRAINT "owner foreign key" FOREIGN KEY (owner) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2536 (class 2606 OID 360312)
-- Dependencies: 1776 2303 1797
-- Name: owner foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_thematic_domain_group
    ADD CONSTRAINT "owner foreign key" FOREIGN KEY (id) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2538 (class 2606 OID 360317)
-- Dependencies: 2303 1798 1776
-- Name: owner foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_user
    ADD CONSTRAINT "owner foreign key" FOREIGN KEY (id) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2473 (class 2606 OID 360322)
-- Dependencies: 1742 1776 2303
-- Name: owner foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_adhoc_group
    ADD CONSTRAINT "owner foreign key" FOREIGN KEY (owner) REFERENCES core_owner(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2505 (class 2606 OID 360327)
-- Dependencies: 1797 1764 2364
-- Name: owner foriegn key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_decision_group
    ADD CONSTRAINT "owner foriegn key" FOREIGN KEY (owner) REFERENCES core_thematic_domain_group(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2515 (class 2606 OID 360332)
-- Dependencies: 2308 1777 1777
-- Name: parent foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_profile
    ADD CONSTRAINT "parent foreign key" FOREIGN KEY (parent) REFERENCES core_profile(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2498 (class 2606 OID 360337)
-- Dependencies: 1758 1758 2250
-- Name: parent foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_category_selection
    ADD CONSTRAINT "parent foreign key" FOREIGN KEY (parent) REFERENCES core_data_category_selection(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2496 (class 2606 OID 360342)
-- Dependencies: 2234 1756 1756
-- Name: previous version foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_category
    ADD CONSTRAINT "previous version foreign key" FOREIGN KEY (previous) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2561 (class 2606 OID 360347)
-- Dependencies: 2308 1777 1814
-- Name: profile foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_profile_members
    ADD CONSTRAINT "profile foreign key" FOREIGN KEY (profile) REFERENCES core_profile(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2517 (class 2606 OID 360352)
-- Dependencies: 2308 1777 1779
-- Name: profile foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_profile_value_domain
    ADD CONSTRAINT "profile foreign key" FOREIGN KEY (profile) REFERENCES core_profile(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2564 (class 2606 OID 360357)
-- Dependencies: 2308 1777 1816
-- Name: profile foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_selected_data_category_profiles
    ADD CONSTRAINT "profile foreign key" FOREIGN KEY (profile) REFERENCES core_profile(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2545 (class 2606 OID 360362)
-- Dependencies: 1779 2315 1806
-- Name: profile value domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_closed_data_category_conceptual_domains
    ADD CONSTRAINT "profile value domain foreign key" FOREIGN KEY (cd) REFERENCES core_profile_value_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2518 (class 2606 OID 360367)
-- Dependencies: 1799 2379 1779
-- Name: profile value domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_profile_value_domain
    ADD CONSTRAINT "profile value domain foreign key" FOREIGN KEY (id) REFERENCES core_value_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2521 (class 2606 OID 360372)
-- Dependencies: 2317 1782 1780
-- Name: registration authority foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_registration_group
    ADD CONSTRAINT "registration authority foreign key" FOREIGN KEY (registration_authority) REFERENCES core_registration_authority(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2489 (class 2606 OID 360377)
-- Dependencies: 1752 1785 2330
-- Name: rule type foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_conceptual_domain_rule
    ADD CONSTRAINT "rule type foreign key" FOREIGN KEY (rule_type) REFERENCES core_rule_type(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2562 (class 2606 OID 360382)
-- Dependencies: 1787 2335 1815
-- Name: selected complex data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_selected_data_category_picklist
    ADD CONSTRAINT "selected complex data category foreign key" FOREIGN KEY (cdc) REFERENCES core_selected_complex_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2524 (class 2606 OID 360387)
-- Dependencies: 1789 1787 2340
-- Name: selected complex data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_complex_data_category
    ADD CONSTRAINT "selected complex data category foreign key" FOREIGN KEY (id) REFERENCES core_selected_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2526 (class 2606 OID 360392)
-- Dependencies: 1789 1788 2340
-- Name: selected container data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_container_data_category
    ADD CONSTRAINT "selected container data category foreign key" FOREIGN KEY (id) REFERENCES core_selected_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2565 (class 2606 OID 360397)
-- Dependencies: 1789 1816 2340
-- Name: selected data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_selected_data_category_profiles
    ADD CONSTRAINT "selected data category foreign key" FOREIGN KEY (dc) REFERENCES core_selected_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2563 (class 2606 OID 360402)
-- Dependencies: 2343 1815 1791
-- Name: selected simple data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_selected_data_category_picklist
    ADD CONSTRAINT "selected simple data category foreign key" FOREIGN KEY (sdc) REFERENCES core_selected_simple_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2528 (class 2606 OID 360407)
-- Dependencies: 2340 1791 1789
-- Name: selected simple data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_simple_data_category
    ADD CONSTRAINT "selected simple data category foreign key" FOREIGN KEY (id) REFERENCES core_selected_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2540 (class 2606 OID 360412)
-- Dependencies: 1800 1792 2348
-- Name: session foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY generic_lock
    ADD CONSTRAINT "session foreign key" FOREIGN KEY (session) REFERENCES core_session(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2566 (class 2606 OID 360417)
-- Dependencies: 2350 1794 1817
-- Name: simple data category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_simple_data_category_super
    ADD CONSTRAINT "simple data category" FOREIGN KEY (dc) REFERENCES core_simple_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2529 (class 2606 OID 360422)
-- Dependencies: 1794 1791 2350
-- Name: simple data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_selected_simple_data_category
    ADD CONSTRAINT "simple data category foreign key" FOREIGN KEY (dc) REFERENCES core_simple_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2568 (class 2606 OID 360427)
-- Dependencies: 1818 2350 1794
-- Name: simple data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_value_domain_values
    ADD CONSTRAINT "simple data category foreign key" FOREIGN KEY (dc) REFERENCES core_simple_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2531 (class 2606 OID 360432)
-- Dependencies: 2234 1756 1794
-- Name: simple data category foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_simple_data_category
    ADD CONSTRAINT "simple data category foreign key" FOREIGN KEY (id) REFERENCES core_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2477 (class 2606 OID 360437)
-- Dependencies: 2272 1743 1765
-- Name: submission group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "submission group foreign key" FOREIGN KEY (submission_group) REFERENCES core_group(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2499 (class 2606 OID 360442)
-- Dependencies: 1760 1760 2256
-- Name: super foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_data_type
    ADD CONSTRAINT "super foreign key" FOREIGN KEY (super) REFERENCES core_data_type(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2567 (class 2606 OID 360447)
-- Dependencies: 1817 2350 1794
-- Name: super simple data category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_simple_data_category_super
    ADD CONSTRAINT "super simple data category" FOREIGN KEY (super) REFERENCES core_simple_data_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2478 (class 2606 OID 360452)
-- Dependencies: 2197 1743 1740
-- Name: tdg foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_change_request
    ADD CONSTRAINT "tdg foreign key" FOREIGN KEY (tdg) REFERENCES core_account(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2516 (class 2606 OID 360457)
-- Dependencies: 1797 1777 2364
-- Name: thematic domain group foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_profile
    ADD CONSTRAINT "thematic domain group foreign key" FOREIGN KEY (tdg) REFERENCES core_thematic_domain_group(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2511 (class 2606 OID 360462)
-- Dependencies: 1772 1798 2375
-- Name: to foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_message
    ADD CONSTRAINT "to foreign key" FOREIGN KEY ("to") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2543 (class 2606 OID 360467)
-- Dependencies: 2375 1798 1804
-- Name: user foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY generic_text
    ADD CONSTRAINT "user foreign key" FOREIGN KEY ("user") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2551 (class 2606 OID 360472)
-- Dependencies: 1809 1798 2375
-- Name: user foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_data_category_selection_users
    ADD CONSTRAINT "user foreign key" FOREIGN KEY ("user") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2530 (class 2606 OID 360477)
-- Dependencies: 1792 1798 2375
-- Name: user foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_session
    ADD CONSTRAINT "user foreign key" FOREIGN KEY ("user") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2501 (class 2606 OID 360482)
-- Dependencies: 1798 2375 1762
-- Name: user foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_dc_status_log
    ADD CONSTRAINT "user foreign key" FOREIGN KEY ("user") REFERENCES core_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 2569 (class 2606 OID 360487)
-- Dependencies: 1799 1818 2379
-- Name: value domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY link_value_domain_values
    ADD CONSTRAINT "value domain foreign key" FOREIGN KEY (cd) REFERENCES core_value_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2539 (class 2606 OID 360492)
-- Dependencies: 2223 1750 1799
-- Name: value domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_value_domain
    ADD CONSTRAINT "value domain foreign key" FOREIGN KEY (id) REFERENCES core_conceptual_domain(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 2485 (class 2606 OID 360497)
-- Dependencies: 1799 1748 2379
-- Name: value domain foreign key; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY core_closed_linguistic_section
    ADD CONSTRAINT "value domain foreign key" FOREIGN KEY (cd) REFERENCES core_value_domain(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 2584 (class 0 OID 0)
-- Dependencies: 6
-- Name: public; Type: ACL; Schema: -; Owner: -
--

--REVOKE ALL ON SCHEMA public FROM PUBLIC;
--REVOKE ALL ON SCHEMA public FROM postgres;
--GRANT ALL ON SCHEMA public TO postgres;
--GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2012-07-04 13:22:30

--
-- PostgreSQL database dump complete
--