From 39dd4ecc8b4a2b3b98a7ffe7056ae64240b22d56 Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Sun, 11 May 2014 17:39:37 -0400
Subject: [PATCH] - Added functions client_get_emailcontact and client_login_get to remote api. - Add option to _get functions of the remote-api to return all records when primaryID = -1 - Fixed permission problem in _get functions of remote api. - Fixed typo in german dashboard language file.
---
install/sql/incremental/upd_0060.sql | 22 ++++++++--------------
1 files changed, 8 insertions(+), 14 deletions(-)
diff --git a/install/sql/incremental/upd_0060.sql b/install/sql/incremental/upd_0060.sql
index d68d2bf..64c9a0d 100644
--- a/install/sql/incremental/upd_0060.sql
+++ b/install/sql/incremental/upd_0060.sql
@@ -1,14 +1,8 @@
-CREATE TABLE `mail_backup` (
- `backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `server_id` int(10) unsigned NOT NULL,
- `parent_domain_id` int(10) unsigned NOT NULL,
- `mailuser_id` int(10) unsigned NOT NULL,
- `backup_mode` varchar(64) NOT NULL DEFAULT '',
- `tstamp` int(10) unsigned NOT NULL,
- `filename` varchar(255) NOT NULL,
- `filesize` VARCHAR(10) NOT NULL,
- PRIMARY KEY (`backup_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
-ALTER TABLE `mail_user` ADD `backup_interval` VARCHAR( 255 ) NOT NULL ;
-ALTER TABLE `mail_user` ADD `backup_copies` INT NOT NULL DEFAULT '1';
+ALTER TABLE `client` ADD `customer_no_template` VARCHAR( 255 ) NULL DEFAULT 'C[CUSTOMER_NO]' AFTER `ssh_rsa` ,
+ADD `customer_no_start` INT NOT NULL DEFAULT '1' AFTER `customer_no_template` ,
+ADD `customer_no_counter` INT NOT NULL DEFAULT '0' AFTER `customer_no_start` ,
+ADD `added_date` DATE NOT NULL default '0000-00-00' AFTER `customer_no_counter` ,
+ADD `added_by` VARCHAR( 255 ) NULL AFTER `added_date` ;
+ALTER TABLE `web_domain` ADD `added_date` DATE NOT NULL default '0000-00-00' AFTER `rewrite_rules` ,
+ADD `added_by` VARCHAR( 255 ) NULL AFTER `added_date` ;
+ALTER TABLE `sys_session` ADD `permanent` ENUM('n','y') NOT NULL DEFAULT 'n' AFTER `last_updated`;
\ No newline at end of file
--
Gitblit v1.9.1