-- SQL to update DNS DB schema for 1.2.6

-- Allow zones to be duplicated, so long as each version is in a unique location
ALTER TABLE domains DROP CONSTRAINT domains_pkey;
ALTER TABLE domains ADD PRIMARY KEY (domain,default_location);

ALTER TABLE revzones DROP CONSTRAINT revzones_pkey;
ALTER TABLE revzones ADD PRIMARY KEY (revnet,default_location);