Paul,

I was reading:

http://dbmail.org/mantis/view.php?id=563

 

should the create_tables.mysql have this field incressed to 255?

Should I alter the field size?

 

With last svn it's:

 

CREATE TABLE dbmail_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',

        PRIMARY KEY  (mailbox_idnr),

        INDEX name_index (name),

        INDEX owner_idnr_index (owner_idnr),

        UNIQUE INDEX owner_idnr_name_index (owner_idnr, name),

        FOREIGN KEY owner_idnr_fk (owner_idnr)

                REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON
UPDATE CASCADE

) ENGINE InnoDB DEFAULT CHARSET=utf8;

 

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

Reply via email to