BIND 10 #1949: proposed sqlite3 schema cleanups

[BIND 10 Development]

#1949: proposed sqlite3 schema cleanups
-------------------------------------+-------------------------------------
            Reporter:  jinmei        |                        Owner:
                Type:  task          |                       Status:  new
            Priority:  medium        |                    Milestone:  New
           Component:  data source   |  Tasks
           Sensitive:  0             |                     Keywords:
         Sub-Project:  DNS           |              Defect Severity:  N/A
Estimated Difficulty:  0             |  Feature Depending on Ticket:
         Total Hours:  0             |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------
 As discussed on
 https://lists.isc.org/pipermail/bind10-dev/2012-April/003373.html
 I propose some schema cleanups for the SQLite3 data source:

 - remove the 'owner' column from the nsec3 table
 - remove the 'sigtype' column from the records table
 - rename 'rdtype' to 'rrtype' in the records table

 The first one will require extending the zone iterator API for the
 database-based data sources.

 Also, if we do this cleanup before replacing the loadzone tool using
 the generic API, the second and third ones (especially the latter)
 will require updating it (more specifically, the
 isc.datasrc.sqlite3_ds module).

 dbutil will also need to be updated.

-- 
Ticket URL: <http://bind10.isc.org/ticket/1949>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development