- Removed MySQL indexes added accidentally.
- Fixed a commentary in a DORA unit tests.

fixing " to ' as mysql will throw errors about "

The only review item not addressed with this commit is the
implementation of unit test that operates on the read only
database, i.e. the database containing tables on which the
given user only has SELECT privileges.

# Conflicts:
#	src/bin/admin/tests/data/pgsql.lease6_dump_test.reference.csv

# Conflicts:
#	ChangeLog
#	src/lib/dhcpsrv/cfg_hosts.cc

- Option code in dhcp6_options table is now SMALLINT.
- Subnet ids are now unsigned.

    Moved schema scripts into a new common location:

        src/share/database/scripts

    to make them accessible to both kea-admin and dhcpsrv testing

- cppcheck issues
- Unique index for prefix and prefix length.

- Added new table host_identifier_type
- Added foreign key on hosts table referencing
  host_identifier_type
- Indexes on hosts table are now unique

AUTHORS
    Added pull submitter,https://github.com/isc-projects/kea/pull/16,
    Sebastien Couture.

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    Fixed "FROm"

Bumps MySQL schema version from 4.0 to 4.1.

Fixes the issue spelled out in 4238 by adding an entry for hardware
address source of zero. This change was added here to limit the
number of schema version bumps.

Changes the MySQL lease dump functions to order by the lease address.
This ensures the dumps always ordered in a predictable manner.

src/bin/admin/scripts/mysql/upgrade_4.0_to_4.1.sh.in
    New file to upgrade from 4.0 to 4.1

configure.ac
    Added entry for mysql/upgrade_4.0_to_4.1.sh

src/bin/admin/scripts/mysql/Makefile.am
    Added entry form upgrade_4.0_to_4.1.sh

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    Added insert of HWADDR_SOURCE_UNKNOWN  into lease_hwaddr_source
    Added order by clauses to lease4DumpData and lease6DumpData
    Updated schema version from 4.0 to 4.1

src/bin/admin/tests/mysql_tests.sh.in
    mysql_upgrade_test()
        Added test for 4.0 to 4.1 upgrade
        Changed final version check to 4.1

All MySQL text to create tables sets ENGINE to INNODB
MySQL unit tests now reliably drop the "hosts" table

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    Added "ENGINE = INNODB" table creates where needed

src/bin/admin/scripts/mysql/upgrade_1.0_to_2.0.sh.in
src/bin/admin/scripts/mysql/upgrade_2.0_to_3.0.sh.in
    Added "ENGINE = INNODB" table creates where needed

src/bin/admin/tests/data/mysql.lease6_dump_test.reference.csv
    Reversed order of reference file to match INNODB result

src/bin/admin/tests/dhcpdb_create_1.0.mysql
    Added "ENGINE = INNODB" table creates where needed

src/bin/admin/tests/mysql_tests.sh.in
    Removed unnecessary explicit drop of ipv6_reservations

src/lib/dhcpsrv/tests/mysql_schema.cc
    Added MySQL error output on statement failures

src/lib/dhcpsrv/tests/schema_mysql_copy.h
    const char* destroy_statement[]
        Added statement to turn off referential integrity checks, so all
        tables will get dropped.  "hosts" table was being left behind.

    const char* create_statement[]
        Added "ENGINE = INNODB" table creates where needed

Also, updated the lease_hwaddr_source table with missing
entries from the lease.cc.

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    lease6DumpData() -  added lookup of lease_hwaddr_source name

src/bin/admin/scripts/mysql/upgrade_3.0_to_4.0.sh.in
    lease6DumpData() -  added lookup of lease_hwaddr_source name

src/bin/admin/tests/data/mysql.lease6_dump_test.reference.csv
    added hwaddr_source names to test reference data

src/bin/admin/tests/mysql_tests.sh.in
    mysql_lease6_dump_test() - changed hwaddr_source test values

src/bin/admin/kea-admin.in
    src/bin/admin/kea-admin.in
        get_dump_query() - modified SQL text returned for MySQL backend
        which calls stored procedures to produce lease dumps  rather than
        SQL text from lease_dump_<version>.sh

src/bin/admin/scripts/mysql/Makefile.am
    removed entries for leave_dump_<version>.sh files

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    Added sql to create stored procedures for lease dumps:
        lease4DumpHeader
        lease4DumpData
        lease6DumpHeader
        lease6DumpData

src/bin/admin/scripts/pgsql/dhcpdb_create.pgsql
    Changes table references in lease6DumpData() to match
    convention used in MySQL lease6DumpData()

src/bin/admin/tests/mysql_tests.sh.in
    mysql_lease4_dump_test() - change lease4 test leases to have differing
    values for lease4.state

    mysql_lease6_dump_test() - change lease4 test leases to have differing
    values for lease6.state

mysql.lease4_dump_test.reference.csv
mysql.lease6_dump_test.reference.csv
    Changed reference files to use lease_state.name values rather than
    lease.state to match dump query output and  new test data

src/bin/admin/scripts/mysql
    deleted the following files as they are now obsolete
        leave_dump_1.0.sh
        leave_dump_2.0.sh
        leave_dump_3.0.sh
        leave_dump_4.0.sh
    Makefile.am - removed entries for deleted lease dump scripts

 - upgrade 2.0 to 3.0 script added
 - added unit-tests
 - dhcpdb_create.mysql script now uses the same database

 - Applied patch as submitted by Adam Kalmus

 - mysql/upgrade_1.0_to_2.0.sh renamed to .in
 - header added to admin-utils.sh, revoked exec bit
 - kea-admin clarified (db => lease db)
 - kea-admin manpage corrected
 - lease6_hwaddr_source renamed to lease_hwaddr_source
 - mysql_tests are now working without installation

 - LeaseType is now initalized from static array
 - @todos added in 2 MySQL tests
 - Added a comment about lease type values to MySQL schema

Also, included FQDN fields in the MySQL script creating database.