From 2ed8912b353101bbe1b23fd74446eb9bce1a6751 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kly@kly.no>
Date: Thu, 30 Jun 2016 08:18:00 +0200
Subject: sql: Bump schema to include multi-dhcpd-support

---
 build/schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'build/schema.sql')

diff --git a/build/schema.sql b/build/schema.sql
index 2cddcc3..9adc7ad 100644
--- a/build/schema.sql
+++ b/build/schema.sql
@@ -4,7 +4,7 @@
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
-SET client_encoding = 'SQL_ASCII';
+SET client_encoding = 'UTF8';
 SET standard_conforming_strings = on;
 SET check_function_bodies = false;
 SET client_min_messages = warning;
@@ -86,7 +86,8 @@ CREATE TABLE dhcp (
     switch integer,
     "time" timestamp with time zone,
     mac macaddr,
-    ip inet
+    ip inet,
+    dhcp_server integer
 );
 
 
-- 
cgit v1.2.3

