Migration

migration rollback

POST https://ushahididocs.api.ushahidi.io/api/v3/migration/rollback

{
    "results": [
        "Phinx by Rob Morgan - https://phinx.org. 0.8.1\r",
        "\r",
        "using config file .C:\\xampp\\htdocs\\platform\\phinx.php\r",
        "using config parser php\r",
        "using migration paths \r",
        " - C:\\xampp\\htdocs\\platform\\migrations\r",
        "using seed paths \r",
        " - C:\\xampp\\htdocs\\platform\\seeds\r",
        "using environment ushahidi\r",
        "using adapter mysql\r",
        "using database platform_3\r",
        "ordering by creation time\r",
        "\r",
        " == 20211215110945 AddMetadataToPostDatetimeTable: reverting\r",
        " == 20211215110945 AddMetadataToPostDatetimeTable: reverted 0.0785s\r",
        "\r",
        "All Done. Took 0.0994s\r"
    ]
}

PreviousVerifier NextNotification

{ "results": [ "Phinx by Rob Morgan - https://phinx.org. 0.8.1\n", "", "using config file .C:\\xampp\\htdocs\\platform\\phinx.php\n", "using config parser php\n", "using migration paths \r", " - C:\\xampp\\htdocs\\platform\\migrations\n", "using seed paths \r", " - C:\\xampp\\htdocs\\platform\\seeds\n", "using environment ushahidi\n", "ordering by creation time\n", "", " Status [Migration ID] Started Finished Migration Name \r", "----------------------------------------------------------------------------------\n", " up 20140716082651 2022-05-25 23:20:24 2022-05-25 23:20:25 Initial\n", " up 20140716103608 2022-05-25 23:20:32 2022-05-25 23:20:34 InitialRelations\n", " up 20140716154343 2022-05-25 23:20:34 2022-05-25 23:20:34 InitialOauth\n", " up 20140716154431 2022-05-25 23:20:34 2022-05-25 23:20:35 InitialOauthRelations\n", " up 20140821024335 2022-05-25 23:20:35 2022-05-25 23:20:35 AddLayers\n", " up 20140827013047 2022-05-25 23:20:35 2022-05-25 23:20:35 PopulateOauthScopes\n", " up 20140828235719 2022-05-25 23:20:35 2022-05-25 23:20:35 AddLayersOauthScope\n", " up 20140829142629 2022-05-25 23:20:35 2022-05-25 23:20:35 DefaultAdminUser\n", " up 20140829151920 2022-05-25 23:20:35 2022-05-25 23:20:35 DefaultOauthClient\n", " up 20140904004829 2022-05-25 23:20:35 2022-05-25 23:20:35 AddPostUserFields\n", " up 20140904004900 2022-05-25 23:20:35 2022-05-25 23:20:35 MovePostUsersToPost\n", " up 20140904004941 2022-05-25 23:20:35 2022-05-25 23:20:35 RequireUsersUsername\n", " up 20141007125013 2022-05-25 23:20:35 2022-05-25 23:20:36 CreatedUpdatedIndexes\n", " up 20141015004705 2022-05-25 23:20:36 2022-05-25 23:20:36 AutoApproveDefaultOauthClient\n", " up 20141017022550 2022-05-25 23:20:36 2022-05-25 23:20:36 FormsSoftDelete\n", " up 20141105085836 2022-05-25 23:20:36 2022-05-25 23:20:36 FormAttributesRelations\n", " up 20141107032450 2022-05-25 23:20:36 2022-05-25 23:20:36 FormAttributePriorityIndex\n", " up 20150307031255 2022-05-25 23:20:36 2022-05-25 23:20:36 AddAdditionalInfoToMessages\n", " up 20150312174835 2022-05-25 23:20:36 2022-05-25 23:20:36 AddFkConstraintOnPostTags\n", " up 20150323031520 2022-05-25 23:20:36 2022-05-25 23:20:36 RenameGroupsToStages\n", " up 20150326152730 2022-05-25 23:20:36 2022-05-25 23:20:37 AddSetFields\n", " up 20150326163454 2022-05-25 23:20:37 2022-05-25 23:20:37 AddPublishedToColumnToPosts\n", " up 20150331022622 2022-05-25 23:20:37 2022-05-25 23:20:37 AddRequiredAndCompletedStages\n", " up 20150428080719 2022-05-25 23:20:37 2022-05-25 23:20:37 AllowNullPostTitle\n", " up 20150502143055 2022-05-25 23:20:37 2022-05-25 23:20:37 UpdateConfigValueType\n", " up 20150507033314 2022-05-25 23:20:37 2022-05-25 23:20:37 CreateDefaultSets\n", " up 20150608081940 2022-05-25 23:20:37 2022-05-25 23:20:37 AddSavedSearchesOauthScope\n", " up 20150612013637 2022-05-25 23:20:37 2022-05-25 23:20:37 RemoveTasks\n", " up 20150612014430 2022-05-25 23:20:37 2022-05-25 23:20:37 AddDefaultRoles\n", " up 20150612014440 2022-05-25 23:20:37 2022-05-25 23:20:38 AddUsersRoleForeignKey\n", " up 20150715004543 2022-05-25 23:20:38 2022-05-25 23:20:38 AddUniquePostSlugIndex\n", " up 20150716003751 2022-05-25 23:20:38 2022-05-25 23:20:38 FixUnstructuredPostSetFilter\n", " up 20150716034610 2022-05-25 23:20:38 2022-05-25 23:20:38 AddMissingPostValueToFormAttributeFk\n", " up 20150716034618 2022-05-25 23:20:38 2022-05-25 23:20:38 AddPostRelations\n", " up 20150716070739 2022-05-25 23:20:38 2022-05-25 23:20:38 AddFormAttributeConfig\n", " up 20150807043140 2022-05-25 23:20:38 2022-05-25 23:20:38 CreateUserResetTokens\n", " up 20150829193514 2022-05-25 23:20:38 2022-05-25 23:20:38 AddNotificationsOauthScope\n", " up 20150830115829 2022-05-25 23:20:38 2022-05-25 23:20:38 CreateNotifications\n", " up 20150904021011 2022-05-25 23:20:38 2022-05-25 23:20:38 AddDefaultPostType\n", " up 20150904083146 2022-05-25 23:20:38 2022-05-25 23:20:38 AddContactOauthScope\n", " up 20150911110021 2022-05-25 23:20:38 2022-05-25 23:20:38 AddContactNotifyFlag\n", " up 20150916032421 2022-05-25 23:20:38 2022-05-25 23:20:39 RemoveUsernameFromUsers\n", " up 20150924101337 2022-05-25 23:20:39 2022-05-25 23:20:39 CreateNotificationQueue\n", " up 20151028083458 2022-05-25 23:20:39 2022-05-25 23:20:39 MakeResetTokenFieldLargeEnough\n", " up 20151127093600 2022-05-25 23:20:39 2022-05-25 23:20:39 CreateCsv\n", " up 20151208024527 2022-05-25 23:20:39 2022-05-25 23:20:39 AddUserToMessages\n", " up 20151208172416 2022-05-25 23:20:39 2022-05-25 23:20:39 AddCsvOauthScope\n", " up 20160202115439 2022-05-25 23:20:39 2022-05-25 23:20:39 AddPermissions\n", " up 20160204093857 2022-05-25 23:20:39 2022-05-25 23:20:39 AddRolesOauthScope\n", " up 20160209093524 2022-05-25 23:20:39 2022-05-25 23:20:39 AddPermissionsOauthScope\n", " up 20160215174906 2022-05-25 23:20:39 2022-05-25 23:20:39 AddRoleId\n", " up 20160215185411 2022-05-25 23:20:39 2022-05-25 23:20:39 AddRolesPermissions\n", " up 20160215191344 2022-05-25 23:20:39 2022-05-25 23:20:39 RemovePermissionsFromRoles\n", " up 20160322013857 2022-05-25 23:20:39 2022-05-25 23:20:39 AddMessageNotificationPostId\n", " up 20160322020552 2022-05-25 23:20:39 2022-05-25 23:20:39 MoveMessagePostIdToNotificationPostId\n", " up 20160421185245 2022-05-25 23:20:39 2022-05-25 23:20:39 AddPostMedia\n", " up 20160503083146 2022-05-25 23:20:39 2022-05-25 23:20:39 AddMigrateOauthScope\n", " up 20160509232531 2022-05-25 23:20:39 2022-05-25 23:20:39 AddMessageLocationAttribute\n", " up 20160609222458 2022-05-25 23:20:39 2022-05-25 23:20:40 SetPostUserNullOnDelete\n", " up 20160612031458 2022-05-25 23:20:40 2022-05-25 23:20:40 RenameUserToMember\n", " up 20160612032112 2022-05-25 23:20:40 2022-05-25 23:20:40 UpdateDefaultSavedSearches\n", " up 20160623182730 2022-05-25 23:20:40 2022-05-25 23:20:40 AddProtectedRoles\n", " up 20160623184725 2022-05-25 23:20:40 2022-05-25 23:20:40 SetProtectedRoles\n", " up 20160628172956 2022-05-25 23:20:40 2022-05-25 23:20:40 AddFormColor\n", " up 20160720230341 2022-05-25 23:20:40 2022-05-25 23:20:40 AddRequireApprovalToForms\n", " up 20160722231016 2022-05-25 23:20:40 2022-05-25 23:20:40 CreateFormRolesTable\n", " up 20160726225434 2022-05-25 23:20:40 2022-05-25 23:20:40 AddFormEveryoneCanCreate\n", " up 20160803210356 2022-05-25 23:20:40 2022-05-25 23:20:40 AddTypeToStage\n", " up 20160803225359 2022-05-25 23:20:40 2022-05-25 23:20:40 AddDescriptionToStage\n", " up 20160809023850 2022-05-25 23:20:40 2022-05-25 23:20:40 ReturnPublishToPostsToReview\n", " up 20160902084943 2022-05-25 23:20:40 2022-05-25 23:20:40 MigrateFirstTaskToPostStage\n", " up 20161005203722 2022-05-25 23:20:40 2022-05-25 23:20:41 PostCustomDate\n", " up 20161110175958 2022-05-25 23:20:41 2022-05-25 23:20:41 UpdatePostTitleDesc\n", " up 20161208162710 2022-05-25 23:20:41 2022-05-25 23:20:41 RenameVisibleToColumn\n", " up 20170311003829 2022-05-25 23:20:41 2022-05-25 23:20:41 CreateWebhookTable\n", " up 20170311004159 2022-05-25 23:20:41 2022-05-25 23:20:41 CreateWebhookJob\n", " up 20170313194004 2022-05-25 23:20:41 2022-05-25 23:20:41 AddWebhookToOauthScope\n", " up 20170315231639 2022-05-25 23:20:41 2022-05-25 23:20:41 AddPostMarkdownTable\n", " up 20170317174120 2022-05-25 23:20:41 2022-05-25 23:20:41 AddPrivateResponseToFormAttribute\n", " up 20170322160413 2022-05-25 23:20:41 2022-05-25 23:20:41 AddHideAuthorToForm\n", " up 20170322162237 2022-05-25 23:20:41 2022-05-25 23:20:41 AddDescriptionFieldToFormAttribute\n", " up 20170325110408 2022-05-25 23:20:41 2022-05-25 23:20:41 AddLanguageToUser\n", " up 20170328080656 2022-05-25 23:20:41 2022-05-25 23:20:41 AddFormsTagsTable\n", " up 20170330135806 2022-05-25 23:20:41 2022-05-25 23:20:41 AddApiKeyTable\n", " up 20170330151759 2022-05-25 23:20:41 2022-05-25 23:20:41 AddApiKeyToOauthTable\n", " up 20170331210813 2022-05-25 23:20:41 2022-05-25 23:20:42 AddShowWhenPublishedToFormStage\n", " up 20170406132016 2022-05-25 23:20:42 2022-05-25 23:20:42 AddWebhookUuidToWebhookTable\n", " up 20170406132136 2022-05-25 23:20:42 2022-05-25 23:20:42 AddFormSourceDestinationToWebhookTable\n", " up 20170412191954 2022-05-25 23:20:42 2022-05-25 23:20:42 ConvertFormTagsToFormAttribute\n", " up 20170413163900 2022-05-25 23:20:42 2022-05-25 23:20:42 RenameSourceDestinationUuidForWebhooksTable\n", " up 20170417082819 2022-05-25 23:20:42 2022-05-25 23:20:42 AddTagsToFormsTags\n", " up 20170417090621 2022-05-25 23:20:42 2022-05-25 23:20:42 MovePostTagValuesToPostVarchar\n", " up 20170419000000 2022-05-25 23:20:42 2022-05-25 23:20:42 DropOldOauthTables\n", " up 20170419000001 2022-05-25 23:20:42 2022-05-25 23:20:42 CreateOauthAuthCodesTable\n", " up 20170419000002 2022-05-25 23:20:42 2022-05-25 23:20:42 CreateOauthAccessTokensTable\n", " up 20170419000003 2022-05-25 23:20:42 2022-05-25 23:20:42 CreateOauthRefreshTokensTable\n", " up 20170419000004 2022-05-25 23:20:42 2022-05-25 23:20:42 CreateOauthClientsTable\n", " up 20170419000005 2022-05-25 23:20:42 2022-05-25 23:20:42 CreateOauthPersonalAccessClientsTable\n", " up 20170419204826 2022-05-25 23:20:42 2022-05-25 23:20:42 RestoreDefaultOauthClient\n", " up 20170507060511 2022-05-25 23:20:42 2022-05-25 23:20:42 MakeShowWhenPublishedToTrue\n", " up 20170508191840 2022-05-25 23:20:42 2022-05-25 23:20:42 ChangeTaskVisibilityDefault\n", " up 20170519044934 2022-05-25 23:20:42 2022-05-25 23:20:42 RemoveTagsFromTasks\n", " up 20170522004400 2022-05-25 23:20:42 2022-05-25 23:20:42 RemoveTagsFromPostVarchar\n", " up 20170522004409 2022-05-25 23:20:42 2022-05-25 23:20:42 JoinPostsTagsTableToAttribute\n", " up 20170525003110 2022-05-25 23:20:42 2022-05-25 23:20:43 DropFormsTagsTable\n", " up 20170526014209 2022-05-25 23:20:43 2022-05-25 23:20:43 MakeTagsTopLevelWhenParentDeleted\n", " up 20170630084848 2022-05-25 23:20:43 2022-05-25 23:20:43 AllowNullInDescriptionForms\n", " up 20170710013345 2022-05-25 23:20:43 2022-05-25 23:20:43 AddEditOwnPostsPermission\n", " up 20170712152806 2022-05-25 23:20:43 2022-05-25 23:20:43 AddTosTable\n", " up 20170713213005 2022-05-25 23:20:43 2022-05-25 23:20:43 AddTosToScope\n", " up 20170905160630 2022-05-25 23:20:43 2022-05-25 23:20:43 AddHasCaptionConfigOptionInFormAttributes\n", " up 20170929155823 2022-05-25 23:20:43 2022-05-25 23:20:43 AddPostLockTable\n", " up 20171005171758 2022-05-25 23:20:43 2022-05-25 23:20:43 AddInternalTaskOnlyToFormStage\n", " up 20171005171849 2022-05-25 23:20:43 2022-05-25 23:20:43 SetDefaultTaskOnlyForExistingFormStage\n", " up 20171013192552 2022-05-25 23:20:43 2022-05-25 23:20:43 ReplaceTimelineViewWithDataView\n", " up 20171019221707 2022-05-25 23:20:43 2022-05-25 23:20:43 IncreaseTagNameLength\n", " up 20171026030927 2022-05-25 23:20:43 2022-05-25 23:20:43 AddIndicesForPostSearch\n", " up 20171112210337 2022-05-25 23:20:43 2022-05-25 23:20:43 SetConfigUpdatedDefaultValue\n", " up 20171115211215 2022-05-25 23:20:43 2022-05-25 23:20:43 RenameDataProviderToSource\n", " up 20171202162600 2022-05-25 23:20:43 2022-05-25 23:20:43 AllowNullInWebhooksUpdated\n", " up 20180201005618 2022-05-25 23:20:43 2022-05-25 23:20:44 AddFormTimeAndLocationPermissions\n", " up 20180212204016 2022-05-25 23:20:44 2022-05-25 23:20:44 CreateExportJobTable\n", " up 20180227213004 2022-05-25 23:20:44 2022-05-25 23:20:44 AddExpiresFieldToExportJob\n", " up 20180313202244 2022-05-25 23:20:44 2022-05-25 23:20:44 AddTargetedSurveyFlag\n", " up 20180316133403 2022-05-25 23:20:44 2022-05-25 23:20:45 AddCountryCodeTable\n", " up 20180316193138 2022-05-25 23:20:45 2022-05-25 23:20:45 ContactPostState\n", " up 20180321121334 2022-05-25 23:20:45 2022-05-25 23:20:45 AddCountryCodesToScope\n", " up 20180327105646 2022-05-25 23:20:45 2022-05-25 23:20:45 ContactPostStateToTargetedSurvey\n", " up 20180411200942 2022-05-25 23:20:45 2022-05-25 23:20:45 AddHeaderToExportJob\n", " up 20180417100825 2022-05-25 23:20:45 2022-05-25 23:20:45 GenerateApiKey\n", " up 20180423131108 2022-05-25 23:20:45 2022-05-25 23:20:45 ChangeTitleTypeToText\n", " up 20180427203643 2022-05-25 23:20:45 2022-05-25 23:20:45 ExportJobFieldSize\n", " up 20180507162526 2022-05-25 23:20:45 2022-05-25 23:20:45 CreateLicenseTable\n", " up 20180507162610 2022-05-25 23:20:45 2022-05-25 23:20:45 AddHxlLicenses\n", " up 20180507182549 2022-05-25 23:20:45 2022-05-25 23:20:46 CreateHxlTagsTables\n", " up 20180508154706 2022-05-25 23:20:46 2022-05-25 23:20:46 AddUserSettingsTable\n", " up 20180510155218 2022-05-25 23:20:46 2022-05-25 23:20:52 AddHxlTags\n", " up 20180510172759 2022-05-25 23:20:52 2022-05-25 23:20:52 DataImportPermissionNameChange\n", " up 20180512175804 2022-05-25 23:21:09 2022-05-25 23:21:09 AddHxlMetadataTable\n", " up 20180512183852 2022-05-25 23:21:09 2022-05-25 23:21:10 AddMetaDataKeyToExportJob\n", " up 20180512213459 2022-05-25 23:21:10 2022-05-25 23:21:10 AddHxlFieldsToExportJob\n", " up 20180512214017 2022-05-25 23:21:10 2022-05-25 23:21:10 SetExportJobSendToBrowser\n", " up 20180512214359 2022-05-25 23:21:10 2022-05-25 23:21:10 CreateFormAttributeHxlAttributeTagTable\n", " up 20180518150913 2022-05-25 23:21:10 2022-05-25 23:21:10 RemoveLicenseOther\n", " up 20180601183328 2022-05-25 23:21:10 2022-05-25 23:21:10 AddMissingTargetedSurveyAttributes\n", " up 20180614142626 2022-05-25 23:21:10 2022-05-25 23:21:10 AddManageCollectionsPermission\n", " up 20180629135118 2022-05-25 23:21:10 2022-05-25 23:21:10 RemoveMaintainerFromHxlMetaData\n", " up 20180713183206 2022-05-25 23:21:10 2022-05-25 23:21:10 RemoveElevationFromHxlAttributes\n", " up 20180717192148 2022-05-25 23:21:10 2022-05-25 23:21:10 AddOrgNameToHxlMetadata\n", " up 20180717201352 2022-05-25 23:21:10 2022-05-25 23:21:10 RenameOrganisationToOrganisationId\n", " up 20180723192841 2022-05-25 23:21:10 2022-05-25 23:21:10 DataImportPermissionNameChangeAgain\n", " up 20180821220522 2022-05-25 23:21:10 2022-05-25 23:21:11 AddStatusToCsv\n", " up 20180823215252 2022-05-25 23:21:11 2022-05-25 23:21:11 SetStatusForOldCsv\n", " up 20180905202314 2022-05-25 23:21:11 2022-05-25 23:21:11 MigratePostIdInMessages\n", " up 20181018034908 2022-05-25 23:21:11 2022-05-25 23:21:11 AddExportJobCounts\n", " up 20181018034914 2022-05-25 23:21:11 2022-05-25 23:21:11 AddExportJobBatches\n", " up 20181019183337 2022-05-25 23:21:11 2022-05-25 23:21:11 RemoveNullConstraintFromMessages\n", " up 20181022164754 2022-05-25 23:21:11 2022-05-25 23:21:11 RemoveTweetContents\n", " up 20181022230553 2022-05-25 23:21:11 2022-05-25 23:21:11 DeleteTweetLatLonFromTwitterPosts\n", " up 20181023140057 2022-05-25 23:21:11 2022-05-25 23:21:11 RemoveContactUsernames\n", " up 20181204074249 2022-07-01 17:39:21 2022-07-01 17:39:21 CreateImportTable\n", " up 20181204074307 2022-07-01 17:39:21 2022-07-01 17:39:21 CreateImportMappingTable\n", " up 20181206211859 2022-05-25 23:21:11 2022-05-25 23:21:11 AllowNullExportBatchFilename\n", " up 20181219073943 2022-07-01 17:39:21 2022-07-01 17:39:21 MakePostTitleLonger\n", " up 20200409232153 2022-05-25 23:21:11 2022-05-25 23:21:11 RewriteTwitterUrls\n", " up 20200506131856 2022-05-25 23:21:11 2022-05-25 23:21:11 AddEntityTranslations\n", " up 20200509204243 2022-05-25 23:21:11 2022-05-25 23:21:11 AddLanguageToSurvey\n", " up 20200518173900 2022-07-01 17:39:21 2022-07-01 17:39:21 CreateImportSourceDataTable\n", " up 20200521014822 2022-05-25 23:21:11 2022-05-25 23:21:12 AddBaseLanguageToCategories\n", " up 20200607230330 2022-05-25 23:21:12 2022-05-25 23:21:12 AddBaseLanguageToPosts\n", " up 20200906142500 2022-07-01 17:39:21 2022-07-01 17:39:22 ImportMappingMetadata\n", " up 20200909182100 2022-07-01 17:39:22 2022-07-01 17:39:22 ImportMetadata\n", " up 20210128193900 2022-05-25 23:21:12 2022-05-25 23:21:12 AdminExampleEmail\n", " up 20210226075959 2022-05-25 23:21:12 2022-05-25 23:21:12 EmbiggenTranslationTextColumnType\n", " up 20211215110945 2022-05-25 23:21:12 2022-05-25 23:21:12 AddMetadataToPostDatetimeTable\n", "" ] }

Migration

migration rollback

migration rollback

get migration

get migration status

migration migrate