BIND 10 trac2142, updated. e1db86a4ff9f3c0190fb3aedb74efa1725fa7a6f [2142] Updated schema specification after review

[BIND 10 source code commits]

The branch, trac2142 has been updated
       via  e1db86a4ff9f3c0190fb3aedb74efa1725fa7a6f (commit)
      from  5ad130df69219a00a4ab28d5028e9fc07282b9c2 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit e1db86a4ff9f3c0190fb3aedb74efa1725fa7a6f
Author: Stephen Morris <stephen at isc.org>
Date:   Tue Oct 16 18:31:31 2012 +0100

    [2142] Updated schema specification after review

-----------------------------------------------------------------------

Summary of changes:
 src/lib/dhcp/dhcpdb_create.mysql |   20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

-----------------------------------------------------------------------
diff --git a/src/lib/dhcp/dhcpdb_create.mysql b/src/lib/dhcp/dhcpdb_create.mysql
index 6f95f94..e5003ae 100644
--- a/src/lib/dhcp/dhcpdb_create.mysql
+++ b/src/lib/dhcp/dhcpdb_create.mysql
@@ -13,6 +13,21 @@
 # NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION
 # WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
 
+# This is the BIND 10 DHCP schema specification for MySQL.
+#
+# The schema is reasonably portable (with the exception of the engine
+# specification, which is MySQL-specific).  Minor changes might be needed for
+# other databases.
+
+# To create the schema, either type the command:
+#
+# mysql -u <user> -p <password> <database> < dhcpdb_create.mysql
+#
+# ... at the command prompt, or log in to the MySQL database and at the "mysql>"
+# prompt, issue the command:
+#
+# source dhcpdb_create.mysql
+
 # Holds the IPv4 leases.
 CREATE TABLE lease4 (
     address INT UNSIGNED UNIQUE NOT NULL,   # IPv4 address
@@ -28,15 +43,16 @@ CREATE TABLE lease6 (
     address BINARY(16) UNIQUE NOT NULL,     # IPv6 address
     hwaddr VARCHAR(20),                     # Hardware address
     client_id VARCHAR(128),                 # Client ID
-    lifetime INT UNSIGNED,                  # Length of the lease (seconds)
+    lease_time INT UNSIGNED,                # Length of the lease (seconds)
     expire TIMESTAMP,                       # Expiration time of the lease
     subnet_id INT UNSIGNED,                 # Subnet identification
+    pref_lifetime INT UNSIGNED,             # Preferred lifetime
     lease_type TINYINT,                     # Lease type
     iaid INT UNSIGNED,                      # IA ID
     prefix_len TINYINT UNSIGNED             # For IA_PD only
     ) ENGINE = INNODB;
 
-# ... and a definition of leasei6 types.  This table is a convenience for
+# ... and a definition of lease6 types.  This table is a convenience for
 # users of the database - if they want to view the lease table and use the
 # type names, they can join this table with the lease6 table
 CREATE TABLE lease6_types (