BIND 10 #963: Utility to upgrade SQLite schema

[BIND 10 Development]

#963: Utility to upgrade SQLite schema
-------------------------------------+-------------------------------------
                   Reporter:  shane  |                 Owner:
                       Type:         |                Status:  new
  enhancement                        |             Milestone:  Year 3 Task
                   Priority:  major  |  Backlog
                  Component:  data   |            Resolution:
  source                             |             Sensitive:  0
                   Keywords:         |           Sub-Project:  DNS
            Defect Severity:  N/A    |  Estimated Difficulty:  0.0
Feature Depending on Ticket:         |           Total Hours:  0
  sqlite schema upgrade              |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------

Comment (by shane):

 We discussed schema versioning on our call today, and Stephen noted that
 we probably want to have a major/minor version number for schemas.

 The basic approach would be that minor version numbers are backward-
 compatible. This includes indexing changes, adding tables or perhaps
 columns, and maybe integrity constraints. If a minor version change is
 detected then BIND 10 should output a WARNING.

 Major versions are backward-incompatible. This includes, well, lots of
 stuff. If a major version change is detected then BIND 10 should output an
 ERROR and exit.

-- 
Ticket URL: <http://bind10.isc.org/ticket/963#comment:2>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development