INSERT INTO "public"."filechunk" VALUES
('5VXHZhGz7UQ-x7rN8GNmhFP-bneB7vgdkEo-gEcwXC9XBPJ', 3, 810, X'96a2be0824dc7efc57c26948604cce7a3126227a8b43e51899423ec6a0c59df89929f536daf59886bee17c3526d0aeda505f5d6c0c2f5fb9601c87a8164b4f7d438d94ed76b946a514c53f0bf183939af568fe40bedae89dbdc64dc38f524939b53c5facc5dcdbf169cd2b6bc56a096ccdc51d0b8ae57c6d2c6651fc5d4839cef5356e8fb8a537e19b3cbc3806d7e8cdd75b88c6583f63c4d3667d6667dc918a3b962e68cdde1287356e87f8fbf25a3458dcd41753b7b82969c7d8e396b680fd5314a6241dc913bb260dff0cdc764d834ad2b86df399c86fdd6cc719b8f63562b91a8a950bdf9b23adb9a95ef1a8ed3746b5fe4a3d5a566dc4fad3929f1e971b4df8dceba6b6acd03163d5a8165b9372d470fbc25cce4c8cdcccd8c8e147a33eb325d8051199a876e45ab775cb7241f81bc3f586f3d7f6f4ba696d8de3831baeeb5f415d395ae92e8e44652843be44e03bb4e0b46b793d36f45356ac7593adcd8cdb9cdfebb6b76de37030bcafd7ed50509d5c9c2f342ab5b1f9b5a118e1ed7ad7e537e667c6eb1e9ad9a2663cf1a4029e5d389cafc99216ae7553d8124b670b8778be369bd49bef8f4ad2b532eeaae66b8d62be241c5d9e6fc0f635dc2eadd99a8d6269666cd8a24d33c7bb8eec75dbd92756a0b33a0e6b9ba71995f1e6ada539997dbc71dab805995f28346bf9c2983c35deb71335ba67a81c5b98f1c9d1bdaad76dcbeef60e6309d404b48f989668aa25f0f8ac3b8f2682bd20a6e140acd9edcfeef48cfeb6c56f85ee5511200a9bd3e289b771f73ce15a7f4fc57ff17fbc79e79df6c3a36f9f76ba7be6dff890e4efa8b38efa2783c6c78d8ff50132feff00dabd7600f39eb00fc4bf773df4915f3e7fe10c03c96b075a1dff8b63915843967ce8d47d363e7ac7db92b0c24f1e6a0d8a838c9d20265d10932e1193ae71922d1efafafa728fbfb5effcd8690c22b4e875992ae9b95200ba860b4eac1f383ea9b07ff9bf4534b38c7f49b4f82f4cc0fd9f8816ff4dfe5744f3c649d74634e07ffc3fa113dad798e5da8623d69e583dbdf71527b5fe336bc611271d70c67ef35e74e2f43de7ed3f6f2d7e1f889f5df2f5f439afd87fdedef3ce88819cd105d0ff03cc6a9700c2080100'),
('39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', 0, 4096, X'[encoded data, 8192 characters]');               
INSERT INTO "public"."filechunk" VALUES
('39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', 1, 4096, X'[encoded data, 8192 characters]');     
INSERT INTO "public"."filechunk" VALUES
('39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', 2, 4096, X'[encoded data, 8192 characters]');     
INSERT INTO "public"."filechunk" VALUES
('39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', 3, 808, X'5f04126e3ffe2be13424302667bd181311bdc5a1728c4c211f63d0e24efccc947a1bed7a4c43df70be1a1368576da8af2e368697af5c308e43548ba5a7bea146ca76bb5ca3528ae29f85f8c149cd7a347f205f6df4ce5ee3a6e147a9a49c5a9e2fd662eeedf8b4e695b562b504b6e6e28e05c572be3616b328fe2ea41ce7fa1ab747dcd29bf04d1e5e1c836bf4e6eb2d4463ac9f31e269b33eb333ee48c51d4b17b4666f89c31ab743fc7d792d1a2c6eea8ba95bdc94b463ec714b5bc0fe290a53928ee4895d93867f066ebba6412569dcb6f94ce4b76eb6e30c5cfb1ab15c0dc5ca85efcd91d6dc54af78d4f61ba35a7fa51e2dab3662fd69c94f8fcb8d267cee75535b56e898b16a548bad49396ab87d612e6726466e666ce4f0a3519fd912ec82884c543b72addbba65b920fc8de17ac3f96b7b7addb4b6c6f1c10dd7f5afa0ae1cad741747a23294215f22f01d5a70dab5bc1e1bfa292bd6bac9d666c66dceef75dbdbb6713818ded7eb7628a84e2ece171a95dad8fcda508cf076bdebf21bf333e3750fcd6c51339e785201cf2e1cced764490bd7ba296c89a5b385433c5f9b4deacdf74725e95a197755f3b546315f128e2ecf3760fb1a6e97d66ccd46b13433366cd1a699e35d47f6baedec132bd0591d87b5cdd38cca78f3d6d29ccc3ede386ddc82cc2f149ab57c614c9e1aefdb891add33548e2dccf8e4e85ed5ebb665777b87b1046a02da474c4b34d512787cd69d4713c15e10d37020d6ecf667777a467fdbe2b742f7aa081085cd69f1c4dbb87b9e70adbfa7e2bff83fdebcf34efbe1d1b74f3bdd3df36f7c48f277d45947fd9341e3e3c6c7fa0019ff7f00ed5e3b80794fd807e2dfbb1efac82f9fbf708681e4b503ad8effc5b148ac214b3e74ea3e1b1fbde36d4958e1270fb506c541c64e10932e8849978849d738c9160f7d7d7db9c7dfda777eec3406115af4ba4c95f45c29005dc30527d60f1c9f54d8bffcdf229a59c6bf245afc1726e0fe4f448bff26ff2ba279e3a46b231af03ffe9fd009ed6bcc726dc3116b4fac9edefb8a935aff9935e388930e3863bf792f3a71fa9ef3f69fb716bf0fc4cf2ef97afa9c57ec3f6fef7967c440cee802e8ff0186762a23c2080100'),
('DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', 0, 4096, X'[encoded data, 8192 characters]');   
INSERT INTO "public"."filechunk" VALUES
('DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', 1, 4096, X'[encoded data, 8192 characters]');     
INSERT INTO "public"."filechunk" VALUES
('DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', 2, 4096, X'[encoded data, 8192 characters]');     
INSERT INTO "public"."filechunk" VALUES
('DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', 3, 446, X'b0b0293c68be7ed0ed59549b5c5128b66a8dc9258dd184e0dd3b9f354fc63d3aafc3cda4e36945bcbb6cacd090212ddbe26610b2b4f3578567ac4bfaebf2498385e158fe5af08ca1e451bdd068950b1591e8da420bbeafe5f6351f514f1c5bbc73ded4a39306ddeef68df578589fc235f35f9cca14785701a7bd4f01674f799025c562bb51284eca5b53cff6a6450f8c56130f33d5391e9f36e876e3e3ee07c613a80be86e313bb554cbe0a95ef79948157b69c2c35262d9ddefeefdace75d83df058f37c6c02862ceca4c3cd37deca9a9f9fd99e41fe6fbc5979ff7e353ee9b7dbe7bf6bfa926e9bf932f3ef9df349a6a37d5d69f0a214a807bdd08163f655f48eef73beef15f3f77d95c83c9e34fb4a94ffd938fb80facfae0b987ee78e2feb7a461859fbed4699404197bf353f4a2267d532c5b31facd6dd5017f57dff9c9a43182d062d0e5eae4e79020742d179cd93c6aaa5311ff9aff15d3cc30fe23d3927f618aee7fc4b4e4dff4ffc4346f8a755d4c03fd9bfe0d9f003fc30cd7024edc7266fdfcc10bcfeafc6ffedc13cf3af282c317bfe0cc39072d3e62f116dc1f85db3ef979fec20b8f587cc8e20b122417f401f5ff016469b277dae20000');
CREATE CACHED TABLE "public"."invitation"(
    "id" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL
); 
ALTER TABLE "public"."invitation" ADD CONSTRAINT "public"."CONSTRAINT_4" PRIMARY KEY("id");    
-- 0 +/- SELECT COUNT(*) FROM public.invitation;               
CREATE CACHED TABLE "public"."tagsource"(
    "id" VARCHAR(254) NOT NULL,
    "source_id" VARCHAR(254) NOT NULL,
    "tag_id" VARCHAR(254) NOT NULL
);         
ALTER TABLE "public"."tagsource" ADD CONSTRAINT "public"."CONSTRAINT_9E" PRIMARY KEY("id");    
-- 0 +/- SELECT COUNT(*) FROM public.tagsource;
CREATE CACHED TABLE "public"."node"(
    "id" VARCHAR(254) NOT NULL,
    "type" VARCHAR(254) NOT NULL,
    "url" VARCHAR(254) NOT NULL,
    "updated" TIMESTAMP NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "not_found" INT DEFAULT 0 NOT NULL
);          
-- 2 +/- SELECT COUNT(*) FROM public.node;     
INSERT INTO "public"."node" VALUES
('rest1', 'restserver', 'http://localhost:7020', TIMESTAMP '2021-07-13 21:06:44.235033', TIMESTAMP '2021-01-03 20:49:33.047', 0),
('joex1', 'joex', 'http://localhost:7021', TIMESTAMP '2021-07-13 21:06:03.808725', TIMESTAMP '2021-01-03 20:49:34.078', 0);               
CREATE CACHED TABLE "public"."source"(
    "sid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "abbrev" VARCHAR(254) NOT NULL,
    "description" TEXT,
    "counter" INT NOT NULL,
    "enabled" BOOLEAN NOT NULL,
    "priority" INT NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "folder_id" VARCHAR(254),
    "file_filter" VARCHAR(254),
    "doc_lang" VARCHAR(254)
);   
ALTER TABLE "public"."source" ADD CONSTRAINT "public"."CONSTRAINT_C" PRIMARY KEY("sid");       
-- 1 +/- SELECT COUNT(*) FROM public.source;   
INSERT INTO "public"."source" VALUES
('FcVZWHAgfFD-MdYCm3qWTyX-a7hcbVhsgKG-FG9DwArw9eQ', 'demo', 'test', NULL, 0, TRUE, 0, TIMESTAMP '2021-01-03 21:35:32.86', NULL, NULL, NULL);              
CREATE CACHED TABLE "public"."folder"(
    "id" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "owner" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL
);               
ALTER TABLE "public"."folder" ADD CONSTRAINT "public"."CONSTRAINT_B4" PRIMARY KEY("id");       
-- 0 +/- SELECT COUNT(*) FROM public.folder;   
CREATE CACHED TABLE "public"."rememberme"(
    "id" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "login" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "uses" INT NOT NULL
);    
ALTER TABLE "public"."rememberme" ADD CONSTRAINT "public"."CONSTRAINT_20" PRIMARY KEY("id");   
-- 0 +/- SELECT COUNT(*) FROM public.rememberme;               
CREATE CACHED TABLE "public"."contact"(
    "contactid" VARCHAR(254) NOT NULL,
    "value" VARCHAR(254) NOT NULL,
    "kind" VARCHAR(254) NOT NULL,
    "pid" VARCHAR(254),
    "oid" VARCHAR(254),
    "created" TIMESTAMP NOT NULL
);        
ALTER TABLE "public"."contact" ADD CONSTRAINT "public"."CONSTRAINT_3" PRIMARY KEY("contactid");
-- 0 +/- SELECT COUNT(*) FROM public.contact;  
CREATE CACHED TABLE "public"."organization"(
    "oid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "street" VARCHAR(254),
    "zip" VARCHAR(254),
    "city" VARCHAR(254),
    "country" VARCHAR(254),
    "notes" TEXT,
    "created" TIMESTAMP NOT NULL,
    "updated" TIMESTAMP NOT NULL,
    "short_name" VARCHAR(254),
    "org_use" VARCHAR(254) NOT NULL
);           
ALTER TABLE "public"."organization" ADD CONSTRAINT "public"."CONSTRAINT_46" PRIMARY KEY("oid");
-- 3 +/- SELECT COUNT(*) FROM public.organization;             
INSERT INTO "public"."organization" VALUES
('26faGiJeaS3-xvguNWcyF7H-9SuwXAMoNDj-Aoiiei4yCdV', 'demo', 'Acme AG', '', '', '', '', NULL, TIMESTAMP '2021-01-03 21:32:55.992', TIMESTAMP '2021-01-03 21:32:55.992', NULL, 'correspondent'),
('85CGijc6q6q-Vj1dZXCPGcK-rpDK7MKVrRz-xyNsSbEbuJy', 'demo', 'Pancake Company', '', '', '', '', NULL, TIMESTAMP '2021-01-03 21:33:01.966', TIMESTAMP '2021-01-03 21:33:01.966', NULL, 'correspondent'),
('Gu3ufBQNyco-TqVjyREXNpJ-f4j9VCdyYoR-TNgUkiQXR1Y', 'demo', 'Sliced Invoices', '', '', '', '', NULL, TIMESTAMP '2021-01-03 21:34:29.153', TIMESTAMP '2021-01-03 21:34:29.153', NULL, 'correspondent');        
CREATE CACHED TABLE "public"."attachment"(
    "attachid" VARCHAR(254) NOT NULL,
    "itemid" VARCHAR(254) NOT NULL,
    "filemetaid" VARCHAR(254) NOT NULL,
    "position" INT NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "name" VARCHAR(254)
);         
ALTER TABLE "public"."attachment" ADD CONSTRAINT "public"."CONSTRAINT_8" PRIMARY KEY("attachid");              
-- 2 +/- SELECT COUNT(*) FROM public.attachment;               
INSERT INTO "public"."attachment" VALUES
('2ecoA7A7HgT-xPwzNQYfiZd-rF1XF3aEPMr-qsNJXoe36oZ', 'J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', '8jre1Sk2anC-XycazyE1d9M-UUjNsj1LsLu-zmZfiPwKB6J', 0, TIMESTAMP '2021-01-03 21:13:33.416', 'wordpress-pdf-invoice-plugin-sample.converted.pdf'),
('4SDQngEFYuK-tb9xAachZSt-LNCrE36NFRr-U8avxFCW9A4', '2wKtSUVt3Kj-mAmexmm1jFe-BU6aY6PN4vo-5cpaDD2EyRm', 'BQR2G7GT5LQ-FKV4FQ1hnDu-9TSkF7nhUyz-nmpe9qDVvBd', 0, TIMESTAMP '2021-01-03 21:34:43.9', 'letter-en.converted.pdf');   
CREATE CACHED TABLE "public"."equipment"(
    "eid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "updated" TIMESTAMP NOT NULL,
    "notes" TEXT,
    "equip_use" VARCHAR(254) NOT NULL
);   
ALTER TABLE "public"."equipment" ADD CONSTRAINT "public"."CONSTRAINT_40" PRIMARY KEY("eid");   
-- 0 +/- SELECT COUNT(*) FROM public.equipment;
CREATE CACHED TABLE "public"."tag"(
    "tid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "category" VARCHAR(254),
    "created" TIMESTAMP NOT NULL
);       
ALTER TABLE "public"."tag" ADD CONSTRAINT "public"."CONSTRAINT_1B" PRIMARY KEY("tid");         
-- 5 +/- SELECT COUNT(*) FROM public.tag;      
INSERT INTO "public"."tag" VALUES
('3i1wmHS7P67-6Mo6vyJwUVh-FyW44prsFKd-BwQfTNRLE4T', 'demo', 'Invoice', 'doctype', TIMESTAMP '2021-01-03 21:32:21.579'),
('GuSMRKP4pp1-3Hdf51jRyjE-X2TGk6GXQdX-y2azLVn47Mt', 'demo', 'Contract', 'doctype', TIMESTAMP '2021-01-03 21:32:28.045'),
('AYmkK5Y5mvF-xBh4gGkA3z9-HWHxM2cs4v6-r5Wcqw9vEpY', 'demo', 'Invitation', 'doctype', TIMESTAMP '2021-01-03 21:32:33.951'),
('4ugueUtfP1p-oqrtQDHmY6V-Yd9PEvhr1Zz-X9aurGADsgK', 'demo', 'Notice', 'doctype', TIMESTAMP '2021-01-03 21:32:41.632'),
('EMp5ZCBvt6X-jx579vGQa7Y-VpWD1zqFTnZ-XSU1r9bEn9j', 'demo', 'Todo', 'state', TIMESTAMP '2021-01-03 21:32:50.08');         
CREATE CACHED TABLE "public"."tagitem"(
    "tagitemid" VARCHAR(254) NOT NULL,
    "itemid" VARCHAR(254) NOT NULL,
    "tid" VARCHAR(254) NOT NULL
);          
ALTER TABLE "public"."tagitem" ADD CONSTRAINT "public"."CONSTRAINT_A" PRIMARY KEY("tagitemid");
-- 3 +/- SELECT COUNT(*) FROM public.tagitem;  
INSERT INTO "public"."tagitem" VALUES
('8Fj7BqidsiR-sSXbCBV77jn-yE2zrPLuTHo-QcKzfeP9vug', 'J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', '3i1wmHS7P67-6Mo6vyJwUVh-FyW44prsFKd-BwQfTNRLE4T'),
('ATAxJL8LASW-be9FMJabPbX-KBpHqAk5asG-KHxJMk1A7aw', '2wKtSUVt3Kj-mAmexmm1jFe-BU6aY6PN4vo-5cpaDD2EyRm', 'AYmkK5Y5mvF-xBh4gGkA3z9-HWHxM2cs4v6-r5Wcqw9vEpY'),
('6W1PtieE38Y-oLfG17gPirm-5sa9xjykAQ3-tqYH69ipDRy', 'J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', 'EMp5ZCBvt6X-jx579vGQa7Y-VpWD1zqFTnZ-XSU1r9bEn9j');         
CREATE CACHED TABLE "public"."job"(
    "jid" VARCHAR(254) NOT NULL,
    "task" VARCHAR(254) NOT NULL,
    "group_" VARCHAR(254) NOT NULL,
    "args" TEXT NOT NULL,
    "subject" VARCHAR(254) NOT NULL,
    "submitted" TIMESTAMP NOT NULL,
    "submitter" VARCHAR(254) NOT NULL,
    "priority" INT NOT NULL,
    "state" VARCHAR(254) NOT NULL,
    "retries" INT NOT NULL,
    "progress" INT NOT NULL,
    "tracker" VARCHAR(254),
    "worker" VARCHAR(254),
    "started" TIMESTAMP,
    "finished" TIMESTAMP,
    "startedmillis" BIGINT
);          
ALTER TABLE "public"."job" ADD CONSTRAINT "public"."CONSTRAINT_19" PRIMARY KEY("jid");         
-- 17 +/- SELECT COUNT(*) FROM public.job;     
INSERT INTO "public"."job" VALUES
('8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'full-text-index', 'docspell-system', '{}', 'Create full-text index', TIMESTAMP '2021-05-29 14:03:05.491834', 'docspell-system', 0, 'success', 0, 0, 'full-text-index-tracker', 'joex1', TIMESTAMP '2021-05-29 14:03:06.604782', TIMESTAMP '2021-05-29 14:03:07.935838', 1622296986604),
('BqaFbmUNoTN-ybAaGPapjJW-zeWeaY54vAg-wpGshXZePpS', 'all-previews', 'docspell-system', '{"collective":null,"storeMode":"whenmissing"}', 'Create preview images', TIMESTAMP '2021-05-29 14:03:05.746322', 'docspell-system', 0, 'success', 0, 0, 'generate-all-previews', 'joex1', TIMESTAMP '2021-05-29 14:03:11.175431', TIMESTAMP '2021-05-29 14:03:11.283971', 1622296991175),
('2uwdfbwzmRQ-WucC5TZTrjG-so5aYxBbFnf-QepabswWCSV', 'all-page-count', 'docspell-system', '{}', 'Create all page-counts', TIMESTAMP '2021-05-29 14:03:05.792122', 'docspell-system', 0, 'success', 0, 0, 'all-page-count-tracker', 'joex1', TIMESTAMP '2021-05-29 14:03:11.349151', TIMESTAMP '2021-05-29 14:03:11.451626', 1622296991349),
('FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'learn-classifier', 'demo', '{"collective":"demo"}', 'learn-classifier: learn-classifier', TIMESTAMP '2021-05-29 14:03:06.326757', 'learn-classifier', 0, 'success', 0, 0, 'CdqeBRkD5Ft-ubJkLhMDTa5-K7k2ix6mqRM-Yu2Y7CGuVK7', 'joex1', TIMESTAMP '2021-05-29 14:03:08.03729', TIMESTAMP '2021-05-29 14:03:11.091329', 1622296988037),
('EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'housekeeping', 'docspell-system', '{}', 'Docspell house-keeping', TIMESTAMP '2021-05-30 00:00:00.049325', 'docspell-system', 0, 'success', 0, 0, 'docspell-houskeeping', 'joex1', TIMESTAMP '2021-05-30 00:00:00.148411', TIMESTAMP '2021-05-30 00:00:01.143928', 1622332800148),
('2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'full-text-index', 'docspell-system', '{}', 'Create full-text index', TIMESTAMP '2021-06-11 14:33:06.584428', 'docspell-system', 0, 'success', 0, 0, 'full-text-index-tracker', 'joex1', TIMESTAMP '2021-06-11 14:33:11.812935', TIMESTAMP '2021-06-11 14:33:15.518232', 1623421991812),
('D4BpCNi2bg9-CQQE8GP3B1e-G1pqZcFinYz-X1uwnfwbZRa', 'all-previews', 'docspell-system', '{"collective":null,"storeMode":"whenmissing"}', 'Create preview images', TIMESTAMP '2021-06-11 14:33:07.918458', 'docspell-system', 0, 'success', 0, 0, 'generate-all-previews', 'joex1', TIMESTAMP '2021-06-11 14:33:15.746345', TIMESTAMP '2021-06-11 14:33:19.084771', 1623421995746),
('8LJDfq6AGb2-E8ZW7w4a7uk-mF2AfRQb1qY-FgNewowo74o', 'all-page-count', 'docspell-system', '{}', 'Create all page-counts', TIMESTAMP '2021-06-11 14:33:08.151387', 'docspell-system', 0, 'success', 0, 0, 'all-page-count-tracker', 'joex1', TIMESTAMP '2021-06-11 14:33:19.268434', TIMESTAMP '2021-06-11 14:33:19.532929', 1623421999268),
('2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'full-text-index', 'docspell-system', '{}', 'Create full-text index', TIMESTAMP '2021-06-16 06:38:41.116323', 'docspell-system', 0, 'failed', 2, 0, 'full-text-index-tracker', 'joex1', TIMESTAMP '2021-06-16 07:38:42.756029', TIMESTAMP '2021-06-16 07:38:44.464088', 1623829122756),
('8Ewew6ccTXP-bcX3d6XiZf9-TRt1ZYJbTnY-1oh6jQSpfvi', 'all-previews', 'docspell-system', '{"collective":null,"storeMode":"whenmissing"}', 'Create preview images', TIMESTAMP '2021-06-16 06:38:42.25456', 'docspell-system', 0, 'success', 0, 0, 'generate-all-previews', 'joex1', TIMESTAMP '2021-06-16 06:38:58.578615', TIMESTAMP '2021-06-16 06:38:59.472489', 1623825538578),
('7vTpPZLnbqG-KxFDYfziTka-SHRd6gVjxXx-He89wi2ijgY', 'all-page-count', 'docspell-system', '{}', 'Create all page-counts', TIMESTAMP '2021-06-16 06:38:42.447822', 'docspell-system', 0, 'success', 0, 0, 'all-page-count-tracker', 'joex1', TIMESTAMP '2021-06-16 06:38:59.656664', TIMESTAMP '2021-06-16 06:38:59.876294', 1623825539656),
('4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'full-text-index', 'docspell-system', '{}', 'Create full-text index', TIMESTAMP '2021-07-13 21:02:58.102752', 'docspell-system', 0, 'stuck', 1, 0, 'full-text-index-tracker', 'joex1', TIMESTAMP '2021-07-13 21:06:04.489798', TIMESTAMP '2021-07-13 21:06:08.498275', 1626210364489);      
INSERT INTO "public"."job" VALUES
('7YcLoh51xm1-gz2F4V2eTmg-yf1wHP3Ummg-uvu32P3ReVz', 'all-previews', 'docspell-system', '{"collective":null,"storeMode":"whenmissing"}', 'Create preview images', TIMESTAMP '2021-07-13 21:02:58.462062', 'docspell-system', 0, 'success', 0, 0, 'generate-all-previews', 'joex1', TIMESTAMP '2021-07-13 21:03:16.701378', TIMESTAMP '2021-07-13 21:03:16.831027', 1626210196701),
('ANZUrGEdwd7-etAxe85BdqR-y22w4b4CbYE-Lzzx71gbwRa', 'all-page-count', 'docspell-system', '{}', 'Create all page-counts', TIMESTAMP '2021-07-13 21:02:58.549823', 'docspell-system', 0, 'success', 0, 0, 'all-page-count-tracker', 'joex1', TIMESTAMP '2021-07-13 21:03:16.916212', TIMESTAMP '2021-07-13 21:03:17.017324', 1626210196916),
('8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'learn-classifier', 'demo', '{"collective":"demo"}', 'learn-classifier: learn-classifier', TIMESTAMP '2021-07-13 21:02:59.434753', 'learn-classifier', 0, 'success', 0, 0, 'CdqeBRkD5Ft-ubJkLhMDTa5-K7k2ix6mqRM-Yu2Y7CGuVK7', 'joex1', TIMESTAMP '2021-07-13 21:03:10.9865', TIMESTAMP '2021-07-13 21:03:16.629004', 1626210190986),
('Fb6p5jSp6Xg-hSw4kYdk9gB-hSQFML94yzP-FLxtPWufche', 'all-previews', 'docspell-system', '{"collective":null,"storeMode":"whenmissing"}', 'Create preview images', TIMESTAMP '2021-07-13 21:06:03.679443', 'docspell-system', 0, 'success', 0, 0, 'generate-all-previews', 'joex1', TIMESTAMP '2021-07-13 21:06:08.582687', TIMESTAMP '2021-07-13 21:06:08.962884', 1626210368582),
('8HEvkXhpQPF-vswPxVSYdVP-fBcsCh6bCmk-vaaCguTKpWU', 'all-page-count', 'docspell-system', '{}', 'Create all page-counts', TIMESTAMP '2021-07-13 21:06:03.732908', 'docspell-system', 0, 'success', 0, 0, 'all-page-count-tracker', 'joex1', TIMESTAMP '2021-07-13 21:06:09.056159', TIMESTAMP '2021-07-13 21:06:09.175354', 1626210369056);           
CREATE CACHED TABLE "public"."attachment_preview"(
    "id" VARCHAR(254) NOT NULL,
    "file_id" VARCHAR(254) NOT NULL,
    "filename" VARCHAR(254),
    "created" TIMESTAMP NOT NULL
);       
ALTER TABLE "public"."attachment_preview" ADD CONSTRAINT "public"."CONSTRAINT_2D" PRIMARY KEY("id");           
-- 2 +/- SELECT COUNT(*) FROM public.attachment_preview;       
INSERT INTO "public"."attachment_preview" VALUES
('2ecoA7A7HgT-xPwzNQYfiZd-rF1XF3aEPMr-qsNJXoe36oZ', 'D8Cj2R2fmSM-z31GMJF61iG-BQnDzjGWeh1-bhQfBym5qrQ', 'wordpress-pdf-invoice-plugin-sample.converted_preview.png', TIMESTAMP '2021-01-03 21:13:35.431'),
('4SDQngEFYuK-tb9xAachZSt-LNCrE36NFRr-U8avxFCW9A4', '7Vvy4bZfe3b-YCpAVWc8Lw9-wUkKLWjo3RL-4RnazGiQtnY', 'letter-en.converted_preview.png', TIMESTAMP '2021-01-03 21:34:45.865');     
CREATE CACHED TABLE "public"."jobgroupuse"(
    "groupid" VARCHAR(254) NOT NULL,
    "workerid" VARCHAR(254) NOT NULL
);       
ALTER TABLE "public"."jobgroupuse" ADD CONSTRAINT "public"."CONSTRAINT_7" PRIMARY KEY("groupid", "workerid");  
-- 2 +/- SELECT COUNT(*) FROM public.jobgroupuse;              
INSERT INTO "public"."jobgroupuse" VALUES
('joex1', 'docspell-system'),
('joex1', 'demo');
CREATE CACHED TABLE "public"."sentmail"(
    "id" VARCHAR(254) NOT NULL,
    "uid" VARCHAR(254) NOT NULL,
    "message_id" VARCHAR(254) NOT NULL,
    "sender" VARCHAR(254) NOT NULL,
    "conn_name" VARCHAR(254) NOT NULL,
    "subject" VARCHAR(254) NOT NULL,
    "recipients" VARCHAR(254) NOT NULL,
    "body" TEXT NOT NULL,
    "created" TIMESTAMP NOT NULL
);        
ALTER TABLE "public"."sentmail" ADD CONSTRAINT "public"."CONSTRAINT_4B" PRIMARY KEY("id");     
-- 0 +/- SELECT COUNT(*) FROM public.sentmail; 
CREATE CACHED TABLE "public"."sentmailitem"(
    "id" VARCHAR(254) NOT NULL,
    "item_id" VARCHAR(254) NOT NULL,
    "sentmail_id" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL
); 
ALTER TABLE "public"."sentmailitem" ADD CONSTRAINT "public"."CONSTRAINT_5" PRIMARY KEY("id");  
-- 0 +/- SELECT COUNT(*) FROM public.sentmailitem;             
CREATE CACHED TABLE "public"."joblog"(
    "id" VARCHAR(254) NOT NULL,
    "jid" VARCHAR(254) NOT NULL,
    "level" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "message" TEXT NOT NULL,
    "counter" BIGINT DEFAULT NEXT VALUE FOR "public"."SYSTEM_SEQUENCE_95446BBD_DF65_42A9_A00E_2556C5A54A0C" NOT NULL NULL_TO_DEFAULT SEQUENCE "public"."SYSTEM_SEQUENCE_95446BBD_DF65_42A9_A00E_2556C5A54A0C"
);     
ALTER TABLE "public"."joblog" ADD CONSTRAINT "public"."CONSTRAINT_BB" PRIMARY KEY("id");       
-- 185 +/- SELECT COUNT(*) FROM public.joblog; 
INSERT INTO "public"."joblog" VALUES
('6sqBoPpqKxw-JkVGbeoJKJw-Bx4h54CCFPK-u2jm67wiEsE', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:06.634397', 'Running full-text-index migrations now', 743),
('7LVoXo67nDS-Xo2nJRQHi6a-vTYQDqMF8va-kJ8PZNDQ2Jm', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.304684', 'Apply 1/Initialize', 744),
('6N13K4iFiLx-YhGqyVeFKq6-pDBdDWueKWa-JQxihX9AbQk', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.466195', 'Migration 1/Initialize already applied.', 745),
('5UNo45PJMn1-aBPwoSUC4hx-x8ZN5kPSW3D-35h4q7SAUYS', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.4691', 'Apply 3/Add folder field', 746),
('3PSJcNcDTyc-BdShvud5v1F-kVfutDqQv5r-b9C6eCGYdo7', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.547933', 'Migration 3/Add folder field already applied.', 747),
('GY9LtFFtECH-5Mzm1ZsVzc7-JZcdpvb3bCs-TFSYiS7eFse', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.548691', 'Apply 4/Index all from database', 748),
('25yKCcetfro-o35Mu5bC9rd-X6dMdAA4syr-vDFp3pXzEMB', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.603847', 'Migration 4/Index all from database already applied.', 749),
('5FsN9NsQt2e-H5BntU38jwJ-JjF8MeWCVfM-zbQCZ8Rcy6f', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.60462', 'Apply 5/Add content_fr field', 750),
('EXJ8PBGwyUu-voro3dU2L2q-wn2Cv4gjzsB-877KEFCaF95', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.660743', 'Migration 5/Add content_fr field already applied.', 751),
('CUBA1c4ndo5-JqAawsKgFdn-ygCHCnt1hC7-qMbnrphwoAD', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.661498', 'Apply 6/Index all from database', 752),
('34qXSsfw413-B1LiaKnGfGr-gkcbe82CVRn-QBR2rfHpMsQ', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.724054', 'Migration 6/Index all from database already applied.', 753),
('4U5dMV8NeC6-jGcUHeC1SFn-ZvR1ooCnYsA-58TCfWn7vL8', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.724718', 'Apply 7/Add content_it field', 754),
('79jxNyuRwZD-hJfgha2zCBy-NRDpNYdvxnc-cMr37YBhF62', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.77576', 'Migration 7/Add content_it field already applied.', 755),
('Dn2brRG1Kce-Q8XRBh3kG85-N9jjMNVpYpE-Zz2DCa3dZTi', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.776431', 'Apply 8/Add content_es field', 756),
('99jAF18tFtG-G1CFXz8qwg9-ymBz7DahWRG-PunUvHnPKty', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.815288', 'Migration 8/Add content_es field already applied.', 757),
('GbCvSUudy32-3bLEMwENUC2-2e27T5khg4s-yVbSKLFaEto', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.81591', 'Apply 9/Add more content fields', 758),
('GNMcCEYSCVy-icd9vsejgWz-C8L6ouyDWdu-sJkCwJnTRzR', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.852093', 'Migration 9/Add more content fields already applied.', 759),
('8b4zpA2rjU9-gwRSTnzcerA-fpXbetBYmkm-ZbiUJfLMx9U', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.852274', 'Apply 10/Add latvian content field', 760),
('9yu5D4V8BYZ-U1fesnfKGVj-4viraXLaoUF-oE4UYMN9ae1', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.894152', 'Migration 10/Add latvian content field already applied.', 761),
('5e3VUutoHrZ-Xd3eq2w7seJ-n4ZUrEjMDXh-vLVyJVc7CKE', '8BcXYmDdmNQ-sDnD2nNyiXj-NwyHmPavxyr-uPwKk4X9wJd', 'info', TIMESTAMP '2021-05-29 14:03:07.898967', 'Job execution successful', 762),
('E2qhYMUGwPM-Q7dDUrardtb-tkcoff92VZP-qifZheQZmJg', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:08.314944', 'Learn classifier for tag category: doctype', 763);            
INSERT INTO "public"."joblog" VALUES
('6kg4JKmjP7R-5yb2gNhFL49-bdDEDn4gzyC-DW1opnGPsPR', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:08.606724', 'Learning from 2 items.', 764),
('47oPyBBC6Kh-V4ZFTA238ac-hsLLjt4Hgd8-cWvBWk65v4p', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:08.630134', 'Splitting raw data into test/train data. Testing with 0 entries', 765),
('HiqZjwXQEko-2UbvE1gehM4-py2gSDxH72p-tWp4WW21uw9', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:08.688984', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 766),
('GpyPyEKyyyK-kf1bdmoxeUP-zNgaeNiabwP-stB8WzauR3V', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.269809', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier10794281213699991694/model.ser.gz))', 767),
('4uBagJnin6j-c4XZ7EX9BZK-zECN1rwJReD-2X26dkkFZYV', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.316101', 'Storing new trained model for: tagcategory-doctype', 768),
('F8tGGCjYjEq-UHda9vp8Y9G-PQb9VDVF9kQ-tP2WgybYbvf', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.534963', 'New model stored at file 9gCV3zJSPJy-fkrAcvxF3ie-knqGfTLKTwN-4rMhSL9HV49', 769),
('G2wkS4QJeGq-W8U8uJeREpY-b4yEqGYofKG-iEgtzFCvk3u', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.539892', 'Deleting old model file 5ZvVojyRZmf-YgBPudDqf5y-qJB9ywBoV92-wGdhw7rpEhs', 770),
('J9qqSSsw48M-oEbZ3njyoj9-yJv1ch7TBHw-hJ9HtPE4W34', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:09.636659', 'Found 0 obsolete model files that are deleted now.', 771),
('AepsnzAceNQ-9MeYFCkXKUz-UtpToqE1fTr-u6S6JQCQH1u', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.649518', 'Deleted 0 model files.', 772),
('4Yk2LdhzEKX-w4tQUgS1nDv-pqW1kQCc2u2-XBdcURJt4e1', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:09.700343', 'Learn classifier correspondentorg', 773),
('G2WidhyAiiN-zd1Ry3DqfVu-oppQmQKXoz5-PV8cWp832Wy', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.754098', 'Learning from 2 items.', 774),
('8MhbFjyBLyJ-wPfJFpsy884-po44nF91zfT-QBCmziBHbia', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.755062', 'Splitting raw data into test/train data. Testing with 0 entries', 775),
('5GX6N4fkHY7-XptD1ujQoZ3-V4uiZRtbkRv-GZKJC9vRWpS', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:09.790563', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 776),
('24wYUshmy8a-89pYfL16F4C-qnDvADu3JVz-HSY2XtqRxAX', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.027773', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier15378402492363708090/model.ser.gz))', 777),
('8DTKPNWwfj3-4KDsTz95sRL-adNMD8SaQaf-8EUCRoMgxaX', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.038696', 'Storing new trained model for: correspondentorg', 778),
('J9gn1DeTVsh-Tb7GRhSXs2i-79QcRp7mqpg-dTsDE42r8Vo', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.12467', 'New model stored at file DvCJfFaQPg7-kUGLnaQHzne-PBimJB7xhmM-bEwRthwX6BA', 779),
('BxAZAE8Xaef-18JRsLmtHVD-wVhBLi6Exjm-462NxdVkMfX', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:10.131737', 'Learn classifier correspondentperson', 780);
INSERT INTO "public"."joblog" VALUES
('GCPyaGhTo5X-FePuAxyJzd8-czEjyjNusZ1-ahfAYJFL9kU', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.189704', 'Learning from 2 items.', 781),
('9Q143c1NA11-EwE8j7Dzq1b-CsY4CPh54jN-WJ2cYTnRqVX', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.190809', 'Splitting raw data into test/train data. Testing with 0 entries', 782),
('53JwV55atGA-ogJSFABNP3b-MEcef7Mao5W-vMMeRhLAeVq', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.223291', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 783),
('3XMXW8N7trf-99R7g5MkZtB-7oBuzuHCLc5-XHBMHwoS3vU', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.387192', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier2567162524909726652/model.ser.gz))', 784),
('F82HvsXuBeK-Swpio68NCwc-QeLYKh1TG1P-VAfKkCD7Ma2', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.402753', 'Storing new trained model for: correspondentperson', 785),
('3c6VSGdb85m-RpLUJKeecje-GZsPuB4QU4w-9QWuZn8iit7', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.469078', 'New model stored at file 6aJE33njUhc-8pr17PhsAZ7-jbnsBFZe9hk-Uetu6mWJSEU', 786),
('A5Am3XFHpro-vpq3aViXAZo-kevz59PgWiV-rv5UXwegeYc', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:10.476341', 'Learn classifier concernedperson', 787),
('Apy7XmSYtCM-6bVCgFFtLTG-7jvqwYMPk9a-8Fzmh9mqm1h', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.519866', 'Learning from 2 items.', 788),
('AYGk3ifsGuy-im15zj7cMan-qJZVt4NYjsL-j5moxr3VRV8', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.524128', 'Splitting raw data into test/train data. Testing with 0 entries', 789),
('C5pyqjGSvnT-xSHPcymGPLH-R2qdBf5HE2o-bVhCvweZ2Wi', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.547369', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 790),
('DWmEJj8oErT-HHvyXtKRxJx-ofBP4UwWXJX-oUGLoadc1Cj', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.723901', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier3373588553631520110/model.ser.gz))', 791),
('6KrCt1W5xYN-V41CzkpPwTi-R256WGikRwv-dVwGug2mA8p', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.734834', 'Storing new trained model for: concernedperson', 792),
('7sywPNP5dZm-2ZJmnhx3SSq-3K1icnvr43Y-nLmpvqMMPdn', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.802075', 'New model stored at file hmVrCPHkP3K-M43aQaxRHCQ-Vk3ZaTGmhc8-mNn2VE9Wr5', 793),
('A471w9QYi5E-JQRo5ARdaro-H7N4DS7Z8xM-YESWxBdKZB7', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:10.811514', 'Learn classifier concernedequip', 794),
('4KUH4xU9Bc7-tFsEa6wzD96-YCo8CXVvLAh-vKKE16UEqyW', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.862941', 'Learning from 2 items.', 795),
('47WnmJGYbKg-jAhZh9hkYDF-dEjDtD6UBPH-rAuvxZYUBqr', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.864057', 'Splitting raw data into test/train data. Testing with 0 entries', 796),
('6ULqZ36fuyF-4QSDTPVA3Wd-htbJfJ2L7Hq-PZt3tVHsV1J', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.895895', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 797);
INSERT INTO "public"."joblog" VALUES
('J1Rpg94pwE5-kLFF4Hhc9ch-6KvNMUrZKgM-EpJ8gkzkmmN', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.931205', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier8809611874743716844/model.ser.gz))', 798),
('5utFXgzdSNr-wXsJ3MV7xVE-9kD7dTmKBkj-479wjpFib8W', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.940457', 'Storing new trained model for: concernedequip', 799),
('FKw6YNYay4M-w4r1mfFzk6x-XwSCeeruufp-2NYZ2ZmqHNy', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'debug', TIMESTAMP '2021-05-29 14:03:10.996896', 'New model stored at file 26fGPjLcULK-kJcCShWqVMH-VwNpAmWoJwS-RGSECJamcDc', 800),
('2emFNYYwqi5-ojfakdphe8P-5fr5ZJbsHQW-iFd5VHF1Yog', 'FWdFqDtwXhx-ZQHugw932d5-35RKbsCKWLv-jECx5bPaZeY', 'info', TIMESTAMP '2021-05-29 14:03:11.089843', 'Job execution successful', 801),
('GQdwPT2RqwT-78FRESCwgwb-WdGGgx73mZ6-7qBxF169xN', 'BqaFbmUNoTN-ybAaGPapjJW-zeWeaY54vAg-wpGshXZePpS', 'info', TIMESTAMP '2021-05-29 14:03:11.185893', 'Generating previews for attachments', 802),
('2QaWWZbVcbL-ngHJpe45L43-vZeEP7r1nte-cGzBePqnr1p', 'BqaFbmUNoTN-ybAaGPapjJW-zeWeaY54vAg-wpGshXZePpS', 'info', TIMESTAMP '2021-05-29 14:03:11.238371', 'Submitted 0 jobs', 803),
('FuYmQNtGi8S-of32WQqY9SZ-F8dFE5L8xsD-c3dU9t97w48', 'BqaFbmUNoTN-ybAaGPapjJW-zeWeaY54vAg-wpGshXZePpS', 'info', TIMESTAMP '2021-05-29 14:03:11.280982', 'Job execution successful', 804),
('CHHbN2dF59w-jeqTKKLJnuN-kiK2CpXzhYh-z9fXUyWehSr', '2uwdfbwzmRQ-WucC5TZTrjG-so5aYxBbFnf-QepabswWCSV', 'info', TIMESTAMP '2021-05-29 14:03:11.361142', 'Generating previews for attachments', 805),
('A5BvN8NprNk-uzPpVQ1GNEM-cdHaPiYsYFB-1qUqutW5Kzx', '2uwdfbwzmRQ-WucC5TZTrjG-so5aYxBbFnf-QepabswWCSV', 'info', TIMESTAMP '2021-05-29 14:03:11.404208', 'Submitted 0 jobs', 806),
('G2q61XTv94i-M39fCwMMRNa-iDrtQ6oEB6N-8iLxwdJ7g5X', '2uwdfbwzmRQ-WucC5TZTrjG-so5aYxBbFnf-QepabswWCSV', 'info', TIMESTAMP '2021-05-29 14:03:11.445938', 'Job execution successful', 807),
('9cQA2FrqQn9-VZ7z7H7EZpD-vAe9DWK6SaG-JZnV7WtTLEx', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.154817', 'Running house-keeping task now', 808),
('BY4ZAyqqRoi-5uykhq1toqL-ftcbtQNzhsV-wBod1AK856w', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.165834', 'Cleanup invitations older than Timestamp(2021-04-30T00:00:00.162853Z)', 809),
('37U1vRgRNHJ-okuy4aEgd3V-ipVj7gyLYiU-dihzcfDhoYJ', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.207562', 'Removed 0 invitations', 810),
('EeFGGQsGGPz-W84d9rzKgtp-AX68ABAwGw8-gRR9XDy7oy2', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.244327', 'Cleanup remember-me tokens older than Timestamp(2021-04-30T00:00:00.217254Z)', 811),
('8FxNYupg2bY-FLSbNghsxuz-ewnawuwvKVA-W79yJRAeUHd', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.268969', 'Removed 0 tokens', 812),
('D2rvqvojjgZ-S2MfnBY99AC-YEquzrs6oTM-kbF17QMjWPS', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.283581', 'Cleanup jobs older than Timestamp(2021-04-30T00:00:00.280706Z)', 813),
('8zsLZJsa7pn-xXE7nLUfehs-GCWW4zeCfQt-pJgQMvfmQc3', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.84562', 'Removed 42 jobs', 814),
('4SfkvTMxM7X-sQicu8PBBMy-vLsXG7Wevdq-T6VYZr9CPYH', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:00.856605', 'Check nodes reachability', 815),
('H89GMVEnPhS-zk4D67UZUCL-R4FEnMFPXj1-5dajnpa5C8n', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:01.024982', 'Node http://localhost:7020 is reachable', 816),
('9zKcg9NhnXz-s4pLyMkGoQk-4uC8Qe7SG8a-TQBuYFdSmvd', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:01.105155', 'Node http://localhost:7021 is reachable', 817),
('J5aUHcb66j9-ePK8ZsXAQvd-VeuTGFkpPct-TMRHkCVWym4', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:01.127643', 'Remove nodes not found more than 2 times', 818);       
INSERT INTO "public"."joblog" VALUES
('5jXATvBczCQ-w4FhG2b1Xzv-obPKQXJQR1C-2NKRFzB1yvd', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:01.142246', 'Removed 0 nodes', 819),
('4Pr9LRcf9cb-86yeWUyp82o-GmRBDJ8Qhxj-2JdNMF1m2pL', 'EGjZYD1fzNW-4MKjbJz1S5e-A7pCVMRuhdr-2cnRmvt4Jr6', 'info', TIMESTAMP '2021-05-30 00:00:01.143054', 'Job execution successful', 820),
('BGxTqxLWedn-HGz8fvrUbdA-ucvu6vtmUjd-amWx2PSS8c7', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:11.8594', 'Running full-text-index migrations now', 839),
('4ssgRrUbkmW-4T83RDTN3GG-u5PUWNHnbNv-UyDwZmo1nqK', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.005756', 'Apply 1/Initialize', 840),
('GZ8Emb9vL4h-LnJYuxDNwx4-Xpa78eardeG-FmNYdwbqKNU', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.40749', 'Migration 1/Initialize already applied.', 841),
('D4T9DcFMBAB-t2SAWctK4m3-5cB5EskGUvG-kcwAjXAohub', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.41696', 'Apply 3/Add folder field', 842),
('A4xBzUHP1Eo-ivPC2o7rPzE-GKYX6KgReCf-UgWyDeZmzqp', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.599634', 'Migration 3/Add folder field already applied.', 843),
('AShLs1A5GeR-LXA2SbuAroS-BCWmvqU8KvN-Gy3HBuZZ7vT', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.610635', 'Apply 4/Index all from database', 844),
('FE1YapQjjTs-UK99Mkx9S2w-A3oPscoHV2Q-Xdy5dq2Pfw3', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.819094', 'Migration 4/Index all from database already applied.', 845),
('2CPjLTwj6Bv-2SD3rQ3QHEU-5HMfC1octon-RPqij47RdtY', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.819845', 'Apply 5/Add content_fr field', 846),
('EKMYX4UP3hh-YJD8pr4tDv9-QCTNVspjYRy-AoKGLMLCwAS', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.953109', 'Migration 5/Add content_fr field already applied.', 847),
('7ecqQj6oHRu-7yND9YeYrBD-uSdEa6ZtFZF-k8PK8t6GHpW', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:14.953892', 'Apply 6/Index all from database', 848),
('3WdAUVFvXQQ-E8QMsTFKfAF-sRGFwoktDna-C7eY6uGEHog', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.062666', 'Migration 6/Index all from database already applied.', 849),
('Cp4HktQyuSV-Ada1by71Cj3-v9FeYtA76tU-s3M7aCjb9m4', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.06334', 'Apply 7/Add content_it field', 850),
('6pmcRe4RYQY-d586oazNfdN-PNwHkNNRtju-qTHfsrNmrbB', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.182586', 'Migration 7/Add content_it field already applied.', 851),
('DwpVChMGi9r-dFFxuE6mAyV-X4ZuTBSdqd7-vYxkHw3fRVa', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.183279', 'Apply 8/Add content_es field', 852),
('2aVkb6UW55K-GufiHLbNSBE-f63XbLnMzhw-Jmp3p6jjNJ6', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.289344', 'Migration 8/Add content_es field already applied.', 853),
('3LK3LbBeMN1-yGeAgYCsDMZ-QyFUjSctDHh-g35ebPSDtSS', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.291013', 'Apply 9/Add more content fields', 854),
('9etGuTU2LBF-va3qk93PnDE-jteZdkajJa9-8LgyFzKyydZ', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.376699', 'Migration 9/Add more content fields already applied.', 855),
('CQ4EeQTzsuh-bJ75LEdQthb-oZZyzA4ALfW-gYVqp4DF6Sy', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.377398', 'Apply 10/Add latvian content field', 856),
('GAmDExW82VY-B49FoHVfX4T-uxuNr6bvmWV-bFxCG6kGvL5', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.447017', 'Migration 10/Add latvian content field already applied.', 857);       
INSERT INTO "public"."joblog" VALUES
('CiFzb9tuceg-bfmhf12gNaE-LzuvGhvJfR1-ouRvpPevNpt', '2LpqxJvGMsk-cJ5f4oSQWGT-yn3zAeoStK6-nfrPcfd81sx', 'info', TIMESTAMP '2021-06-11 14:33:15.452812', 'Job execution successful', 858),
('3ob6FJuSSpZ-yMjUv9FfVYn-KVFk3D2vHN5-byDd5NC2Goe', 'D4BpCNi2bg9-CQQE8GP3B1e-G1pqZcFinYz-X1uwnfwbZRa', 'info', TIMESTAMP '2021-06-11 14:33:15.787689', 'Generating previews for attachments', 859),
('DQhSy91ns6m-eBASA29yGmj-Mis3E9vcuuR-FxuGtMJ2qkJ', 'D4BpCNi2bg9-CQQE8GP3B1e-G1pqZcFinYz-X1uwnfwbZRa', 'info', TIMESTAMP '2021-06-11 14:33:16.006495', 'Submitted 0 jobs', 860),
('HgwYcP7jZEe-mXjgXYbyW87-oTdXG9xNECf-6Z2jP2kYkTg', 'D4BpCNi2bg9-CQQE8GP3B1e-G1pqZcFinYz-X1uwnfwbZRa', 'info', TIMESTAMP '2021-06-11 14:33:19.082665', 'Job execution successful', 861),
('DziGGZJcXEQ-9U8d9ocKdEK-MN2JwqcBsub-56iTZstNi5', '8LJDfq6AGb2-E8ZW7w4a7uk-mF2AfRQb1qY-FgNewowo74o', 'info', TIMESTAMP '2021-06-11 14:33:19.292741', 'Generating previews for attachments', 862),
('CeHkGczy9vg-LjxXT8EjCgm-SPZexYUp2X9-H34byFBN3wZ', '8LJDfq6AGb2-E8ZW7w4a7uk-mF2AfRQb1qY-FgNewowo74o', 'info', TIMESTAMP '2021-06-11 14:33:19.442448', 'Submitted 0 jobs', 863),
('7qT51VwKFbD-XXj4w82JLbY-wPqVmXfQNek-Xdf5FPbF84x', '8LJDfq6AGb2-E8ZW7w4a7uk-mF2AfRQb1qY-FgNewowo74o', 'info', TIMESTAMP '2021-06-11 14:33:19.530906', 'Job execution successful', 864),
('6ucjFXkaWLQ-UkZdiSha6V6-UyHgwJQXtUH-q7U4iSD69xu', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 06:38:45.916392', 'Running full-text-index migrations now', 871),
('7LpojX8nfvB-UrrVAoP6gbN-v32A8YyuXmq-ryPRJ7ABj32', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 06:38:52.56198', 'Apply 0/Delete all data', 872),
('6otBG9jdc39-MHiYKsPknz3-ANVtyXxzixg-YEvGv8JJ4hZ', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 06:38:53.453767', 'Apply 1/Initialize', 873),
('LkF2rAbnjo7-cWUfUPTD1LE-QfE1nb6zeEe-5UtS5kftTA', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'error', TIMESTAMP '2021-06-16 06:38:58.31187', 'Job 2Fu3P534J.../docspell-system/full-text-index/Low execution failed. Retrying later.: unexpected HTTP status: 400 Bad Request', 874),
('8nc5GsmbiHw-paMgS15GdjS-7aHJnUiyPf7-RQhMeQHnsmD', '8Ewew6ccTXP-bcX3d6XiZf9-TRt1ZYJbTnY-1oh6jQSpfvi', 'info', TIMESTAMP '2021-06-16 06:38:58.602331', 'Generating previews for attachments', 875),
('AsFB3aG9pin-FjonvTU41XP-BgAkKPmA9pK-dtZx18tm2eA', '8Ewew6ccTXP-bcX3d6XiZf9-TRt1ZYJbTnY-1oh6jQSpfvi', 'info', TIMESTAMP '2021-06-16 06:38:58.801116', 'Submitted 0 jobs', 876),
('F7zpPRecwBt-uVgpK9RoAZb-gtBbNf3zZWJ-NMvRMrswFZu', '8Ewew6ccTXP-bcX3d6XiZf9-TRt1ZYJbTnY-1oh6jQSpfvi', 'info', TIMESTAMP '2021-06-16 06:38:59.464802', 'Job execution successful', 877),
('J1AUfkH6KRs-dv5bCWmXdEP-uyWudQ2PVtR-JAdCwnyYFTS', '7vTpPZLnbqG-KxFDYfziTka-SHRd6gVjxXx-He89wi2ijgY', 'info', TIMESTAMP '2021-06-16 06:38:59.6817', 'Generating previews for attachments', 878),
('DZ38EPAbhjU-8GHJ9WUYpyN-u9Fh7pijGYQ-x51qBmYMa43', '7vTpPZLnbqG-KxFDYfziTka-SHRd6gVjxXx-He89wi2ijgY', 'info', TIMESTAMP '2021-06-16 06:38:59.794367', 'Submitted 0 jobs', 879),
('4G1Z9X5rmyB-4fpRYEYYh5H-26RNKu7iS6q-KCB79aWK7t9', '7vTpPZLnbqG-KxFDYfziTka-SHRd6gVjxXx-He89wi2ijgY', 'info', TIMESTAMP '2021-06-16 06:38:59.874509', 'Job execution successful', 880),
('HSyuL3L1UKL-oXvwJkYYzq8-VANdj7kgf4K-9Q2Q6Ej19MR', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:08:42.795253', 'Running full-text-index migrations now', 881),
('4JiM8UAwYeg-4bx8LPKvyfr-a3tUeaRf9wb-cwbNsmvc2tW', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:08:42.893714', 'Apply 0/Delete all data', 882),
('AT2EqBybK1g-YcceSbCNEWj-QGKAJUXiCth-cU4bashtWXr', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:08:42.932493', 'Apply 1/Initialize', 883),
('FkmuFWb2fVr-9kodGhQy8CF-zuY32HCJGTt-snUvQxiGGat', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'error', TIMESTAMP '2021-06-16 07:08:44.866175', 'Job 2Fu3P534J.../docspell-system/full-text-index/Low execution failed. Retrying later.: unexpected HTTP status: 400 Bad Request', 884);          
INSERT INTO "public"."joblog" VALUES
('7rxjLDtqdgG-HfMvJDgSJv1-KikJRJXdL3Z-FtpX96Jbdb3', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:38:42.775967', 'Running full-text-index migrations now', 885),
('GebswdZA3km-kgHA3r2aoFe-jVaj5c2RGKS-sK5Wnf3hcQ5', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:38:42.861026', 'Apply 0/Delete all data', 886),
('4o35WzU3edm-Pt4LdymEvf9-KamZ3LimGTR-pM4piZV7mLw', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'info', TIMESTAMP '2021-06-16 07:38:42.88736', 'Apply 1/Initialize', 887),
('28H856UscxN-n3eRGXcm7XH-f34pn3REU2N-98YWhi5Yi5T', '2Fu3P534JhW-39BKcXYcUcU-FeUQvxQbRZq-isDa61jZEFs', 'error', TIMESTAMP '2021-06-16 07:38:44.447126', 'Job 2Fu3P534J.../docspell-system/full-text-index/Low execution failed. Retries exceeded.: unexpected HTTP status: 400 Bad Request', 888),
('5wb3Tw4E1bX-eTAsX4fqgvM-SMoo6PDCRmS-aBbVosZnkAY', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:03:00.789897', 'Running full-text-index migrations now', 903),
('7GaZKWtxign-fyBMZwsRKYJ-rd6N2a3BUEV-r1vaiqvg9Lb', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:03:06.430987', 'Apply 0/Delete all data', 904),
('FALpgd9FhFB-Gwzr9YiFEGT-c9mjqh2aQUV-AzhuzaiyPre', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:03:06.839931', 'Apply 1/Initialize', 905),
('5QWAbBi3iMt-Qr6xRyMuAhF-z29Fy7pjTdZ-c7h2yDaNybs', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'error', TIMESTAMP '2021-07-13 21:03:10.80493', 'Job 4MUuvPDJk.../docspell-system/full-text-index/Low execution failed. Retrying later.: unexpected HTTP status: 400 Bad Request', 906),
('4GM35w46n2L-JCdXpL2ZSZh-SF1acPVTge9-gdjPjiie7gu', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:11.641064', 'Learn classifier for tag category: doctype', 907),
('9tPbzvgKUZU-2UVUjwRFoNF-6waD3JnWCKX-CgNW6mj8d4u', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:12.167259', 'Learning from 2 items.', 908),
('g3meXk6zjnj-VRnMwmpjaYY-unCz6yjMJsQ-qocR72jdzV', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:12.307961', 'Splitting raw data into test/train data. Testing with 0 entries', 909),
('AtRy24rkzEF-J5DMBzrpn8T-rMbj8W7bnkp-d6xwSYUSvb1', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:12.406011', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 910),
('51Khh6Zztza-MNGicR41Ev9-u223U1gtGyb-nZXxAw42CoC', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.128775', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier7377315354548024063/model.ser.gz))', 911),
('DsNKwDevJna-VZwrFURKTJg-jnXWt5xQpZv-WpKGE94PKib', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.234724', 'Storing new trained model for: tagcategory-doctype', 912),
('5AGjQDUxNRP-XiGQXibNRfk-kJuBzMC2Ept-WmP1niT3rcc', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.596897', 'New model stored at file 8Zqe9ujkK9F-x8su5twLT6Q-N45WGGTmjzk-cf5xbFP9TDK', 913),
('HPCqqdMSm7r-g8HzHrzNqzA-gW5pEFM52N7-cRB4TUfqadz', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.606018', 'Deleting old model file 9gCV3zJSPJy-fkrAcvxF3ie-knqGfTLKTwN-4rMhSL9HV49', 914),
('A5kcQwc6Vyi-73m1LkQhiHk-bisyDSG5M3N-53dJGmQCofC', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:14.738248', 'Found 0 obsolete model files that are deleted now.', 915),
('EpjhwfLUzYa-oT26heNw2wo-m6quZxp4eP6-wKq6Kh7tTRi', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.759099', 'Deleted 0 model files.', 916);              
INSERT INTO "public"."joblog" VALUES
('7p3BUpeCJCJ-3RKpe8aqkto-qAwqoFMA8r7-d48YofS1V1c', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:14.814034', 'Learn classifier correspondentorg', 917),
('FxdSdaftcyv-t9AuiTW6F7c-QvHrBgMxsps-aF6rX7NugeB', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.873696', 'Learning from 2 items.', 918),
('XwWDZXyqQdk-kYNAYCrX9Lo-grbheNkxFNo-KVerxeo7Yj', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.874726', 'Splitting raw data into test/train data. Testing with 0 entries', 919),
('9LuURsjJVhR-AJx2rPsc6jM-S4TYc9b8HK2-ywk9WXvZwo9', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:14.915584', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 920),
('7RJkb6ANAB7-Qf88oFHtWLn-HQgi9uUm6pq-epnSg6rxgYJ', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.260879', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier7458987435802725726/model.ser.gz))', 921),
('9boQyAmsPWJ-rTMuQ1npkbw-bPmjS2dMH52-UYyUy1ELHh5', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.285037', 'Storing new trained model for: correspondentorg', 922),
('GjkmVgHQakz-pG2TYBNkxLo-pNbM8UF12Xr-AbdqHgCPYxL', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.37327', 'New model stored at file Fi8t9zhK4oj-qAUuNjvvkkk-8rdDiFgg7Cs-GY5ku8ArwUM', 923),
('i9dpvTsGnNe-k1VfakG8sJg-sz9n5jmok88-cDfpNPQrPF', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.3744', 'Deleting old model file DvCJfFaQPg7-kUGLnaQHzne-PBimJB7xhmM-bEwRthwX6BA', 924),
('9UX1iUrpgv2-PEd4MBYeMsy-DvvVVRsLPLu-EfZwPHMZHcH', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:15.39873', 'Learn classifier correspondentperson', 925),
('FSbYMdqZy73-iZRDYZaAqKw-PQiPqZ4gDVH-ZM8vFetyuqo', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.459494', 'Learning from 2 items.', 926),
('7HmKWwwWmBT-SGgddwMkXLr-KhDf1YgG5eK-mmpx3XjW8KP', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.460459', 'Splitting raw data into test/train data. Testing with 0 entries', 927),
('4nQkzHKFYWE-RSLkNp1Xiim-A3HR1BQfRSz-34iFWquBg1K', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.485365', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 928),
('6LrEGYFxuGM-QYp7F8qLP2s-9Z35MUhmu5V-WtdmAA47xye', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.790386', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier15895265564062830446/model.ser.gz))', 929),
('4atxtaVYJLx-BN5meHctZwE-TnEdThzVUx1-afhXoFPHh6b', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.806281', 'Storing new trained model for: correspondentperson', 930),
('45KLsgcgD8M-QnaBaJmN5Rg-KmqPhki2YRy-F5cw6L8cgbX', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.873332', 'New model stored at file 5VXHZhGz7UQ-x7rN8GNmhFP-bneB7vgdkEo-gEcwXC9XBPJ', 931),
('HAXoG4jopB3-yDsMDvigKge-yCNB8mtV2Gq-fNVA3dhqMEC', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.874466', 'Deleting old model file 6aJE33njUhc-8pr17PhsAZ7-jbnsBFZe9hk-Uetu6mWJSEU', 932),
('CWmj6XkcaDd-ie4Td5aGKjV-95v7AQQENcu-jpcMpVK9vsa', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:15.899483', 'Learn classifier concernedperson', 933);       
INSERT INTO "public"."joblog" VALUES
('3XQQkN7ncvs-StBLvAN3WQx-vSv42BbePeT-QWFV9VzsZ72', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.943902', 'Learning from 2 items.', 934),
('BNv13jbGDGY-p5xczttFFWg-mSY1gEaYhW8-WykJQEDApew', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.944837', 'Splitting raw data into test/train data. Testing with 0 entries', 935),
('Cta9ksXwbwm-HGscNbFQt3k-mLzEooaWaNn-aecnsdprtmt', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:15.984414', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 936),
('EKC4R2fQJBF-SAXyC7agHV6-E2oksvP3nwD-hsf4PRwYJc7', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.153429', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier17449574376311259573/model.ser.gz))', 937),
('9SB8xSHUCU5-8kLctw4R1SR-yMYuwJMUC1K-9y95QdWcYDi', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.176667', 'Storing new trained model for: concernedperson', 938),
('4KUt3uba89L-mHhkthyHsP5-qCQncbGF5Cy-R76sp75bWPJ', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.251777', 'New model stored at file 39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', 939),
('35qBXegG3FR-7gYRxJLpX93-yZo5W8VzsX9-HL3gTUa3g5x', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.252893', 'Deleting old model file hmVrCPHkP3K-M43aQaxRHCQ-Vk3ZaTGmhc8-mNn2VE9Wr5', 940),
('E7m44uEQBMd-khGHGHuJv2B-58rdcdBUX4w-sCk8mtv2QZY', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:16.27612', 'Learn classifier concernedequip', 941),
('6Vr7SFaPNGd-rfRhgvAjhUv-koMm3zMuZ2q-CoU7kMnvtXT', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.326988', 'Learning from 2 items.', 942),
('AjJFdUc5JuE-ks65zZoFbJf-XRSxT5aDEzp-C82CnWC2XfN', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.327892', 'Splitting raw data into test/train data. Testing with 0 entries', 943),
('AhUzTQncQB8-DZ2C9aZ5omX-qjnmtTMVk2y-mH9vY1L1rHX', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.363653', 'Training classifier from HashMap(maxNGramLeng -> 4, useSplitPrefixSuffixNGrams -> true, splitWordsTokenizerRegexp -> [\p{L}][\p{L}0-9]*|(?:\$ ?)?[0-9]+(?:\.[0-9]{2})?%?|\s+|., splitWordsIgnoreRegexp -> \s+, intern -> true, splitWordShape -> chris4, minNGramLeng -> 1, useSplitWords -> true)', 944),
('4TmyH3QroPh-1gegqCgoZca-AHMxNyzmGQM-i6CcLR4fe3h', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.422069', 'Trained with result TrainResult(NaN,ClassifierModel(/tmp/docspell-analysis/trainclassifier7340285168898578303/model.ser.gz))', 945),
('AskthFvzDVp-u23i5PPhad6-3H4yohxLRi3-Q6dwUmrf1vx', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.435078', 'Storing new trained model for: concernedequip', 946),
('6mKv5xDurf2-KakGfBTVTni-jaD9sYLpUc6-bntKcbg4ysv', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.492124', 'New model stored at file DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', 947),
('DxLVNManycZ-Mtj81qNrA91-37quvqwDm4k-PaXhnrmCpWA', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'debug', TIMESTAMP '2021-07-13 21:03:16.493361', 'Deleting old model file 26fGPjLcULK-kJcCShWqVMH-VwNpAmWoJwS-RGSECJamcDc', 948),
('FbpEcwGeiDk-YeGtfZGXN1z-D8uJpcVSH7i-BWeuG2hVb71', '8EnpPkCQCz5-KKDchNWRfFd-h5K7Zt7ASLM-eDn6bTBoqMm', 'info', TIMESTAMP '2021-07-13 21:03:16.620121', 'Job execution successful', 949),
('Ez2P1TLP6VM-HC466n72Muq-FUk2URP47UQ-7h1unjLiafF', '7YcLoh51xm1-gz2F4V2eTmg-yf1wHP3Ummg-uvu32P3ReVz', 'info', TIMESTAMP '2021-07-13 21:03:16.710604', 'Generating previews for attachments', 950);    
INSERT INTO "public"."joblog" VALUES
('3gW1w7XHxxw-FxBfS6ekzZ4-ecwUkqHLhWW-WTnB8NaK6Cu', '7YcLoh51xm1-gz2F4V2eTmg-yf1wHP3Ummg-uvu32P3ReVz', 'info', TIMESTAMP '2021-07-13 21:03:16.772449', 'Submitted 0 jobs', 951),
('C7mKXrQwVQ7-A84mvh5VWdN-aRh7jokG7Lg-hn6yATKL9kX', '7YcLoh51xm1-gz2F4V2eTmg-yf1wHP3Ummg-uvu32P3ReVz', 'info', TIMESTAMP '2021-07-13 21:03:16.829303', 'Job execution successful', 952),
('Aq2MeeHRZhD-qG6DU7RB98Z-oghcT7vmJ9W-TCmXkvUh1NQ', 'ANZUrGEdwd7-etAxe85BdqR-y22w4b4CbYE-Lzzx71gbwRa', 'info', TIMESTAMP '2021-07-13 21:03:16.930894', 'Generating previews for attachments', 953),
('FbeKfTxbJ1V-7T6bCpWagTU-EQLGDKKS83H-KiAhB8BYCV6', 'ANZUrGEdwd7-etAxe85BdqR-y22w4b4CbYE-Lzzx71gbwRa', 'info', TIMESTAMP '2021-07-13 21:03:16.97891', 'Submitted 0 jobs', 954),
('4U7xnfyfsWG-scXfJV8pvuU-dxNr5Sr1Mbf-vVbBC1DLah1', 'ANZUrGEdwd7-etAxe85BdqR-y22w4b4CbYE-Lzzx71gbwRa', 'info', TIMESTAMP '2021-07-13 21:03:17.015671', 'Job execution successful', 955),
('HistRuv4Fnk-igZQPCUSD9s-trfQgAijgfn-DUvMcFaB8p4', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:06:04.518302', 'Running full-text-index migrations now', 967),
('7DCuB1N8JTv-Lt4DYHkNYhv-XUQPuEziZNN-Tn8YC96QmBx', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:06:06.305316', 'Apply 0/Delete all data', 968),
('GUNdEXZd75A-KVEH2HLWZMo-Kyk1QfdBQqk-u4Ky6cAGrqJ', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'info', TIMESTAMP '2021-07-13 21:06:06.450174', 'Apply 1/Initialize', 969),
('3osmuypnNRz-r3TMEYNhSr2-geJJfCJm8RE-dGXs9mNCGAt', '4MUuvPDJkc9-PUiL2p1v3rM-jsAH4LB7kK5-3b3QPWodt1c', 'error', TIMESTAMP '2021-07-13 21:06:08.478863', 'Job 4MUuvPDJk.../docspell-system/full-text-index/Low execution failed. Retrying later.: unexpected HTTP status: 400 Bad Request', 970),
('5paQhBojuTE-NsSJYPJiUSu-RvLKKNMX8q2-UX49bNP6J1', 'Fb6p5jSp6Xg-hSw4kYdk9gB-hSQFML94yzP-FLxtPWufche', 'info', TIMESTAMP '2021-07-13 21:06:08.59685', 'Generating previews for attachments', 971),
('56dsyh7MJEQ-QNT61H1rzjK-Cf6Y5SNfJC2-bL2o5oBqam5', 'Fb6p5jSp6Xg-hSw4kYdk9gB-hSQFML94yzP-FLxtPWufche', 'info', TIMESTAMP '2021-07-13 21:06:08.685079', 'Submitted 0 jobs', 972),
('ghJgH8ynXFJ-YPJrkvA5szf-gzsvyUoqHPZ-qkyFd5tWbj', 'Fb6p5jSp6Xg-hSw4kYdk9gB-hSQFML94yzP-FLxtPWufche', 'info', TIMESTAMP '2021-07-13 21:06:08.959132', 'Job execution successful', 973),
('3uHj6sDTDwX-Hjk6Dej2FWd-pBemb8j6DfM-rhC6P9asvj3', '8HEvkXhpQPF-vswPxVSYdVP-fBcsCh6bCmk-vaaCguTKpWU', 'info', TIMESTAMP '2021-07-13 21:06:09.067886', 'Generating previews for attachments', 974),
('BBs6to96VHZ-4zr7ZPdztKL-HBoaftmqReY-MM1njyjcLBb', '8HEvkXhpQPF-vswPxVSYdVP-fBcsCh6bCmk-vaaCguTKpWU', 'info', TIMESTAMP '2021-07-13 21:06:09.126876', 'Submitted 0 jobs', 975),
('7fF3dSegsV2-nYAZd8pnFUM-efwZAJ1skr4-TDiJLZpsHFG', '8HEvkXhpQPF-vswPxVSYdVP-fBcsCh6bCmk-vaaCguTKpWU', 'info', TIMESTAMP '2021-07-13 21:06:09.173384', 'Job execution successful', 976);        
CREATE CACHED TABLE "public"."attachment_source"(
    "id" VARCHAR(254) NOT NULL,
    "file_id" VARCHAR(254) NOT NULL,
    "filename" VARCHAR(254),
    "created" TIMESTAMP NOT NULL
);        
ALTER TABLE "public"."attachment_source" ADD CONSTRAINT "public"."CONSTRAINT_69" PRIMARY KEY("id");            
-- 2 +/- SELECT COUNT(*) FROM public.attachment_source;        
INSERT INTO "public"."attachment_source" VALUES
('2ecoA7A7HgT-xPwzNQYfiZd-rF1XF3aEPMr-qsNJXoe36oZ', 'DtG18bCtiGr-fGEwzMKktpB-tosSKp9g7ty-wDgXGffbp1f', 'wordpress-pdf-invoice-plugin-sample.pdf', TIMESTAMP '2021-01-03 21:13:33.416'),
('4SDQngEFYuK-tb9xAachZSt-LNCrE36NFRr-U8avxFCW9A4', 'JXziW35E2TW-zXPFxZeeNwA-M1fcdXMEdAL-FVYEyKNC7N', 'letter-en.pdf', TIMESTAMP '2021-01-03 21:34:43.9');             
CREATE CACHED TABLE "public"."client_settings"(
    "id" VARCHAR(254) NOT NULL,
    "client_id" VARCHAR(254) NOT NULL,
    "user_id" VARCHAR(254) NOT NULL,
    "settings_data" TEXT NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "updated" TIMESTAMP NOT NULL
);           
ALTER TABLE "public"."client_settings" ADD CONSTRAINT "public"."CONSTRAINT_E" PRIMARY KEY("id");               
-- 1 +/- SELECT COUNT(*) FROM public.client_settings;          
INSERT INTO "public"."client_settings" VALUES
('JAX2ZTZsv6m-aTkj5aSfNjK-VTRkbN7o8QN-XfLNRdd7a8P', 'webClient', 'Bx213P591Rr-enoBUH66pTn-81emkqRGdQj-XNxT85q7YM5', '{"itemSearchPageSize":60,"tagCategoryColors":{"doctype":"yellow","state":"green"},"nativePdfPreview":true,"itemSearchNoteLength":0,"itemDetailNotesPosition":"bottom","searchMenuFolderCount":3,"searchMenuTagCount":6,"searchMenuTagCatCount":3,"formFields":["concequip","concperson","corrorg","corrperson","customfields","date","direction","duedate","folder","preview","sourcename","tag"],"itemDetailShortcuts":false,"searchMenuVisible":false,"editMenuVisible":false,"cardPreviewSize":"medium","cardTitleTemplate":"{{name}}","cardSubtitleTemplate":"{{dateLong}}","searchStatsVisible":true,"cardPreviewFullWidth":false,"uiTheme":"Dark","sideMenuVisible":true,"powerSearchEnabled":true,"uiLang":"gb"}', TIMESTAMP '2021-05-29 14:03:42.867883', TIMESTAMP '2021-05-29 14:04:52.065916');  
CREATE CACHED TABLE "public"."attachment_archive"(
    "id" VARCHAR(254) NOT NULL,
    "file_id" VARCHAR(254) NOT NULL,
    "filename" VARCHAR(254),
    "message_id" VARCHAR(254),
    "created" TIMESTAMP NOT NULL
);        
ALTER TABLE "public"."attachment_archive" ADD CONSTRAINT "public"."CONSTRAINT_13" PRIMARY KEY("id");           
-- 0 +/- SELECT COUNT(*) FROM public.attachment_archive;       
CREATE INDEX "public"."attachment_archive_message_id_idx" ON "public"."attachment_archive"("message_id");      
CREATE CACHED TABLE "public"."collective"(
    "cid" VARCHAR(254) NOT NULL,
    "state" VARCHAR(254) NOT NULL,
    "doclang" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "integration_enabled" BOOLEAN NOT NULL
);            
ALTER TABLE "public"."collective" ADD CONSTRAINT "public"."CONSTRAINT_9" PRIMARY KEY("cid");   
-- 1 +/- SELECT COUNT(*) FROM public.collective;               
INSERT INTO "public"."collective" VALUES
('demo', 'active', 'deu', TIMESTAMP '2021-01-03 21:13:16.146', TRUE); 
CREATE CACHED TABLE "public"."folder_member"(
    "id" VARCHAR(254) NOT NULL,
    "folder_id" VARCHAR(254) NOT NULL,
    "user_id" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL
);  
ALTER TABLE "public"."folder_member" ADD CONSTRAINT "public"."CONSTRAINT_BD" PRIMARY KEY("id");
-- 0 +/- SELECT COUNT(*) FROM public.folder_member;            
CREATE CACHED TABLE "public"."item"(
    "itemid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "itemdate" TIMESTAMP,
    "source" VARCHAR(254) NOT NULL,
    "incoming" BOOLEAN NOT NULL,
    "state" VARCHAR(254) NOT NULL,
    "corrorg" VARCHAR(254),
    "corrperson" VARCHAR(254),
    "concperson" VARCHAR(254),
    "concequipment" VARCHAR(254),
    "inreplyto" VARCHAR(254),
    "duedate" TIMESTAMP,
    "notes" TEXT,
    "created" TIMESTAMP NOT NULL,
    "updated" TIMESTAMP NOT NULL,
    "folder_id" VARCHAR(254)
);         
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_31" PRIMARY KEY("itemid");     
-- 2 +/- SELECT COUNT(*) FROM public.item;     
INSERT INTO "public"."item" VALUES
('J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', 'demo', 'wordpress-pdf-invoice-plugin-sample.pdf', TIMESTAMP '2016-01-25 12:00:00', 'webapp', TRUE, 'confirmed', 'Gu3ufBQNyco-TqVjyREXNpJ-f4j9VCdyYoR-TNgUkiQXR1Y', NULL, NULL, NULL, NULL, NULL, NULL, TIMESTAMP '2021-01-03 21:13:33.41', TIMESTAMP '2021-01-03 21:34:33.901', NULL),
('2wKtSUVt3Kj-mAmexmm1jFe-BU6aY6PN4vo-5cpaDD2EyRm', 'demo', 'letter-en.pdf', TIMESTAMP '2019-09-03 12:00:00', 'webapp', TRUE, 'confirmed', '85CGijc6q6q-Vj1dZXCPGcK-rpDK7MKVrRz-xyNsSbEbuJy', '83XuNaLvbMt-E3ocm83uYtt-VoLgToV7gxz-rYhG6ZDZmB6', '2vhk349kjyK-LYQWRjTPLro-E4hCRgJyGC3-BMqG3bcVw4y', NULL, NULL, NULL, NULL, TIMESTAMP '2021-01-03 21:34:43.896', TIMESTAMP '2021-01-03 21:35:05.565', NULL);    
CREATE CACHED TABLE "public"."classifier_model"(
    "id" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "file_id" VARCHAR(254) NOT NULL,
    "created" TIMESTAMP NOT NULL
);   
ALTER TABLE "public"."classifier_model" ADD CONSTRAINT "public"."CONSTRAINT_BC" PRIMARY KEY("id");             
-- 5 +/- SELECT COUNT(*) FROM public.classifier_model;         
INSERT INTO "public"."classifier_model" VALUES
('df9dd2a4-23d1-4727-a259-fce6b2f1252a', 'demo', 'tagcategory-doctype', '8Zqe9ujkK9F-x8su5twLT6Q-N45WGGTmjzk-cf5xbFP9TDK', TIMESTAMP '2021-07-13 21:03:14.560739'),
('4D6VMFtxUYT-B2p4B3aQVwE-EGYfXnCKVCQ-76EXUmQ2RPi', 'demo', 'correspondentorg', 'Fi8t9zhK4oj-qAUuNjvvkkk-8rdDiFgg7Cs-GY5ku8ArwUM', TIMESTAMP '2021-07-13 21:03:15.366308'),
('A4rNLv9rETC-BdE13jCzhSA-CtApbFhk9zz-8HpjGSf4Gtw', 'demo', 'correspondentperson', '5VXHZhGz7UQ-x7rN8GNmhFP-bneB7vgdkEo-gEcwXC9XBPJ', TIMESTAMP '2021-07-13 21:03:15.866455'),
('EeRCrtyYxLw-sFZSqYQpF2x-xRNYmtpehF5-gnUpF3p677F', 'demo', 'concernedperson', '39fJiyTA5cF-NbFRocgVXsa-8HZq4chnjuj-PtT7VwD4EWV', TIMESTAMP '2021-07-13 21:03:16.246099'),
('7bSotqXw7Rh-JYioDdg7imG-3L2b5gbKrcJ-nHjGjYQo7A2', 'demo', 'concernedequip', 'DHGeDybWtnT-AkD5avn2wTB-RvfFeVguPUu-LDJADAajdSD', TIMESTAMP '2021-07-13 21:03:16.487072');             
CREATE CACHED TABLE "public"."custom_field"(
    "id" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "label" VARCHAR(254),
    "cid" VARCHAR(254) NOT NULL,
    "ftype" VARCHAR(100) NOT NULL,
    "created" TIMESTAMP NOT NULL
);               
ALTER TABLE "public"."custom_field" ADD CONSTRAINT "public"."CONSTRAINT_2A" PRIMARY KEY("id"); 
-- 3 +/- SELECT COUNT(*) FROM public.custom_field;             
INSERT INTO "public"."custom_field" VALUES
('3DUwoSr5hrR-uNPf9VHRyut-1GbBhk98gQr-toVUFGhr3Zu', 'eur', 'EUR', 'demo', 'money', TIMESTAMP '2021-01-03 21:33:29.123'),
('HGU7e4ViYRK-C45csppWGya-JfvqSBK7RHV-hewejitFZLt', 'usd', 'USD', 'demo', 'money', TIMESTAMP '2021-01-03 21:33:38.397'),
('H4GdvuxxiTu-xkrSbSiLEYu-AaEmVaX3T8d-EwNA1fEWzar', 'paid', 'Paid', 'demo', 'date', TIMESTAMP '2021-01-03 21:33:49.783');         
CREATE CACHED TABLE "public"."custom_field_value"(
    "id" VARCHAR(254) NOT NULL,
    "item_id" VARCHAR(254) NOT NULL,
    "field" VARCHAR(254) NOT NULL,
    "field_value" VARCHAR(300) NOT NULL
);          
ALTER TABLE "public"."custom_field_value" ADD CONSTRAINT "public"."CONSTRAINT_6F" PRIMARY KEY("id");           
-- 2 +/- SELECT COUNT(*) FROM public.custom_field_value;       
INSERT INTO "public"."custom_field_value" VALUES
('5mTamR1DWyQ-GnQbNwRN3hA-LhhkXvrLTAp-Rx8kzt5cHFV', 'J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', 'HGU7e4ViYRK-C45csppWGya-JfvqSBK7RHV-hewejitFZLt', '93.50'),
('FRgFi2EJe7E-QHeQwhJJeJu-ddtSXiH3rY7-BFiTLJ52TbK', 'J4wAkg3jxt5-7QaYXD1WTmF-gq4kGaS89RP-DnPyUwa77fK', 'H4GdvuxxiTu-xkrSbSiLEYu-AaEmVaX3T8d-EwNA1fEWzar', '2016-01-28');  
CREATE CACHED TABLE "public"."person"(
    "pid" VARCHAR(254) NOT NULL,
    "cid" VARCHAR(254) NOT NULL,
    "name" VARCHAR(254) NOT NULL,
    "street" VARCHAR(254),
    "zip" VARCHAR(254),
    "city" VARCHAR(254),
    "country" VARCHAR(254),
    "notes" TEXT,
    "created" TIMESTAMP NOT NULL,
    "updated" TIMESTAMP NOT NULL,
    "oid" VARCHAR(254),
    "person_use" VARCHAR(254)
);              
ALTER TABLE "public"."person" ADD CONSTRAINT "public"."CONSTRAINT_C4" PRIMARY KEY("pid");      
-- 2 +/- SELECT COUNT(*) FROM public.person;   
INSERT INTO "public"."person" VALUES
('83XuNaLvbMt-E3ocm83uYtt-VoLgToV7gxz-rYhG6ZDZmB6', 'demo', 'Marcus Leaf', '', '', '', '', NULL, TIMESTAMP '2021-01-03 21:33:10.411', TIMESTAMP '2021-01-03 21:33:10.411', '85CGijc6q6q-Vj1dZXCPGcK-rpDK7MKVrRz-xyNsSbEbuJy', 'correspondent'),
('2vhk349kjyK-LYQWRjTPLro-E4hCRgJyGC3-BMqG3bcVw4y', 'demo', 'Derek Jeter', '', '', '', '', NULL, TIMESTAMP '2021-01-03 21:33:17.323', TIMESTAMP '2021-01-03 21:33:17.323', NULL, 'concerning');
CREATE CACHED TABLE "public"."item_proposal"(
    "itemid" VARCHAR(254) NOT NULL,
    "classifier_proposals" TEXT NOT NULL,
    "classifier_tags" TEXT NOT NULL,
    "created" TIMESTAMP NOT NULL
);           
ALTER TABLE "public"."item_proposal" ADD CONSTRAINT "public"."CONSTRAINT_DBF" PRIMARY KEY("itemid");           
-- 0 +/- SELECT COUNT(*) FROM public.item_proposal;            
CREATE CACHED TABLE "public"."attachmentmeta"(
    "attachid" VARCHAR(254) NOT NULL,
    "content" TEXT,
    "nerlabels" TEXT,
    "itemproposals" TEXT,
    "page_count" SMALLINT,
    "language" VARCHAR(254)
);             
ALTER TABLE "public"."attachmentmeta" ADD CONSTRAINT "public"."CONSTRAINT_1" PRIMARY KEY("attachid");          
-- 2 +/- SELECT COUNT(*) FROM public.attachmentmeta;           
CREATE TABLE IF NOT EXISTS SYSTEM_LOB_STREAM(ID INT NOT NULL, PART INT NOT NULL, CDATA VARCHAR, BDATA BINARY); 
CREATE PRIMARY KEY SYSTEM_LOB_STREAM_PRIMARY_KEY ON SYSTEM_LOB_STREAM(ID, PART);               
CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_CLOB FOR "org.h2.command.dml.ScriptCommand.combineClob";             
CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_BLOB FOR "org.h2.command.dml.ScriptCommand.combineBlob";             
INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 0, '[{"label":"Sliced Invoices | admin@slicedinvoices.com","tag":"misc","startPosition":138,"endPosition":180},{"label":"Page 1/1","tag":"misc","startPosition":182,"endPosition":190},{"label":"Sliced Invoices","tag":"misc","startPosition":206,"endPosition":221},{"label":"Date January","tag":"person","startPosition":359,"endPosition":371},{"label":"Due Date January","tag":"person","startPosition":382,"endPosition":398},{"label":"Total Due $","tag":"misc","startPosition":409,"endPosition":420},{"label":"Price Adjust Sub Total","tag":"misc","startPosition":522,"endPosition":544},{"label":"1.00 Web Design This","tag":"misc","startPosition":546,"endPosition":566},{"label":"Sub Total $","tag":"misc","startPosition":616,"endPosition":627},{"label":"Tax $","tag":"misc","startPosition":634,"endPosition":639},{"label":"ANZ Bank","tag":"organization","startPosition":659,"endPosition":667},{"label":"Pa id","tag":"misc","startPosition":701,"endPosition":706},{"label":"PDF Invoice Example Sliced","tag":"misc","startPosition":708,"endPosition":734},{"label":"Sliced","tag":"misc","startPosition":138,"endPosition":144},{"label":"Invoices","tag":"misc","startPosition":145,"endPosition":153},{"label":"|","tag":"misc","startPosition":154,"endPosition":155},{"label":"admin@slicedinvoices.com","tag":"misc","startPosition":156,"endPosition":180},{"label":"Page","tag":"misc","startPosition":182,"endPosition":186},{"label":"1/1","tag":"misc","startPosition":187,"endPosition":190},{"label":"From","tag":"misc","startPosition":192,"endPosition":196},{"label":"Sliced","tag":"misc","startPosition":206,"endPosition":212},{"label":"Invoices","tag":"misc","startPosition":213,"endPosition":221},{"label":"Suite","tag":"misc","startPosition":223,"endPosition":228},{"label":"Street","tag":"organization","startPosition":252,"endPosition":258},{"label":"Your","tag":"organization","startPosition":260,"endPosition":264},{"label":"Date","tag":"person","startPosition":359,"endPosition":363},{"label":"January","tag":"person","startPosition":364,"endPosition":371},{"label":"Due","tag":"person","startPosition":382,"endPosition":385},{"label":"Date","tag":"person","startPosition":386,"endPosition":390},{"label":"January","tag":"person","startPosition":391,"endPosition":398},{"label":"Total","tag":"misc","startPosition":409,"endPosition":414},{"label":"Due","tag":"misc","startPosition":415,"endPosition":418},{"label":"$","tag":"misc","startPosition":419,"endPosition":420},{"label":"St","tag":"location","startPosition":461,"endPosition":463},{"label":"Melbourne","tag":"location","startPosition":465,"endPosition":474},{"label":"Price","tag":"misc","startPosition":522,"endPosition":527},{"label":"Adjust","tag":"misc","startPosition":528,"endPosition":534},{"label":"Sub","tag":"misc","startPosition":535,"endPosition":538},{"label":"Total","tag":"misc","startPosition":539,"endPosition":544},{"label":"1.00","tag":"misc","startPosition":546,"endPosition":550},{"label":"Web","tag":"misc","startPosition":551,"endPosition":554},{"label":"Design","tag":"misc","startPosition":555,"endPosition":561},{"label":"This","tag":"misc","startPosition":562,"endPosition":566},{"label":"$","tag":"misc","startPosition":595,"endPosition":596},{"label":"$","tag":"misc","startPosition":608,"endPosition":609},{"label":"85.00","tag":"misc","startPosition":609,"endPosition":614},{"label":"Sub","tag":"misc","startPosition":616,"endPosition":619},{"label":"Total","tag":"misc","startPosition":620,"endPosition":625},{"label":"$","tag":"misc","startPosition":626,"endPosition":627},{"label":"85.00","tag":"misc","startPosition":627,"endPosition":632},{"label":"Tax","tag":"misc","startPosition":634,"endPosition":637},{"label":"$","tag":"misc","startPosition":638,"endPosition":639},{"label":"$","tag":"misc","startPosition":651,"endPosition":652},{"label":"ANZ","tag":"organization","startPosition":659,"endPosition":662},{"label":"Bank","tag":"organization","startPosition":663,"endPosition":667},{"label":"ACC","tag":"organization","startPosition":669,"endPosition":672},{"label":"Pa","tag":"misc","startPosition":7', NULL);          
INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 1, '01,"endPosition":703},{"label":"id","tag":"misc","startPosition":704,"endPosition":706},{"label":"PDF","tag":"misc","startPosition":708,"endPosition":711},{"label":"Invoice","tag":"misc","startPosition":712,"endPosition":719},{"label":"Example","tag":"misc","startPosition":720,"endPosition":727},{"label":"Sliced","tag":"misc","startPosition":728,"endPosition":734},{"label":"admin@slicedinvoices.com","tag":"email","startPosition":156,"endPosition":180},{"label":"admin@slicedinvoices.com","tag":"email","startPosition":280,"endPosition":304},{"label":"test@test.com","tag":"email","startPosition":486,"endPosition":499},{"label":"2016-01-25","tag":"date","startPosition":364,"endPosition":374},{"label":"2016-01-31","tag":"date","startPosition":391,"endPosition":401}]', NULL);       
INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 0, '[{"label":"Derek Jeter","tag":"person","startPosition":0,"endPosition":11},{"label":"Derek Jeter","tag":"person","startPosition":69,"endPosition":80},{"label":"M. Leaf","tag":"person","startPosition":142,"endPosition":149},{"label":"Syrup Production","tag":"organization","startPosition":160,"endPosition":176},{"label":"Old Sticky Pancake Company","tag":"organization","startPosition":178,"endPosition":204},{"label":"456 Maple Lane","tag":"organization","startPosition":206,"endPosition":220},{"label":"Let me begin by thanking you for your past contributions to our Little League baseball","tag":"misc","startPosition":287,"endPosition":373},{"label":"their past years of service and present employees for their","tag":"organization","startPosition":621,"endPosition":680},{"label":"Derek Jeter","tag":"person","startPosition":1128,"endPosition":1139},{"label":"Derek Jeter","tag":"person","startPosition":1141,"endPosition":1152},{"label":"Derek","tag":"person","startPosition":0,"endPosition":5},{"label":"Jeter","tag":"person","startPosition":6,"endPosition":11},{"label":"Elm","tag":"location","startPosition":17,"endPosition":20},{"label":"Derek","tag":"person","startPosition":69,"endPosition":74},{"label":"Jeter","tag":"person","startPosition":75,"endPosition":80},{"label":"Elm","tag":"location","startPosition":86,"endPosition":89},{"label":"M.","tag":"person","startPosition":142,"endPosition":144},{"label":"Leaf","tag":"person","startPosition":145,"endPosition":149},{"label":"Syrup","tag":"organization","startPosition":160,"endPosition":165},{"label":"Production","tag":"organization","startPosition":166,"endPosition":176},{"label":"Old","tag":"organization","startPosition":178,"endPosition":181},{"label":"Sticky","tag":"organization","startPosition":182,"endPosition":188},{"label":"Pancake","tag":"organization","startPosition":189,"endPosition":196},{"label":"Company","tag":"organization","startPosition":197,"endPosition":204},{"label":"456","tag":"organization","startPosition":206,"endPosition":209},{"label":"Maple","tag":"organization","startPosition":210,"endPosition":215},{"label":"Lane","tag":"organization","startPosition":216,"endPosition":220},{"label":"Forest","tag":"organization","startPosition":222,"endPosition":228},{"label":"Leaf","tag":"person","startPosition":280,"endPosition":284},{"label":"Let","tag":"misc","startPosition":287,"endPosition":290},{"label":"me","tag":"misc","startPosition":291,"endPosition":293},{"label":"begin","tag":"misc","startPosition":294,"endPosition":299},{"label":"by","tag":"misc","startPosition":300,"endPosition":302},{"label":"thanking","tag":"misc","startPosition":303,"endPosition":311},{"label":"you","tag":"misc","startPosition":312,"endPosition":315},{"label":"for","tag":"misc","startPosition":316,"endPosition":319},{"label":"your","tag":"misc","startPosition":320,"endPosition":324},{"label":"past","tag":"misc","startPosition":325,"endPosition":329},{"label":"contributions","tag":"misc","startPosition":330,"endPosition":343},{"label":"to","tag":"misc","startPosition":344,"endPosition":346},{"label":"our","tag":"misc","startPosition":347,"endPosition":350},{"label":"Little","tag":"misc","startPosition":351,"endPosition":357},{"label":"League","tag":"misc","startPosition":358,"endPosition":364},{"label":"baseball","tag":"misc","startPosition":365,"endPosition":373},{"label":"team","tag":"misc","startPosition":375,"endPosition":379},{"label":"company","tag":"organization","startPosition":524,"endPosition":531},{"label":"pancake","tag":"organization","startPosition":569,"endPosition":576},{"label":"their","tag":"organization","startPosition":621,"endPosition":626},{"label":"past","tag":"organization","startPosition":627,"endPosition":631},{"label":"years","tag":"organization","startPosition":632,"endPosition":637},{"label":"of","tag":"organization","startPosition":638,"endPosition":640},{"label":"service","tag":"organization","startPosition":641,"endPosition":648},{"label":"and","tag":"organization","startPosition":649,"endPosition":652},{"label":"present","tag":"organization","startPosit', NULL);          
INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 1, 'ion":653,"endPosition":660},{"label":"employees","tag":"organization","startPosition":661,"endPosition":670},{"label":"for","tag":"organization","startPosition":671,"endPosition":674},{"label":"their","tag":"organization","startPosition":675,"endPosition":680},{"label":"loyalty","tag":"organization","startPosition":682,"endPosition":689},{"label":"company","tag":"organization","startPosition":803,"endPosition":810},{"label":"pancake","tag":"organization","startPosition":828,"endPosition":835},{"label":"Derek","tag":"person","startPosition":1128,"endPosition":1133},{"label":"Jeter","tag":"person","startPosition":1134,"endPosition":1139},{"label":"Derek","tag":"person","startPosition":1141,"endPosition":1146},{"label":"Jeter","tag":"person","startPosition":1147,"endPosition":1152},{"label":"2016-11-07","tag":"date","startPosition":51,"endPosition":61},{"label":"2016-11-07","tag":"date","startPosition":120,"endPosition":130},{"label":"2019-09-03","tag":"date","startPosition":252,"endPosition":263},{"label":"2016-12-12","tag":"date","startPosition":1087,"endPosition":1098}]', NULL);            
INSERT INTO "public"."attachmentmeta" VALUES
('2ecoA7A7HgT-xPwzNQYfiZd-rF1XF3aEPMr-qsNJXoe36oZ', STRINGDECODE('Invoice\n\nPayment is due within 30 days from date of invoice. Late payment is subject to fees of 5% per month.\n\nThanks for choosing DEMO - Sliced Invoices | admin@slicedinvoices.com\n\nPage 1/1\n\nFrom:\n\nDEMO - Sliced Invoices\n\nSuite 5A-1204\n\n123 Somewhere Street\n\nYour City AZ 12345\n\nadmin@slicedinvoices.com\n\nInvoice Number INV-3337\n\nOrder Number 12345\n\nInvoice Date January 25, 2016\n\nDue Date January 31, 2016\n\nTotal Due $93.50\n\nTo:\n\nTest Business\n\n123 Somewhere St\n\nMelbourne, VIC 3000\n\ntest@test.com\n\nHrs/Qty Service Rate/Price Adjust Sub Total\n\n1.00\nWeb Design\nThis is a sample description...\n\n$85.00 0.00% $85.00\n\nSub Total $85.00\n\nTax $8.50\n\nTotal $93.50\n\nANZ Bank\n\nACC # 1234 1234\n\nBSB # 4321 432 Pa\nid\n\nPDF Invoice Example\nSliced Invoices\nExample PDF invoice that was created using the Sli\n2016-02-04'), SYSTEM_COMBINE_CLOB(0), '{"proposals":[{"proposalType":"docdate","values":[{"ref":{"id":"2016-01-25","name":"2016-01-25"},"origin":[{"label":"January 25, 2016","tag":"date","startPosition":364,"endPosition":374}],"weight":0.0753623188405797},{"ref":{"id":"2016-01-31","name":"2016-01-31"},"origin":[{"label":"January 31, 2016","tag":"date","startPosition":391,"endPosition":401}],"weight":0.08095238095238094}]}]}', 1, 'deu'),
('4SDQngEFYuK-tb9xAachZSt-LNCrE36NFRr-U8avxFCW9A4', STRINGDECODE('Derek Jeter\n\n123 Elm Ave.\n\nTreesville, ON M1N 2P3\n\nNovember 7, 2016\n\nDerek Jeter, 123 Elm Ave., Treesville, ON M1N 2P3, November 7, 2016\n\nMr. M. Leaf\n\nChief of Syrup Production\n\nOld Sticky Pancake Company\n\n456 Maple Lane\n\nForest, ON 7W8 9Y0\n\nHemptown, September 3, 2019\n\nDear Mr. Leaf,\n\nLet me begin by thanking you for your past contributions to our Little League baseball\n\nteam. Your sponsorship aided in the purchase of ten full uniforms and several pieces of\n\nbaseball equipment for last year\u2019s season.\n\nNext month, our company is planning an employee appreciation pancake breakfast hon-\n\noring retired employees for their past years of service and present employees for their\n\nloyalty and dedication in spite of the current difficult economic conditions.\n\nWe would like to place an order with your company for 25 pounds of pancake mix and\n\nfive gallons of maple syrup. We hope you will be able to provide these products in the\n\nbulk quantities we require.\n\nAs you are a committed corporate sponsor and long-time associate, we hope that you\n\nwill be able to join us for breakfast on December 12, 2016.\n\nRespectfully yours,\n\nDerek Jeter\n\nDerek Jeter\n2019-09-03'), SYSTEM_COMBINE_CLOB(1), '{"proposals":[{"proposalType":"corrperson","values":[{"ref":{"id":"83XuNaLvbMt-E3ocm83uYtt-VoLgToV7gxz-rYhG6ZDZmB6","name":"Marcus Leaf"},"origin":[{"label":"Leaf","tag":"person","startPosition":145,"endPosition":149}],"weight":0.024935511607910577}]},{"proposalType":"corrorg","values":[{"ref":{"id":"85CGijc6q6q-Vj1dZXCPGcK-rpDK7MKVrRz-xyNsSbEbuJy","name":"Pancake Company"},"origin":[{"label":"Company","tag":"organization","startPosition":197,"endPosition":204},{"label":"Pancake","tag":"organization","startPosition":189,"endPosition":196}],"weight":0.03250214961306965}]},{"proposalType":"concperson","values":[{"ref":{"id":"2vhk349kjyK-LYQWRjTPLro-E4hCRgJyGC3-BMqG3bcVw4y","name":"Derek Jeter"},"origin":[{"label":"Derek Jeter","tag":"person","startPosition":0,"endPosition":11}],"weight":0.0}]},{"proposalType":"docdate","values":[{"ref":{"id":"2016-11-07","name":"2016-11-07"},"origin":[{"label":"November 7, 2016","tag":"date","startPosition":51,"endPosition":61}],"weight":0.007308684436801376},{"ref":{"id":"2016-11-07","name":"2016-11-07"},"origin":[{"label":"November 7, 2016","tag":"date","startPosition":120,"endPosition":130}],"weight":0.017196904557179708},{"ref":{"id":"2019-09-03","name":"2019-09-03"},"origin":[{"label":"September 3, 2019","tag":"date","startPosition":252,"endPosition":263}],"weight":0.03611349957007738},{"ref":{"id":"2016-12-12","name":"2016-12-12"},"origin":[{"label":"December 12, 2016","tag":"date","startPosition":1087,"endPosition":1098}],"weight":0.3115505875609057}]}]}', 1, 'deu');
CREATE CACHED TABLE "public"."classifier_setting"(
    "cid" VARCHAR(254) NOT NULL,
    "schedule" VARCHAR(254) NOT NULL,
    "item_count" INT NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "categories" TEXT NOT NULL,
    "category_list_type" VARCHAR(254) NOT NULL
);   
ALTER TABLE "public"."classifier_setting" ADD CONSTRAINT "public"."CONSTRAINT_B9" PRIMARY KEY("cid");          
-- 1 +/- SELECT COUNT(*) FROM public.classifier_setting;       
INSERT INTO "public"."classifier_setting" VALUES
('demo', '*-01/3-01 01:00:00', 0, TIMESTAMP '2021-01-03 21:35:17.933', '["doctype"]', 'whitelist');           
CREATE CACHED TABLE "public"."periodic_task"(
    "id" VARCHAR(254) NOT NULL,
    "enabled" BOOLEAN NOT NULL,
    "task" VARCHAR(254) NOT NULL,
    "group_" VARCHAR(254) NOT NULL,
    "args" TEXT NOT NULL,
    "subject" VARCHAR(254) NOT NULL,
    "submitter" VARCHAR(254) NOT NULL,
    "priority" INT NOT NULL,
    "worker" VARCHAR(254),
    "marked" TIMESTAMP,
    "timer" VARCHAR(254) NOT NULL,
    "nextrun" TIMESTAMP NOT NULL,
    "created" TIMESTAMP NOT NULL,
    "summary" VARCHAR(254)
); 
ALTER TABLE "public"."periodic_task" ADD CONSTRAINT "public"."CONSTRAINT_2" PRIMARY KEY("id"); 
-- 2 +/- SELECT COUNT(*) FROM public.periodic_task;            
INSERT INTO "public"."periodic_task" VALUES
('docspell-houskeeping', TRUE, 'housekeeping', 'docspell-system', '{}', 'Docspell house-keeping', 'docspell-system', 0, NULL, TIMESTAMP '2021-07-13 21:06:09.222925', 'Sun *-*-* 00:00:00', TIMESTAMP '2021-07-18 00:00:00', TIMESTAMP '2021-01-03 20:49:33.897', NULL),
('CdqeBRkD5Ft-ubJkLhMDTa5-K7k2ix6mqRM-Yu2Y7CGuVK7', TRUE, 'learn-classifier', 'demo', '{"collective":"demo"}', 'learn-classifier: learn-classifier', 'learn-classifier', 0, NULL, TIMESTAMP '2021-07-13 21:02:59.231627', '*-01/3-01 01:00:00', TIMESTAMP '2021-10-01 01:00:00', TIMESTAMP '2021-01-03 21:35:17.958', NULL);              
CREATE INDEX "public"."periodic_task_nextrun_idx" ON "public"."periodic_task"("nextrun");      
CREATE INDEX "public"."periodic_task_worker_idx" ON "public"."periodic_task"("worker");        
CALL SYSTEM_COMBINE_BLOB(-1);  
DROP ALIAS IF EXISTS SYSTEM_COMBINE_CLOB;      
DROP ALIAS IF EXISTS SYSTEM_COMBINE_BLOB;      
ALTER TABLE "public"."tagitem" ADD CONSTRAINT "public"."CONSTRAINT_A3" UNIQUE("itemid", "tid");
ALTER TABLE "public"."custom_field_value" ADD CONSTRAINT "public"."CONSTRAINT_6FD5B" UNIQUE("item_id", "field");               
ALTER TABLE "public"."classifier_model" ADD CONSTRAINT "public"."CONSTRAINT_BC7B9" UNIQUE("cid", "name");      
ALTER TABLE "public"."custom_field" ADD CONSTRAINT "public"."CONSTRAINT_2ACD" UNIQUE("cid", "name");           
ALTER TABLE "public"."tagsource" ADD CONSTRAINT "public"."CONSTRAINT_9E8" UNIQUE("source_id", "tag_id");
ALTER TABLE "public"."client_settings" ADD CONSTRAINT "public"."CONSTRAINT_ECB" UNIQUE("client_id", "user_id");
ALTER TABLE "public"."equipment" ADD CONSTRAINT "public"."equipment_cid_name_key" UNIQUE("cid", "name");       
ALTER TABLE "public"."folder_member" ADD CONSTRAINT "public"."CONSTRAINT_BDD" UNIQUE("folder_id", "user_id");  
ALTER TABLE "public"."folder" ADD CONSTRAINT "public"."CONSTRAINT_B45" UNIQUE("name", "cid");  
ALTER TABLE "public"."source" ADD CONSTRAINT "public"."CONSTRAINT_CA" UNIQUE("cid", "abbrev"); 
ALTER TABLE "public"."equipment" ADD CONSTRAINT "public"."CONSTRAINT_402" UNIQUE("cid", "eid");
ALTER TABLE "public"."tag" ADD CONSTRAINT "public"."CONSTRAINT_1BF" UNIQUE("cid", "name");
ALTER TABLE "public"."person" ADD CONSTRAINT "public"."CONSTRAINT_C4E" UNIQUE("cid", "name");
ALTER TABLE "public"."organization" ADD CONSTRAINT "public"."CONSTRAINT_464" UNIQUE("cid", "name");            
ALTER TABLE "public"."sentmailitem" ADD CONSTRAINT "public"."CONSTRAINT_59" UNIQUE("item_id", "sentmail_id");  
ALTER TABLE "public"."attachment" ADD CONSTRAINT "public"."CONSTRAINT_8A" FOREIGN KEY("itemid") REFERENCES "public"."item"("itemid") NOCHECK;  
ALTER TABLE "public"."classifier_setting" ADD CONSTRAINT "public"."CONSTRAINT_B94" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;         
ALTER TABLE "public"."folder_member" ADD CONSTRAINT "public"."CONSTRAINT_BDDF" FOREIGN KEY("folder_id") REFERENCES "public"."folder"("id") NOCHECK;            
ALTER TABLE "public"."attachment_archive" ADD CONSTRAINT "public"."CONSTRAINT_13E2" FOREIGN KEY("id") REFERENCES "public"."attachment"("attachid") NOCHECK;    
ALTER TABLE "public"."custom_field" ADD CONSTRAINT "public"."CONSTRAINT_2AC" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;               
ALTER TABLE "public"."attachment_source" ADD CONSTRAINT "public"."CONSTRAINT_698" FOREIGN KEY("file_id") REFERENCES "public"."filemeta"("id") NOCHECK;         
ALTER TABLE "public"."tagsource" ADD CONSTRAINT "public"."CONSTRAINT_9E86" FOREIGN KEY("source_id") REFERENCES "public"."source"("sid") NOCHECK;
ALTER TABLE "public"."rememberme" ADD CONSTRAINT "public"."CONSTRAINT_20F" FOREIGN KEY("cid", "login") REFERENCES "public"."user_"("cid", "login") NOCHECK;
ALTER TABLE "public"."folder_member" ADD CONSTRAINT "public"."CONSTRAINT_BDDF3" FOREIGN KEY("user_id") REFERENCES "public"."user_"("uid") NOCHECK;             
ALTER TABLE "public"."custom_field_value" ADD CONSTRAINT "public"."CONSTRAINT_6FD5" FOREIGN KEY("field") REFERENCES "public"."custom_field"("id") NOCHECK;     
ALTER TABLE "public"."tagsource" ADD CONSTRAINT "public"."CONSTRAINT_9E868" FOREIGN KEY("tag_id") REFERENCES "public"."tag"("tid") NOCHECK;    
ALTER TABLE "public"."source" ADD CONSTRAINT "public"."CONSTRAINT_CA9" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;     
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317" FOREIGN KEY("inreplyto") REFERENCES "public"."item"("itemid") NOCHECK;    
ALTER TABLE "public"."contact" ADD CONSTRAINT "public"."CONSTRAINT_38B" FOREIGN KEY("oid") REFERENCES "public"."organization"("oid") NOCHECK;  
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B1" FOREIGN KEY("corrperson") REFERENCES "public"."person"("pid") NOCHECK;  
ALTER TABLE "public"."attachment_source" ADD CONSTRAINT "public"."CONSTRAINT_698C" FOREIGN KEY("id") REFERENCES "public"."attachment"("attachid") NOCHECK;     
ALTER TABLE "public"."custom_field_value" ADD CONSTRAINT "public"."CONSTRAINT_6FD" FOREIGN KEY("item_id") REFERENCES "public"."item"("itemid") NOCHECK;        
ALTER TABLE "public"."classifier_model" ADD CONSTRAINT "public"."CONSTRAINT_BC7B" FOREIGN KEY("file_id") REFERENCES "public"."filemeta"("id") NOCHECK;         
ALTER TABLE "public"."tagitem" ADD CONSTRAINT "public"."CONSTRAINT_A3B" FOREIGN KEY("itemid") REFERENCES "public"."item"("itemid") NOCHECK;    
ALTER TABLE "public"."source" ADD CONSTRAINT "public"."CONSTRAINT_CA90" FOREIGN KEY("folder_id") REFERENCES "public"."folder"("id") NOCHECK;   
ALTER TABLE "public"."sentmail" ADD CONSTRAINT "public"."CONSTRAINT_4B4" FOREIGN KEY("uid") REFERENCES "public"."user_"("uid") NOCHECK;        
ALTER TABLE "public"."attachmentmeta" ADD CONSTRAINT "public"."CONSTRAINT_1F" FOREIGN KEY("attachid") REFERENCES "public"."attachment"("attachid") NOCHECK;    
ALTER TABLE "public"."attachment_archive" ADD CONSTRAINT "public"."CONSTRAINT_13E" FOREIGN KEY("file_id") REFERENCES "public"."filemeta"("id") NOCHECK;        
ALTER TABLE "public"."attachment" ADD CONSTRAINT "public"."CONSTRAINT_8AF" FOREIGN KEY("filemetaid") REFERENCES "public"."filemeta"("id") NOCHECK;             
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B13_2" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;  
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B13_3" FOREIGN KEY("folder_id") REFERENCES "public"."folder"("id") NOCHECK; 
ALTER TABLE "public"."sentmailitem" ADD CONSTRAINT "public"."CONSTRAINT_5905" FOREIGN KEY("sentmail_id") REFERENCES "public"."sentmail"("id") NOCHECK;         
ALTER TABLE "public"."tag" ADD CONSTRAINT "public"."CONSTRAINT_1BF9" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;       
ALTER TABLE "public"."person" ADD CONSTRAINT "public"."CONSTRAINT_C4E3" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;    
ALTER TABLE "public"."folder" ADD CONSTRAINT "public"."CONSTRAINT_B45D1" FOREIGN KEY("owner") REFERENCES "public"."user_"("uid") NOCHECK;      
ALTER TABLE "public"."item_proposal" ADD CONSTRAINT "public"."CONSTRAINT_DBF3" FOREIGN KEY("itemid") REFERENCES "public"."item"("itemid") NOCHECK;             
ALTER TABLE "public"."contact" ADD CONSTRAINT "public"."CONSTRAINT_38" FOREIGN KEY("pid") REFERENCES "public"."person"("pid") NOCHECK;         
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B" FOREIGN KEY("corrorg") REFERENCES "public"."organization"("oid") NOCHECK;
ALTER TABLE "public"."attachment_preview" ADD CONSTRAINT "public"."CONSTRAINT_2D82" FOREIGN KEY("id") REFERENCES "public"."attachment"("attachid") NOCHECK;    
ALTER TABLE "public"."tagitem" ADD CONSTRAINT "public"."CONSTRAINT_A3B5" FOREIGN KEY("tid") REFERENCES "public"."tag"("tid") NOCHECK;          
ALTER TABLE "public"."equipment" ADD CONSTRAINT "public"."CONSTRAINT_4027" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK; 
ALTER TABLE "public"."attachment_preview" ADD CONSTRAINT "public"."CONSTRAINT_2D8" FOREIGN KEY("file_id") REFERENCES "public"."filemeta"("id") NOCHECK;        
ALTER TABLE "public"."person" ADD CONSTRAINT "public"."fk_person_organization" FOREIGN KEY("oid") REFERENCES "public"."organization"("oid") NOCHECK;
ALTER TABLE "public"."classifier_model" ADD CONSTRAINT "public"."CONSTRAINT_BC7" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;           
ALTER TABLE "public"."sentmailitem" ADD CONSTRAINT "public"."CONSTRAINT_590" FOREIGN KEY("item_id") REFERENCES "public"."item"("itemid") NOCHECK;              
ALTER TABLE "public"."folder" ADD CONSTRAINT "public"."CONSTRAINT_B45D" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;    
ALTER TABLE "public"."client_settings" ADD CONSTRAINT "public"."CONSTRAINT_EC" FOREIGN KEY("user_id") REFERENCES "public"."user_"("uid") ON DELETE CASCADE NOCHECK;            
ALTER TABLE "public"."joblog" ADD CONSTRAINT "public"."CONSTRAINT_BB2" FOREIGN KEY("jid") REFERENCES "public"."job"("jid") NOCHECK;            
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B13_0" FOREIGN KEY("concperson") REFERENCES "public"."person"("pid") NOCHECK;               
ALTER TABLE "public"."item" ADD CONSTRAINT "public"."CONSTRAINT_317B13_1" FOREIGN KEY("concequipment") REFERENCES "public"."equipment"("eid") NOCHECK;         
ALTER TABLE "public"."organization" ADD CONSTRAINT "public"."CONSTRAINT_4644" FOREIGN KEY("cid") REFERENCES "public"."collective"("cid") NOCHECK;              
