From 181ee7eedc5b73dfb893fa13bd5a5fa155e0562b Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Thu, 26 May 2016 09:03:14 -0400
Subject: [PATCH] Fixed #3855  - Added missing html template for form page System > Interface config > DNS

---
 install/sql/ispconfig3.sql |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 17b08b6..a14a0d6 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -657,7 +657,7 @@
   `traffic_date` date NOT NULL,
   `in_bytes` bigint(32) unsigned NOT NULL,
   `out_bytes` bigint(32) unsigned NOT NULL,
-  PRIMARY KEY (`hostname`,`traffic_date`)
+  UNIQUE KEY (`hostname`,`traffic_date`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
@@ -1153,7 +1153,7 @@
   `veid` int(11) NOT NULL DEFAULT '0',
   `traffic_date` date NULL DEFAULT NULL,
   `traffic_bytes` bigint(32) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`veid`,`traffic_date`)
+  UNIQUE KEY (`veid`,`traffic_date`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -2043,7 +2043,7 @@
   `hostname` varchar(255) NOT NULL DEFAULT '',
   `traffic_date` date NULL DEFAULT NULL,
   `traffic_bytes` bigint(32) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`hostname`,`traffic_date`)
+  UNIQUE KEY  (`hostname`,`traffic_date`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
 
 -- --------------------------------------------------------
@@ -2477,7 +2477,7 @@
 -- Dumping data for table `sys_config`
 --
 
-INSERT INTO sys_config VALUES ('db','db_version','3.1a1');
+INSERT INTO sys_config VALUES ('db','db_version','3.1b1');
 INSERT INTO sys_config VALUES ('interface','session_timeout','0');
 
 SET FOREIGN_KEY_CHECKS = 1;

--
Gitblit v1.9.1