Untitled

CREATE VIEW domains AS

    SELECT dns_zones.id, dns_zones.name, NULL::character varying AS master, NULL::integer AS last_check, 'NATIVE'::character varying AS type, NULL::integer AS notified_serial, dns_zones.customer_id AS account FROM dns_zones;

 

 

CREATE VIEW records AS

    SELECT dns_records.id, dns_records.name, dns_records.content, dns_records.ttl, dns_records.prio, dns_records.type, NULL::integer AS change_date, dns_records.dns_zone_id AS domain_id FROM dns_records;

 

 

ALTER TABLE public.domains OWNER TO pdns;

ALTER TABLE public.records OWNER TO pdns;