View Single Post
  #2  
Old 31st December 2005, 18:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

You could change the table definition for the table isp_isp_user from
Code:
CREATE TABLE `isp_isp_user` (
  `doc_id` bigint(20) NOT NULL auto_increment,
  `doctype_id` bigint(20) NOT NULL default '1014',
  `user_username` varchar(32) default NULL,
  `user_passwort` varchar(20) default NULL,
  `user_speicher` varchar(10) default NULL,
  `user_admin` char(1) default NULL,
  `user_shell` char(1) default NULL,
  `user_emailalias` text,
  `user_name` varchar(255) default NULL,
  `status` char(1) default NULL,
  `user_autoresponder` char(1) default NULL,
  `user_autoresponder_text` text,
  `user_mailquota` varchar(10) default NULL,
  `user_catchallemail` char(1) default '0',
  `user_mailscan` char(1) default NULL,
  `user_emailweiterleitung_local_copy` smallint(6) default NULL,
  `user_email` varchar(255) default NULL,
  `user_emailweiterleitung` text,
  `user_spamfilter` char(1) default NULL,
  `spam_strategy` varchar(255) NOT NULL default 'accept',
  `spam_hits` varchar(255) default '5.0',
  `spam_rewrite_subject` char(1) NOT NULL default '1',
  `spam_subject_tag` varchar(255) NOT NULL default '***SPAM*** ',
  `antivirus` char(1) NOT NULL default '0',
  `user_lang` char(2) NOT NULL default '',
  PRIMARY KEY  (`doc_id`),
  KEY `doctype_id` (`doctype_id`)
) TYPE=MyISAM;
to

Code:
CREATE TABLE `isp_isp_user` (
  `doc_id` bigint(20) NOT NULL auto_increment,
  `doctype_id` bigint(20) NOT NULL default '1014',
  `user_username` varchar(32) default NULL,
  `user_passwort` varchar(20) default NULL,
  `user_speicher` varchar(10) default NULL,
  `user_admin` char(1) default NULL,
  `user_shell` char(1) default NULL,
  `user_emailalias` text,
  `user_name` varchar(255) default NULL,
  `status` char(1) default NULL,
  `user_autoresponder` char(1) default NULL,
  `user_autoresponder_text` text,
  `user_mailquota` varchar(10) default NULL,
  `user_catchallemail` char(1) default '0',
  `user_mailscan` char(1) default NULL,
  `user_emailweiterleitung_local_copy` smallint(6) default NULL,
  `user_email` varchar(255) default NULL,
  `user_emailweiterleitung` text,
  `user_spamfilter` char(1) default '1',
  `spam_strategy` varchar(255) NOT NULL default 'accept',
  `spam_hits` varchar(255) default '5.0',
  `spam_rewrite_subject` char(1) NOT NULL default '1',
  `spam_subject_tag` varchar(255) NOT NULL default '***SPAM*** ',
  `antivirus` char(1) NOT NULL default '1',
  `user_lang` char(2) NOT NULL default '',
  PRIMARY KEY  (`doc_id`),
  KEY `doctype_id` (`doctype_id`)
) TYPE=MyISAM;
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote