From 2e961201be67cc348e7da22ad7c32c87c9f3d30d Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 11 May 2010 07:00:08 -0400
Subject: [PATCH] Fixed: FS#1186 - Error in Installer r1728
---
install/sql/ispconfig3.sql | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 709ce7a..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;
+
-- --------------------------------------------------------
--
@@ -1148,6 +1164,23 @@
`value` varchar(255) NOT NULL
) ENGINE=MyISAM;
+
+--
+-- Tabellenstruktur für Tabelle `sys_remoteaction`
+--
+
+CREATE TABLE `sys_remoteaction` (
+ `action_id` int(11) unsigned NOT NULL auto_increment,
+ `server_id` int(11) unsigned NOT NULL,
+ `tstamp` int(11) NOT NULL,
+ `action_type` varchar(20) NOT NULL,
+ `action_param` mediumtext NOT NULL,
+ `action_state` enum('pending','ok','warning','error') NOT NULL,
+ `response` mediumtext NOT NULL,
+ PRIMARY KEY (`action_id`),
+ KEY `server_id` (`server_id`)
+) ENGINE=MyISAM;
+
-- --------------------------------------------------------
--
--
Gitblit v1.9.1