Re: [Dbmail] DBMAIL upgrade 1.2.2 to 1.2.9

Paul J Stevens Fri, 11 Jun 2004 21:43:01 +0200 (CEST)

Becki,

Better do it so you know for sure, period. So use diff:


-----
#!/bin/sh
mysqladmin create dbmailtmp
mysql dbmailtmp < .../sql/mysql/create_tables_innoDB.mysql
mysqldump -d dbmail > dbmail-1.2.2.mysql
mysqldump -d dbmailtmp > dbmail-1.2.9.mysql
diff dbmail-1.2.2.mysql dbmail-1.2.9.mysql
-----

and then send the diff result instead if you can't read it.

regards,


becki wrote:

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 bitstrange .. 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


------------------------------------------------------------------------

_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


--
  ________________________________________________________________
  Paul Stevens                                  mailto:[EMAIL PROTECTED]
  NET FACILITIES GROUP                     PGP: finger [EMAIL PROTECTED]
  The Netherlands________________________________http://www.nfg.nl

Re: [Dbmail] DBMAIL upgrade 1.2.2 to 1.2.9

Reply via email to