From 9376d70f0ccba49ead95ef47f0ecba568ea2d6e1 Mon Sep 17 00:00:00 2001 From: Marius Burkard <m.burkard@pixcept.de> Date: Mon, 23 May 2016 04:35:50 -0400 Subject: [PATCH] - added example for REST api --- install/sql/ispconfig3.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index d9898fb..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 ; -- -------------------------------------------------------- -- Gitblit v1.9.1