37 lines
1.0 KiB
SQL
37 lines
1.0 KiB
SQL
--
|
|
-- Identity switch RoundCube Bundle
|
|
--
|
|
-- @copyright (c) 2024 Forian Daeumling, Germany. All right reserved
|
|
-- @license https://github.com/toteph42/identity_switch/blob/master/LICENSE
|
|
--
|
|
-- Created with: https://sqliteonline.com/
|
|
|
|
CREATE TABLE IF NOT EXISTS `identity_switch`(
|
|
`id` INTEGER NOT NULL ,
|
|
`user_id` INTEGER NOT NULL
|
|
REFERENCES users(user_id)
|
|
ON DELETE CASCADE ON UPDATE CASCADE,
|
|
`iid` INTEGER NOT NULL
|
|
REFERENCES identities(identity_id)
|
|
ON DELETE CASCADE ON UPDATE CASCADE UNIQUE,
|
|
`label` TEXT,
|
|
`flags` INT NOT NULL DEFAULT 0,
|
|
`imap_user` TEXT,
|
|
`imap_pwd` TEXT,
|
|
`imap_host` TEXT,
|
|
`imap_port` SMALLINT DEFAULT 0,
|
|
`imap_delim` CHAR(1),
|
|
`newmail_check` SMALLINT DEFAULT 300,
|
|
`notify_timeout` SMALLINT DEFAULT 10,
|
|
`smtp_host` TEXT,
|
|
`smtp_port` SMALLINT DEFAULT 0,
|
|
`drafts` TEXT DEFAULT '',
|
|
`sent` TEXT DEFAULT '',
|
|
`junk` TEXT DEFAULT '',
|
|
`trash` TEXT DEFAULT '',
|
|
UNIQUE (user_id, label)
|
|
);
|
|
|
|
CREATE INDEX IX_identity_switch_user_id ON identity_switch(user_id);
|
|
CREATE INDEX IX_identity_switch_iid on identity_switch(iid);
|