From c8ccbfb4f4e323d828af15f0bc33cc979cc501b9 Mon Sep 17 00:00:00 2001 From: mcramer <m.cramer@pixcept.de> Date: Thu, 20 Sep 2012 12:56:41 -0400 Subject: [PATCH] Next step of importer --- install/sql/ispconfig3.sql | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 2817f75..782705d 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, @@ -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