Context Navigation

dns-upd-1.2.6.sql@ 803

Last change on this file since 803 was 725, checked in by Kris Deugau, 8 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.