Last change
on this file since 825 was 725, checked in by Kris Deugau, 9 years ago |
/branches/stable
Merge /trunk through r721; minor tweaks and updates required for RPC
from IPDB
|
File size:
631 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
|
---|
[725] | 4 | ALTER TABLE ONLY domains
|
---|
| 5 | DROP CONSTRAINT domains_pkey;
|
---|
| 6 | ALTER TABLE ONLY domains
|
---|
| 7 | ADD PRIMARY KEY (domain,default_location);
|
---|
[704] | 8 |
|
---|
[725] | 9 | ALTER TABLE ONLY revzones
|
---|
| 10 | DROP CONSTRAINT revzones_pkey;
|
---|
| 11 | ALTER TABLE ONLY revzones
|
---|
| 12 | ADD PRIMARY KEY (revnet,default_location);
|
---|
| 13 |
|
---|
| 14 | -- MIA unique constraint to match domains table. Arguably not strictly necessary.
|
---|
| 15 | ALTER TABLE ONLY revzones
|
---|
| 16 | ADD CONSTRAINT revzones_rdns_id_key UNIQUE (rdns_id);
|
---|
| 17 |
|
---|
| 18 | -- Update dbversion
|
---|
| 19 | UPDATE misc SET value='1.2.6' WHERE key='dbversion';
|
---|
Note:
See
TracBrowser
for help on using the repository browser.