From 98a9088ff66120c55d711e73d00c22b2bafeaa00 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Wed, 02 Sep 2009 13:28:07 -0400
Subject: [PATCH] added sys_ columns to the remote_user table.

---
 install/sql/ispconfig3.sql |    5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index b229a69..97321cd 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -572,6 +572,11 @@
 
 CREATE TABLE `remote_user` (
   `remote_userid` 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) default NULL,
+  `sys_perm_group` varchar(5) default NULL,
+  `sys_perm_other` varchar(5) default NULL,
   `remote_username` varchar(64) NOT NULL,
   `remote_password` varchar(64) NOT NULL,
   `remote_functions` text NOT NULL,

--
Gitblit v1.9.1