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