From 6d6a37b9164fe5ec2a0717fa20cf83c12172b07a Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Tue, 07 Jan 2014 08:38:52 -0500
Subject: [PATCH] Updated incremental svn files.
---
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