From 24f38b424a3d12c7f4fac1829c83725b200b1e97 Mon Sep 17 00:00:00 2001
From: vogelor <vogelor@ispconfig3>
Date: Wed, 26 May 2010 05:42:11 -0400
Subject: [PATCH] Enhancement of the Website-List. The user can only select the server as filter, he has some sites at (and not ALL Servers of the server-farm)
---
install/sql/ispconfig3.sql | 21 +++++++++++++++++++--
1 files changed, 19 insertions(+), 2 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index e9db32e..e0a3a92 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -262,6 +262,22 @@
PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
+--
+-- Tabellenstruktur für Tabelle `domain`
+--
+
+CREATE TABLE `domain` (
+ `domain_id` int(11) unsigned NOT NULL auto_increment,
+ `sys_userid` int(11) unsigned NOT NULL default '0',
+ `sys_groupid` int(11) unsigned NOT NULL default '0',
+ `sys_perm_user` varchar(5) NOT NULL default '',
+ `sys_perm_group` varchar(5) NOT NULL default '',
+ `sys_perm_other` varchar(5) NOT NULL default '',
+ `domain` varchar(255) NOT NULL default '',
+ PRIMARY KEY (`domain_id`),
+ UNIQUE KEY `domain` (`domain`)
+) ENGINE=MyISAM;
+
-- --------------------------------------------------------
--
@@ -1159,9 +1175,10 @@
`tstamp` int(11) NOT NULL,
`action_type` varchar(20) NOT NULL,
`action_param` mediumtext NOT NULL,
- `action_status` enum('pending','ok','warning','error') NOT NULL,
+ `action_state` enum('pending','ok','warning','error') NOT NULL,
`response` mediumtext NOT NULL,
- PRIMARY KEY (`action_id`)
+ PRIMARY KEY (`action_id`),
+ KEY `server_id` (`server_id`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
Gitblit v1.9.1