Context Navigation

source: trunk/dns-upd-1.2.6.sql@ 717

Last change on this file since 717 was 704, checked in by Kris Deugau, 8 years ago

/trunk

Refine a couple of segments of location handling

resurrect a missing dropdown on new revzone page
update DB structure and code to allow duplicate zone names so long as each is in a different location/view
show the location/view in the zone lists

File size: 353 bytes

Line
1	-- SQL to update DNS DB schema for 1.2.6
2
3	-- Allow zones to be duplicated, so long as each version is in a unique location
4	ALTER TABLE domains DROP CONSTRAINT domains_pkey;
5	ALTER TABLE domains ADD PRIMARY KEY (domain,default_location);
6
7	ALTER TABLE revzones DROP CONSTRAINT revzones_pkey;
8	ALTER TABLE revzones ADD PRIMARY KEY (revnet,default_location);

Note: See TracBrowser for help on using the repository browser.