Migration

get migration

get

Authorizations

bearerAuth

AuthorizationstringRequired

Bearer authentication header of the form Bearer <token>.

Responses

200

OK

application/json

401

Unauthorized

application/json

get

/api/v3/migration

HTTPcURLJavaScriptPython

GET /api/v3/migration HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "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",
    ""
  ]
}

get migration status

get

Authorizations

bearerAuth

AuthorizationstringRequired

Bearer authentication header of the form Bearer <token>.

Responses

200

OK

application/json

401

Unauthorized

application/json

get

/api/v3/migration/status

HTTPcURLJavaScriptPython

GET /api/v3/migration/status HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "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 rollback

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

200: OK

{
    "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"
    ]
}

migration migrate

post

Authorizations

bearerAuth

AuthorizationstringRequired

Bearer authentication header of the form Bearer <token>.

Responses

200

OK

application/json

401

Unauthorized

application/json

post

/api/v3/migration/migrate

HTTPcURLJavaScriptPython

POST /api/v3/migration/migrate HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "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",
    ""
  ]
}