Created
May 2, 2023 16:37
-
-
Save wassereimer86/b88e074850e24daa6d7f1dab5e7306f7 to your computer and use it in GitHub Desktop.
Report
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "basic": { | |
| "license key": "***REMOVED SENSITIVE VALUE***", | |
| "date": "Tue, 02 May 2023 16:28:03 +0000", | |
| "ownCloud version": "10.11.0.6", | |
| "ownCloud version string": "10.11.0", | |
| "ownCloud edition": "Community", | |
| "server OS": "Linux", | |
| "server OS version": "Linux ***REMOVED SENSITIVE VALUE*** 5.15.0-71-generic #78-Ubuntu SMP Tue Apr 18 09:00:29 UTC 2023 x86_64", | |
| "server SAPI": "fpm-fcgi", | |
| "webserver version": "Apache", | |
| "hostname": "***REMOVED SENSITIVE VALUE***", | |
| "logged-in user": "***REMOVED SENSITIVE VALUE***" | |
| }, | |
| "stats": { | |
| "users": { | |
| "Database": { | |
| "total_count": 4, | |
| "guest_count": 0, | |
| "seen": 4, | |
| "logged in (30 days)": 4 | |
| } | |
| }, | |
| "groups": { | |
| "OC\\Group\\Database": 1 | |
| } | |
| }, | |
| "config": { | |
| "instanceid": "ocpe6oh997hw", | |
| "passwordsalt": "***REMOVED SENSITIVE VALUE***", | |
| "secret": "***REMOVED SENSITIVE VALUE***", | |
| "trusted_domains": [ | |
| "***REMOVED SENSITIVE VALUE***", | |
| "***REMOVED SENSITIVE VALUE***" | |
| ], | |
| "datadirectory": "\/var\/www\/vhosts\/***REMOVED SENSITIVE VALUE***\/cloud.data", | |
| "overwrite.cli.url": "https:\/\/***REMOVED SENSITIVE VALUE***", | |
| "dbtype": "mysql", | |
| "version": "10.11.0.6", | |
| "dbname": "***REMOVED SENSITIVE VALUE***", | |
| "dbhost": "localhost", | |
| "dbtableprefix": "oc_", | |
| "dbuser": "***REMOVED SENSITIVE VALUE***", | |
| "dbpassword": "***REMOVED SENSITIVE VALUE***", | |
| "installed": true, | |
| "mail_smtpmode": "php", | |
| "mail_from_address": "***REMOVED SENSITIVE VALUE***", | |
| "mail_domain": "***REMOVED SENSITIVE VALUE***", | |
| "mail_smtpname": "***REMOVED SENSITIVE VALUE***", | |
| "loglevel": 2, | |
| "log_rotate_size": 10485760, | |
| "logtimezone": "Europe\/Berlin", | |
| "theme": "", | |
| "maintenance": false, | |
| "htaccess.RewriteBase": "\/", | |
| "data-fingerprint": "3ae40161cd9ba3ab5c3a78e31c4aca9f", | |
| "trashbin_retention_obligation": "auto,7", | |
| "versions_retention_obligation": "auto,30", | |
| "activity_expire_days": 60, | |
| "enable_previews": true, | |
| "preview_max_scale_factor": 1, | |
| "preview_max_x": 1280, | |
| "preview_max_y": 720, | |
| "memcache.local": "\\OC\\Memcache\\APCu", | |
| "memcache.locking": "\\OC\\Memcache\\Redis", | |
| "redis": { | |
| "host": "localhost", | |
| "port": ***REMOVED SENSITIVE VALUE***, | |
| "timeout": 0, | |
| "password": "***REMOVED SENSITIVE VALUE***", | |
| "dbindex": 0 | |
| }, | |
| "singleuser": false, | |
| "allow_user_to_change_mail_address": "" | |
| }, | |
| "integritychecker": { | |
| "passing": true, | |
| "enabled": true, | |
| "result": [] | |
| }, | |
| "core": { | |
| "OC_Channel": "stable", | |
| "backgroundjobs_mode": "cron", | |
| "default_encryption_module": "OC_DEFAULT_MODULE", | |
| "enable_external_storage": "no", | |
| "encryption_enabled": "no", | |
| "incoming_server2server_share_enabled": "no", | |
| "installedat": "1452547198.7692", | |
| "lastcron": "1683044401", | |
| "lastupdateResult": "[]", | |
| "lastupdatedat": "1683044101", | |
| "legal.imprint_url": "https:\/\/***REMOVED SENSITIVE VALUE***\/impressum\/", | |
| "legal.privacy_policy_url": "https:\/\/***REMOVED SENSITIVE VALUE***\/datenschutzerklaerung\/", | |
| "outgoing_server2server_share_enabled": "no", | |
| "public_documents": "documents\/public.php", | |
| "public_files": "files_sharing\/public.php", | |
| "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php", | |
| "remote_caldav": "dav\/appinfo\/v1\/caldav.php", | |
| "remote_calendar": "dav\/appinfo\/v1\/caldav.php", | |
| "remote_carddav": "dav\/appinfo\/v1\/carddav.php", | |
| "remote_contacts": "dav\/appinfo\/v1\/carddav.php", | |
| "remote_dav": "dav\/appinfo\/v2\/remote.php", | |
| "remote_files": "dav\/appinfo\/v1\/webdav.php", | |
| "remote_webdav": "dav\/appinfo\/v1\/webdav.php", | |
| "repairlegacystoragesdone": "yes", | |
| "shareapi_allow_group_sharing": "no", | |
| "shareapi_allow_mail_notification": "no", | |
| "shareapi_allow_public_notification": "yes", | |
| "shareapi_allow_public_upload": "yes", | |
| "shareapi_allow_resharing": "no", | |
| "shareapi_allow_share_dialog_user_enumeration": "no", | |
| "shareapi_auto_accept_share": "no", | |
| "shareapi_default_expire_date": "no", | |
| "shareapi_default_permissions": "31", | |
| "shareapi_exclude_groups": "no", | |
| "shareapi_exclude_groups_list": "[\"\"]", | |
| "shareapi_only_share_with_group_members": "no", | |
| "shareapi_only_share_with_membership_groups": "no", | |
| "shareapi_public_notification_lang": "de", | |
| "shareapi_share_dialog_user_enumeration_group_members": "no", | |
| "updater.secret.created": "1669236909", | |
| "vendor": "owncloud" | |
| }, | |
| "apps": [ | |
| { | |
| "id": "external", | |
| "name": "External Sites", | |
| "description": "This application allows an admin to add a link in the ownCloud web interface Apps menu that points to an external website. By simply entering the URL and the name for the external site, icon appears. When this icon is clicked by a user, the external website appears in the ownCloud frame. For the user, this external site appears as if it is part of ownCloud but, in fact, this can be any external URL.\n\nNote that the External Site link must use the same type of encryption as provided by ownCloud. In other words, if ownCloud is hosted on HTTPS, the link in the external site must also be HTTPS. The same is also true for HTTP. More information is available in the External Sites documentation.", | |
| "licence": "AGPL", | |
| "author": "Frank Karlitschek", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "version": "1.4.0", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/external\/img\/external.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "updatenotification", | |
| "name": "Update notification", | |
| "description": "Displays update notifications for ownCloud and provides the SSO for the updater.", | |
| "licence": "AGPL", | |
| "author": "Lukas Reschke", | |
| "version": "0.2.1", | |
| "namespace": "UpdateNotification", | |
| "default_enable": "", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\UpdateNotification\\Notification\\BackgroundJob" | |
| }, | |
| "settings": { | |
| "admin": "OCA\\UpdateNotification\\Controller\\AdminController" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "appconfig": { | |
| "core": "10.11.0", | |
| "enabled": "yes", | |
| "installed_version": "0.2.1", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "market", | |
| "name": "Market", | |
| "summary": "Integrate the ownCloud marketplace into your ownCloud", | |
| "description": "Easily manage ownCloud apps from within your ownCloud web interface. It connects your ownCloud with your marketplace account and lets you browse, install and update any apps from inside your ownCloud instance.\n\nPlease note: Since ownCloud X (10.0) every instance gets shipped with this app included. You do not need to install it separately. To use this application click on \"Files\" in the top left corner and click on \"Market\" (cart icon) (Administrator privileges required)", | |
| "licence": "AGPL", | |
| "author": "Thomas M\u00fcller, Felix Heidecke, Thomas B\u00f6rger, Philipp Schaffrath, Viktar Dubiniuk", | |
| "version": "0.7.0", | |
| "default_enable": "", | |
| "category": "tools", | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/market\/ownCloud-market-app.jpg", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.11", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\Market\\CheckUpdateBackgroundJob" | |
| }, | |
| "commands": [ | |
| "OCA\\Market\\Command\\InstallApp", | |
| "OCA\\Market\\Command\\UnInstallApp", | |
| "OCA\\Market\\Command\\ListApps", | |
| "OCA\\Market\\Command\\UpgradeApp" | |
| ], | |
| "navigation": { | |
| "@attributes": { | |
| "role": "admin" | |
| }, | |
| "route": "market.page.index", | |
| "order": "100" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/market\/img\/market.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "activity": "2.7.1", | |
| "brute_force_protection": "1.2.0", | |
| "code_challenge": "YWMxMjQ2ZTNiMjgyNzE4ZjliOWQwZGFlOTE0MWNlNzI5M2IwNDE4MDcyMjRiMzlhNzk1YTY5NjZlZmY2ZjQ2Zg==", | |
| "code_verify": "6L0JqXSZzrd2uKtyeGeojPm57JPVDQO7A9lyqZGobnE5oN4g6itmCG30ILSyQYP1", | |
| "enabled": "yes", | |
| "files_mediaviewer": "1.0.5", | |
| "files_pdfviewer": "1.0.1", | |
| "files_texteditor": "2.5.1", | |
| "files_textviewer": "1.0.3", | |
| "gallery": "16.1.1", | |
| "guests": "0.7.0", | |
| "impersonate": "0.5.2", | |
| "installed_version": "0.7.0", | |
| "key": "", | |
| "market": "0.6.3", | |
| "oauth2": "0.5.3", | |
| "password_policy": "***REMOVED SENSITIVE VALUE***", | |
| "signed": "true", | |
| "templateeditor": "0.3", | |
| "twofactor_totp": "0.7.4", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "files_versions", | |
| "name": "Versions", | |
| "licence": "AGPL", | |
| "author": "Frank Karlitschek, Bjoern Schiessle", | |
| "description": "This application enables ownCloud to automatically maintain older versions of files that are changed. When enabled, a hidden versions folder is provisioned in every user\u2019s directory and is used to store old file versions. A user can revert to an older version through the web interface at any time, with the replaced file becoming a version. ownCloud then automatically manages the versions folder to ensure the user doesn\u2019t run out of Quota because of versions. In addition to the expiry of versions, ownCloud\u2019s versions app makes certain never to use more than 50% of the user\u2019s currently available free space. If stored versions exceed this limit, ownCloud will delete the oldest versions first until it meets this limit. More information is available in the Versions documentation.\n\n", | |
| "version": "1.3.0", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "namespace": "Files_Versions", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "documentation": { | |
| "user": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=user-versions" | |
| }, | |
| "default_enable": "", | |
| "background-jobs": { | |
| "job": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions" | |
| }, | |
| "commands": [ | |
| "OCA\\Files_Versions\\Command\\CleanUp", | |
| "OCA\\Files_Versions\\Command\\ExpireVersions" | |
| ], | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/files_versions\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "1.3.0", | |
| "types": "filesystem" | |
| } | |
| }, | |
| { | |
| "id": "twofactor_backup_codes", | |
| "name": "Two factor backup codes", | |
| "description": "Two-factor auth backup codes provider", | |
| "summary": "Backup codes let you access your account if your other factors are not available.", | |
| "licence": "AGPL", | |
| "author": "Semih Serhat Karakaya", | |
| "version": "0.1.0", | |
| "namespace": "TwoFactorBackupCodes", | |
| "category": "security", | |
| "types": [ | |
| "prelogin", | |
| "authentication" | |
| ], | |
| "screenshot": [ | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/twofactor_backup_codes\/104e03d3b2a7d58e6d03c5fb28db281200a0ef84\/screenshots\/owncloud-twofactor-backup-codes.jpg", | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/twofactor_backup_codes\/717991de4a7d4ff634add9897867eeeed7662c7b\/screenshots\/verify.png" | |
| ], | |
| "two-factor-providers": { | |
| "provider": "OCA\\TwoFactorBackupCodes\\Provider\\BackupProvider" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "settings": { | |
| "personal": "OCA\\TwoFactorBackupCodes\\Settings\\PersonalPanel" | |
| }, | |
| "website": "https:\/\/github.com\/owncloud\/twofactor_backup_codes\/", | |
| "bugs": "https:\/\/github.com\/owncloud\/twofactor_backup_codes\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/twofactor_backup_codes.git" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.1.0", | |
| "signed": "true", | |
| "types": "prelogin,authentication" | |
| } | |
| }, | |
| { | |
| "id": "impersonate", | |
| "name": "Impersonate", | |
| "summary": "Provide assistance by logging in as another user", | |
| "description": "The Impersonate application allows administrators, and group admins, to log in as another user within an ownCloud instance. It provides a helpdesk-like experience and can be useful to help users with configuration issues, to get a better understanding of what they see when they use their ownCloud account, or to perform actions in legacy accounts.\n\nOnce Impersonate is installed, a new column will be available in the user management panel. Click on the icon next to the user that you want to impersonate and you will be logged in as that user. Your current session will be temporarily suspended, and you will see a notification at the top of the page reminding you that you\u2019re impersonating another user. Once you\u2019re finished, log out, and you will return to your previous user session.\n\nAs a security measure, the application lets ownCloud administrators restrict the ability to impersonate users in specific groups. When enabled and configured, only a group\u2019s administrator can impersonate members of their group. Administrators can find configuration options in the \"User Authentication\" section of the \"Admin settings\" panel.", | |
| "licence": "AGPL", | |
| "author": "J\u00f6rn Friedrich Dreyer, Sujith Haridasan", | |
| "version": "0.5.2", | |
| "namespace": "Impersonate", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/general_topics\/impersonate_users.html" | |
| }, | |
| "bugs": "https:\/\/github.com\/owncloud\/impersonate\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "http:\/\/github.com\/owncloud\/impersonate.git" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.2", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "category": "tools", | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/impersonate\/impersonate.png", | |
| "settings": { | |
| "admin": "OCA\\Impersonate\\AdminPanel" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/impersonate\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "impersonate_all_groupadmins": "false", | |
| "impersonate_include_groups": "false", | |
| "impersonate_include_groups_list": "[]", | |
| "installed_version": "0.5.2", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "federation", | |
| "name": "Federation", | |
| "description": "ownCloud Federation allows you to connect with other trusted ownClouds to exchange the user directory. For example this will be used to auto-complete external users for federated sharing.", | |
| "licence": "AGPL", | |
| "author": "Bjoern Schiessle", | |
| "version": "0.1.0", | |
| "namespace": "Federation", | |
| "category": "other", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "default_enable": "", | |
| "types": [ | |
| "authentication" | |
| ], | |
| "background-jobs": { | |
| "job": "OCA\\Federation\\SyncJob" | |
| }, | |
| "commands": { | |
| "command": "OCA\\Federation\\Command\\SyncFederationAddressBooks" | |
| }, | |
| "settings": { | |
| "admin": "OCA\\Federation\\Panels\\Admin" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/federation\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "encryption", | |
| "description": "In order to use this encryption module you need to enable server-side encryption in the admin settings. Once enabled this module will encrypt all your files transparently. The encryption is based on AES 256 keys. The module won't touch existing files, only new files will be encrypted after server-side encryption was enabled. It is also not possible to disable the encryption again and switch back to a unencrypted system. Please read the documentation to know all implications before you decide to enable server-side encryption.", | |
| "name": "Default encryption module", | |
| "licence": "AGPL", | |
| "author": "Bjoern Schiessle, Clark Tomlinson", | |
| "documentation": { | |
| "user": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=user-encryption", | |
| "admin": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=admin-encryption" | |
| }, | |
| "rememberlogin": "false", | |
| "version": "1.5.3", | |
| "category": "security", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "use-migrations": "true", | |
| "dependencies": { | |
| "lib": "openssl", | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.7", | |
| "max-version": "11.0" | |
| } | |
| } | |
| }, | |
| "commands": [ | |
| "OCA\\Encryption\\Command\\SelectEncryptionType", | |
| "OCA\\Encryption\\Command\\RecreateMasterKey", | |
| "OCA\\Encryption\\Command\\MigrateKeys", | |
| "OCA\\Encryption\\Command\\HSMDaemon", | |
| "OCA\\Encryption\\Command\\HSMDaemonDecrypt", | |
| "OCA\\Encryption\\Command\\FixEncryptedVersion" | |
| ], | |
| "settings": { | |
| "admin": "OCA\\Encryption\\Panels\\Admin", | |
| "personal": "OCA\\Encryption\\Panels\\Personal" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/encryption\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "firstrunwizard", | |
| "name": "First run wizard", | |
| "description": "This application enables a pop-up window when a user first logs into ownCloud. This window welcomes new users to ownCloud, and contains links to the standard ownCloud desktop client, Android app, and the iOS app. The window also shows a link for accessing ownCloud via WebDAV. At any time, the first run wizard button can be opened again via the link on the personal page. The First run wizard can be customized to meet specific design goals, or to change links and messages. Create an appropriate theme following the Theming documentation, and changes to the look and feel of this Wizard are simple. More information is available in the First run wizard documentation, as well as the theming documentation.", | |
| "licence": "AGPL", | |
| "author": "Frank Karlitschek, Jan-Christoph Borchardt, Tom Needham", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.2", | |
| "max-version": "11" | |
| } | |
| } | |
| }, | |
| "version": "1.2.0", | |
| "namespace": "FirstRunWizard", | |
| "default_enable": "", | |
| "commands": { | |
| "command": "OCA\\FirstRunWizard\\Command\\ResetAll" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/firstrunwizard\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "systemtags", | |
| "name": "Collaborative tags", | |
| "description": "Collaborative tagging functionality which shares tags among users. Great for teams. (If you are a provider with a multi-tenancy installation, it is advised to deactivate this app as tags are shared.)", | |
| "licence": "AGPL", | |
| "author": "Vincent Petry", | |
| "default_enable": "", | |
| "version": "0.3.0", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "namespace": "SystemTags", | |
| "types": [ | |
| "logging" | |
| ], | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": false, | |
| "removable": true | |
| }, | |
| { | |
| "id": "files_external_ftp", | |
| "name": "External Storage: FTP", | |
| "summary": "Integrate FTP servers as external storages", | |
| "description": "With ownCloud you can leverage storage that already exists in your enterprise. Administrators can for example decide to store the most sensitive data on-premises and less sensitive data in the cloud while making all of your files available through a single user interface and enabling compliance with your chosen security and governance policies. This highly facilitates data infrastructure modernization in your business without the need of data migration or major investments in new storage systems. Using ownCloud it is possible to integrate a wide range of storage types and make them accessible from all devices under the specified security policies in ownCloud. ownCloud works as an additional layer, providing users with a single point of access to their files on all storage locations.\n\nThis application enables integrating FTP servers as external storages. Once a FTP server is integrated by an administrator or the user in self-service, users see a folder structure that mirrors the hierarchy of the FTP server. Users can then selectively sync files to their desktop or access them on mobile devices like any other file in ownCloud. The files will remain on the FTP storage but are now accessible in a secure and fully logged and traceable way through ownCloud.\n\nAdministrators and users (when enabled) can find external storage configuration options in the 'Storage' section of admin and user settings, respectively.", | |
| "licence": "AGPL", | |
| "author": "Robin Appelman, Thomas M\u00fcller, Vincent Petry, Ilja Neumann", | |
| "version": "0.2.1", | |
| "category": "storage", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "documentation": { | |
| "user": "https:\/\/doc.owncloud.com\/server\/latest\/user_manual\/external_storage\/external_storage.html", | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/files\/external_storage\/ftp.html" | |
| }, | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/promo\/e1dd604d66b4c5f765579b4c160de3268169ea3c\/ownCloud%20logo%20square.png", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "website": "https:\/\/github.com\/owncloud\/files_external_ftp\/", | |
| "bugs": "https:\/\/github.com\/owncloud\/files_external_ftp\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/files_external_ftp.git" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.2.1", | |
| "signed": "true", | |
| "types": "filesystem" | |
| } | |
| }, | |
| { | |
| "id": "files_textviewer", | |
| "category": "tools", | |
| "name": "Text File Viewer", | |
| "description": "Allows text files to be displayed in the browser rather than downloaded. Allows folders to be listed in a lightweight index rather than an infinite river. These features offer a faster and more secure way to view text content in the cloud.", | |
| "summary": "Easy web access to plain text files.", | |
| "licence": "AGPL", | |
| "author": "Robert Chapin", | |
| "namespace": "RobsFileViewer", | |
| "version": "1.0.3", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.0", | |
| "max-version": "10" | |
| } | |
| }, | |
| "php": { | |
| "@attributes": { | |
| "min-version": "5.4" | |
| } | |
| } | |
| }, | |
| "documentation": "\n\t", | |
| "website": "https:\/\/www.miqrogroove.com\/", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/miqrogroove\/files_textviewer" | |
| }, | |
| "bugs": "https:\/\/github.com\/miqrogroove\/files_textviewer\/issues", | |
| "screenshot": "https:\/\/www.miqrogroove.com\/wp-content\/uploads\/2018\/10\/textviewer.png", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "1.0.3", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "configreport", | |
| "name": "Admin Config Report", | |
| "namespace": "ConfigReport", | |
| "licence": "AGPL", | |
| "description": "Generate a Config Report", | |
| "summary": "Generate a Config Report", | |
| "author": "owncloud.org", | |
| "version": "0.2.1", | |
| "default_enable": [ | |
| "", | |
| "" | |
| ], | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.8", | |
| "max-version": "11" | |
| } | |
| } | |
| }, | |
| "commands": { | |
| "command": "OCA\\ConfigReport\\Command\\ConfigReport" | |
| }, | |
| "settings": { | |
| "admin": "OCA\\ConfigReport\\AdminPanel" | |
| }, | |
| "category": "tools", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/next\/admin_manual\/troubleshooting\/providing_logs_and_config_files.html#generate-a-config-report" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.2.1", | |
| "types": "filesystem" | |
| } | |
| }, | |
| { | |
| "id": "twofactor_totp", | |
| "name": "2-Factor Authentication", | |
| "summary": "Increase access security with 2FA\/TOTP", | |
| "description": "2-Factor Authentication adds another layer of access security to ownCloud. The authentication method confirms a user\u2019s identity utilizing a combination of two independent components. Instead of simply requiring a username\/password combination, an additional access token (time-based one-time password\/TOTP), which can be obtained via mobile phones for instance, is needed to gain access to ownCloud accounts. This not only improves access security, but also provides administrators with an option for disabling individual tokens. Time-based one-time passwords (TOTP) can be obtained through services like Google Authenticator or an Open-Source implementation of the TOTP standard like LinOTP. This extension provides the most simple way to add a second factor to user logins. More sophisticated 2-Factor Authentication mechanisms with additional authentication devices is available via the [PrivacyIDEA ownCloud App](https:\/\/marketplace.owncloud.com\/apps\/twofactor_privacyidea) or by integrating other Identity Providers that offer multi-factor authenication mechanisms.", | |
| "licence": "AGPL", | |
| "author": "ownCloud GmbH, Christoph Wurst, Semih Serhat Karakaya", | |
| "version": "0.7.4", | |
| "namespace": "TwoFactor_Totp", | |
| "category": "security", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/occ_command.html#two-factor-authentication", | |
| "user": "https:\/\/doc.owncloud.com\/server\/latest\/user_manual\/session_management.html" | |
| }, | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/twofactor_totp\/cc989d968cef37f28df8e2dc633babf9a6c894cc\/screenshots\/settings.png", | |
| "two-factor-providers": { | |
| "provider": "OCA\\TwoFactor_Totp\\Provider\\TotpProvider" | |
| }, | |
| "settings": { | |
| "personal": "OCA\\TwoFactor_Totp\\Settings\\PersonalPanel" | |
| }, | |
| "commands": [ | |
| "OCA\\TwoFactor_Totp\\Command\\SetSecretVerificationStatusCommand", | |
| "OCA\\TwoFactor_Totp\\Command\\DeleteRedundantSecretsCommand" | |
| ], | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.2", | |
| "max-version": "10" | |
| } | |
| }, | |
| "php": { | |
| "@attributes": { | |
| "min-version": "7.1", | |
| "max-version": "7.4" | |
| } | |
| } | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.7.4", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "files_pdfviewer", | |
| "name": "PDF Viewer", | |
| "summary": "Viewer for PDF files", | |
| "description": "This application integrates a browser-based PDF Viewer into ownCloud. It allows users to view their PDF files in the browser without the need to download the file.\n\nWhen this application is enabled, publicly shared PDF documents will also be shown in the PDF Viewer. The PDF viewer requires a modern browser and will not work with Microsoft\u00ae Internet Explorer\u00ae and older (non-Chromium-based) versions of Microsoft Edge\u00ae. The integration is based on PDF.js which is a JavaScript library developed by Mozilla. You can learn more about the PDF.js project at https:\/\/mozilla.github.io\/pdf.js\/", | |
| "licence": "AGPL", | |
| "author": "Thomas M\u00fcller, Lukas Reschke, Viktar Dubiniuk", | |
| "version": "1.0.1", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.2", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "default_enable": "", | |
| "namespace": "Files_PdfViewer", | |
| "website": "https:\/\/github.com\/owncloud\/files_pdfviewer", | |
| "bugs": "https:\/\/github.com\/owncloud\/files_pdfviewer\/issues", | |
| "category": "productivity", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/files_pdfviewer.git" | |
| }, | |
| "screenshot": "https:\/\/github.com\/owncloud\/screenshots\/raw\/cd5f83007e6037af6733d847548d2766be69a8a0\/files_pdfviewer\/files_pdfviewer.png", | |
| "ocsid": "166049", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/files_pdfviewer\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "1.0.1", | |
| "ocsid": "166049", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "files_mediaviewer", | |
| "name": "Media Viewer", | |
| "summary": "Explore, show and share your media collections", | |
| "description": "A media viewer that adds image and video viewing capabilities to Files view and Public Links.\n\n**Features**\n\n- Support for a large selection of image and video formats (depending on server setup) - Fullscreen, zoomable slideshow view integrated with the Files view and Public Links - Image rotation - Sort images by name or date - Image and video download straight from the slideshow - Native SVG support - Mobile support", | |
| "licence": "GPLv2", | |
| "author": "Felix Heidecke", | |
| "version": "1.0.5", | |
| "namespace": "Mediaviewer", | |
| "documentation": { | |
| "developer": "https:\/\/github.com\/owncloud\/files_mediaviewer\/blob\/master\/README.md" | |
| }, | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/files_mediaviewer\/ownCloud-app-mediaviewer.jpg", | |
| "category": "multimedia", | |
| "website": "https:\/\/github.com\/owncloud\/files_mediaviewer", | |
| "bugs": "https:\/\/github.com\/owncloud\/files_mediaviewer\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/files_mediaviewer.git" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "default_enable": "", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "1.0.5", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "brute_force_protection", | |
| "name": "Brute-Force Protection", | |
| "description": "A brute-force attack occurs when an attacker uses a range of potential passwords in the hope of using the correct one and gaining access to a user's account. Such attacks frequently operate in an automated manner. Doing so lets attackers try many different password combinations in a small time frame.\n\nAdditionally, attackers may use password dictionaries to reduce the number of potential combinations to actual words. This kind of attack is called a \"dictionary attack\". Depending on the strength of a password, attackers can estimate the number of attempts, and the respective time required to break the password and gain access to a user's account. Administrators should be aware of this potential threat and take appropriate counter-measures.\n\nThat's why the Brute-Force Protection extension was developed. It allows administrators to specify a maximum number of unsuccessful user account login attempts. On reaching the unsuccessful login limit, ownCloud temporarily bans further login attempts to those user accounts from the originating IP address. The time frame of the ban is configurable by ownCloud administrators.\n\nOnce a ban is in effect, an attacker is forced to either change their IP address or wait for the ban time to expire before continuing the attack. This best-practice approach increases the amount of time required to conduct an attack, drastically reducing the feasibility of the attack and the possibility of a successful account login.\n\nAlso, ownCloud administrators can take further steps to increase user account security. These include:\n\n1. Requiring strong passwords, using the [Password Policy](https:\/\/marketplace.owncloud.com\/apps\/password_policy) extension. 2. Enabling two- or multi-factor authentication (e.g., a time-based one-time password), which can, theoretically, make brute-force attacks impossible.\n\nSee the [2-Factor Authentication](https:\/\/marketplace.owncloud.com\/apps\/twofactor_totp) extension, [more sophisticated MFA solutions](https:\/\/marketplace.owncloud.com\/apps\/category\/security) or outsourcing user authentication to an Identity Provider via the [SAML\/SSO Integration](https:\/\/marketplace.owncloud.com\/apps\/user_shibboleth) for further information.", | |
| "summary": "Prevent attackers from guessing user passwords", | |
| "licence": "GPLv2", | |
| "author": "Semih Serhat Karakaya", | |
| "version": "1.2.0", | |
| "namespace": "BruteForceProtection", | |
| "use-migrations": "true", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.5", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "types": [ | |
| "prelogin" | |
| ], | |
| "category": "security", | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/brute_force_protection\/ownCloud-app-bruteforce-protection.jpg", | |
| "settings": { | |
| "admin": "OCA\\BruteForceProtection\\Panels\\AdminPanel" | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\BruteForceProtection\\Jobs\\ExpireOldAttempts" | |
| }, | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/security\/brute_force_protection.html" | |
| }, | |
| "website": "https:\/\/github.com\/owncloud\/brute_force_protection", | |
| "bugs": "https:\/\/github.com\/owncloud\/brute_force_protection\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/brute_force_protection.git" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/brute_force_protection\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "brute_force_protection_ban_period": "3600", | |
| "brute_force_protection_fail_tolerance": "5", | |
| "brute_force_protection_time_threshold": "10", | |
| "enabled": "yes", | |
| "installed_version": "1.2.0", | |
| "signed": "true", | |
| "types": "prelogin" | |
| } | |
| }, | |
| { | |
| "id": "provisioning_api", | |
| "name": "Provisioning API", | |
| "description": "This application enables a set of APIs that external systems can use to create, edit, delete and query user attributes, query, set and remove groups, set quota and query total storage used in ownCloud. Group admin users can also query ownCloud and perform the same functions as an admin for groups they manage. The API also enables an admin to query for active ownCloud applications, application info, and to enable or disable an app remotely. Once the app is enabled, http requests can be used via a Basic Auth header to perform any of the functions listed above. More information is available in the Provisioning API documentation, including example calls and server responses.", | |
| "licence": "AGPL", | |
| "author": "Tom Needham", | |
| "default_enable": "", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=admin-provisioning-api" | |
| }, | |
| "version": "0.5.0", | |
| "namespace": "Provisioning_API", | |
| "types": [ | |
| "prevent_group_restriction" | |
| ], | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/provisioning_api\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "password_policy", | |
| "name": "Password Policy", | |
| "licence": "GPLv2", | |
| "author": "Thomas M\u00fcller, Vincent Petry, J\u00f6rn Friedrich Dreyer, Juan Pablo Villafa\u00f1ez Ramos, Semih Serhat Karakaya, Sujith Haridasan, Phil Davis", | |
| "summary": "Define password policies for user and public link passwords", | |
| "description": "The Password Policy extension enables ownCloud administrators to define password requirements like minimum characters, numbers, capital letters and more for all kinds of password endpoints like user account and public link sharing passwords. To add another layer of security, the administrator can enforce maximum expiration dates for public link shares depending on whether a password has been set or not. As a further measure the extension saves a history of hashed user passwords to prevent users from choosing a former password again, enforcing password security even more. Users can also be required to change their password upon first login. To impose regular password changes administrators can set up password expiration policies. For this users can be notified via email, web interface and the ownCloud Clients when their password is about to expire and when it has expired.\n\nThe definition of certain password rules support administrators in the task of ensuring a minimum level of password security throughout the enterprise. It minimizes the risk of weak user passwords and therefore adds an additional security aspect to ownCloud. The expiration date policies for public link shares allow users to depart from general public link expiration policies. Users can, for instance, be allowed to create longer-lasting public link shares when they choose to set a password. This way IT can provide more flexibility in external sharing while staying in full control. Password history and expiration policies are supplements that allow IT to establish a level of password security that can comply with corporate guidelines of all sorts. The provided tools enable administrators to granularly choose their desired security level. At this point it is important to keep in mind that high levels of security might sacrifice usability and come at the expense of user experience. For this reason it is highly recommended to check [best practices](https:\/\/pages.nist.gov\/800-63-3\/sp800-63b.html) and decide carefully on the hurdles that are put upon users in order to maintain and optimize user adoption and satisfaction.\n\nAdministrators find the configuration options in the 'Security' section of the ownCloud administration settings panel. The respective policies are designed for local user accounts created by administrators or via the [Guests](https:\/\/marketplace.owncloud.com\/apps\/guests) extension, not for user accounts imported from LDAP or other user backends as these provide their own mechanisms. For more information and recommendations when deploying policies in an existing ownCloud, please consult the [ownCloud Documentation](https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/security\/password_policy.html).", | |
| "version": "2.1.4", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/security\/password_policy.html" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.8", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "namespace": "PasswordPolicy", | |
| "settings": { | |
| "admin": "OCA\\PasswordPolicy\\Controller\\SettingsController" | |
| }, | |
| "category": "security", | |
| "commands": { | |
| "command": "OCA\\PasswordPolicy\\Command\\ExpirePassword" | |
| }, | |
| "account-modules": { | |
| "module": "OCA\\PasswordPolicy\\Authentication\\AccountModule" | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\PasswordPolicy\\Jobs\\PasswordExpirationNotifierJob" | |
| }, | |
| "types": [ | |
| "authentication" | |
| ], | |
| "screenshot": [ | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/password_policy\/owncloud-app-password_policy.jpg", | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/password_policy\/owncloud-app-password_policy2.jpg" | |
| ], | |
| "use-migrations": "true", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/password_policy\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "2.1.4", | |
| "signed": "true", | |
| "spv_def_special_chars_checked": "", | |
| "spv_def_special_chars_value": "#!", | |
| "spv_expiration_nopassword_checked": "***REMOVED SENSITIVE VALUE***", | |
| "spv_expiration_nopassword_value": "***REMOVED SENSITIVE VALUE***", | |
| "spv_expiration_password_checked": "***REMOVED SENSITIVE VALUE***", | |
| "spv_expiration_password_value": "***REMOVED SENSITIVE VALUE***", | |
| "spv_lowercase_checked": "on", | |
| "spv_lowercase_value": "1", | |
| "spv_min_chars_checked": "on", | |
| "spv_min_chars_value": "10", | |
| "spv_numbers_checked": "on", | |
| "spv_numbers_value": "1", | |
| "spv_password_history_checked": "***REMOVED SENSITIVE VALUE***", | |
| "spv_password_history_value": "***REMOVED SENSITIVE VALUE***", | |
| "spv_special_chars_checked": "on", | |
| "spv_special_chars_value": "1", | |
| "spv_uppercase_checked": "on", | |
| "spv_uppercase_value": "1", | |
| "spv_user_password_expiration_checked": "***REMOVED SENSITIVE VALUE***", | |
| "spv_user_password_expiration_notification_checked": "***REMOVED SENSITIVE VALUE***", | |
| "spv_user_password_expiration_notification_value": "***REMOVED SENSITIVE VALUE***", | |
| "spv_user_password_expiration_value": "***REMOVED SENSITIVE VALUE***", | |
| "spv_user_password_force_change_on_first_login_checked": "***REMOVED SENSITIVE VALUE***", | |
| "types": "authentication" | |
| } | |
| }, | |
| { | |
| "id": "activity", | |
| "name": "Activity", | |
| "summary": "Keep track of events with Activity stream and email notifications", | |
| "description": "The ownCloud Activity application enables users to not only get a summarized overview of all file and folder events in their ownCloud, but also to receive notifications for such via email. The user can configure their individual Activity preferences in their personal settings and can decide in detail which file or folder actions should be listed in the Activity stream (accessible via the app launcher) and also for which file or folder actions the users wants to receive email notifications. The bulk email notifications can either be sent out hourly, daily or weekly to fit the specific needs of the individual user.\n\nFrom creation of new files or folders, to file or folder changes, updates, restores from trash bin, sharing activities, comments, tags and downloads from public share links - the ownCloud Activity app gathers all file or folder related actions in one place for the user to review. For users with lots of activity it is possible to limit the Activity stream to 'Favorites' in order to avoid noise. Furthermore the application provides filters to give users the means to maintain overview by reducing entries to relevant information.\n\nAnd there you have it - a complete overview of all file and folder activities in your ownCloud with the additional ability to receive activity notifications via email in a time interval of your choice. Never again miss an important event related to content in ownCloud and always be up-to-date on all activities of your files and folders.", | |
| "licence": "AGPL", | |
| "author": "Thomas M\u00fcller, Frank Karlitschek, Joas Schilling, Tom Needham, Vincent Petry", | |
| "version": "2.7.1", | |
| "default_enable": "", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "use-migrations": "true", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.org\/server\/latest\/admin_manual\/configuration_server\/activity_configuration.html" | |
| }, | |
| "website": "https:\/\/github.com\/owncloud\/activity\/", | |
| "bugs": "https:\/\/github.com\/owncloud\/activity\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/activity.git" | |
| }, | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/68550c2b7c53e6309132ca1c7b177adca976db0b\/activity\/activity.png", | |
| "category": "tools", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.9.0", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "background-jobs": [ | |
| "OCA\\Activity\\BackgroundJob\\EmailNotification", | |
| "OCA\\Activity\\BackgroundJob\\ExpireActivities" | |
| ], | |
| "navigation": { | |
| "order": "1", | |
| "route": "activity.Activities.showList" | |
| }, | |
| "settings": { | |
| "personal": "OCA\\Activity\\PersonalPanel" | |
| }, | |
| "commands": { | |
| "command": "OCA\\Activity\\Command\\SendEmails" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/activity\/img\/activity.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "2.7.1", | |
| "signed": "true", | |
| "types": "filesystem" | |
| } | |
| }, | |
| { | |
| "id": "gallery", | |
| "name": "Gallery", | |
| "summary": "Explore, show and share your image collections", | |
| "description": "Media gallery that adds image viewing capabilities to files view and public links. Provides a dedicated grid-based album view for images.\n\n**Features**\n\n- Support for a large selection of image types (depending on server setup) - Fullscreen, zoomable image view integrated with the Files app - Slideshow - Sort images by name or date - Per album description and copyright statement - Image download straight from the slideshow or the album view - Seamlessly jump between the gallery and files view - Ignore folders containing a \".nomedia\" file - Native SVG support - Mobile support", | |
| "licence": "AGPL", | |
| "author": "Olivier Paroz, Robin Appelman, Thomas M\u00fcller", | |
| "version": "16.1.2", | |
| "namespace": "Gallery", | |
| "documentation": { | |
| "user": "https:\/\/doc.owncloud.com\/server\/latest\/user_manual\/files\/gallery_app.html", | |
| "admin": "https:\/\/doc.owncloud.com\/server\/latest\/user_manual\/files\/gallery_app.html", | |
| "developer": "https:\/\/github.com\/owncloud\/gallery\/blob\/master\/README.md" | |
| }, | |
| "category": "multimedia", | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/0e38639046884e863afc654c5529c8014f7d42fb\/gallery\/gallery.png", | |
| "website": "https:\/\/github.com\/owncloud\/gallery", | |
| "bugs": "https:\/\/github.com\/owncloud\/gallery\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/gallery.git" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.8", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "default_enable": "", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/gallery\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "16.1.2", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "oauth2", | |
| "name": "OAuth2", | |
| "summary": "OAuth2 token-based authorization interface", | |
| "description": "OAuth2 is the open industry-standard protocol for secure authorization of clients. It can be used as a way for users to grant web services or applications access to their data stored in ownCloud. The use of OAuth2 in ownCloud greatly enhances security while facilitating the integration of third party applications or web services:\n\n- Connect ownCloud clients (Desktop, Android, iOS) through a standardized and secure authorization flow - Provide a user authorization interface for developers to facilitate the integration of ownCloud in third party applications\n\n### Benefits provided by the OAuth2 interface\n\n- No user passwords are being stored in ownCloud clients or third party web applications\n\nInstead of connecting clients with username\/password, a user only needs to provide the information once in the browser. The respective client is then provided with a unique access token which is used for future connections to the ownCloud server. ownCloud clients or third party applications never get to know the actual login credentials.\n\n- The use of different access tokens per client provides the ability to selectively revoke user sessions\n\nWhen using OAuth2 a unique access token is generated for each device or third party application. Users can check their authorized clients in the personal settings and have the ability to selectively invalidate access tokens when e.g. a device is lost. This strengthens control and access security significantly.\n\n### Resources - [OAuth - Wikipedia](https:\/\/en.wikipedia.org\/wiki\/OAuth) - [OAuth protocol web page](https:\/\/oauth.net\/2\/)", | |
| "licence": "AGPL", | |
| "author": "Project Seminar \"sciebo@Learnweb\" of the University of M\u00fcnster, Thomas M\u00fcller", | |
| "version": "0.5.3", | |
| "namespace": "OAuth2", | |
| "category": "security", | |
| "website": "https:\/\/github.com\/owncloud\/oauth2", | |
| "bugs": "https:\/\/github.com\/owncloud\/oauth2\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/oauth2.git" | |
| }, | |
| "screenshot": [ | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/oauth2\/oauth2.jpg", | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/oauth2\/ownCloud-oauth2-app-auth-request.jpg", | |
| "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/oauth2\/ownCloud-oauth2-app-authorized.jpg" | |
| ], | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.3", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "types": [ | |
| "authentication" | |
| ], | |
| "auth-modules": { | |
| "module": "OCA\\OAuth2\\AuthModule" | |
| }, | |
| "settings": { | |
| "personal": "OCA\\OAuth2\\Panels\\PersonalPanel", | |
| "admin": "OCA\\OAuth2\\Panels\\AdminPanel" | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\OAuth2\\BackgroundJob\\CleanUp" | |
| }, | |
| "use-migrations": "true", | |
| "commands": [ | |
| "OCA\\OAuth2\\Commands\\AddClient", | |
| "OCA\\OAuth2\\Commands\\RemoveClient", | |
| "OCA\\OAuth2\\Commands\\ListClients", | |
| "OCA\\OAuth2\\Commands\\ModifyClient" | |
| ], | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/oauth2\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.5.3", | |
| "signed": "true", | |
| "types": "authentication" | |
| } | |
| }, | |
| { | |
| "id": "notifications", | |
| "name": "Notifications", | |
| "summary": "Notification system for internal events", | |
| "description": "This application adds an internal notification system to an ownCloud instance. Notifications are triggered by apps like the Announcement Center or Custom Groups and displayed via a bell indicator in the WebUI as well as via the ownCloud clients.", | |
| "category": "tools", | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/promo\/e1dd604d66b4c5f765579b4c160de3268169ea3c\/ownCloud%20logo%20square.png", | |
| "licence": "AGPL", | |
| "author": "Joas Schilling, Thomas M\u00fcller", | |
| "version": "0.5.4", | |
| "types": [ | |
| "logging" | |
| ], | |
| "default_enable": "", | |
| "website": "https:\/\/github.com\/owncloud\/notifications", | |
| "bugs": "https:\/\/github.com\/owncloud\/notifications\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/notifications.git" | |
| }, | |
| "commands": [ | |
| "OCA\\Notifications\\Command\\Generate", | |
| "OCA\\Notifications\\Command\\RepairNotifications" | |
| ], | |
| "settings": { | |
| "personal": "OCA\\Notifications\\Panels\\Personal\\NotificationsPanel" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.2", | |
| "max-version": "11" | |
| } | |
| } | |
| }, | |
| "use-migrations": "true", | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/notifications\/img\/notifications.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "0.5.4", | |
| "types": "logging" | |
| } | |
| }, | |
| { | |
| "id": "comments", | |
| "name": "Comments", | |
| "description": "Files app plugin to add comments to files", | |
| "licence": "AGPL", | |
| "author": "Arthur Schiwon, Vincent Petry", | |
| "default_enable": "", | |
| "version": "0.3.0", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "types": [ | |
| "logging", | |
| "dav" | |
| ], | |
| "sabre": { | |
| "plugins": { | |
| "plugin": "OCA\\Comments\\Dav\\CommentsPlugin" | |
| }, | |
| "collections": { | |
| "collection": "OCA\\Comments\\Dav\\RootCollection" | |
| } | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": false, | |
| "removable": true | |
| }, | |
| { | |
| "id": "user_external", | |
| "name": "External user support", | |
| "description": "Use external user authentication methods like IMAP, SMB and FTP", | |
| "licence": "AGPL", | |
| "author": "Robin Appelman", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.org\/server\/10.3\/admin_manual\/configuration\/user\/user_auth_ftp_smb_imap.html" | |
| }, | |
| "website": "https:\/\/github.com\/owncloud\/apps\/tree\/master\/user_external", | |
| "bugs": "https:\/\/github.com\/owncloud\/apps\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/user_external.git" | |
| }, | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "version": "0.6.0", | |
| "types": [ | |
| "authentication", | |
| "prelogin" | |
| ], | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/user_external\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "files_sharing", | |
| "name": "Share Files", | |
| "description": "This application enables users to share files within ownCloud. If enabled, the admin can choose which groups can share files. The applicable users can then share files and folders with other users and groups within ownCloud. In addition, if the admin enables the share link feature, an external link can be used to share files with other users outside of ownCloud. Admins can also enforce passwords, expirations dates, and enable server to server sharing via share links, as well as sharing from mobile devices. Turning the feature off removes shared files and folders on the server for all share recipients, and also on the sync clients and mobile apps. More information is available in the ownCloud Documentation.\n\n", | |
| "licence": "AGPL", | |
| "author": "Michael Gapczynski, Bjoern Schiessle", | |
| "default_enable": "", | |
| "version": "0.14.0", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "use-migrations": "true", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.0.2.4", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "public": { | |
| "files": "public.php" | |
| }, | |
| "namespace": "Files_Sharing", | |
| "settings-sections": { | |
| "personal": "OCA\\Files_Sharing\\Panels\\Personal\\Section" | |
| }, | |
| "settings": { | |
| "admin": "OCA\\Files_Sharing\\Panels\\Admin\\SettingsPanel", | |
| "personal": "OCA\\Files_Sharing\\Panels\\Personal\\PersonalPanel" | |
| }, | |
| "background-jobs": [ | |
| "OCA\\Files_Sharing\\DeleteOrphanedSharesJob", | |
| "OCA\\Files_Sharing\\ExpireSharesJob", | |
| "OCA\\Files_Sharing\\External\\ScanExternalSharesJob" | |
| ], | |
| "commands": { | |
| "command": "OCA\\Files_Sharing\\Command\\CleanupRemoteStorages" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/files_sharing\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "incoming_server2server_share_enabled": "no", | |
| "installed_version": "0.14.0", | |
| "outgoing_server2server_share_enabled": "no", | |
| "types": "filesystem" | |
| } | |
| }, | |
| { | |
| "id": "files_texteditor", | |
| "name": "Text Editor", | |
| "namespace": "Files_Texteditor", | |
| "summary": "Edit text files on the fly", | |
| "description": "This application enables ownCloud users to view, save and edit text files in the file view. If enabled, an entry for 'Text file' is shown in the '+' button menu at the top of the files view. When clicked, a new text file opens in the browser and the file is saved into the current directory. Furthermore, when a text file is clicked in the file list, it will be opened and editable. If the permissions allow, a user can also edit shared files and save these changes right away in the file view. More information is available in the Text Editor documentation.", | |
| "licence": "AGPL", | |
| "author": "Tom Needham, Bj\u00f6rn Schie\u00dfle", | |
| "version": "2.5.1", | |
| "default_enable": "", | |
| "documentation": { | |
| "user": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md", | |
| "admin": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md", | |
| "developer": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md" | |
| }, | |
| "category": "productivity", | |
| "website": "https:\/\/github.com\/owncloud\/files_texteditor", | |
| "bugs": "https:\/\/github.com\/owncloud\/files_texteditor\/issues", | |
| "repository": { | |
| "@attributes": { | |
| "type": "git" | |
| }, | |
| "@value": "https:\/\/github.com\/owncloud\/files_texteditor.git" | |
| }, | |
| "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/a068ff44c439aa4969ea37b60e45bed875bbbb98\/files_texteditor\/texteditor.png", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "types": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "commands": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": false, | |
| "removable": true, | |
| "preview": "\/apps\/files_texteditor\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "enabled": "yes", | |
| "installed_version": "2.5.1", | |
| "signed": "true", | |
| "types": "" | |
| } | |
| }, | |
| { | |
| "id": "files_external", | |
| "name": "External storage support", | |
| "description": "This application enables administrators to configure connections to external storage providers. Administrators can choose which types of storage to enable and can mount these storage locations for a user, a group, or the entire system. Users will see a new folder appear in their root ownCloud directory, which they can access and use like any other ownCloud folder. External Storage also allows users to share files stored in these external locations. In these cases, the credentials for the owner of the file are used when the recipient requests the file from external storage, thereby ensuring that the recipient can access the shared file.\n\nExternal Storage can be configured using the GUI or at the command line. This second option provides the advanced user with more flexibility for configuring bulk external storage mounts and setting mount priorities. More information is available in the External Storage GUI documentation and the External Storage Configuration File documentation.", | |
| "licence": "AGPL", | |
| "author": "Robin Appelman, Michael Gapczynski, Vincent Petry", | |
| "documentation": { | |
| "admin": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=admin-external-storage" | |
| }, | |
| "rememberlogin": "false", | |
| "version": "0.9.0", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "ocsid": "166048", | |
| "use-migrations": "true", | |
| "namespace": "Files_External", | |
| "default_enable": "", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "commands": [ | |
| "OCA\\Files_External\\Command\\ListCommand", | |
| "OCA\\Files_External\\Command\\Config", | |
| "OCA\\Files_External\\Command\\Option", | |
| "OCA\\Files_External\\Command\\Applicable", | |
| "OCA\\Files_External\\Command\\Import", | |
| "OCA\\Files_External\\Command\\Export", | |
| "OCA\\Files_External\\Command\\Delete", | |
| "OCA\\Files_External\\Command\\Create", | |
| "OCA\\Files_External\\Command\\Backends", | |
| "OCA\\Files_External\\Command\\Verify" | |
| ], | |
| "settings": { | |
| "admin": "OCA\\Files_External\\Panels\\Admin", | |
| "personal": "OCA\\Files_External\\Panels\\Personal" | |
| }, | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "background-jobs": [], | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": false, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/files_external\/img\/app.svg", | |
| "previewAsIcon": true | |
| }, | |
| { | |
| "id": "files_trashbin", | |
| "name": "Deleted files", | |
| "description": "This application enables users to restore files that were deleted from the system. It displays a list of deleted files in the web interface, and has options to restore those deleted files back to their ownCloud file directories or remove them permanently from the system. Restoring a file also restores related file versions, if the versions application is enabled. When a file is deleted from a share, it can be restored in the same manner, though it is no longer shared. By default, these files remain in the trash bin for 30 days. To prevent a user from running out of disk space, the ownCloud Deleted files app will not utilize more than 50% of the currently available free quota for deleted files. If the deleted files exceed this limit, ownCloud deletes the oldest files until it gets below this limit. More information is available in the Deleted Files documentation.\n\n", | |
| "licence": "AGPL", | |
| "author": "Bjoern Schiessle", | |
| "default_enable": "", | |
| "version": "0.9.1", | |
| "types": [ | |
| "filesystem" | |
| ], | |
| "use-migrations": "true", | |
| "namespace": "Files_Trashbin", | |
| "dependencies": { | |
| "owncloud": { | |
| "@attributes": { | |
| "min-version": "10.0.2.4", | |
| "max-version": "10" | |
| } | |
| } | |
| }, | |
| "documentation": { | |
| "user": "https:\/\/doc.owncloud.com\/server\/10.11\/go.php?to=user-trashbin" | |
| }, | |
| "background-jobs": { | |
| "job": "OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash" | |
| }, | |
| "commands": [ | |
| "OCA\\Files_Trashbin\\Command\\CleanUp", | |
| "OCA\\Files_Trashbin\\Command\\ExpireTrash" | |
| ], | |
| "info": [], | |
| "remote": [], | |
| "public": [], | |
| "repair-steps": { | |
| "install": [], | |
| "pre-migration": [], | |
| "post-migration": [], | |
| "live-migration": [], | |
| "uninstall": [] | |
| }, | |
| "two-factor-providers": [], | |
| "_cached": true, | |
| "groups": null, | |
| "active": true, | |
| "internal": true, | |
| "level": 200, | |
| "removable": false, | |
| "preview": "\/apps\/files_trashbin\/img\/app.svg", | |
| "previewAsIcon": true, | |
| "appconfig": { | |
| "cronjob_trash_expiry_offset": "0", | |
| "enabled": "yes", | |
| "installed_version": "0.9.1", | |
| "types": "filesystem" | |
| } | |
| } | |
| ], | |
| "mounts": [], | |
| "tables": { | |
| "tableNames": { | |
| "oc_account_terms": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "account_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "term": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "term_index", | |
| "columns": [ | |
| "term" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "account_id_index", | |
| "columns": [ | |
| "account_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_accounts": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "email": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lower_user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "display_name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "quota": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_login": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "backend": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "home": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "state": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "lower_user_id_index", | |
| "columns": [ | |
| "lower_user_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "display_name_index", | |
| "columns": [ | |
| "display_name" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "email_index", | |
| "columns": [ | |
| "email" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "UNIQ_907AA303A76ED395", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_activity": { | |
| "fields": [ | |
| { | |
| "activity_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "timestamp": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "priority": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "affecteduser": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "app": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "subject": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "subjectparams": { | |
| "type": "text", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "message": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "messageparams": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "link": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_type": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "activity_time", | |
| "columns": [ | |
| "timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "activity_filter_app", | |
| "columns": [ | |
| "affecteduser", | |
| "app", | |
| "timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "activity_filter_by", | |
| "columns": [ | |
| "affecteduser", | |
| "user", | |
| "timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "activity_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "activity_object", | |
| "columns": [ | |
| "object_type", | |
| "object_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "activity_user_time", | |
| "columns": [ | |
| "affecteduser", | |
| "timestamp" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "activity_id" | |
| ] | |
| } | |
| }, | |
| "oc_activity_mq": { | |
| "fields": [ | |
| { | |
| "mail_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "amq_timestamp": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_latest_send": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_affecteduser": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_appid": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_subject": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "amq_subjectparams": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "amp_latest_send_time", | |
| "columns": [ | |
| "amq_latest_send" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "amp_timestamp_time", | |
| "columns": [ | |
| "amq_timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "mail_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "amp_user", | |
| "columns": [ | |
| "amq_affecteduser" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "mail_id" | |
| ] | |
| } | |
| }, | |
| "oc_addressbookchanges": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "synctoken": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "addressbookid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "operation": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "addressbookid_synctoken", | |
| "columns": [ | |
| "addressbookid", | |
| "synctoken" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_addressbooks": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "principaluri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "displayname": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "description": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "synctoken": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "addressbook_index", | |
| "columns": [ | |
| "principaluri", | |
| "uri" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_announcements": { | |
| "fields": [ | |
| { | |
| "announcement_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "announcement_time": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "announcement_user": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "announcement_subject": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "announcement_message": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "announcement_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "announcement_id" | |
| ] | |
| } | |
| }, | |
| "oc_appconfig": { | |
| "fields": [ | |
| { | |
| "appid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "configkey": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "configvalue": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "appconfig_config_key_index", | |
| "columns": [ | |
| "configkey" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "appconfig_appid_key", | |
| "columns": [ | |
| "appid" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "appid", | |
| "configkey" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "appid", | |
| "configkey" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_albums": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "year": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "genre_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "cover": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "bgcolor": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "artist_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "folder_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "albums_album_user_idx", | |
| "columns": [ | |
| "id", | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "albums_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_artists": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "artists_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_genre": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "genre_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_playlist_tracks": { | |
| "fields": [ | |
| { | |
| "playlist_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "track_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "sortorder": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "playlist_tracks_idx", | |
| "columns": [ | |
| "playlist_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "playlist_tracks_unique_idx", | |
| "columns": [ | |
| "playlist_id", | |
| "track_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_audioplayer_playlists": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "playlists_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_stats": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "track_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "playtime": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "playcount": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "stats_file_user_id_idx", | |
| "columns": [ | |
| "track_id", | |
| "user_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_streams": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "title": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mimetype": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "streams_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_audioplayer_tracks": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "title": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "number": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "artist_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "album_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "length": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "bitrate": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mimetype": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "genre_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "year": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "folder_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "disc": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "composer": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "subtitle": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "isrc": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "copyright": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "tracks_year_idx", | |
| "columns": [ | |
| "year", | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "tracks_user_id_idx", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "tracks_genre_id_idx", | |
| "columns": [ | |
| "genre_id", | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "tracks_folder_id_idx", | |
| "columns": [ | |
| "folder_id", | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "tracks_album_id_idx", | |
| "columns": [ | |
| "album_id", | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "tracks_artist_id_idx", | |
| "columns": [ | |
| "artist_id", | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_authtoken": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "login_name": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "password": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "text", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_activity": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_check": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "authtoken_last_activity_index", | |
| "columns": [ | |
| "last_activity" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "authtoken_token_index", | |
| "columns": [ | |
| "token" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_bfp_failed_logins": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "ip": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "attempted_at": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "bfp_failed_logins_at", | |
| "columns": [ | |
| "attempted_at" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "bfp_failed_logins_ip", | |
| "columns": [ | |
| "ip" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_bfp_link_accesses": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "ip": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "link_token": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "attempted_at": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "bfp_link_accesses_at", | |
| "columns": [ | |
| "attempted_at" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "bfp_link_accesses_ip", | |
| "columns": [ | |
| "ip" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_calendarchanges": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "synctoken": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "operation": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "calendarid_synctoken", | |
| "columns": [ | |
| "calendarid", | |
| "synctoken" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_calendarobjects": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "calendardata": { | |
| "type": "blob", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastmodified": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "etag": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "size": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "componenttype": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "firstoccurence": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastoccurence": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "classification": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "calobjects_index", | |
| "columns": [ | |
| "calendarid", | |
| "uri" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_calendars": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "principaluri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "displayname": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "synctoken": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "description": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarorder": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarcolor": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "timezone": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "components": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "transparent": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "calendars_index", | |
| "columns": [ | |
| "principaluri", | |
| "uri" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_calendarsubscriptions": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "principaluri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "source": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "displayname": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "refreshrate": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarorder": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendarcolor": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "striptodos": { | |
| "type": "smallint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "stripalarms": { | |
| "type": "smallint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "stripattachments": { | |
| "type": "smallint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastmodified": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "calsub_index", | |
| "columns": [ | |
| "principaluri", | |
| "uri" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_cards": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "addressbookid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "carddata": { | |
| "type": "blob", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastmodified": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "etag": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "size": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "addressbookid_uri_index", | |
| "columns": [ | |
| "addressbookid", | |
| "uri" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_cards_properties": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "addressbookid": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "cardid": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "value": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "preferred": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "card_name_index", | |
| "columns": [ | |
| "name" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "card_value_index", | |
| "columns": [ | |
| "value" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "card_bookid_name_index", | |
| "columns": [ | |
| "addressbookid", | |
| "name" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "card_contactid_index", | |
| "columns": [ | |
| "cardid" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_comments": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "parent_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "topmost_parent_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "children_count": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "actor_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "actor_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "message": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "verb": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "creation_timestamp": { | |
| "type": "datetime", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "latest_child_timestamp": { | |
| "type": "datetime", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "comments_topmost_parent_id_idx", | |
| "columns": [ | |
| "topmost_parent_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "comments_actor_index", | |
| "columns": [ | |
| "actor_type", | |
| "actor_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "comments_object_index", | |
| "columns": [ | |
| "object_type", | |
| "object_id", | |
| "creation_timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "comments_parent_id_index", | |
| "columns": [ | |
| "parent_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_comments_read_markers": { | |
| "fields": [ | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "marker_datetime": { | |
| "type": "datetime", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "comments_marker_object_index", | |
| "columns": [ | |
| "object_type", | |
| "object_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "comments_marker_index", | |
| "columns": [ | |
| "user_id", | |
| "object_type", | |
| "object_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_credentials": { | |
| "fields": [ | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "identifier": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "credentials": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "credentials_user", | |
| "columns": [ | |
| "user" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "user", | |
| "identifier" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "user", | |
| "identifier" | |
| ] | |
| } | |
| }, | |
| "oc_dav_job_status": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uuid": { | |
| "type": "guid", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "status_info": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "UNIQ_18BBA548D17F50A6", | |
| "columns": [ | |
| "uuid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_dav_properties": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "propertypath": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "propertyname": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "propertyvalue": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "propertytype": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "propertypath_index", | |
| "columns": [ | |
| "propertypath" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_dav_shares": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "principaluri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "access": { | |
| "type": "smallint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "resourceid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "publicuri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "dav_shares_index", | |
| "columns": [ | |
| "principaluri", | |
| "resourceid", | |
| "type", | |
| "publicuri" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_documents_invite": { | |
| "fields": [ | |
| { | |
| "es_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "status": { | |
| "type": "smallint", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "sent_on": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_documents_member": { | |
| "fields": [ | |
| { | |
| "member_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "es_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "color": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_activity": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "is_guest": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "status": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "member_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "member_id" | |
| ] | |
| } | |
| }, | |
| "oc_documents_op": { | |
| "fields": [ | |
| { | |
| "seq": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "es_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "member": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "optype": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "opspec": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "seq" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "documents_op_eis_idx", | |
| "columns": [ | |
| "es_id", | |
| "seq" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "seq" | |
| ] | |
| } | |
| }, | |
| "oc_documents_revisions": { | |
| "fields": [ | |
| { | |
| "es_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "seq_head": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "member_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "save_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "documents_rev_eis_idx", | |
| "columns": [ | |
| "es_id", | |
| "seq_head" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_documents_session": { | |
| "fields": [ | |
| { | |
| "es_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "genesis_url": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "genesis_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "owner": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "es_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "es_id" | |
| ] | |
| } | |
| }, | |
| "oc_external_applicable": { | |
| "fields": [ | |
| { | |
| "applicable_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "mount_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "value": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "applicable_type_value", | |
| "columns": [ | |
| "type", | |
| "value" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "applicable_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "applicable_mount", | |
| "columns": [ | |
| "mount_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "applicable_type_value_mount", | |
| "columns": [ | |
| "type", | |
| "value", | |
| "mount_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "applicable_id" | |
| ] | |
| } | |
| }, | |
| "oc_external_config": { | |
| "fields": [ | |
| { | |
| "config_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "mount_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "key": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "value": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "config_mount", | |
| "columns": [ | |
| "mount_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "config_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "config_mount_key", | |
| "columns": [ | |
| "mount_id", | |
| "key" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "config_id" | |
| ] | |
| } | |
| }, | |
| "oc_external_mounts": { | |
| "fields": [ | |
| { | |
| "mount_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "mount_point": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "storage_backend": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "auth_backend": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "priority": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "100", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "mount_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "mount_id" | |
| ] | |
| } | |
| }, | |
| "oc_external_options": { | |
| "fields": [ | |
| { | |
| "option_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "mount_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "key": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "value": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "option_mount", | |
| "columns": [ | |
| "mount_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "option_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "option_mount_key", | |
| "columns": [ | |
| "mount_id", | |
| "key" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "option_id" | |
| ] | |
| } | |
| }, | |
| "oc_federated_reshares": { | |
| "fields": [ | |
| { | |
| "share_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "remote_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "share_id_index", | |
| "columns": [ | |
| "share_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_file_locks": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "lock": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "key": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "ttl": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "-1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "lock_ttl_index", | |
| "columns": [ | |
| "ttl" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "lock_key_index", | |
| "columns": [ | |
| "key" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_filecache": { | |
| "fields": [ | |
| { | |
| "fileid": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "storage": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "path": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "path_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "parent": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mimetype": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mimepart": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "size": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mtime": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "storage_mtime": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "encrypted": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "unencrypted_size": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "etag": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "permissions": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "checksum": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "fs_storage_mimetype", | |
| "columns": [ | |
| "storage", | |
| "mimetype" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "fs_storage_size", | |
| "columns": [ | |
| "storage", | |
| "size", | |
| "fileid" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "fs_parent_name_hash", | |
| "columns": [ | |
| "parent", | |
| "name" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "fileid" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "fs_storage_mimepart", | |
| "columns": [ | |
| "storage", | |
| "mimepart" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "fs_storage_path_hash", | |
| "columns": [ | |
| "storage", | |
| "path_hash" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "fileid" | |
| ] | |
| } | |
| }, | |
| "oc_files_trash": { | |
| "fields": [ | |
| { | |
| "auto_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "timestamp": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "location": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mime": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "timestamp_index", | |
| "columns": [ | |
| "timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "user_index", | |
| "columns": [ | |
| "user" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "auto_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "id_index", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "auto_id" | |
| ] | |
| } | |
| }, | |
| "oc_group_admin": { | |
| "fields": [ | |
| { | |
| "gid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "group_admin_uid", | |
| "columns": [ | |
| "uid" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "gid", | |
| "uid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "gid", | |
| "uid" | |
| ] | |
| } | |
| }, | |
| "oc_group_user": { | |
| "fields": [ | |
| { | |
| "gid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "gu_uid_index", | |
| "columns": [ | |
| "uid" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "gid", | |
| "uid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "gid", | |
| "uid" | |
| ] | |
| } | |
| }, | |
| "oc_groups": { | |
| "fields": [ | |
| { | |
| "gid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "gid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "gid" | |
| ] | |
| } | |
| }, | |
| "oc_jobs": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "class": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "argument": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_run": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_checked": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "reserved_at": { | |
| "type": "integer", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "execution_duration": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "-1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "job_class_index", | |
| "columns": [ | |
| "class" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_migrations": { | |
| "fields": [ | |
| { | |
| "app": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "version": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "app", | |
| "version" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "app", | |
| "version" | |
| ] | |
| } | |
| }, | |
| "oc_mimetypes": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "mimetype": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "mimetype_id_index", | |
| "columns": [ | |
| "mimetype" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_mounts": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "storage_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "root_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mount_point": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "mounts_root_index", | |
| "columns": [ | |
| "root_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "mounts_user_index", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "mounts_storage_index", | |
| "columns": [ | |
| "storage_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "mounts_user_root_index", | |
| "columns": [ | |
| "user_id", | |
| "root_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_notifications": { | |
| "fields": [ | |
| { | |
| "notification_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "app": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "timestamp": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "object_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "subject": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "subject_parameters": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "message": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "message_parameters": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "link": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "icon": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "actions": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "oc_notifications_user", | |
| "columns": [ | |
| "user" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "oc_notifications_timestamp", | |
| "columns": [ | |
| "timestamp" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "notification_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "oc_notifications_object", | |
| "columns": [ | |
| "object_type", | |
| "object_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "oc_notifications_app", | |
| "columns": [ | |
| "app" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "notification_id" | |
| ] | |
| } | |
| }, | |
| "oc_oauth2_access_tokens": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "client_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "expires": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "oauth2_token", | |
| "columns": [ | |
| "token" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_oauth2_auth_codes": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "code": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "client_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "expires": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "code_challenge": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "code_challenge_method": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_oauth2_clients": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "identifier": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "secret": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "redirect_uri": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "allow_subdomains": { | |
| "type": "boolean", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "trusted": { | |
| "type": "boolean", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "name_idx", | |
| "columns": [ | |
| "name" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_oauth2_refresh_tokens": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "client_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "access_token_id": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_onlyoffice_filekey": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": "-1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "key": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lock": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "fs": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "onlyoffice_file_id_index", | |
| "columns": [ | |
| "file_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_onlyoffice_instance": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "remote": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "expire": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "status": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "onlyoffice_remote_index", | |
| "columns": [ | |
| "remote" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_persistent_locks": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "file_id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "owner_account_id": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "owner": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "timeout": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "created_at": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "scope": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "depth": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "IDX_F0C3D55B93CB796C", | |
| "columns": [ | |
| "file_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "IDX_F0C3D55BC901C6FF", | |
| "columns": [ | |
| "owner_account_id" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "UNIQ_F0C3D55BB3BC57DA", | |
| "columns": [ | |
| "token_hash" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_preferences": { | |
| "fields": [ | |
| { | |
| "userid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "appid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "configkey": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "configvalue": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "userid", | |
| "appid", | |
| "configkey" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "userid", | |
| "appid", | |
| "configkey" | |
| ] | |
| } | |
| }, | |
| "oc_privatedata": { | |
| "fields": [ | |
| { | |
| "keyid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "app": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "key": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "value": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "keyid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "keyid" | |
| ] | |
| } | |
| }, | |
| "oc_properties": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "propertyname": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "propertyvalue": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "fileid": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "propertytype": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "fileid_index", | |
| "columns": [ | |
| "fileid" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_schedulingobjects": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "principaluri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "calendardata": { | |
| "type": "blob", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uri": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastmodified": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "etag": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "size": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_share": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "share_type": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "share_with": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid_owner": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "parent": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "item_type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "item_source": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "item_target": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_source": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "file_target": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "permissions": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "stime": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "accepted": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "expiration": { | |
| "type": "datetime", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mail_send": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "uid_initiator": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "share_name": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "attributes": { | |
| "type": "text", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "share_with_index", | |
| "columns": [ | |
| "share_with" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "item_source_index", | |
| "columns": [ | |
| "item_source" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "file_source_index", | |
| "columns": [ | |
| "file_source" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "item_source_type_index", | |
| "columns": [ | |
| "item_source", | |
| "share_type", | |
| "item_type" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "token_index", | |
| "columns": [ | |
| "token" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "item_share_type_index", | |
| "columns": [ | |
| "item_type", | |
| "share_type" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_share_external": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "remote": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "remote_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "-1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "share_token": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "password": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "owner": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "user": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mountpoint": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "mountpoint_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "accepted": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "lastscan": { | |
| "type": "bigint", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "sh_external_user", | |
| "columns": [ | |
| "user" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "sh_external_mp", | |
| "columns": [ | |
| "user", | |
| "mountpoint_hash" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_storages": { | |
| "fields": [ | |
| { | |
| "numeric_id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "id": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "available": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_checked": { | |
| "type": "integer", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "numeric_id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "storages_id_index", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "numeric_id" | |
| ] | |
| } | |
| }, | |
| "oc_systemtag": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "name": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "visibility": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "editable": { | |
| "type": "smallint", | |
| "null": false, | |
| "default": "1", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "assignable": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "tag_ident", | |
| "columns": [ | |
| "name", | |
| "visibility", | |
| "editable", | |
| "assignable" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_systemtag_group": { | |
| "fields": [ | |
| { | |
| "systemtagid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "gid": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "gid", | |
| "systemtagid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "gid", | |
| "systemtagid" | |
| ] | |
| } | |
| }, | |
| "oc_systemtag_object_mapping": { | |
| "fields": [ | |
| { | |
| "objectid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "objecttype": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "systemtagid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "mapping", | |
| "columns": [ | |
| "objecttype", | |
| "objectid", | |
| "systemtagid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [] | |
| } | |
| }, | |
| "oc_trusted_servers": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "url": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "url_hash": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "token": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "shared_secret": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "status": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "2", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "sync_token": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "url_hash", | |
| "columns": [ | |
| "url_hash" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_twofactor_backup_codes": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "code": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "twofactor_backup_codes_user_id", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_twofactor_totp_secrets": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "user_id": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "secret": { | |
| "type": "text", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "verified": { | |
| "type": "boolean", | |
| "null": true, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "last_validated_key": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "totp_secrets_user_id", | |
| "columns": [ | |
| "user_id" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_user_password_history": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "password": { | |
| "type": "text", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "change_time": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "pp_uid_index", | |
| "columns": [ | |
| "uid" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_users": { | |
| "fields": [ | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "displayname": { | |
| "type": "string", | |
| "null": true, | |
| "default": null, | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "password": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "uid" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "uid" | |
| ] | |
| } | |
| }, | |
| "oc_vcategory": { | |
| "fields": [ | |
| { | |
| "id": { | |
| "type": "integer", | |
| "null": false, | |
| "default": null, | |
| "autoIncrement": true | |
| } | |
| }, | |
| { | |
| "uid": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "category": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "type_index", | |
| "columns": [ | |
| "type" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "category_index", | |
| "columns": [ | |
| "category" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "id" | |
| ], | |
| "unique": true | |
| }, | |
| { | |
| "indexName": "uid_index", | |
| "columns": [ | |
| "uid" | |
| ], | |
| "unique": false | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "id" | |
| ] | |
| } | |
| }, | |
| "oc_vcategory_to_object": { | |
| "fields": [ | |
| { | |
| "objid": { | |
| "type": "bigint", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "categoryid": { | |
| "type": "integer", | |
| "null": false, | |
| "default": "0", | |
| "autoIncrement": false | |
| } | |
| }, | |
| { | |
| "type": { | |
| "type": "string", | |
| "null": false, | |
| "default": "", | |
| "autoIncrement": false | |
| } | |
| } | |
| ], | |
| "index": [ | |
| { | |
| "indexName": "vcategory_objectd_index", | |
| "columns": [ | |
| "objid", | |
| "type" | |
| ], | |
| "unique": false | |
| }, | |
| { | |
| "indexName": "PRIMARY", | |
| "columns": [ | |
| "categoryid", | |
| "objid", | |
| "type" | |
| ], | |
| "unique": true | |
| } | |
| ], | |
| "0": { | |
| "primaryColumns": [ | |
| "categoryid", | |
| "objid", | |
| "type" | |
| ] | |
| } | |
| } | |
| } | |
| }, | |
| "migrations": [ | |
| { | |
| "app": "activity", | |
| "version": "20161122085340" | |
| }, | |
| { | |
| "app": "activity", | |
| "version": "20161122092159" | |
| }, | |
| { | |
| "app": "activity", | |
| "version": "20170131134507" | |
| }, | |
| { | |
| "app": "activity", | |
| "version": "20170724182159" | |
| }, | |
| { | |
| "app": "activity", | |
| "version": "20181019151118" | |
| }, | |
| { | |
| "app": "activity", | |
| "version": "20181022150134" | |
| }, | |
| { | |
| "app": "brute_force_protection", | |
| "version": "20180802194631" | |
| }, | |
| { | |
| "app": "brute_force_protection", | |
| "version": "20191109111104" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170101010100" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170101215145" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170111103310" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170213215145" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170214112458" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170221114437" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170221121536" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170315173825" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170320173955" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170418154659" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170516100103" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170526104128" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170605143658" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170711191432" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170804201253" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20170928120000" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20171026130750" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20180123131835" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20180302155233" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20180319102121" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20180607072706" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20181017105216" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20181017120818" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20181113071753" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20181220085457" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20190125162909" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20200610110817" | |
| }, | |
| { | |
| "app": "core", | |
| "version": "20210928123126" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170116150538" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170116170538" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170202213905" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170202220512" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170427182800" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170519091921" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170526100342" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170711193427" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20170927201245" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20180622095921" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20181115210344" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20190823065724" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20200114181454" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20200427142541" | |
| }, | |
| { | |
| "app": "dav", | |
| "version": "20210714123001" | |
| }, | |
| { | |
| "app": "encryption", | |
| "version": "20170913113840" | |
| }, | |
| { | |
| "app": "federatedfilesharing", | |
| "version": "20170804201125" | |
| }, | |
| { | |
| "app": "federatedfilesharing", | |
| "version": "20170804201253" | |
| }, | |
| { | |
| "app": "federatedfilesharing", | |
| "version": "20190410160725" | |
| }, | |
| { | |
| "app": "files_external", | |
| "version": "20170814051424" | |
| }, | |
| { | |
| "app": "files_external", | |
| "version": "20210511082903" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20170804201125" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20170804201253" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20170830112305" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20171115154900" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20171215103657" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20190426123324" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20200504211654" | |
| }, | |
| { | |
| "app": "files_sharing", | |
| "version": "20200823121322" | |
| }, | |
| { | |
| "app": "files_trashbin", | |
| "version": "20170804201125" | |
| }, | |
| { | |
| "app": "files_trashbin", | |
| "version": "20170804201253" | |
| }, | |
| { | |
| "app": "notifications", | |
| "version": "20170801085340" | |
| }, | |
| { | |
| "app": "notifications", | |
| "version": "20170801152524" | |
| }, | |
| { | |
| "app": "notifications", | |
| "version": "20180119080933" | |
| }, | |
| { | |
| "app": "notifications", | |
| "version": "20180604132522" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20161122085340" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20170329194544" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20170724162518" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20201123114127" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20201126140622" | |
| }, | |
| { | |
| "app": "oauth2", | |
| "version": "20220312110422" | |
| }, | |
| { | |
| "app": "password_policy", | |
| "version": "20180123143343" | |
| }, | |
| { | |
| "app": "password_policy", | |
| "version": "20211102124544" | |
| } | |
| ], | |
| "phpinfo": { | |
| "apcu": { | |
| "APCu Support": "Enabled", | |
| "Version": "5.1.18", | |
| "APCu Debugging": "Disabled", | |
| "MMAP Support": "Enabled", | |
| "MMAP File Mask": "no value", | |
| "Serialization Support": "php", | |
| "Build Date": "Jul 21 2020 22:56:51", | |
| "apc.coredump_unmap": "Off", | |
| "apc.enable_cli": "Off", | |
| "apc.enabled": "On", | |
| "apc.entries_hint": "4096", | |
| "apc.gc_ttl": "3600", | |
| "apc.mmap_file_mask": "no value", | |
| "apc.preload_path": "no value", | |
| "apc.serializer": "php", | |
| "apc.shm_segments": "1", | |
| "apc.shm_size": "32M", | |
| "apc.slam_defense": "Off", | |
| "apc.smart": "0", | |
| "apc.ttl": "0", | |
| "apc.use_request_time": "On" | |
| }, | |
| "bcmath": { | |
| "BCMath support": "enabled", | |
| "bcmath.scale": "0" | |
| }, | |
| "bz2": { | |
| "BZip2 Support": "Enabled", | |
| "Stream Wrapper support": "compress.bzip2:\/\/", | |
| "Stream Filter support": "bzip2.decompress, bzip2.compress", | |
| "BZip2 Version": "1.0.8, 13-Jul-2019" | |
| }, | |
| "calendar": { | |
| "Calendar support": "enabled" | |
| }, | |
| "cgi-fcgi": { | |
| "php-fpm": "active", | |
| "cgi.discard_path": "0", | |
| "cgi.fix_pathinfo": "1", | |
| "cgi.force_redirect": "1", | |
| "cgi.nph": "0", | |
| "cgi.redirect_status_env": "no value", | |
| "cgi.rfc2616_headers": "0", | |
| "fastcgi.error_header": "no value", | |
| "fastcgi.logging": "1", | |
| "fpm.config": "no value" | |
| }, | |
| "Core": { | |
| "PHP Version": "7.4.33", | |
| "allow_url_fopen": "On", | |
| "allow_url_include": "Off", | |
| "arg_separator.input": "&", | |
| "arg_separator.output": "&", | |
| "auto_append_file": "no value", | |
| "auto_globals_jit": "On", | |
| "auto_prepend_file": "no value", | |
| "browscap": "no value", | |
| "default_charset": "UTF-8", | |
| "default_mimetype": "text\/html", | |
| "disable_classes": "no value", | |
| "disable_functions": "opcache_get_status", | |
| "display_errors": "Off", | |
| "display_startup_errors": "Off", | |
| "doc_root": "no value", | |
| "docref_ext": "no value", | |
| "docref_root": "no value", | |
| "enable_dl": "Off", | |
| "enable_post_data_reading": "On", | |
| "error_append_string": "no value", | |
| "error_log": "no value", | |
| "error_prepend_string": "no value", | |
| "error_reporting": [ | |
| "32767", | |
| "22519" | |
| ], | |
| "expose_php": "On", | |
| "extension_dir": "\/opt\/plesk\/php\/7.4\/lib\/php\/modules", | |
| "file_uploads": "On", | |
| "hard_timeout": "2", | |
| "highlight.comment": "#FF8000", | |
| "highlight.default": "#0000BB", | |
| "highlight.html": "#000000", | |
| "highlight.keyword": "#007700", | |
| "highlight.string": "#DD0000", | |
| "html_errors": "On", | |
| "ignore_repeated_errors": "Off", | |
| "ignore_repeated_source": "Off", | |
| "ignore_user_abort": "Off", | |
| "implicit_flush": "Off", | |
| "input_encoding": "no value", | |
| "internal_encoding": "no value", | |
| "log_errors": "On", | |
| "log_errors_max_len": "1024", | |
| "mail.add_x_header": "Off", | |
| "mail.force_extra_parameters": "no value", | |
| "mail.log": "no value", | |
| "max_execution_time": [ | |
| "3600", | |
| "180" | |
| ], | |
| "max_file_uploads": "20", | |
| "max_input_nesting_level": "64", | |
| "max_input_time": "60", | |
| "max_input_vars": "2000", | |
| "memory_limit": "512M", | |
| "open_basedir": "\/var\/www\/vhosts\/***REMOVED SENSITIVE VALUE***\/:\/tmp\/:\/dev\/urandom", | |
| "output_buffering": [ | |
| "0", | |
| "4096" | |
| ], | |
| "output_encoding": "no value", | |
| "output_handler": "no value", | |
| "post_max_size": [ | |
| "513M", | |
| "512M" | |
| ], | |
| "precision": "14", | |
| "realpath_cache_size": "4096K", | |
| "realpath_cache_ttl": "120", | |
| "register_argc_argv": "Off", | |
| "report_memleaks": "On", | |
| "report_zend_debug": "On", | |
| "request_order": "GP", | |
| "sendmail_from": "no value", | |
| "sendmail_path": "\/usr\/sbin\/sendmail -t -i", | |
| "serialize_precision": "-1", | |
| "short_open_tag": "Off", | |
| "SMTP": "localhost", | |
| "smtp_port": "25", | |
| "sys_temp_dir": "no value", | |
| "syslog.facility": "LOG_USER", | |
| "syslog.filter": "no-ctrl", | |
| "syslog.ident": "php", | |
| "track_errors": "Off", | |
| "unserialize_callback_func": "no value", | |
| "upload_max_filesize": [ | |
| "513M", | |
| "512M" | |
| ], | |
| "upload_tmp_dir": "no value", | |
| "user_dir": "no value", | |
| "user_ini.cache_ttl": "300", | |
| "user_ini.filename": ".user.ini", | |
| "variables_order": "GPCS", | |
| "xmlrpc_error_number": "0", | |
| "xmlrpc_errors": "Off", | |
| "zend.assertions": "-1", | |
| "zend.detect_unicode": "On", | |
| "zend.enable_gc": "On", | |
| "zend.exception_ignore_args": "On", | |
| "zend.multibyte": "Off", | |
| "zend.script_encoding": "no value", | |
| "zend.signal_check": "Off" | |
| }, | |
| "ctype": { | |
| "ctype functions": "enabled" | |
| }, | |
| "curl": { | |
| "cURL support": "enabled", | |
| "cURL Information": "7.81.0", | |
| "Age": "9", | |
| "Features": null, | |
| "AsynchDNS": "Yes", | |
| "CharConv": "No", | |
| "Debug": "No", | |
| "GSS-Negotiate": "No", | |
| "IDN": "Yes", | |
| "IPv6": "Yes", | |
| "krb4": "No", | |
| "Largefile": "Yes", | |
| "libz": "Yes", | |
| "NTLM": "Yes", | |
| "NTLMWB": "Yes", | |
| "SPNEGO": "Yes", | |
| "SSL": "Yes", | |
| "SSPI": "No", | |
| "TLS-SRP": "Yes", | |
| "HTTP2": "Yes", | |
| "GSSAPI": "Yes", | |
| "KERBEROS5": "Yes", | |
| "UNIX_SOCKETS": "Yes", | |
| "PSL": "Yes", | |
| "HTTPS_PROXY": "Yes", | |
| "MULTI_SSL": "No", | |
| "BROTLI": "Yes", | |
| "Protocols": "dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, ldap, ldaps, mqtt, pop3, pop3s, rtmp, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp", | |
| "Host": "x86_64-pc-linux-gnu", | |
| "SSL Version": "OpenSSL\/3.0.2", | |
| "ZLib Version": "1.2.11", | |
| "libSSH Version": "libssh\/0.9.6\/openssl\/zlib", | |
| "curl.cainfo": "no value" | |
| }, | |
| "date": { | |
| "date\/time support": "enabled", | |
| "timelib version": "2018.04", | |
| ""Olson" Timezone Database Version": "0.system", | |
| "Timezone Database": "internal", | |
| "Default timezone": "UTC", | |
| "date.default_latitude": "31.7667", | |
| "date.default_longitude": "35.2333", | |
| "date.sunrise_zenith": "90.583333", | |
| "date.sunset_zenith": "90.583333", | |
| "date.timezone": "no value" | |
| }, | |
| "dba": { | |
| "DBA support": "enabled", | |
| "Supported handlers": "cdb cdb_make db4 inifile flatfile", | |
| "dba.default_handler": "flatfile" | |
| }, | |
| "dom": { | |
| "DOM\/XML": "enabled", | |
| "DOM\/XML API Version": "20031129", | |
| "libxml Version": "2.9.13", | |
| "HTML Support": "enabled", | |
| "XPath Support": "enabled", | |
| "XPointer Support": "enabled", | |
| "Schema Support": "enabled", | |
| "RelaxNG Support": "enabled" | |
| }, | |
| "enchant": { | |
| "enchant support": "enabled", | |
| "Libenchant Version": "2.3.2", | |
| "aspell": [ | |
| "Aspell Provider", | |
| "\/usr\/lib\/x86_64-linux-gnu\/enchant-2\/enchant_aspell.so" | |
| ], | |
| "hunspell": [ | |
| "Hunspell Provider", | |
| "\/usr\/lib\/x86_64-linux-gnu\/enchant-2\/enchant_hunspell.so" | |
| ], | |
| "hspell": [ | |
| "Hspell Provider", | |
| "\/usr\/lib\/x86_64-linux-gnu\/enchant-2\/enchant_hspell.so" | |
| ] | |
| }, | |
| "exif": { | |
| "EXIF Support": "enabled", | |
| "Supported EXIF Version": "0220", | |
| "Supported filetypes": "JPEG, TIFF", | |
| "Multibyte decoding support using mbstring": "enabled", | |
| "Extended EXIF tag formats": "Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson", | |
| "exif.decode_jis_intel": "JIS", | |
| "exif.decode_jis_motorola": "JIS", | |
| "exif.decode_unicode_intel": "UCS-2LE", | |
| "exif.decode_unicode_motorola": "UCS-2BE", | |
| "exif.encode_jis": "no value", | |
| "exif.encode_unicode": "ISO-8859-15" | |
| }, | |
| "fileinfo": { | |
| "fileinfo support": "enabled", | |
| "libmagic": "537" | |
| }, | |
| "filter": { | |
| "Input Validation and Filtering": "enabled", | |
| "filter.default": "unsafe_raw", | |
| "filter.default_flags": "no value" | |
| }, | |
| "ftp": { | |
| "FTP support": "enabled", | |
| "FTPS support": "enabled" | |
| }, | |
| "gd": { | |
| "GD Support": "enabled", | |
| "GD Version": "bundled (2.1.0 compatible)", | |
| "FreeType Support": "enabled", | |
| "FreeType Linkage": "with freetype", | |
| "FreeType Version": "2.11.1", | |
| "GIF Read Support": "enabled", | |
| "GIF Create Support": "enabled", | |
| "JPEG Support": "enabled", | |
| "libJPEG Version": "8", | |
| "PNG Support": "enabled", | |
| "libPNG Version": "1.6.37", | |
| "WBMP Support": "enabled", | |
| "XPM Support": "enabled", | |
| "libXpm Version": "30411", | |
| "XBM Support": "enabled", | |
| "WebP Support": "enabled", | |
| "BMP Support": "enabled", | |
| "TGA Read Support": "enabled", | |
| "gd.jpeg_ignore_warning": "1" | |
| }, | |
| "gettext": { | |
| "GetText Support": "enabled" | |
| }, | |
| "gmp": { | |
| "gmp support": "enabled", | |
| "GMP version": "6.2.1" | |
| }, | |
| "hash": { | |
| "hash support": "enabled", | |
| "Hashing Engines": "md2 md4 md5 sha1 sha224 sha256 sha384 sha512\/224 sha512\/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5" | |
| }, | |
| "iconv": { | |
| "iconv support": "enabled", | |
| "iconv implementation": "glibc", | |
| "iconv library version": "2.35", | |
| "iconv.input_encoding": "no value", | |
| "iconv.internal_encoding": "no value", | |
| "iconv.output_encoding": "no value" | |
| }, | |
| "imagick": { | |
| "imagick module version": "3.7.0", | |
| "imagick classes": "Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator, ImagickKernel", | |
| "Imagick compiled with ImageMagick version": "ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https:\/\/imagemagick.org", | |
| "Imagick using ImageMagick library version": "ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https:\/\/imagemagick.org", | |
| "ImageMagick copyright": "(C) 1999-2021 ImageMagick Studio LLC", | |
| "ImageMagick release date": "2021-01-25", | |
| "ImageMagick number of supported formats:": "237", | |
| "ImageMagick supported formats": "3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV", | |
| "imagick.allow_zero_dimension_images": "0", | |
| "imagick.locale_fix": "0", | |
| "imagick.progress_monitor": "0", | |
| "imagick.set_single_thread": "1", | |
| "imagick.shutdown_sleep_count": "10", | |
| "imagick.skip_version_check": "0" | |
| }, | |
| "imap": { | |
| "IMAP c-Client Version": "2007f", | |
| "SSL Support": "enabled", | |
| "Kerberos Support": "enabled", | |
| "imap.enable_insecure_rsh": "Off" | |
| }, | |
| "intl": { | |
| "ICU version": "70.1", | |
| "ICU Data version": "70.1", | |
| "ICU TZData version": "2023c", | |
| "ICU Unicode version": "14.0", | |
| "intl.default_locale": "no value", | |
| "intl.error_level": "0", | |
| "intl.use_exceptions": "0" | |
| }, | |
| "ionCube Loader": { | |
| "ionCube Loader developed by ionCube Ltd.Visit ioncube.com forlatest Loaders andsupport.This Loader also includes features for real-time error reporting and malware protection. Visitioncube24.com for more details.": null, | |
| "Loader version": "11.0.1", | |
| "ionCube24 features": "unconfigured", | |
| "ic24.api.log_msg_errors": "0", | |
| "ic24.api.max_timeout": "7", | |
| "ic24.api_access_key": "********", | |
| "ic24.api_check_ip": "1", | |
| "ic24.enable": "0", | |
| "ic24.home_dir": "no value", | |
| "ic24.phperr.enable": "auto", | |
| "ic24.phperr.ignore": "0", | |
| "ic24.sec.block_stdin": "1", | |
| "ic24.sec.block_uploaded_files": "1", | |
| "ic24.sec.enable": "auto", | |
| "ic24.sec.exclusion_key": "********", | |
| "ic24.sec.initial_action": "block", | |
| "ic24.sec.initial_cache_all": "1", | |
| "ic24.sec.initial_notify": "always", | |
| "ic24.sec.initial_state": "1", | |
| "ic24.sec.stop_on_error": "1", | |
| "ic24.sec.trusted_include_paths": "********", | |
| "ic24.slt": "7", | |
| "ic24.update_domains_retry_interval": "30", | |
| "ioncube.loader.encoded_paths": "no value" | |
| }, | |
| "json": { | |
| "json support": "enabled" | |
| }, | |
| "ldap": { | |
| "LDAP Support": "enabled", | |
| "Total Links": "0\/unlimited", | |
| "API Version": "3001", | |
| "Vendor Name": "OpenLDAP", | |
| "Vendor Version": "20511", | |
| "SASL Support": "Enabled", | |
| "ldap.max_links": "Unlimited" | |
| }, | |
| "libxml": { | |
| "libXML support": "active", | |
| "libXML Compiled Version": "2.9.13", | |
| "libXML Loaded Version": "20913", | |
| "libXML streams": "enabled" | |
| }, | |
| "mbstring": { | |
| "Multibyte Support": "enabled", | |
| "Multibyte string engine": "libmbfl", | |
| "HTTP input encoding translation": "disabled", | |
| "libmbfl version": "1.3.2", | |
| "Multibyte (japanese) regex support": "enabled", | |
| "Multibyte regex (oniguruma) version": "6.9.7", | |
| "mbstring.detect_order": "no value", | |
| "mbstring.encoding_translation": "Off", | |
| "mbstring.func_overload": "0", | |
| "mbstring.http_input": "no value", | |
| "mbstring.http_output": "no value", | |
| "mbstring.http_output_conv_mimetypes": "^(text\/|application\/xhtml\\+xml)", | |
| "mbstring.internal_encoding": "no value", | |
| "mbstring.language": "neutral", | |
| "mbstring.regex_retry_limit": "1000000", | |
| "mbstring.regex_stack_limit": "100000", | |
| "mbstring.strict_detection": "Off", | |
| "mbstring.substitute_character": "no value" | |
| }, | |
| "mysqli": { | |
| "Client API library version": "mysqlnd 7.4.33", | |
| "Active Persistent Links": "0", | |
| "Inactive Persistent Links": "0", | |
| "Active Links": "0", | |
| "mysqli.allow_local_infile": "Off", | |
| "mysqli.allow_persistent": "On", | |
| "mysqli.default_host": "no value", | |
| "mysqli.default_port": "3306", | |
| "mysqli.default_pw": "no value", | |
| "mysqli.default_socket": "\/var\/run\/mysqld\/mysqld.sock", | |
| "mysqli.default_user": "no value", | |
| "mysqli.max_links": "Unlimited", | |
| "mysqli.max_persistent": "Unlimited", | |
| "mysqli.reconnect": "Off", | |
| "mysqli.rollback_on_cached_plink": "Off" | |
| }, | |
| "mysqlnd": { | |
| "Version": "mysqlnd 7.4.33", | |
| "Compression": "supported", | |
| "core SSL": "supported", | |
| "extended SSL": "supported", | |
| "Command buffer size": "4096", | |
| "Read buffer size": "32768", | |
| "Read timeout": "86400", | |
| "Collecting statistics": "Yes", | |
| "Collecting memory statistics": "No", | |
| "Tracing": "n\/a", | |
| "Loaded plugins": "mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password", | |
| "API Extensions": "mysqli,pdo_mysql" | |
| }, | |
| "odbc": { | |
| "Active Persistent Links": "0", | |
| "Active Links": "0", | |
| "ODBC library": "unixODBC", | |
| "ODBCVER": "0x0380", | |
| "ODBC_CFLAGS": "-I\/usr\/include", | |
| "ODBC_LFLAGS": "-L\/usr\/lib", | |
| "ODBC_LIBS": "-lodbc", | |
| "odbc.allow_persistent": "On", | |
| "odbc.check_persistent": "On", | |
| "odbc.default_cursortype": "Static cursor", | |
| "odbc.default_db": "no value", | |
| "odbc.default_pw": "no value", | |
| "odbc.default_user": "no value", | |
| "odbc.defaultbinmode": "return as is", | |
| "odbc.defaultlrl": "return up to 4096 bytes", | |
| "odbc.max_links": "Unlimited", | |
| "odbc.max_persistent": "Unlimited" | |
| }, | |
| "openssl": { | |
| "OpenSSL support": "enabled", | |
| "OpenSSL Library Version": "OpenSSL 3.0.2 15 Mar 2022", | |
| "OpenSSL Header Version": "OpenSSL 3.0.2 15 Mar 2022", | |
| "Openssl default config": "\/usr\/lib\/ssl\/openssl.cnf", | |
| "openssl.cafile": "no value", | |
| "openssl.capath": "no value" | |
| }, | |
| "pcre": { | |
| "PCRE (Perl Compatible Regular Expressions) Support": "enabled", | |
| "PCRE Library Version": "10.35 2020-05-09", | |
| "PCRE Unicode Version": "13.0.0", | |
| "PCRE JIT Support": "enabled", | |
| "PCRE JIT Target": "x86 64bit (little endian + unaligned)", | |
| "pcre.backtrack_limit": "1000000", | |
| "pcre.jit": "1", | |
| "pcre.recursion_limit": "100000" | |
| }, | |
| "PDO": { | |
| "PDO drivers": "mysql, odbc, pgsql, sqlite" | |
| }, | |
| "pdo_mysql": { | |
| "Client API version": "mysqlnd 7.4.33", | |
| "pdo_mysql.default_socket": "\/var\/run\/mysqld\/mysqld.sock" | |
| }, | |
| "PDO_ODBC": { | |
| "ODBC Connection Pooling": "Enabled, strict matching" | |
| }, | |
| "pdo_pgsql": { | |
| "PDO Driver for PostgreSQL": "enabled", | |
| "PostgreSQL(libpq) Version": "14.5 (Ubuntu 14.5-0ubuntu0.22.04.1)" | |
| }, | |
| "pdo_sqlite": { | |
| "SQLite Library": "3.37.2" | |
| }, | |
| "pgsql": { | |
| "PostgreSQL(libpq) Version": "14.5 (Ubuntu 14.5-0ubuntu0.22.04.1)", | |
| "PostgreSQL(libpq)": "PostgreSQL 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit", | |
| "Multibyte character support": "enabled", | |
| "SSL support": "enabled", | |
| "Active Persistent Links": "0", | |
| "Active Links": "0", | |
| "pgsql.allow_persistent": "On", | |
| "pgsql.auto_reset_persistent": "Off", | |
| "pgsql.ignore_notice": "Off", | |
| "pgsql.log_notice": "Off", | |
| "pgsql.max_links": "Unlimited", | |
| "pgsql.max_persistent": "Unlimited" | |
| }, | |
| "Phar": { | |
| "Phar API version": "1.1.1", | |
| "Phar-based phar archives": "enabled", | |
| "Tar-based phar archives": "enabled", | |
| "ZIP-based phar archives": "enabled", | |
| "gzip compression": "enabled", | |
| "bzip2 compression": "enabled", | |
| "Native OpenSSL support": "enabled", | |
| "Phar based on pear\/PHP_Archive, original concept by Davey Shafik.Phar fully realized by Gregory Beaver and Marcus Boerger.Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.": null, | |
| "phar.cache_list": "no value", | |
| "phar.readonly": "On", | |
| "phar.require_hash": "On" | |
| }, | |
| "posix": { | |
| "POSIX support": "enabled" | |
| }, | |
| "pspell": { | |
| "PSpell Support": "enabled" | |
| }, | |
| "redis": { | |
| "Redis Version": "5.3.7", | |
| "Redis Sentinel Version": "0.1", | |
| "Available serializers": "php, json", | |
| "redis.arrays.algorithm": "no value", | |
| "redis.arrays.auth": "no value", | |
| "redis.arrays.autorehash": "0", | |
| "redis.arrays.connecttimeout": "0", | |
| "redis.arrays.consistent": "0", | |
| "redis.arrays.distributor": "no value", | |
| "redis.arrays.functions": "no value", | |
| "redis.arrays.hosts": "no value", | |
| "redis.arrays.index": "0", | |
| "redis.arrays.lazyconnect": "0", | |
| "redis.arrays.names": "no value", | |
| "redis.arrays.pconnect": "0", | |
| "redis.arrays.previous": "no value", | |
| "redis.arrays.readtimeout": "0", | |
| "redis.arrays.retryinterval": "0", | |
| "redis.clusters.auth": "no value", | |
| "redis.clusters.cache_slots": "0", | |
| "redis.clusters.persistent": "0", | |
| "redis.clusters.read_timeout": "0", | |
| "redis.clusters.seeds": "no value", | |
| "redis.clusters.timeout": "0", | |
| "redis.pconnect.connection_limit": "0", | |
| "redis.pconnect.echo_check_liveness": "1", | |
| "redis.pconnect.pool_detect_dirty": "0", | |
| "redis.pconnect.pool_pattern": "no value", | |
| "redis.pconnect.pool_poll_timeout": "0", | |
| "redis.pconnect.pooling_enabled": "1", | |
| "redis.session.lock_expire": "0", | |
| "redis.session.lock_retries": "10", | |
| "redis.session.lock_wait_time": "2000", | |
| "redis.session.locking_enabled": "0" | |
| }, | |
| "Reflection": { | |
| "Reflection": "enabled" | |
| }, | |
| "session": { | |
| "Session Support": "enabled", | |
| "Registered save handlers": "files user redis rediscluster", | |
| "Registered serializer handlers": "php_serialize php php_binary", | |
| "session.auto_start": "Off", | |
| "session.cache_expire": "180", | |
| "session.cache_limiter": "nocache", | |
| "session.cookie_domain": "no value", | |
| "session.cookie_httponly": [ | |
| "1", | |
| "no value" | |
| ], | |
| "session.cookie_lifetime": "0", | |
| "session.cookie_path": "\/", | |
| "session.cookie_samesite": [ | |
| "Strict", | |
| "no value" | |
| ], | |
| "session.cookie_secure": [ | |
| "1", | |
| "0" | |
| ], | |
| "session.gc_divisor": "1000", | |
| "session.gc_maxlifetime": [ | |
| "1200", | |
| "1440" | |
| ], | |
| "session.gc_probability": "0", | |
| "session.lazy_write": "On", | |
| "session.name": [ | |
| "ocpe6oh997hw", | |
| "PHPSESSID" | |
| ], | |
| "session.referer_check": "no value", | |
| "session.save_handler": "files", | |
| "session.save_path": "\/var\/lib\/php\/sessions", | |
| "session.serialize_handler": "php", | |
| "session.sid_bits_per_character": "5", | |
| "session.sid_length": "26", | |
| "session.upload_progress.cleanup": "On", | |
| "session.upload_progress.enabled": "On", | |
| "session.upload_progress.freq": "1%", | |
| "session.upload_progress.min_freq": "1", | |
| "session.upload_progress.name": "PHP_SESSION_UPLOAD_PROGRESS", | |
| "session.upload_progress.prefix": "upload_progress_", | |
| "session.use_cookies": "1", | |
| "session.use_only_cookies": "1", | |
| "session.use_strict_mode": "0", | |
| "session.use_trans_sid": "0" | |
| }, | |
| "SimpleXML": { | |
| "SimpleXML support": "enabled", | |
| "Schema support": "enabled" | |
| }, | |
| "soap": { | |
| "Soap Client": "enabled", | |
| "Soap Server": "enabled", | |
| "soap.wsdl_cache": "1", | |
| "soap.wsdl_cache_dir": "\/tmp", | |
| "soap.wsdl_cache_enabled": "1", | |
| "soap.wsdl_cache_limit": "5", | |
| "soap.wsdl_cache_ttl": "86400" | |
| }, | |
| "sockets": { | |
| "Sockets Support": "enabled" | |
| }, | |
| "sodium": { | |
| "libsodium headers version": "1.0.18", | |
| "libsodium library version": "1.0.18" | |
| }, | |
| "SPL": { | |
| "Interfaces": "OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject", | |
| "Classes": "AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException" | |
| }, | |
| "sqlite3": { | |
| "SQLite Library": "3.37.2", | |
| "sqlite3.defensive": "1", | |
| "sqlite3.extension_dir": "no value" | |
| }, | |
| "standard": { | |
| "Dynamic Library Support": "enabled", | |
| "Path to sendmail": "\/usr\/sbin\/sendmail -t -i", | |
| "assert.active": "1", | |
| "assert.bail": "0", | |
| "assert.callback": "no value", | |
| "assert.exception": "0", | |
| "assert.quiet_eval": "0", | |
| "assert.warning": "1", | |
| "auto_detect_line_endings": "0", | |
| "default_socket_timeout": "60", | |
| "from": "no value", | |
| "session.trans_sid_hosts": "no value", | |
| "session.trans_sid_tags": "a=href,area=href,frame=src,form=", | |
| "unserialize_max_depth": "4096", | |
| "url_rewriter.hosts": "no value", | |
| "url_rewriter.tags": "form=", | |
| "user_agent": "no value" | |
| }, | |
| "sysvmsg": { | |
| "sysvmsg support": "enabled" | |
| }, | |
| "sysvsem": { | |
| "sysvsem support": "enabled" | |
| }, | |
| "sysvshm": { | |
| "sysvshm support": "enabled" | |
| }, | |
| "tidy": { | |
| "Tidy support": "enabled", | |
| "libTidy Version": "5.6.0", | |
| "libTidy Release": "2017\/11\/25", | |
| "tidy.clean_output": "no value", | |
| "tidy.default_config": "no value" | |
| }, | |
| "tokenizer": { | |
| "Tokenizer Support": "enabled" | |
| }, | |
| "xml": { | |
| "XML Support": "active", | |
| "XML Namespace Support": "active", | |
| "libxml2 Version": "2.9.13" | |
| }, | |
| "xmlreader": { | |
| "XMLReader": "enabled" | |
| }, | |
| "xmlrpc": { | |
| "core library version": "xmlrpc-epi v. 0.51", | |
| "author": "Dan Libby", | |
| "homepage": "http:\/\/xmlrpc-epi.sourceforge.net", | |
| "open sourced by": "Epinions.com" | |
| }, | |
| "xmlwriter": { | |
| "XMLWriter": "enabled" | |
| }, | |
| "xsl": { | |
| "XSL": "enabled", | |
| "libxslt Version": "1.1.34", | |
| "libxslt compiled against libxml Version": "2.9.13", | |
| "EXSLT": "enabled", | |
| "libexslt Version": "1.1.34" | |
| }, | |
| "Zend OPcache": { | |
| "Opcode Caching": "Up and Running", | |
| "Optimization": "Enabled", | |
| "SHM Cache": "Enabled", | |
| "File Cache": "Disabled", | |
| "Startup": "OK", | |
| "Shared memory model": "mmap", | |
| "Cache hits": "21253737", | |
| "Cache misses": "1214", | |
| "Used memory": "27455088", | |
| "Free memory": "106762640", | |
| "Wasted memory": "0", | |
| "Interned Strings Used memory": "3359488", | |
| "Interned Strings Free memory": "2931520", | |
| "Cached scripts": "1214", | |
| "Cached keys": "1214", | |
| "Max keys": "16229", | |
| "OOM restarts": "0", | |
| "Hash keys restarts": "0", | |
| "Manual restarts": "0", | |
| "opcache.blacklist_filename": "no value", | |
| "opcache.consistency_checks": "0", | |
| "opcache.dups_fix": "Off", | |
| "opcache.enable": "On", | |
| "opcache.enable_cli": "Off", | |
| "opcache.enable_file_override": "Off", | |
| "opcache.error_log": "no value", | |
| "opcache.file_cache": "no value", | |
| "opcache.file_cache_consistency_checks": "On", | |
| "opcache.file_cache_only": "Off", | |
| "opcache.file_update_protection": "2", | |
| "opcache.force_restart_timeout": "180", | |
| "opcache.huge_code_pages": "Off", | |
| "opcache.interned_strings_buffer": "8", | |
| "opcache.lockfile_path": "\/tmp", | |
| "opcache.log_verbosity_level": "1", | |
| "opcache.max_accelerated_files": "10000", | |
| "opcache.max_file_size": "0", | |
| "opcache.max_wasted_percentage": "10", | |
| "opcache.memory_consumption": "128", | |
| "opcache.opt_debug_level": "0", | |
| "opcache.optimization_level": "0x7FFEBFFF", | |
| "opcache.preferred_memory_model": "no value", | |
| "opcache.preload": "no value", | |
| "opcache.preload_user": "no value", | |
| "opcache.protect_memory": "Off", | |
| "opcache.restrict_api": "no value", | |
| "opcache.revalidate_freq": "2", | |
| "opcache.revalidate_path": "On", | |
| "opcache.save_comments": "On", | |
| "opcache.use_cwd": "On", | |
| "opcache.validate_permission": "On", | |
| "opcache.validate_root": "Off", | |
| "opcache.validate_timestamps": "On" | |
| }, | |
| "zip": { | |
| "Zip": "enabled", | |
| "Zip version": "1.15.6", | |
| "Libzip headers version": "1.7.3", | |
| "Libzip library version": "1.7.3" | |
| }, | |
| "zlib": { | |
| "Stream Wrapper": "compress.zlib:\/\/", | |
| "Stream Filter": "zlib.inflate, zlib.deflate", | |
| "Compiled Version": "1.2.11", | |
| "Linked Version": "1.2.11", | |
| "zlib.output_compression": "Off", | |
| "zlib.output_compression_level": "-1", | |
| "zlib.output_handler": "no value" | |
| }, | |
| "Environment": { | |
| "USER": "***REMOVED SENSITIVE VALUE***", | |
| "HOME": "\/var\/www\/vhosts\/***REMOVED SENSITIVE VALUE***" | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment