FreeBSD Support #941
Closed
mietzen
started this conversation in
Feature requests
FreeBSD Support
#941
Replies: 2 comments
-
|
Never mind, it works 👍 You need to include the front end in the build: |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
I've added freebsd support. Enjoy :) |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Hi, I tried cross compailing UpSnap for FreeBSD:
But when trying to reach the webinterface I get:
I marked it as "Feature requests" since FreeBSD is not officialy supported, I attached a full
--devlog, but I couldn't find any obvious hints in there.Full dev log
``` # ./upsnap serve --dev [35.00ms] CREATE TABLE IF NOT EXISTS `_migrations` (file VARCHAR(255) PRIMARY KEY NOT NULL, applied INTEGER NOT NULL) [0.00ms] SELECT count(*) FROM `_migrations` WHERE `file`='1640988000_aux_init.go' LIMIT 1 [0.00ms] INSERT INTO `_migrations` (`applied`, `file`) VALUES (1736787682911744, '1640988000_aux_init.go') [0.00ms] SELECT count(*) FROM `_migrations` WHERE `file`='1640988000_init.go' LIMIT 1 [1.00ms] CREATE TABLE `_params` ( `id` TEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL, `value` JSON DEFAULT NULL, `created` TEXT DEFAULT (strftime('%Y-%m-%d %H:%M:%fZ')) NOT NULL, `updated` TEXT DEFAULT (strftime('%Y-%m-%d %H:%M:%fZ')) NOT NULL );[2.00ms]
CREATE TABLE
_collections(idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,systemBOOLEAN DEFAULT FALSE NOT NULL,typeTEXT DEFAULT "base" NOT NULL,nameTEXT UNIQUE NOT NULL,fieldsJSON DEFAULT "[]" NOT NULL,indexesJSON DEFAULT "[]" NOT NULL,listRuleTEXT DEFAULT NULL,viewRuleTEXT DEFAULT NULL,createRuleTEXT DEFAULT NULL,updateRuleTEXT DEFAULT NULL,deleteRuleTEXT DEFAULT NULL,optionsJSON DEFAULT "{}" NOT NULL,createdTEXT DEFAULT (strftime('%Y-%m-%d %H:%M:%fZ')) NOT NULL,updatedTEXT DEFAULT (strftime('%Y-%m-%d %H:%M:%fZ')) NOT NULL);
[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_2279338944' LIMIT 1[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_2279338944' LIMIT 1[0.00ms] SELECT
idFROM_collectionsWHEREid='pbc_2279338944' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_mfas') AND (id<>'pbc_3233087073') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_mfas'[0.00ms] SELECT count() FROM
_collectionsWHERE LOWER(name)='_mfas' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_mfas')) LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_mfas'))) AND (LOWER(name)=LOWER('idx_mfas_collectionRef_recordRef')) LIMIT 1[8.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:22.919Z', NULL, '[{"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"}]', 'pbc_2279338944', '["CREATE INDEXidx_mfas_collectionRef_recordRefON_mfas(collectionRef,recordRef)"]', 0x86c0b87e0, '_mfas', '{}', true, 'base', NULL, '2025-01-13 17:01:22.919Z', 0x86c0b87f0)[2.00ms] CREATE TABLE
_mfas(collectionRefTEXT DEFAULT '' NOT NULL,createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,methodTEXT DEFAULT '' NOT NULL,recordRefTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[1.00ms] CREATE INDEX
idx_mfas_collectionRef_recordRefON_mfas(collectionRef,recordRef)
[4.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_1638494021' LIMIT 1[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_1638494021' LIMIT 1[0.00ms] SELECT
idFROM_collectionsWHEREid='pbc_1638494021' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_otps') AND (id<>'pbc_3233087073') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_otps'[0.00ms] SELECT count() FROM
_collectionsWHERE LOWER(name)='_otps' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_otps')) LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_otps'))) AND (LOWER(name)=LOWER('idx_otps_collectionRef_recordRef')) LIMIT 1[2.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:22.972Z', NULL, '[{"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"},{"autogeneratePattern":"","hidden":true,"id":"text3866985172","max":0,"min":0,"name":"sentTo","pattern":"","presentable":false,"primaryKey":false,"required":false,"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"}]', 'pbc_1638494021', '["CREATE INDEXidx_otps_collectionRef_recordRefON_otps(collectionRef, recordRef)"]', 0x86c279910, '_otps', '{}', true, 'base', NULL, '2025-01-13 17:01:22.972Z', 0x86c279920)[2.00ms] CREATE TABLE
_otps(collectionRefTEXT DEFAULT '' NOT NULL,createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,passwordTEXT DEFAULT '' NOT NULL,recordRefTEXT DEFAULT '' NOT NULL,sentToTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[1.00ms] CREATE INDEX
idx_otps_collectionRef_recordRefON_otps(collectionRef,recordRef)
[0.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_2281828961' LIMIT 1[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_2281828961' LIMIT 1[0.00ms] SELECT
idFROM_collectionsWHEREid='pbc_2281828961' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_externalauths') AND (id<>'pbc_3233087073') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_externalAuths'[0.00ms] SELECT count() FROM
_collectionsWHERE LOWER(name)='_externalauths' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_externalAuths')) LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(name)=LOWER('idx_externalAuths_record_provider')) LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(name)=LOWER('idx_externalAuths_collection_provider')) LIMIT 1[2.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.009Z', 0x86c0b9a20, '[{"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"}]', 'pbc_2281828961', '["CREATE UNIQUE INDEXidx_externalAuths_record_providerON_externalAuths(collectionRef, recordRef, provider)","CREATE UNIQUE INDEXidx_externalAuths_collection_providerON_externalAuths(collectionRef, provider, providerId)"]', 0x86c0b9a00, '_externalAuths', '{}', true, 'base', NULL, '2025-01-13 17:01:23.009Z', 0x86c0b9a10)[2.00ms] CREATE TABLE
_externalAuths(collectionRefTEXT DEFAULT '' NOT NULL,createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,providerTEXT DEFAULT '' NOT NULL,providerIdTEXT DEFAULT '' NOT NULL,recordRefTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[1.00ms] CREATE UNIQUE INDEX
idx_externalAuths_record_providerON_externalAuths(collectionRef,recordRef,provider)
[1.00ms] CREATE UNIQUE INDEX
idx_externalAuths_collection_providerON_externalAuths(collectionRef,provider,providerId)
[0.00ms] PRAGMA optimize
[1.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_4275539003' LIMIT 1[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_4275539003' LIMIT 1[0.00ms] SELECT
idFROM_collectionsWHEREid='pbc_4275539003' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_authorigins') AND (id<>'pbc_3233087073') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_authOrigins'[0.00ms] SELECT count() FROM
_collectionsWHERE LOWER(name)='_authorigins' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_authOrigins')) LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_authOrigins'))) AND (LOWER(name)=LOWER('idx_authOrigins_unique_pairs')) LIMIT 1[5.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.054Z', 0x86c30d680, '[{"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"}]', 'pbc_4275539003', '["CREATE UNIQUE INDEXidx_authOrigins_unique_pairsON_authOrigins(collectionRef, recordRef, fingerprint)"]', 0x86c30d660, '_authOrigins', '{}', true, 'base', NULL, '2025-01-13 17:01:23.055Z', 0x86c30d670)[4.00ms] CREATE TABLE
_authOrigins(collectionRefTEXT DEFAULT '' NOT NULL,createdTEXT DEFAULT '' NOT NULL,fingerprintTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,recordRefTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[1.00ms] CREATE UNIQUE INDEX
idx_authOrigins_unique_pairsON_authOrigins(collectionRef,recordRef,fingerprint)
[0.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[1.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_3142635823' LIMIT 1[0.00ms] SELECT (1) FROM
_collectionsWHEREid='pbc_3142635823' LIMIT 1[0.00ms] SELECT
idFROM_collectionsWHEREid='pbc_3142635823' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_superusers') AND (id<>'pbc_4175343705') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_superusers'[0.00ms] SELECT count() FROM
_collectionsWHERE LOWER(name)='_superusers' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_superusers')) LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_tokenKey_pbc_3142635823')) LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_email_pbc_3142635823')) LIMIT 1[1.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.102Z', NULL, '[{"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","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"}]', 'pbc_3142635823', '["CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey)","CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= ''''"]', NULL, 'superusers', '{"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\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":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"FLc2Dlshm0kNJfE8ss5sLxg6ZTxCVHfBqKCDYgzQRhKXpYXO4U","duration":86400},"passwordResetToken":{"secret":"EGDKY84RweV6MCQ2hEuUxOzLGcexKwZyxCJkhJuM0oYYNfB6pL","duration":1800},"emailChangeToken":{"secret":"JlZibajam0UuJFdzOaxlfQ2NkQ2TRAP6CsBrhhrMKeptEjNBbB","duration":1800},"verificationToken":{"secret":"GEPcIVDrHv7tweeFR1Y6RipDYlg93kLzhSZXEM8Wt7bn60p9ZG","duration":259200},"fileToken":{"secret":"5PlQpyDD5I8AtXFLkZgtYvOLcRA2rxHVgn82snhg7lZ3AfhNbm","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"', true, 'auth', NULL, '2025-01-13 17:01:23.102Z', NULL) [2.00ms] CREATE TABLE_superusers(createdTEXT DEFAULT '' NOT NULL,emailTEXT DEFAULT '' NOT NULL,emailVisibilityBOOLEAN DEFAULT FALSE NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,passwordTEXT DEFAULT '' NOT NULL,tokenKeyTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL,verifiedBOOLEAN DEFAULT FALSE NOT NULL) [1.00ms] CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey) [1.00ms] CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= '' [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [2.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [0.00ms] SELECTidFROM_collectionsWHEREid='_pb_users_auth_' LIMIT 1 [0.00ms] SELECT count(*) FROM_collectionsWHERE (LOWER(name)='users') AND (id<>'pbc_4175343705') LIMIT 1 [0.00ms] SELECT_collections.* FROM_collectionsWHEREid='users' [0.00ms] SELECT count(*) FROM_collectionsWHERE LOWER(name)='users' LIMIT 1 [0.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('users')) LIMIT 1 [1.00ms] SELECT_collections.* FROM_collectionsWHEREid='_pb_users_auth_' OR LOWER(name)='_pb_users_auth_' LIMIT 1 [0.00ms] SELECT_collections.* FROMcollectionsWHEREid='_pb_users_auth_' OR LOWER(name)='_pb_users_auth_' LIMIT 1 [0.00ms] SELECTtbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('idx_tokenKey__pb_users_auth_')) LIMIT 1 [0.00ms] SELECTtbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER(''))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('idx_email__pb_users_auth_')) LIMIT 1 [5.00ms] INSERT INTOcollections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (0x86c434f50, '2025-01-13 17:01:23.189Z', 0x86c434f70, '[{"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","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"text1579384326","max":255,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"file376926767","maxSelect":1,"maxSize":0,"mimeTypes":["image/jpeg","image/png","image/svg+xml","image/gif","image/webp"],"name":"avatar","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', '_pb_users_auth_', '["CREATE UNIQUE INDEXidx_tokenKey__pb_users_authONusers(tokenKey)","CREATE UNIQUE INDEXidx_email__pb_users_authONusers(email) WHEREemail!= ''''"]', 0x86c434f30, 'users', '{"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\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":null,"mappedFields":{"id":"","name":"name","username":"","avatarURL":"avatar"},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"062x14P7GS0RejuDil3M3chTt8M5GUWhfNf7YG0Adhlwlt7gyX","duration":604800},"passwordResetToken":{"secret":"DfC6PZI9uQk0Ib2Qsejbtre3wpNuykn5OfoPKVbWTku4d7m0iB","duration":1800},"emailChangeToken":{"secret":"y145Xw2VL9K29mhDHbfMFEXEW6npTiqTi2zVyU8HB1zx5WoQMA","duration":1800},"verificationToken":{"secret":"HQhc8vnirKCTo42pHWzZvu1hv9fSSeqBRSJGZ34s23VPSny4Kx","duration":259200},"fileToken":{"secret":"cqKxXuGd3Oujb6yrGr92ZUCwjqSFthvqKcJZZsrFI4cav1RgYN","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"', false, 'auth', 0x86c434f60, '2025-01-13 17:01:23.189Z', 0x86c434f40)[3.00ms] CREATE TABLE
users(avatarTEXT DEFAULT '' NOT NULL,createdTEXT DEFAULT '' NOT NULL,emailTEXT DEFAULT '' NOT NULL,emailVisibilityBOOLEAN DEFAULT FALSE NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,nameTEXT DEFAULT '' NOT NULL,passwordTEXT DEFAULT '' NOT NULL,tokenKeyTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL,verifiedBOOLEAN DEFAULT FALSE NOT NULL)[1.00ms] CREATE UNIQUE INDEX
idx_tokenKey__pb_users_auth_ONusers(tokenKey)[1.00ms] CREATE UNIQUE INDEX
idx_email__pb_users_auth_ONusers(email) WHEREemail!= ''[0.00ms] PRAGMA optimize
[1.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[2.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787683276462, '1640988000_init.go')[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233556_v0.23_migrate.go' LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_mfas')) LIMIT 1[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_authOrigins')) LIMIT 1[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787683280450, '1717233556_v0.23_migrate.go')[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233557_v0.23_migrate2.go' LIMIT 1[0.00ms] CREATE INDEX IF NOT EXISTS idx__collections_type on
_collections(type);[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='_mfas' OR LOWER(name)='_mfas' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='_otps' OR LOWER(name)='_otps' LIMIT 1[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787683288513, '1717233557_v0.23_migrate2.go')[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233558_v0.23_migrate3.go' LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREnameIN ('_mfas', '_otps', '_externalAuths', '_authOrigins', '_superusers')[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid<>'pbc_2279338944'[0.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pbc_2279338944' ORDER BYcreatedDESC[1.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pbc_2279338944' ORDER BYcreatedDESC[1.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pbc_2279338944' ORDER BYcreatedDESC[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid<>'pbc_1638494021'[1.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pbc_1638494021' ORDER BYcreatedDESC[0.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pbc_1638494021' ORDER BYcreatedDESC[0.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pbc_1638494021' ORDER BYcreatedDESC[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid<>'pbc_2281828961'[0.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pbc_2281828961' ORDER BYcreatedDESC[1.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pbc_2281828961' ORDER BYcreatedDESC[1.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pbc_2281828961' ORDER BYcreatedDESC[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid<>'pbc_4275539003'[1.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pbc_4275539003' ORDER BYcreatedDESC[0.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pbc_4275539003' ORDER BYcreatedDESC[0.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pbc_4275539003' ORDER BYcreatedDESC[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid<>'pbc_3142635823'[1.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pbc_3142635823' ORDER BYcreatedDESC[0.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pbc_3142635823' ORDER BYcreatedDESC[0.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pbc_3142635823' ORDER BYcreatedDESC[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787683367905, '1717233558_v0.23_migrate3.go')[1.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233559_v0.23_migrate4.go' LIMIT 1[2.00ms] SELECT
_collections. FROM_collectionsWHEREid='otps' OR LOWER(name)='otps' LIMIT 1[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787683379921, '1717233559_v0.23_migrate4.go')[7.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] SELECT
_params.* FROM_paramsWHEREid='settings'[1.00ms] INSERT INTO
_params(created,id,updated,value) VALUES ('2025-01-13 17:01:23.412Z', 'settings', '2025-01-13 17:01:23.412Z', 0x7b22736d7470223a7b22656e61626c6564223a66616c73652c22706f7274223a3538372c22686f7374223a22736d74702e6578616d706c652e636f6d222c22757365726e616d65223a22222c22617574684d6574686f64223a22222c22746c73223a66616c73652c226c6f63616c4e616d65223a22227d2c226261636b757073223a7b2263726f6e223a22222c2263726f6e4d61784b656570223a332c227333223a7b22656e61626c6564223a66616c73652c226275636b6574223a22222c22726567696f6e223a22222c22656e64706f696e74223a22222c226163636573734b6579223a22222c22666f726365506174685374796c65223a66616c73657d7d2c227333223a7b22656e61626c6564223a66616c73652c226275636b6574223a22222c22726567696f6e223a22222c22656e64706f696e74223a22222c226163636573734b6579223a22222c22666f726365506174685374796c65223a66616c73657d2c226d657461223a7b226170704e616d65223a2241636d65222c2261707055524c223a22687474703a2f2f6c6f63616c686f73743a38303930222c2273656e6465724e616d65223a22537570706f7274222c2273656e64657241646472657373223a22737570706f7274406578616d706c652e636f6d222c2268696465436f6e74726f6c73223a66616c73657d2c22726174654c696d697473223a7b2272756c6573223a5b7b226c6162656c223a222a3a61757468222c2261756469656e6365223a22222c226475726174696f6e223a332c226d61785265717565737473223a327d2c7b226c6162656c223a222a3a637265617465222c2261756469656e6365223a22222c226475726174696f6e223a352c226d61785265717565737473223a32307d2c7b226c6162656c223a222f6170692f6261746368222c2261756469656e6365223a22222c226475726174696f6e223a312c226d61785265717565737473223a337d2c7b226c6162656c223a222f6170692f222c2261756469656e6365223a22222c226475726174696f6e223a31302c226d61785265717565737473223a3330307d5d2c22656e61626c6564223a66616c73657d2c227472757374656450726f7879223a7b2268656164657273223a5b5d2c227573654c6566746d6f73744950223a66616c73657d2c226261746368223a7b22656e61626c6564223a66616c73652c226d61785265717565737473223a35302c2274696d656f7574223a332c226d6178426f647953697a65223a307d2c226c6f6773223a7b226d617844617973223a352c226d696e4c6576656c223a302c226c6f674950223a747275652c226c6f67417574684964223a66616c73657d7d)[1.00ms] SELECT
_params.* FROM_paramsWHEREid='settings'[2.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] CREATE TABLE IF NOT EXISTS
_migrations(file VARCHAR(255) PRIMARY KEY NOT NULL, applied INTEGER NOT NULL)[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1640988000_aux_init.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1640988000_init.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233556_v0.23_migrate.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233557_v0.23_migrate2.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233558_v0.23_migrate3.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1717233559_v0.23_migrate4.go' LIMIT 1[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1735377462_collections_snapshot.go' LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='z5lghx2r3tm45n1' OR LOWER(name)='z5lghx2r3tm45n1' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='cti4l8f4mz8df3r' OR LOWER(name)='cti4l8f4mz8df3r' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='nmj3ko20gzkg8n3' OR LOWER(name)='nmj3ko20gzkg8n3' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='t1rajoyzl6691g3' OR LOWER(name)='t1rajoyzl6691g3' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='djqp3uxrac2ores' OR LOWER(name)='djqp3uxrac2ores' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='7emu7fnnwuim2ua' OR LOWER(name)='7emu7fnnwuim2ua' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsORDER BYupdatedASC[2.00ms] DROP TABLE IF EXISTS
users[0.00ms] DELETE FROM
_collectionsWHEREid='pb_users_auth'[0.00ms] SELECT
_authOrigins.* FROM_authOriginsWHEREcollectionRef='pb_users_auth'[0.00ms] SELECT
_otps.* FROM_otpsWHEREcollectionRef='pb_users_auth'[1.00ms] SELECT
_mfas.* FROM_mfasWHEREcollectionRef='pb_users_auth'[1.00ms] SELECT
_externalAuths.* FROM_externalAuthsWHEREcollectionRef='pb_users_auth'[1.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[9.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (0x86c279b60, '2025-01-13 17:01:23.578Z', 0x86c279b70, '[{"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":"tiqcmnjo","max":0,"min":0,"name":"name","pattern":"","presentable":true,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"1si6ajha","max":0,"min":0,"name":"ip","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"fyqmpon6","max":0,"min":0,"name":"mac","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"s8c5z7n0","max":0,"min":0,"name":"netmask","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"cascadeDelete":false,"collectionId":"cti4l8f4mz8df3r","hidden":false,"id":"ilrwvlev","maxSelect":2147483647,"minSelect":0,"name":"ports","presentable":false,"required":false,"system":false,"type":"relation"},{"exceptDomains":null,"hidden":false,"id":"gdctb8hj","name":"link","onlyDomains":null,"presentable":false,"required":false,"system":false,"type":"url"},{"autogeneratePattern":"","hidden":false,"id":"kzvdbbws","max":0,"min":0,"name":"wake_cron","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"dcd3vuc3","name":"wake_cron_enabled","presentable":false,"required":false,"system":false,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"91bs6clw","max":0,"min":0,"name":"shutdown_cron","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"vnlymcuw","name":"shutdown_cron_enabled","presentable":false,"required":false,"system":false,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"1a7yrwo9","max":0,"min":0,"name":"shutdown_cmd","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"iarksm3l","max":0,"min":0,"name":"password","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"cascadeDelete":false,"collectionId":"djqp3uxrac2ores","hidden":false,"id":"rk2vrn57","maxSelect":2147483647,"minSelect":0,"name":"groups","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"27do0wbcuyfmbmx","hidden":false,"id":"naciykac","maxSelect":1,"minSelect":0,"name":"created_by","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"qmiatdwa","maxSelect":1,"name":"status","presentable":false,"required":false,"system":false,"type":"select","values":["pending","online","offline"]},{"hidden":false,"id":"ueieydw5","name":"sol_enabled","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"yfszwhpw","name":"sol_auth","presentable":false,"required":false,"system":false,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"dbcmnrmp","max":0,"min":0,"name":"sol_user","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"hvz8stfy","max":0,"min":0,"name":"sol_password","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"6kfqheid","max":65535,"min":1,"name":"sol_port","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"hidden":false,"id":"chtoblvl","name":"wake_confirm","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"muqy3axq","name":"shutdown_confirm","presentable":false,"required":false,"system":false,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"murx1eum","max":0,"min":0,"name":"wake_cmd","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"kefxqjbj","max":0,"min":0,"name":"ping_cmd","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', 'z5lghx2r3tm45n1', '["CREATE INDEX_z5lghx2r3tm45n1_created_idxONdevices(created)"]', 0x86c2e81b0, 'devices', '{}', false, 'base', 0x86c2e81c0, '2025-01-13 17:01:23.578Z', 0x86c2e81d0)[3.00ms] CREATE TABLE
devices(createdTEXT DEFAULT '' NOT NULL,created_byTEXT DEFAULT '' NOT NULL,groupsJSON DEFAULT '[]' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,ipTEXT DEFAULT '' NOT NULL,linkTEXT DEFAULT '' NOT NULL,macTEXT DEFAULT '' NOT NULL,nameTEXT DEFAULT '' NOT NULL,netmaskTEXT DEFAULT '' NOT NULL,passwordTEXT DEFAULT '' NOT NULL,ping_cmdTEXT DEFAULT '' NOT NULL,portsJSON DEFAULT '[]' NOT NULL,shutdown_cmdTEXT DEFAULT '' NOT NULL,shutdown_confirmBOOLEAN DEFAULT FALSE NOT NULL,shutdown_cronTEXT DEFAULT '' NOT NULL,shutdown_cron_enabledBOOLEAN DEFAULT FALSE NOT NULL,sol_authBOOLEAN DEFAULT FALSE NOT NULL,sol_enabledBOOLEAN DEFAULT FALSE NOT NULL,sol_passwordTEXT DEFAULT '' NOT NULL,sol_portNUMERIC DEFAULT 0 NOT NULL,sol_userTEXT DEFAULT '' NOT NULL,statusTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL,wake_cmdTEXT DEFAULT '' NOT NULL,wake_confirmBOOLEAN DEFAULT FALSE NOT NULL,wake_cronTEXT DEFAULT '' NOT NULL,wake_cron_enabledBOOLEAN DEFAULT FALSE NOT NULL)[1.00ms] CREATE INDEX
_z5lghx2r3tm45n1_created_idxONdevices(created)[1.00ms] PRAGMA optimize
[1.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[1.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[1.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.615Z', NULL, '[{"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"},{"hidden":false,"id":"8nwuncgg","max":65535,"min":1,"name":"number","onlyInt":false,"presentable":false,"required":true,"system":false,"type":"number"},{"autogeneratePattern":"","hidden":false,"id":"o0he3pu6","max":0,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"w0bh39gv","name":"status","presentable":false,"required":false,"system":false,"type":"bool"},{"exceptDomains":null,"hidden":false,"id":"i3uvw7ij","name":"link","onlyDomains":null,"presentable":false,"required":false,"system":false,"type":"url"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', 'cti4l8f4mz8df3r', '["CREATE INDEX_cti4l8f4mz8df3r_created_idxONports(created)"]', 0x86c2e8e60, 'ports', '{}', false, 'base', NULL, '2025-01-13 17:01:23.615Z', 0x86c2e8e70)[2.00ms] CREATE TABLE
ports(createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,linkTEXT DEFAULT '' NOT NULL,nameTEXT DEFAULT '' NOT NULL,numberNUMERIC DEFAULT 0 NOT NULL,statusBOOLEAN DEFAULT FALSE NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[1.00ms] CREATE INDEX
_cti4l8f4mz8df3r_created_idxONports(created)[0.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[1.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.633Z', NULL, '[{"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":"ph88gaa5","max":0,"min":0,"name":"interval","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"agw2fyd1","max":0,"min":0,"name":"scan_range","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"yjyq5pvg","name":"lazy_ping","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', 'nmj3ko20gzkg8n3', '["CREATE INDEX_nmj3ko20gzkg8n3_created_idxON "settings_private" (created)"]', NULL, 'settings_private', '{}', false, 'base', NULL, '2025-01-13 17:01:23.633Z', NULL)[1.00ms] CREATE TABLE
settings_private(createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,intervalTEXT DEFAULT '' NOT NULL,lazy_pingBOOLEAN DEFAULT FALSE NOT NULL,scan_rangeTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL)[0.00ms] CREATE INDEX
_nmj3ko20gzkg8n3_created_idxONsettings_private(created)[0.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[1.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[2.00ms] INSERT INTO
_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (0x86c37b330, '2025-01-13 17:01:23.653Z', 0x86c37b340, '[{"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":10,"hidden":true,"id":"password901924565","max":0,"min":5,"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":false,"system":true,"type":"email"},{"hidden":false,"id":"bool1547992806","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"users[0-9]{6}","hidden":false,"id":"text4166911607","max":150,"min":3,"name":"username","pattern":"^[\w][\w\.\-]*$","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"i1qnezoa","max":9,"min":0,"name":"avatar","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', '27do0wbcuyfmbmx', '["CREATE UNIQUE INDEX_27do0wbcuyfmbmx_username_idxONusers(username COLLATE NOCASE)","CREATE UNIQUE INDEX_27do0wbcuyfmbmx_email_idxONusers(email) WHEREemail!= ''''","CREATE UNIQUE INDEX_27do0wbcuyfmbmx_tokenKey_idxONusers(tokenKey)","CREATE INDEX_27do0wbcuyfmbmx_created_idxONusers(created)"]', 0x86c37b540, 'users', '{"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\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":null,"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"7kUrHXKaSLiaIK0JHOnp2USMy5AOeiGJxlXj1YbTB0WShI6UMO","duration":1209600},"passwordResetToken":{"secret":"SPpo1FUjxCzdkqMR1d2qwe1gA4pJxCVZn02mClCKsq1VfMcIUF","duration":1800},"emailChangeToken":{"secret":"YfFDshBR4OjEHqNKwK6aSSsRCRyVcb4CQb3X2nwUmlKjS1ixPS","duration":1800},"verificationToken":{"secret":"ad0ltkuGbtnF9i9YyFk5CUtZzub31y09dBNMpsQsuh8EveZQ2x","duration":604800},"fileToken":{"secret":"l6fIkSc6wOhQgG89Ub0kgetff86G91c48De1IjLOGq0iQ0jJhv","duration":120},"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"', false, 'auth', 0x86c37b550, '2025-01-13 17:01:23.653Z', 0x86c37b560) [2.00ms] CREATE TABLEusers(avatarNUMERIC DEFAULT 0 NOT NULL,createdTEXT DEFAULT '' NOT NULL,emailTEXT DEFAULT '' NOT NULL,emailVisibilityBOOLEAN DEFAULT FALSE NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,passwordTEXT DEFAULT '' NOT NULL,tokenKeyTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL,usernameTEXT DEFAULT '' NOT NULL,verifiedBOOLEAN DEFAULT FALSE NOT NULL) [1.00ms] CREATE UNIQUE INDEX_27do0wbcuyfmbmx_username_idxONusers(usernameCOLLATE NOCASE) [1.00ms] CREATE UNIQUE INDEX_27do0wbcuyfmbmx_email_idxONusers(email) WHEREemail!= '' [5.00ms] CREATE UNIQUE INDEX_27do0wbcuyfmbmx_tokenKey_idxONusers(tokenKey) [1.00ms] CREATE INDEX_27do0wbcuyfmbmx_created_idxONusers(created) [0.00ms] PRAGMA optimize [1.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [1.00ms] INSERT INTO_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.693Z', NULL, '[{"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":"s1grje98","max":0,"min":0,"name":"website_title","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"tlzz87pj","maxSelect":1,"maxSize":5242880,"mimeTypes":["image/x-icon","image/png","image/svg+xml","image/gif","image/jpeg"],"name":"favicon","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"},{"hidden":false,"id":"vrxqcsnv","name":"setup_completed","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', 't1rajoyzl6691g3', '["CREATE INDEX_t1rajoyzl6691g3_created_idxONsettings_public(created)"]', 0x86c406160, 'settings_public', '{}', false, 'base', NULL, '2025-01-13 17:01:23.693Z', 0x86c406170) [1.00ms] CREATE TABLEsettings_public(createdTEXT DEFAULT '' NOT NULL,faviconTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,setup_completedBOOLEAN DEFAULT FALSE NOT NULL,updatedTEXT DEFAULT '' NOT NULL,website_titleTEXT DEFAULT '' NOT NULL) [0.00ms] CREATE INDEX_t1rajoyzl6691g3_created_idxONsettings_public(created) [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [1.00ms] INSERT INTO_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (0x86c406940, '2025-01-13 17:01:23.715Z', 0x86c406950, '[{"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":"b3oaemnp","max":0,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', 'djqp3uxrac2ores', '[]', 0x86c406a30, 'device_groups', '{}', false, 'base', 0x86c406a40, '2025-01-13 17:01:23.715Z', 0x86c406a50) [1.00ms] CREATE TABLEdevice_groups(createdTEXT DEFAULT '' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,nameTEXT DEFAULT '' NOT NULL,updatedTEXT DEFAULT '' NOT NULL) [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [2.00ms] INSERT INTO_collections(createRule,created,deleteRule,fields,id,indexes,listRule,name,options,system,type,updateRule,updated,viewRule) VALUES (NULL, '2025-01-13 17:01:23.735Z', 0x86c04b230, '[{"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"},{"cascadeDelete":false,"collectionId":"27do0wbcuyfmbmx","hidden":false,"id":"tzxtuykz","maxSelect":1,"minSelect":0,"name":"user","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"nd1ekexz","name":"create","presentable":false,"required":false,"system":false,"type":"bool"},{"cascadeDelete":false,"collectionId":"z5lghx2r3tm45n1","hidden":false,"id":"z79gcpy3","maxSelect":2147483647,"minSelect":0,"name":"read","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"z5lghx2r3tm45n1","hidden":false,"id":"t7wwbk2c","maxSelect":2147483647,"minSelect":0,"name":"update","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"z5lghx2r3tm45n1","hidden":false,"id":"b4u0gqa7","maxSelect":2147483647,"minSelect":0,"name":"delete","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":false,"collectionId":"z5lghx2r3tm45n1","hidden":false,"id":"nyeqt3fn","maxSelect":2147483647,"minSelect":0,"name":"power","presentable":false,"required":false,"system":false,"type":"relation"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]', '7emu7fnnwuim2ua', '["CREATE UNIQUE INDEXidx_2GIk1FoONpermissions(user)"]', 0x86c04b410, 'permissions', '{}', false, 'base', NULL, '2025-01-13 17:01:23.735Z', 0x86c04b420) [2.00ms] CREATE TABLEpermissions(createBOOLEAN DEFAULT FALSE NOT NULL,createdTEXT DEFAULT '' NOT NULL,deleteJSON DEFAULT '[]' NOT NULL,idTEXT PRIMARY KEY DEFAULT ('r'||lower(hex(randomblob(7)))) NOT NULL,powerJSON DEFAULT '[]' NOT NULL,readJSON DEFAULT '[]' NOT NULL,updateJSON DEFAULT '[]' NOT NULL,updatedTEXT DEFAULT '' NOT NULL,userTEXT DEFAULT '' NOT NULL) [1.00ms] CREATE UNIQUE INDEXidx_2GIk1FoONpermissions(user) [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [2.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:22.919Z',deleteRule=NULL,fields='[{"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"}]',id='pbc_2279338944',indexes='["CREATE INDEXidx_mfas_collectionRef_recordRefON_mfas(collectionRef,recordRef)"]',listRule=0x86c4343d0,name='_mfas',options='{}',system=true,type='base',updateRule=NULL,updated='2025-01-13 17:01:23.764Z',viewRule=0x86c4343e0 WHEREid='pbc_2279338944' [0.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_mfas')) LIMIT 1 [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [1.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:22.972Z',deleteRule=NULL,fields='[{"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"},{"autogeneratePattern":"","hidden":true,"id":"text3866985172","max":0,"min":0,"name":"sentTo","pattern":"","presentable":false,"primaryKey":false,"required":false,"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"}]',id='pbc_1638494021',indexes='["CREATE INDEXidx_otps_collectionRef_recordRefON_otps(collectionRef, recordRef)"]',listRule=0x86c435870,name='_otps',options='{}',system=true,type='base',updateRule=NULL,updated='2025-01-13 17:01:23.786Z',viewRule=0x86c435880 WHEREid='pbc_1638494021' [0.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_otps')) LIMIT 1 [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [2.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:23.009Z',deleteRule=0x86c30dda0,fields='[{"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"}]',id='pbc_2281828961',indexes='["CREATE UNIQUE INDEXidx_externalAuths_record_providerON_externalAuths(collectionRef, recordRef, provider)","CREATE UNIQUE INDEXidx_externalAuths_collection_providerON_externalAuths(collectionRef, provider, providerId)"]',listRule=0x86c30dd80,name='_externalAuths',options='{}',system=true,type='base',updateRule=NULL,updated='2025-01-13 17:01:23.816Z',viewRule=0x86c30dd90 WHEREid='pbc_2281828961' [1.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_externalAuths')) LIMIT 1 [0.00ms] PRAGMA optimize [1.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [1.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:23.054Z',deleteRule=0x86c0b9e10,fields='[{"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"}]',id='pbc_4275539003',indexes='["CREATE UNIQUE INDEXidx_authOrigins_unique_pairsON_authOrigins(collectionRef, recordRef, fingerprint)"]',listRule=0x86c0b9dd0,name='_authOrigins',options='{}',system=true,type='base',updateRule=NULL,updated='2025-01-13 17:01:23.843Z',viewRule=0x86c0b9df0 WHEREid='pbc_4275539003' [0.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_authOrigins')) LIMIT 1 [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [0.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [1.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:23.102Z',deleteRule=NULL,fields='[{"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","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"}]',id='pbc_3142635823',indexes='["CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey)","CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= ''''"]',listRule=NULL,name='_superusers',options='{"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\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":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"FLc2Dlshm0kNJfE8ss5sLxg6ZTxCVHfBqKCDYgzQRhKXpYXO4U","duration":1209600},"passwordResetToken":{"secret":"EGDKY84RweV6MCQ2hEuUxOzLGcexKwZyxCJkhJuM0oYYNfB6pL","duration":1800},"emailChangeToken":{"secret":"JlZibajam0UuJFdzOaxlfQ2NkQ2TRAP6CsBrhhrMKeptEjNBbB","duration":1800},"verificationToken":{"secret":"GEPcIVDrHv7tweeFR1Y6RipDYlg93kLzhSZXEM8Wt7bn60p9ZG","duration":259200},"fileToken":{"secret":"5PlQpyDD5I8AtXFLkZgtYvOLcRA2rxHVgn82snhg7lZ3AfhNbm","duration":120},"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"',system=true,type='auth',updateRule=NULL,updated='2025-01-13 17:01:23.865Z',viewRule=NULL WHEREid='pbc_3142635823'[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_superusers')) LIMIT 1[0.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[1.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='devices') AND (id<>'z5lghx2r3tm45n1') LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='devices'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='z5lghx2r3tm45n1' OR LOWER(name)='z5lghx2r3tm45n1' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='z5lghx2r3tm45n1' OR LOWER(name)='z5lghx2r3tm45n1' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('devices'))) AND (LOWER(tbl_name)!=LOWER('devices'))) AND (LOWER(name)=LOWER('_z5lghx2r3tm45n1_created_idx')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='ports') AND (id<>'cti4l8f4mz8df3r') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='ports'[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='cti4l8f4mz8df3r' OR LOWER(name)='cti4l8f4mz8df3r' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='cti4l8f4mz8df3r' OR LOWER(name)='cti4l8f4mz8df3r' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('ports'))) AND (LOWER(tbl_name)!=LOWER('ports'))) AND (LOWER(name)=LOWER('_cti4l8f4mz8df3r_created_idx')) LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='settings_private') AND (id<>'nmj3ko20gzkg8n3') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='settings_private'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='nmj3ko20gzkg8n3' OR LOWER(name)='nmj3ko20gzkg8n3' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='nmj3ko20gzkg8n3' OR LOWER(name)='nmj3ko20gzkg8n3' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('settings_private'))) AND (LOWER(tbl_name)!=LOWER('settings_private'))) AND (LOWER(name)=LOWER('_nmj3ko20gzkg8n3_created_idx')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='users') AND (id<>'27do0wbcuyfmbmx') LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='users'[2.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_username_idx')) LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_email_idx')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_tokenKey_idx')) LIMIT 1[0.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_created_idx')) LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='settings_public') AND (id<>'t1rajoyzl6691g3') LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='settings_public'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='t1rajoyzl6691g3' OR LOWER(name)='t1rajoyzl6691g3' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='t1rajoyzl6691g3' OR LOWER(name)='t1rajoyzl6691g3' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('settings_public'))) AND (LOWER(tbl_name)!=LOWER('settings_public'))) AND (LOWER(name)=LOWER('_t1rajoyzl6691g3_created_idx')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='device_groups') AND (id<>'djqp3uxrac2ores') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='device_groups'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='djqp3uxrac2ores' OR LOWER(name)='djqp3uxrac2ores' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='djqp3uxrac2ores' OR LOWER(name)='djqp3uxrac2ores' LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='permissions') AND (id<>'7emu7fnnwuim2ua') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='permissions'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='7emu7fnnwuim2ua' OR LOWER(name)='7emu7fnnwuim2ua' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='7emu7fnnwuim2ua' OR LOWER(name)='7emu7fnnwuim2ua' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('permissions'))) AND (LOWER(tbl_name)!=LOWER('permissions'))) AND (LOWER(name)=LOWER('idx_2GIk1Fo')) LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_mfas') AND (id<>'pbc_2279338944') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_mfas'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2279338944' OR LOWER(name)='pbc_2279338944' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_mfas'))) AND (LOWER(tbl_name)!=LOWER('_mfas'))) AND (LOWER(name)=LOWER('idx_mfas_collectionRef_recordRef')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_otps') AND (id<>'pbc_1638494021') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_otps'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_1638494021' OR LOWER(name)='pbc_1638494021' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_otps'))) AND (LOWER(tbl_name)!=LOWER('_otps'))) AND (LOWER(name)=LOWER('idx_otps_collectionRef_recordRef')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_externalauths') AND (id<>'pbc_2281828961') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_externalAuths'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_2281828961' OR LOWER(name)='pbc_2281828961' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(name)=LOWER('idx_externalAuths_record_provider')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(tbl_name)!=LOWER('_externalAuths'))) AND (LOWER(name)=LOWER('idx_externalAuths_collection_provider')) LIMIT 1[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_authorigins') AND (id<>'pbc_4275539003') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_authOrigins'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_4275539003' OR LOWER(name)='pbc_4275539003' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_authOrigins'))) AND (LOWER(tbl_name)!=LOWER('_authOrigins'))) AND (LOWER(name)=LOWER('idx_authOrigins_unique_pairs')) LIMIT 1[0.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_superusers') AND (id<>'pbc_3142635823') LIMIT 1[2.00ms] SELECT
_collections. FROM_collectionsWHEREid='_superusers'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_tokenKey_pbc_3142635823')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_email_pbc_3142635823')) LIMIT 1[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787684290316, '1735377462_collections_snapshot.go')[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1735379875_updated__superusers.go' LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823'[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='_superusers') AND (id<>'pbc_3142635823') LIMIT 1[0.00ms] SELECT
_collections. FROM_collectionsWHEREid='_superusers'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_tokenKey_pbc_3142635823')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_email_pbc_3142635823')) LIMIT 1[3.00ms] UPDATE
_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:23.102Z',deleteRule=NULL,fields='[{"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","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"number376926767","max":9,"min":0,"name":"avatar","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"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"}]',id='pbc_3142635823',indexes='["CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey)","CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= ''''"]',listRule=NULL,name='superusers',options='{"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\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":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"FLc2Dlshm0kNJfE8ss5sLxg6ZTxCVHfBqKCDYgzQRhKXpYXO4U","duration":1209600},"passwordResetToken":{"secret":"EGDKY84RweV6MCQ2hEuUxOzLGcexKwZyxCJkhJuM0oYYNfB6pL","duration":1800},"emailChangeToken":{"secret":"JlZibajam0UuJFdzOaxlfQ2NkQ2TRAP6CsBrhhrMKeptEjNBbB","duration":1800},"verificationToken":{"secret":"GEPcIVDrHv7tweeFR1Y6RipDYlg93kLzhSZXEM8Wt7bn60p9ZG","duration":259200},"fileToken":{"secret":"5PlQpyDD5I8AtXFLkZgtYvOLcRA2rxHVgn82snhg7lZ3AfhNbm","duration":120},"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"',system=true,type='auth',updateRule=NULL,updated='2025-01-13 17:01:24.296Z',viewRule=NULL WHEREid='pbc_3142635823' [0.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_superusers')) LIMIT 1 [1.00ms] DROP INDEX IF EXISTSidx_tokenKey_pbc_3142635823[1.00ms] DROP INDEX IF EXISTSidx_email_pbc_3142635823[9.00ms] ALTER TABLE_superusersADDavatarXMQA6NUMERIC DEFAULT 0 NOT NULL [42.00ms] ALTER TABLE_superusersRENAME COLUMNavatarXMQA6TOavatar[1.00ms] CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey) [1.00ms] CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= '' [0.00ms] PRAGMA optimize [0.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [2.00ms] INSERT INTO_migrations(applied,file) VALUES (1736787684471619, '1735379875_updated__superusers.go') [1.00ms] SELECT count(*) FROM_migrationsWHEREfile='1735381989_updated__superusers.go' LIMIT 1 [4.00ms] SELECT_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1 [1.00ms] SELECT_collections.* FROM_collectionsWHEREid='pbc_3142635823' [1.00ms] SELECT count(*) FROM_collectionsWHERE (LOWER(name)='_superusers') AND (id<>'pbc_3142635823') LIMIT 1 [0.00ms] SELECT_collections.* FROM_collectionsWHEREid='_superusers' [2.00ms] SELECT_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1 [1.00ms] SELECT_collections.* FROM_collectionsWHEREid='pbc_3142635823' OR LOWER(name)='pbc_3142635823' LIMIT 1 [1.00ms] SELECTtbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_tokenKey_pbc_3142635823')) LIMIT 1 [1.00ms] SELECTtbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(tbl_name)!=LOWER('_superusers'))) AND (LOWER(name)=LOWER('idx_email_pbc_3142635823')) LIMIT 1 [2.00ms] UPDATE_collectionsSETcreateRule=NULL,created='2025-01-13 17:01:23.102Z',deleteRule=NULL,fields='[{"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","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"number376926767","max":9,"min":0,"name":"avatar","onlyInt":true,"presentable":false,"required":false,"system":false,"type":"number"},{"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"}]',id='pbc_3142635823',indexes='["CREATE UNIQUE INDEXidx_tokenKey_pbc_3142635823ON_superusers(tokenKey)","CREATE UNIQUE INDEXidx_email_pbc_3142635823ON_superusers(email) WHEREemail!= ''''"]',listRule=NULL,name='_superusers',options='{"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\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":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"FLc2Dlshm0kNJfE8ss5sLxg6ZTxCVHfBqKCDYgzQRhKXpYXO4U","duration":1209600},"passwordResetToken":{"secret":"EGDKY84RweV6MCQ2hEuUxOzLGcexKwZyxCJkhJuM0oYYNfB6pL","duration":1800},"emailChangeToken":{"secret":"JlZibajam0UuJFdzOaxlfQ2NkQ2TRAP6CsBrhhrMKeptEjNBbB","duration":1800},"verificationToken":{"secret":"GEPcIVDrHv7tweeFR1Y6RipDYlg93kLzhSZXEM8Wt7bn60p9ZG","duration":259200},"fileToken":{"secret":"5PlQpyDD5I8AtXFLkZgtYvOLcRA2rxHVgn82snhg7lZ3AfhNbm","duration":120},"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"',system=true,type='auth',updateRule=NULL,updated='2025-01-13 17:01:24.491Z',viewRule=NULL WHEREid='pbc_3142635823'[0.00ms] SELECT (1) FROM
sqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('_superusers')) LIMIT 1[2.00ms] DROP INDEX IF EXISTS
idx_tokenKey_pbc_3142635823[1.00ms] DROP INDEX IF EXISTS
idx_email_pbc_3142635823[1.00ms] CREATE UNIQUE INDEX
idx_tokenKey_pbc_3142635823ON_superusers(tokenKey)[1.00ms] CREATE UNIQUE INDEX
idx_email_pbc_3142635823ON_superusers(email) WHEREemail!= ''[1.00ms] PRAGMA optimize
[0.00ms] SELECT
_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC[0.00ms] SELECT
_collections.* FROM_collectionsORDER BYcreatedASC[0.00ms] INSERT INTO
_migrations(applied,file) VALUES (1736787684600917, '1735381989_updated__superusers.go')[0.00ms] SELECT count() FROM
_migrationsWHEREfile='1735385555_updated_users.go' LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx'[1.00ms] SELECT count() FROM
_collectionsWHERE (LOWER(name)='users') AND (id<>'27do0wbcuyfmbmx') LIMIT 1[1.00ms] SELECT
_collections. FROM_collectionsWHEREid='users'[1.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[0.00ms] SELECT
_collections.* FROM_collectionsWHEREid='27do0wbcuyfmbmx' OR LOWER(name)='27do0wbcuyfmbmx' LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_username_idx')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('_27do0wbcuyfmbmx_email_idx')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('27do0wbcuyfmbmx_tokenKey_idx')) LIMIT 1[1.00ms] SELECT
tbl_nameFROMsqlite_masterWHERE (((type='index') AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(tbl_name)!=LOWER('users'))) AND (LOWER(name)=LOWER('27do0wbcuyfmbmx_created_idx')) LIMIT 1[2.00ms] UPDATE
_collectionsSETcreateRule=0x86c388170,created='2025-01-13 17:01:23.653Z',deleteRule=0x86c388190,fields='[{"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":10,"hidden":true,"id":"password901924565","max":0,"min":5,"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":false,"system":true,"type":"email"},{"hidden":false,"id":"bool1547992806","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"autogeneratePattern":"users[0-9]{6}","hidden":false,"id":"text4166911607","max":150,"min":3,"name":"username","pattern":"^[\w][\w\.\-]*$","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"i1qnezoa","max":9,"min":0,"name":"avatar","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]',id='27do0wbcuyfmbmx',indexes='["CREATE UNIQUE INDEX_27do0wbcuyfmbmx_username_idxONusers(username COLLATE NOCASE)","CREATE UNIQUE INDEX_27do0wbcuyfmbmx_email_idxONusers(email) WHEREemail!= ''''","CREATE UNIQUE INDEX_27do0wbcuyfmbmx_tokenKey_idxONusers(tokenKey)","CREATE INDEX_27do0wbcuyfmbmx_created_idxONusers(created)"]',listRule=0x86c388000,name='users',options='{"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\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":null,"mappedFields":{"id":"","name":"","username":"username","avatarURL":""},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email","username"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"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":"7kUrHXKaSLiaIK0JHOnp2USMy5AOeiGJxlXj1YbTB0WShI6UMO","duration":1209600},"passwordResetToken":{"secret":"SPpo1FUjxCzdkqMR1d2qwe1gA4pJxCVZn02mClCKsq1VfMcIUF","duration":1800},"emailChangeToken":{"secret":"YfFDshBR4OjEHqNKwK6aSSsRCRyVcb4CQb3X2nwUmlKjS1ixPS","duration":1800},"verificationToken":{"secret":"ad0ltkuGbtnF9i9YyFk5CUtZzub31y09dBNMpsQsuh8EveZQ2x","duration":604800},"fileToken":{"secret":"l6fIkSc6wOhQgG89Ub0kgetff86G91c48De1IjLOGq0iQ0jJhv","duration":120},"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"',system=false,type='auth',updateRule=0x86c388180,updated='2025-01-13 17:01:24.607Z',viewRule=0x86c388160 WHEREid='27do0wbcuyfmbmx' [1.00ms] SELECT (1) FROMsqlite_schemaWHERE (typeIN ('table', 'view')) AND (LOWER(name)=LOWER('users')) LIMIT 1 [0.00ms] PRAGMA optimize [1.00ms] SELECT_collections.* FROM_collectionsWHEREtype='view' ORDER BYcreatedASC [1.00ms] SELECT_collections.* FROM_collectionsORDER BYcreatedASC [0.00ms] INSERT INTO_migrations(applied,file) VALUES (1736787684712554, '1735385555_updated_users.go') [8.00ms] SELECTsettings_private.* FROMsettings_private[1.00ms] SELECT_collections.* FROM_collectionsWHEREid='settings_private' OR LOWER(name)='settings_private' LIMIT 1 [0.00ms] SELECTsettings_public.* FROMsettings_public[0.00ms] SELECT_collections.* FROM_collectionsWHEREid='settings_public' OR LOWER(name)='settings_public' LIMIT 1 [1.00ms] INSERT INTOsettings_private(created,id,interval,lazy_ping,scan_range,updated) VALUES ('2025-01-13 17:01:24.738Z', 'ymh06zvzn91810k', '@every 3s', false, '', '2025-01-13 17:01:24.738Z') [0.00ms] INSERT INTOsettings_public(created,favicon,id,setup_completed,updated,website_title) VALUES ('2025-01-13 17:01:24.741Z', '', '03l7b383avcyk0a', false, '2025-01-13 17:01:24.741Z', '') [0.00ms] SELECT count(*) FROM_superusers[0.00ms] SELECTsettings_public.* FROMsettings_public[0.00ms] SELECTsettings_public.* FROMsettings_publicWHEREsettings_public.id='03l7b383avcyk0a' LIMIT 1 [1.00ms] UPDATEsettings_publicSETcreated='2025-01-13 17:01:24.741Z',favicon='',id='03l7b383avcyk0a',setup_completed=false,updated='2025-01-13 17:01:24.746Z',website_title='' WHEREid='03l7b383avcyk0a' [INFO] 2025/01/13 18:01:24 pb.go:243: Ping interval set to @every 3s [1.00ms] SELECTdevices.* FROMdevices[0.00ms] SELECTsettings_private.* FROMsettings_private[0.00ms] SELECTdevices.* FROMdevices2025/01/13 18:01:24 Server started at http://127.0.0.1:8090 ├─ REST API: http://127.0.0.1:8090/api/ └─ Dashboard: http://127.0.0.1:8090/_/ [2.00ms] SELECT count(*) FROM_superusersWHERE NOT (email='__pbinstaller@example.com') [0.00ms] SELECT_superusers.* FROM_superusersWHEREemail='__pbinstaller@example.com' LIMIT 1 WARN Failed to initialize installer └─ {"error":"skip default PocketBase installer"} [1.00ms] SELECTdevices.* FROMdevices[2.00ms] SELECTdevices.* FROMdevicesERROR GET / └─ File not found. [1.00ms] SELECTdevices.* FROMdevices[1.00ms] SELECTdevices.* FROMdevices`Beta Was this translation helpful? Give feedback.
All reactions