Home
last modified time | relevance | path

Searched refs:mailbox_idnr (Results 1 – 22 of 22) sorted by relevance

/dports/mail/dbmail/dbmail-3.2.5/src/
H A Ddm_db.h198 int mailbox_is_writable(uint64_t mailbox_idnr);
422 int db_delete_mailbox(uint64_t mailbox_idnr, int only_empty,
452 /*@out@*/ uint64_t * mailbox_idnr);
498 uint64_t * mailbox_idnr);
512 uint64_t owner_idnr, uint64_t * mailbox_idnr, const char * * message);
546 uint64_t owner_idnr, /*@out@*/ uint64_t * mailbox_idnr);
568 int db_isselectable(uint64_t mailbox_idnr);
577 int db_noinferiors(uint64_t mailbox_idnr);
644 int db_setmailboxname(uint64_t mailbox_idnr, const char *name);
654 int db_subscribe(uint64_t mailbox_idnr, uint64_t user_idnr);
[all …]
H A Dexport.c76 static int mailbox_dump(uint64_t mailbox_idnr, const char *dumpfile, in mailbox_dump() argument
96 mb = dbmail_mailbox_new(pool, mailbox_idnr); in mailbox_dump()
189 uint64_t user_idnr = 0, owner_idnr = 0, mailbox_idnr = 0; in do_export() local
236 mailbox_idnr = *(uint64_t *)children->data; in do_export()
237 db_getmailboxname(mailbox_idnr, user_idnr, mailbox); in do_export()
238 if (! db_get_mailbox_owner(mailbox_idnr, &owner_idnr)) { in do_export()
256 if ((result = mailbox_dump(mailbox_idnr, dumpfile, search, delete_after_dump)) != 0) { in do_export()
261 …after_dump) db_update("UPDATE %smailboxes SET seq=seq+1 WHERE mailbox_idnr=%d",DBPFX,mailbox_idnr); in do_export()
H A Ddm_db.c1936 DBPFX, mailbox_idnr); in mailbox_delete()
1942 DBPFX, mailbox_idnr); in mailbox_empty()
2118 assert(mailbox_idnr); in db_findmailbox_owner()
2119 *mailbox_idnr = 0; in db_findmailbox_owner()
2170 *mailbox_idnr = 0; in db_findmailbox()
2308 *id = mailbox_idnr; in mailboxes_by_regex()
2517 assert(mailbox_idnr); in db_mailbox_create_with_parents()
2655 *mailbox_idnr = 0; in db_createmailbox()
2737 *mailbox_idnr = 0; in db_find_create_mailbox()
2849 DBPFX, mailbox_idnr); in db_isselectable()
[all …]
H A Ddm_quota.c140 uint64_t mailbox_idnr; in quota_get_quotaroot() local
142 if (! db_findmailbox(mailbox, useridnr, &mailbox_idnr)) { in quota_get_quotaroot()
H A Dimapcommands.c377 uint64_t mailbox_idnr = 0; in imap_session_mailbox_open() local
383 if ((! mailbox_idnr ) && (strcasecmp(mailbox, "INBOX")==0)) { in imap_session_mailbox_open()
384 int err = db_createmailbox("INBOX", self->userid, &mailbox_idnr); in imap_session_mailbox_open()
389 if (! mailbox_idnr) { in imap_session_mailbox_open()
395 self->mailbox = dbmail_mailbox_new(self->pool, mailbox_idnr); in imap_session_mailbox_open()
873 uint64_t mailbox_idnr; in _ic_delete_enter() local
886 if (! (db_findmailbox(mailbox, self->userid, &mailbox_idnr)) ) { in _ic_delete_enter()
915 result = db_isselectable(mailbox_idnr); in _ic_delete_enter()
932 if (! mailbox_is_writable(mailbox_idnr)) { in _ic_delete_enter()
963 db_mailbox_seq_update(mailbox_idnr, 0); in _ic_delete_enter()
[all …]
H A Dpop3.c104 uint64_t mailbox_idnr; in db_createsession() local
107 if (db_find_create_mailbox("INBOX", BOX_DEFAULT, user_idnr, &mailbox_idnr) < 0) { in db_createsession()
112 g_return_val_if_fail(mailbox_idnr > 0, DM_EQUERY); in db_createsession()
124 mailbox_idnr, MESSAGE_STATUS_DELETE); in db_createsession()
H A Ddm_imapsession.h99 MailboxState_T dbmail_imap_session_mbxinfo_lookup(ImapSession *self, uint64_t mailbox_idnr);
H A Ddm_user.c49 uint64_t mailbox_idnr; in do_add() local
77 if (db_createmailbox("INBOX", useridnr, &mailbox_idnr) < 0) { in do_add()
/dports/mail/dbmail/dbmail-3.2.5/test/
H A Dcheck_dbmail_db.c291 uint64_t mailbox_idnr = 0, mb1 = 0, mb2 = 0, mb3 = 0; in START_TEST() local
297 useridnr, &mailbox_idnr, &message); in START_TEST()
301 result = db_findmailbox("inbox/foo/BAR/baz", useridnr, &mailbox_idnr); in START_TEST()
303 result = db_delete_mailbox(mailbox_idnr, only_empty, update_curmail_size); in START_TEST()
306 result = db_findmailbox("InBox/Foo/bar", useridnr, &mailbox_idnr); in START_TEST()
308 result = db_delete_mailbox(mailbox_idnr, only_empty, update_curmail_size); in START_TEST()
327 result = db_findmailbox("INBOX/FOO", useridnr, &mailbox_idnr); in START_TEST()
329 result = db_delete_mailbox(mailbox_idnr, only_empty, update_curmail_size); in START_TEST()
332 result = db_findmailbox("INBox", useridnr, &mailbox_idnr); in START_TEST()
333 fail_unless(result == 1 && mailbox_idnr != 0, "Failed at db_findmailbox(\"INBox\")"); in START_TEST()
[all …]
/dports/mail/dbmail/dbmail-3.2.5/sql/oracle/
H A Ddbmail_schema.sql254 mailbox_idnr number(20) NOT NULL, field
268 CREATE UNIQUE INDEX dbmail_mailboxes_idx ON dbmail_mailboxes (mailbox_idnr) TABLESPACE DBMAIL_TS_ID…
269 ALTER TABLE dbmail_mailboxes ADD CONSTRAINT dbmail_mailboxes_pk PRIMARY KEY (mailbox_idnr) USING IN…
273 new.mailbox_idnr IS NULL OR new.mailbox_idnr = 0
277 INTO :new.mailbox_idnr
292 mailbox_idnr number(20) DEFAULT '0' NOT NULL, field
308 new.message_idnr IS NULL OR new.mailbox_idnr = 0
318 CREATE INDEX dbmail_messages_mbox_idnr_idx ON dbmail_messages (mailbox_idnr) TABLESPACE DBMAIL_TS_I…
322 CREATE INDEX dbmail_messages_mbox_stat_idx ON dbmail_messages (mailbox_idnr, status) TABLESPACE DBM…
551 … ADD CONSTRAINT dbmail_messages_fk2 FOREIGN KEY (mailbox_idnr) REFERENCES dbmail_mailboxes (mailbo…
[all …]
/dports/mail/dbmail/dbmail-3.2.5/sql/sqlite/
H A Dcreate_tables.sqlite61 mailbox_idnr INTEGER PRIMARY KEY,
150 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_id) IS NULL)
159 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_id) IS NULL)
166 UPDATE dbmail_subscription SET mailbox_id = new.mailbox_idnr WHERE mailbox_id = OLD.mailbox_idnr;
228 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_id) IS NULL)
237 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_id) IS NULL)
244 UPDATE dbmail_acl SET mailbox_id = new.mailbox_idnr WHERE mailbox_id = OLD.mailbox_idnr;
318 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_idnr) IS NULL)
327 AND ((SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = new.mailbox_idnr) IS NULL)
334 UPDATE dbmail_messages SET mailbox_idnr = new.mailbox_idnr WHERE mailbox_idnr = OLD.mailbox_idnr;
[all …]
/dports/mail/dbmail/dbmail-3.2.5/sql/mysql/
H A Dmigrate_from_1.x_to_2.0_innodb.mysql70 REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE CASCADE ON UPDATE CASCADE
75 SELECT owner_idnr, mailbox_idnr FROM dbmail_mailboxes
101 REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE CASCADE ON UPDATE CASCADE
132 ADD INDEX mailbox_idnr_index (mailbox_idnr),
136 ADD FOREIGN KEY mailbox_idnr_fk (mailbox_idnr)
137 REFERENCES dbmail_mailboxes (mailbox_idnr)
226 AND b.mailbox_idnr = m.mailbox_idnr
H A Dcreate_tables.mysql72 …cl_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CAS…
191 `mailbox_idnr` bigint(20) UNSIGNED NOT NULL auto_increment,
204 PRIMARY KEY (`mailbox_idnr`),
219 `mailbox_idnr` bigint(20) UNSIGNED NOT NULL default '0',
231 KEY `mailbox_idnr_index` (`mailbox_idnr`),
235 KEY `mailbox_status` (`mailbox_idnr`,`status`),
237 …STRAINT `dbmail_messages_ibfk_2` FOREIGN KEY (`mailbox_idnr`) REFERENCES `dbmail_mailboxes` (`mail…
355 …on_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CAS…
H A Dfix_foreign_keys.mysql58 …FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPD…
69 …FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPD…
80 …FOREIGN KEY (`mailbox_idnr`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON U…
H A D2_2-3_0.mysql197 MODIFY COLUMN mailbox_idnr BIGINT(20) UNSIGNED AUTO_INCREMENT NOT NULL,
205 MODIFY COLUMN `mailbox_idnr` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0';
253 …cl_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CAS…
281 …STRAINT `dbmail_messages_ibfk_2` FOREIGN KEY (`mailbox_idnr`) REFERENCES `dbmail_mailboxes` (`mail…
295 …on_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CAS…
H A D2_3_5-2_3_6.mysql43 ALTER TABLE dbmail_mailboxes MODIFY COLUMN mailbox_idnr BIGINT(20) AUTO_INCREMENT NOT NULL;
47 ALTER TABLE dbmail_messages MODIFY COLUMN mailbox_idnr BIGINT(20) DEFAULT 0 NOT NULL;
/dports/mail/dbmail/dbmail-3.2.5/sql/postgresql/
H A Dmigrate_from_1.x_to_2.0.pgsql83 ALTER TABLE dbmail_mailboxes ALTER COLUMN mailbox_idnr
93 mailbox_id INT8 REFERENCES dbmail_mailboxes(mailbox_idnr) ON DELETE CASCADE ON UPDATE CASCADE,
100 SELECT owner_idnr, mailbox_idnr FROM dbmail_mailboxes
110 mailbox_id INT8 REFERENCES dbmail_mailboxes (mailbox_idnr)
164 CREATE INDEX dbmail_messages_mailbox_idx ON dbmail_messages(mailbox_idnr);
236 AND msg.mailbox_idnr = mbx.mailbox_idnr
H A Dcreate_tables.pgsql83 mailbox_idnr INT8 DEFAULT nextval('dbmail_mailbox_idnr_seq'),
96 PRIMARY KEY (mailbox_idnr)
106 mailbox_id INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
113 mailbox_id INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
141 mailbox_idnr INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
155 CREATE INDEX dbmail_messages_1 ON dbmail_messages(mailbox_idnr);
161 CREATE INDEX dbmail_messages_7 ON dbmail_messages(mailbox_idnr,status,seen_flag);
162 CREATE INDEX dbmail_messages_8 ON dbmail_messages(mailbox_idnr,status,recent_flag);
/dports/mail/dbmail/dbmail-3.2.5/contrib/
H A Dexpiretrash.sh66 SELECT mailbox_idnr FROM dbmail_mailboxes b
83 WHERE m.mailbox_idnr IN ($ids)
/dports/mail/dbmail/dbmail-3.2.5/contrib/autosubscribe/
H A Dautosubscribe.sql14 select u.user_idnr,b.mailbox_idnr from dbmail_mailboxes b
/dports/mail/dbmail/dbmail-3.2.5/contrib/sql2sql/
H A Dmysql2pgsql.sh77 SELECT setval('dbmail_mailbox_idnr_seq', max(mailbox_idnr)+1) FROM dbmail_mailboxes;
/dports/mail/dbmail/dbmail-3.2.5/src/modules/
H A Dauthldap.c1252 uint64_t mailbox_idnr; in auth_validate() local
1314 db_find_create_mailbox("INBOX", BOX_DEFAULT, *user_idnr, &mailbox_idnr); in auth_validate()