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
-
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='[email protected]') [0.00ms] SELECT_superusers.* FROM_superusersWHEREemail='[email protected]' 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