sqlite.initial.sql - not complete database structure
Issue #76
closed
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.
Comments (3)
-
repo owner -
Account Deleted reporter
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);
-
repo owner - changed status to closed
Fix SQlite scripts. Thanx to T S. Closes
#76→ <<cset 7795a0fbf98e>>
- Log in to comment
Hello. Thanx for reporting. Can you share your initial.sql with modifications?