From 7bce72dd8ffc5a1e072d9d51cd4e40ede7258d3d Mon Sep 17 00:00:00 2001 From: Till Brehm <tbrehm@ispconfig.org> Date: Thu, 07 Apr 2016 12:26:40 -0400 Subject: [PATCH] Fixed: Issue #3693 Choose better default customer numbers for clients of resellers. --- install/sql/ispconfig3.sql | 2 +- install/sql/incremental/upd_dev_collection.sql | 1 + 2 files changed, 2 insertions(+), 1 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index 2c4300a..4333ab7 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -225,4 +225,5 @@ ALTER TABLE `client` ADD COLUMN `limit_database_user` int(11) NOT NULL DEFAULT '-1' after limit_database; ALTER TABLE `client_template` ADD COLUMN `limit_database_user` int(11) NOT NULL DEFAULT '-1' after limit_database; +ALTER TABLE `client` CHANGE `customer_no_template` `customer_no_template` VARCHAR(255) NULL DEFAULT 'R[CLIENTID]C[CUSTOMER_NO]'; diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 9d75095..6eed418 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -255,7 +255,7 @@ `tmp_data` mediumblob, `id_rsa` varchar(2000) NOT NULL DEFAULT '', `ssh_rsa` varchar(600) NOT NULL DEFAULT '', - `customer_no_template` varchar(255) DEFAULT 'C[CUSTOMER_NO]', + `customer_no_template` varchar(255) DEFAULT 'R[CLIENTID]C[CUSTOMER_NO]', `customer_no_start` int(11) NOT NULL DEFAULT '1', `customer_no_counter` int(11) NOT NULL DEFAULT '0', `added_date` date NOT NULL DEFAULT '0000-00-00', -- Gitblit v1.9.1