 ALTER TABLE ONLY cachegroups
     ADD CONSTRAINT cachegroups_parent_cachegroup_cachegroups_name_fkey FOREIGN KEY (parent_cachegroup) REFERENCES cachegroups(name);
 
-
---
--- Name: cachegroups_type_types_name_fkey; Type: FK CONSTRAINT; Schema: public; Owner: touser
---
-
-ALTER TABLE ONLY cachegroups
-    ADD CONSTRAINT cachegroups_type_types_name_fkey FOREIGN KEY (type) REFERENCES types(name);
-
-
 --
 -- Name: deliveryservices_cdn_cdns_name_fkey; Type: FK CONSTRAINT; Schema: public; Owner: touser
 --


ALTER TABLE domains OWNER TO touser;

--
-- Name: extensions; Type: TABLE; Schema: public; Owner: touser
--


ALTER TABLE asns OWNER TO touser;


CREATE TABLE cachegroups_types (
    name text PRIMARY KEY,
    description text NOT NULL,
    created_at timestamp without time zone DEFAULT now() NOT NULL
);
ALTER TABLE cachegroups_types OWNER TO touser;

--
-- Name: cachegroups; Type: TABLE; Schema: public; Owner: touser
--
