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
|
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.