diff options
Diffstat (limited to 'extras/tables/table-sqlite/table-sqlite.5')
-rw-r--r-- | extras/tables/table-sqlite/table-sqlite.5 | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/extras/tables/table-sqlite/table-sqlite.5 b/extras/tables/table-sqlite/table-sqlite.5 index 69dc3c8..d0963a6 100644 --- a/extras/tables/table-sqlite/table-sqlite.5 +++ b/extras/tables/table-sqlite/table-sqlite.5 @@ -136,21 +136,21 @@ CREATE TABLE domains ( id INTEGER PRIMARY KEY AUTOINCREMENT, domain VARCHAR(255) NOT NULL ); -insert into domains values (1, "example.com"); -insert into domains values (2, "example.net"); -insert into domains values (3, "example.org"); - -insert into virtuals values (1, "abuse@example.com", "bob@example.com"); -insert into virtuals values (2, "postmaster@example.com", "bob@example.com"); -insert into virtuals values (3, "webmaster@example.com", "bob@example.com"); -insert into virtuals values (4, "bob@example.com", "vmail"); -insert into virtuals values (5, "abuse@example.net", "alice@example.net"); -insert into virtuals values (6, "postmaster@example.net", "alice@example.net"); -insert into virtuals values (7, "webmaster@example.net", "alice@example.net"); -insert into virtuals values (8, "alice@example.net", "vmail"); - -insert into credentials values (1, "bob@example.com", "$2b$08$ANGFKBL.BnDLL0bUl7I6aumTCLRJSQluSQLuueWRG.xceworWrUIu"); -insert into credentials values (2, "alice@example.net", "$2b$08$AkHdB37kaj2NEoTcISHSYOCEBA5vyW1RcD8H1HG.XX0P/G1KIYwii"); +INSERT INTO domains VALUES (1, "example.com"); +INSERT INTO domains VALUES (2, "example.net"); +INSERT INTO domains VALUES (3, "example.org"); + +INSERT INTO virtuals VALUES (1, "abuse@example.com", "bob@example.com"); +INSERT INTO virtuals VALUES (2, "postmaster@example.com", "bob@example.com"); +INSERT INTO virtuals VALUES (3, "webmaster@example.com", "bob@example.com"); +INSERT INTO virtuals VALUES (4, "bob@example.com", "vmail"); +INSERT INTO virtuals VALUES (5, "abuse@example.net", "alice@example.net"); +INSERT INTO virtuals VALUES (6, "postmaster@example.net", "alice@example.net"); +INSERT INTO virtuals VALUES (7, "webmaster@example.net", "alice@example.net"); +INSERT INTO virtuals VALUES (8, "alice@example.net", "vmail"); + +INSERT INTO credentials VALUES (1, "bob@example.com", "$2b$08$ANGFKBL.BnDLL0bUl7I6aumTCLRJSQluSQLuueWRG.xceworWrUIu"); +INSERT INTO credentials VALUES (2, "alice@example.net", "$2b$08$AkHdB37kaj2NEoTcISHSYOCEBA5vyW1RcD8H1HG.XX0P/G1KIYwii"); .Ed .Ic Pa /etc/mail/sqlite.conf |