sqlite.initial.sql - not complete database structure

[Former user]

In sqlite.initial.sql are missing columns (smtp_auth and *_mbox’s) and effect is that plugin not saving enabled function at settings, so it didn’t work. For me i’ve copied missing fragments from other sql initial files and it works.

[Boris Gulay]

Hello. Thanx for reporting. Can you share your initial.sql with modifications?

[Former user]

‌

CREATE TABLE ident_switch
(
    id
        integer
        PRIMARY KEY,
    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,
    username
        varchar(64),
    password
        varchar(64),
    imap_host
        varchar(64),
    imap_port
        integer
        CHECK(imap_port > 0 AND imap_port <= 65535),
    imap_delimiter
        char(1),
    label
        varchar(32),
    flags
        integer
        NOT NULL
        DEFAULT(0),
  smtp_host
    varchar(64),
  smtp_port
    integer
    CHECK(smtp_port > 0 AND smtp_port <= 65535),
`smtp_auth`
        smallint
        NOT NULL
        DEFAULT 1,
`drafts_mbox`
        varchar(64),
    `sent_mbox`
        varchar(64),
    `junk_mbox`
        varchar(64),
    `trash_mbox`
        varchar(64),
    UNIQUE (user_id, label)
);
CREATE INDEX IX_ident_switch_user_id ON ident_switch(user_id);
CREATE INDEX IX_ident_switch_iid on ident_switch(iid);

‌

[Boris Gulay]

Fix SQlite scripts. Thanx to T S. Closes #76

→ <<cset 7795a0fbf98e>>