Hello Jonathan, On 20 Feb 2015, at 18:28 , Jonathan Hunter <[email protected]> wrote:
> Is it possible when implementing NAPTR records in the records table to add > multiple entries within the content field of a record? > > Im just trying to reduce the number of entries in the database, so wondered > if I could have more than one content entry, and if so how do you split them > up? > > So for example I have; > > > select * from records; > +----+-----------+---------------------------+-------+-------------------------------------------------------------+-------+------+-------------+ > | id | domain_id | name | type | content > | ttl | prio | change_date | > +----+-----------+---------------------------+-------+-------------------------------------------------------------+-------+------+-------------+ > > | 27 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 "U" "E2U+sip" > "!^(.*)$!sip:\\[email protected]!". | 120 | NULL | NULL | > | 26 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 "U" "E2U+sip" > "!^(.*)$!sip:\\[email protected]!". | 120 | NULL | NULL | > > Can I add both 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\[email protected]!". and 2 10 > "U" "E2U+sip" "!^(.*)$!sip:\\[email protected]!". into the content of id 27 > without breaking a query? No, this will not work. One database row is one DNS record, there are no exceptions to this. What problem are you trying to solve by combining the records? Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/ _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
