Context Navigation

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

Last change on this file since 708 was 704, checked in by Kris Deugau, 9 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

Rev	Line
[704]	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.