From a84ff46ff8c731a321ae87bea0e05d3fef3aceae Mon Sep 17 00:00:00 2001 From: mcramer <m.cramer@pixcept.de> Date: Tue, 09 Oct 2012 07:29:34 -0400 Subject: [PATCH] Bugfix: removed some columns from being sortable --- install/sql/ispconfig3.sql | 9 ++++++++- 1 files changed, 8 insertions(+), 1 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 2817f75..67df290 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -59,6 +59,11 @@ CREATE TABLE IF NOT EXISTS `aps_instances` ( `id` int(4) 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, `server_id` int(11) NOT NULL DEFAULT '0', `customer_id` int(4) NOT NULL, `package_id` int(4) NOT NULL, @@ -155,6 +160,7 @@ `internet` varchar(255) NOT NULL, `icq` varchar(16) DEFAULT NULL, `notes` text, + `bank_account_owner` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `bank_code` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, @@ -215,7 +221,7 @@ `language` char(2) NOT NULL DEFAULT 'en', `usertheme` varchar(32) NOT NULL DEFAULT 'default', `template_master` int(11) unsigned NOT NULL DEFAULT '0', - `template_additional` varchar(255) NOT NULL DEFAULT '', + `template_additional` text NOT NULL DEFAULT '', `created_at` bigint(20) DEFAULT NULL, `id_rsa` varchar(2000) NOT NULL DEFAULT '', `ssh_rsa` varchar(600) NOT NULL DEFAULT '', @@ -1662,6 +1668,7 @@ `sys_perm_user` varchar(5) DEFAULT NULL, `sys_perm_group` varchar(5) DEFAULT NULL, `sys_perm_other` varchar(5) DEFAULT NULL, + `server_id` int(11) UNSIGNED NOT NULL DEFAULT '0', `database_user` varchar(64) DEFAULT NULL, `database_password` varchar(64) DEFAULT NULL, PRIMARY KEY (`database_user_id`) -- Gitblit v1.9.1