Changeset 762 for trunk/cgi-bin


Ignore:
Timestamp:
07/29/15 13:10:53 (9 years ago)
Author:
Kris Deugau
Message:

/trunk

Update 2.7 -> 3.0 SQL upgrade script

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/cgi-bin/ipdb-2.7-3.0.sql

    r691 r762  
    55-- has run, IPDB v2.7 and older will NOT be able to properly manipulate
    66-- the data!
     7
     8-- Flag table for deciding if we can usefully do rDNS RPC calls.
     9CREATE TABLE dnsavail (
     10    "zone" cidr PRIMARY KEY,
     11    "location" varchar(2) DEFAULT '',
     12    parent_alloc integer NOT NULL
     13);
    714
    815-- Master and routed blocks now live in the allocations table.
     
    1522ALTER TABLE allocations DROP CONSTRAINT allocations_pkey;
    1623ALTER TABLE allocations ADD COLUMN id serial PRIMARY KEY;
     24CREATE UNIQUE INDEX allocations_skey ON allocations (cidr,vrf,type);
    1725
    1826ALTER TABLE freeblocks ADD COLUMN vrf text NOT NULL DEFAULT '';
    1927ALTER TABLE freeblocks ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
    2028ALTER TABLE freeblocks ADD COLUMN master_id integer NOT NULL DEFAULT 0;
     29ALTER TABLE freeblocks ADD COLUMN reserve_for integer NOT NULL DEFAULT 0;
    2130ALTER TABLE freeblocks DROP CONSTRAINT freeblocks_pkey;
    2231ALTER TABLE freeblocks ADD CONSTRAINT freeblocks_pkey PRIMARY KEY ("cidr","parent_id");
Note: See TracChangeset for help on using the changeset viewer.