Bret,
Looks to me like the default width for unsigned tinyint is indeed 3. I'll fix the create_tables.mysql file. Bret Baptist wrote: > On Friday 14 March 2008 5:11:09 pm Paul J Stevens wrote: >> Bret, >> >> >> I don't have any problems with such a change. Sensible cleanups in the >> schema are always welcome. Especially ones that are backward compatible. >> > > That would be great. > >> But: how does RoR treat tinyints without a width specification? I'd >> rather simply remove all width specifications on the numeric types from >> the mysql schema (and add the UNSIGNED attribute where possible) since >> we don't use, need or rely on them at all. >> > > The only assumption that RoR makes is for a tinyint. it assumes a tinyint(1) > is boolean, any other tinyint, for example, the status column in > dbmail_messages is a tinyint(3), it handles it normally. So if we changed > the permissions column to be a tinyint(3), which is the default, it would be > workable with RoR. > > > Thanks again. > > Bret. > > >> Bret Baptist wrote: >>> We are writing a dbmail administration interface with Ruby on Rails for >>> the latest dbmail 2.2.9. We are having an issue with the permission >>> column in dbmail_mailboxes being set to a tinyint(1) in MySQL. Ruby on >>> Rails assumes that a tinyint(1) in MySQL is a boolean, however dbmail >>> stores values greater than 1 in that column. If we change the column to >>> be tinyint(2) then Ruby on Rail has no issues. >>> >>> Interestingly there is another column in the dbmail database that stores >>> a similar value and is a tinyint(3). This is the status column in the >>> dbmail_messages table. >>> >>> What I am wondering is if this change can be made upstream with you guys >>> or if we are going to have to maintain the change on our end. >>> >>> I would understand completely if you did not want to make this change, I >>> just think it might be easier for anyone who might want to manipulate the >>> dbmail database with Ruby on Rails. >>> >>> >>> Thank you very much for your help. > > > -- ________________________________________________________________ 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
