From c5d17d3fd1bbdca95dd9230a2ab54f5aef04aef8 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Fri, 22 Jul 2011 09:48:47 -0400
Subject: [PATCH] Bugfixes in server list in vm server forms.
---
install/sql/ispconfig3.sql | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 21d3391..501c9d0 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -504,6 +504,27 @@
-- --------------------------------------------------------
+-- Table structure for table `iptables`
+--
+
+DROP TABLE IF EXISTS `iptables`;
+CREATE TABLE `iptables` (
+ `iptables_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `server_id` int(10) unsigned NOT NULL DEFAULT '0',
+ `table` varchar(10) DEFAULT NULL COMMENT 'INPUT OUTPUT FORWARD',
+ `source_ip` varchar(16) DEFAULT NULL,
+ `destination_ip` varchar(16) DEFAULT NULL,
+ `protocol` varchar(10) DEFAULT 'TCP' COMMENT 'TCP UDP GRE',
+ `singleport` varchar(10) DEFAULT NULL,
+ `multiport` varchar(40) DEFAULT NULL,
+ `state` varchar(20) DEFAULT NULL COMMENT 'NEW ESTABLISHED RECNET etc',
+ `target` varchar(10) DEFAULT NULL COMMENT 'ACCEPT DROP REJECT LOG',
+ `active` enum('n','y') NOT NULL DEFAULT 'y',
+ PRIMARY KEY (`iptables_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
--
-- Table structure for table `mail_access`
--
--
Gitblit v1.9.1