hello ilja, thanks again a lot for your reply - you are very helpful ;-)
so ... a 1.2.2 version with passwd field of varchar(32) sounds a bit strange .. well that's what i got on my runing system ! anyway ... will send you a dump of the mysql database structure. hopefully you can tell me if the upgrade is going to work fine ! thanks a lot & have fun becki ==>> sql dump below ==>> # # Table structure for table `aliases` # CREATE TABLE aliases ( alias_idnr bigint(21) NOT NULL auto_increment, alias varchar(100) NOT NULL default '', deliver_to varchar(250) NOT NULL default '', client_idnr bigint(21) NOT NULL default '0', PRIMARY KEY (alias_idnr), UNIQUE KEY alias_idnr_2 (alias_idnr), KEY alias (alias) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `auto_notifications` # CREATE TABLE auto_notifications ( auto_notify_idnr bigint(21) NOT NULL auto_increment, user_idnr bigint(21) NOT NULL default '0', notify_address varchar(100) default NULL, PRIMARY KEY (auto_notify_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `auto_replies` # CREATE TABLE auto_replies ( auto_reply_idnr bigint(21) NOT NULL auto_increment, user_idnr bigint(21) NOT NULL default '0', reply_body mediumtext, PRIMARY KEY (auto_reply_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `config` # CREATE TABLE config ( configid int(11) NOT NULL default '0', item varchar(128) NOT NULL default '', value varchar(128) NOT NULL default '' ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `mailboxes` # CREATE TABLE mailboxes ( mailbox_idnr bigint(21) NOT NULL auto_increment, owner_idnr bigint(21) NOT NULL default '0', name varchar(100) NOT NULL default '', seen_flag tinyint(1) NOT NULL default '0', answered_flag tinyint(1) NOT NULL default '0', deleted_flag tinyint(1) NOT NULL default '0', flagged_flag tinyint(1) NOT NULL default '0', recent_flag tinyint(1) NOT NULL default '0', draft_flag tinyint(1) NOT NULL default '0', no_inferiors tinyint(1) NOT NULL default '0', no_select tinyint(1) NOT NULL default '0', permission tinyint(1) default '2', is_subscribed tinyint(1) NOT NULL default '0', PRIMARY KEY (mailbox_idnr), UNIQUE KEY mailboxidnr_2 (mailbox_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `messageblks` # CREATE TABLE messageblks ( messageblk_idnr bigint(21) NOT NULL auto_increment, message_idnr bigint(21) NOT NULL default '0', messageblk longtext NOT NULL, blocksize bigint(21) NOT NULL default '0', PRIMARY KEY (messageblk_idnr), UNIQUE KEY messageblk_idnr_2 (messageblk_idnr), KEY messageblk_idnr (messageblk_idnr), KEY msg_index (message_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `messages` # CREATE TABLE messages ( message_idnr bigint(21) NOT NULL auto_increment, mailbox_idnr bigint(21) NOT NULL default '0', messagesize bigint(21) NOT NULL default '0', seen_flag tinyint(1) NOT NULL default '0', answered_flag tinyint(1) NOT NULL default '0', deleted_flag tinyint(1) NOT NULL default '0', flagged_flag tinyint(1) NOT NULL default '0', recent_flag tinyint(1) NOT NULL default '0', draft_flag tinyint(1) NOT NULL default '0', unique_id varchar(70) NOT NULL default '', internal_date datetime NOT NULL default '0000-00-00 00:00:00', status tinyint(3) unsigned zerofill NOT NULL default '000', rfcsize bigint(21) NOT NULL default '0', PRIMARY KEY (message_idnr), UNIQUE KEY message_idnr_2 (message_idnr), KEY message_idnr (message_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `pbsp` # CREATE TABLE pbsp ( idnr bigint(21) NOT NULL auto_increment, since datetime NOT NULL default '0000-00-00 00:00:00', ipnumber varchar(40) NOT NULL default '', PRIMARY KEY (idnr), UNIQUE KEY ipnumber_2 (ipnumber), UNIQUE KEY idnr_2 (idnr), KEY idnr (idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `tmpmessage` # CREATE TABLE tmpmessage ( message_idnr bigint(21) NOT NULL auto_increment, mailbox_idnr int(21) NOT NULL default '0', messagesize bigint(21) NOT NULL default '0', seen_flag tinyint(1) NOT NULL default '0', answered_flag tinyint(1) NOT NULL default '0', deleted_flag tinyint(1) NOT NULL default '0', flagged_flag tinyint(1) NOT NULL default '0', recent_flag tinyint(1) NOT NULL default '0', draft_flag tinyint(1) NOT NULL default '0', unique_id varchar(70) NOT NULL default '', internal_date datetime NOT NULL default '0000-00-00 00:00:00', status tinyint(3) unsigned zerofill NOT NULL default '000', PRIMARY KEY (message_idnr), UNIQUE KEY message_idnr_2 (message_idnr), KEY message_idnr (message_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `tmpmessageblk` # CREATE TABLE tmpmessageblk ( messageblk_idnr bigint(21) NOT NULL auto_increment, message_idnr bigint(21) NOT NULL default '0', messageblk longtext NOT NULL, blocksize bigint(21) NOT NULL default '0', PRIMARY KEY (messageblk_idnr), UNIQUE KEY messageblk_idnr_2 (messageblk_idnr), KEY messageblk_idnr (messageblk_idnr), KEY msg_index (message_idnr) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `users` # CREATE TABLE users ( user_idnr bigint(21) NOT NULL auto_increment, userid varchar(100) NOT NULL default '', passwd varchar(32) NOT NULL default '', client_idnr bigint(21) NOT NULL default '0', maxmail_size bigint(21) NOT NULL default '0', encryption_type varchar(20) NOT NULL default '', last_login datetime NOT NULL default '1979-11-03 22:05:58', PRIMARY KEY (user_idnr), UNIQUE KEY userid_2 (userid), UNIQUE KEY useridnr_2 (user_idnr,userid), KEY user_idnr (user_idnr,userid) ) TYPE=MyISAM; --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.700 / Virus Database: 457 - Release Date: 6/6/2004
