SQLite format 3@ VTR�V.��6�� G�� E�}m��f�$�'tabledemo1demo1CREATE TABLE `demo1` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY, `title` TEXT DEFAULT '', `updated` TEXT DEFAULT '' NOT NULL))=indexsqlite_autoindex_demo1_1demo1xG�index__pb_users_auth__tokenKey_idxusersCREATE UNIQUE INDEX __pb_users_auth__tokenKey_idx ON `users` (`tokenKey`)�A�;index__pb_users_auth__email_idxusersCREATE UNIQUE INDEX __pb_users_auth__email_idx ON `users` (`email`) WHERE `email` != ''xG�index__pb_users_auth__username_idxusersCREATE UNIQUE INDEX __pb_users_auth__username_idx ON `users` (`username`)pE�index__pb_users_auth__created_idxusersCREATE INDEX `__pb_users_auth__created_idx` ON `users` (`created`)�m�9tableusersusersCREATE TABLE `users` (`avatar` TEXT DEFAULT '', `created` TEXT DEFAULT '' NOT NULL, `email` TEXT DEFAULT '' NOT NULL, `emailVisibility` BOOLEAN DEFAULT FALSE NOT NULL, `id` TEXT PRIMARY KEY, `lastResetSentAt` TEXT DEFAULT '' NOT NULL, `lastVerificationSentAt` TEXT DEFAULT '' NOT NULL, `name` TEXT DEFAULT '', `passwordHash` TEXT NOT NULL, `tokenKey` TEXT NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `username` TEXT NOT NULL, `verified` BOOLEAN DEFAULT FALSE NOT NULL))=indexsqlite_autoindex_users_1users�*Y)�_index_externalAuths_provider_providerId_idx_externalAuthsCREATE UNIQUE INDEX _externalAuths_provider_providerId_idx on `_externalAuths` (`provider`, `providerId`)�0Q)�sindex_externalAuths_record_provider_idx_externalAuthsCREATE UNIQUE INDEX _externalAuths_record_provider_idx on `_externalAuths` (`collectionId`, `recordId`, `provider`)�B ))�?table_externalAuths_externalAuthsCREATE TABLE `_externalAuths` ( `id` TEXT PRIMARY KEY, `collectionId` TEXT NOT NULL, `recordId` TEXT NOT NULL, `provider` TEXT NOT NULL, `providerId` TEXT NOT NULL, `created` TEXT DEFAULT "" NOT NULL, `updated` TEXT DEFAULT "" NOT NULL, --- FOREIGN KEY (`collectionId`) REFERENCES `_collections` (`id`) ON UPDATE CASCADE ON DELETE CASCADE );O)indexsqlite_autoindex__externalAuths_1_externalAuths�l �/table_params_paramsCREATE TABLE `_params` ( `id` TEXT PRIMARY KEY, `key` TEXT UNIQUE NOT NULL, `value` JSON DEFAULT NULL, `created` TEXT DEFAULT "" NOT NULL, `updated` TEXT DEFAULT "" NOT NULL )-Aindexsqlite_autoindex__params_2_params -Aindexsqlite_autoindex__params_1_params�T%%�ktable_collections_collectionsCREATE TABLE `_collections` ( `id` TEXT PRIMARY KEY, `system` BOOLEAN DEFAULT FALSE NOT NULL, `type` TEXT DEFAULT "base" NOT NULL, `name` TEXT UNIQUE NOT NULL, `schema` JSON DEFAULT "[]" NOT NULL, `listRule` TEXT DEFAULT NULL, `viewRule` TEXT DEFAULT NULL, `createRule` TEXT DEFAULT NULL, `updateRule` TEXT DEFAULT NULL, `deleteRule` TEXT DEFAULT NULL, `options` JSON DEFAULT "{}" NOT NULL, `created` TEXT DEFAULT "" NOT NULL, `updated` TEXT DEFAULT "" NOT NULL )7 K%indexsqlite_autoindex__collections_2_collections 7K%indexsqlite_autoindex__collections_1_collections ��table_admins_adminsCREATE TABLE `_admins` ( `id` TEXT PRIMARY KEY, `avatar` INTEGER DEFAULT 0 NOT NULL, `email` TEXT UNIQUE NOT NULL, `tokenKey` TEXT UNIQUE NOT NULL, `passwordHash` TEXT NOT NULL, `lastResetSentAt` TEXT DEFAULT "" NOT NULL, `created` TEXT DEFAULT "" NOT NULL, `updated` TEXT DEFAULT "" NOT NULL )-Aindexsqlite_autoindex__admins_3_admins-Aindexsqlite_autoindex__admins_2_admins-Aindexsqlite_autoindex__admins_1_admins�##�Gtable_migrations_migrationsCREATE TABLE `_migrations` (file VARCHAR(255) PRIMARY KEY NOT NULL, applied INTEGER NOT NULL)5I#indexsqlite_autoindex__migrations_1_migrationm) �L��O � , �]&�� M ��f2 ��h> � � � ] 5 � � w E ��iA��a:��a4��f>��xP(��pB��&VC1772312824_updated_demo3.jsK�R}O1722443544_updated_authOrigins.js��T�%=A1722443494_updated_mfas.js��l%D5a1690454337_transform_relations_to_views.go�h��B*K1690319366_reset_null_values.go�h��6,O1673167670_multi_match_migrate.go��s�16%A1691747913_resave_views.go ��S��11640988000_init.gocC� 4L �� q<zK+�� i C��hH(��mM- � � � e ; � � � � q K %��|V. ��d>�`@ ��`* C1772312824_updated_demo3.jsV5o1763020353_update_default_auth_alert_templates.goU!G1762788846_updated_nologin.jsT%O1762788829_updated__superusers.jsSC1762788817_updated_users.jsR!G1762788810_updated_clients.jsQC1762788048_updated_users.jsP5o1762785011_update_default_auth_alert_templates.goOC1761219736_updated_view1.jsNC1743591869_updated_demo1.jsM E1717233559_v0.23_migrate4.goL E1717233558_v0.23_migrate3.goK E1717233557_v0.23_migrate2.goJ91640988000_aux_init.goIC1726224493_updated_users.jsHC1726224305_updated_users.jsG%O1725792578_updated__superusers.jsFC1725192928_updated_demo4.jsEC1725192864_updated_demo1.jsDC1725192864_updated_view1.jsCC1725192864_updated_view2.jsB$M1724072848_updated_superusers.jsA$M1722443663_updated_superusers.js@'S1722443631_updated_externalAuths.js?%O1722443544_updated_authOrigins.js>A1722443494_updated_mfas.js=A1722443484_updated_mfas.js<A1722443467_updated_otps.js;%O1721987788_updated_authOrigins.js:%O1721987781_updated_authOrigins.js9%O1721987631_updated_authOrigins.js8%O1721987625_updated_authOrigins.js7C1720865200_updated_view2.js6C1720865181_updated_view1.js5C1720865176_updated_view2.js4C1720865172_updated_view2.js3C1720865165_updated_view1.js2)W1720865157_updated_numeric_id_view.js1)W1720863324_updated_numeric_id_view.js0)W1720863270_updated_numeric_id_view.js/)W1720863228_updated_numeric_id_view.js.)W1720862822_updated_numeric_id_view.js-)W1720862814_updated_numeric_id_view.js,C1720862738_updated_view2.js+C1720862730_updated_view2.js*C1720862724_updated_view1.js)C1720862718_updated_view1.js()W1720862697_updated_numeric_id_view.js')W1720862691_updated_numeric_id_view.js&$M1720595195_updated_superusers.js%!G1719590348_updated_clients.js$C1719427256_updated_users.js#C1719427201_updated_users.js"C1719427146_updated_users.js!!G1719427055_updated_nologin.js C1717233556_v0.23_migrate.go+[1702134272_set_default_json_max_size.goL�1701496825_allow_single_oauth2_provider_in_multiple_auth_collections.go%O1692609521_copy_display_fields.goA1691747913_resave_views.go)W1691747757_updated_numeric_id_view.js)W1691747531_updated_numeric_id_view.js$M1679943781_add_indexes_column.go2i1679943780_normalize_single_multiple_values.go�16794m1689579878_renormalize_single_multiple_values.go91685164450_check_fk.go*Y1677152688_rename_authentik_to_oidc.go� 167666)W1691747509_updated_numeric_id_view.jsC1691746903_updated_view3.jsC1691746871_updated_view3.jsC1691746861_created_view3.js.a1690454337_transform_relations_to_views.go#K1690319366_reset_null_values.go%O1673167670_multi_match_migrate.go167A1691747912_resave_views.go1 1640988000_init.go 0��0�+1q� sbmbsdb40jyxf7ptest44@example.comO4rvW9FSUyTA3xUuQmXR3wHF2db9bHs19nBHeSgVTxerOsTAl2$2y$13$RuGt9Ul0R4XDJ.2jfK.lqejloyeiqvj5YFgdUAu2lQBg9nrvszP4q�I +/q� ==9q2trqumvlyr3bdtest3@example.comezLvEu7DRFtUp9BI6nxtXCpgtp7qWaNQLdD6dDwjIVB0mA0uUr$2a$13$gqXkfs0WjqTtUNRjRDxAHuLul1sxmA.elEfYuL0KT0er+=++=_pb_users_auth_2024-07-29 11:57:28.598Z5eto7nmys833164githubtest456bgs820n361vj1qd2024-07-29 11:57:28.598Zr+=++=v851q4r790rhknl2024-07-29 11:56:28.439Zf1z5b3843pzc964googletest456gk390qegs4y47wn2024-07-29 11:56:35.151Zr+=++=_pb_users_auth_2022-01-01 01:01:01.123Zdlmflokuq1xl342gitlabtest1234q1xlclmfloku332022-01-01 01:01:01.123Zr+=++=_pb_users_auth_2023-01-01 01:02:03.456Zclmflokuq1xl341googletest1234q1xlclmfloku332022-01-01 01:01:01.123Z ��+5eto7nmys833164+f1z5b3843pzc964+dlmflokuq1xl342+ clmflokuq1xl341 f��$� +�' �Q==ib3m2700k5hlsjzviewview2[{"autogeneratePattern":"","hidden":false,"id":"text3208210256","max":0,"min":0,"name":"id","pattern":"","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"_clone_5Vzi","name":"state","presentable":false,"required":false,"system":fa�++�S �==zahsr9d2mix2fvkviewnumeric_id_view[{"autogeneratePattern":"","hidden":false,"id":"text3208210256","max":0,"min":0,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"_clone_jO9O","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"}]{"viewQuery":"select (ROW_NUMBER() OVER()) as id, email from clients"}2023-08-11 09:41:00.997Z2024-11-19 15:29:43.901Z[]� +�= �Q==ib3m2700k5hlsjzviewview2[{"autogeneratePattern":"","hidden":false,"id":"text3208210256","max":0,"min":0,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"_clone_77Ik","name":"state","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"_clone_IbSu","maxSelect":99,"maxSize":5242880,"mimeTypes":null,"name":"file_many","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"cascadeDelete":true,"collectionId":"_pb_users_auth_","hidden":false,"id":"_clone_Asz0","maxSelect":9999,"minSelect":0,"name":"rel_many","presentable":false,"required":false,"system":false,"type":"relation"}]{"viewQuery":"SELECT view1.id, view1.bool as state, view1.file_many, view1.rel_many from view1\n"}2023-02-17 19:42:54.278Z2024-11-19 15:29:43.857Z[]�) #��g==�wpbc_3142635823auth_superusers[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":0,"hidden":true,"id":"password901924565","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePatt�Q) #��w==�wpbc_3142635823auth_superusers[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":0,"hidden":true,"id":"password901924565","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9_]{50}","hidden":true,"id":"text2504183744","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"email3885137012","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"},{"hidden":false,"id":"bool1547992806","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","S U��U7O4rvW9FSUyTA3xUuQmXR3wHF2db9bHs19nBHeSgVTxer*++v851q4r790rhknlgk390qegs4y47wngoogle*++_pb_users_auth_bgs820n361vj1qdgithub)++ _pb_users_auth_4q1xlclmfloku33google*++_pb_users_auth_4q1xlclmfloku33gitlab �F��'7 77�y==_pb_users_auth_authusers[{"system":false,"id":"users_name","name":"name","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}},{"system":false,"id":"users_avatar","name":"avatar","type":"file","required":false,"unique":false,"options":{"maxSelect":1,"maxSize":5242880,"mimeTypes":["image/jpg","image/jpeg","image/png","image/svg+xml","image/gif"],"thumbs":["70x50","70x50t","70x50b","70x50f","0x50","70x0"]}},{"system":false,"id":"xtecur3m","name":"file","type":"file","required":false,"unique":false,"options":{"maxSelect":5,"maxSize":5242880,"mimeTypes":[],"thumbs":[]}}]id = @request.auth.idid = @request.auth.idid = @request.auth.id{"allowEmailAuth":true,"allowOAuth2Auth":true,"allowUsernameAuth":true,"exceptEmailDomains":null,"manageRule":null,"minPasswordLength":8,"onlyEmailDomains":null,"requireEmail":false}2022-10-10 09:49:46.145Z2022-10-11 18:38:50.784Z�+�'�s==v851q4r790rhknlauthclients[{"system":false,"id":"lacorw19","name":"name","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}}]{"allowEmailAuth":true,"allowOAuth2Auth":false,"allowUsernameAuth":false,"exceptEmailDomains":[],"manageRule":null,"minPasswordLength":8,"onlyEmailDomains":[],"requireEmail":true}2022-10-11 09:41:36.712Z2022-10-11 09:41:36.712Z�k+�1==wsmn24bux7wo113basedemo1[{"system":false,"id":"u7spsiph","name":"text","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}},{"system":false,"id":"puk534el","name":"bool","type":"bool","required":false,"unique":false,"options":{}},{"system":false,"id":"ktas5n7b","name":"url","type":"url","required":false,"unique":false,"options":{"exceptDomains":[],"onlyDomains":[]}},{"system":false,"id":"dc4abz4i","name":"select_one","type":"select","required":false,"unique":false,"options":{"maxSelect":1,"values":["optionA","optionB","optionC"]}},{"system":false,"id":"owtlq7zl","name":"select_many","type":"select","required":false,"unique":false,"options":{"maxSelect":3,"values":["optionA","optionB","optionC"]}},{"system":false,"id":"4ulkdevf","name":"file_one","type":"file","required":false,"unique":false,"options":{"maxSelect":1,"maxSize":5242880,"mimeTypes":[],"thumbs":[]}},{"system":false,"id":"fjzhrsvq","name":"file_many","type":"file","required":false,"unique":false,"options":{"maxSelect":99,"maxSize":5242880,"mimeTypes":[],"thumbs":[]}},{"system":false,"id":"1z1ld0i5","name":"number","type":"number","required":false,"unique":false,"options":{"min":null,"max":null}},{"system":false,"id":"khvhpwgj","name":"email","type":"email","required":false,"unique":false,"options":{"exceptDomains":null,"onlyDomains":null}},{"system":false,"id":"ro6p02gk","name":"datetime","type":"date","required":false,"unique":false,"options":{"min":"","max":""}},{"system":false,"id":"ei2fg4v1","name":"json","type":"json","required":false,"unique":false,"options":{}},{"system":false,"id":"zaedritp","name":"rel_one","type":"relation","required":false,"unique":false,"options":{"maxSelect":1,"collectionId":"wsmn24bux7wo113","cascadeDelete":false}},{"system":false,"id":"t9bpk2ug","name":"rel_many","type":"relation","required":false,"unique":false,"options":{"maxSelect":null,"collectionId":"_pb_users_auth_","cascadeDelete":false}}]{}2022-10-10 09:51:19.868Z2022-10-10 10:11:18.528Z�g+�)==4d1blo5cuycfacabasedemo4[{"system":false,"id":"erkxnabw","name":"title","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}}]{}2022-10-10 09:51:47.770Z2022-10-10 09:51:47.770Z�g+�)==wzlqyes4orhoygbbasedemo3[{"system":false,"id":"w5z2x0nq","name":"title","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}}]{}2022-10-10 09:51:36.853Z2022-10-10 09:51:36.853Z�g+�)==sz5l5z67tg7gku0basedemo2[{"system":false,"id":"mkrguaaf","name":"title","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}}]E D A-98, ��a�9u��M��%%�)pbc_1638494021)pbc_2279338944+wsmn24bux7wo113)pbc_2281828961 )pbc_3142635823+zahsr9d2mix2fvk+ib3m2700k5hlsjz +v9gwnfh02gjq1q0 +9n89pl5vkct6330+kpv709sk2lqbqk8+v851q4r790rhknl+4d1blo5cuycfaca+wzlqyes4orhoygb+sz5l5z67tg7gku0)pbc_4275539003+ _pb_users_auth_ W)�r9L)�^��Ch��%_authOrigins#_s#_superusers _mfas users _otps�dem demo1 view1 )_externalAuths view2 demo3+numeric_id_view demo5nologinclients demo4 demo3 demo2%_authOriginsrs $$ +�==ye7i7hrf6ljms0jsettings{"meta":{"appName":"acme_test","appUrl":"http://localhost:8090","hideControls":false,"senderName":"Support","senderAddress":"support@example.com","verificationTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{ACTION_URL}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Verify your {APP_NAME} email","actionUrl":"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}"},"resetPasswordTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{ACTION_URL}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Reset your {APP_NAME} password","actionUrl":"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}"},"confirmEmailChangeTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{ACTION_URL}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Confirm your {APP_NAME} new email address","actionUrl":"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}"}},"logs":{"maxDays":5},"smtp":{"enabled":false,"host":"smtp.example.com","port":587,"username":"","password":"","tls":false},"s3":{"enabled":false,"bucket":"","region":"","endpoint":"","accessKey":"","secret":"","forcePathStyle":false},"adminAuthToken":{"secret":"MyN3nDlzmHnuCjd35vb6cyIdqNr7Os0PmgiPVDMxmbFToSpBvS","duration":1209600},"adminPasswordResetToken":{"secret":"fPSpF�s+�W==ye7i7hrf6ljms0jsettings{"meta":{"appName":"acme_test","appUrl":"http://localhost:8090","hideControls":false,"senderName":"Support","senderAddress":"support@example.com","verificationTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{ACTION_URL}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Verify your {APP_NAME} email","actionUrl":"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}"},"resetPasswordTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClicl+=++=_pb_users_auth_2024-07-26 12:22:01.467Z07a9x0h2sc19m4wpassword4q1xlclmfloku332024-07-26 12:22:01.467Zn=++=_pb_users_auth_2024-07-26 12:21:49.158Zzqr7oy87mdlkwj4password4q1xlclmfloku332024-07-26 12:21:49.158Z ��+07a9x0h2sc19m4wzqr7oy87mdlkwj4 }}[{��]+ � ==�_pbc_1285377323basemfas[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1582905952","max":0,"min":0,"name":"method","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]{}2024-06-20 09:29:22.894Z2024-07-31 06:56:59.301Z["CREATE INDEX `_mfas_collectionRef_idx` ON `_mfas` (collectionRef)"]!�� ) )��U�U�U==�apbc_2281828961base_externalAuths[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text2462348188","max":0,"min":0,"name":"provider","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1044722854","max":0,"min":0,"name":"providerId","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId{}2024-06-20 09:29:22.862Z2024-07-31 16:33:51.596Z["CREATE UNIQUE INDEX `idx_externalAuths_record_provider` ON `externalAuths` (collectionRef, recordRef, provider)","CREATE UNIQUE INDEX `idx_externalAuths_collection_provider` ON `externalAuths` (collectionRef, provider, providerId)"] EE� �ssettings{"meta":{"appName":"acme_test","appUrl":"http://localhost:8090","senderName":"Support","senderAddress":"support@example.com","hideControls":false},"logs":{"maxDays":5,"minLevel":0,"logIp":false},"smtp":{"enabled":false,"port":587,"host":"smtp.example.com","username":"","password":"","authMethod":"","tls":fa�8 =�0settings2024-09-11 15:34:33.155Z{"smtp":{"enabled":false,"port":587,"host":"smtp.example.com","username":"","authMethod":"","tls":false,"localName":""},"backups":{"cron":"","cronMaxKeep":0,"s3":{"enabled":false,"bucket":"","region":"","endpoint":"","accessKey":"","forcePathStyle":false}},"s3":{"enabled":false,"bucket":"","region":"","endpoint":"","accessKey":"","forcePathStyle":false},"meta":{"appName":"acme_test","appURL":"http://localhost:8090","senderName":"Support","senderAddress":"support@example.com","hideControls":false},"logs":{"maxDays":5,"minLevel":0,"logIP":false},"batch":{"enabled":true,"maxRequests":50,"timeout":5,"maxBodySize":0},"rateLimits":{"rules":[{"label":"*:auth","maxRequests":2,"duration":3},{"label":"*:create","maxRequests":20,"duration":5},{"label":"/api/batch","maxRequests":3,"duration":1},{"label":"/api/","maxRequests":300,"duration":10}],"enabled":false},"trustedProxy":{"headers":[],"useLeftmostIP":false}} ��+dlmflokuq1xl342settings u��u*++v851q4r790rhknlgk390qegs4y"+v851q4r790rhknlgoogletest456!+ _pb_users_auth_googletest123"+_pb_users_auth_gitlabtest123"+_pb_users_auth_githubtest456 y *�+� ==�wsmn24bux7wo113basedemo1[{"system":false,"id":"u7spsiph","name":"text","type":"text","required":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}},{"system":false,"id":"puk534el","name":"bool","type":"bool�H+�[==�wsmn24bux7wo113basedemo1[{"system":false,"id":"u7spsiph","name":"text","type":"text","required":false,"presentable":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}},{"system":false,"id":"puk534el","name":"bool","type":"bool","required":false,"presentable":false,"unique":false,"options":{}},{"system":false,"id":"ktas5n7b","name":"url","type":"url","required":false,"presentable":false,"unique":false,"options":{"exceptDomains":[],"onlyDomains":[]}},{"system":false,"id":"dc4abz4i","name":"select_one","type":"select","required":false,"presentable":false,"unique":false,"options":{"maxSelect":1,"values":["optionA","optionB","optionC"]}},{"system":false,"id":"owtlq7zl","name":"select_many","type":"select","required":false,"presentable":false,"unique":false,"options":{"maxSelect":3,"values":["optionA","optionB","optionC"]}},{"system":false,"id":"4ulkdevf","name":"file_one","type":"�_+�-7 77� ==�y_pb_users_auth_authusers[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":10,"hidden":true,"id":"_pbf_auth_password_","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9_]{50}","hidden":true,"id":"_pbf_auth_tokenKey_","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"_pbf_auth_email_","name":"email","onlyDomains":null,"presentable":false,"required":false,"system":true,"type":"email"},{"hidden":false,"id":"_pbf_auth_emailVisibility_","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"_pbf_auth_verified_","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"users[0-9]{5}","hidden":false,"id":"_pbf_auth_username_","max":150,"min":3,"name":"username","pattern":"^[\\w][\\w\\.\\-]*$","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"users_name","max":0,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"users_avatar","maxSelect":1,"maxSize":5242880,"mimeTypes":["image/jpg","image/jpeg","image/png","image/svg+xml","image/gif"],"name":"avatar","presentable":false,"protected":false,"required":false,"system":false,"thumbs":["70x50","70x50t","70x50b","70x50f","0x50","70x0"],"type":"file"},{"hidden":false,"id":"xtecur3m","maxSelect":5,"maxSize":5242880,"mimeTypes":null,"name":"file","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"cascadeDelete":false,"collectionId":"sz5l5z67tg7gku0","hidden":false,"id":"lkeigvv3","maxSelect":1,"minSelect":0,"name":"rel","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"_pbf_autodate_created_","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"_pbf_autodate_updated_","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]id = @request.auth.idid = @request.auth.idid = @request.auth.id{"authRule":"","manageRule":null,"authAlert":{"enabled":true,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APPT �u =/+ �q=); 2022-10-10 10:36:59.438Ztest2@example.comoap640cot4yru2s$2a$13$RC6/uXsHWM1ZV1v0cPJLRuWPXxyNINDmUDIHTq1x1dM.K.TBgWzFKAQbE30CNb8Ncwr6Sg0sfvDJGJuepriTJN24EHZqO5DsEBTk1kA2022-10-11 18:37:20.744Ztest2_username["test_kfd2wYLxkz.txt"]�1=-+ �q=!+300_1SEi6Q6U72.png2022-10-10 10:36:26.879Ztest@example.com4q1xlclmfloku33test1$2a$13$uULN32dHTkWQIALJP1N54.22HW/K9/qkXqcmsfz2hOA1wGeuUDbfGtfYe7rCTX4D2KuWQY3pJjBifgsrMbecyXBatEPjrSfGEGS2jh62022-10-12 11:46:10.490Zusers7565�t =/+ �q=); 2022-10-10 10:36:59.438Ztest2@example.comoap640cot4yru2s$2a$13$RC6/uXsHWM1ZV1v0cPJLRuWPXxyNINDmUDIHTq1x1dM.K.TBgWzFKAQbE30CNb8Ncwr6Sg0sfvDJGJuepriTJN24EHZqO5DsEBTk1kA2022-10-11 18:37:20.744Ztest2_username["test_kfd2wYLxkz.txt"]�1=-+�q=!+300_1SEi6Q6U72.png2022-10-10 10:36:26.879Ztest@example.com4q1xlclmfloku33test1$2a$13$uULN32dHTkWQIALJP1N54.22HW/K9/qkXqcmsfz2hOA1wGeuUDbfGtfYe7rCTX4D2KuWQY3pJjBifgsrMbecyXBatEPjrSfGEGS2jh62022-10-12 11:46:10.490Zusers75657[]llvuca81nly1qls�o =/+�q=!+2022-10-10 10:37:33.119Ztest3@example.combgs820n361vj1qdtest3$2a$13$qzF1J0ePG5.fvBrm0fVrtez5RRBjPOUoezvYRbTQGAfsT85d4XH2Kx6vHUi00LvM5bFeGIpwXN9xuol8k1BknfTmlySQ7YQWoTLKOa72022-10-12 11:46:02.462Zusers69238[]0yxhwia2amd8gecc ��+bgs820n361vj1qd+oap640cot4yru2s+ 4q1xlclmfloku33 ��=2022-10-10 10:37:33.119Z=2022- ! users75657!users69238)test2_username ��- test@example.com/test3@example.com/test2@example.com \��\6qx6vHUi00LvM5bFeGIpwXN9xuol8k1BknfTmlySQ7YQWoTLKOa75q tfYe7rCTX4D2KuWQY3pJjBifgsrMbecyXBatEPjrSfGEGS2jh66qAQbE30CNb8Ncwr6Sg0sfvDJGJuepriTJN24EHZqO5DsEBTk1kA ��6qx6vHUi00LvM5bFeGIpwXN9xuol8k1BknfTmlySQ7YQWoTLKOa76qAQbE30CNb8Ncwr6Sg0s=2022-10-10 10:37:33.119Z=2022-10-10 10:36:59.438Z= 2022-10-10 10:36:26.879Z �1 .1��z=+= 1/ +#{O2022-10-14 10:14:04.685Zal1h9ijdeojtsjy2025-04-02 11:05:26.292Ztest2optionB300_Jsjq7RdBgA.png[]�test2@example.comnull84nmscqy84lsi1t["optionB"]["bgs820n361vj1qd","4q1xlclmfloku33","oap640cot4yru2s"]{"lon":23.333157,"lat":42.654318}�Z=+=53�i-=7 732022-10-14 10:13:12.397Z84nmscqy84lsi1t2023-01-04 20:11:20.732Ztesthttps://example.copmoptionBtest_d61b33QdDU.txt["test_QZFjKjXchk.txt","300_WlbFWSGmW9.png","logo_vcfJJG5TAh.svg","test_MaWC6mWyrP.txt","test_tC1Yc87DfC.txt"]�@test@example.com2022-10-01 12:00:00.000Z[ 1, 2, 3 ]["optionB","optionC"]["oap640cot4yru2s"](+=# �=+=# Q2022-10-14 10:36:21.012Zimy661ixudk5izi2025-04-02 11:05:03.433Zlorem ipsum[]null[][]{"lon":-74.006015,"lat":40.712728}�=+= 1/ +#{2022-10-14 10:14:04.685Zal1h9ijdeojtsjy2022-10-14 10:35:40.150Ztest2optionB300_Jsjq7RdBgA.png[]�test2@example.com84nmscqy84lsi1t["optionB"]["bgs820n361vj1qd","4q1xlclmfloku33","oap640cot4yru2s"] ��+imy661ixudk5izi+al1h9ijdeojtsjy+ 84nmscqy84lsi1t ��=2022-10-14 10:36:21.012Z=2022-10-14 10:14:04.685Z= 2022-10-14 10:13:12.397Z M}F��W � pM E ~ S�h{=��0�+�5tabledemo1demo1CREATE TABLE `demo1` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY, `updated` TEXT DEFAULT '' NOT NULL, "text" TEXT DEFAULT '', "bool" Boolean DEFAULT FALSE, "url" TEXT DEFAULT '', "select_one" TEXT DEFAULT '', "file_one" TEXT DEFAULT '', "file_many" TEXT DEFAULT '', "number" REAL DEFAULT 0, "email" TEXT DEFAULT '', "datetime" TEXT DEFAULT '', "json" JSON DEFAULT NULL, "rel_one" TEXT DEFAULT '', "select_many" TEXT DEFAULT '', "rel_many" JSON DEFAULT '[]' NOT NULL, "point" JSON DEFAULT '{"lat":0,"lon":0}' NOT NULL)� �tabledemo4demo4#CREATE TABLE `demo4` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY, `title` TEXT DEFAULT '', `updated` TEXT DEFAULT '' NOT NULL, "rel_one_no_cascade" TEXT DEFAULT '', "rel_one_no_cascade_required" TEXT DEFAULT '', "rel_one_cascade" TEXT DEFAULT '', "self_rel_one" TEXT DEFAULT '', "json_array" JSON DEFAULT NULL, "json_object" JSON DEFAULT NULL, "rel_one_unique" TEXT DEFAULT '' NOT NULL, "rel_many_no_cascade" JSON DEFAULT '[]' NOT NULL, "rel_many_no_cascade_required" JSON DEFAULT '[]' NOT NULL, "rel_many_cascade" JSON DEFAULT '[]' NOT NULL, "rel_many_unique" JSON DEFAULT '[]' NOT NULL, "self_rel_many" JSON DEFAULT '[]' NOT NULL)�v)�Ctablenologinnologin.CREATE TABLE "nologin" (`created` TEXT DEFAULT '' NOT NULL, `email` TEXT DEFAULT '' NOT NULL, `emailVisibility` BOOLEAN DEFAULT FALSE NOT NULL, `id` TEXT PRIMARY KEY, `name` TEXT DEFAULT '', "password" TEXT NOT NULL, `tokenKey` TEXT NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `username` TEXT NOT NULL, `verified` BOOLEAN DEFAULT FALSE NOT NULL)-$Aindexsqlite_autoindex_clients_1clients'�v#�Ctableclientsclients&CREATE TABLE `clients` (`created` TEXT DEFAULT '' NOT NULL, `email` TEXT DEFAULT '' NOT NULL, `emailVisibility` BOOLEAN DEFAULT FALSE NOT NULL, `id` TEXT PRIMARY KEY, `name` TEXT DEFAULT '', "password" TEXT NOT NULL, `tokenKey` TEXT NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `username` TEXT NOT NULL, `verified` BOOLEAN DEFAULT FALSE NOT NULL))!=indexsqlite_autoindex_demo4_1demo4$)=indexsqlite_autoindex_demo3_1demo3!�=�Ytabledemo3demo3 CREATE TABLE `demo3` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY, `title` TEXT DEFAULT '', `updated` TEXT DEFAULT '' NOT NULL, "files" TEXT DEFAULT ''))=indexsqlite_autoindex_demo2_1demo2�D�gtabledemo2demo2CREATE TABLE `demo2` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY, `title` TEXT DEFAULT '', `updated` TEXT DEFAULT '' NOT NULL, "active" Boolean DEFAULT FALSE))=indexsqlite_autoindex_demo1_1demo1)=indexsqlite_autoindex_users_1users�9�QtableusersusersCREATE TABLE `users` (`avatar` TEXT DEFAULT '', `created` TEXT DEFAULT '' NOT NULL, `email` TEXT DEFAULT '' NOT NULL, `emailVisibility` BOOLEAN DEFAULT FALSE NOT NULL, `id` TEXT PRIMARY KEY, `name` TEXT DEFAULT '', "password" TEXT NOT NULL, `tokenKey` TEXT NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `username` TEXT NOT NULL, `verified` BOOLEAN DEFAULT FALSE NOT NULL, "file" TEXT DEFAULT '', "rel" TEXT DEFAULT '')7 K%indexsqlite_autoindex__collections_2_collections 7K%indexsqlite_autoindex__collections_1_collections �z%%�7table_collections_collectionsCREATE TABLE `_collections` ( `id` TEXT PRIMARY KEY, `system` BOOLEAN DEFAULT FALSE NOT NULL, `type` TEXT DEFAULT "base" NOT NULL, `name` TEXT UNIQUE NOT NULL, "fields" JSON DEFAULT "[]" NOT NULL, `listRule` TEXT DEFAULT NULL, `viewRule` TEXT DEFAULT NULL, `createRule` TEXT DEFAULT NULL, `updateRule` TEXT DEFAULT NULL, `deleteRule` TEXT DEFAULT NULL, `options` JSON DEFAULT "{}" NOT NULL, `created` TEXT DEFAULT "" NOT NULL, `updated` TEXT DEFAULT "" NOT NULL , `indexes` JSON DEFAULT "[]" NOT NULL)5I#indexsqlite_autoindex__migrations_1_migrations�##�Gtable_migrations_migrationsCREATE TABLE `_migrations` (file VARCHAR(255) PRIMARY KEY NOT NULL, applied INTEGER NOT NULL) ��iJ=+= 2022-10-12 11:42:55.076Zachvryl401bhse3test22022-10-14 10:52:46.726ZI+=2022-10-18 17:31:03.134Zuo2yigeqdzg5oa0po2022-10-18 17:31:03.134Z5J=+= 2022-10-12 11:42:58.215Z0yxhwia2amd8gectest32022-10-14 10:52:49.596ZI=+=2022-10-12 11:42:51.509Zllvuca81nly1qlstest12022-10-12 11:42:51.509Z ��uo2yigeqdzg5oa0+0yxhwia2amd8gec+achvryl401bhse3+ llvuca81nly1qls j��k � � 3�g � � ��sj�&�m�c��Zc�Uc� table_otps_otpsKCREATE TABLE "_otps" (`collectionRef` TEXT DEFAULT '' NOT NULL, `created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `password` TEXT DEFAULT '' NOT NULL, `recordRef` TEXT DEFAULT '' NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, "sentTo" TEXT DEFAULT '' NOT NULL))d=indexsqlite_autoindex__otps_1_otpsLtmE�index_kpv709sk2lqbqk8_created_idxnologin3CREATE INDEX `_kpv709sk2lqbqk8_created_idx` ON `nologin` (`created`)~lG�'index_kpv709sk2lqbqk8_tokenKey_idxnologin2CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_tokenKey_idx` ON `nologin` (`tokenKey`)�kA�?index_kpv709sk2lqbqk8_email_idxnologin1CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_email_idx` ON `nologin` (`email`) WHERE email != ''~jG�'index_kpv709sk2lqbqk8_username_idxnologin0CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_username_idx` ON `nologin` (`username`)7gK%indexsqlite_autoindex__authOrigins_1_authOriginsO�Jf%%�Wtable_authOrigins_authOriginsNCREATE TABLE "_authOrigins" (`collectionRef` TEXT DEFAULT '' NOT NULL, `created` TEXT DEFAULT '' NOT NULL, `fingerprint` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `recordRef` TEXT DEFAULT '' NOT NULL, `updated` TEXT DEFAULT '' NOT NULL))a=indexsqlite_autoindex__mfas_1_mfas�0`�?table_mfas_mfasCREATE TABLE "_mfas" (`collectionRef` TEXT DEFAULT '' NOT NULL, `created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `method` TEXT DEFAULT '' NOT NULL, `recordRef` TEXT DEFAULT '' NOT NULL, `updated` TEXT DEFAULT '' NOT NULL)-_Aindexsqlite_autoindex__params_1_params�^^�table_params_paramsCREATE TABLE `_params` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `value` JSON DEFAULT NULL);ZO)indexsqlite_autoindex__externalAuths_1_externalAuths�tY))�#table_externalAuths_externalAuthsCREATE TABLE "_externalAuths" (`collectionRef` TEXT DEFAULT '' NOT NULL, `created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `provider` TEXT DEFAULT '' NOT NULL, `providerId` TEXT DEFAULT '' NOT NULL, `recordRef` TEXT DEFAULT '' NOT NULL, `updated` TEXT DEFAULT '' NOT NULL)5VI#indexsqlite_autoindex__superusers_1_superusersH�U##�wtable_superusers_superusersGCREATE TABLE "_superusers" (`created` TEXT DEFAULT '' NOT NULL, `email` TEXT DEFAULT '' NOT NULL, `emailVisibility` BOOLEAN DEFAULT FALSE NOT NULL, `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `password` TEXT DEFAULT '' NOT NULL, `tokenKey` TEXT DEFAULT '' NOT NULL, `updated` TEXT DEFAULT '' NOT NULL, `verified` BOOLEAN DEFAULT FALSE NOT NULL)pHE�index_9n89pl5vkct6330_created_idxdemo57CREATE INDEX `_9n89pl5vkct6330_created_idx` ON `demo5` (`created`)XE-{indexidx_demo2_activedemo2:CREATE INDEX "idx_demo2_active" ON "demo2" ( "active" )iD9�indexidx_unique_demo2_titledemo2;CREATE UNIQUE INDEX "idx_unique_demo2_title" on "demo2" ("title")YC/{indexidx_demo2_createddemo2CREATE INDEX `idx_demo2_created` ON `demo2` (`created`)p>E�index_wzlqyes4orhoygb_created_idxdemo3"CREATE INDEX `_wzlqyes4orhoygb_created_idx` ON `demo3` (`created`))0=indexsqlite_autoindex_demo5_1demo55�8/�Otabledemo5demo54CREATE TABLE `demo5` (`created` TEXT DEFAULT '' NOT NULL, `id` TEXT PRIMARY KEY NOT NULL, `rel_many` TEXT DEFAULT '', `rel_one` TEXT DEFAULT '', `select_many` TEXT DEFAULT '', `select_one` TEXT DEFAULT '', `updated` TEXT DEFAULT '' NOT NULL, "total" REAL DEFAULT 0, "file" TEXT DEFAULT '')-*Aindexsqlite_autoindex_nologin_1nologin/ ��2022-10-18 17:31:03.134Z=2022-10-12 11:42:58.215Z=2022-10-12 11:42:55.076Z= 2022-10-12 11:42:51.509Z =Z� ? ? ?tt�� g�+=2022-10-15 10:49:20.539Zpro2j546fl1qgbhpostman12022-10-15 10:49:20.539Z[] gQ+=2022-10-15 10:48:58.739Z4f22vqq195fgfh2postman12022-10-15 10:48:58.739Z[]D+=2022-10-15 10:48:10.041Zao7wwfv9x750eglpostman12022-10-15 10:48:10.041Z[]�+=2022-10-15 10:47:44.906Zy00ba5ls71fmkvlpostman12022-10-15 10:47:44.906Z[]O=+=2022-10-15 10:47:24.340Zatrvssmhz+=2022-10-15 10:56:03.474Z74m2udsfg204oewpostman12022-10-15 10:56:03.474Z[]�+=;2022-10-15 10:55:53.882Ztfw3vdhinvwvlrgpostman12022-10-15 10:55:53.882Z["test_BZvcuUFU63.txt"]b=+=;2022-10-15 10:L=+=2022-10-14 11:41:09.381Z1tmknxy2868d869test12022-10-14 11:41:09.381Z[]a=+=;2022-10-14 11:41:15.689Z7nwo8tuiatetxdmtest32022-10-14 14:08:16.072Z["test_JnXeKEwgwr.txt"]`=+=92022-10-14 11:41:18.877Zmk5fmymtx4wsprktest42022-10-14 14:08:06.446Z["300_JdfBOieXAW.png"]�+=2022-10-14 11:41:15.689v=+=e2022-10-14 11:41:12.548Zlcl9d87w22ml6jytest22022-10-14 14:08:29.095Z["test_FLurQTgrY8.txt","300_UhLKX91HVb.png"]K+=2022-10-14 11:41:09.381Z1tmknxy2868d869test12022-10-14 11:41:09.381Z ��MMMMu(pro2j546fl1qgbhu4f22vqq195fgfh2Pao7wwfv9x750egl CREATE UNIQUE INDEX `idx_IjL94ze` ON `demo4` (`rel_many_unique`) WHERE rel_many_unique != '[]'w�#�Aindexidx_luoQV2Ademo4?CREATE UNIQUE INDEX `idx_luoQV2A` ON `demo4` (`rel_one_unique`) WHERE rel_one_unique != ''p�E�index_4d1blo5cuycfaca_created_idxdemo4%CREATE INDEX `_4d1blo5cuycfaca_created_idx` ON `demo4` (`created`) �9�{viewview2view2CREATE VIEW `view2` AS �!��M�Kindexidx_otps_collectionRef_recordRef_otpsMCREATE INDEX `idx_otps_collectionRef_recordRef` ON `_otps` ( `collectionRef`, `recordRef` )p�E�index_wsmn24bux7wo113_created_idxdemo1CREATE INDEX `_wsmn24bux7wo113_created_idx` ON `demo1` (`created`)y� ��{viewview2view2CREATE VIEW `view2` AS SELECT * FROM (SELECT view1.id, view1.bool as state, view1.file_many, view1.rel_many from view1)Z�%%ytablesqlite_stat4sqlite_stat4PCREATE TABLE sqlite_stat4(tbl,idx,neq,nlt,ndlt,sample)K�%%[tablesqlite_stat1sqlite_stat1ICREATE TABLE sqlite_stat1(tbl,idx,stat)�C�W)�indexidx_externalAuths_collection_provider_externalAuthsCREATE UNIQUE INDEX `idx_externalAuths_collection_provider` ON "_externalAuths" ( `collectionRef`, `provider`, `providerId` )�:� O)� indexidx_externalAuths_record_provider_externalAuthsCREATE UNIQUE INDEX `idx_externalAuths_record_provider` ON "_externalAuths" ( `collectionRef`, `recordRef`, `provider` )�/� E%�indexidx_authOrigins_unique_pairs_authOriginsQCREATE UNIQUE INDEX `idx_authOrigins_unique_pairs` ON "_authOrigins" ( `collectionRef`, `recordRef`, `fingerprint` )��M�Kindexidx_mfas_collectionRef_recordRef_mfas=CREATE INDEX `idx_mfas_collectionRef_recordRef` ON "_mfas" ( `collectionRef`, `recordRef` )�M��!%%�Uview_temp_QlgTD2_temp_QlgTD2CREATE VIEW `_temp_QlgTD2` AS SELECT * FROM (select (ROW_NUMBER() OVER()) as id, email from clients)�?�++�7viewnumeric_id_viewnumeric_id_viewCREATE VIEW `numeric_id_view` AS SELECT * FROM (SELECT CAST(`id` as TEXT) `id`,`email` FROM (select (ROW_NUMBER() OVER()) as id, email from clients))tuE�index_v851q4r790rhknl_created_idxclients+CREATE INDEX `_v851q4r790rhknl_created_idx` ON `clients` (`created`)~tG�'index_v851q4r790rhknl_tokenKey_idxclients*CREATE UNIQUE INDEX `_v851q4r790rhknl_tokenKey_idx` ON `clients` (`tokenKey`)�sA�?index_v851q4r790rhknl_email_idxclients)CREATE UNIQUE INDEX `_v851q4r790rhknl_email_idx` ON `clients` (`email`) WHERE email != ''~rG�'index_v851q4r790rhknl_username_idxclients(CREATE UNIQUE INDEX `_v851q4r790rhknl_username_idx` ON `clients` (`username`)pqE�index__pb_users_auth__created_idxusersCREATE INDEX `__pb_users_auth__created_idx` ON `users` (`created`)zpG�#index__pb_users_auth__tokenKey_idxusersCREATE UNIQUE INDEX `__pb_users_auth__tokenKey_idx` ON `users` (`tokenKey`)�oA�;index__pb_users_auth__email_idxusersCREATE UNIQUE INDEX `__pb_users_auth__email_idx` ON `users` (`email`) WHERE email != ''znG�#index__pb_users_auth__username_idxusersCREATE UNIQUE INDEX `__pb_users_auth__username_idx` ON `users` (`username`) ��=2023-01-07 13:13:28.337Z= 2023-01-07 13:13:24.249Z &&�W+�e YY ==�4d1blo5cuycfacabasedemo4[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"erkxnabw","max":0,"min":0,"name":"title","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"t5jskeyz","maxSelect":1,"minSelect":0,"name":"rel_one_no_cascade","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"ldrcjhk8","maxSelect":1,"minSelect":0,"name":"rel_one_no_cascade_required","presentable":false,"required":true,"system":false,"type":"relation"},{"cascadeDelete":true,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"pl5lcd4y","maxSelect":1,"minSelect":0,"name":"rel_one_cascade","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"jz0oue3z","maxSelect":999,"minSelect":0,"name":"rel_many_no_cascade","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"bsxyqrhb","maxSelect":999,"minSelect":0,"name":"rel_many_no_cascade_required","presentable":false,"required":true,"system":false,"type":"relation"},{"cascadeDelete":true,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"kwmchnf7","maxSelect":999,"minSelect":0,"name":"rel_many_cascade","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"pmynkqk5","maxSelect":1,"minSelect":0,"name":"rel_one_unique","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"wzlqyes4orhoygb","hidden":false,"id":"mjzyk9vb","maxSelect":999,"minSelect":0,"name":"rel_many_unique","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"4d1blo5cuycfaca","hidden":false,"id":"dagiyxj4","maxSelect":1,"minSelect":0,"name":"self_rel_one","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"4d1blo5cuycfaca","hidden":false,"id":"tsrki8kc","maxSelect":999,"minSelect":0,"name":"self_rel_many","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"4wpx0hhx","maxSize":5242880,"name":"json_array","presentable":false,"required":false,"system":false,"type":"json"},{"hidden":false,"id":"ufpwiqnx","maxSize":5242880,"name":"json_object","presentable":false,"required":false,"system":false,"type":"json"},{"hidden":false,"id":"_pbf_autodate_created_","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"_pbf_autodate_updated_","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]@request.auth.collectionName = 'users'@request.auth.collectionName = 'users'{}2022-10-10 09:51:47.770Z2024-09-01 12:15:28.332Z["CREATE INDEX `_4d1blo5cuycfaca_created_idx` ON `demo4` (`created`)","CREATE UNIQUE INDEX `idx_luoQV2A` ON `demo4` (`rel_one_unique`) WHERE rel_one_unique != ''","CREATE UNIQUE INDEX `idx_IjL94ze` ON `demo4` (`rel_many_unique`) WHERE rel_many_unique != '[]'"] � ��[+ �- �k==� kpv709sk2lqbqk8authnologin[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":10,"hidden":true,"id":"_pbf_auth_password_","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9_]{50}","hidden":true,"id":"_pbf_auth_tokenKey_","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"_pbf_auth_email_","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"},{"hidden":false,"id":"_pbf_auth_emailVisibility_","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"_pbf_auth_verified_","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"users[0-9]{5}","hidden":false,"id":"_pbf_auth_username_","max":150,"min":3,"name":"username","pattern":"^[\\w][\\w\\.\\-]*$","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"x8zzktwe","max":0,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"_pbf_autodate_created_","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"_pbf_autodate_updated_","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"systJ�=+�-�3==� v851q4r790rhknlauthclients[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":10,"hidden":true,"id":"_pbf_auth_password_","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9_]{50}","hidden":true,"id":"_pbf_auth_tokenKey_","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"_pbf_auth_email_","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"},{"hidden":false,"id":"_pbf_auth_emailVisibility_","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"_pbf_auth_verified_","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"users[0-9]{5}","hidden":false,"id":"_pbf_auth_username_","max":150,"min":3,"name":"username","pattern":"^[\\w][\\w\\.\\-]*$","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"lacorw19","max":0,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"_pbf_autodate_created_","name":"created","onCreate":true,"onUpdate":false,"presentable":fa@ ��;754=2022-10-12 11:42:58.215Z=2022-10-12 11:42:55.076Z= 2022-10-12 �� test3 test2 test1 %��\%red":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]{"authRule":"","manageRule":null,"oauth2":{"providers":null,"mappedFields":{"id":"","name":"","username":"","avatarUrl":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800},"otp":{"enabled":false,"duration":300,"length":8},"authToken":{"secret":"MyN3nDlzmHnuCjd35vb6cyIdqNr7Os0PmgiPVDMxmbFToSpBvS","duration":1209600},"passwordResetToken":{"secret":"fPSpFm9rxjj4mdeWYfyQ5OZQ4UWpyainTO0dqrJe3LHEYEDduq","duration":1800},"emailChangeToken":{"secret":"unYNiYeuIxH7BCV09NIb81abe2bkPgaexMYdDQ6uOOIFh74urD","duration":1800},"verificationToken":{"secret":"uhr68rXLVjPBWALFtw8uEHeQwDdN4t0MiTLr2pBWVkEQnNICe1","duration":259200},"fileToken":{"secret":"sjJAjTNPrOcRDmnIKwQm7qY9FyjuXTG5KNcaqw4U1TSDVfu4r9","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"otpTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"loginAlertTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2024-06-6qezLvEu7DRFtUp9BI6nxtXCpgtp7qWaNQLdD6dDwjIVB0mA0uUr6qcvg1nk1dKRFlazQH8nCKuFYwczdReQx6ZJimxXvei0uDyTkgEb5q O4rvW9FSUyTA3xUuQmXR3wHF2db9bHs19nBHeSgVTxerOsTAl46qB4LS_3ZiIlL_TQ97_W_u2_82__W1_l64037w_x211_F_BM_J4_ ��03ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Reset your {APP_NAME} password","actionUrl":"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}"},"confirmEmailChangeTemplate":{"body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{ACTION_URL}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e","subject":"Confirm your {APP_NAME} new email address","actionUrl":"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}"}},"logs":{"maxDays":5},"smtp":{"enabled":false,"host":"smtp.example.com","port":587,"username":"","password":"","authMethod":"","tls":false},"s3":{"enabled":false,"bucket":"","region":"","endpoint":"","accessKey":"","secret":"","forcePathStyle":false},"adminAuthToken":{"secret":"MyN3nDlzmHnuCjd35vb6cyIdqNr7Os0PmgiPVDMxmbFToSpBvS","duration":1209600},"adminPasswordResetToken":{"secret":"fPSpFm9rxjj4mdeWYfyQ5OZQ4UWpyainTO0dqrJe3LHEYEDduq","duration":1800},"adminFileToken":{"secret":"sjJAjTNPrOcRDmnIKwQm7qY9FyjuXTG5KNcaqw4U1TSDVfu4r9","duration":180},"recordAuthToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"recordPasswordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"recordEmailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"recordVerificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"recordFileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"emailAuth":{"enabled":false,"exceptDomains":null,"onlyDomains":null,"minPasswordLength":0},"googleAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"facebookAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"githubAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"gitlabAuth":{"enabled":true,"clientId":"test_id","clientSecret":"test_secret","authUrl":"https://example.com","tokenUrl":"","userApiUrl":""},"discordAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"twitterAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"microsoftAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"spotifyAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"kakaoAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"twitchAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"stravaAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"giteeAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"livechatAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"giteaAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"oidcAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"oidc2Auth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"oidc3Auth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""},"appleAuth":{"enabled":false,"clientId":"","clientSecret":"","authUrl":"","tokenUrl":"","userApiUrl":""}}2022-10-1+_pb_users_auth__pb_users_auth_ ?%=2022-10-14 17:35:18.647Z= 2022-10-14 14:15:43.771Z ��[] []lse,"system":false,"type":"autodate"},{"hidden":false,"id":"_pbf_autodate_updated_","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]{"authRule":"verified=true","manageRule":null,"authAlert":{"enabled":true,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location:\u003c/p\u003e\n\u003cp\u003e\u003cem\u003e{ALERT_INFO}\u003c/em\u003e\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[],"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"passwordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"emailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"verificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"fileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2022-10-11 09:41:36.712Z2025-11-10 15:33:30.519Z["CREATE UNIQUE INDEX `_v851q4r790rhknl_username_idx` ON `clients` (username)","CREATE UNIQUE INDEX `_v851q4r790rhknl_email_idx` ON `clients` (email) WHERE email != ''","CREATE UNIQUE INDEX `_v851q4r790rhknl_tokenKey_idx` ON `clients` (tokenKey)","CREATE INDEX `_v851q4r790rhknl_created_idx` ON `clients` (`created`)"] ��O++�] �=�f+�_9};;M==�9n89pl5vkct6330basedemo5[{"system":false,"id":"sozvpexq","name":"select_one","type":"select","required":false,"unique":false,"options":{"maxSelect":1,"values":["a","b","c","d"]}},{"system":false,"id":"qlq1nxlc","name":"select_many","type":"select","required":false,"unique":false,"options":{"maxSelect":5,"values":["a","b","c","d","e"]}},{"system":false,"id":"ajrrsq1a","name":"rel_one","type":"relation","required":false,"unique":false,"options":{"collectionId":"4d1blo5cuycfaca","cascadeDelete":false,"minSelect":null,"maxSelect":1,"displayFields":null}},{"system":false,"id":"soxhs0ou","name":"rel_many","type":"relation","required":false,"unique":false,"options":{"collectionId":"4d1blo5cuycfaca","cascadeDelete":false,"minSelect":null,"maxSelect":5,"displayFields":null}},{"system":false,"id":"kvbyzuqj","name":"total","type":"number","required":false,"unique":false,"options":{"min":null,"max":null}},{"system":false,"id":"ob7dsrcl","name":"file","type":"file","required":false,"unique":false,"options":{"maxSelect":1,"maxSize":5242880,"mimeTypes":[],"thumbs":[],"protected":false}}]select_many:length = 3rel_many.self_rel_many.rel_many_cascade.files:length = 1@request.data.total = 3@request.data.total = 3@request.query.test:isset = true{}2023-01-07 13:13:08.733Z2023-04-04 13:10:52.723Z["CREATE INDEX `_9n89pl5vkct6330_created_idx` ON `demo5` (`created`)"]�f +�[WW�A==v9gwnfh02gjq1q0viewview1[{"system":false,"id":"kbvy2qji","name":"text","type":"text","required":false,"presentable":false,"unique":false,"options":{"min":null,"max":null,"pattern":""}},{"system":false,"id":"hwthpdtj","name":"bool","type":"bool","required":false,"presentable":false,"unique":false,"options":{}},{"system":false,"id":"yryqt1ys","name":"url","type":"url","required":false,"presentable":false,"unique":false,"options":{"exceptDomains":[],"onlyDomains":[]}},{"system":false,"id":"xw1uhojl","name":"select_one","type":"select","required":false,"presentable":false,"unique":false,"options":{"maxSelect":1,"values":["optionA","optionB","optionC"]}},{"system":false,"id":"gxios7gf","name":"select_many","type":"select","re�x+�9};;M==�9n89pl5vkct6330basedemo5[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"sozvpexq","maxSelect":1,"name":"select_one","presentable":false,"required":false,"system":false,"type":"select","values":["a","b","c","d"]},{"hidden":false,"id":"qlq1nxlc","maxSelect":5,"name":"select_many","presentable":false,"required":false,"system":false,"type":"select","values":["a","b","c","d","e"]},{"cascadeDelete":false,"collectionId":"4d1blo5cuycfaca","hidden":false,"id":"ajrrsq1a","maxSelect":1,"minSelect":0,"name":"rel_one","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"4d1blo5cuycfaca","hidden":false,"id":"soxhs0ou","maxSelect":5,"minSelect":0,"name":"rel_many","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"kvbyzuqj","max":null,"min":null,"name":"total","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"hidden":false,"id":"ob7dsrcl","maxSelect":1,"maxSize":5242880,"mimeTypes":null,"name":"file","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"hidden":false,"id":"_pbf_autodate_created_","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"_pbf_autodate_updated_","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]select_many:length = 3rel_many.self_rel_many.rel_many_cascade.files:length = 1@request.body.total = 3@request.body.total = 3@request.query.test:isset = true{}2023-01-07 13:13:08.733Z2023-04-04 13:10:52.723Z["CREATE INDEX `_9n89pl5vkct6330_created_idx` ON `demo5` (`created`)"]] ��d":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]{"authRule":"","manageRule":null,"oauth2":{"providers":null,"mappedFields":{"id":"","name":"","username":"","avatarUrl":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800},"otp":{"enabled":false,"duration":300,"length":8},"authToken":{"secret":"MyN3nDlzmHnuCjd35vb6cyIdqNr7Os0PmgiPVDMxmbFToSpBvS","duration":1209600},"passwordResetToken":{"secret":"fPSpFm9rxjj4mdeWYfyQ5OZQ4UWpyainTO0dqrJe3LHEYEDduq","duration":1800},"emailChangeToken":{"secret":"unYNiYeuIxH7BCV09NIb81abe2bkPgaexMYdDQ6uOOIFh74urD","duration":1800},"verificationToken":{"secret":"uhr68rXLVjPBWALFtw8uEHeQwDdN4t0MiTLr2pBWVkEQnNICe1","duration":259200},"fileToken":{"secret":"sjJAjTNPrOcRDmnIKwQm7qY9FyjuXTG5KNcaqw4U1TSDVfu4r9","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"otpTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"loginAlertTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2024-06-206qezLvEu7DRFtUp9BI6nxtXCpgtp7qWaNQLdD6dDwjIVB0mA0uUr6qcvg1nk1dKRFlazQH8nCKuFYwczdReQx6ZJimxXvei0uDyTkgEb5q O4rvW9FSUyTA3xUuQmX- test@example.com/test4@example.com/test3@example.com/test2@example.com q��zqLogin from a new location","body":"\u003cp\u003eHello {RECORD:name},\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[{"pkce":null,"name":"gitlab","clientId":"test1","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":""},{"pkce":null,"name":"google","clientId":"test","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":""}],"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":true,"duration":1800,"rule":""},"otp":{"enabled":true,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello {RECORD:name},\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"passwordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"emailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"verificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"fileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello {RECORD:name},\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello {RECORD:name},\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello {RECORD:name},\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2022-10-10 09:49:46.145Z2024-09-13 10:45:05.803Z["CREATE UNIQUE INDEX `__pb_users_auth__username_idx` ON `users` (username)","CREATE UNIQUE INDEX `__pb_users_auth__email_idx` ON `users` (email) WHERE email != ''","Cviewview view basebasebasebase basebasebasebasebaseauthauthauth auth 88w�� +�? �M==ib3m2700k5hlsjzviewview2[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"_pbf_text_id_","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"uwbf02xt","name":"state","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"8pgictjd","maxSelect":99,"maxSize":5242880,"mimeTypes":null,"name":"file_many","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"cascadeDelete":true,"collectionId":"_pb_users_auth_","hidden":false,"id":"6sn6wga9","maxSelect":0,"minSelect":0,"name":"rel_many","presentable":false,"required":false,"system":false,"type":"relation"}]{"viewQuery":"SELECT view1.id, view1.bool as state, view1.file_many, view1.rel_many from view1"}2023-02-17 19:42:54.278Z2023-11-20 18:26:53.162Z[]� +�AWW�I==v9gwnfh02gjq1q0viewvie�E +�WW�W==v9gwnfh02gjq1q0viewview1[{"autogeneratePattern":"","hidden":false,"id":"text3208210256","max":0,"min":0,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"_clone_r09R","max":0,"min":0,"name":"text","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"_clone_8o57","name":"bool","presentable":false,"required":false,"system":false,"type":"bool"},{"exceptDomains":null,"hidden":false,"id":"_clone_y2Ow","name":"url","onlyDomains":null,"presentable":false,"required":false,"system":false,"type":"url"},{"hidden":false,"id":"_clone_jFNd","maxSelect":1,"name":"select_one","presentable":false,"required":false,"system":false,"type":"select","values":["optionA","optionB","optionC"]},{"hidden":false,"id":"_clone_mNKL","maxSelect":3,"name":"select_many","presentable":false,"required":false,"system":false,"type":"select","values":["optionA","optionB","optionC"]},{"hidden":false,"id":"_clone_diFB","maxSelect":1,"maxSize":5242880,"mimeTypes":null,"name":"file_one","presentable":false,"protected":true,"required":false,"system":false,"thumbs":null,"type":"file"},{"hidden":false,"id":"_clone_dViH","maxSelect":99,"maxSize":5242880,"mimeTypes":null,"name":"file_many","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"hidden":false,"id":"_clone_dIjh","max":null,"min":null,"name":"number","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"exceptDomains":null,"hidden":false,"id":"_clone_5R4l","name":"email","onlyDomains":null,"presentable":false,"required":false,"system":false,"type":"email"},{"hidden":false,"id":"_clone_LZkS","max":"","min":"","name":"datetime","presentable":false,"required":false,"system":false,"type":"date"},{"hidden":false,"id":"_clone_yiCN","maxSize":5242880,"name":"json","presentable":false,"required":false,"system":false,"type":"json"},{"cascadeDelete":false,"collectionId":"wsmn24bux7wo113","hidden":false,"id":"_clone_UJXf","maxSelect":1,"minSelect":0,"name":"rel_one","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":true,"collectionId":"_pb_users_auth_","hidden":false,"id":"_clone_0li1","maxSelect":9999,"minSelect":0,"name":"rel_many","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"_clone_VWxh","name":"point","presentable":false,"required":false,"system":false,"type":"geoPoint"},{"hidden":false,"id":"_clone_b5hm","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"}]@request.auth.id != "" && bool = true@request.auth.id != "" && bool = true{"viewQuery":"select id, text, bool, url, select_one, select_many, file_one, file_many, number, email, datetime, json, rel_one, rel_many, point, created from demo1"}2023-02-12 18:58:12.315Z2025-10-23 11:42:16.302Z[] � 4��+ �S��l) �S�U�U==�Wpbc_1638494021base_otps[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"cost":8,"hidden":true,"id":"password901924565","max":0,"min":0,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"},{"autogeneratePattern":"","hidden":true,"id":"text3866985172","max":0,"min":0,"name":"sentTo","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":true,"type":"text"}]@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId{}2024-06-20 09:29:22.901Z2024-11-19 15:29:43.633Z["CREATE INDEX `idx_otps_collectionRef_recordRef` ON `otps` (\n `collectionRef`,\n `recordRef`\n)"]�G) � �U�U==�Wpbc_2279338944base_mfas[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1582905952","max":0,"min":0,"name":"method","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId{}2024-06-20 09:29:22.894Z2024-10-24 18:34:35.352Z["CREATE INDEX `idx_mfas_collectionRef_recordRef` ON `mfas` (\n `collectionRef`,\n `recordRef`\n)"]]] � �=<�) #��U�U�U==�_pbc_120207207baseauthOrigins[{"autogeneratePattern":"[a-��B) %��U�U�U==�kpbc_4275539003base_authOrigins[{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text4228609354","max":0,"min":0,"name":"fingerprint","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId@request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId{}2024-06-20 12:10:52.542Z2024-07-31 16:32:24.722Z["CREATE UNIQUE INDEX `idx_authOrigins_unique_pairs` ON `authDevices` (collectionRef, recordRef, fingerprint)"] �6k ��H =/+�q= 2024-07-26 12:17:43.787Ztest4@example.comq911776rrfy658l$2a$10$0CUWH81tPWUhxKqksZnO/eDfJiWTTG/xg7v5Yg8RhcLIGWY3oeCHeB4LS_3ZiIlL_TQ97_W_u2_82__W1_l64037w_x211_F_BM_J4_2024-07-26 12:17:43.787Z�H =/+�q= 2022-10-10 11:22:50.693Ztest3@example.com9q2trqumvlyr3bd$2a$13$gqXkfs0WjqTtUNRjRDxAHuLul1sxmA.elEfYuL0KT0ef5cMDt9FjmezLvEu7DRFtUp9BI6nxtXCpgtp7qWaNQLdD6dDwjIVB0mA0uUr2022-10-10 11:22:54.907Z�H =/+�q= 2022-10-10 11:22:27.982Ztest2@example.comsbmbsdb40jyxf7h$2a$13$1U32ttl.v1VtQkIH.a.z2.VVrU2IFwkW41TnY2OgyMcjADv34ynMKcvg1nk1dKRFlazQH8nCKuFYwczdReQx6ZJimxXvei0uDyTkgEb2022-10-10 11:22:31.096Z�G =-+�q= 2022-10-10 09:50:06.449Ztest@example.comsywbhecnh46rhm0$2a$13$6PP1fpShEsQHpZElw4.BN.vMl/2CMIKc2kpumJM//T4qV4RGUgb6iO4rvW9FSUyTA3xUuQmXR3wHF2db9bHs19nBHeSgVTxerOsTAl42022-10-10 09:50:06.449Z ��+q911776rrfy658l+9q2trqumvlyr3bd+sbmbsdb40jyxf7h+ sywbhecnh46rhm0 {0i��p1��5 � Q &��T*��eA" � � � y � � t G ` G ��R�� i��3:%K_collectionssqlite_autoindex__collections_116 167)O_externalAuthssqlite_autoindex__externalAuths_14 1:6)O_externalAuthsidx_externalAuths_record_provider4 2 2 1>5)W_externalAuthsidx_externalAuths_collection_provider4 2 1 124%K_authOriginssqlite_autoindex__authOrigins_16 133%E_authOriginsidx_authOrigins_unique_pairs6 3 2 102#I_superuserssqlite_autoindex__superusers_14 1.1#E_superusersidx_tokenKey__pbc_33238663394 1()Aclientssqlite_autoindex_clients_12 1+(Gclients_v851q4r790rhknl_username_idx2 1('Aclients_v851q4r790rhknl_email_idx2 1+&Gclients_v851q4r790rhknl_tokenKey_idx2 1*%Eclients_v851q4r790rhknl_created_idx2 1$/=demo4sqlite_autoindex_demo4_12 1(.Edemo4_4d1blo5cuycfaca_created_idx2 1-#demo4idx_luoQV2A0 0,#demo4idx_IjL94ze0 0$ =demo3sqlite_autoindex_demo3_14 1(Edemo3_wzlqyes4orhoygb_created_idx4 11#I_migrationssqlite_autoindex__migrations_154 1$=demo2sqlite_autoindex_demo2_13 1/demo2idx_demo2_created3 1"9demo2idx_unique_demo2_title3 1-demo2idx_demo2_active3 2$<=demo1sqlite_autoindex_demo1_13 1(;Edemo1_wsmn24bux7wo113_created_idx3 1(Anologinsqlite_autoindex_nologin_13 1+Gnologin_kpv709sk2lqbqk8_username_idx3 1(Anologin_kpv709sk2lqbqk8_email_idx3 1+Gnologin_kpv709sk2lqbqk8_tokenKey_idx3 1*Enologin_kpv709sk2lqbqk8_created_idx3 1$=userssqlite_autoindex_users_13 1)Gusers__pb_users_auth__username_idx3 1&Ausers__pb_users_auth__email_idx3 1)Gusers__pb_users_auth__tokenKey_idx3 1(Eusers__pb_users_auth__created_idx3 1e K_col39%K_collectionssqlite_autoindex__collections_216 1)8%7_collectionsidx__collections_type16 6$=demo5sqlite_autoindex_demo5_12 1( Edemo5_9n89pl5vkct6330_created_idx2 1. !Gsuperuserssqlite_autoindex_superusers_14 1.Esuperusersidx_tokenKey__pbc_27738676754 +0#?_superusersidx_email__pbc_33238663394 14'MexternalAuthssqlite_autoindex_externalAuths_14 19'OexternalAuthsidx_externalAuths_record_provider4 2 2 1='WexternalAuthsidx_externalAuths_collection_provider4 2 1 1(A_paramssqlite_autoindex__params_11 10#IauthOriginssqlite_autoindex_authOrigins_17 12#EauthOriginsidx_authOrigins_unique_pairs7 4 3 1em":false,"type":"autodate"}]{"authRule":"","manageRule":"@request.auth.collectionName = 'users'","authAlert":{"enabled":true,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location:\u003c/p\u003e\n\u003cp\u003e\u003cem\u003e{ALERT_INFO}\u003c/em\u003e\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[{"pkce":null,"name":"gitlab","clientId":"test","clientSecret":"test","authURL":"","tokenURL":"","userInfoURL":"","displayName":"","extra":null}],"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":false,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"passwordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"emailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"verificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"fileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2022-10-12 10:39:21.294Z2025-11-10 15:34:06.288Z["CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_username_idx` ON `nologin` (username)","CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_email_idx` ON `nologin` (email) WHERE email != ''","CREATE UNIQUE INDEX `_kpv709sk2lqbqk8_tokenKey_idx` ON `nologin` (tokenKey)","CREATE INDEX `_kpv709sk2lqbqk8_created_idx` ON \"nologin\" (`created`)"] ]�yk � ]�O�+=M++=_pbc_27738676752024-08-29 11:07:31.948Z64bec65f11bca24081ea47db82d004cfp70fhvf70ba4c59sywbhecnh46rhm02024-08-29 11:07:31.948Z��)=M++=pbc_31426358232026-02-28 21:05:51.904Zf52302b146518dfc78aa8f196a407b08n1sfvetkzv8jrujsywbhecnh46rhm02026-02-28 21:05:51.904Z�+=M++=v851q4r790rhknl2024-07-26 12:22:37.681Z22bbbcbed36e25321f384ccf99f600579r2j0m74260ur8igk390qegs4y47wn2024-07-26 12:22:37.681Z�)=M++=pbc_31426358232024-07-26 12:12:17.972Zdc879cfc889d0f1c1f3258d6f3a828fe5798yh833k6w6w0sbmbsdb40jyxf7h2024-11-04 16:41:03.650ZZ�)=M++=pbc_31426358232024-07-26 12:11:38.697Z6afbfe481c31c08c55a746cccb88ece0ic55o70g4f8pcl4sbmbsdb40jyxf7h2024-11-04 16:41:03.654ZZ�)=M++=pbc_31426358232024-07-13 09:24:15.442Z6afbfe481c31c08c55a746cccb88ece05f29jy38bf5zm3fsywbhecnh46rhm02024-11-04 16:41:03.658ZZ�)=M++=pbc_31426358232024-07-26 12:10:47.102Z22bbbcbed36e25321f384ccf99f60057dmy260k6ksjr4ibsbmbsdb40jyxf7h2024-11-04 16:41:03.656ZZ ��uu+p70fhvf70ba4c59+n1sfvetkzv8jruj+9r2j0m74260ur8i+5798yh833k6w6w0ic55o70g4f8pcl4+ic55o70g4f8pcl4+dmy260k6ksjr4ib+5f29jy38bf5zm3f IBI+_pbc_2773867675+v851q4r790rhknl+_pbc_2773867675+_pbc_2773867675+_pbc_2773867675_pbc_2773867675+_pbc_2773867675 vb��2�bbbD++M_pbc_2773867675sywbhecnh46rhm064bec65f11bca24081ea47db82d004cfD++Mv851q4r790rhknlgk390qegs4y47wn22bbbcbed36e25321f384ccf99f60057C)+Mpbc_3142635823sywbhecnh46rhm06afbfe481c31c08c55a746cccb88ece0C)+Mpbc_3142635823sbmbsdb40jyxf7h6afbfe481c31c08c55a746cccb88ece0DC)+Mpbc_3142635823sbmbsdb40jyxf7hdc879cfc889d0f1c1f3258d6f3a828feDMpbc_3142635823sywbhecnh46rhm0f52302b146518dfc78aa8f196a407b08DC)+Mpbc_3142635823sbmbsdb40jyxf7h22bbbcbed36e25321f384ccf99f60057 {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[{"pkce":null,"name":"gitlab","clientId":"test1","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":""},{"pkce":null,"name":"google","clientId":"test","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":""}],"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":true,"duration":1800,"rule":""},"otp":{"enabled":true,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"passwordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"emailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"verificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"fileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2022-10-10 09:49:46.145Z2024-09-13 10:48:13.365Z["CREATE UNIQUE INDEX `__pb_users_auth__username_idx` ON `users` (username)","CREATE UNIQUE INDEX `__pb_users_auth__email_idx` ON `users` (email) WHERE email != ''","CREATE UNIQUE INDEX `__pb_users_auth__tokenKey_idx` ON `users` (tokenKey)","CREATE INDEX `__pb_users_auth__created_idx` ON `users` (`created`)"]presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]{"authRule":"","manageRule":null,"authAlert":{"enabled":true,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location:\u003c/p\u003e\n\u003cp\u003e\u003cem\u003e{ALERT_INFO}\u003c/em\u003e\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"MyN3nDlzmHnuCjd35vb6cyIdqNr7Os0PmgiPVDMxmbFToSpBvS","duration":1209600},"passwordResetToken":{"secret":"fPSpFm9rxjj4mdeWYfyQ5OZQ4UWpyainTO0dqrJe3LHEYEDduq","duration":1800},"emailChangeToken":{"secret":"unYNiYeuIxH7BCV09NIb81abe2bkPgaexMYdDQ6uOOIFh74urD","duration":1800},"verificationToken":{"secret":"uhr68rXLVjPBWALFtw8uEHeQwDdN4t0MiTLr2pBWVkEQnNICe1","duration":259200},"fileToken":{"secret":"sjJAjTNPrOcRDmnIKwQm7qY9FyjuXTG5KNcaqw4U1TSDVfu4r9","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2024-06-20 09:29:22.826Z2025-11-10 15:33:49.591Z["CREATE UNIQUE INDEX `idx_tokenKey__pbc_3323866339` ON `_superusers` (`tokenKey`)","CREATE UNIQUE INDEX `idx_email__pbc_3323866339` ON `_superusers` (`email`) WHERE `email` != ''"]_NAME} account from a new location:\u003c/p\u003e\n\u003cp\u003e\u003cem\u003e{ALERT_INFO}\u003c/em\u003e\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[{"pkce":null,"name":"gitlab","clientId":"test1","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":"","extra":null},{"pkce":null,"name":"google","clientId":"test","clientSecret":"test2","authURL":"","tokenURL":"","userInfoURL":"","displayName":"","extra":null}],"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":true,"duration":1800,"rule":""},"otp":{"enabled":true,"duration":300,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"PjVU4hAV7CZIWbCByJHkDcMUlSEWCLI6M5aWSZOpEq0a3rYxKT","duration":1209600},"passwordResetToken":{"secret":"BC6jYPe4JXpQGGNzu6VXtYw0yhKoH2mh2ezIJClOJQuZYrd4Ol","duration":1800},"emailChangeToken":{"secret":"eON2TTJZiGCEi7mvUvwMLADj8CMHQzwZN3gmyMjQb24EY08ATP","duration":1800},"verificationToken":{"secret":"dgGGHlzzdCJ2C5MjXGoondllwSXkJHyL50FuvLvXGHNmBhvGKO","duration":604800},"fileToken":{"secret":"4Ax9zDm2Rwtny81dGaGQrJQBnIx5wVOuNe89X6v7NbNzrAZhvn","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello {RECORD:name}{RECORD:tokenKey},\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n Thanks,\u003cbr/\u003e\n {APP_NAME} team\n\u003c/p\u003e"}}2022-10-10 09:49:46.145Z2025-11-10 15:33:37.841Z["CREATE UNIQUE INDEX `__pb_users_auth__username_idx` ON `users` (username)","CREATE UNIQUE INDEX `__pb_users_auth__email_idx` ON `users` (email) WHERE email != ''","CREATE UNIQUE INDEX `__pb_users_auth__tokenKey_idx` ON `users` (tokenKey)","CREATE INDEX `__pb_users_auth__created_idx` ON `users` (`created`)"]