VtUJR61Y

1{
2    "basic": {
3        "license key": "***REMOVED SENSITIVE VALUE***",
4        "date": "Sat, 28 Mar 2020 23:47:43 +0000",
5        "ownCloud version": "10.4.0.4",
6        "ownCloud version string": "10.4.0",
7        "ownCloud edition": "Community",
8        "server OS": "Linux",
9        "server OS version": "Linux blacky 5.4.28-sunxi #20.02.7 SMP Sat Mar 28 14:32:15 CET 2020 armv7l",
10        "server SAPI": "apache2handler",
11        "webserver version": "Apache\/2.4.38 (Debian)",
12        "hostname": "***REMOVED SENSITIVE VALUE***",
13        "logged-in user": "me"
14    },
15    "stats": {
16        "users": {
17            "Database": {
18                "count": 2,
19                "seen": 2,
20                "logged in (30 days)": 2
21            }
22        },
23        "groups": {
24            "OC\\Group\\Database": 1
25        }
26    },
27    "config": {
28        "instanceid": "***REMOVED SENSITIVE VALUE***",
29        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
30        "trusted_domains": [
31            "***REMOVED SENSITIVE VALUE***",
32            "***REMOVED SENSITIVE VALUE***"
33        ],
34        "datadirectory": "***REMOVED SENSITIVE VALUE***",
35        "version": "10.4.0.4",
36        "dbtype": "mysql",
37        "dbhost": "localhost",
38        "dbname": "owncloud",
39        "dbuser": "***REMOVED SENSITIVE VALUE***",
40        "dbpassword": "***REMOVED SENSITIVE VALUE***",
41        "dbtableprefix": "oc_",
42        "installed": true,
43        "default_language": "en_GB",
44        "defaultapp": "files",
45        "knowledgebaseenabled": true,
46        "enable_avatars": true,
47        "allow_user_to_change_display_name": true,
48        "session_keepalive": true,
49        "token_auth_enforced": true,
50        "mail_domain": "***REMOVED SENSITIVE VALUE***",
51        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
52        "mail_smtpdebug": false,
53        "mail_smtpmode": "smtp",
54        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
55        "mail_smtpsecure": "tls",
56        "mail_smtpauth": true,
57        "mail_smtpauthtype": "LOGIN",
58        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
59        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
60        "overwriteprotocol": "https",
61        "overwrite.cli.url": "https:\/\"***REMOVED SENSITIVE VALUE***\/owncloud",
62        "htaccess.RewriteBase": "\/owncloud",
63        "operation.mode": "single-instance",
64        "log_type": "owncloud",
65        "loglevel": 2,
66        "logtimezone": "Europe\/Berlin",
67        "enable_previews": true,
68        "maintenance": false,
69        "singleuser": false,
70        "tempdirectory": "***REMOVED SENSITIVE VALUE***",
71        "cipher": "AES-256-CFB",
72        "secret": "***REMOVED SENSITIVE VALUE***",
73        "theme": ""
74    },
75    "integritychecker": {
76        "passing": true,
77        "enabled": true,
78        "result": []
79    },
80    "core": {
81        "backgroundjobs_mode": "cron",
82        "enable_external_storage": "no",
83        "global_cache_gc_lastrun": "1447241986",
84        "installedat": "1413637683.4351",
85        "lastcron": "1585439104",
86        "lastupdateResult": "[]",
87        "lastupdatedat": "1585437530",
88        "public_caldav": "calendar\/share.php",
89        "public_calendar": "calendar\/share.php",
90        "public_documents": "documents\/public.php",
91        "public_files": "files_sharing\/public.php",
92        "public_gallery": "gallery\/public.php",
93        "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
94        "remote_caldav": "dav\/appinfo\/v1\/caldav.php",
95        "remote_calendar": "dav\/appinfo\/v1\/caldav.php",
96        "remote_carddav": "dav\/appinfo\/v1\/carddav.php",
97        "remote_contacts": "dav\/appinfo\/v1\/carddav.php",
98        "remote_dav": "dav\/appinfo\/v2\/remote.php",
99        "remote_files": "dav\/appinfo\/v1\/webdav.php",
100        "remote_filesync": "files\/appinfo\/filesync.php",
101        "remote_mozilla_sync": "mozilla_sync\/appinfo\/remote.php",
102        "remote_webdav": "dav\/appinfo\/v1\/webdav.php",
103        "repairlegacystoragesdone": "yes",
104        "shareapi_allow_public_notification": "yes",
105        "shareapi_allow_social_share": "yes",
106        "shareapi_default_expire_date": "no",
107        "updater.secret.created": "***REMOVED SENSITIVE VALUE***",
108        "vendor": "owncloud"
109    },
110    "apps": [
111        {
112            "id": "comments",
113            "name": "Comments",
114            "description": "Files app plugin to add comments to files",
115            "licence": "AGPL",
116            "author": "Arthur Schiwon, Vincent Petry",
117            "default_enable": "",
118            "version": "0.3.0",
119            "dependencies": {
120                "owncloud": {
121                    "@attributes": {
122                        "min-version": "10",
123                        "max-version": "10"
124                    }
125                }
126            },
127            "types": [
128                "logging",
129                "dav"
130            ],
131            "sabre": {
132                "plugins": {
133                    "plugin": "OCA\\Comments\\Dav\\CommentsPlugin"
134                },
135                "collections": {
136                    "collection": "OCA\\Comments\\Dav\\RootCollection"
137                }
138            },
139            "info": [],
140            "remote": [],
141            "public": [],
142            "repair-steps": {
143                "install": [],
144                "pre-migration": [],
145                "post-migration": [],
146                "live-migration": [],
147                "uninstall": []
148            },
149            "background-jobs": [],
150            "two-factor-providers": [],
151            "commands": [],
152            "_cached": true,
153            "groups": null,
154            "active": true,
155            "level": 100,
156            "removable": true,
157            "internal": false,
158            "appconfig": {
159                "enabled": "yes",
160                "installed_version": "0.3.0",
161                "types": "logging"
162            }
163        },
164        {
165            "id": "encryption",
166            "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.",
167            "name": "Default encryption module",
168            "licence": "AGPL",
169            "author": "Bjoern Schiessle, Clark Tomlinson",
170            "documentation": {
171                "user": "https:\/\/doc.owncloud.org\/server\/10.4\/go.php?to=user-encryption",
172                "admin": "https:\/\/doc.owncloud.org\/server\/10.4\/go.php?to=admin-encryption"
173            },
174            "rememberlogin": "false",
175            "version": "1.4.0",
176            "category": "security",
177            "types": [
178                "filesystem"
179            ],
180            "use-migrations": "true",
181            "dependencies": {
182                "lib": "openssl",
183                "owncloud": {
184                    "@attributes": {
185                        "min-version": "10.2",
186                        "max-version": "11.0"
187                    }
188                }
189            },
190            "commands": [
191                "OCA\\Encryption\\Command\\SelectEncryptionType",
192                "OCA\\Encryption\\Command\\RecreateMasterKey",
193                "OCA\\Encryption\\Command\\MigrateKeys",
194                "OCA\\Encryption\\Command\\HSMDaemon",
195                "OCA\\Encryption\\Command\\FixEncryptedVersion"
196            ],
197            "settings": {
198                "admin": "OCA\\Encryption\\Panels\\Admin",
199                "personal": "OCA\\Encryption\\Panels\\Personal"
200            },
201            "info": [],
202            "remote": [],
203            "public": [],
204            "repair-steps": {
205                "install": [],
206                "pre-migration": [],
207                "post-migration": [],
208                "live-migration": [],
209                "uninstall": []
210            },
211            "background-jobs": [],
212            "two-factor-providers": [],
213            "_cached": true,
214            "groups": null,
215            "active": false,
216            "internal": true,
217            "level": 200,
218            "removable": false,
219            "preview": "\/owncloud\/apps\/encryption\/img\/app.svg",
220            "previewAsIcon": true
221        },
222        {
223            "id": "updatenotification",
224            "name": "Update notification",
225            "description": "Displays update notifications for ownCloud and provides the SSO for the updater.",
226            "licence": "AGPL",
227            "author": "Lukas Reschke",
228            "version": "0.2.1",
229            "namespace": "UpdateNotification",
230            "default_enable": "",
231            "dependencies": {
232                "owncloud": {
233                    "@attributes": {
234                        "min-version": "10",
235                        "max-version": "10"
236                    }
237                }
238            },
239            "background-jobs": {
240                "job": "OCA\\UpdateNotification\\Notification\\BackgroundJob"
241            },
242            "settings": {
243                "admin": "OCA\\UpdateNotification\\Controller\\AdminController"
244            },
245            "info": [],
246            "remote": [],
247            "public": [],
248            "types": [],
249            "repair-steps": {
250                "install": [],
251                "pre-migration": [],
252                "post-migration": [],
253                "live-migration": [],
254                "uninstall": []
255            },
256            "two-factor-providers": [],
257            "commands": [],
258            "_cached": true,
259            "groups": null,
260            "active": true,
261            "internal": true,
262            "level": 200,
263            "removable": false,
264            "appconfig": {
265                "core": "10.4.0",
266                "enabled": "yes",
267                "installed_version": "0.2.1",
268                "types": ""
269            }
270        },
271        {
272            "id": "market",
273            "name": "Market",
274            "summary": "Integrate the ownCloud marketplace into your ownCloud",
275            "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)",
276            "licence": "AGPL",
277            "author": "Thomas M\u00fcller, Felix Heidecke, Thomas B\u00f6rger, Philipp Schaffrath, Viktar Dubiniuk",
278            "version": "0.5.0",
279            "default_enable": "",
280            "category": "tools",
281            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/market\/ownCloud-market-app.jpg",
282            "dependencies": {
283                "owncloud": {
284                    "@attributes": {
285                        "min-version": "10.2",
286                        "max-version": "10"
287                    }
288                }
289            },
290            "background-jobs": {
291                "job": "OCA\\Market\\CheckUpdateBackgroundJob"
292            },
293            "commands": [
294                "OCA\\Market\\Command\\InstallApp",
295                "OCA\\Market\\Command\\UnInstallApp",
296                "OCA\\Market\\Command\\ListApps",
297                "OCA\\Market\\Command\\UpgradeApp"
298            ],
299            "navigation": {
300                "@attributes": {
301                    "role": "admin"
302                },
303                "route": "market.page.index",
304                "order": "100"
305            },
306            "info": [],
307            "remote": [],
308            "public": [],
309            "types": [],
310            "repair-steps": {
311                "install": [],
312                "pre-migration": [],
313                "post-migration": [],
314                "live-migration": [],
315                "uninstall": []
316            },
317            "two-factor-providers": [],
318            "_cached": true,
319            "groups": null,
320            "active": true,
321            "level": 100,
322            "removable": true,
323            "internal": false,
324            "preview": "\/owncloud\/apps\/market\/img\/market.svg",
325            "previewAsIcon": true,
326            "appconfig": {
327                "activity": "2.4.2",
328                "calendar": "1.6.4",
329                "contacts": "1.5.5",
330                "enabled": "yes",
331                "files_mediaviewer": "1.0.2",
332                "files_pdfviewer": "0.11.1",
333                "files_texteditor": "2.3.0",
334                "gallery": "16.1.1",
335                "installed_version": "0.5.0",
336                "key": null,
337                "market": "0.4.0",
338                "security": "0.0.3",
339                "signed": "true",
340                "tasks": "0.9.7",
341                "types": ""
342            }
343        },
344        {
345            "id": "federation",
346            "name": "Federation",
347            "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.",
348            "licence": "AGPL",
349            "author": "Bjoern Schiessle",
350            "version": "0.1.0",
351            "namespace": "Federation",
352            "category": "other",
353            "dependencies": {
354                "owncloud": {
355                    "@attributes": {
356                        "min-version": "10",
357                        "max-version": "10"
358                    }
359                }
360            },
361            "default_enable": "",
362            "types": [
363                "authentication"
364            ],
365            "background-jobs": {
366                "job": "OCA\\Federation\\SyncJob"
367            },
368            "commands": {
369                "command": "OCA\\Federation\\Command\\SyncFederationAddressBooks"
370            },
371            "settings": {
372                "admin": "OCA\\Federation\\Panels\\Admin"
373            },
374            "info": [],
375            "remote": [],
376            "public": [],
377            "repair-steps": {
378                "install": [],
379                "pre-migration": [],
380                "post-migration": [],
381                "live-migration": [],
382                "uninstall": []
383            },
384            "two-factor-providers": [],
385            "_cached": true,
386            "groups": null,
387            "active": true,
388            "internal": true,
389            "level": 200,
390            "removable": false,
391            "preview": "\/owncloud\/apps\/federation\/img\/app.svg",
392            "previewAsIcon": true,
393            "appconfig": {
394                "enabled": "yes",
395                "installed_version": "0.1.0",
396                "types": "authentication"
397            }
398        },
399        {
400            "id": "calendar",
401            "name": "Calendar",
402            "summary": "A Calendar app for ownCloud",
403            "description": "The Calendar app is a user interface for ownCloud's CalDAV server. Easily sync events from various devices with your ownCloud and edit them online.\n\n* **Integration with other ownCloud apps!** Currently Contacts - more to come. * **WebCal Support!** Want to see your favorite team\u2019s matchdays in your calendar? No problem! * **Attendees!** Invite people to your events.",
404            "version": "1.6.4",
405            "licence": "AGPL",
406            "author": "Georg Ehrke, Raghu Nayyar, Bernhard Fr\u00f6hler, Julian M\u00fcller",
407            "dependencies": {
408                "owncloud": {
409                    "@attributes": {
410                        "min-version": "9.1",
411                        "max-version": "10"
412                    }
413                }
414            },
415            "documentation": {
416                "user": "https:\/\/doc.owncloud.org\/server\/10.0\/user_manual\/pim\/calendar.html"
417            },
418            "category": "productivity",
419            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/calendar\/screenshot.png",
420            "website": "https:\/\/github.com\/owncloud\/calendar\/",
421            "bugs": "https:\/\/github.com\/owncloud\/calendar\/issues",
422            "repository": {
423                "@attributes": {
424                    "type": "git"
425                },
426                "@value": "https:\/\/github.com\/owncloud\/calendar.git"
427            },
428            "info": [],
429            "remote": [],
430            "public": [],
431            "types": [],
432            "repair-steps": {
433                "install": [],
434                "pre-migration": [],
435                "post-migration": [],
436                "live-migration": [],
437                "uninstall": []
438            },
439            "background-jobs": [],
440            "two-factor-providers": [],
441            "commands": [],
442            "_cached": true,
443            "groups": null,
444            "active": true,
445            "level": 100,
446            "removable": true,
447            "internal": false,
448            "preview": "\/owncloud\/apps\/calendar\/img\/calendar.svg",
449            "previewAsIcon": true,
450            "appconfig": {
451                "enabled": "yes",
452                "installed_version": "1.6.4",
453                "signed": "true",
454                "types": ""
455            }
456        },
457        {
458            "id": "files_texteditor",
459            "name": "Text Editor",
460            "summary": "Edit text files on the fly",
461            "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.",
462            "licence": "AGPL",
463            "author": "Tom Needham, Bj\u00f6rn Schie\u00dfle",
464            "version": "2.3.0",
465            "default_enable": "",
466            "documentation": {
467                "user": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md",
468                "admin": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md",
469                "developer": "https:\/\/github.com\/owncloud\/files_texteditor\/blob\/master\/README.md"
470            },
471            "category": "productivity",
472            "website": "https:\/\/github.com\/owncloud\/files_texteditor",
473            "bugs": "https:\/\/github.com\/owncloud\/files_texteditor\/issues",
474            "repository": {
475                "@attributes": {
476                    "type": "git"
477                },
478                "@value": "https:\/\/github.com\/owncloud\/files_texteditor.git"
479            },
480            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/a068ff44c439aa4969ea37b60e45bed875bbbb98\/files_texteditor\/texteditor.png",
481            "dependencies": {
482                "owncloud": {
483                    "@attributes": {
484                        "min-version": "10",
485                        "max-version": "10"
486                    }
487                }
488            },
489            "info": [],
490            "remote": [],
491            "public": [],
492            "types": [],
493            "repair-steps": {
494                "install": [],
495                "pre-migration": [],
496                "post-migration": [],
497                "live-migration": [],
498                "uninstall": []
499            },
500            "background-jobs": [],
501            "two-factor-providers": [],
502            "commands": [],
503            "_cached": true,
504            "groups": null,
505            "active": true,
506            "level": 100,
507            "removable": true,
508            "internal": false,
509            "preview": "\/owncloud\/apps\/files_texteditor\/img\/app.svg",
510            "previewAsIcon": true,
511            "appconfig": {
512                "enabled": "yes",
513                "installed_version": "2.3.0",
514                "signed": "true",
515                "types": ""
516            }
517        },
518        {
519            "id": "contacts",
520            "name": "Contacts",
521            "summary": "Manage your CardDAV contacts from a feature-rich web-interface",
522            "description": "Contacts is a user interface for ownCloud's CardDAV server. ownCloud Server comes with a CardDAV component that allows users to synchronize and backup their address books with ownCloud and across multiple devices. It provides users with an alternative to proprietary contact synchronization services giving them back control over their data once more.\n\nThe Contacts application is an extension to ownCloud's CardDAV interface. It equips ownCloud with a feature-rich frontend for the CardDAV server component, supports multiple address books and empowers users to easily manage their contacts from a web interface for ownCloud. Users may find the URL for device synchronization (to configure synchronization in iOS, Android or other CardDAV-capable applications) in the 'Settings' section on the bottom left inside the application (link symbol). Furthermore users can share address books with other users or groups (read-only\/editable) enabling to synchronize address books not only across devices but also across users. In addition to managing synchronized contacts the application also offers a feature to import contacts from vCards (.vcf).",
523            "licence": "AGPL",
524            "author": "Hendrik Leppelsack, Thomas M\u00fcller, Alexander Weidinger, Jan-Christoph Borchardt, Tom Needham",
525            "version": "1.5.5",
526            "documentation": {
527                "user": "https:\/\/doc.owncloud.org\/server\/10.0\/user_manual\/pim\/index.html",
528                "admin": "https:\/\/doc.owncloud.org\/server\/10.0\/admin_manual\/configuration\/server\/occ_command.html?highlight=contacts#dav-commands",
529                "developer": "https:\/\/github.com\/owncloud\/contacts\/blob\/master\/README.md"
530            },
531            "category": "productivity",
532            "website": "https:\/\/github.com\/owncloud\/contacts",
533            "bugs": "https:\/\/github.com\/owncloud\/contacts\/issues",
534            "repository": {
535                "@attributes": {
536                    "type": "git"
537                },
538                "@value": "https:\/\/github.com\/owncloud\/contacts.git"
539            },
540            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/760f2783b03fd26cbc920188b672f5f5efe548c0\/contacts\/contacts.png",
541            "dependencies": {
542                "owncloud": {
543                    "@attributes": {
544                        "min-version": "9.0",
545                        "max-version": "10"
546                    }
547                }
548            },
549            "info": [],
550            "remote": [],
551            "public": [],
552            "types": [],
553            "repair-steps": {
554                "install": [],
555                "pre-migration": [],
556                "post-migration": [],
557                "live-migration": [],
558                "uninstall": []
559            },
560            "background-jobs": [],
561            "two-factor-providers": [],
562            "commands": [],
563            "_cached": true,
564            "groups": null,
565            "active": true,
566            "level": 100,
567            "removable": true,
568            "internal": false,
569            "preview": "\/owncloud\/apps\/contacts\/img\/app.svg",
570            "previewAsIcon": true,
571            "appconfig": {
572                "enabled": "yes",
573                "installed_version": "1.5.5",
574                "ocsid": "168708",
575                "signed": "true",
576                "types": ""
577            }
578        },
579        {
580            "id": "firstrunwizard",
581            "name": "First run wizard",
582            "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.",
583            "licence": "AGPL",
584            "author": "Frank Karlitschek, Jan-Christoph Borchardt, Tom Needham",
585            "dependencies": {
586                "owncloud": {
587                    "@attributes": {
588                        "min-version": "10.2",
589                        "max-version": "11"
590                    }
591                }
592            },
593            "version": "1.2.0",
594            "namespace": "FirstRunWizard",
595            "default_enable": "",
596            "commands": {
597                "command": "OCA\\FirstRunWizard\\Command\\ResetAll"
598            },
599            "info": [],
600            "remote": [],
601            "public": [],
602            "types": [],
603            "repair-steps": {
604                "install": [],
605                "pre-migration": [],
606                "post-migration": [],
607                "live-migration": [],
608                "uninstall": []
609            },
610            "background-jobs": [],
611            "two-factor-providers": [],
612            "_cached": true,
613            "groups": null,
614            "active": false,
615            "level": 100,
616            "removable": true,
617            "internal": false,
618            "preview": "\/owncloud\/apps\/firstrunwizard\/img\/app.svg",
619            "previewAsIcon": true
620        },
621        {
622            "id": "user_external",
623            "name": "External user support",
624            "description": "Use external user authentication methods like IMAP, SMB and FTP",
625            "licence": "AGPL",
626            "author": "Robin Appelman",
627            "documentation": {
628                "admin": "https:\/\/doc.owncloud.org\/server\/10.3\/admin_manual\/configuration\/user\/user_auth_ftp_smb_imap.html"
629            },
630            "website": "https:\/\/github.com\/owncloud\/apps\/tree\/master\/user_external",
631            "bugs": "https:\/\/github.com\/owncloud\/apps\/issues",
632            "repository": {
633                "@attributes": {
634                    "type": "git"
635                },
636                "@value": "https:\/\/github.com\/owncloud\/user_external.git"
637            },
638            "dependencies": {
639                "owncloud": {
640                    "@attributes": {
641                        "min-version": "10",
642                        "max-version": "10"
643                    }
644                }
645            },
646            "version": "0.6.0",
647            "types": [
648                "authentication",
649                "prelogin"
650            ],
651            "info": [],
652            "remote": [],
653            "public": [],
654            "repair-steps": {
655                "install": [],
656                "pre-migration": [],
657                "post-migration": [],
658                "live-migration": [],
659                "uninstall": []
660            },
661            "background-jobs": [],
662            "two-factor-providers": [],
663            "commands": [],
664            "_cached": true,
665            "groups": null,
666            "active": false,
667            "level": 100,
668            "removable": true,
669            "internal": false,
670            "preview": "\/owncloud\/apps\/user_external\/img\/app.svg",
671            "previewAsIcon": true
672        },
673        {
674            "id": "provisioning_api",
675            "name": "Provisioning API",
676            "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.",
677            "licence": "AGPL",
678            "author": "Tom Needham",
679            "default_enable": "",
680            "documentation": {
681                "admin": "https:\/\/doc.owncloud.org\/server\/10.4\/go.php?to=admin-provisioning-api"
682            },
683            "version": "0.5.0",
684            "namespace": "Provisioning_API",
685            "types": [
686                "prevent_group_restriction"
687            ],
688            "dependencies": {
689                "owncloud": {
690                    "@attributes": {
691                        "min-version": "10",
692                        "max-version": "10"
693                    }
694                }
695            },
696            "info": [],
697            "remote": [],
698            "public": [],
699            "repair-steps": {
700                "install": [],
701                "pre-migration": [],
702                "post-migration": [],
703                "live-migration": [],
704                "uninstall": []
705            },
706            "background-jobs": [],
707            "two-factor-providers": [],
708            "commands": [],
709            "_cached": true,
710            "groups": null,
711            "active": true,
712            "internal": true,
713            "level": 200,
714            "removable": false,
715            "preview": "\/owncloud\/apps\/provisioning_api\/img\/app.svg",
716            "previewAsIcon": true,
717            "appconfig": {
718                "enabled": "yes",
719                "installed_version": "0.5.0",
720                "types": "prevent_group_restriction"
721            }
722        },
723        {
724            "id": "files_sharing",
725            "name": "Share Files",
726            "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",
727            "licence": "AGPL",
728            "author": "Michael Gapczynski, Bjoern Schiessle",
729            "default_enable": "",
730            "version": "0.12.0",
731            "types": [
732                "filesystem"
733            ],
734            "use-migrations": "true",
735            "dependencies": {
736                "owncloud": {
737                    "@attributes": {
738                        "min-version": "10.0.2.4",
739                        "max-version": "10"
740                    }
741                }
742            },
743            "public": {
744                "files": "public.php"
745            },
746            "namespace": "Files_Sharing",
747            "settings-sections": {
748                "personal": "OCA\\Files_Sharing\\Panels\\Personal\\Section"
749            },
750            "settings": {
751                "admin": "OCA\\Files_Sharing\\Panels\\Admin\\SettingsPanel",
752                "personal": "OCA\\Files_Sharing\\Panels\\Personal\\PersonalPanel"
753            },
754            "background-jobs": [
755                "OCA\\Files_Sharing\\DeleteOrphanedSharesJob",
756                "OCA\\Files_Sharing\\ExpireSharesJob"
757            ],
758            "commands": {
759                "command": "OCA\\Files_Sharing\\Command\\CleanupRemoteStorages"
760            },
761            "info": [],
762            "remote": [],
763            "repair-steps": {
764                "install": [],
765                "pre-migration": [],
766                "post-migration": [],
767                "live-migration": [],
768                "uninstall": []
769            },
770            "two-factor-providers": [],
771            "_cached": true,
772            "groups": null,
773            "active": true,
774            "internal": true,
775            "level": 200,
776            "removable": false,
777            "preview": "\/owncloud\/apps\/files_sharing\/img\/app.svg",
778            "previewAsIcon": true,
779            "appconfig": {
780                "enabled": "yes",
781                "installed_version": "0.12.0",
782                "types": "filesystem"
783            }
784        },
785        {
786            "id": "external",
787            "name": "External Sites",
788            "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.",
789            "licence": "AGPL",
790            "author": "Frank Karlitschek",
791            "dependencies": {
792                "owncloud": {
793                    "@attributes": {
794                        "min-version": "10",
795                        "max-version": "10"
796                    }
797                }
798            },
799            "version": "1.4.0",
800            "info": [],
801            "remote": [],
802            "public": [],
803            "types": [],
804            "repair-steps": {
805                "install": [],
806                "pre-migration": [],
807                "post-migration": [],
808                "live-migration": [],
809                "uninstall": []
810            },
811            "background-jobs": [],
812            "two-factor-providers": [],
813            "commands": [],
814            "_cached": true,
815            "groups": null,
816            "active": false,
817            "level": 100,
818            "removable": true,
819            "internal": false,
820            "preview": "\/owncloud\/apps\/external\/img\/external.svg",
821            "previewAsIcon": true
822        },
823        {
824            "id": "tasks",
825            "name": "Tasks",
826            "version": "0.9.7",
827            "namespace": "Tasks",
828            "category": "productivity",
829            "licence": "AGPL",
830            "author": "Raimund Schl\u00fc\u00dfler",
831            "summary": "ownCloud Tasks App for Calender",
832            "description": "Once enabled, a new Tasks menu will appear in your ownCloud apps menu. From there you can add and delete tasks, edit their title, description, start and due dates, reminder times, mark them as important, and add comments on them. Tasks can be shared between users. Tasks can be synchronized using CalDav (each task list is linked to an ownCloud calendar, to sync it to your local client - Thunderbird, Evolution, KDE Kontact, iCal... - just add the calendar as a remote calendar in your client). You can download your tasks as ICS files using the download button for each calendar.",
833            "screenshot": "https:\/\/github.com\/owncloud\/tasks\/raw\/master\/screenshots\/screenshot.png",
834            "bugs": "https:\/\/github.com\/owncloud\/tasks\/issues",
835            "repository": {
836                "@attributes": {
837                    "type": "git"
838                },
839                "@value": "https:\/\/github.com\/owncloud\/tasks.git"
840            },
841            "dependencies": {
842                "owncloud": {
843                    "@attributes": {
844                        "min-version": "9.1",
845                        "max-version": "10"
846                    }
847                }
848            },
849            "info": [],
850            "remote": [],
851            "public": [],
852            "types": [],
853            "repair-steps": {
854                "install": [],
855                "pre-migration": [],
856                "post-migration": [],
857                "live-migration": [],
858                "uninstall": []
859            },
860            "background-jobs": [],
861            "two-factor-providers": [],
862            "commands": [],
863            "_cached": true,
864            "groups": null,
865            "active": true,
866            "level": 100,
867            "removable": true,
868            "internal": false,
869            "preview": "\/owncloud\/apps\/tasks\/img\/tasks.svg",
870            "previewAsIcon": true,
871            "appconfig": {
872                "enabled": "yes",
873                "installed_version": "0.9.7",
874                "signed": "true",
875                "types": ""
876            }
877        },
878        {
879            "id": "brute_force_protection",
880            "name": "Brute-Force Protection",
881            "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.",
882            "summary": "Prevent attackers from guessing user passwords",
883            "licence": "GPLv2",
884            "author": "Semih Serhat Karakaya",
885            "version": "1.0.1",
886            "namespace": "BruteForceProtection",
887            "use-migrations": "true",
888            "dependencies": {
889                "owncloud": {
890                    "@attributes": {
891                        "min-version": "10.0.3",
892                        "max-version": "10"
893                    }
894                }
895            },
896            "types": [
897                "prelogin"
898            ],
899            "category": "security",
900            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/brute_force_protection\/ownCloud-app-bruteforce-protection.jpg",
901            "settings": {
902                "admin": "OCA\\BruteForceProtection\\Panels\\AdminPanel"
903            },
904            "background-jobs": {
905                "job": "OCA\\BruteForceProtection\\Jobs\\ExpireOldAttempts"
906            },
907            "documentation": {
908                "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/security\/password_policy.html"
909            },
910            "website": "https:\/\/github.com\/owncloud\/brute_force_protection",
911            "bugs": "https:\/\/github.com\/owncloud\/brute_force_protection\/issues",
912            "repository": {
913                "@attributes": {
914                    "type": "git"
915                },
916                "@value": "https:\/\/github.com\/owncloud\/brute_force_protection.git"
917            },
918            "info": [],
919            "remote": [],
920            "public": [],
921            "repair-steps": {
922                "install": [],
923                "pre-migration": [],
924                "post-migration": [],
925                "live-migration": [],
926                "uninstall": []
927            },
928            "two-factor-providers": [],
929            "commands": [],
930            "_cached": true,
931            "groups": null,
932            "active": true,
933            "level": 100,
934            "removable": true,
935            "internal": false,
936            "appconfig": {
937                "brute_force_protection_ban_period": "300",
938                "brute_force_protection_fail_tolerance": "3",
939                "brute_force_protection_time_threshold": "60",
940                "enabled": "yes",
941                "installed_version": "1.0.1",
942                "signed": "true",
943                "types": "prelogin"
944            }
945        },
946        {
947            "id": "files_pdfviewer",
948            "name": "PDF Viewer",
949            "summary": "Online viewer for PDF files",
950            "description": "This application integrates the PDF.js library into ownCloud. Using this application users can view their PDF files in their browser without the need to download the file.\n\nWhen this application is enabled publicly shared PDF documents will also get shown in the PDF Viewer instead of only showing a single static snapshot of the document. The PDF viewer requires a modern browser and will not work with Microsoft\u00ae Internet Explorer\u00ae versions below 9.\n\nPDF.js is a JavaScript library developed by Mozilla, you can learn more about the PDF.js project at https:\/\/mozilla.github.io\/pdf.js\/",
951            "licence": "AGPL",
952            "author": "Thomas M\u00fcller, Lukas Reschke, Viktar Dubiniuk",
953            "version": "0.11.1",
954            "dependencies": {
955                "owncloud": {
956                    "@attributes": {
957                        "min-version": "10.2",
958                        "max-version": "10"
959                    }
960                }
961            },
962            "default_enable": "",
963            "namespace": "Files_PdfViewer",
964            "website": "https:\/\/github.com\/owncloud\/files_pdfviewer",
965            "bugs": "https:\/\/github.com\/owncloud\/files_pdfviewer\/issues",
966            "category": "productivity",
967            "repository": {
968                "@attributes": {
969                    "type": "git"
970                },
971                "@value": "https:\/\/github.com\/owncloud\/files_pdfviewer.git"
972            },
973            "screenshot": "https:\/\/github.com\/owncloud\/screenshots\/raw\/cd5f83007e6037af6733d847548d2766be69a8a0\/files_pdfviewer\/files_pdfviewer.png",
974            "ocsid": "166049",
975            "info": [],
976            "remote": [],
977            "public": [],
978            "types": [],
979            "repair-steps": {
980                "install": [],
981                "pre-migration": [],
982                "post-migration": [],
983                "live-migration": [],
984                "uninstall": []
985            },
986            "background-jobs": [],
987            "two-factor-providers": [],
988            "commands": [],
989            "_cached": true,
990            "groups": null,
991            "active": true,
992            "level": 100,
993            "removable": true,
994            "internal": false,
995            "preview": "\/owncloud\/apps\/files_pdfviewer\/img\/app.svg",
996            "previewAsIcon": true,
997            "appconfig": {
998                "enabled": "yes",
999                "installed_version": "0.11.1",
1000                "ocsid": "166049",
1001                "signed": "true",
1002                "types": ""
1003            }
1004        },
1005        {
1006            "id": "files_versions",
1007            "name": "Versions",
1008            "licence": "AGPL",
1009            "author": "Frank Karlitschek, Bjoern Schiessle",
1010            "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",
1011            "version": "1.3.0",
1012            "types": [
1013                "filesystem"
1014            ],
1015            "namespace": "Files_Versions",
1016            "dependencies": {
1017                "owncloud": {
1018                    "@attributes": {
1019                        "min-version": "10",
1020                        "max-version": "10"
1021                    }
1022                }
1023            },
1024            "documentation": {
1025                "user": "https:\/\/doc.owncloud.org\/server\/10.4\/go.php?to=user-versions"
1026            },
1027            "default_enable": "",
1028            "background-jobs": {
1029                "job": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions"
1030            },
1031            "commands": [
1032                "OCA\\Files_Versions\\Command\\CleanUp",
1033                "OCA\\Files_Versions\\Command\\ExpireVersions"
1034            ],
1035            "info": [],
1036            "remote": [],
1037            "public": [],
1038            "repair-steps": {
1039                "install": [],
1040                "pre-migration": [],
1041                "post-migration": [],
1042                "live-migration": [],
1043                "uninstall": []
1044            },
1045            "two-factor-providers": [],
1046            "_cached": true,
1047            "groups": null,
1048            "active": true,
1049            "internal": true,
1050            "level": 200,
1051            "removable": false,
1052            "preview": "\/owncloud\/apps\/files_versions\/img\/app.svg",
1053            "previewAsIcon": true,
1054            "appconfig": {
1055                "enabled": "yes",
1056                "installed_version": "1.3.0",
1057                "types": "filesystem"
1058            }
1059        },
1060        {
1061            "id": "templateeditor",
1062            "name": "Mail Template Editor",
1063            "summary": "Customize mail templates easily",
1064            "description": "ownCloud comes with a built-in mail service to send various kinds of informative and action-requiring notifications to interact with users (e.g., user\/group and link share notifications, activity stream summary mails, password reset mails and more). By default ownCloud uses pre-defined standard templates for the respective events.\n\nTo meet their exact needs and guidelines many administrators desire to customize and personalize these templates. The system administrator can manually edit the template files within the ownCloud code. The Mail Template Editor provides an easier and more comfortable way for ownCloud administrators to modify mail templates within the 'General' section of ownCloud admin settings using HTML or plain text depending on the respective template. Each [ownCloud Theme](https:\/\/marketplace.owncloud.com\/themes) can provide separate templates making it very easy to switch between templates by just enabling a different theme. For more information, please read the [ownCloud Documentation](https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/email_configuration.html#using-email-templates).",
1065            "licence": "AGPL",
1066            "author": "J\u00f6rn Dreyer, Viktar Dubiniuk",
1067            "version": "0.4.0",
1068            "category": "customization",
1069            "documentation": {
1070                "admin": "https:\/\/doc.owncloud.com\/server\/latest\/admin_manual\/configuration\/server\/email_configuration.html#using-email-templates"
1071            },
1072            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/templateeditor\/template_editor.jpg",
1073            "namespace": "TemplateEditor",
1074            "dependencies": {
1075                "owncloud": {
1076                    "@attributes": {
1077                        "min-version": "10.0.9",
1078                        "max-version": "10"
1079                    }
1080                }
1081            },
1082            "default_enable": "",
1083            "website": "https:\/\/github.com\/owncloud\/templateeditor\/",
1084            "bugs": "https:\/\/github.com\/owncloud\/templateeditor\/issues",
1085            "repository": {
1086                "@attributes": {
1087                    "type": "git"
1088                },
1089                "@value": "http:\/\/github.com\/owncloud\/templateeditor.git"
1090            },
1091            "settings": {
1092                "admin": "OCA\\TemplateEditor\\AdminPanel"
1093            },
1094            "info": [],
1095            "remote": [],
1096            "public": [],
1097            "types": [],
1098            "repair-steps": {
1099                "install": [],
1100                "pre-migration": [],
1101                "post-migration": [],
1102                "live-migration": [],
1103                "uninstall": []
1104            },
1105            "background-jobs": [],
1106            "two-factor-providers": [],
1107            "commands": [],
1108            "_cached": true,
1109            "groups": null,
1110            "active": true,
1111            "level": 100,
1112            "removable": true,
1113            "internal": false,
1114            "preview": "\/owncloud\/apps\/templateeditor\/img\/app.svg",
1115            "previewAsIcon": true,
1116            "appconfig": {
1117                "enabled": "yes",
1118                "installed_version": "0.4.0",
1119                "signed": "true",
1120                "types": ""
1121            }
1122        },
1123        {
1124            "id": "systemtags",
1125            "name": "Collaborative tags",
1126            "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.)",
1127            "licence": "AGPL",
1128            "author": "Vincent Petry",
1129            "default_enable": "",
1130            "version": "0.3.0",
1131            "dependencies": {
1132                "owncloud": {
1133                    "@attributes": {
1134                        "min-version": "10",
1135                        "max-version": "10"
1136                    }
1137                }
1138            },
1139            "namespace": "SystemTags",
1140            "types": [
1141                "logging"
1142            ],
1143            "info": [],
1144            "remote": [],
1145            "public": [],
1146            "repair-steps": {
1147                "install": [],
1148                "pre-migration": [],
1149                "post-migration": [],
1150                "live-migration": [],
1151                "uninstall": []
1152            },
1153            "background-jobs": [],
1154            "two-factor-providers": [],
1155            "commands": [],
1156            "_cached": true,
1157            "groups": null,
1158            "active": true,
1159            "level": 100,
1160            "removable": true,
1161            "internal": false,
1162            "appconfig": {
1163                "enabled": "yes",
1164                "installed_version": "0.3.0",
1165                "types": "logging"
1166            }
1167        },
1168        {
1169            "id": "files_trashbin",
1170            "name": "Deleted files",
1171            "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",
1172            "licence": "AGPL",
1173            "author": "Bjoern Schiessle",
1174            "default_enable": "",
1175            "version": "0.9.1",
1176            "types": [
1177                "filesystem"
1178            ],
1179            "use-migrations": "true",
1180            "namespace": "Files_Trashbin",
1181            "dependencies": {
1182                "owncloud": {
1183                    "@attributes": {
1184                        "min-version": "10.0.2.4",
1185                        "max-version": "10"
1186                    }
1187                }
1188            },
1189            "documentation": {
1190                "user": "https:\/\/doc.owncloud.org\/server\/10.4\/go.php?to=user-trashbin"
1191            },
1192            "background-jobs": {
1193                "job": "OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash"
1194            },
1195            "commands": [
1196                "OCA\\Files_Trashbin\\Command\\CleanUp",
1197                "OCA\\Files_Trashbin\\Command\\ExpireTrash"
1198            ],
1199            "info": [],
1200            "remote": [],
1201            "public": [],
1202            "repair-steps": {
1203                "install": [],
1204                "pre-migration": [],
1205                "post-migration": [],
1206                "live-migration": [],
1207                "uninstall": []
1208            },
1209            "two-factor-providers": [],
1210            "_cached": true,
1211            "groups": null,
1212            "active": true,
1213            "internal": true,
1214            "level": 200,
1215            "removable": false,
1216            "preview": "\/owncloud\/apps\/files_trashbin\/img\/app.svg",
1217            "previewAsIcon": true,
1218            "appconfig": {
1219                "enabled": "yes",
1220                "installed_version": "0.9.1",
1221                "types": "filesystem"
1222            }
1223        },
1224        {
1225            "id": "notifications",
1226            "name": "Notifications",
1227            "summary": "Notification system for internal events",
1228            "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.",
1229            "category": "tools",
1230            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/promo\/e1dd604d66b4c5f765579b4c160de3268169ea3c\/ownCloud%20logo%20square.png",
1231            "licence": "AGPL",
1232            "author": "Joas Schilling, Thomas M\u00fcller",
1233            "version": "0.5.0",
1234            "types": [
1235                "logging"
1236            ],
1237            "default_enable": "",
1238            "website": "https:\/\/github.com\/owncloud\/notifications",
1239            "bugs": "https:\/\/github.com\/owncloud\/notifications\/issues",
1240            "repository": {
1241                "@attributes": {
1242                    "type": "git"
1243                },
1244                "@value": "https:\/\/github.com\/owncloud\/notifications.git"
1245            },
1246            "commands": {
1247                "command": "OCA\\Notifications\\Command\\Generate"
1248            },
1249            "settings": {
1250                "personal": "OCA\\Notifications\\Panels\\Personal\\NotificationsPanel"
1251            },
1252            "dependencies": {
1253                "owncloud": {
1254                    "@attributes": {
1255                        "min-version": "10.2",
1256                        "max-version": "11"
1257                    }
1258                }
1259            },
1260            "use-migrations": "true",
1261            "info": [],
1262            "remote": [],
1263            "public": [],
1264            "repair-steps": {
1265                "install": [],
1266                "pre-migration": [],
1267                "post-migration": [],
1268                "live-migration": [],
1269                "uninstall": []
1270            },
1271            "background-jobs": [],
1272            "two-factor-providers": [],
1273            "_cached": true,
1274            "groups": null,
1275            "active": true,
1276            "level": 100,
1277            "removable": true,
1278            "internal": false,
1279            "preview": "\/owncloud\/apps\/notifications\/img\/notifications.svg",
1280            "previewAsIcon": true,
1281            "appconfig": {
1282                "enabled": "yes",
1283                "installed_version": "0.5.0",
1284                "types": "logging"
1285            }
1286        },
1287        {
1288            "id": "configreport",
1289            "name": "Admin Config Report",
1290            "description": "Generate a Config Report",
1291            "licence": "AGPL",
1292            "author": "owncloud.org",
1293            "version": "0.2.0",
1294            "namespace": "ConfigReport",
1295            "default_enable": [
1296                "",
1297                ""
1298            ],
1299            "types": [
1300                "filesystem"
1301            ],
1302            "dependencies": {
1303                "owncloud": {
1304                    "@attributes": {
1305                        "min-version": "10.2",
1306                        "max-version": "11"
1307                    }
1308                }
1309            },
1310            "commands": {
1311                "command": "OCA\\ConfigReport\\Command\\ConfigReport"
1312            },
1313            "settings": {
1314                "admin": "OCA\\ConfigReport\\AdminPanel"
1315            },
1316            "info": [],
1317            "remote": [],
1318            "public": [],
1319            "repair-steps": {
1320                "install": [],
1321                "pre-migration": [],
1322                "post-migration": [],
1323                "live-migration": [],
1324                "uninstall": []
1325            },
1326            "background-jobs": [],
1327            "two-factor-providers": [],
1328            "_cached": true,
1329            "groups": null,
1330            "active": true,
1331            "internal": true,
1332            "level": 200,
1333            "removable": false,
1334            "appconfig": {
1335                "enabled": "yes",
1336                "installed_version": "0.2.0",
1337                "types": "filesystem"
1338            }
1339        },
1340        {
1341            "id": "files_mediaviewer",
1342            "name": "Media Viewer",
1343            "summary": "Explore, show and share your media collections",
1344            "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",
1345            "licence": "GPLv2",
1346            "author": "Felix Heidecke",
1347            "version": "1.0.2",
1348            "namespace": "Mediaviewer",
1349            "documentation": {
1350                "developer": "https:\/\/github.com\/owncloud\/files_mediaviewer\/blob\/master\/README.md"
1351            },
1352            "screenshot": "https:\/\/raw.githubusercontent.com\/owncloud\/screenshots\/master\/files_mediaviewer\/ownCloud-app-mediaviewer.jpg",
1353            "category": "multimedia",
1354            "website": "https:\/\/github.com\/owncloud\/files_mediaviewer",
1355            "bugs": "https:\/\/github.com\/owncloud\/files_mediaviewer\/issues",
1356            "repository": {
1357                "@attributes": {
1358                    "type": "git"
1359                },
1360                "@value": "https:\/\/github.com\/owncloud\/files_mediaviewer.git"
1361            },
1362            "dependencies": {
1363                "owncloud": {
1364                    "@attributes": {
1365                        "min-version": "10",
1366                        "max-version": "10"
1367                    }
1368                }
1369            },
1370            "default_enable": "",
1371            "info": [],
1372            "remote": [],
1373            "public": [],
1374            "types": [],
1375            "repair-steps": {
1376                "install": [],
1377                "pre-migration": [],
1378                "post-migration": [],
1379                "live-migration": [],
1380                "uninstall": []
1381            },
1382            "background-jobs": [],
1383            "two-factor-providers": [],
1384            "commands": [],
1385            "_cached": true,
1386            "groups": null,
1387            "active": true,
1388            "level": 100,
1389            "removable": true,
1390            "internal": false,
1391            "appconfig": {
1392                "enabled": "yes",
1393                "installed_version": "1.0.2",
1394                "signed": "true",
1395                "types": ""
1396            }
1397        }
1398    ],
1399    "mounts": [],
1400    "tables": {
1401        "tableNames": {
1402            "oc_account_terms": {
1403                "fields": [
1404                    {
1405                        "id": {
1406                            "type": "bigint",
1407                            "null": false,
1408                            "default": null,
1409                            "autoIncrement": true
1410                        }
1411                    },
1412                    {
1413                        "account_id": {
1414                            "type": "bigint",
1415                            "null": false,
1416                            "default": null,
1417                            "autoIncrement": false
1418                        }
1419                    },
1420                    {
1421                        "term": {
1422                            "type": "string",
1423                            "null": false,
1424                            "default": null,
1425                            "autoIncrement": false
1426                        }
1427                    }
1428                ],
1429                "index": [
1430                    {
1431                        "indexName": "account_id_index",
1432                        "columns": [
1433                            "account_id"
1434                        ],
1435                        "unique": false
1436                    },
1437                    {
1438                        "indexName": "PRIMARY",
1439                        "columns": [
1440                            "id"
1441                        ],
1442                        "unique": true
1443                    },
1444                    {
1445                        "indexName": "term_index",
1446                        "columns": [
1447                            "term"
1448                        ],
1449                        "unique": false
1450                    }
1451                ],
1452                "0": {
1453                    "primaryColumns": [
1454                        "id"
1455                    ]
1456                }
1457            },
1458            "oc_accounts": {
1459                "fields": [
1460                    {
1461                        "id": {
1462                            "type": "bigint",
1463                            "null": false,
1464                            "default": null,
1465                            "autoIncrement": true
1466                        }
1467                    },
1468                    {
1469                        "email": {
1470                            "type": "string",
1471                            "null": true,
1472                            "default": null,
1473                            "autoIncrement": false
1474                        }
1475                    },
1476                    {
1477                        "user_id": {
1478                            "type": "string",
1479                            "null": false,
1480                            "default": null,
1481                            "autoIncrement": false
1482                        }
1483                    },
1484                    {
1485                        "lower_user_id": {
1486                            "type": "string",
1487                            "null": false,
1488                            "default": null,
1489                            "autoIncrement": false
1490                        }
1491                    },
1492                    {
1493                        "display_name": {
1494                            "type": "string",
1495                            "null": true,
1496                            "default": null,
1497                            "autoIncrement": false
1498                        }
1499                    },
1500                    {
1501                        "quota": {
1502                            "type": "string",
1503                            "null": true,
1504                            "default": null,
1505                            "autoIncrement": false
1506                        }
1507                    },
1508                    {
1509                        "last_login": {
1510                            "type": "integer",
1511                            "null": false,
1512                            "default": "0",
1513                            "autoIncrement": false
1514                        }
1515                    },
1516                    {
1517                        "backend": {
1518                            "type": "string",
1519                            "null": false,
1520                            "default": null,
1521                            "autoIncrement": false
1522                        }
1523                    },
1524                    {
1525                        "home": {
1526                            "type": "string",
1527                            "null": false,
1528                            "default": null,
1529                            "autoIncrement": false
1530                        }
1531                    },
1532                    {
1533                        "state": {
1534                            "type": "smallint",
1535                            "null": false,
1536                            "default": "0",
1537                            "autoIncrement": false
1538                        }
1539                    }
1540                ],
1541                "index": [
1542                    {
1543                        "indexName": "UNIQ_907AA303A76ED395",
1544                        "columns": [
1545                            "user_id"
1546                        ],
1547                        "unique": true
1548                    },
1549                    {
1550                        "indexName": "email_index",
1551                        "columns": [
1552                            "email"
1553                        ],
1554                        "unique": false
1555                    },
1556                    {
1557                        "indexName": "PRIMARY",
1558                        "columns": [
1559                            "id"
1560                        ],
1561                        "unique": true
1562                    },
1563                    {
1564                        "indexName": "display_name_index",
1565                        "columns": [
1566                            "display_name"
1567                        ],
1568                        "unique": false
1569                    },
1570                    {
1571                        "indexName": "lower_user_id_index",
1572                        "columns": [
1573                            "lower_user_id"
1574                        ],
1575                        "unique": true
1576                    }
1577                ],
1578                "0": {
1579                    "primaryColumns": [
1580                        "id"
1581                    ]
1582                }
1583            },
1584            "oc_activity": {
1585                "fields": [
1586                    {
1587                        "activity_id": {
1588                            "type": "bigint",
1589                            "null": false,
1590                            "default": null,
1591                            "autoIncrement": true
1592                        }
1593                    },
1594                    {
1595                        "timestamp": {
1596                            "type": "integer",
1597                            "null": false,
1598                            "default": "0",
1599                            "autoIncrement": false
1600                        }
1601                    },
1602                    {
1603                        "priority": {
1604                            "type": "integer",
1605                            "null": false,
1606                            "default": "0",
1607                            "autoIncrement": false
1608                        }
1609                    },
1610                    {
1611                        "type": {
1612                            "type": "string",
1613                            "null": true,
1614                            "default": null,
1615                            "autoIncrement": false
1616                        }
1617                    },
1618                    {
1619                        "user": {
1620                            "type": "string",
1621                            "null": true,
1622                            "default": null,
1623                            "autoIncrement": false
1624                        }
1625                    },
1626                    {
1627                        "affecteduser": {
1628                            "type": "string",
1629                            "null": false,
1630                            "default": null,
1631                            "autoIncrement": false
1632                        }
1633                    },
1634                    {
1635                        "app": {
1636                            "type": "string",
1637                            "null": false,
1638                            "default": null,
1639                            "autoIncrement": false
1640                        }
1641                    },
1642                    {
1643                        "subject": {
1644                            "type": "string",
1645                            "null": false,
1646                            "default": null,
1647                            "autoIncrement": false
1648                        }
1649                    },
1650                    {
1651                        "subjectparams": {
1652                            "type": "text",
1653                            "null": false,
1654                            "default": null,
1655                            "autoIncrement": false
1656                        }
1657                    },
1658                    {
1659                        "message": {
1660                            "type": "string",
1661                            "null": true,
1662                            "default": null,
1663                            "autoIncrement": false
1664                        }
1665                    },
1666                    {
1667                        "messageparams": {
1668                            "type": "text",
1669                            "null": true,
1670                            "default": null,
1671                            "autoIncrement": false
1672                        }
1673                    },
1674                    {
1675                        "file": {
1676                            "type": "string",
1677                            "null": true,
1678                            "default": null,
1679                            "autoIncrement": false
1680                        }
1681                    },
1682                    {
1683                        "link": {
1684                            "type": "string",
1685                            "null": true,
1686                            "default": null,
1687                            "autoIncrement": false
1688                        }
1689                    },
1690                    {
1691                        "object_type": {
1692                            "type": "string",
1693                            "null": true,
1694                            "default": null,
1695                            "autoIncrement": false
1696                        }
1697                    },
1698                    {
1699                        "object_id": {
1700                            "type": "bigint",
1701                            "null": false,
1702                            "default": "0",
1703                            "autoIncrement": false
1704                        }
1705                    }
1706                ],
1707                "index": [
1708                    {
1709                        "indexName": "activity_user_time",
1710                        "columns": [
1711                            "affecteduser",
1712                            "timestamp"
1713                        ],
1714                        "unique": false
1715                    },
1716                    {
1717                        "indexName": "PRIMARY",
1718                        "columns": [
1719                            "activity_id"
1720                        ],
1721                        "unique": true
1722                    },
1723                    {
1724                        "indexName": "activity_filter_by",
1725                        "columns": [
1726                            "affecteduser",
1727                            "user",
1728                            "timestamp"
1729                        ],
1730                        "unique": false
1731                    },
1732                    {
1733                        "indexName": "activity_object",
1734                        "columns": [
1735                            "object_type",
1736                            "object_id"
1737                        ],
1738                        "unique": false
1739                    },
1740                    {
1741                        "indexName": "activity_filter_app",
1742                        "columns": [
1743                            "affecteduser",
1744                            "app",
1745                            "timestamp"
1746                        ],
1747                        "unique": false
1748                    },
1749                    {
1750                        "indexName": "activity_time",
1751                        "columns": [
1752                            "timestamp"
1753                        ],
1754                        "unique": false
1755                    }
1756                ],
1757                "0": {
1758                    "primaryColumns": [
1759                        "activity_id"
1760                    ]
1761                }
1762            },
1763            "oc_activity_mq": {
1764                "fields": [
1765                    {
1766                        "mail_id": {
1767                            "type": "bigint",
1768                            "null": false,
1769                            "default": null,
1770                            "autoIncrement": true
1771                        }
1772                    },
1773                    {
1774                        "amq_timestamp": {
1775                            "type": "integer",
1776                            "null": false,
1777                            "default": "0",
1778                            "autoIncrement": false
1779                        }
1780                    },
1781                    {
1782                        "amq_latest_send": {
1783                            "type": "integer",
1784                            "null": false,
1785                            "default": "0",
1786                            "autoIncrement": false
1787                        }
1788                    },
1789                    {
1790                        "amq_type": {
1791                            "type": "string",
1792                            "null": false,
1793                            "default": null,
1794                            "autoIncrement": false
1795                        }
1796                    },
1797                    {
1798                        "amq_affecteduser": {
1799                            "type": "string",
1800                            "null": false,
1801                            "default": null,
1802                            "autoIncrement": false
1803                        }
1804                    },
1805                    {
1806                        "amq_appid": {
1807                            "type": "string",
1808                            "null": false,
1809                            "default": null,
1810                            "autoIncrement": false
1811                        }
1812                    },
1813                    {
1814                        "amq_subject": {
1815                            "type": "string",
1816                            "null": false,
1817                            "default": null,
1818                            "autoIncrement": false
1819                        }
1820                    },
1821                    {
1822                        "amq_subjectparams": {
1823                            "type": "string",
1824                            "null": false,
1825                            "default": null,
1826                            "autoIncrement": false
1827                        }
1828                    }
1829                ],
1830                "index": [
1831                    {
1832                        "indexName": "amp_user",
1833                        "columns": [
1834                            "amq_affecteduser"
1835                        ],
1836                        "unique": false
1837                    },
1838                    {
1839                        "indexName": "PRIMARY",
1840                        "columns": [
1841                            "mail_id"
1842                        ],
1843                        "unique": true
1844                    },
1845                    {
1846                        "indexName": "amp_timestamp_time",
1847                        "columns": [
1848                            "amq_timestamp"
1849                        ],
1850                        "unique": false
1851                    },
1852                    {
1853                        "indexName": "amp_latest_send_time",
1854                        "columns": [
1855                            "amq_latest_send"
1856                        ],
1857                        "unique": false
1858                    }
1859                ],
1860                "0": {
1861                    "primaryColumns": [
1862                        "mail_id"
1863                    ]
1864                }
1865            },
1866            "oc_addressbookchanges": {
1867                "fields": [
1868                    {
1869                        "id": {
1870                            "type": "bigint",
1871                            "null": false,
1872                            "default": null,
1873                            "autoIncrement": true
1874                        }
1875                    },
1876                    {
1877                        "uri": {
1878                            "type": "string",
1879                            "null": true,
1880                            "default": null,
1881                            "autoIncrement": false
1882                        }
1883                    },
1884                    {
1885                        "synctoken": {
1886                            "type": "integer",
1887                            "null": false,
1888                            "default": "1",
1889                            "autoIncrement": false
1890                        }
1891                    },
1892                    {
1893                        "addressbookid": {
1894                            "type": "integer",
1895                            "null": false,
1896                            "default": null,
1897                            "autoIncrement": false
1898                        }
1899                    },
1900                    {
1901                        "operation": {
1902                            "type": "smallint",
1903                            "null": false,
1904                            "default": null,
1905                            "autoIncrement": false
1906                        }
1907                    }
1908                ],
1909                "index": [
1910                    {
1911                        "indexName": "addressbookid_synctoken",
1912                        "columns": [
1913                            "addressbookid",
1914                            "synctoken"
1915                        ],
1916                        "unique": false
1917                    },
1918                    {
1919                        "indexName": "PRIMARY",
1920                        "columns": [
1921                            "id"
1922                        ],
1923                        "unique": true
1924                    }
1925                ],
1926                "0": {
1927                    "primaryColumns": [
1928                        "id"
1929                    ]
1930                }
1931            },
1932            "oc_addressbooks": {
1933                "fields": [
1934                    {
1935                        "id": {
1936                            "type": "bigint",
1937                            "null": false,
1938                            "default": null,
1939                            "autoIncrement": true
1940                        }
1941                    },
1942                    {
1943                        "principaluri": {
1944                            "type": "string",
1945                            "null": true,
1946                            "default": null,
1947                            "autoIncrement": false
1948                        }
1949                    },
1950                    {
1951                        "displayname": {
1952                            "type": "string",
1953                            "null": true,
1954                            "default": null,
1955                            "autoIncrement": false
1956                        }
1957                    },
1958                    {
1959                        "uri": {
1960                            "type": "string",
1961                            "null": true,
1962                            "default": null,
1963                            "autoIncrement": false
1964                        }
1965                    },
1966                    {
1967                        "description": {
1968                            "type": "string",
1969                            "null": true,
1970                            "default": null,
1971                            "autoIncrement": false
1972                        }
1973                    },
1974                    {
1975                        "synctoken": {
1976                            "type": "integer",
1977                            "null": false,
1978                            "default": "1",
1979                            "autoIncrement": false
1980                        }
1981                    }
1982                ],
1983                "index": [
1984                    {
1985                        "indexName": "addressbook_index",
1986                        "columns": [
1987                            "principaluri",
1988                            "uri"
1989                        ],
1990                        "unique": true
1991                    },
1992                    {
1993                        "indexName": "PRIMARY",
1994                        "columns": [
1995                            "id"
1996                        ],
1997                        "unique": true
1998                    }
1999                ],
2000                "0": {
2001                    "primaryColumns": [
2002                        "id"
2003                    ]
2004                }
2005            },
2006            "oc_appconfig": {
2007                "fields": [
2008                    {
2009                        "appid": {
2010                            "type": "string",
2011                            "null": false,
2012                            "default": "",
2013                            "autoIncrement": false
2014                        }
2015                    },
2016                    {
2017                        "configkey": {
2018                            "type": "string",
2019                            "null": false,
2020                            "default": "",
2021                            "autoIncrement": false
2022                        }
2023                    },
2024                    {
2025                        "configvalue": {
2026                            "type": "text",
2027                            "null": true,
2028                            "default": null,
2029                            "autoIncrement": false
2030                        }
2031                    }
2032                ],
2033                "index": [
2034                    {
2035                        "indexName": "PRIMARY",
2036                        "columns": [
2037                            "appid",
2038                            "configkey"
2039                        ],
2040                        "unique": true
2041                    },
2042                    {
2043                        "indexName": "appconfig_appid_key",
2044                        "columns": [
2045                            "appid"
2046                        ],
2047                        "unique": false
2048                    },
2049                    {
2050                        "indexName": "appconfig_config_key_index",
2051                        "columns": [
2052                            "configkey"
2053                        ],
2054                        "unique": false
2055                    }
2056                ],
2057                "0": {
2058                    "primaryColumns": [
2059                        "appid",
2060                        "configkey"
2061                    ]
2062                }
2063            },
2064            "oc_authtoken": {
2065                "fields": [
2066                    {
2067                        "id": {
2068                            "type": "integer",
2069                            "null": false,
2070                            "default": null,
2071                            "autoIncrement": true
2072                        }
2073                    },
2074                    {
2075                        "uid": {
2076                            "type": "string",
2077                            "null": false,
2078                            "default": "",
2079                            "autoIncrement": false
2080                        }
2081                    },
2082                    {
2083                        "login_name": {
2084                            "type": "string",
2085                            "null": false,
2086                            "default": "",
2087                            "autoIncrement": false
2088                        }
2089                    },
2090                    {
2091                        "password": {
2092                            "type": "text",
2093                            "null": true,
2094                            "default": null,
2095                            "autoIncrement": false
2096                        }
2097                    },
2098                    {
2099                        "name": {
2100                            "type": "text",
2101                            "null": false,
2102                            "default": null,
2103                            "autoIncrement": false
2104                        }
2105                    },
2106                    {
2107                        "token": {
2108                            "type": "string",
2109                            "null": false,
2110                            "default": "",
2111                            "autoIncrement": false
2112                        }
2113                    },
2114                    {
2115                        "type": {
2116                            "type": "smallint",
2117                            "null": false,
2118                            "default": "0",
2119                            "autoIncrement": false
2120                        }
2121                    },
2122                    {
2123                        "last_activity": {
2124                            "type": "integer",
2125                            "null": false,
2126                            "default": "0",
2127                            "autoIncrement": false
2128                        }
2129                    },
2130                    {
2131                        "last_check": {
2132                            "type": "integer",
2133                            "null": false,
2134                            "default": "0",
2135                            "autoIncrement": false
2136                        }
2137                    }
2138                ],
2139                "index": [
2140                    {
2141                        "indexName": "authtoken_token_index",
2142                        "columns": [
2143                            "token"
2144                        ],
2145                        "unique": true
2146                    },
2147                    {
2148                        "indexName": "PRIMARY",
2149                        "columns": [
2150                            "id"
2151                        ],
2152                        "unique": true
2153                    },
2154                    {
2155                        "indexName": "authtoken_last_activity_index",
2156                        "columns": [
2157                            "last_activity"
2158                        ],
2159                        "unique": false
2160                    }
2161                ],
2162                "0": {
2163                    "primaryColumns": [
2164                        "id"
2165                    ]
2166                }
2167            },
2168            "oc_bfp_failed_logins": {
2169                "fields": [
2170                    {
2171                        "id": {
2172                            "type": "integer",
2173                            "null": false,
2174                            "default": null,
2175                            "autoIncrement": true
2176                        }
2177                    },
2178                    {
2179                        "ip": {
2180                            "type": "string",
2181                            "null": false,
2182                            "default": null,
2183                            "autoIncrement": false
2184                        }
2185                    },
2186                    {
2187                        "uid": {
2188                            "type": "string",
2189                            "null": false,
2190                            "default": null,
2191                            "autoIncrement": false
2192                        }
2193                    },
2194                    {
2195                        "attempted_at": {
2196                            "type": "integer",
2197                            "null": false,
2198                            "default": null,
2199                            "autoIncrement": false
2200                        }
2201                    }
2202                ],
2203                "index": [
2204                    {
2205                        "indexName": "bfp_failed_logins_ip",
2206                        "columns": [
2207                            "ip"
2208                        ],
2209                        "unique": false
2210                    },
2211                    {
2212                        "indexName": "PRIMARY",
2213                        "columns": [
2214                            "id"
2215                        ],
2216                        "unique": true
2217                    },
2218                    {
2219                        "indexName": "bfp_failed_logins_at",
2220                        "columns": [
2221                            "attempted_at"
2222                        ],
2223                        "unique": false
2224                    }
2225                ],
2226                "0": {
2227                    "primaryColumns": [
2228                        "id"
2229                    ]
2230                }
2231            },
2232            "oc_bookmarks": {
2233                "fields": [
2234                    {
2235                        "id": {
2236                            "type": "integer",
2237                            "null": false,
2238                            "default": null,
2239                            "autoIncrement": true
2240                        }
2241                    },
2242                    {
2243                        "url": {
2244                            "type": "string",
2245                            "null": false,
2246                            "default": "",
2247                            "autoIncrement": false
2248                        }
2249                    },
2250                    {
2251                        "title": {
2252                            "type": "string",
2253                            "null": false,
2254                            "default": "",
2255                            "autoIncrement": false
2256                        }
2257                    },
2258                    {
2259                        "user_id": {
2260                            "type": "string",
2261                            "null": false,
2262                            "default": "",
2263                            "autoIncrement": false
2264                        }
2265                    },
2266                    {
2267                        "description": {
2268                            "type": "string",
2269                            "null": false,
2270                            "default": "",
2271                            "autoIncrement": false
2272                        }
2273                    },
2274                    {
2275                        "public": {
2276                            "type": "smallint",
2277                            "null": true,
2278                            "default": "0",
2279                            "autoIncrement": false
2280                        }
2281                    },
2282                    {
2283                        "added": {
2284                            "type": "integer",
2285                            "null": true,
2286                            "default": "0",
2287                            "autoIncrement": false
2288                        }
2289                    },
2290                    {
2291                        "lastmodified": {
2292                            "type": "integer",
2293                            "null": true,
2294                            "default": "0",
2295                            "autoIncrement": false
2296                        }
2297                    },
2298                    {
2299                        "clickcount": {
2300                            "type": "integer",
2301                            "null": false,
2302                            "default": "0",
2303                            "autoIncrement": false
2304                        }
2305                    }
2306                ],
2307                "index": [
2308                    {
2309                        "indexName": "PRIMARY",
2310                        "columns": [
2311                            "id"
2312                        ],
2313                        "unique": true
2314                    }
2315                ],
2316                "0": {
2317                    "primaryColumns": [
2318                        "id"
2319                    ]
2320                }
2321            },
2322            "oc_bookmarks_tags": {
2323                "fields": [
2324                    {
2325                        "bookmark_id": {
2326                            "type": "bigint",
2327                            "null": true,
2328                            "default": null,
2329                            "autoIncrement": false
2330                        }
2331                    },
2332                    {
2333                        "tag": {
2334                            "type": "string",
2335                            "null": false,
2336                            "default": "",
2337                            "autoIncrement": false
2338                        }
2339                    }
2340                ],
2341                "index": [
2342                    {
2343                        "indexName": "bookmark_tag",
2344                        "columns": [
2345                            "bookmark_id",
2346                            "tag"
2347                        ],
2348                        "unique": true
2349                    }
2350                ],
2351                "0": {
2352                    "primaryColumns": []
2353                }
2354            },
2355            "oc_calendarchanges": {
2356                "fields": [
2357                    {
2358                        "id": {
2359                            "type": "bigint",
2360                            "null": false,
2361                            "default": null,
2362                            "autoIncrement": true
2363                        }
2364                    },
2365                    {
2366                        "uri": {
2367                            "type": "string",
2368                            "null": true,
2369                            "default": null,
2370                            "autoIncrement": false
2371                        }
2372                    },
2373                    {
2374                        "synctoken": {
2375                            "type": "integer",
2376                            "null": false,
2377                            "default": "1",
2378                            "autoIncrement": false
2379                        }
2380                    },
2381                    {
2382                        "calendarid": {
2383                            "type": "integer",
2384                            "null": false,
2385                            "default": null,
2386                            "autoIncrement": false
2387                        }
2388                    },
2389                    {
2390                        "operation": {
2391                            "type": "smallint",
2392                            "null": false,
2393                            "default": null,
2394                            "autoIncrement": false
2395                        }
2396                    }
2397                ],
2398                "index": [
2399                    {
2400                        "indexName": "calendarid_synctoken",
2401                        "columns": [
2402                            "calendarid",
2403                            "synctoken"
2404                        ],
2405                        "unique": false
2406                    },
2407                    {
2408                        "indexName": "PRIMARY",
2409                        "columns": [
2410                            "id"
2411                        ],
2412                        "unique": true
2413                    }
2414                ],
2415                "0": {
2416                    "primaryColumns": [
2417                        "id"
2418                    ]
2419                }
2420            },
2421            "oc_calendarobjects": {
2422                "fields": [
2423                    {
2424                        "id": {
2425                            "type": "bigint",
2426                            "null": false,
2427                            "default": null,
2428                            "autoIncrement": true
2429                        }
2430                    },
2431                    {
2432                        "calendardata": {
2433                            "type": "blob",
2434                            "null": true,
2435                            "default": null,
2436                            "autoIncrement": false
2437                        }
2438                    },
2439                    {
2440                        "uri": {
2441                            "type": "string",
2442                            "null": true,
2443                            "default": null,
2444                            "autoIncrement": false
2445                        }
2446                    },
2447                    {
2448                        "calendarid": {
2449                            "type": "integer",
2450                            "null": false,
2451                            "default": null,
2452                            "autoIncrement": false
2453                        }
2454                    },
2455                    {
2456                        "lastmodified": {
2457                            "type": "integer",
2458                            "null": true,
2459                            "default": null,
2460                            "autoIncrement": false
2461                        }
2462                    },
2463                    {
2464                        "etag": {
2465                            "type": "string",
2466                            "null": true,
2467                            "default": null,
2468                            "autoIncrement": false
2469                        }
2470                    },
2471                    {
2472                        "size": {
2473                            "type": "bigint",
2474                            "null": false,
2475                            "default": null,
2476                            "autoIncrement": false
2477                        }
2478                    },
2479                    {
2480                        "componenttype": {
2481                            "type": "string",
2482                            "null": true,
2483                            "default": null,
2484                            "autoIncrement": false
2485                        }
2486                    },
2487                    {
2488                        "firstoccurence": {
2489                            "type": "bigint",
2490                            "null": true,
2491                            "default": null,
2492                            "autoIncrement": false
2493                        }
2494                    },
2495                    {
2496                        "lastoccurence": {
2497                            "type": "bigint",
2498                            "null": true,
2499                            "default": null,
2500                            "autoIncrement": false
2501                        }
2502                    },
2503                    {
2504                        "uid": {
2505                            "type": "string",
2506                            "null": true,
2507                            "default": null,
2508                            "autoIncrement": false
2509                        }
2510                    },
2511                    {
2512                        "classification": {
2513                            "type": "integer",
2514                            "null": true,
2515                            "default": "0",
2516                            "autoIncrement": false
2517                        }
2518                    }
2519                ],
2520                "index": [
2521                    {
2522                        "indexName": "calobjects_index",
2523                        "columns": [
2524                            "calendarid",
2525                            "uri"
2526                        ],
2527                        "unique": true
2528                    },
2529                    {
2530                        "indexName": "PRIMARY",
2531                        "columns": [
2532                            "id"
2533                        ],
2534                        "unique": true
2535                    }
2536                ],
2537                "0": {
2538                    "primaryColumns": [
2539                        "id"
2540                    ]
2541                }
2542            },
2543            "oc_calendars": {
2544                "fields": [
2545                    {
2546                        "id": {
2547                            "type": "bigint",
2548                            "null": false,
2549                            "default": null,
2550                            "autoIncrement": true
2551                        }
2552                    },
2553                    {
2554                        "principaluri": {
2555                            "type": "string",
2556                            "null": true,
2557                            "default": null,
2558                            "autoIncrement": false
2559                        }
2560                    },
2561                    {
2562                        "displayname": {
2563                            "type": "string",
2564                            "null": true,
2565                            "default": null,
2566                            "autoIncrement": false
2567                        }
2568                    },
2569                    {
2570                        "uri": {
2571                            "type": "string",
2572                            "null": true,
2573                            "default": null,
2574                            "autoIncrement": false
2575                        }
2576                    },
2577                    {
2578                        "synctoken": {
2579                            "type": "integer",
2580                            "null": false,
2581                            "default": "1",
2582                            "autoIncrement": false
2583                        }
2584                    },
2585                    {
2586                        "description": {
2587                            "type": "string",
2588                            "null": true,
2589                            "default": null,
2590                            "autoIncrement": false
2591                        }
2592                    },
2593                    {
2594                        "calendarorder": {
2595                            "type": "integer",
2596                            "null": false,
2597                            "default": "0",
2598                            "autoIncrement": false
2599                        }
2600                    },
2601                    {
2602                        "calendarcolor": {
2603                            "type": "string",
2604                            "null": true,
2605                            "default": null,
2606                            "autoIncrement": false
2607                        }
2608                    },
2609                    {
2610                        "timezone": {
2611                            "type": "text",
2612                            "null": true,
2613                            "default": null,
2614                            "autoIncrement": false
2615                        }
2616                    },
2617                    {
2618                        "components": {
2619                            "type": "string",
2620                            "null": true,
2621                            "default": null,
2622                            "autoIncrement": false
2623                        }
2624                    },
2625                    {
2626                        "transparent": {
2627                            "type": "smallint",
2628                            "null": false,
2629                            "default": "0",
2630                            "autoIncrement": false
2631                        }
2632                    }
2633                ],
2634                "index": [
2635                    {
2636                        "indexName": "calendars_index",
2637                        "columns": [
2638                            "principaluri",
2639                            "uri"
2640                        ],
2641                        "unique": true
2642                    },
2643                    {
2644                        "indexName": "PRIMARY",
2645                        "columns": [
2646                            "id"
2647                        ],
2648                        "unique": true
2649                    }
2650                ],
2651                "0": {
2652                    "primaryColumns": [
2653                        "id"
2654                    ]
2655                }
2656            },
2657            "oc_calendarsubscriptions": {
2658                "fields": [
2659                    {
2660                        "id": {
2661                            "type": "bigint",
2662                            "null": false,
2663                            "default": null,
2664                            "autoIncrement": true
2665                        }
2666                    },
2667                    {
2668                        "uri": {
2669                            "type": "string",
2670                            "null": true,
2671                            "default": null,
2672                            "autoIncrement": false
2673                        }
2674                    },
2675                    {
2676                        "principaluri": {
2677                            "type": "string",
2678                            "null": true,
2679                            "default": null,
2680                            "autoIncrement": false
2681                        }
2682                    },
2683                    {
2684                        "source": {
2685                            "type": "string",
2686                            "null": true,
2687                            "default": null,
2688                            "autoIncrement": false
2689                        }
2690                    },
2691                    {
2692                        "displayname": {
2693                            "type": "string",
2694                            "null": true,
2695                            "default": null,
2696                            "autoIncrement": false
2697                        }
2698                    },
2699                    {
2700                        "refreshrate": {
2701                            "type": "string",
2702                            "null": true,
2703                            "default": null,
2704                            "autoIncrement": false
2705                        }
2706                    },
2707                    {
2708                        "calendarorder": {
2709                            "type": "integer",
2710                            "null": false,
2711                            "default": "0",
2712                            "autoIncrement": false
2713                        }
2714                    },
2715                    {
2716                        "calendarcolor": {
2717                            "type": "string",
2718                            "null": true,
2719                            "default": null,
2720                            "autoIncrement": false
2721                        }
2722                    },
2723                    {
2724                        "striptodos": {
2725                            "type": "smallint",
2726                            "null": true,
2727                            "default": null,
2728                            "autoIncrement": false
2729                        }
2730                    },
2731                    {
2732                        "stripalarms": {
2733                            "type": "smallint",
2734                            "null": true,
2735                            "default": null,
2736                            "autoIncrement": false
2737                        }
2738                    },
2739                    {
2740                        "stripattachments": {
2741                            "type": "smallint",
2742                            "null": true,
2743                            "default": null,
2744                            "autoIncrement": false
2745                        }
2746                    },
2747                    {
2748                        "lastmodified": {
2749                            "type": "integer",
2750                            "null": false,
2751                            "default": null,
2752                            "autoIncrement": false
2753                        }
2754                    }
2755                ],
2756                "index": [
2757                    {
2758                        "indexName": "calsub_index",
2759                        "columns": [
2760                            "principaluri",
2761                            "uri"
2762                        ],
2763                        "unique": true
2764                    },
2765                    {
2766                        "indexName": "PRIMARY",
2767                        "columns": [
2768                            "id"
2769                        ],
2770                        "unique": true
2771                    }
2772                ],
2773                "0": {
2774                    "primaryColumns": [
2775                        "id"
2776                    ]
2777                }
2778            },
2779            "oc_cards": {
2780                "fields": [
2781                    {
2782                        "id": {
2783                            "type": "bigint",
2784                            "null": false,
2785                            "default": null,
2786                            "autoIncrement": true
2787                        }
2788                    },
2789                    {
2790                        "addressbookid": {
2791                            "type": "integer",
2792                            "null": false,
2793                            "default": "0",
2794                            "autoIncrement": false
2795                        }
2796                    },
2797                    {
2798                        "carddata": {
2799                            "type": "blob",
2800                            "null": true,
2801                            "default": null,
2802                            "autoIncrement": false
2803                        }
2804                    },
2805                    {
2806                        "uri": {
2807                            "type": "string",
2808                            "null": true,
2809                            "default": null,
2810                            "autoIncrement": false
2811                        }
2812                    },
2813                    {
2814                        "lastmodified": {
2815                            "type": "bigint",
2816                            "null": true,
2817                            "default": null,
2818                            "autoIncrement": false
2819                        }
2820                    },
2821                    {
2822                        "etag": {
2823                            "type": "string",
2824                            "null": true,
2825                            "default": null,
2826                            "autoIncrement": false
2827                        }
2828                    },
2829                    {
2830                        "size": {
2831                            "type": "bigint",
2832                            "null": false,
2833                            "default": null,
2834                            "autoIncrement": false
2835                        }
2836                    }
2837                ],
2838                "index": [
2839                    {
2840                        "indexName": "addressbookid_uri_index",
2841                        "columns": [
2842                            "addressbookid",
2843                            "uri"
2844                        ],
2845                        "unique": false
2846                    },
2847                    {
2848                        "indexName": "PRIMARY",
2849                        "columns": [
2850                            "id"
2851                        ],
2852                        "unique": true
2853                    }
2854                ],
2855                "0": {
2856                    "primaryColumns": [
2857                        "id"
2858                    ]
2859                }
2860            },
2861            "oc_cards_properties": {
2862                "fields": [
2863                    {
2864                        "id": {
2865                            "type": "bigint",
2866                            "null": false,
2867                            "default": null,
2868                            "autoIncrement": true
2869                        }
2870                    },
2871                    {
2872                        "addressbookid": {
2873                            "type": "bigint",
2874                            "null": false,
2875                            "default": "0",
2876                            "autoIncrement": false
2877                        }
2878                    },
2879                    {
2880                        "cardid": {
2881                            "type": "bigint",
2882                            "null": false,
2883                            "default": "0",
2884                            "autoIncrement": false
2885                        }
2886                    },
2887                    {
2888                        "name": {
2889                            "type": "string",
2890                            "null": true,
2891                            "default": null,
2892                            "autoIncrement": false
2893                        }
2894                    },
2895                    {
2896                        "value": {
2897                            "type": "string",
2898                            "null": true,
2899                            "default": null,
2900                            "autoIncrement": false
2901                        }
2902                    },
2903                    {
2904                        "preferred": {
2905                            "type": "integer",
2906                            "null": false,
2907                            "default": "1",
2908                            "autoIncrement": false
2909                        }
2910                    }
2911                ],
2912                "index": [
2913                    {
2914                        "indexName": "card_contactid_index",
2915                        "columns": [
2916                            "cardid"
2917                        ],
2918                        "unique": false
2919                    },
2920                    {
2921                        "indexName": "PRIMARY",
2922                        "columns": [
2923                            "id"
2924                        ],
2925                        "unique": true
2926                    },
2927                    {
2928                        "indexName": "card_value_index",
2929                        "columns": [
2930                            "value"
2931                        ],
2932                        "unique": false
2933                    },
2934                    {
2935                        "indexName": "card_name_index",
2936                        "columns": [
2937                            "name"
2938                        ],
2939                        "unique": false
2940                    }
2941                ],
2942                "0": {
2943                    "primaryColumns": [
2944                        "id"
2945                    ]
2946                }
2947            },
2948            "oc_comments": {
2949                "fields": [
2950                    {
2951                        "id": {
2952                            "type": "integer",
2953                            "null": false,
2954                            "default": null,
2955                            "autoIncrement": true
2956                        }
2957                    },
2958                    {
2959                        "parent_id": {
2960                            "type": "integer",
2961                            "null": false,
2962                            "default": "0",
2963                            "autoIncrement": false
2964                        }
2965                    },
2966                    {
2967                        "topmost_parent_id": {
2968                            "type": "integer",
2969                            "null": false,
2970                            "default": "0",
2971                            "autoIncrement": false
2972                        }
2973                    },
2974                    {
2975                        "children_count": {
2976                            "type": "integer",
2977                            "null": false,
2978                            "default": "0",
2979                            "autoIncrement": false
2980                        }
2981                    },
2982                    {
2983                        "actor_type": {
2984                            "type": "string",
2985                            "null": false,
2986                            "default": "",
2987                            "autoIncrement": false
2988                        }
2989                    },
2990                    {
2991                        "actor_id": {
2992                            "type": "string",
2993                            "null": false,
2994                            "default": "",
2995                            "autoIncrement": false
2996                        }
2997                    },
2998                    {
2999                        "message": {
3000                            "type": "text",
3001                            "null": true,
3002                            "default": null,
3003                            "autoIncrement": false
3004                        }
3005                    },
3006                    {
3007                        "verb": {
3008                            "type": "string",
3009                            "null": true,
3010                            "default": null,
3011                            "autoIncrement": false
3012                        }
3013                    },
3014                    {
3015                        "creation_timestamp": {
3016                            "type": "datetime",
3017                            "null": true,
3018                            "default": null,
3019                            "autoIncrement": false
3020                        }
3021                    },
3022                    {
3023                        "latest_child_timestamp": {
3024                            "type": "datetime",
3025                            "null": true,
3026                            "default": null,
3027                            "autoIncrement": false
3028                        }
3029                    },
3030                    {
3031                        "object_type": {
3032                            "type": "string",
3033                            "null": false,
3034                            "default": "",
3035                            "autoIncrement": false
3036                        }
3037                    },
3038                    {
3039                        "object_id": {
3040                            "type": "string",
3041                            "null": false,
3042                            "default": "",
3043                            "autoIncrement": false
3044                        }
3045                    }
3046                ],
3047                "index": [
3048                    {
3049                        "indexName": "comments_parent_id_index",
3050                        "columns": [
3051                            "parent_id"
3052                        ],
3053                        "unique": false
3054                    },
3055                    {
3056                        "indexName": "PRIMARY",
3057                        "columns": [
3058                            "id"
3059                        ],
3060                        "unique": true
3061                    },
3062                    {
3063                        "indexName": "comments_object_index",
3064                        "columns": [
3065                            "object_type",
3066                            "object_id",
3067                            "creation_timestamp"
3068                        ],
3069                        "unique": false
3070                    },
3071                    {
3072                        "indexName": "comments_actor_index",
3073                        "columns": [
3074                            "actor_type",
3075                            "actor_id"
3076                        ],
3077                        "unique": false
3078                    },
3079                    {
3080                        "indexName": "comments_topmost_parent_id_idx",
3081                        "columns": [
3082                            "topmost_parent_id"
3083                        ],
3084                        "unique": false
3085                    }
3086                ],
3087                "0": {
3088                    "primaryColumns": [
3089                        "id"
3090                    ]
3091                }
3092            },
3093            "oc_comments_read_markers": {
3094                "fields": [
3095                    {
3096                        "user_id": {
3097                            "type": "string",
3098                            "null": false,
3099                            "default": "",
3100                            "autoIncrement": false
3101                        }
3102                    },
3103                    {
3104                        "marker_datetime": {
3105                            "type": "datetime",
3106                            "null": true,
3107                            "default": null,
3108                            "autoIncrement": false
3109                        }
3110                    },
3111                    {
3112                        "object_type": {
3113                            "type": "string",
3114                            "null": false,
3115                            "default": "",
3116                            "autoIncrement": false
3117                        }
3118                    },
3119                    {
3120                        "object_id": {
3121                            "type": "string",
3122                            "null": false,
3123                            "default": "",
3124                            "autoIncrement": false
3125                        }
3126                    }
3127                ],
3128                "index": [
3129                    {
3130                        "indexName": "comments_marker_index",
3131                        "columns": [
3132                            "user_id",
3133                            "object_type",
3134                            "object_id"
3135                        ],
3136                        "unique": true
3137                    },
3138                    {
3139                        "indexName": "comments_marker_object_index",
3140                        "columns": [
3141                            "object_type",
3142                            "object_id"
3143                        ],
3144                        "unique": false
3145                    }
3146                ],
3147                "0": {
3148                    "primaryColumns": []
3149                }
3150            },
3151            "oc_credentials": {
3152                "fields": [
3153                    {
3154                        "user": {
3155                            "type": "string",
3156                            "null": false,
3157                            "default": null,
3158                            "autoIncrement": false
3159                        }
3160                    },
3161                    {
3162                        "identifier": {
3163                            "type": "string",
3164                            "null": false,
3165                            "default": null,
3166                            "autoIncrement": false
3167                        }
3168                    },
3169                    {
3170                        "credentials": {
3171                            "type": "text",
3172                            "null": true,
3173                            "default": null,
3174                            "autoIncrement": false
3175                        }
3176                    }
3177                ],
3178                "index": [
3179                    {
3180                        "indexName": "PRIMARY",
3181                        "columns": [
3182                            "user",
3183                            "identifier"
3184                        ],
3185                        "unique": true
3186                    },
3187                    {
3188                        "indexName": "credentials_user",
3189                        "columns": [
3190                            "user"
3191                        ],
3192                        "unique": false
3193                    }
3194                ],
3195                "0": {
3196                    "primaryColumns": [
3197                        "user",
3198                        "identifier"
3199                    ]
3200                }
3201            },
3202            "oc_dav_job_status": {
3203                "fields": [
3204                    {
3205                        "id": {
3206                            "type": "bigint",
3207                            "null": false,
3208                            "default": null,
3209                            "autoIncrement": true
3210                        }
3211                    },
3212                    {
3213                        "uuid": {
3214                            "type": "guid",
3215                            "null": false,
3216                            "default": null,
3217                            "autoIncrement": false
3218                        }
3219                    },
3220                    {
3221                        "user_id": {
3222                            "type": "string",
3223                            "null": false,
3224                            "default": null,
3225                            "autoIncrement": false
3226                        }
3227                    },
3228                    {
3229                        "status_info": {
3230                            "type": "string",
3231                            "null": false,
3232                            "default": null,
3233                            "autoIncrement": false
3234                        }
3235                    }
3236                ],
3237                "index": [
3238                    {
3239                        "indexName": "UNIQ_18BBA548D17F50A6",
3240                        "columns": [
3241                            "uuid"
3242                        ],
3243                        "unique": true
3244                    },
3245                    {
3246                        "indexName": "PRIMARY",
3247                        "columns": [
3248                            "id"
3249                        ],
3250                        "unique": true
3251                    }
3252                ],
3253                "0": {
3254                    "primaryColumns": [
3255                        "id"
3256                    ]
3257                }
3258            },
3259            "oc_dav_properties": {
3260                "fields": [
3261                    {
3262                        "id": {
3263                            "type": "bigint",
3264                            "null": false,
3265                            "default": null,
3266                            "autoIncrement": true
3267                        }
3268                    },
3269                    {
3270                        "propertypath": {
3271                            "type": "string",
3272                            "null": false,
3273                            "default": "",
3274                            "autoIncrement": false
3275                        }
3276                    },
3277                    {
3278                        "propertyname": {
3279                            "type": "string",
3280                            "null": false,
3281                            "default": "",
3282                            "autoIncrement": false
3283                        }
3284                    },
3285                    {
3286                        "propertyvalue": {
3287                            "type": "string",
3288                            "null": false,
3289                            "default": null,
3290                            "autoIncrement": false
3291                        }
3292                    }
3293                ],
3294                "index": [
3295                    {
3296                        "indexName": "propertypath_index",
3297                        "columns": [
3298                            "propertypath"
3299                        ],
3300                        "unique": false
3301                    },
3302                    {
3303                        "indexName": "PRIMARY",
3304                        "columns": [
3305                            "id"
3306                        ],
3307                        "unique": true
3308                    }
3309                ],
3310                "0": {
3311                    "primaryColumns": [
3312                        "id"
3313                    ]
3314                }
3315            },
3316            "oc_dav_shares": {
3317                "fields": [
3318                    {
3319                        "id": {
3320                            "type": "bigint",
3321                            "null": false,
3322                            "default": null,
3323                            "autoIncrement": true
3324                        }
3325                    },
3326                    {
3327                        "principaluri": {
3328                            "type": "string",
3329                            "null": true,
3330                            "default": null,
3331                            "autoIncrement": false
3332                        }
3333                    },
3334                    {
3335                        "type": {
3336                            "type": "string",
3337                            "null": true,
3338                            "default": null,
3339                            "autoIncrement": false
3340                        }
3341                    },
3342                    {
3343                        "access": {
3344                            "type": "smallint",
3345                            "null": true,
3346                            "default": null,
3347                            "autoIncrement": false
3348                        }
3349                    },
3350                    {
3351                        "resourceid": {
3352                            "type": "integer",
3353                            "null": false,
3354                            "default": null,
3355                            "autoIncrement": false
3356                        }
3357                    },
3358                    {
3359                        "publicuri": {
3360                            "type": "string",
3361                            "null": true,
3362                            "default": null,
3363                            "autoIncrement": false
3364                        }
3365                    }
3366                ],
3367                "index": [
3368                    {
3369                        "indexName": "dav_shares_index",
3370                        "columns": [
3371                            "principaluri",
3372                            "resourceid",
3373                            "type",
3374                            "publicuri"
3375                        ],
3376                        "unique": true
3377                    },
3378                    {
3379                        "indexName": "PRIMARY",
3380                        "columns": [
3381                            "id"
3382                        ],
3383                        "unique": true
3384                    }
3385                ],
3386                "0": {
3387                    "primaryColumns": [
3388                        "id"
3389                    ]
3390                }
3391            },
3392            "oc_documents_invite": {
3393                "fields": [
3394                    {
3395                        "es_id": {
3396                            "type": "string",
3397                            "null": false,
3398                            "default": null,
3399                            "autoIncrement": false
3400                        }
3401                    },
3402                    {
3403                        "uid": {
3404                            "type": "string",
3405                            "null": true,
3406                            "default": null,
3407                            "autoIncrement": false
3408                        }
3409                    },
3410                    {
3411                        "status": {
3412                            "type": "smallint",
3413                            "null": true,
3414                            "default": "0",
3415                            "autoIncrement": false
3416                        }
3417                    },
3418                    {
3419                        "sent_on": {
3420                            "type": "integer",
3421                            "null": true,
3422                            "default": "0",
3423                            "autoIncrement": false
3424                        }
3425                    }
3426                ],
3427                "0": {
3428                    "primaryColumns": []
3429                }
3430            },
3431            "oc_documents_member": {
3432                "fields": [
3433                    {
3434                        "member_id": {
3435                            "type": "integer",
3436                            "null": false,
3437                            "default": null,
3438                            "autoIncrement": true
3439                        }
3440                    },
3441                    {
3442                        "es_id": {
3443                            "type": "string",
3444                            "null": false,
3445                            "default": null,
3446                            "autoIncrement": false
3447                        }
3448                    },
3449                    {
3450                        "uid": {
3451                            "type": "string",
3452                            "null": true,
3453                            "default": null,
3454                            "autoIncrement": false
3455                        }
3456                    },
3457                    {
3458                        "color": {
3459                            "type": "string",
3460                            "null": true,
3461                            "default": null,
3462                            "autoIncrement": false
3463                        }
3464                    },
3465                    {
3466                        "last_activity": {
3467                            "type": "integer",
3468                            "null": true,
3469                            "default": null,
3470                            "autoIncrement": false
3471                        }
3472                    },
3473                    {
3474                        "is_guest": {
3475                            "type": "smallint",
3476                            "null": false,
3477                            "default": "0",
3478                            "autoIncrement": false
3479                        }
3480                    },
3481                    {
3482                        "token": {
3483                            "type": "string",
3484                            "null": true,
3485                            "default": null,
3486                            "autoIncrement": false
3487                        }
3488                    },
3489                    {
3490                        "status": {
3491                            "type": "smallint",
3492                            "null": false,
3493                            "default": "1",
3494                            "autoIncrement": false
3495                        }
3496                    }
3497                ],
3498                "index": [
3499                    {
3500                        "indexName": "PRIMARY",
3501                        "columns": [
3502                            "member_id"
3503                        ],
3504                        "unique": true
3505                    }
3506                ],
3507                "0": {
3508                    "primaryColumns": [
3509                        "member_id"
3510                    ]
3511                }
3512            },
3513            "oc_documents_op": {
3514                "fields": [
3515                    {
3516                        "seq": {
3517                            "type": "integer",
3518                            "null": false,
3519                            "default": null,
3520                            "autoIncrement": true
3521                        }
3522                    },
3523                    {
3524                        "es_id": {
3525                            "type": "string",
3526                            "null": false,
3527                            "default": null,
3528                            "autoIncrement": false
3529                        }
3530                    },
3531                    {
3532                        "member": {
3533                            "type": "integer",
3534                            "null": false,
3535                            "default": "1",
3536                            "autoIncrement": false
3537                        }
3538                    },
3539                    {
3540                        "opspec": {
3541                            "type": "text",
3542                            "null": true,
3543                            "default": null,
3544                            "autoIncrement": false
3545                        }
3546                    },
3547                    {
3548                        "optype": {
3549                            "type": "string",
3550                            "null": true,
3551                            "default": null,
3552                            "autoIncrement": false
3553                        }
3554                    }
3555                ],
3556                "index": [
3557                    {
3558                        "indexName": "documents_op_eis_idx",
3559                        "columns": [
3560                            "es_id",
3561                            "seq"
3562                        ],
3563                        "unique": true
3564                    },
3565                    {
3566                        "indexName": "PRIMARY",
3567                        "columns": [
3568                            "seq"
3569                        ],
3570                        "unique": true
3571                    }
3572                ],
3573                "0": {
3574                    "primaryColumns": [
3575                        "seq"
3576                    ]
3577                }
3578            },
3579            "oc_documents_revisions": {
3580                "fields": [
3581                    {
3582                        "es_id": {
3583                            "type": "string",
3584                            "null": false,
3585                            "default": null,
3586                            "autoIncrement": false
3587                        }
3588                    },
3589                    {
3590                        "seq_head": {
3591                            "type": "integer",
3592                            "null": false,
3593                            "default": null,
3594                            "autoIncrement": false
3595                        }
3596                    },
3597                    {
3598                        "member_id": {
3599                            "type": "integer",
3600                            "null": false,
3601                            "default": null,
3602                            "autoIncrement": false
3603                        }
3604                    },
3605                    {
3606                        "file_id": {
3607                            "type": "string",
3608                            "null": true,
3609                            "default": null,
3610                            "autoIncrement": false
3611                        }
3612                    },
3613                    {
3614                        "save_hash": {
3615                            "type": "string",
3616                            "null": false,
3617                            "default": null,
3618                            "autoIncrement": false
3619                        }
3620                    }
3621                ],
3622                "index": [
3623                    {
3624                        "indexName": "documents_rev_eis_idx",
3625                        "columns": [
3626                            "es_id",
3627                            "seq_head"
3628                        ],
3629                        "unique": true
3630                    }
3631                ],
3632                "0": {
3633                    "primaryColumns": []
3634                }
3635            },
3636            "oc_documents_session": {
3637                "fields": [
3638                    {
3639                        "es_id": {
3640                            "type": "string",
3641                            "null": false,
3642                            "default": null,
3643                            "autoIncrement": false
3644                        }
3645                    },
3646                    {
3647                        "genesis_url": {
3648                            "type": "string",
3649                            "null": true,
3650                            "default": null,
3651                            "autoIncrement": false
3652                        }
3653                    },
3654                    {
3655                        "genesis_hash": {
3656                            "type": "string",
3657                            "null": false,
3658                            "default": null,
3659                            "autoIncrement": false
3660                        }
3661                    },
3662                    {
3663                        "file_id": {
3664                            "type": "string",
3665                            "null": true,
3666                            "default": null,
3667                            "autoIncrement": false
3668                        }
3669                    },
3670                    {
3671                        "owner": {
3672                            "type": "string",
3673                            "null": false,
3674                            "default": null,
3675                            "autoIncrement": false
3676                        }
3677                    }
3678                ],
3679                "index": [
3680                    {
3681                        "indexName": "PRIMARY",
3682                        "columns": [
3683                            "es_id"
3684                        ],
3685                        "unique": true
3686                    }
3687                ],
3688                "0": {
3689                    "primaryColumns": [
3690                        "es_id"
3691                    ]
3692                }
3693            },
3694            "oc_external_applicable": {
3695                "fields": [
3696                    {
3697                        "applicable_id": {
3698                            "type": "bigint",
3699                            "null": false,
3700                            "default": null,
3701                            "autoIncrement": true
3702                        }
3703                    },
3704                    {
3705                        "mount_id": {
3706                            "type": "bigint",
3707                            "null": false,
3708                            "default": null,
3709                            "autoIncrement": false
3710                        }
3711                    },
3712                    {
3713                        "type": {
3714                            "type": "integer",
3715                            "null": false,
3716                            "default": null,
3717                            "autoIncrement": false
3718                        }
3719                    },
3720                    {
3721                        "value": {
3722                            "type": "string",
3723                            "null": true,
3724                            "default": null,
3725                            "autoIncrement": false
3726                        }
3727                    }
3728                ],
3729                "index": [
3730                    {
3731                        "indexName": "applicable_type_value_mount",
3732                        "columns": [
3733                            "type",
3734                            "value",
3735                            "mount_id"
3736                        ],
3737                        "unique": true
3738                    },
3739                    {
3740                        "indexName": "applicable_mount",
3741                        "columns": [
3742                            "mount_id"
3743                        ],
3744                        "unique": false
3745                    },
3746                    {
3747                        "indexName": "PRIMARY",
3748                        "columns": [
3749                            "applicable_id"
3750                        ],
3751                        "unique": true
3752                    },
3753                    {
3754                        "indexName": "applicable_type_value",
3755                        "columns": [
3756                            "type",
3757                            "value"
3758                        ],
3759                        "unique": false
3760                    }
3761                ],
3762                "0": {
3763                    "primaryColumns": [
3764                        "applicable_id"
3765                    ]
3766                }
3767            },
3768            "oc_external_config": {
3769                "fields": [
3770                    {
3771                        "config_id": {
3772                            "type": "bigint",
3773                            "null": false,
3774                            "default": null,
3775                            "autoIncrement": true
3776                        }
3777                    },
3778                    {
3779                        "mount_id": {
3780                            "type": "bigint",
3781                            "null": false,
3782                            "default": null,
3783                            "autoIncrement": false
3784                        }
3785                    },
3786                    {
3787                        "key": {
3788                            "type": "string",
3789                            "null": false,
3790                            "default": null,
3791                            "autoIncrement": false
3792                        }
3793                    },
3794                    {
3795                        "value": {
3796                            "type": "string",
3797                            "null": false,
3798                            "default": null,
3799                            "autoIncrement": false
3800                        }
3801                    }
3802                ],
3803                "index": [
3804                    {
3805                        "indexName": "config_mount_key",
3806                        "columns": [
3807                            "mount_id",
3808                            "key"
3809                        ],
3810                        "unique": true
3811                    },
3812                    {
3813                        "indexName": "PRIMARY",
3814                        "columns": [
3815                            "config_id"
3816                        ],
3817                        "unique": true
3818                    },
3819                    {
3820                        "indexName": "config_mount",
3821                        "columns": [
3822                            "mount_id"
3823                        ],
3824                        "unique": false
3825                    }
3826                ],
3827                "0": {
3828                    "primaryColumns": [
3829                        "config_id"
3830                    ]
3831                }
3832            },
3833            "oc_external_mounts": {
3834                "fields": [
3835                    {
3836                        "mount_id": {
3837                            "type": "bigint",
3838                            "null": false,
3839                            "default": null,
3840                            "autoIncrement": true
3841                        }
3842                    },
3843                    {
3844                        "mount_point": {
3845                            "type": "string",
3846                            "null": false,
3847                            "default": null,
3848                            "autoIncrement": false
3849                        }
3850                    },
3851                    {
3852                        "storage_backend": {
3853                            "type": "string",
3854                            "null": false,
3855                            "default": null,
3856                            "autoIncrement": false
3857                        }
3858                    },
3859                    {
3860                        "auth_backend": {
3861                            "type": "string",
3862                            "null": false,
3863                            "default": null,
3864                            "autoIncrement": false
3865                        }
3866                    },
3867                    {
3868                        "priority": {
3869                            "type": "integer",
3870                            "null": false,
3871                            "default": "100",
3872                            "autoIncrement": false
3873                        }
3874                    },
3875                    {
3876                        "type": {
3877                            "type": "integer",
3878                            "null": false,
3879                            "default": null,
3880                            "autoIncrement": false
3881                        }
3882                    }
3883                ],
3884                "index": [
3885                    {
3886                        "indexName": "PRIMARY",
3887                        "columns": [
3888                            "mount_id"
3889                        ],
3890                        "unique": true
3891                    }
3892                ],
3893                "0": {
3894                    "primaryColumns": [
3895                        "mount_id"
3896                    ]
3897                }
3898            },
3899            "oc_external_options": {
3900                "fields": [
3901                    {
3902                        "option_id": {
3903                            "type": "bigint",
3904                            "null": false,
3905                            "default": null,
3906                            "autoIncrement": true
3907                        }
3908                    },
3909                    {
3910                        "mount_id": {
3911                            "type": "bigint",
3912                            "null": false,
3913                            "default": null,
3914                            "autoIncrement": false
3915                        }
3916                    },
3917                    {
3918                        "key": {
3919                            "type": "string",
3920                            "null": false,
3921                            "default": null,
3922                            "autoIncrement": false
3923                        }
3924                    },
3925                    {
3926                        "value": {
3927                            "type": "string",
3928                            "null": false,
3929                            "default": null,
3930                            "autoIncrement": false
3931                        }
3932                    }
3933                ],
3934                "index": [
3935                    {
3936                        "indexName": "option_mount_key",
3937                        "columns": [
3938                            "mount_id",
3939                            "key"
3940                        ],
3941                        "unique": true
3942                    },
3943                    {
3944                        "indexName": "PRIMARY",
3945                        "columns": [
3946                            "option_id"
3947                        ],
3948                        "unique": true
3949                    },
3950                    {
3951                        "indexName": "option_mount",
3952                        "columns": [
3953                            "mount_id"
3954                        ],
3955                        "unique": false
3956                    }
3957                ],
3958                "0": {
3959                    "primaryColumns": [
3960                        "option_id"
3961                    ]
3962                }
3963            },
3964            "oc_failed_login_attempts": {
3965                "fields": [
3966                    {
3967                        "ip": {
3968                            "type": "string",
3969                            "null": false,
3970                            "default": "",
3971                            "autoIncrement": false
3972                        }
3973                    },
3974                    {
3975                        "uid": {
3976                            "type": "string",
3977                            "null": false,
3978                            "default": "",
3979                            "autoIncrement": false
3980                        }
3981                    },
3982                    {
3983                        "attempted_at": {
3984                            "type": "integer",
3985                            "null": true,
3986                            "default": "0",
3987                            "autoIncrement": false
3988                        }
3989                    }
3990                ],
3991                "index": [
3992                    {
3993                        "indexName": "failed_login_attempted_at",
3994                        "columns": [
3995                            "attempted_at"
3996                        ],
3997                        "unique": false
3998                    },
3999                    {
4000                        "indexName": "failed_login_attempts_ip",
4001                        "columns": [
4002                            "ip"
4003                        ],
4004                        "unique": false
4005                    }
4006                ],
4007                "0": {
4008                    "primaryColumns": []
4009                }
4010            },
4011            "oc_federated_reshares": {
4012                "fields": [
4013                    {
4014                        "share_id": {
4015                            "type": "bigint",
4016                            "null": false,
4017                            "default": null,
4018                            "autoIncrement": false
4019                        }
4020                    },
4021                    {
4022                        "remote_id": {
4023                            "type": "string",
4024                            "null": false,
4025                            "default": null,
4026                            "autoIncrement": false
4027                        }
4028                    }
4029                ],
4030                "index": [
4031                    {
4032                        "indexName": "share_id_index",
4033                        "columns": [
4034                            "share_id"
4035                        ],
4036                        "unique": true
4037                    }
4038                ],
4039                "0": {
4040                    "primaryColumns": []
4041                }
4042            },
4043            "oc_file_locks": {
4044                "fields": [
4045                    {
4046                        "id": {
4047                            "type": "integer",
4048                            "null": false,
4049                            "default": null,
4050                            "autoIncrement": true
4051                        }
4052                    },
4053                    {
4054                        "lock": {
4055                            "type": "integer",
4056                            "null": false,
4057                            "default": "0",
4058                            "autoIncrement": false
4059                        }
4060                    },
4061                    {
4062                        "key": {
4063                            "type": "string",
4064                            "null": false,
4065                            "default": null,
4066                            "autoIncrement": false
4067                        }
4068                    },
4069                    {
4070                        "ttl": {
4071                            "type": "integer",
4072                            "null": false,
4073                            "default": "-1",
4074                            "autoIncrement": false
4075                        }
4076                    }
4077                ],
4078                "index": [
4079                    {
4080                        "indexName": "lock_key_index",
4081                        "columns": [
4082                            "key"
4083                        ],
4084                        "unique": true
4085                    },
4086                    {
4087                        "indexName": "PRIMARY",
4088                        "columns": [
4089                            "id"
4090                        ],
4091                        "unique": true
4092                    },
4093                    {
4094                        "indexName": "lock_ttl_index",
4095                        "columns": [
4096                            "ttl"
4097                        ],
4098                        "unique": false
4099                    }
4100                ],
4101                "0": {
4102                    "primaryColumns": [
4103                        "id"
4104                    ]
4105                }
4106            },
4107            "oc_filecache": {
4108                "fields": [
4109                    {
4110                        "fileid": {
4111                            "type": "bigint",
4112                            "null": false,
4113                            "default": null,
4114                            "autoIncrement": true
4115                        }
4116                    },
4117                    {
4118                        "storage": {
4119                            "type": "integer",
4120                            "null": false,
4121                            "default": "0",
4122                            "autoIncrement": false
4123                        }
4124                    },
4125                    {
4126                        "path": {
4127                            "type": "string",
4128                            "null": true,
4129                            "default": null,
4130                            "autoIncrement": false
4131                        }
4132                    },
4133                    {
4134                        "path_hash": {
4135                            "type": "string",
4136                            "null": false,
4137                            "default": "",
4138                            "autoIncrement": false
4139                        }
4140                    },
4141                    {
4142                        "parent": {
4143                            "type": "bigint",
4144                            "null": false,
4145                            "default": "0",
4146                            "autoIncrement": false
4147                        }
4148                    },
4149                    {
4150                        "name": {
4151                            "type": "string",
4152                            "null": true,
4153                            "default": null,
4154                            "autoIncrement": false
4155                        }
4156                    },
4157                    {
4158                        "mimetype": {
4159                            "type": "integer",
4160                            "null": false,
4161                            "default": "0",
4162                            "autoIncrement": false
4163                        }
4164                    },
4165                    {
4166                        "mimepart": {
4167                            "type": "integer",
4168                            "null": false,
4169                            "default": "0",
4170                            "autoIncrement": false
4171                        }
4172                    },
4173                    {
4174                        "size": {
4175                            "type": "bigint",
4176                            "null": false,
4177                            "default": "0",
4178                            "autoIncrement": false
4179                        }
4180                    },
4181                    {
4182                        "mtime": {
4183                            "type": "bigint",
4184                            "null": false,
4185                            "default": "0",
4186                            "autoIncrement": false
4187                        }
4188                    },
4189                    {
4190                        "storage_mtime": {
4191                            "type": "bigint",
4192                            "null": false,
4193                            "default": "0",
4194                            "autoIncrement": false
4195                        }
4196                    },
4197                    {
4198                        "encrypted": {
4199                            "type": "integer",
4200                            "null": false,
4201                            "default": "0",
4202                            "autoIncrement": false
4203                        }
4204                    },
4205                    {
4206                        "unencrypted_size": {
4207                            "type": "bigint",
4208                            "null": false,
4209                            "default": "0",
4210                            "autoIncrement": false
4211                        }
4212                    },
4213                    {
4214                        "etag": {
4215                            "type": "string",
4216                            "null": true,
4217                            "default": null,
4218                            "autoIncrement": false
4219                        }
4220                    },
4221                    {
4222                        "permissions": {
4223                            "type": "integer",
4224                            "null": true,
4225                            "default": "0",
4226                            "autoIncrement": false
4227                        }
4228                    },
4229                    {
4230                        "checksum": {
4231                            "type": "string",
4232                            "null": true,
4233                            "default": null,
4234                            "autoIncrement": false
4235                        }
4236                    }
4237                ],
4238                "index": [
4239                    {
4240                        "indexName": "fs_storage_path_hash",
4241                        "columns": [
4242                            "storage",
4243                            "path_hash"
4244                        ],
4245                        "unique": true
4246                    },
4247                    {
4248                        "indexName": "PRIMARY",
4249                        "columns": [
4250                            "fileid"
4251                        ],
4252                        "unique": true
4253                    },
4254                    {
4255                        "indexName": "fs_storage_mimepart",
4256                        "columns": [
4257                            "storage",
4258                            "mimepart"
4259                        ],
4260                        "unique": false
4261                    },
4262                    {
4263                        "indexName": "fs_parent_name_hash",
4264                        "columns": [
4265                            "parent",
4266                            "name"
4267                        ],
4268                        "unique": false
4269                    },
4270                    {
4271                        "indexName": "fs_storage_size",
4272                        "columns": [
4273                            "storage",
4274                            "size",
4275                            "fileid"
4276                        ],
4277                        "unique": false
4278                    },
4279                    {
4280                        "indexName": "fs_storage_mimetype",
4281                        "columns": [
4282                            "storage",
4283                            "mimetype"
4284                        ],
4285                        "unique": false
4286                    }
4287                ],
4288                "0": {
4289                    "primaryColumns": [
4290                        "fileid"
4291                    ]
4292                }
4293            },
4294            "oc_files_trash": {
4295                "fields": [
4296                    {
4297                        "auto_id": {
4298                            "type": "bigint",
4299                            "null": false,
4300                            "default": null,
4301                            "autoIncrement": true
4302                        }
4303                    },
4304                    {
4305                        "id": {
4306                            "type": "string",
4307                            "null": false,
4308                            "default": "",
4309                            "autoIncrement": false
4310                        }
4311                    },
4312                    {
4313                        "user": {
4314                            "type": "string",
4315                            "null": false,
4316                            "default": "",
4317                            "autoIncrement": false
4318                        }
4319                    },
4320                    {
4321                        "timestamp": {
4322                            "type": "string",
4323                            "null": false,
4324                            "default": "",
4325                            "autoIncrement": false
4326                        }
4327                    },
4328                    {
4329                        "location": {
4330                            "type": "string",
4331                            "null": false,
4332                            "default": "",
4333                            "autoIncrement": false
4334                        }
4335                    },
4336                    {
4337                        "type": {
4338                            "type": "string",
4339                            "null": true,
4340                            "default": null,
4341                            "autoIncrement": false
4342                        }
4343                    },
4344                    {
4345                        "mime": {
4346                            "type": "string",
4347                            "null": true,
4348                            "default": null,
4349                            "autoIncrement": false
4350                        }
4351                    }
4352                ],
4353                "index": [
4354                    {
4355                        "indexName": "id_index",
4356                        "columns": [
4357                            "id"
4358                        ],
4359                        "unique": false
4360                    },
4361                    {
4362                        "indexName": "PRIMARY",
4363                        "columns": [
4364                            "auto_id"
4365                        ],
4366                        "unique": true
4367                    },
4368                    {
4369                        "indexName": "user_index",
4370                        "columns": [
4371                            "user"
4372                        ],
4373                        "unique": false
4374                    },
4375                    {
4376                        "indexName": "timestamp_index",
4377                        "columns": [
4378                            "timestamp"
4379                        ],
4380                        "unique": false
4381                    }
4382                ],
4383                "0": {
4384                    "primaryColumns": [
4385                        "auto_id"
4386                    ]
4387                }
4388            },
4389            "oc_group_admin": {
4390                "fields": [
4391                    {
4392                        "gid": {
4393                            "type": "string",
4394                            "null": false,
4395                            "default": "",
4396                            "autoIncrement": false
4397                        }
4398                    },
4399                    {
4400                        "uid": {
4401                            "type": "string",
4402                            "null": false,
4403                            "default": "",
4404                            "autoIncrement": false
4405                        }
4406                    }
4407                ],
4408                "index": [
4409                    {
4410                        "indexName": "PRIMARY",
4411                        "columns": [
4412                            "gid",
4413                            "uid"
4414                        ],
4415                        "unique": true
4416                    },
4417                    {
4418                        "indexName": "group_admin_uid",
4419                        "columns": [
4420                            "uid"
4421                        ],
4422                        "unique": false
4423                    }
4424                ],
4425                "0": {
4426                    "primaryColumns": [
4427                        "gid",
4428                        "uid"
4429                    ]
4430                }
4431            },
4432            "oc_group_user": {
4433                "fields": [
4434                    {
4435                        "gid": {
4436                            "type": "string",
4437                            "null": false,
4438                            "default": "",
4439                            "autoIncrement": false
4440                        }
4441                    },
4442                    {
4443                        "uid": {
4444                            "type": "string",
4445                            "null": false,
4446                            "default": "",
4447                            "autoIncrement": false
4448                        }
4449                    }
4450                ],
4451                "index": [
4452                    {
4453                        "indexName": "PRIMARY",
4454                        "columns": [
4455                            "gid",
4456                            "uid"
4457                        ],
4458                        "unique": true
4459                    },
4460                    {
4461                        "indexName": "gu_uid_index",
4462                        "columns": [
4463                            "uid"
4464                        ],
4465                        "unique": false
4466                    }
4467                ],
4468                "0": {
4469                    "primaryColumns": [
4470                        "gid",
4471                        "uid"
4472                    ]
4473                }
4474            },
4475            "oc_groups": {
4476                "fields": [
4477                    {
4478                        "gid": {
4479                            "type": "string",
4480                            "null": false,
4481                            "default": "",
4482                            "autoIncrement": false
4483                        }
4484                    }
4485                ],
4486                "index": [
4487                    {
4488                        "indexName": "PRIMARY",
4489                        "columns": [
4490                            "gid"
4491                        ],
4492                        "unique": true
4493                    }
4494                ],
4495                "0": {
4496                    "primaryColumns": [
4497                        "gid"
4498                    ]
4499                }
4500            },
4501            "oc_jobs": {
4502                "fields": [
4503                    {
4504                        "id": {
4505                            "type": "integer",
4506                            "null": false,
4507                            "default": null,
4508                            "autoIncrement": true
4509                        }
4510                    },
4511                    {
4512                        "class": {
4513                            "type": "string",
4514                            "null": false,
4515                            "default": "",
4516                            "autoIncrement": false
4517                        }
4518                    },
4519                    {
4520                        "argument": {
4521                            "type": "string",
4522                            "null": false,
4523                            "default": "",
4524                            "autoIncrement": false
4525                        }
4526                    },
4527                    {
4528                        "last_run": {
4529                            "type": "integer",
4530                            "null": true,
4531                            "default": "0",
4532                            "autoIncrement": false
4533                        }
4534                    },
4535                    {
4536                        "last_checked": {
4537                            "type": "integer",
4538                            "null": true,
4539                            "default": "0",
4540                            "autoIncrement": false
4541                        }
4542                    },
4543                    {
4544                        "reserved_at": {
4545                            "type": "integer",
4546                            "null": true,
4547                            "default": "0",
4548                            "autoIncrement": false
4549                        }
4550                    },
4551                    {
4552                        "execution_duration": {
4553                            "type": "integer",
4554                            "null": false,
4555                            "default": "-1",
4556                            "autoIncrement": false
4557                        }
4558                    }
4559                ],
4560                "index": [
4561                    {
4562                        "indexName": "job_class_index",
4563                        "columns": [
4564                            "class"
4565                        ],
4566                        "unique": false
4567                    },
4568                    {
4569                        "indexName": "PRIMARY",
4570                        "columns": [
4571                            "id"
4572                        ],
4573                        "unique": true
4574                    }
4575                ],
4576                "0": {
4577                    "primaryColumns": [
4578                        "id"
4579                    ]
4580                }
4581            },
4582            "oc_ldap_group_mapping": {
4583                "fields": [
4584                    {
4585                        "ldap_dn": {
4586                            "type": "string",
4587                            "null": false,
4588                            "default": "",
4589                            "autoIncrement": false
4590                        }
4591                    },
4592                    {
4593                        "owncloud_name": {
4594                            "type": "string",
4595                            "null": false,
4596                            "default": "",
4597                            "autoIncrement": false
4598                        }
4599                    },
4600                    {
4601                        "directory_uuid": {
4602                            "type": "string",
4603                            "null": false,
4604                            "default": "",
4605                            "autoIncrement": false
4606                        }
4607                    }
4608                ],
4609                "index": [
4610                    {
4611                        "indexName": "owncloud_name_groups",
4612                        "columns": [
4613                            "owncloud_name"
4614                        ],
4615                        "unique": true
4616                    },
4617                    {
4618                        "indexName": "PRIMARY",
4619                        "columns": [
4620                            "ldap_dn"
4621                        ],
4622                        "unique": true
4623                    }
4624                ],
4625                "0": {
4626                    "primaryColumns": [
4627                        "ldap_dn"
4628                    ]
4629                }
4630            },
4631            "oc_ldap_group_members": {
4632                "fields": [
4633                    {
4634                        "owncloudname": {
4635                            "type": "string",
4636                            "null": false,
4637                            "default": "",
4638                            "autoIncrement": false
4639                        }
4640                    },
4641                    {
4642                        "owncloudusers": {
4643                            "type": "text",
4644                            "null": false,
4645                            "default": null,
4646                            "autoIncrement": false
4647                        }
4648                    }
4649                ],
4650                "index": [
4651                    {
4652                        "indexName": "PRIMARY",
4653                        "columns": [
4654                            "owncloudname"
4655                        ],
4656                        "unique": true
4657                    }
4658                ],
4659                "0": {
4660                    "primaryColumns": [
4661                        "owncloudname"
4662                    ]
4663                }
4664            },
4665            "oc_ldap_user_mapping": {
4666                "fields": [
4667                    {
4668                        "owncloud_name": {
4669                            "type": "string",
4670                            "null": false,
4671                            "default": "",
4672                            "autoIncrement": false
4673                        }
4674                    },
4675                    {
4676                        "ldap_dn": {
4677                            "type": "string",
4678                            "null": false,
4679                            "default": "",
4680                            "autoIncrement": false
4681                        }
4682                    },
4683                    {
4684                        "directory_uuid": {
4685                            "type": "string",
4686                            "null": false,
4687                            "default": "",
4688                            "autoIncrement": false
4689                        }
4690                    }
4691                ],
4692                "index": [
4693                    {
4694                        "indexName": "ldap_dn_users",
4695                        "columns": [
4696                            "ldap_dn"
4697                        ],
4698                        "unique": true
4699                    },
4700                    {
4701                        "indexName": "PRIMARY",
4702                        "columns": [
4703                            "owncloud_name"
4704                        ],
4705                        "unique": true
4706                    }
4707                ],
4708                "0": {
4709                    "primaryColumns": [
4710                        "owncloud_name"
4711                    ]
4712                }
4713            },
4714            "oc_lucene_status": {
4715                "fields": [
4716                    {
4717                        "fileid": {
4718                            "type": "integer",
4719                            "null": false,
4720                            "default": "0",
4721                            "autoIncrement": false
4722                        }
4723                    },
4724                    {
4725                        "status": {
4726                            "type": "string",
4727                            "null": true,
4728                            "default": null,
4729                            "autoIncrement": false
4730                        }
4731                    }
4732                ],
4733                "index": [
4734                    {
4735                        "indexName": "status_index",
4736                        "columns": [
4737                            "status"
4738                        ],
4739                        "unique": false
4740                    },
4741                    {
4742                        "indexName": "PRIMARY",
4743                        "columns": [
4744                            "fileid"
4745                        ],
4746                        "unique": true
4747                    }
4748                ],
4749                "0": {
4750                    "primaryColumns": [
4751                        "fileid"
4752                    ]
4753                }
4754            },
4755            "oc_migrations": {
4756                "fields": [
4757                    {
4758                        "app": {
4759                            "type": "string",
4760                            "null": false,
4761                            "default": null,
4762                            "autoIncrement": false
4763                        }
4764                    },
4765                    {
4766                        "version": {
4767                            "type": "string",
4768                            "null": false,
4769                            "default": null,
4770                            "autoIncrement": false
4771                        }
4772                    }
4773                ],
4774                "index": [
4775                    {
4776                        "indexName": "PRIMARY",
4777                        "columns": [
4778                            "app",
4779                            "version"
4780                        ],
4781                        "unique": true
4782                    }
4783                ],
4784                "0": {
4785                    "primaryColumns": [
4786                        "app",
4787                        "version"
4788                    ]
4789                }
4790            },
4791            "oc_mimetypes": {
4792                "fields": [
4793                    {
4794                        "id": {
4795                            "type": "integer",
4796                            "null": false,
4797                            "default": null,
4798                            "autoIncrement": true
4799                        }
4800                    },
4801                    {
4802                        "mimetype": {
4803                            "type": "string",
4804                            "null": false,
4805                            "default": "",
4806                            "autoIncrement": false
4807                        }
4808                    }
4809                ],
4810                "index": [
4811                    {
4812                        "indexName": "mimetype_id_index",
4813                        "columns": [
4814                            "mimetype"
4815                        ],
4816                        "unique": true
4817                    },
4818                    {
4819                        "indexName": "PRIMARY",
4820                        "columns": [
4821                            "id"
4822                        ],
4823                        "unique": true
4824                    }
4825                ],
4826                "0": {
4827                    "primaryColumns": [
4828                        "id"
4829                    ]
4830                }
4831            },
4832            "oc_mounts": {
4833                "fields": [
4834                    {
4835                        "id": {
4836                            "type": "integer",
4837                            "null": false,
4838                            "default": null,
4839                            "autoIncrement": true
4840                        }
4841                    },
4842                    {
4843                        "storage_id": {
4844                            "type": "integer",
4845                            "null": false,
4846                            "default": null,
4847                            "autoIncrement": false
4848                        }
4849                    },
4850                    {
4851                        "root_id": {
4852                            "type": "bigint",
4853                            "null": false,
4854                            "default": null,
4855                            "autoIncrement": false
4856                        }
4857                    },
4858                    {
4859                        "user_id": {
4860                            "type": "string",
4861                            "null": false,
4862                            "default": null,
4863                            "autoIncrement": false
4864                        }
4865                    },
4866                    {
4867                        "mount_point": {
4868                            "type": "string",
4869                            "null": false,
4870                            "default": null,
4871                            "autoIncrement": false
4872                        }
4873                    }
4874                ],
4875                "index": [
4876                    {
4877                        "indexName": "mounts_user_root_index",
4878                        "columns": [
4879                            "user_id",
4880                            "root_id"
4881                        ],
4882                        "unique": true
4883                    },
4884                    {
4885                        "indexName": "mounts_storage_index",
4886                        "columns": [
4887                            "storage_id"
4888                        ],
4889                        "unique": false
4890                    },
4891                    {
4892                        "indexName": "PRIMARY",
4893                        "columns": [
4894                            "id"
4895                        ],
4896                        "unique": true
4897                    },
4898                    {
4899                        "indexName": "mounts_user_index",
4900                        "columns": [
4901                            "user_id"
4902                        ],
4903                        "unique": false
4904                    },
4905                    {
4906                        "indexName": "mounts_root_index",
4907                        "columns": [
4908                            "root_id"
4909                        ],
4910                        "unique": false
4911                    }
4912                ],
4913                "0": {
4914                    "primaryColumns": [
4915                        "id"
4916                    ]
4917                }
4918            },
4919            "oc_mozilla_sync_collections": {
4920                "fields": [
4921                    {
4922                        "id": {
4923                            "type": "integer",
4924                            "null": false,
4925                            "default": null,
4926                            "autoIncrement": true
4927                        }
4928                    },
4929                    {
4930                        "userid": {
4931                            "type": "integer",
4932                            "null": false,
4933                            "default": null,
4934                            "autoIncrement": false
4935                        }
4936                    },
4937                    {
4938                        "name": {
4939                            "type": "string",
4940                            "null": false,
4941                            "default": null,
4942                            "autoIncrement": false
4943                        }
4944                    }
4945                ],
4946                "index": [
4947                    {
4948                        "indexName": "mozilla_sync_collections_userid_name",
4949                        "columns": [
4950                            "userid",
4951                            "name"
4952                        ],
4953                        "unique": false
4954                    },
4955                    {
4956                        "indexName": "PRIMARY",
4957                        "columns": [
4958                            "id"
4959                        ],
4960                        "unique": true
4961                    }
4962                ],
4963                "0": {
4964                    "primaryColumns": [
4965                        "id"
4966                    ]
4967                }
4968            },
4969            "oc_mozilla_sync_users": {
4970                "fields": [
4971                    {
4972                        "id": {
4973                            "type": "integer",
4974                            "null": false,
4975                            "default": null,
4976                            "autoIncrement": true
4977                        }
4978                    },
4979                    {
4980                        "username": {
4981                            "type": "string",
4982                            "null": false,
4983                            "default": null,
4984                            "autoIncrement": false
4985                        }
4986                    },
4987                    {
4988                        "sync_user": {
4989                            "type": "string",
4990                            "null": false,
4991                            "default": null,
4992                            "autoIncrement": false
4993                        }
4994                    }
4995                ],
4996                "index": [
4997                    {
4998                        "indexName": "mozilla_sync_users_sync_user",
4999                        "columns": [
5000                            "sync_user"
5001                        ],
5002                        "unique": false
5003                    },
5004                    {
5005                        "indexName": "PRIMARY",
5006                        "columns": [
5007                            "id"
5008                        ],
5009                        "unique": true
5010                    }
5011                ],
5012                "0": {
5013                    "primaryColumns": [
5014                        "id"
5015                    ]
5016                }
5017            },
5018            "oc_mozilla_sync_wbo": {
5019                "fields": [
5020                    {
5021                        "id": {
5022                            "type": "integer",
5023                            "null": false,
5024                            "default": null,
5025                            "autoIncrement": true
5026                        }
5027                    },
5028                    {
5029                        "collectionid": {
5030                            "type": "integer",
5031                            "null": false,
5032                            "default": null,
5033                            "autoIncrement": false
5034                        }
5035                    },
5036                    {
5037                        "name": {
5038                            "type": "string",
5039                            "null": false,
5040                            "default": null,
5041                            "autoIncrement": false
5042                        }
5043                    },
5044                    {
5045                        "parentid": {
5046                            "type": "string",
5047                            "null": true,
5048                            "default": null,
5049                            "autoIncrement": false
5050                        }
5051                    },
5052                    {
5053                        "predecessorid": {
5054                            "type": "string",
5055                            "null": true,
5056                            "default": null,
5057                            "autoIncrement": false
5058                        }
5059                    },
5060                    {
5061                        "sortindex": {
5062                            "type": "integer",
5063                            "null": true,
5064                            "default": null,
5065                            "autoIncrement": false
5066                        }
5067                    },
5068                    {
5069                        "modified": {
5070                            "type": "decimal",
5071                            "null": false,
5072                            "default": "0.00",
5073                            "autoIncrement": false
5074                        }
5075                    },
5076                    {
5077                        "payload": {
5078                            "type": "text",
5079                            "null": false,
5080                            "default": null,
5081                            "autoIncrement": false
5082                        }
5083                    },
5084                    {
5085                        "ttl": {
5086                            "type": "integer",
5087                            "null": true,
5088                            "default": null,
5089                            "autoIncrement": false
5090                        }
5091                    }
5092                ],
5093                "index": [
5094                    {
5095                        "indexName": "mozilla_sync_wbo_collectionid",
5096                        "columns": [
5097                            "collectionid"
5098                        ],
5099                        "unique": false
5100                    },
5101                    {
5102                        "indexName": "mozilla_sync_wbo_coll_name_mod",
5103                        "columns": [
5104                            "collectionid",
5105                            "name",
5106                            "modified"
5107                        ],
5108                        "unique": false
5109                    },
5110                    {
5111                        "indexName": "PRIMARY",
5112                        "columns": [
5113                            "id"
5114                        ],
5115                        "unique": true
5116                    },
5117                    {
5118                        "indexName": "mozilla_sync_wbo_coll_name",
5119                        "columns": [
5120                            "collectionid",
5121                            "name"
5122                        ],
5123                        "unique": false
5124                    }
5125                ],
5126                "0": {
5127                    "primaryColumns": [
5128                        "id"
5129                    ]
5130                }
5131            },
5132            "oc_notifications": {
5133                "fields": [
5134                    {
5135                        "notification_id": {
5136                            "type": "integer",
5137                            "null": false,
5138                            "default": null,
5139                            "autoIncrement": true
5140                        }
5141                    },
5142                    {
5143                        "app": {
5144                            "type": "string",
5145                            "null": false,
5146                            "default": null,
5147                            "autoIncrement": false
5148                        }
5149                    },
5150                    {
5151                        "user": {
5152                            "type": "string",
5153                            "null": false,
5154                            "default": null,
5155                            "autoIncrement": false
5156                        }
5157                    },
5158                    {
5159                        "timestamp": {
5160                            "type": "integer",
5161                            "null": false,
5162                            "default": "0",
5163                            "autoIncrement": false
5164                        }
5165                    },
5166                    {
5167                        "object_type": {
5168                            "type": "string",
5169                            "null": false,
5170                            "default": null,
5171                            "autoIncrement": false
5172                        }
5173                    },
5174                    {
5175                        "object_id": {
5176                            "type": "string",
5177                            "null": false,
5178                            "default": null,
5179                            "autoIncrement": false
5180                        }
5181                    },
5182                    {
5183                        "subject": {
5184                            "type": "string",
5185                            "null": false,
5186                            "default": null,
5187                            "autoIncrement": false
5188                        }
5189                    },
5190                    {
5191                        "subject_parameters": {
5192                            "type": "text",
5193                            "null": true,
5194                            "default": null,
5195                            "autoIncrement": false
5196                        }
5197                    },
5198                    {
5199                        "message": {
5200                            "type": "string",
5201                            "null": true,
5202                            "default": null,
5203                            "autoIncrement": false
5204                        }
5205                    },
5206                    {
5207                        "message_parameters": {
5208                            "type": "text",
5209                            "null": true,
5210                            "default": null,
5211                            "autoIncrement": false
5212                        }
5213                    },
5214                    {
5215                        "link": {
5216                            "type": "string",
5217                            "null": true,
5218                            "default": null,
5219                            "autoIncrement": false
5220                        }
5221                    },
5222                    {
5223                        "actions": {
5224                            "type": "text",
5225                            "null": true,
5226                            "default": null,
5227                            "autoIncrement": false
5228                        }
5229                    },
5230                    {
5231                        "icon": {
5232                            "type": "string",
5233                            "null": true,
5234                            "default": null,
5235                            "autoIncrement": false
5236                        }
5237                    }
5238                ],
5239                "index": [
5240                    {
5241                        "indexName": "oc_notifications_app",
5242                        "columns": [
5243                            "app"
5244                        ],
5245                        "unique": false
5246                    },
5247                    {
5248                        "indexName": "oc_notifications_object",
5249                        "columns": [
5250                            "object_type",
5251                            "object_id"
5252                        ],
5253                        "unique": false
5254                    },
5255                    {
5256                        "indexName": "PRIMARY",
5257                        "columns": [
5258                            "notification_id"
5259                        ],
5260                        "unique": true
5261                    },
5262                    {
5263                        "indexName": "oc_notifications_timestamp",
5264                        "columns": [
5265                            "timestamp"
5266                        ],
5267                        "unique": false
5268                    },
5269                    {
5270                        "indexName": "oc_notifications_user",
5271                        "columns": [
5272                            "user"
5273                        ],
5274                        "unique": false
5275                    }
5276                ],
5277                "0": {
5278                    "primaryColumns": [
5279                        "notification_id"
5280                    ]
5281                }
5282            },
5283            "oc_persistent_locks": {
5284                "fields": [
5285                    {
5286                        "id": {
5287                            "type": "bigint",
5288                            "null": false,
5289                            "default": null,
5290                            "autoIncrement": true
5291                        }
5292                    },
5293                    {
5294                        "file_id": {
5295                            "type": "bigint",
5296                            "null": false,
5297                            "default": null,
5298                            "autoIncrement": false
5299                        }
5300                    },
5301                    {
5302                        "owner_account_id": {
5303                            "type": "bigint",
5304                            "null": true,
5305                            "default": null,
5306                            "autoIncrement": false
5307                        }
5308                    },
5309                    {
5310                        "owner": {
5311                            "type": "string",
5312                            "null": true,
5313                            "default": null,
5314                            "autoIncrement": false
5315                        }
5316                    },
5317                    {
5318                        "timeout": {
5319                            "type": "integer",
5320                            "null": false,
5321                            "default": null,
5322                            "autoIncrement": false
5323                        }
5324                    },
5325                    {
5326                        "created_at": {
5327                            "type": "integer",
5328                            "null": false,
5329                            "default": null,
5330                            "autoIncrement": false
5331                        }
5332                    },
5333                    {
5334                        "token": {
5335                            "type": "string",
5336                            "null": false,
5337                            "default": null,
5338                            "autoIncrement": false
5339                        }
5340                    },
5341                    {
5342                        "token_hash": {
5343                            "type": "string",
5344                            "null": false,
5345                            "default": null,
5346                            "autoIncrement": false
5347                        }
5348                    },
5349                    {
5350                        "scope": {
5351                            "type": "smallint",
5352                            "null": false,
5353                            "default": null,
5354                            "autoIncrement": false
5355                        }
5356                    },
5357                    {
5358                        "depth": {
5359                            "type": "smallint",
5360                            "null": false,
5361                            "default": null,
5362                            "autoIncrement": false
5363                        }
5364                    }
5365                ],
5366                "index": [
5367                    {
5368                        "indexName": "UNIQ_F0C3D55BB3BC57DA",
5369                        "columns": [
5370                            "token_hash"
5371                        ],
5372                        "unique": true
5373                    },
5374                    {
5375                        "indexName": "PRIMARY",
5376                        "columns": [
5377                            "id"
5378                        ],
5379                        "unique": true
5380                    },
5381                    {
5382                        "indexName": "IDX_F0C3D55BC901C6FF",
5383                        "columns": [
5384                            "owner_account_id"
5385                        ],
5386                        "unique": false
5387                    },
5388                    {
5389                        "indexName": "IDX_F0C3D55B93CB796C",
5390                        "columns": [
5391                            "file_id"
5392                        ],
5393                        "unique": false
5394                    }
5395                ],
5396                "0": {
5397                    "primaryColumns": [
5398                        "id"
5399                    ]
5400                }
5401            },
5402            "oc_preferences": {
5403                "fields": [
5404                    {
5405                        "userid": {
5406                            "type": "string",
5407                            "null": false,
5408                            "default": "",
5409                            "autoIncrement": false
5410                        }
5411                    },
5412                    {
5413                        "appid": {
5414                            "type": "string",
5415                            "null": false,
5416                            "default": "",
5417                            "autoIncrement": false
5418                        }
5419                    },
5420                    {
5421                        "configkey": {
5422                            "type": "string",
5423                            "null": false,
5424                            "default": "",
5425                            "autoIncrement": false
5426                        }
5427                    },
5428                    {
5429                        "configvalue": {
5430                            "type": "text",
5431                            "null": true,
5432                            "default": null,
5433                            "autoIncrement": false
5434                        }
5435                    }
5436                ],
5437                "index": [
5438                    {
5439                        "indexName": "PRIMARY",
5440                        "columns": [
5441                            "userid",
5442                            "appid",
5443                            "configkey"
5444                        ],
5445                        "unique": true
5446                    }
5447                ],
5448                "0": {
5449                    "primaryColumns": [
5450                        "userid",
5451                        "appid",
5452                        "configkey"
5453                    ]
5454                }
5455            },
5456            "oc_privatedata": {
5457                "fields": [
5458                    {
5459                        "keyid": {
5460                            "type": "integer",
5461                            "null": false,
5462                            "default": null,
5463                            "autoIncrement": true
5464                        }
5465                    },
5466                    {
5467                        "user": {
5468                            "type": "string",
5469                            "null": false,
5470                            "default": "",
5471                            "autoIncrement": false
5472                        }
5473                    },
5474                    {
5475                        "app": {
5476                            "type": "string",
5477                            "null": false,
5478                            "default": "",
5479                            "autoIncrement": false
5480                        }
5481                    },
5482                    {
5483                        "key": {
5484                            "type": "string",
5485                            "null": false,
5486                            "default": "",
5487                            "autoIncrement": false
5488                        }
5489                    },
5490                    {
5491                        "value": {
5492                            "type": "string",
5493                            "null": false,
5494                            "default": "",
5495                            "autoIncrement": false
5496                        }
5497                    }
5498                ],
5499                "index": [
5500                    {
5501                        "indexName": "PRIMARY",
5502                        "columns": [
5503                            "keyid"
5504                        ],
5505                        "unique": true
5506                    }
5507                ],
5508                "0": {
5509                    "primaryColumns": [
5510                        "keyid"
5511                    ]
5512                }
5513            },
5514            "oc_properties": {
5515                "fields": [
5516                    {
5517                        "id": {
5518                            "type": "bigint",
5519                            "null": false,
5520                            "default": null,
5521                            "autoIncrement": true
5522                        }
5523                    },
5524                    {
5525                        "propertyname": {
5526                            "type": "string",
5527                            "null": false,
5528                            "default": "",
5529                            "autoIncrement": false
5530                        }
5531                    },
5532                    {
5533                        "propertyvalue": {
5534                            "type": "string",
5535                            "null": false,
5536                            "default": null,
5537                            "autoIncrement": false
5538                        }
5539                    },
5540                    {
5541                        "fileid": {
5542                            "type": "bigint",
5543                            "null": false,
5544                            "default": null,
5545                            "autoIncrement": false
5546                        }
5547                    }
5548                ],
5549                "index": [
5550                    {
5551                        "indexName": "fileid_index",
5552                        "columns": [
5553                            "fileid"
5554                        ],
5555                        "unique": false
5556                    },
5557                    {
5558                        "indexName": "PRIMARY",
5559                        "columns": [
5560                            "id"
5561                        ],
5562                        "unique": true
5563                    }
5564                ],
5565                "0": {
5566                    "primaryColumns": [
5567                        "id"
5568                    ]
5569                }
5570            },
5571            "oc_schedulingobjects": {
5572                "fields": [
5573                    {
5574                        "id": {
5575                            "type": "bigint",
5576                            "null": false,
5577                            "default": null,
5578                            "autoIncrement": true
5579                        }
5580                    },
5581                    {
5582                        "principaluri": {
5583                            "type": "string",
5584                            "null": true,
5585                            "default": null,
5586                            "autoIncrement": false
5587                        }
5588                    },
5589                    {
5590                        "calendardata": {
5591                            "type": "blob",
5592                            "null": true,
5593                            "default": null,
5594                            "autoIncrement": false
5595                        }
5596                    },
5597                    {
5598                        "uri": {
5599                            "type": "string",
5600                            "null": true,
5601                            "default": null,
5602                            "autoIncrement": false
5603                        }
5604                    },
5605                    {
5606                        "lastmodified": {
5607                            "type": "integer",
5608                            "null": true,
5609                            "default": null,
5610                            "autoIncrement": false
5611                        }
5612                    },
5613                    {
5614                        "etag": {
5615                            "type": "string",
5616                            "null": true,
5617                            "default": null,
5618                            "autoIncrement": false
5619                        }
5620                    },
5621                    {
5622                        "size": {
5623                            "type": "bigint",
5624                            "null": false,
5625                            "default": null,
5626                            "autoIncrement": false
5627                        }
5628                    }
5629                ],
5630                "index": [
5631                    {
5632                        "indexName": "PRIMARY",
5633                        "columns": [
5634                            "id"
5635                        ],
5636                        "unique": true
5637                    }
5638                ],
5639                "0": {
5640                    "primaryColumns": [
5641                        "id"
5642                    ]
5643                }
5644            },
5645            "oc_share": {
5646                "fields": [
5647                    {
5648                        "id": {
5649                            "type": "integer",
5650                            "null": false,
5651                            "default": null,
5652                            "autoIncrement": true
5653                        }
5654                    },
5655                    {
5656                        "share_type": {
5657                            "type": "smallint",
5658                            "null": false,
5659                            "default": "0",
5660                            "autoIncrement": false
5661                        }
5662                    },
5663                    {
5664                        "share_with": {
5665                            "type": "string",
5666                            "null": true,
5667                            "default": null,
5668                            "autoIncrement": false
5669                        }
5670                    },
5671                    {
5672                        "uid_owner": {
5673                            "type": "string",
5674                            "null": false,
5675                            "default": "",
5676                            "autoIncrement": false
5677                        }
5678                    },
5679                    {
5680                        "parent": {
5681                            "type": "integer",
5682                            "null": true,
5683                            "default": null,
5684                            "autoIncrement": false
5685                        }
5686                    },
5687                    {
5688                        "item_type": {
5689                            "type": "string",
5690                            "null": false,
5691                            "default": "",
5692                            "autoIncrement": false
5693                        }
5694                    },
5695                    {
5696                        "item_source": {
5697                            "type": "string",
5698                            "null": true,
5699                            "default": null,
5700                            "autoIncrement": false
5701                        }
5702                    },
5703                    {
5704                        "item_target": {
5705                            "type": "string",
5706                            "null": true,
5707                            "default": null,
5708                            "autoIncrement": false
5709                        }
5710                    },
5711                    {
5712                        "file_source": {
5713                            "type": "bigint",
5714                            "null": true,
5715                            "default": null,
5716                            "autoIncrement": false
5717                        }
5718                    },
5719                    {
5720                        "file_target": {
5721                            "type": "string",
5722                            "null": true,
5723                            "default": null,
5724                            "autoIncrement": false
5725                        }
5726                    },
5727                    {
5728                        "permissions": {
5729                            "type": "smallint",
5730                            "null": false,
5731                            "default": "0",
5732                            "autoIncrement": false
5733                        }
5734                    },
5735                    {
5736                        "stime": {
5737                            "type": "bigint",
5738                            "null": false,
5739                            "default": "0",
5740                            "autoIncrement": false
5741                        }
5742                    },
5743                    {
5744                        "accepted": {
5745                            "type": "smallint",
5746                            "null": false,
5747                            "default": "0",
5748                            "autoIncrement": false
5749                        }
5750                    },
5751                    {
5752                        "expiration": {
5753                            "type": "datetime",
5754                            "null": true,
5755                            "default": null,
5756                            "autoIncrement": false
5757                        }
5758                    },
5759                    {
5760                        "token": {
5761                            "type": "string",
5762                            "null": true,
5763                            "default": null,
5764                            "autoIncrement": false
5765                        }
5766                    },
5767                    {
5768                        "mail_send": {
5769                            "type": "smallint",
5770                            "null": false,
5771                            "default": "0",
5772                            "autoIncrement": false
5773                        }
5774                    },
5775                    {
5776                        "uid_initiator": {
5777                            "type": "string",
5778                            "null": true,
5779                            "default": null,
5780                            "autoIncrement": false
5781                        }
5782                    },
5783                    {
5784                        "share_name": {
5785                            "type": "string",
5786                            "null": true,
5787                            "default": null,
5788                            "autoIncrement": false
5789                        }
5790                    },
5791                    {
5792                        "attributes": {
5793                            "type": "text",
5794                            "null": true,
5795                            "default": null,
5796                            "autoIncrement": false
5797                        }
5798                    }
5799                ],
5800                "index": [
5801                    {
5802                        "indexName": "item_share_type_index",
5803                        "columns": [
5804                            "item_type",
5805                            "share_type"
5806                        ],
5807                        "unique": false
5808                    },
5809                    {
5810                        "indexName": "token_index",
5811                        "columns": [
5812                            "token"
5813                        ],
5814                        "unique": false
5815                    },
5816                    {
5817                        "indexName": "PRIMARY",
5818                        "columns": [
5819                            "id"
5820                        ],
5821                        "unique": true
5822                    },
5823                    {
5824                        "indexName": "item_source_type_index",
5825                        "columns": [
5826                            "item_source",
5827                            "share_type",
5828                            "item_type"
5829                        ],
5830                        "unique": false
5831                    },
5832                    {
5833                        "indexName": "file_source_index",
5834                        "columns": [
5835                            "file_source"
5836                        ],
5837                        "unique": false
5838                    },
5839                    {
5840                        "indexName": "item_source_index",
5841                        "columns": [
5842                            "item_source"
5843                        ],
5844                        "unique": false
5845                    },
5846                    {
5847                        "indexName": "share_with_index",
5848                        "columns": [
5849                            "share_with"
5850                        ],
5851                        "unique": false
5852                    }
5853                ],
5854                "0": {
5855                    "primaryColumns": [
5856                        "id"
5857                    ]
5858                }
5859            },
5860            "oc_share_external": {
5861                "fields": [
5862                    {
5863                        "id": {
5864                            "type": "bigint",
5865                            "null": false,
5866                            "default": null,
5867                            "autoIncrement": true
5868                        }
5869                    },
5870                    {
5871                        "remote": {
5872                            "type": "string",
5873                            "null": false,
5874                            "default": null,
5875                            "autoIncrement": false
5876                        }
5877                    },
5878                    {
5879                        "share_token": {
5880                            "type": "string",
5881                            "null": false,
5882                            "default": null,
5883                            "autoIncrement": false
5884                        }
5885                    },
5886                    {
5887                        "password": {
5888                            "type": "string",
5889                            "null": true,
5890                            "default": null,
5891                            "autoIncrement": false
5892                        }
5893                    },
5894                    {
5895                        "name": {
5896                            "type": "string",
5897                            "null": false,
5898                            "default": null,
5899                            "autoIncrement": false
5900                        }
5901                    },
5902                    {
5903                        "owner": {
5904                            "type": "string",
5905                            "null": false,
5906                            "default": null,
5907                            "autoIncrement": false
5908                        }
5909                    },
5910                    {
5911                        "user": {
5912                            "type": "string",
5913                            "null": false,
5914                            "default": null,
5915                            "autoIncrement": false
5916                        }
5917                    },
5918                    {
5919                        "mountpoint": {
5920                            "type": "string",
5921                            "null": false,
5922                            "default": null,
5923                            "autoIncrement": false
5924                        }
5925                    },
5926                    {
5927                        "mountpoint_hash": {
5928                            "type": "string",
5929                            "null": false,
5930                            "default": null,
5931                            "autoIncrement": false
5932                        }
5933                    },
5934                    {
5935                        "remote_id": {
5936                            "type": "string",
5937                            "null": false,
5938                            "default": "-1",
5939                            "autoIncrement": false
5940                        }
5941                    },
5942                    {
5943                        "accepted": {
5944                            "type": "integer",
5945                            "null": false,
5946                            "default": "0",
5947                            "autoIncrement": false
5948                        }
5949                    }
5950                ],
5951                "index": [
5952                    {
5953                        "indexName": "sh_external_mp",
5954                        "columns": [
5955                            "user",
5956                            "mountpoint_hash"
5957                        ],
5958                        "unique": true
5959                    },
5960                    {
5961                        "indexName": "PRIMARY",
5962                        "columns": [
5963                            "id"
5964                        ],
5965                        "unique": true
5966                    },
5967                    {
5968                        "indexName": "sh_external_user",
5969                        "columns": [
5970                            "user"
5971                        ],
5972                        "unique": false
5973                    }
5974                ],
5975                "0": {
5976                    "primaryColumns": [
5977                        "id"
5978                    ]
5979                }
5980            },
5981            "oc_storages": {
5982                "fields": [
5983                    {
5984                        "numeric_id": {
5985                            "type": "integer",
5986                            "null": false,
5987                            "default": null,
5988                            "autoIncrement": true
5989                        }
5990                    },
5991                    {
5992                        "id": {
5993                            "type": "string",
5994                            "null": true,
5995                            "default": null,
5996                            "autoIncrement": false
5997                        }
5998                    },
5999                    {
6000                        "available": {
6001                            "type": "integer",
6002                            "null": false,
6003                            "default": "1",
6004                            "autoIncrement": false
6005                        }
6006                    },
6007                    {
6008                        "last_checked": {
6009                            "type": "integer",
6010                            "null": true,
6011                            "default": null,
6012                            "autoIncrement": false
6013                        }
6014                    }
6015                ],
6016                "index": [
6017                    {
6018                        "indexName": "storages_id_index",
6019                        "columns": [
6020                            "id"
6021                        ],
6022                        "unique": true
6023                    },
6024                    {
6025                        "indexName": "PRIMARY",
6026                        "columns": [
6027                            "numeric_id"
6028                        ],
6029                        "unique": true
6030                    }
6031                ],
6032                "0": {
6033                    "primaryColumns": [
6034                        "numeric_id"
6035                    ]
6036                }
6037            },
6038            "oc_systemtag": {
6039                "fields": [
6040                    {
6041                        "id": {
6042                            "type": "integer",
6043                            "null": false,
6044                            "default": null,
6045                            "autoIncrement": true
6046                        }
6047                    },
6048                    {
6049                        "name": {
6050                            "type": "string",
6051                            "null": false,
6052                            "default": "",
6053                            "autoIncrement": false
6054                        }
6055                    },
6056                    {
6057                        "visibility": {
6058                            "type": "smallint",
6059                            "null": false,
6060                            "default": "1",
6061                            "autoIncrement": false
6062                        }
6063                    },
6064                    {
6065                        "editable": {
6066                            "type": "smallint",
6067                            "null": false,
6068                            "default": "1",
6069                            "autoIncrement": false
6070                        }
6071                    },
6072                    {
6073                        "assignable": {
6074                            "type": "integer",
6075                            "null": false,
6076                            "default": "0",
6077                            "autoIncrement": false
6078                        }
6079                    }
6080                ],
6081                "index": [
6082                    {
6083                        "indexName": "tag_ident",
6084                        "columns": [
6085                            "name",
6086                            "visibility",
6087                            "editable",
6088                            "assignable"
6089                        ],
6090                        "unique": true
6091                    },
6092                    {
6093                        "indexName": "PRIMARY",
6094                        "columns": [
6095                            "id"
6096                        ],
6097                        "unique": true
6098                    }
6099                ],
6100                "0": {
6101                    "primaryColumns": [
6102                        "id"
6103                    ]
6104                }
6105            },
6106            "oc_systemtag_group": {
6107                "fields": [
6108                    {
6109                        "systemtagid": {
6110                            "type": "integer",
6111                            "null": false,
6112                            "default": "0",
6113                            "autoIncrement": false
6114                        }
6115                    },
6116                    {
6117                        "gid": {
6118                            "type": "string",
6119                            "null": false,
6120                            "default": null,
6121                            "autoIncrement": false
6122                        }
6123                    }
6124                ],
6125                "index": [
6126                    {
6127                        "indexName": "PRIMARY",
6128                        "columns": [
6129                            "gid",
6130                            "systemtagid"
6131                        ],
6132                        "unique": true
6133                    }
6134                ],
6135                "0": {
6136                    "primaryColumns": [
6137                        "gid",
6138                        "systemtagid"
6139                    ]
6140                }
6141            },
6142            "oc_systemtag_object_mapping": {
6143                "fields": [
6144                    {
6145                        "objectid": {
6146                            "type": "string",
6147                            "null": false,
6148                            "default": "",
6149                            "autoIncrement": false
6150                        }
6151                    },
6152                    {
6153                        "objecttype": {
6154                            "type": "string",
6155                            "null": false,
6156                            "default": "",
6157                            "autoIncrement": false
6158                        }
6159                    },
6160                    {
6161                        "systemtagid": {
6162                            "type": "integer",
6163                            "null": false,
6164                            "default": "0",
6165                            "autoIncrement": false
6166                        }
6167                    }
6168                ],
6169                "index": [
6170                    {
6171                        "indexName": "mapping",
6172                        "columns": [
6173                            "objecttype",
6174                            "objectid",
6175                            "systemtagid"
6176                        ],
6177                        "unique": true
6178                    }
6179                ],
6180                "0": {
6181                    "primaryColumns": []
6182                }
6183            },
6184            "oc_trusted_servers": {
6185                "fields": [
6186                    {
6187                        "id": {
6188                            "type": "integer",
6189                            "null": false,
6190                            "default": null,
6191                            "autoIncrement": true
6192                        }
6193                    },
6194                    {
6195                        "url": {
6196                            "type": "string",
6197                            "null": false,
6198                            "default": null,
6199                            "autoIncrement": false
6200                        }
6201                    },
6202                    {
6203                        "url_hash": {
6204                            "type": "string",
6205                            "null": false,
6206                            "default": "",
6207                            "autoIncrement": false
6208                        }
6209                    },
6210                    {
6211                        "token": {
6212                            "type": "string",
6213                            "null": true,
6214                            "default": null,
6215                            "autoIncrement": false
6216                        }
6217                    },
6218                    {
6219                        "shared_secret": {
6220                            "type": "string",
6221                            "null": true,
6222                            "default": null,
6223                            "autoIncrement": false
6224                        }
6225                    },
6226                    {
6227                        "status": {
6228                            "type": "integer",
6229                            "null": false,
6230                            "default": "2",
6231                            "autoIncrement": false
6232                        }
6233                    },
6234                    {
6235                        "sync_token": {
6236                            "type": "string",
6237                            "null": true,
6238                            "default": null,
6239                            "autoIncrement": false
6240                        }
6241                    }
6242                ],
6243                "index": [
6244                    {
6245                        "indexName": "url_hash",
6246                        "columns": [
6247                            "url_hash"
6248                        ],
6249                        "unique": true
6250                    },
6251                    {
6252                        "indexName": "PRIMARY",
6253                        "columns": [
6254                            "id"
6255                        ],
6256                        "unique": true
6257                    }
6258                ],
6259                "0": {
6260                    "primaryColumns": [
6261                        "id"
6262                    ]
6263                }
6264            },
6265            "oc_users": {
6266                "fields": [
6267                    {
6268                        "uid": {
6269                            "type": "string",
6270                            "null": false,
6271                            "default": "",
6272                            "autoIncrement": false
6273                        }
6274                    },
6275                    {
6276                        "displayname": {
6277                            "type": "string",
6278                            "null": true,
6279                            "default": null,
6280                            "autoIncrement": false
6281                        }
6282                    },
6283                    {
6284                        "password": {
6285                            "type": "string",
6286                            "null": false,
6287                            "default": "",
6288                            "autoIncrement": false
6289                        }
6290                    }
6291                ],
6292                "index": [
6293                    {
6294                        "indexName": "PRIMARY",
6295                        "columns": [
6296                            "uid"
6297                        ],
6298                        "unique": true
6299                    }
6300                ],
6301                "0": {
6302                    "primaryColumns": [
6303                        "uid"
6304                    ]
6305                }
6306            },
6307            "oc_users_external": {
6308                "fields": [
6309                    {
6310                        "backend": {
6311                            "type": "string",
6312                            "null": false,
6313                            "default": "",
6314                            "autoIncrement": false
6315                        }
6316                    },
6317                    {
6318                        "uid": {
6319                            "type": "string",
6320                            "null": false,
6321                            "default": "",
6322                            "autoIncrement": false
6323                        }
6324                    },
6325                    {
6326                        "displayname": {
6327                            "type": "string",
6328                            "null": true,
6329                            "default": null,
6330                            "autoIncrement": false
6331                        }
6332                    }
6333                ],
6334                "index": [
6335                    {
6336                        "indexName": "PRIMARY",
6337                        "columns": [
6338                            "uid",
6339                            "backend"
6340                        ],
6341                        "unique": true
6342                    }
6343                ],
6344                "0": {
6345                    "primaryColumns": [
6346                        "uid",
6347                        "backend"
6348                    ]
6349                }
6350            },
6351            "oc_vcategory": {
6352                "fields": [
6353                    {
6354                        "id": {
6355                            "type": "integer",
6356                            "null": false,
6357                            "default": null,
6358                            "autoIncrement": true
6359                        }
6360                    },
6361                    {
6362                        "uid": {
6363                            "type": "string",
6364                            "null": false,
6365                            "default": "",
6366                            "autoIncrement": false
6367                        }
6368                    },
6369                    {
6370                        "type": {
6371                            "type": "string",
6372                            "null": false,
6373                            "default": "",
6374                            "autoIncrement": false
6375                        }
6376                    },
6377                    {
6378                        "category": {
6379                            "type": "string",
6380                            "null": false,
6381                            "default": "",
6382                            "autoIncrement": false
6383                        }
6384                    }
6385                ],
6386                "index": [
6387                    {
6388                        "indexName": "uid_index",
6389                        "columns": [
6390                            "uid"
6391                        ],
6392                        "unique": false
6393                    },
6394                    {
6395                        "indexName": "PRIMARY",
6396                        "columns": [
6397                            "id"
6398                        ],
6399                        "unique": true
6400                    },
6401                    {
6402                        "indexName": "category_index",
6403                        "columns": [
6404                            "category"
6405                        ],
6406                        "unique": false
6407                    },
6408                    {
6409                        "indexName": "type_index",
6410                        "columns": [
6411                            "type"
6412                        ],
6413                        "unique": false
6414                    }
6415                ],
6416                "0": {
6417                    "primaryColumns": [
6418                        "id"
6419                    ]
6420                }
6421            },
6422            "oc_vcategory_to_object": {
6423                "fields": [
6424                    {
6425                        "objid": {
6426                            "type": "bigint",
6427                            "null": false,
6428                            "default": "0",
6429                            "autoIncrement": false
6430                        }
6431                    },
6432                    {
6433                        "categoryid": {
6434                            "type": "integer",
6435                            "null": false,
6436                            "default": "0",
6437                            "autoIncrement": false
6438                        }
6439                    },
6440                    {
6441                        "type": {
6442                            "type": "string",
6443                            "null": false,
6444                            "default": "",
6445                            "autoIncrement": false
6446                        }
6447                    }
6448                ],
6449                "index": [
6450                    {
6451                        "indexName": "PRIMARY",
6452                        "columns": [
6453                            "categoryid",
6454                            "objid",
6455                            "type"
6456                        ],
6457                        "unique": true
6458                    },
6459                    {
6460                        "indexName": "vcategory_objectd_index",
6461                        "columns": [
6462                            "objid",
6463                            "type"
6464                        ],
6465                        "unique": false
6466                    }
6467                ],
6468                "0": {
6469                    "primaryColumns": [
6470                        "categoryid",
6471                        "objid",
6472                        "type"
6473                    ]
6474                }
6475            }
6476        }
6477    },
6478    "migrations": [
6479        {
6480            "app": "activity",
6481            "version": "20161122085340"
6482        },
6483        {
6484            "app": "activity",
6485            "version": "20161122092159"
6486        },
6487        {
6488            "app": "activity",
6489            "version": "20170131134507"
6490        },
6491        {
6492            "app": "activity",
6493            "version": "20170724182159"
6494        },
6495        {
6496            "app": "brute_force_protection",
6497            "version": "20180802194631"
6498        },
6499        {
6500            "app": "core",
6501            "version": "20170101010100"
6502        },
6503        {
6504            "app": "core",
6505            "version": "20170101215145"
6506        },
6507        {
6508            "app": "core",
6509            "version": "20170111103310"
6510        },
6511        {
6512            "app": "core",
6513            "version": "20170213215145"
6514        },
6515        {
6516            "app": "core",
6517            "version": "20170214112458"
6518        },
6519        {
6520            "app": "core",
6521            "version": "20170221114437"
6522        },
6523        {
6524            "app": "core",
6525            "version": "20170221121536"
6526        },
6527        {
6528            "app": "core",
6529            "version": "20170315173825"
6530        },
6531        {
6532            "app": "core",
6533            "version": "20170320173955"
6534        },
6535        {
6536            "app": "core",
6537            "version": "20170418154659"
6538        },
6539        {
6540            "app": "core",
6541            "version": "20170516100103"
6542        },
6543        {
6544            "app": "core",
6545            "version": "20170526104128"
6546        },
6547        {
6548            "app": "core",
6549            "version": "20170605143658"
6550        },
6551        {
6552            "app": "core",
6553            "version": "20170711191432"
6554        },
6555        {
6556            "app": "core",
6557            "version": "20170804201253"
6558        },
6559        {
6560            "app": "core",
6561            "version": "20170928120000"
6562        },
6563        {
6564            "app": "core",
6565            "version": "20171026130750"
6566        },
6567        {
6568            "app": "core",
6569            "version": "20180123131835"
6570        },
6571        {
6572            "app": "core",
6573            "version": "20180302155233"
6574        },
6575        {
6576            "app": "core",
6577            "version": "20180319102121"
6578        },
6579        {
6580            "app": "core",
6581            "version": "20180607072706"
6582        },
6583        {
6584            "app": "core",
6585            "version": "20181017105216"
6586        },
6587        {
6588            "app": "core",
6589            "version": "20181017120818"
6590        },
6591        {
6592            "app": "core",
6593            "version": "20181113071753"
6594        },
6595        {
6596            "app": "core",
6597            "version": "20181220085457"
6598        },
6599        {
6600            "app": "core",
6601            "version": "20190125162909"
6602        },
6603        {
6604            "app": "dav",
6605            "version": "20170116150538"
6606        },
6607        {
6608            "app": "dav",
6609            "version": "20170116170538"
6610        },
6611        {
6612            "app": "dav",
6613            "version": "20170202213905"
6614        },
6615        {
6616            "app": "dav",
6617            "version": "20170202220512"
6618        },
6619        {
6620            "app": "dav",
6621            "version": "20170427182800"
6622        },
6623        {
6624            "app": "dav",
6625            "version": "20170519091921"
6626        },
6627        {
6628            "app": "dav",
6629            "version": "20170526100342"
6630        },
6631        {
6632            "app": "dav",
6633            "version": "20170711193427"
6634        },
6635        {
6636            "app": "dav",
6637            "version": "20170927201245"
6638        },
6639        {
6640            "app": "dav",
6641            "version": "20180622095921"
6642        },
6643        {
6644            "app": "dav",
6645            "version": "20181115210344"
6646        },
6647        {
6648            "app": "dav",
6649            "version": "20190823065724"
6650        },
6651        {
6652            "app": "federatedfilesharing",
6653            "version": "20170804201125"
6654        },
6655        {
6656            "app": "federatedfilesharing",
6657            "version": "20170804201253"
6658        },
6659        {
6660            "app": "federatedfilesharing",
6661            "version": "20190410160725"
6662        },
6663        {
6664            "app": "files_external",
6665            "version": "20170814051424"
6666        },
6667        {
6668            "app": "files_sharing",
6669            "version": "20170804201125"
6670        },
6671        {
6672            "app": "files_sharing",
6673            "version": "20170804201253"
6674        },
6675        {
6676            "app": "files_sharing",
6677            "version": "20170830112305"
6678        },
6679        {
6680            "app": "files_sharing",
6681            "version": "20171115154900"
6682        },
6683        {
6684            "app": "files_sharing",
6685            "version": "20171215103657"
6686        },
6687        {
6688            "app": "files_sharing",
6689            "version": "20190426123324"
6690        },
6691        {
6692            "app": "files_trashbin",
6693            "version": "20170804201125"
6694        },
6695        {
6696            "app": "files_trashbin",
6697            "version": "20170804201253"
6698        },
6699        {
6700            "app": "notifications",
6701            "version": "20170801085340"
6702        },
6703        {
6704            "app": "notifications",
6705            "version": "20170801152524"
6706        },
6707        {
6708            "app": "notifications",
6709            "version": "20180119080933"
6710        },
6711        {
6712            "app": "notifications",
6713            "version": "20180604132522"
6714        }
6715    ],
6716    "phpinfo": {
6717        "apache2handler": {
6718            "Apache Version": "Apache\/2.4.38 (Debian)",
6719            "Apache API Version": "20120211",
6720            "Server Administrator": "***REMOVED SENSITIVE VALUE***",
6721            "Hostname:Port": "***REMOVED SENSITIVE VALUE***:443",
6722            "User\/Group": "www-data(33)\/33",
6723            "Max Requests": "Per Child: 0 - Keep Alive: on - Max Per Connection: 100",
6724            "Timeouts": "Connection: 300 - Keep-Alive: 5",
6725            "Virtual Server": "Yes",
6726            "Server Root": "\/etc\/apache2",
6727            "Loaded Modules": "core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_filter mod_headers mod_mime prefork mod_negotiation mod_php7 mod_reqtimeout mod_setenvif mod_socache_shmcb mod_ssl mod_status mod_xsendfile",
6728            "engine": "1",
6729            "last_modified": "0",
6730            "xbithack": "0"
6731        },
6732        "Apache Environment": {
6733            "MOD_X_SENDFILE_ENABLED": "1",
6734            "modHeadersAvailable": "true",
6735            "htaccessWorking": "true",
6736            "HTTPS": "on",
6737            "SSL_TLS_SNI": "***REMOVED SENSITIVE VALUE***",
6738            "SSL_SERVER_S_DN_CN": "***REMOVED SENSITIVE VALUE***",
6739            "SSL_SERVER_I_DN_C": "US",
6740            "SSL_SERVER_I_DN_O": "Let s Encrypt",
6741            "SSL_SERVER_I_DN_CN": "Let s Encrypt Authority X3",
6742            "SSL_SERVER_SAN_DNS_0": "***REMOVED SENSITIVE VALUE***",
6743            "SSL_VERSION_INTERFACE": "mod_ssl\/2.4.38",
6744            "SSL_VERSION_LIBRARY": "OpenSSL\/1.1.1d",
6745            "SSL_PROTOCOL": "TLSv1.3",
6746            "SSL_SECURE_RENEG": "false",
6747            "SSL_COMPRESS_METHOD": "NULL",
6748            "SSL_CIPHER": "TLS_AES_256_GCM_SHA384",
6749            "SSL_CIPHER_EXPORT": "false",
6750            "SSL_CIPHER_USEKEYSIZE": "256",
6751            "SSL_CIPHER_ALGKEYSIZE": "256",
6752            "SSL_CLIENT_VERIFY": "NONE",
6753            "SSL_SERVER_M_VERSION": "3",
6754            "SSL_SERVER_M_SERIAL": "***REMOVED SENSITIVE VALUE***",
6755            "SSL_SERVER_V_START": "Mar 28 19:00:29 2020 GMT",
6756            "SSL_SERVER_V_END": "Jun 26 19:00:29 2020 GMT",
6757            "SSL_SERVER_S_DN": "***REMOVED SENSITIVE VALUE***",
6758            "SSL_SERVER_I_DN": "CN=Let s Encrypt Authority X3,O=Let s Encrypt,C=US",
6759            "SSL_SERVER_A_KEY": "rsaEncryption",
6760            "SSL_SERVER_A_SIG": "sha256WithRSAEncryption",
6761            "SSL_SESSION_ID": "***REMOVED SENSITIVE VALUE***",
6762            "SSL_SESSION_RESUMED": "Resumed",
6763            "HTTP_HOST": "***REMOVED SENSITIVE VALUE***",
6764            "HTTP_USER_AGENT": "Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.13; rv:74.0) Gecko\/20100101 Firefox\/74.0",
6765            "HTTP_ACCEPT": "text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/webp,*\/*;q=0.8",
6766            "HTTP_ACCEPT_LANGUAGE": "en-GB,en;q=0.5",
6767            "HTTP_ACCEPT_ENCODING": "gzip, deflate, br",
6768            "HTTP_DNT": "1",
6769            "HTTP_CONNECTION": "keep-alive",
6770            "HTTP_UPGRADE_INSECURE_REQUESTS": "1",
6771            "HTTP_PRAGMA": "no-cache",
6772            "HTTP_CACHE_CONTROL": "no-cache",
6773            "SERVER_SIGNATURE": "***REMOVED SENSITIVE VALUE***",
6774            "SERVER_SOFTWARE": "Apache\/2.4.38 (Debian)",
6775            "SERVER_NAME": "***REMOVED SENSITIVE VALUE***",
6776            "SERVER_ADDR": "***REMOVED SENSITIVE VALUE***",
6777            "SERVER_PORT": "443",
6778            "REMOTE_ADDR": "***REMOVED SENSITIVE VALUE***",
6779            "DOCUMENT_ROOT": "***REMOVED SENSITIVE VALUE***",
6780            "REQUEST_SCHEME": "https",
6781            "CONTEXT_PREFIX": "no value",
6782            "CONTEXT_DOCUMENT_ROOT": "***REMOVED SENSITIVE VALUE***",
6783            "SERVER_ADMIN": "***REMOVED SENSITIVE VALUE***",
6784            "SCRIPT_FILENAME": "***REMOVED SENSITIVE VALUE***\/owncloud\/index.php",
6785            "REMOTE_PORT": "57967",
6786            "GATEWAY_INTERFACE": "CGI\/1.1",
6787            "SERVER_PROTOCOL": "HTTP\/1.1",
6788            "REQUEST_METHOD": "GET",
6789            "QUERY_STRING": "no value",
6790            "REQUEST_URI": "\/owncloud\/index.php\/apps\/configreport\/report",
6791            "SCRIPT_NAME": "\/owncloud\/index.php",
6792            "PATH_INFO": "\/apps\/configreport\/report",
6793            "PATH_TRANSLATED": "***REMOVED SENSITIVE VALUE***\/apps\/configreport\/report"
6794        },
6795        "HTTP Headers Information": {
6796            "HTTP Request": "GET \/owncloud\/index.php\/apps\/configreport\/report HTTP\/1.1",
6797            "Host": "***REMOVED SENSITIVE VALUE***",
6798            "User-Agent": "Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.13; rv:74.0) Gecko\/20100101 Firefox\/74.0",
6799            "Accept": "text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/webp,*\/*;q=0.8",
6800            "Accept-Language": "en-GB,en;q=0.5",
6801            "Accept-Encoding": "gzip, deflate, br",
6802            "DNT": "1",
6803            "Connection": "keep-alive",
6804            "Upgrade-Insecure-Requests": "1",
6805            "Pragma": "no-cache",
6806            "Cache-Control": "no-store, no-cache, must-revalidate",
6807            "Expires": "Thu, 19 Nov 1981 08:52:00 GMT",
6808            "Content-Security-Policy": "default-src self ; script-src self unsafe-eval ; style-src self unsafe-inline ; frame-src *; img-src * data: blob:; font-src self data:; media-src *; connect-src *"
6809        },
6810        "calendar": {
6811            "Calendar support": "enabled"
6812        },
6813        "Core": {
6814            "PHP Version": "7.3.14-1~deb10u1",
6815            "allow_url_fopen": "On",
6816            "allow_url_include": "Off",
6817            "arg_separator.input": "&",
6818            "arg_separator.output": "&",
6819            "auto_append_file": "no value",
6820            "auto_globals_jit": "On",
6821            "auto_prepend_file": "no value",
6822            "browscap": "no value",
6823            "default_charset": "UTF-8",
6824            "default_mimetype": "text\/html",
6825            "disable_classes": "no value",
6826            "disable_functions": "pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,",
6827            "display_errors": "Off",
6828            "display_startup_errors": "Off",
6829            "doc_root": "no value",
6830            "docref_ext": "no value",
6831            "docref_root": "no value",
6832            "enable_dl": "Off",
6833            "enable_post_data_reading": "On",
6834            "error_append_string": "no value",
6835            "error_log": "no value",
6836            "error_prepend_string": "no value",
6837            "error_reporting": [
6838                "32767",
6839                "22527"
6840            ],
6841            "expose_php": "Off",
6842            "extension_dir": "\/usr\/lib\/php\/20180731",
6843            "file_uploads": "On",
6844            "hard_timeout": "2",
6845            "highlight.comment": "#FF8000",
6846            "highlight.default": "#0000BB",
6847            "highlight.html": "#000000",
6848            "highlight.keyword": "#007700",
6849            "highlight.string": "#DD0000",
6850            "html_errors": "On",
6851            "ignore_repeated_errors": "Off",
6852            "ignore_repeated_source": "Off",
6853            "ignore_user_abort": "Off",
6854            "implicit_flush": "Off",
6855            "input_encoding": "no value",
6856            "internal_encoding": "no value",
6857            "log_errors": "On",
6858            "log_errors_max_len": "1024",
6859            "mail.add_x_header": "Off",
6860            "mail.force_extra_parameters": "no value",
6861            "mail.log": "no value",
6862            "max_execution_time": [
6863                "3600",
6864                "30"
6865            ],
6866            "max_file_uploads": "20",
6867            "max_input_nesting_level": "64",
6868            "max_input_time": "60",
6869            "max_input_vars": "1000",
6870            "memory_limit": [
6871                "512M",
6872                "128M"
6873            ],
6874            "open_basedir": "no value",
6875            "output_buffering": [
6876                "0",
6877                "4096"
6878            ],
6879            "output_encoding": "no value",
6880            "output_handler": "no value",
6881            "post_max_size": [
6882                "513M",
6883                "8M"
6884            ],
6885            "precision": "14",
6886            "realpath_cache_size": "4096K",
6887            "realpath_cache_ttl": "120",
6888            "register_argc_argv": "Off",
6889            "report_memleaks": "On",
6890            "report_zend_debug": "On",
6891            "request_order": "GP",
6892            "sendmail_from": "no value",
6893            "sendmail_path": "\/usr\/sbin\/sendmail -t -i ",
6894            "serialize_precision": "-1",
6895            "short_open_tag": "Off",
6896            "SMTP": "localhost",
6897            "smtp_port": "25",
6898            "sys_temp_dir": "no value",
6899            "syslog.facility": "LOG_USER",
6900            "syslog.filter": "no-ctrl",
6901            "syslog.ident": "php",
6902            "track_errors": "Off",
6903            "unserialize_callback_func": "no value",
6904            "upload_max_filesize": [
6905                "513M",
6906                "2M"
6907            ],
6908            "upload_tmp_dir": "no value",
6909            "user_dir": "no value",
6910            "user_ini.cache_ttl": "300",
6911            "user_ini.filename": ".user.ini",
6912            "variables_order": "GPCS",
6913            "xmlrpc_error_number": "0",
6914            "xmlrpc_errors": "Off",
6915            "zend.assertions": "-1",
6916            "zend.detect_unicode": "On",
6917            "zend.enable_gc": "On",
6918            "zend.multibyte": "Off",
6919            "zend.script_encoding": "no value",
6920            "zend.signal_check": "Off"
6921        },
6922        "ctype": {
6923            "ctype functions": "enabled"
6924        },
6925        "curl": {
6926            "cURL support": "enabled",
6927            "cURL Information": "7.64.0",
6928            "Age": "4",
6929            "Features": null,
6930            "AsynchDNS": "Yes",
6931            "CharConv": "No",
6932            "Debug": "No",
6933            "GSS-Negotiate": "No",
6934            "IDN": "Yes",
6935            "IPv6": "Yes",
6936            "krb4": "No",
6937            "Largefile": "Yes",
6938            "libz": "Yes",
6939            "NTLM": "Yes",
6940            "NTLMWB": "Yes",
6941            "SPNEGO": "Yes",
6942            "SSL": "Yes",
6943            "SSPI": "No",
6944            "TLS-SRP": "Yes",
6945            "HTTP2": "Yes",
6946            "GSSAPI": "Yes",
6947            "KERBEROS5": "Yes",
6948            "UNIX_SOCKETS": "Yes",
6949            "PSL": "Yes",
6950            "HTTPS_PROXY": "Yes",
6951            "MULTI_SSL": "No",
6952            "BROTLI": "No",
6953            "Protocols": "dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtmp, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp",
6954            "Host": "arm-unknown-linux-gnueabihf",
6955            "SSL Version": "OpenSSL\/1.1.1d",
6956            "ZLib Version": "1.2.11",
6957            "libSSH Version": "libssh2\/1.8.0",
6958            "curl.cainfo": "no value"
6959        },
6960        "date": {
6961            "date\/time support": "enabled",
6962            "timelib version": "2018.03",
6963            ""Olson" Timezone Database Version": "0.system",
6964            "Timezone Database": "internal",
6965            "Default timezone": "UTC",
6966            "date.default_latitude": "31.7667",
6967            "date.default_longitude": "35.2333",
6968            "date.sunrise_zenith": "90.583333",
6969            "date.sunset_zenith": "90.583333",
6970            "date.timezone": "no value"
6971        },
6972        "dom": {
6973            "DOM\/XML": "enabled",
6974            "DOM\/XML API Version": "20031129",
6975            "libxml Version": "2.9.4",
6976            "HTML Support": "enabled",
6977            "XPath Support": "enabled",
6978            "XPointer Support": "enabled",
6979            "Schema Support": "enabled",
6980            "RelaxNG Support": "enabled"
6981        },
6982        "exif": {
6983            "EXIF Support": "enabled",
6984            "Supported EXIF Version": "0220",
6985            "Supported filetypes": "JPEG, TIFF",
6986            "Multibyte decoding support using mbstring": "enabled",
6987            "Extended EXIF tag formats": "Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson",
6988            "exif.decode_jis_intel": "JIS",
6989            "exif.decode_jis_motorola": "JIS",
6990            "exif.decode_unicode_intel": "UCS-2LE",
6991            "exif.decode_unicode_motorola": "UCS-2BE",
6992            "exif.encode_jis": "no value",
6993            "exif.encode_unicode": "ISO-8859-15"
6994        },
6995        "fileinfo": {
6996            "fileinfo support": "enabled",
6997            "libmagic": "533"
6998        },
6999        "filter": {
7000            "Input Validation and Filtering": "enabled",
7001            "filter.default": "unsafe_raw",
7002            "filter.default_flags": "no value"
7003        },
7004        "ftp": {
7005            "FTP support": "enabled",
7006            "FTPS support": "enabled"
7007        },
7008        "gd": {
7009            "GD Support": "enabled",
7010            "GD headers Version": "2.2.5",
7011            "GD library Version": "2.2.5",
7012            "FreeType Support": "enabled",
7013            "FreeType Linkage": "with freetype",
7014            "FreeType Version": "2.9.1",
7015            "GIF Read Support": "enabled",
7016            "GIF Create Support": "enabled",
7017            "JPEG Support": "enabled",
7018            "libJPEG Version": "6b",
7019            "PNG Support": "enabled",
7020            "libPNG Version": "1.6.36",
7021            "WBMP Support": "enabled",
7022            "XPM Support": "enabled",
7023            "libXpm Version": "30411",
7024            "XBM Support": "enabled",
7025            "WebP Support": "enabled",
7026            "gd.jpeg_ignore_warning": "1"
7027        },
7028        "gettext": {
7029            "GetText Support": "enabled"
7030        },
7031        "hash": {
7032            "hash support": "enabled",
7033            "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 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",
7034            "MHASH support": "Enabled",
7035            "MHASH API Version": "Emulated Support"
7036        },
7037        "iconv": {
7038            "iconv support": "enabled",
7039            "iconv implementation": "glibc",
7040            "iconv library version": "2.28",
7041            "iconv.input_encoding": "no value",
7042            "iconv.internal_encoding": "no value",
7043            "iconv.output_encoding": "no value"
7044        },
7045        "imagick": {
7046            "imagick module version": "3.4.3",
7047            "imagick classes": "Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator, ImagickKernel",
7048            "Imagick compiled with ImageMagick version": "ImageMagick 6.9.10-23 Q16 x86_64 20190101 https:\/\/imagemagick.org",
7049            "Imagick using ImageMagick library version": "ImageMagick 6.9.10-23 Q16 arm 20190101 https:\/\/imagemagick.org",
7050            "ImageMagick copyright": "\u00a9 1999-2019 ImageMagick Studio LLC",
7051            "ImageMagick release date": "20190101",
7052            "ImageMagick number of supported formats:": "232",
7053            "ImageMagick supported formats": "3FR, 3G2, 3GP, AAI, AI, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, 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, MPEG, 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, 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, VIFF, VIPS, VST, WBMP, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV",
7054            "imagick.locale_fix": "0",
7055            "imagick.progress_monitor": "0",
7056            "imagick.skip_version_check": "1"
7057        },
7058        "imap": {
7059            "IMAP c-Client Version": "2007f",
7060            "SSL Support": "enabled",
7061            "Kerberos Support": "enabled",
7062            "imap.enable_insecure_rsh": "Off"
7063        },
7064        "intl": {
7065            "ICU version": "63.1",
7066            "ICU Data version": "63.1",
7067            "ICU TZData version": "2018e",
7068            "ICU Unicode version": "11.0",
7069            "intl.default_locale": "no value",
7070            "intl.error_level": "0",
7071            "intl.use_exceptions": "0"
7072        },
7073        "json": {
7074            "json support": "enabled",
7075            "json version": "1.7.0"
7076        },
7077        "ldap": {
7078            "LDAP Support": "enabled",
7079            "Total Links": "0\/unlimited",
7080            "API Version": "3001",
7081            "Vendor Name": "OpenLDAP",
7082            "Vendor Version": "20447",
7083            "SASL Support": "Enabled",
7084            "ldap.max_links": "Unlimited"
7085        },
7086        "libsmbclient": {
7087            "Version": "0.9.0"
7088        },
7089        "libxml": {
7090            "libXML support": "active",
7091            "libXML Compiled Version": "2.9.4",
7092            "libXML Loaded Version": "20904",
7093            "libXML streams": "enabled"
7094        },
7095        "mbstring": {
7096            "Multibyte Support": "enabled",
7097            "Multibyte string engine": "libmbfl",
7098            "HTTP input encoding translation": "disabled",
7099            "libmbfl version": "1.3.2",
7100            "oniguruma version": "6.9.4",
7101            "Multibyte (japanese) regex support": "enabled",
7102            "Multibyte regex (oniguruma) backtrack check": "On",
7103            "Multibyte regex (oniguruma) version": "6.9.4",
7104            "mbstring.detect_order": "no value",
7105            "mbstring.encoding_translation": "Off",
7106            "mbstring.func_overload": "0",
7107            "mbstring.http_input": "no value",
7108            "mbstring.http_output": "no value",
7109            "mbstring.http_output_conv_mimetypes": "^(text\/|application\/xhtml\\+xml)",
7110            "mbstring.internal_encoding": "no value",
7111            "mbstring.language": "neutral",
7112            "mbstring.regex_stack_limit": "100000",
7113            "mbstring.strict_detection": "Off",
7114            "mbstring.substitute_character": "no value"
7115        },
7116        "mysqli": {
7117            "Client API library version": "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $",
7118            "Active Persistent Links": "0",
7119            "Inactive Persistent Links": "0",
7120            "Active Links": "0",
7121            "mysqli.allow_local_infile": "Off",
7122            "mysqli.allow_persistent": "On",
7123            "mysqli.default_host": "no value",
7124            "mysqli.default_port": "3306",
7125            "mysqli.default_pw": "no value",
7126            "mysqli.default_socket": "no value",
7127            "mysqli.default_user": "no value",
7128            "mysqli.max_links": "Unlimited",
7129            "mysqli.max_persistent": "Unlimited",
7130            "mysqli.reconnect": "Off",
7131            "mysqli.rollback_on_cached_plink": "Off"
7132        },
7133        "mysqlnd": {
7134            "Version": "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $",
7135            "Compression": "supported",
7136            "core SSL": "supported",
7137            "extended SSL": "supported",
7138            "Command buffer size": "4096",
7139            "Read buffer size": "32768",
7140            "Read timeout": "86400",
7141            "Collecting statistics": "Yes",
7142            "Collecting memory statistics": "No",
7143            "Tracing": "n\/a",
7144            "Loaded plugins": "mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password",
7145            "API Extensions": "mysqli,pdo_mysql",
7146            "bytes_sent": "130495",
7147            "bytes_received": "414143",
7148            "packets_sent": "982",
7149            "packets_received": "8346",
7150            "protocol_overhead_in": "33384",
7151            "protocol_overhead_out": "3928",
7152            "bytes_received_ok_packet": "0",
7153            "bytes_received_eof_packet": "0",
7154            "bytes_received_rset_header_packet": "3582",
7155            "bytes_received_rset_field_meta_packet": "0",
7156            "bytes_received_rset_row_packet": "3306",
7157            "bytes_received_prepare_response_packet": "234499",
7158            "bytes_received_change_user_packet": "168828",
7159            "packets_sent_command": "474",
7160            "packets_received_ok": "0",
7161            "packets_received_eof": "0",
7162            "packets_received_rset_header": "398",
7163            "packets_received_rset_field_meta": "0",
7164            "packets_received_rset_row": "458",
7165            "packets_received_prepare_response": "2941",
7166            "packets_received_change_user": "4515",
7167            "result_set_queries": "398",
7168            "non_result_set_queries": "60",
7169            "no_index_used": "299",
7170            "bad_index_used": "0",
7171            "slow_queries": "0",
7172            "buffered_sets": "398",
7173            "unbuffered_sets": "0",
7174            "ps_buffered_sets": "0",
7175            "ps_unbuffered_sets": "0",
7176            "flushed_normal_sets": "0",
7177            "flushed_ps_sets": "0",
7178            "ps_prepared_never_executed": "0",
7179            "ps_prepared_once_executed": "0",
7180            "rows_fetched_from_server_normal": "4117",
7181            "rows_fetched_from_server_ps": "0",
7182            "rows_buffered_from_client_normal": "4117",
7183            "rows_buffered_from_client_ps": "0",
7184            "rows_fetched_from_client_normal_buffered": "4117",
7185            "rows_fetched_from_client_normal_unbuffered": "0",
7186            "rows_fetched_from_client_ps_buffered": "0",
7187            "rows_fetched_from_client_ps_unbuffered": "0",
7188            "rows_fetched_from_client_ps_cursor": "0",
7189            "rows_affected_normal": "4",
7190            "rows_affected_ps": "0",
7191            "rows_skipped_normal": "4117",
7192            "rows_skipped_ps": "0",
7193            "copy_on_write_saved": "0",
7194            "copy_on_write_performed": "0",
7195            "command_buffer_too_small": "0",
7196            "connect_success": "17",
7197            "connect_failure": "0",
7198            "connection_reused": "0",
7199            "reconnect": "0",
7200            "pconnect_success": "0",
7201            "active_connections": "18446744073709551601",
7202            "active_persistent_connections": "0",
7203            "explicit_close": "16",
7204            "implicit_close": "0",
7205            "disconnect_close": "0",
7206            "in_middle_of_command_close": "0",
7207            "explicit_free_result": "398",
7208            "implicit_free_result": "0",
7209            "explicit_stmt_close": "0",
7210            "implicit_stmt_close": "0",
7211            "mem_emalloc_count": "0",
7212            "mem_emalloc_amount": "0",
7213            "mem_ecalloc_count": "0",
7214            "mem_ecalloc_amount": "0",
7215            "mem_erealloc_count": "0",
7216            "mem_erealloc_amount": "0",
7217            "mem_efree_count": "0",
7218            "mem_efree_amount": "0",
7219            "mem_malloc_count": "0",
7220            "mem_malloc_amount": "0",
7221            "mem_calloc_count": "0",
7222            "mem_calloc_amount": "0",
7223            "mem_realloc_count": "0",
7224            "mem_realloc_amount": "0",
7225            "mem_free_count": "0",
7226            "mem_free_amount": "0",
7227            "mem_estrndup_count": "0",
7228            "mem_strndup_count": "0",
7229            "mem_estrdup_count": "0",
7230            "mem_strdup_count": "0",
7231            "mem_edupl_count": "0",
7232            "mem_dupl_count": "0",
7233            "proto_text_fetched_null": "0",
7234            "proto_text_fetched_bit": "0",
7235            "proto_text_fetched_tinyint": "0",
7236            "proto_text_fetched_short": "46",
7237            "proto_text_fetched_int24": "0",
7238            "proto_text_fetched_int": "135",
7239            "proto_text_fetched_bigint": "747",
7240            "proto_text_fetched_decimal": "0",
7241            "proto_text_fetched_float": "0",
7242            "proto_text_fetched_double": "0",
7243            "proto_text_fetched_date": "0",
7244            "proto_text_fetched_year": "0",
7245            "proto_text_fetched_time": "0",
7246            "proto_text_fetched_datetime": "0",
7247            "proto_text_fetched_timestamp": "0",
7248            "proto_text_fetched_string": "11207",
7249            "proto_text_fetched_blob": "0",
7250            "proto_text_fetched_enum": "3926",
7251            "proto_text_fetched_set": "0",
7252            "proto_text_fetched_geometry": "0",
7253            "proto_text_fetched_other": "0",
7254            "proto_binary_fetched_null": "0",
7255            "proto_binary_fetched_bit": "0",
7256            "proto_binary_fetched_tinyint": "0",
7257            "proto_binary_fetched_short": "0",
7258            "proto_binary_fetched_int24": "0",
7259            "proto_binary_fetched_int": "0",
7260            "proto_binary_fetched_bigint": "0",
7261            "proto_binary_fetched_decimal": "0",
7262            "proto_binary_fetched_float": "0",
7263            "proto_binary_fetched_double": "0",
7264            "proto_binary_fetched_date": "0",
7265            "proto_binary_fetched_year": "0",
7266            "proto_binary_fetched_time": "0",
7267            "proto_binary_fetched_datetime": "0",
7268            "proto_binary_fetched_timestamp": "0",
7269            "proto_binary_fetched_string": "0",
7270            "proto_binary_fetched_json": "0",
7271            "proto_binary_fetched_blob": "0",
7272            "proto_binary_fetched_enum": "0",
7273            "proto_binary_fetched_set": "0",
7274            "proto_binary_fetched_geometry": "0",
7275            "proto_binary_fetched_other": "0",
7276            "init_command_executed_count": "0",
7277            "init_command_failed_count": "0",
7278            "com_quit": "16",
7279            "com_init_db": "0",
7280            "com_query": "458",
7281            "com_field_list": "0",
7282            "com_create_db": "0",
7283            "com_drop_db": "0",
7284            "com_refresh": "0",
7285            "com_shutdown": "0",
7286            "com_statistics": "0",
7287            "com_process_info": "0",
7288            "com_connect": "0",
7289            "com_process_kill": "0",
7290            "com_debug": "0",
7291            "com_ping": "0",
7292            "com_time": "0",
7293            "com_delayed_insert": "0",
7294            "com_change_user": "0",
7295            "com_binlog_dump": "0",
7296            "com_table_dump": "0",
7297            "com_connect_out": "0",
7298            "com_register_slave": "0",
7299            "com_stmt_prepare": "0",
7300            "com_stmt_execute": "0",
7301            "com_stmt_send_long_data": "0",
7302            "com_stmt_close": "0",
7303            "com_stmt_reset": "0",
7304            "com_stmt_set_option": "0",
7305            "com_stmt_fetch": "0",
7306            "com_deamon": "0",
7307            "bytes_received_real_data_normal": "133717",
7308            "bytes_received_real_data_ps": "0"
7309        },
7310        "openssl": {
7311            "OpenSSL support": "enabled",
7312            "OpenSSL Library Version": "OpenSSL 1.1.1d 10 Sep 2019",
7313            "OpenSSL Header Version": "OpenSSL 1.1.1d 10 Sep 2019",
7314            "Openssl default config": "\/usr\/lib\/ssl\/openssl.cnf",
7315            "openssl.cafile": "no value",
7316            "openssl.capath": "no value"
7317        },
7318        "pcre": {
7319            "PCRE (Perl Compatible Regular Expressions) Support": "enabled",
7320            "PCRE Library Version": "10.32 2018-09-10",
7321            "PCRE Unicode Version": "11.0.0",
7322            "PCRE JIT Support": "not compiled in",
7323            "pcre.backtrack_limit": "1000000",
7324            "pcre.recursion_limit": "100000"
7325        },
7326        "PDO": {
7327            "PDO drivers": "mysql, pgsql, sqlite"
7328        },
7329        "pdo_mysql": {
7330            "Client API version": "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $",
7331            "pdo_mysql.default_socket": "\/var\/run\/mysqld\/mysqld.sock"
7332        },
7333        "pdo_pgsql": {
7334            "PDO Driver for PostgreSQL": "enabled",
7335            "PostgreSQL(libpq) Version": "11.7 (Debian 11.7-0+deb10u1)"
7336        },
7337        "pdo_sqlite": {
7338            "SQLite Library": "3.27.2"
7339        },
7340        "pgsql": {
7341            "PostgreSQL(libpq) Version": "11.7 (Debian 11.7-0+deb10u1)",
7342            "PostgreSQL(libpq)": "PostgreSQL 11.7 (Debian 11.7-0+deb10u1) on arm-unknown-linux-gnueabihf, compiled by gcc (Debian 8.3.0-6) 8.3.0, 32-bit",
7343            "Multibyte character support": "enabled",
7344            "SSL support": "enabled",
7345            "Active Persistent Links": "0",
7346            "Active Links": "0",
7347            "pgsql.allow_persistent": "On",
7348            "pgsql.auto_reset_persistent": "Off",
7349            "pgsql.ignore_notice": "Off",
7350            "pgsql.log_notice": "Off",
7351            "pgsql.max_links": "Unlimited",
7352            "pgsql.max_persistent": "Unlimited"
7353        },
7354        "Phar": {
7355            "Phar API version": "1.1.1",
7356            "Phar-based phar archives": "enabled",
7357            "Tar-based phar archives": "enabled",
7358            "ZIP-based phar archives": "enabled",
7359            "gzip compression": "enabled",
7360            "bzip2 compression": "disabled (install ext\/bz2)",
7361            "Native OpenSSL support": "enabled",
7362            "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,
7363            "phar.cache_list": "no value",
7364            "phar.readonly": "On",
7365            "phar.require_hash": "On"
7366        },
7367        "posix": {
7368            "POSIX support": "enabled"
7369        },
7370        "readline": {
7371            "Readline library": "EditLine wrapper",
7372            "cli.pager": "no value",
7373            "cli.prompt": "\\b \\> "
7374        },
7375        "Reflection": {
7376            "Reflection": "enabled"
7377        },
7378        "session": {
7379            "Session Support": "enabled",
7380            "Registered save handlers": "files user",
7381            "Registered serializer handlers": "php_serialize php php_binary wddx",
7382            "session.auto_start": "Off",
7383            "session.cache_expire": "180",
7384            "session.cache_limiter": "nocache",
7385            "session.cookie_domain": "no value",
7386            "session.cookie_httponly": [
7387                "1",
7388                "no value"
7389            ],
7390            "session.cookie_lifetime": "0",
7391            "session.cookie_path": [
7392                "\/owncloud",
7393                "\/"
7394            ],
7395            "session.cookie_samesite": "no value",
7396            "session.cookie_secure": [
7397                "1",
7398                "0"
7399            ],
7400            "session.gc_divisor": "1000",
7401            "session.gc_maxlifetime": "1440",
7402            "session.gc_probability": "0",
7403            "session.lazy_write": "On",
7404            "session.name": [
7405                "oc5112ecc40e",
7406                "PHPSESSID"
7407            ],
7408            "session.referer_check": "no value",
7409            "session.save_handler": "files",
7410            "session.save_path": "\/var\/lib\/php\/sessions",
7411            "session.serialize_handler": "php",
7412            "session.sid_bits_per_character": "5",
7413            "session.sid_length": "26",
7414            "session.upload_progress.cleanup": "On",
7415            "session.upload_progress.enabled": "On",
7416            "session.upload_progress.freq": "1%",
7417            "session.upload_progress.min_freq": "1",
7418            "session.upload_progress.name": "PHP_SESSION_UPLOAD_PROGRESS",
7419            "session.upload_progress.prefix": "upload_progress_",
7420            "session.use_cookies": "1",
7421            "session.use_only_cookies": "1",
7422            "session.use_strict_mode": "0",
7423            "session.use_trans_sid": "0"
7424        },
7425        "shmop": {
7426            "shmop support": "enabled"
7427        },
7428        "SimpleXML": {
7429            "SimpleXML support": "enabled",
7430            "Schema support": "enabled"
7431        },
7432        "smbclient": {
7433            "smbclient Support": "enabled",
7434            "smbclient extension Version": "0.9.0",
7435            "libsmbclient library Version": "4.9.5-Debian"
7436        },
7437        "sockets": {
7438            "Sockets Support": "enabled"
7439        },
7440        "sodium": {
7441            "libsodium headers version": "1.0.17",
7442            "libsodium library version": "1.0.17"
7443        },
7444        "SPL": {
7445            "Interfaces": "OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject",
7446            "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"
7447        },
7448        "sqlite3": {
7449            "SQLite Library": "3.27.2",
7450            "sqlite3.defensive": "1",
7451            "sqlite3.extension_dir": "no value"
7452        },
7453        "ssh2": {
7454            "extension version": "1.1.2",
7455            "libssh2 version": "1.8.0",
7456            "banner": "SSH-2.0-libssh2_1.8.0"
7457        },
7458        "standard": {
7459            "Dynamic Library Support": "enabled",
7460            "Path to sendmail": "\/usr\/sbin\/sendmail -t -i",
7461            "assert.active": "1",
7462            "assert.bail": "0",
7463            "assert.callback": "no value",
7464            "assert.exception": "0",
7465            "assert.quiet_eval": "0",
7466            "assert.warning": "1",
7467            "auto_detect_line_endings": "0",
7468            "default_socket_timeout": "60",
7469            "from": "no value",
7470            "session.trans_sid_hosts": "no value",
7471            "session.trans_sid_tags": "a=href,area=href,frame=src,form=",
7472            "url_rewriter.hosts": "no value",
7473            "url_rewriter.tags": "form=",
7474            "user_agent": "no value"
7475        },
7476        "sysvmsg": {
7477            "sysvmsg support": "enabled"
7478        },
7479        "sysvsem": {
7480            "sysvsem support": "enabled"
7481        },
7482        "sysvshm": {
7483            "sysvshm support": "enabled"
7484        },
7485        "tokenizer": {
7486            "Tokenizer Support": "enabled"
7487        },
7488        "wddx": {
7489            "WDDX Session Serializer": "enabled"
7490        },
7491        "xml": {
7492            "XML Support": "active",
7493            "XML Namespace Support": "active",
7494            "libxml2 Version": "2.9.4"
7495        },
7496        "xmlreader": {
7497            "XMLReader": "enabled"
7498        },
7499        "xmlwriter": {
7500            "XMLWriter": "enabled"
7501        },
7502        "xsl": {
7503            "XSL": "enabled",
7504            "libxslt Version": "1.1.32",
7505            "libxslt compiled against libxml Version": "2.9.4",
7506            "EXSLT": "enabled",
7507            "libexslt Version": "1.1.32"
7508        },
7509        "Zend OPcache": {
7510            "Opcode Caching": "Up and Running",
7511            "Optimization": "Enabled",
7512            "SHM Cache": "Enabled",
7513            "File Cache": "Disabled",
7514            "Startup": "OK",
7515            "Shared memory model": "mmap",
7516            "Cache hits": "84460",
7517            "Cache misses": "1876",
7518            "Used memory": "22558520",
7519            "Free memory": "100290432",
7520            "Wasted memory": "11368776",
7521            "Interned Strings Used memory": "2723232",
7522            "Interned Strings Free memory": "3567964",
7523            "Cached scripts": "1030",
7524            "Cached keys": "1961",
7525            "Max keys": "16229",
7526            "OOM restarts": "0",
7527            "Hash keys restarts": "0",
7528            "Manual restarts": "0",
7529            "opcache.blacklist_filename": "no value",
7530            "opcache.consistency_checks": "0",
7531            "opcache.dups_fix": "Off",
7532            "opcache.enable": "On",
7533            "opcache.enable_cli": "Off",
7534            "opcache.enable_file_override": "Off",
7535            "opcache.error_log": "no value",
7536            "opcache.file_cache": "no value",
7537            "opcache.file_cache_consistency_checks": "1",
7538            "opcache.file_cache_only": "0",
7539            "opcache.file_update_protection": "2",
7540            "opcache.force_restart_timeout": "180",
7541            "opcache.huge_code_pages": "Off",
7542            "opcache.interned_strings_buffer": "8",
7543            "opcache.lockfile_path": "\/tmp",
7544            "opcache.log_verbosity_level": "1",
7545            "opcache.max_accelerated_files": "10000",
7546            "opcache.max_file_size": "0",
7547            "opcache.max_wasted_percentage": "5",
7548            "opcache.memory_consumption": "128",
7549            "opcache.opt_debug_level": "0",
7550            "opcache.optimization_level": "0x7FFEBFFF",
7551            "opcache.preferred_memory_model": "no value",
7552            "opcache.protect_memory": "0",
7553            "opcache.restrict_api": "no value",
7554            "opcache.revalidate_freq": "2",
7555            "opcache.revalidate_path": "Off",
7556            "opcache.save_comments": "1",
7557            "opcache.use_cwd": "On",
7558            "opcache.validate_permission": "Off",
7559            "opcache.validate_root": "Off",
7560            "opcache.validate_timestamps": "On"
7561        },
7562        "zip": {
7563            "Zip": "enabled",
7564            "Zip version": "1.15.4",
7565            "Libzip headers version": "1.5.1",
7566            "Libzip library version": "1.5.1"
7567        },
7568        "zlib": {
7569            "Stream Wrapper": "compress.zlib:\/\/",
7570            "Stream Filter": "zlib.inflate, zlib.deflate",
7571            "Compiled Version": "1.2.11",
7572            "Linked Version": "1.2.11",
7573            "zlib.output_compression": "Off",
7574            "zlib.output_compression_level": "-1",
7575            "zlib.output_handler": "no value"
7576        },
7577        "Environment": {
7578            "LANGUAGE": "en_US.UTF-8",
7579            "APACHE_RUN_DIR": "\/var\/run\/apache2",
7580            "APACHE_PID_FILE": "\/var\/run\/apache2\/apache2.pid",
7581            "JOURNAL_STREAM": "9:23239",
7582            "INVOCATION_ID": "19f7496196d64cd3aaae655902433ad9",
7583            "APACHE_LOCK_DIR": "\/var\/lock\/apache2",
7584            "LANG": "C",
7585            "LC_MESSAGES": "en_US.UTF-8",
7586            "APACHE_RUN_USER": "www-data",
7587            "APACHE_RUN_GROUP": "www-data",
7588            "APACHE_LOG_DIR": "\/var\/log\/apache2",
7589            "PWD": "\/"
7590        }
7591    }
7592}