mirror of
https://bitbucket.org/jsuto/piler.git
synced 2024-11-07 19:51:59 +01:00
15 lines
1.1 KiB
SQL
15 lines
1.1 KiB
SQL
use piler;
|
|
|
|
insert into domain (domain, mapped) values("fictive.com","fictive.com"),("address.com","address.com"),("acts.hu","acts.hu"),("gtsce.com","gtsce.com"),("datanet.hu","datanet.hu"),("gtsdatanet.hu","gtsdatanet.hu"),("gts.hu","gts.hu"),("aaa.fu","aaa.fu");
|
|
|
|
insert into archiving_rule (subject) values ("Android táblagép");
|
|
insert into archiving_rule (`from`) values ("@gmail.com");
|
|
insert into archiving_rule (`from`,attachment_type, _attachment_size, attachment_size) values ("finderis.co.ua", "image", ">", 100000);
|
|
insert into archiving_rule (`to`) values ("undisclosed-recipients");
|
|
insert into import (`type`, username, password, server) values ("imap-ssl", "sanyi@aaa.fu", "abcde123", "imap.aaa.fu");
|
|
|
|
update user set password="$6$GKL00T$8jqoFOe3PyAbOCLwKB7JwndwC.IinHrZRkdoQDZUc8vybZ88sA2qomlz5JceNif8fFpkGzZ03ilvQa7tqQx0v1";
|
|
|
|
insert into user (uid, username, realname, password, domain, dn, isadmin) values(2, "dataofficer", "Data officer", "$6$rX285LfP$ZxhlacbzKuCcqkaizzBu8SAiYb6.f8K4Us08nUHwSpWMQkNhw4o2rmfKXoTfaM4rnBHUYVK1N4IfBsqN8CAtS/", "local", "*", 4);
|
|
insert into email (uid, email) values(2, "do@local");
|