{ "basic": { "license key": "***REMOVED SENSITIVE VALUE***", "date": "Thu, 12 Nov 2020 18:52:38 +0000", "ownCloud version": "10.5.0.10", "ownCloud version string": "10.5.0", "ownCloud edition": "Community", "server OS": "Linux", "server OS version": "Linux localhost.localdomain 4.18.0-193.28.1.el8_2.x86_64 #1 SMP Thu Oct 22 00:20:22 UTC 2020 x86_64", "server SAPI": "cli", "webserver version": null, "hostname": null, "logged-in user": false }, "stats": { "users": { "Database": { "count": 1, "seen": 1, "logged in (30 days)": 1 } }, "groups": { "OC\\Group\\Database": 1 } }, "config": { "instanceid": "ocgzvkircuku", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "example.com" ], "datadirectory": "\/Data", "overwrite.cli.url": "https:\/\/example.com", "htaccess.RewriteBase": "\/", "enable_previews": "off", "dbtype": "mysql", "version": "10.5.0.10", "dbname": "owncloud", "dbhost": "localhost", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "UTC", "apps_paths": [ { "path": "\/var\/www\/VH\/example.com\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/VH\/example.com\/apps-external", "url": "\/apps-external", "writable": true } ], "installed": true, "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpauth": 1, "mail_smtpauthtype": "LOGIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpsecure": "ssl", "mail_smtpport": "465", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***" }, "integritychecker": { "passing": true, "enabled": true, "result": [] }, "core": { "allow_user_mount_sharing": "no", "enable_external_storage": "yes", "first_install_version": "10.5.0.10", "grace_period": "1605171187", "installedat": "1604879324.8813", "lastcron": "1605207049", "lastupdateResult": "[]", "lastupdatedat": "1605207003", "public_files": "files_sharing\/public.php", "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php" }, "apps": [ { "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.3", "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, "level": 100, "removable": true, "internal": false, "appconfig": { "enabled": "yes", "installed_version": "1.0.3", "types": "" } }, { "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": true, "level": 100, "removable": true, "internal": false, "appconfig": { "enabled": "yes", "installed_version": "0.3.0", "types": "logging" } }, { "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, "level": 100, "removable": true, "internal": false, "preview": "\/apps\/external\/img\/external.svg", "previewAsIcon": true }, { "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": true, "internal": true, "level": 200, "removable": false, "preview": "\/apps\/federation\/img\/app.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "0.1.0", "types": "authentication" } }, { "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": true, "level": 100, "removable": true, "internal": false, "preview": "\/apps\/firstrunwizard\/img\/app.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "1.2.0", "types": "" } }, { "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": true, "level": 100, "removable": true, "internal": false, "appconfig": { "enabled": "yes", "installed_version": "0.3.0", "types": "logging,dav" } }, { "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.org\/server\/10.5\/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": { "enabled": "yes", "installed_version": "0.9.1", "types": "filesystem" } }, { "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.org\/server\/10.5\/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": true, "internal": true, "level": 200, "removable": false, "preview": "\/apps\/provisioning_api\/img\/app.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "0.5.0", "types": "prevent_group_restriction" } }, { "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.13.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", "installed_version": "0.13.0", "types": "filesystem" } }, { "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.org\/server\/10.5\/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": "configreport", "name": "Admin Config Report", "description": "Generate a Config Report", "licence": "AGPL", "author": "owncloud.org", "version": "0.2.0", "namespace": "ConfigReport", "default_enable": [ "", "" ], "types": [ "filesystem" ], "dependencies": { "owncloud": { "@attributes": { "min-version": "10.2", "max-version": "11" } } }, "commands": { "command": "OCA\\ConfigReport\\Command\\ConfigReport" }, "settings": { "admin": "OCA\\ConfigReport\\AdminPanel" }, "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.0", "types": "filesystem" } }, { "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.2", "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": { "command": "OCA\\Notifications\\Command\\Generate" }, "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, "level": 100, "removable": true, "internal": false, "preview": "\/apps\/notifications\/img\/notifications.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "0.5.2", "types": "logging" } }, { "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.6.0", "default_enable": "", "category": "tools", "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/market\/ownCloud-market-app.jpg", "dependencies": { "owncloud": { "@attributes": { "min-version": "10.5", "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, "level": 100, "removable": true, "internal": false, "preview": "\/apps\/market\/img\/market.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "0.6.0", "types": "" } }, { "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.org\/server\/10.5\/go.php?to=user-encryption", "admin": "https:\/\/doc.owncloud.org\/server\/10.5\/go.php?to=admin-encryption" }, "rememberlogin": "false", "version": "1.4.0", "category": "security", "types": [ "filesystem" ], "use-migrations": "true", "dependencies": { "lib": "openssl", "owncloud": { "@attributes": { "min-version": "10.2", "max-version": "11.0" } } }, "commands": [ "OCA\\Encryption\\Command\\SelectEncryptionType", "OCA\\Encryption\\Command\\RecreateMasterKey", "OCA\\Encryption\\Command\\MigrateKeys", "OCA\\Encryption\\Command\\HSMDaemon", "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": "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": { "enabled": "yes", "installed_version": "0.2.1", "types": "" } }, { "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, "level": 100, "removable": true, "internal": false, "preview": "\/apps\/user_external\/img\/app.svg", "previewAsIcon": true }, { "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.0", "documentation": { "admin": "https:\/\/doc.owncloud.org\/server\/latest\/admin_manual\/issues\/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.0.4", "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, "level": 100, "removable": true, "internal": false, "preview": "\/apps-external\/impersonate\/img\/app.svg", "previewAsIcon": true, "appconfig": { "enabled": "yes", "installed_version": "0.5.0", "signed": "true", "types": "" } } ], "mounts": [ { "id": 7, "mount_point": "\/SMB", "storage": "SMB \/ CIFS", "authentication_type": "Username and password", "configuration": { "domain": "CMI.local", "host": "192.168.1.211", "password": "***REMOVED SENSITIVE VALUE***", "root": "", "share": "Data", "user": "mauro.fossati" }, "options": { "enable_sharing": false, "encoding_compatibility": false, "encrypt": true, "filesystem_check_changes": 1, "previews": false, "read_only": false }, "applicable_users": "All", "applicable_groups": "", "type": "Admin" } ], "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": "account_id_index", "columns": [ "account_id" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true }, { "indexName": "term_index", "columns": [ "term" ], "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": "display_name_index", "columns": [ "display_name" ], "unique": false }, { "indexName": "email_index", "columns": [ "email" ], "unique": false }, { "indexName": "lower_user_id_index", "columns": [ "lower_user_id" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true }, { "indexName": "UNIQ_907AA303A76ED395", "columns": [ "user_id" ], "unique": true } ], "0": { "primaryColumns": [ "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": "addressbookid_synctoken", "columns": [ "addressbookid", "synctoken" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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": "addressbook_index", "columns": [ "principaluri", "uri" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "0": { "primaryColumns": [ "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_appid_key", "columns": [ "appid" ], "unique": false }, { "indexName": "appconfig_config_key_index", "columns": [ "configkey" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "appid", "configkey" ], "unique": true } ], "0": { "primaryColumns": [ "appid", "configkey" ] } }, "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": "authtoken_token_index", "columns": [ "token" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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": "calendarid_synctoken", "columns": [ "calendarid", "synctoken" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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": "calobjects_index", "columns": [ "calendarid", "uri" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "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": "calendars_index", "columns": [ "principaluri", "uri" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "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": "calsub_index", "columns": [ "principaluri", "uri" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "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": "addressbookid_uri_index", "columns": [ "addressbookid", "uri" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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_contactid_index", "columns": [ "cardid" ], "unique": false }, { "indexName": "card_name_index", "columns": [ "name" ], "unique": false }, { "indexName": "card_value_index", "columns": [ "value" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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_actor_index", "columns": [ "actor_type", "actor_id" ], "unique": false }, { "indexName": "comments_object_index", "columns": [ "object_type", "object_id", "creation_timestamp" ], "unique": false }, { "indexName": "comments_parent_id_index", "columns": [ "parent_id" ], "unique": false }, { "indexName": "comments_topmost_parent_id_idx", "columns": [ "topmost_parent_id" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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_index", "columns": [ "user_id", "object_type", "object_id" ], "unique": true }, { "indexName": "comments_marker_object_index", "columns": [ "object_type", "object_id" ], "unique": false } ], "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": "dav_shares_index", "columns": [ "principaluri", "resourceid", "type", "publicuri" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "0": { "primaryColumns": [ "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_mount", "columns": [ "mount_id" ], "unique": false }, { "indexName": "applicable_type_value", "columns": [ "type", "value" ], "unique": false }, { "indexName": "applicable_type_value_mount", "columns": [ "type", "value", "mount_id" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "applicable_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": "config_mount_key", "columns": [ "mount_id", "key" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "config_id" ], "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": "option_mount_key", "columns": [ "mount_id", "key" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "option_id" ], "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_key_index", "columns": [ "key" ], "unique": true }, { "indexName": "lock_ttl_index", "columns": [ "ttl" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "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_parent_name_hash", "columns": [ "parent", "name" ], "unique": false }, { "indexName": "fs_storage_mimepart", "columns": [ "storage", "mimepart" ], "unique": false }, { "indexName": "fs_storage_mimetype", "columns": [ "storage", "mimetype" ], "unique": false }, { "indexName": "fs_storage_path_hash", "columns": [ "storage", "path_hash" ], "unique": true }, { "indexName": "fs_storage_size", "columns": [ "storage", "size", "fileid" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "fileid" ], "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": "id_index", "columns": [ "id" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "auto_id" ], "unique": true }, { "indexName": "timestamp_index", "columns": [ "timestamp" ], "unique": false }, { "indexName": "user_index", "columns": [ "user" ], "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": "job_class_index", "columns": [ "class" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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": "mimetype_id_index", "columns": [ "mimetype" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "id" ], "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_storage_index", "columns": [ "storage_id" ], "unique": false }, { "indexName": "mounts_user_index", "columns": [ "user_id" ], "unique": false }, { "indexName": "mounts_user_root_index", "columns": [ "user_id", "root_id" ], "unique": true }, { "indexName": "PRIMARY", "columns": [ "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": null, "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 } }, { "actions": { "type": "text", "null": true, "default": null, "autoIncrement": false } }, { "icon": { "type": "string", "null": true, "default": null, "autoIncrement": false } } ], "index": [ { "indexName": "IDX_16B8074811CB6B3A232D562B", "columns": [ "object_type", "object_id" ], "unique": false }, { "indexName": "IDX_16B807488D93D649", "columns": [ "user" ], "unique": false }, { "indexName": "IDX_16B80748A5D6E63E", "columns": [ "timestamp" ], "unique": false }, { "indexName": "IDX_16B80748C96E70CF", "columns": [ "app" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "notification_id" ], "unique": true } ], "0": { "primaryColumns": [ "notification_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 } }, { "fileid": { "type": "bigint", "null": false, "default": null, "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": "fileid_index", "columns": [ "fileid" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "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 } }, { "uid_initiator": { "type": "string", "null": true, "default": null, "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 } }, { "share_name": { "type": "string", "null": true, "default": null, "autoIncrement": false } }, { "attributes": { "type": "text", "null": true, "default": null, "autoIncrement": false } } ], "index": [ { "indexName": "file_source_index", "columns": [ "file_source" ], "unique": false }, { "indexName": "item_share_type_index", "columns": [ "item_type", "share_type" ], "unique": false }, { "indexName": "item_source_index", "columns": [ "item_source" ], "unique": false }, { "indexName": "item_source_type_index", "columns": [ "item_source", "share_type", "item_type" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true }, { "indexName": "share_with_index", "columns": [ "share_with" ], "unique": false }, { "indexName": "token_index", "columns": [ "token" ], "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": "PRIMARY", "columns": [ "id" ], "unique": true }, { "indexName": "sh_external_mp", "columns": [ "user", "mountpoint_hash" ], "unique": true }, { "indexName": "sh_external_user", "columns": [ "user" ], "unique": false } ], "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": "smallint", "null": false, "default": "1", "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_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": "category_index", "columns": [ "category" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true }, { "indexName": "type_index", "columns": [ "type" ], "unique": false }, { "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": "PRIMARY", "columns": [ "categoryid", "objid", "type" ], "unique": true }, { "indexName": "vcategory_objectd_index", "columns": [ "objid", "type" ], "unique": false } ], "0": { "primaryColumns": [ "categoryid", "objid", "type" ] } }, "oc_wnd_nqueue": { "fields": [ { "id": { "type": "integer", "null": false, "default": null, "autoIncrement": true } }, { "notification_hash": { "type": "string", "null": false, "default": null, "autoIncrement": false } }, { "action": { "type": "string", "null": false, "default": null, "autoIncrement": false } }, { "target_server": { "type": "string", "null": false, "default": null, "autoIncrement": false } }, { "target_share": { "type": "string", "null": false, "default": null, "autoIncrement": false } }, { "parameters": { "type": "string", "null": false, "default": null, "autoIncrement": false } }, { "timestamp": { "type": "float", "null": false, "default": null, "autoIncrement": false } } ], "index": [ { "indexName": "nqueue_hash_index", "columns": [ "notification_hash" ], "unique": true }, { "indexName": "nqueue_timestamp_index", "columns": [ "timestamp" ], "unique": false }, { "indexName": "PRIMARY", "columns": [ "id" ], "unique": true } ], "0": { "primaryColumns": [ "id" ] } } } }, "migrations": [ { "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": "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": "federatedfilesharing", "version": "20170804201125" }, { "app": "federatedfilesharing", "version": "20170804201253" }, { "app": "federatedfilesharing", "version": "20190410160725" }, { "app": "files_external", "version": "20170814051424" }, { "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_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": "windows_network_drive", "version": "20191029123324" } ], "phpinfo": [] }