{ "migrations": { "core": { "13000Date20170705121758": [], "13000Date20170718121200": [], "13000Date20170814074715": [], "13000Date20170919121250": [], "13000Date20170926101637": [], "14000Date20180129121024": [], "14000Date20180404140050": [], "14000Date20180516101403": [], "14000Date20180518120534": [], "14000Date20180522074438": [], "14000Date20180626223656": [], "14000Date20180710092004": [], "14000Date20180712153140": [], "15000Date20180926101451": [], "15000Date20181015062942": [], "15000Date20181029084625": [], "16000Date20190207141427": [], "16000Date20190212081545": [], "16000Date20190427105638": [], "16000Date20190428150708": [], "17000Date20190514105811": [], "18000Date20190920085628": [], "18000Date20191014105105": [], "18000Date20191204114856": [], "19000Date20200211083441": [], "20000Date20201109081915": [], "20000Date20201109081918": [], "20000Date20201109081919": [], "20000Date20201111081915": [], "21000Date20201120141228": [], "21000Date20201202095923": [], "21000Date20210119195004": [], "21000Date20210309185126": [], "21000Date20210309185127": [], "22000Date20210216080825": [], "23000Date20210721100600": [], "23000Date20210906132259": [], "23000Date20210930122352": [], "23000Date20211203110726": [], "23000Date20211213203940": [], "24000Date20211210141942": [], "24000Date20211213081506": [], "24000Date20211213081604": [], "24000Date20211222112246": [], "24000Date20211230140012": [], "24000Date20220131153041": [], "24000Date20220202150027": [], "24000Date20220404230027": [], "24000Date20220425072957": [], "25000Date20220515204012": [], "25000Date20220602190540": [], "25000Date20220905140840": [], "25000Date20221007010957": [], "27000Date20220613163520": [], "27000Date20230309104325": [], "27000Date20230309104802": [], "28000Date20230616104802": [], "28000Date20230728104802": [], "28000Date20230803221055": [], "28000Date20230906104802": [], "28000Date20231004103301": [], "28000Date20231103104802": [], "28000Date20231126110901": [], "28000Date20240828142927": [ { "class": "OCP\\Migration\\Attributes\\ModifyColumn", "table": "jobs", "description": "Increase the column size from 32 to 64", "notes": [], "name": "argument_hash", "type": "string" }, { "class": "OCP\\Migration\\Attributes\\ModifyColumn", "table": "jobs", "description": "Rehash the argument_hash column using sha256", "notes": [], "name": "argument_hash", "type": "string" } ], "29000Date20231126110901": [], "29000Date20231213104850": [], "29000Date20240124132201": [], "29000Date20240124132202": [], "29000Date20240131122720": [], "30000Date20240429122720": [ { "class": "OCP\\Migration\\Attributes\\CreateTable", "table": "taskprocessing_tasks", "description": "", "notes": [], "columns": [] }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "taskprocessing_tasks", "description": "", "notes": [], "type": "primary" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "taskprocessing_tasks", "description": "", "notes": [], "type": "index" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "taskprocessing_tasks", "description": "", "notes": [], "type": "index" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "taskprocessing_tasks", "description": "", "notes": [], "type": "index" } ], "30000Date20240708160048": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "scheduled_at", "type": "integer" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "started_at", "type": "integer" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "ended_at", "type": "integer" } ], "30000Date20240717111406": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "webhook_uri", "type": "string" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "webhook_method", "type": "string" } ], "30000Date20240814180800": [], "30000Date20240815080800": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "webauthn", "description": "", "notes": [], "name": "user_verification", "type": "boolean" } ], "30000Date20240906095113": [ { "class": "OCP\\Migration\\Attributes\\ModifyColumn", "table": "taskprocessing_tasks", "description": "Increase column length to 4000 bytes to support longer error messages", "notes": [], "name": "error_message", "type": "" } ], "31000Date20240101084401": [ { "class": "OCP\\Migration\\Attributes\\CreateTable", "table": "sec_signatory", "description": "new table to store remove public/private key pairs", "notes": [], "columns": [ "id", "key_id_sum", "key_id", "host", "provider_id", "account", "public_key", "metadata", "type", "status", "creation", "last_updated" ] }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "sec_signatory", "description": "", "notes": [], "type": "primary" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "sec_signatory", "description": "confirm uniqueness per host, provider and account", "notes": [], "type": "unique" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "sec_signatory", "description": "to search on key and provider", "notes": [], "type": "index" } ], "31000Date20240814184402": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "preferences", "description": "lazy loading to user preferences", "notes": [], "name": "lazy", "type": "smallint" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "preferences", "description": "typed values to user preferences", "notes": [], "name": "type", "type": "smallint" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "preferences", "description": "bitflag about the value", "notes": [], "name": "flag", "type": "integer" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "preferences", "description": "non-array value can be set as indexed", "notes": [], "name": "indexed", "type": "integer" }, { "class": "OCP\\Migration\\Attributes\\DropIndex", "table": "preferences", "description": "remove previous app/key index", "notes": [ "will be re-created to include 'indexed' field" ], "type": "index" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "preferences", "description": "new index including user+lazy", "notes": [], "type": "index" }, { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "preferences", "description": "new index including app/key and indexed", "notes": [], "type": "index" } ], "31000Date20250213102442": [ { "class": "OCP\\Migration\\Attributes\\DropIndex", "table": "filecache", "description": "remove index fs_id_storage_size (concurrent with PRIMARY KEY)", "notes": [], "type": "index" } ], "32000Date20250620081925": [ { "class": "OCP\\Migration\\Attributes\\DataCleansing", "table": "preferences", "description": "lowercase accounts email address", "notes": [] } ], "32000Date20250731062008": [ { "class": "OCP\\Migration\\Attributes\\DataCleansing", "table": "vcategory", "description": "Cleanup of duplicate vcategory records", "notes": [] }, { "class": "OCP\\Migration\\Attributes\\DataCleansing", "table": "vcategory_to_object", "description": "Update object references", "notes": [] } ], "32000Date20250806110519": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "taskprocessing_tasks", "description": "", "notes": [], "name": "allow_cleanup", "type": "smallint" } ], "33000Date20251209123503": [], "34000Date20260318095645": [ { "class": "OCP\\Migration\\Attributes\\ModifyColumn", "table": "jobs", "description": "Migrate background job arguments to a text column", "notes": [], "name": "argument", "type": "text" } ] }, "apps": { "notifications": { "2004Date20190107135757": [], "2010Date20210218082811": [], "2010Date20210218082855": [], "2011Date20210930134607": [], "2011Date20220826074907": [] }, "app_api": { "1000Date202305221555": [], "1004Date202311061844": [], "2000Date20240120094952": [], "2005Date20240209094951": [], "2201Date20240221124152": [], "2203Date20240325124149": [], "2204Date20240403125002": [], "2205Date20240411124836": [], "2206Date20240502145029": [], "2207Date20240502145029": [], "2700Date20240515092246": [], "2800Date20240710220000": [], "2800Date20240711080316": [], "3000Date20240715170800": [], "3000Date20240807085759": [], "3100Date20240822080316": [], "3200Date20240905080316": [], "5000Date20241120135411": [], "032000Date20250109162434": [], "032001Date20250115164140": [], "032002Date20250527174907": [] }, "twofactor_nextcloud_notification": { "0001Date20180411172140": [], "3004Date20220331145316": [], "4000Date20240802134536": [], "4000Date20240802134537": [] }, "files_downloadlimit": { "000000Date20210910094923": [] }, "twofactor_totp": { "010501Date20181018124436": [], "020102Date20190304124405": [], "030000Date20190305114917": [], "140000Date202503027114917": [] }, "suspicious_login": { "0Date20181127130604": [], "0Date20181213090142": [], "0Date20181214080456": [], "0Date20181214083108": [], "0Date20181214103754": [], "0Date20190115134303": [], "0Date20190121184304": [], "0Date20190123142603": [], "2Date20190906100917": [], "2Date20190913144908": [], "4002Date20220922094803": [], "4002Date20220922094804": [], "9000Date20250114095826": [] }, "related_resources": [], "bruteforcesettings": [], "circles": { "0022Date20220526111723": [], "0022Date20220526113601": [], "0022Date20220703115023": [], "0023Date20211216113101": [], "0024Date20220203123901": [], "0024Date20220203123902": [], "0024Date20220317190331": [], "0028Date20230705222601": [], "0031Date20241105133904": [ { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "circles_mountpoint", "description": "add uniqueness to mountpoint per user", "notes": [], "type": "unique" } ], "0032Date20250623120204": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "circles_mount", "description": "store remote instance for quicker identification", "notes": [], "name": "remote", "type": "string" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "circles_mount", "description": "store remote share id for quicker identification", "notes": [], "name": "remote_id", "type": "integer" } ] }, "viewer": [], "text": { "010000Date20190617184535": [], "030001Date20200402075029": [], "030201Date20201116110353": [], "030201Date20201116123153": [], "030501Date20220202101853": [], "030701Date20230207131313": [], "030901Date20231114150437": [], "040100Date20240611165300": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "text_steps", "description": "Tracking the timestamp of a document editing step", "notes": [], "name": "timestamp", "type": "bigint" } ], "070000Date20250925110024": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "text_documents", "description": "CRC32 checksum of document content", "notes": [], "name": "checksum", "type": "string" } ], "080000Date20260331132113": [ { "class": "OCP\\Migration\\Attributes\\AddIndex", "table": "text_steps", "description": "Optimize cleanup job", "notes": [], "type": "index" } ] }, "survey_client": [], "support": [], "serverinfo": [], "recommendations": [], "privacy": { "100Date20190217131943": [] }, "photos": { "20000Date20220727125801": [], "20001Date20220830131446": [], "20003Date20221102170153": [], "20003Date20221103094628": [], "30000Date20240417075405": [], "32000Date20250507132617": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "photos_albums", "description": "storing album filters", "notes": [], "name": "filters", "type": "text" } ] }, "password_policy": [], "nextcloud_announcements": [], "logreader": [], "firstrunwizard": [], "files_pdfviewer": [], "activity": { "2006Date20170808154933": [], "2006Date20170808155040": [], "2006Date20170919095939": [], "2007Date20181107114613": [], "2008Date20181011095117": [], "2010Date20190416112817": [], "2011Date20201006132544": [], "2011Date20201006132545": [], "2011Date20201006132546": [], "2011Date20201006132547": [], "2011Date20201207091915": [] }, "workflowengine": { "2000Date20190808074233": [], "2200Date20210805101925": [] }, "webhook_listeners": { "1000Date20240527153425": [], "1001Date20240716184935": [] }, "weather_status": [], "user_status": { "0001Date20200602134824": [], "0002Date20200902144824": [], "1000Date20201111130204": [], "1003Date20210809144824": [], "1008Date20230921144701": [] }, "user_ldap": { "1010Date20200630192842": [], "1120Date20210917155206": [], "1130Date20211102154716": [], "1130Date20220110154717": [], "1130Date20220110154718": [], "1130Date20220110154719": [], "1141Date20220323143801": [], "1190Date20230706134108": [], "1190Date20230706134109": [] }, "updatenotification": [], "twofactor_backupcodes": { "1002Date20170607104347": [], "1002Date20170607113030": [], "1002Date20170919123342": [], "1002Date20170926101419": [], "1002Date20180821043638": [] }, "theming": { "2006Date20240905111627": [] }, "systemtags": { "31000Date20241018063111": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "systemtag", "description": "Adding etag for systemtag table to prevent conflicts", "notes": [], "name": "etag", "type": "string" } ], "31000Date20241114171300": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "systemtag", "description": "Adding color for systemtag table", "notes": [], "name": "color", "type": "string" } ] }, "sharebymail": [], "settings": [], "provisioning_api": [], "profile": [], "oauth2": { "010401Date20181207190718": [], "010402Date20190107124745": [], "011601Date20230522143227": [], "011602Date20230613160650": [], "011603Date20230620111039": [], "011901Date20240829164356": [] }, "lookup_server_connector": [], "files_versions": { "1020Date20221114144058": [] }, "files_trashbin": { "1010Date20200630192639": [], "1020Date20240403003535": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "files_trash", "description": "", "notes": [], "name": "deleted_by", "type": "string" } ] }, "files_sharing": { "11300Date20201120141438": [], "21000Date20201223143245": [], "22000Date20210216084241": [], "24000Date20220208195521": [], "24000Date20220404142216": [], "31000Date20240821142813": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "share", "description": "", "notes": [], "name": "reminder_sent", "type": "boolean" } ], "32000Date20251017081948": [ { "class": "OCP\\Migration\\Attributes\\ModifyColumn", "table": "share_external", "description": "Change length to 255 characters", "notes": [], "name": "owner", "type": "string" } ] }, "files_reminders": { "10000Date20230725162149": [] }, "files_external": { "1011Date20200630192246": [], "1015Date20211104103506": [], "1016Date20220324154536": [], "1025Date20250228162604": [], "22000Date20210216084416": [] }, "files": { "2003Date20241021095629": [], "11301Date20191205150729": [], "12101Date20221011153334": [] }, "federation": { "1010Date20200630191302": [] }, "federatedfilesharing": { "1010Date20200630191755": [], "1011Date20201120125158": [] }, "encryption": [], "dav": { "1004Date20170825134824": [], "1004Date20170919104507": [], "1004Date20170924124212": [], "1004Date20170926103422": [], "1005Date20180413093149": [], "1005Date20180530124431": [], "1006Date20180619154313": [], "1006Date20180628111625": [], "1008Date20181030113700": [], "1008Date20181105104826": [], "1008Date20181105104833": [], "1008Date20181105110300": [], "1008Date20181105112049": [], "1008Date20181114084440": [], "1011Date20190725113607": [], "1011Date20190806104428": [], "1012Date20190808122342": [], "1016Date20201109085907": [], "1017Date20210216083742": [], "1018Date20210312100735": [], "1024Date20211221144219": [], "1025Date20240308063933": [], "1027Date20230504122946": [], "1029Date20221114151721": [], "1029Date20231004091403": [], "1030Date20240205103243": [], "1031Date20240610134258": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "dav_absence", "description": "", "notes": [], "name": "replacement_user_id", "type": "string" }, { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "dav_absence", "description": "", "notes": [], "name": "replacement_user_display_name", "type": "string" } ], "1034Date20250605132605": [ { "class": "OCP\\Migration\\Attributes\\AddColumn", "table": "dav_shares", "description": "", "notes": [], "name": "token", "type": "string" }, { "class": "OCP\\Migration\\Attributes\\CreateTable", "table": "calendars_federated", "description": "Supporting Federated Calender", "notes": [], "columns": [ "id", "display_name", "color", "uri", "principaluri", "remote_Url", "token", "sync_token", "last_sync", "shared_by", "shared_by_display_name", "components", "permissions" ] } ], "1034Date20250813093701": [ { "class": "OCP\\Migration\\Attributes\\DataCleansing", "table": "properties", "description": "remove commonly used custom properties set as default", "notes": [] } ] }, "dashboard": [], "contactsinteraction": { "010000Date20200304152605": [] }, "comments": [], "cloud_federation_api": { "1016Date202502262004": [ { "class": "OCP\\Migration\\Attributes\\CreateTable", "table": "federated_invites", "description": "Supporting the OCM Invitation Flow feature", "notes": [], "columns": [ "id", "user_id", "recipient_provider", "recipient_user_id", "recipient_name", "recipient_email", "token", "accepted", "created_at", "expired_at", "accepted_at" ] } ] }, "admin_audit": [] } }, "build": { "initiated": 1777260129, "duration": 858 } }