 CREATE TABLE regexes (
     id bigint DEFAULT nextval('regexes_id_seq'::regclass) NOT NULL,
     pattern text NOT NULL,
-    type text NOT NULL,
+    type text NOT NULL REFERENCES regexes_types (name),
     created_at timestamp without time zone DEFAULT now() NOT NULL
 );
 

    dns_bypass_ip6 inet,
    dns_bypass_ttl integer,
    org_server_fqdn text,
    type text NOT NULL,
    profile text NOT NULL,
    dns_ttl integer,
    global_max_mbps integer,


ALTER TABLE staticdnsentries OWNER TO touser;


--
-- Name: crconfig_ds_data_v; Type: VIEW; Schema: public; Owner: touser
