Changeset 2053
- Timestamp:
- 02/25/11 21:54:32 (2 years ago)
- Location:
- trunk/pdns/modules
- Files:
-
- 3 modified
-
gmysqlbackend/gmysqlbackend.cc (modified) (1 diff)
-
gpgsqlbackend/gpgsqlbackend.cc (modified) (1 diff)
-
gsqlite3backend/gsqlite3backend.cc (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/pdns/modules/gmysqlbackend/gmysqlbackend.cc
r2024 r2053 76 76 declare(suffix,"wildcard-any-id-query-auth","Wildcard ANY with ID query","select content,ttl,prio,type,domain_id,name, auth from records where name like '%s' and domain_id='%d'"); 77 77 78 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, auth from records where domain_id='%d'"); 79 80 78 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, auth from records where domain_id='%d' order by name, type"); 81 79 82 80 declare(suffix,"master-zone-query","Data", "select master from domains where name='%s' and type='SLAVE'"); -
trunk/pdns/modules/gpgsqlbackend/gpgsqlbackend.cc
r2024 r2053 73 73 declare(suffix,"wildcard-any-id-query-auth","Wildcard ANY with ID query","select content,ttl,prio,type,domain_id,name, case when auth then 1 else 0 end as auth from records where name like '%s' and domain_id='%d'"); 74 74 75 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, case when auth then 1 else 0 end as auth from records where domain_id='%d' ");75 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, case when auth then 1 else 0 end as auth from records where domain_id='%d' order by name, type"); 76 76 77 77 declare(suffix,"master-zone-query","Data", "select master from domains where name='%s' and type='SLAVE'"); -
trunk/pdns/modules/gsqlite3backend/gsqlite3backend.cc
r2047 r2053 82 82 declare(suffix,"wildcard-any-id-query-auth","Wildcard ANY with ID query","select content,ttl,prio,type,domain_id,name, auth from records where name like '%s' and domain_id='%d'"); 83 83 84 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, auth from records where domain_id='%d' ");84 declare(suffix,"list-query-auth","AXFR query", "select content,ttl,prio,type,domain_id,name, auth from records where domain_id='%d' order by name, type"); 85 85 86 86 declare(suffix,"get-order-before-query","DNSSEC Ordering Query, before", "select ordername, name from records where ordername <= '%s' and auth=1 and domain_id=%d order by 1 desc limit 1");