Am 21.06.2014 19:44, schrieb Jorge Bastos: > I’d like to make a separate backup for the IMAP flags somewhile, to when I > want restore them for just one user. > > Thing is, for the 2nd time this year, I just hit the wrong option on K9 (mark > all read), and bummm! All my marked > as unread emails in INBOX were gone, there it goes my pending matters. > > K9 is great, but this option should have a confirm!!! > > Which table holds this? The rest I’ll look at it, the user idnr’s etc.
MariaDB [dbmail]> show fields from dbmail_messages; +----------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+----------------+ | message_idnr | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | mailbox_idnr | bigint(20) unsigned | NO | MUL | 0 | | | physmessage_id | bigint(20) unsigned | NO | MUL | 0 | | | seen_flag | tinyint(1) | NO | MUL | 0 | | | answered_flag | tinyint(1) | NO | | 0 | | | deleted_flag | tinyint(1) | NO | MUL | 0 | | | flagged_flag | tinyint(1) | NO | | 0 | | | recent_flag | tinyint(1) | NO | | 0 | | | draft_flag | tinyint(1) | NO | | 0 | | | unique_id | varchar(70) | NO | MUL | | | | status | tinyint(3) unsigned | NO | MUL | 0 | | +----------------+---------------------+------+-----+---------+----------------+
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
