From 5915a89a32e96146d360c7d14c9c39da941b5fd1 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 01 Jun 2010 07:11:04 -0400
Subject: [PATCH] Fixed: FS#1205 - phpmyadmin warning
---
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