Simon Lange wrote: > Hi Paul, > Sounds good, but to be honest i guess you had good reasons to change the > table fieldtypes and other database-structures. > So, is there a golden way to update 207 to 208 without loss of data AND get > the advantage of those database-changes. Or why you have changed them if > nobody "needs" to change their database-modell?!
The ON UPDATE CASCADE is only needed if for instance you want to re-organize your user_idnr values. I needed that when I migrated my main dbmail installations to LDAP with existing UID values. The longtext to longblob change in the mysql tables reflect the need to store messages as-is: without the tables being sensitive to character encodings and such. Longblobs are binary fields, longtexts are character fields. So, if you want to play safe: update that field. ALTER TABLE dbmail_messageblks CHANGE messageblk messageblk longblob not null; should do the trick. But it may run a long time and eat your disks if you have a lot of mail. > > best regards > > Simon > > > >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens >>Sent: Thursday, January 26, 2006 2:10 PM >>To: DBMail mailinglist >>Subject: Re: [Dbmail] announce: dbmail-2.0.8 >> >>There are *no* changes in the database at all! The changes in >>the create files are not required for continued operation on >>existing installs. >> >> >> >>Simon Lange wrote: >> >>>Hi, >>> >>>before i start updating some questions: >>>(1) are there statements included to alter the mysql database >>>(tablechange,...) >>>(2) what happens to existing mails and accounts? (e.g. text became >>>blob) >>>(3) are there any 2.0.7 -> 2.0.8 scripts or does dbmail 2.0.8 >>>automaticly upgrade existent data to 2.0.8 (database consistency) >>> >>>regards >>> >>>Simon >>> >>> >>> >>>>-----Original Message----- >>>>From: [EMAIL PROTECTED] >>>>[mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens >>>>Sent: Wednesday, January 25, 2006 4:55 PM >>>>To: DBMail mailinglist >>>>Subject: [Dbmail] announce: dbmail-2.0.8 >>>> >>> >>>Dbmail 2.0.8 released >>> >>>This is mostly a bugfix release with some minor additional features. >>> >>> * added ON UPDATE CASCADE to create_table files >>> * do not close database connection on startup (closes: #271) >>> * change dbmail_messageblks.messageblk from longtext to >> >>longblob >> >>>in >>> >>> mysql create scripts >>> * fix incorrect quoting in quoted_string_out (closes: #204) >>> * added CHILDREN capability >>> * enable QUOTA in CAPABILITY >>> >>>-- >>> ________________________________________________________________ >>> Paul Stevens paul at nfg.nl >>> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 >>> The Netherlands________________________________http://www.nfg.nl >> >>_______________________________________________ >>Dbmail mailing list >>[email protected] >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> >>>_______________________________________________ >>>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 >>_______________________________________________ >>Dbmail mailing list >>[email protected] >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > > _______________________________________________ > 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
