[Pdns-users] When was ordername column added to records table?

[Christian Hofstaedtler]

> On 19 Feb 2015, at 22:37, ktm at rice.edu wrote:
> On Thu, Feb 19, 2015 at 03:34:06PM -0600, Nick Williams wrote:
>> The schema for PDNS 3.0 shows no "ordername" column or "orderindex" index on the records table:
>> https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/no-dnssec.schema.pgsql.sql
>> 
>> And the upgrade instructions for 3.0 -> 3.1 don't include an alter statement for adding the "ordername" column or "orderindex" index:
>> https://doc.powerdns.com/md/authoritative/upgrading/#30-to-31
>> 
>> But the upgrade instructions for 3.1 -> 3.2 includes an alter statement for _modifying_ the "ordername" column and _dropping_ the "orderindex" index that were never added:
>> https://doc.powerdns.com/md/authoritative/upgrading/#31-to-32
>> 
>> […]

>> Can someone provide me some perspective on this?

ordername was added in 3.0, as part of the DNSSEC schema upgrade. (see https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/dnssec.schema.pgsql.sql )


> […] The ALTER TABLE will only apply to previously existing
> tables, not create the needed new ones.

The upgrade SQL scripts in general add/modify tables and columns.

The instructions for upgrading to 3.4.0 include consolidated update scripts, see https://doc.powerdns.com/md/authoritative/upgrading/#database-schema .
Pick the backend and schema type you currently have (if you come from 2.9.22, it’s always the ‘non-dnssec’ type), and you’ll end up with the correct schema.

Best,
-- 
Christian Hofstaedtler / Deduktiva GmbH (FN 418592 b, HG Wien)
www.deduktiva.com / +43 1 353 1707