From ac28e80eb785b1e3651b56e86fd625f77b4c9ae1 Mon Sep 17 00:00:00 2001
From: Dietmar Maurer <dietmar@proxmox.com>
Date: Tue, 30 Jan 2018 09:04:15 +0100
Subject: [PATCH] remove unique constraint from LocalStat(Time)

Because the Primary Key is TIME/CID.
---
 PMG/DBTools.pm | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/PMG/DBTools.pm b/PMG/DBTools.pm
index a7c96c4..2a132ad 100644
--- a/PMG/DBTools.pm
+++ b/PMG/DBTools.pm
@@ -146,7 +146,7 @@ __EOD
 
 my $local_stat_ctablecmd =  <<__EOD;
     CREATE TABLE LocalStat
-    (Time INTEGER NOT NULL UNIQUE,
+    (Time INTEGER NOT NULL,
      RBLCount INTEGER DEFAULT 0 NOT NULL,
      PregreetCount INTEGER DEFAULT 0 NOT NULL,
      CID INTEGER NOT NULL,
@@ -491,6 +491,10 @@ sub upgradedb {
 		 "PregreetCount INTEGER DEFAULT 0 NOT NULL");
     }
 
+    eval { $dbh->do("ALTER TABLE LocalStat DROP CONSTRAINT localstat_time_key"); };
+    # ignore errors here
+
+
     # add missing TicketID to CMSReceivers
     if (!database_column_exists($dbh, 'CMSReceivers', 'TicketID')) {
 	eval {
-- 
2.39.5