From d4eae9fd3946d0747a555710f52099221586d538 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Mon, 21 Sep 2009 11:46:32 -0400 Subject: [PATCH] Fixed: FS#875 - SRV Records need validation --- install/sql/ispconfig3.sql | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index b229a69..fe6dfdb 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -103,7 +103,7 @@ `usertheme` varchar(32) NOT NULL default 'default', `template_master` int(11) unsigned NOT NULL default '0', `template_additional` varchar(255) NOT NULL default '', - `created_at` datetime default NULL, + `created_at` bigint(20) DEFAULT NULL, PRIMARY KEY (`client_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; @@ -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