argos/dmp-db-scema/updates
Efstratios Giannopoulos 906cee7621 db script changes 2024-04-10 16:48:12 +03:00
..
00.00.002_create_user_association.sql Removed old database updates (redundant) 2020-05-13 12:49:14 +03:00
00.00.003_doifunder.sql Removed old database updates (redundant) 2020-05-13 12:49:14 +03:00
00.00.004_add_language_to_dmp_and_dataset_profile.sql Add ExtraProperties for DMP and language for Dataset Template 2020-06-03 12:13:31 +03:00
00.00.005_remove_user_association_table.sql fixes 2020-10-05 12:08:57 +03:00
00.00.006_Update_Credential_and_LoginConfirmationEmail_tables.sql db script fix 2020-11-04 18:57:42 +02:00
00.00.007_Add_userstatus_on_UserInfo_table.sql Fix minor issue with one of the DB update scripts 2020-11-04 16:28:14 +02:00
00.00.008_Add_UserDatasetProfile_table.sql When finalize DMP properly finalize it's datasets first 2021-04-21 18:21:52 +03:00
00.00.009_Add_File_table.sql Add in DB table UploadFile 2022-03-16 11:32:06 +02:00
00.00.010_Add_EntityDoi_table.sql [WIP] EntityDoi table 2022-11-02 09:41:40 +02:00
00.00.011.Migrate_data_from_dmp_doi_to_entitydoi.sql [WIP] EntityDoi table 2022-11-02 09:41:40 +02:00
00.00.012.Delete_doi_from_dmp_table.sql drop column doi from dmp and refactor code(replace single doi with list of dois) 2022-12-08 13:12:54 +02:00
00.00.013_Add_Description_Template_Type_table.sql add status to description template types, fix bugs in editor/listing 2023-09-11 08:40:03 +03:00
00.00.014_Rename_DatasetProfile_and_add_Type_column.sql description template type and dmp blueprint frontend changes 2023-10-20 18:01:09 +03:00
00.00.015_Add_new_column_to_Dataset_and_DMPDatasetProfile.sql add db scripts: inserting default blueprint, attach that blueprint as profile of each dmp, make each dataset section index correspond to the default blueprint last section 2023-09-12 15:24:25 +03:00
00.00.016_Insert_default_blueprint_and_add_dmpSectionIndex_to datasets.sql small fixes, (wip) remove description template chip from dmp editor 2023-09-13 15:55:38 +03:00
00.00.017_Make_grant_not_null.sql make grant funder not mandatory for the creation/new version/clone of dmp 2023-09-18 17:48:54 +03:00
00.01.000_Add_Reference_ReferenceType_SupportiveMaterial.sql migration changes 2024-02-29 12:38:57 +02:00
00.01.001_Align_Description_Template_Type.sql description template type and dmp blueprint frontend changes 2023-10-20 18:01:09 +03:00
00.01.002_Align_Entity_Doi_table.sql Updating EntityDoi db script removing problematic column entity_type and adding a new one with the same name of type smallint in order for the queries to work properly 2023-12-06 18:02:42 +02:00
00.01.003_Add_UserSettings_table.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.004_Align_Dmp_blueprint_table.sql Adding migration scripts for Dmp, DmpReference, Description and DescriptionReference entities, other fixes / clear up dmp entity 2023-10-27 17:05:48 +03:00
00.01.005_Add_Dmp_table.sql add user contact migration 2023-11-24 17:18:28 +02:00
00.01.006_Add_Dmp_reference_table.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.007_Add_Description_table_former_Dataset.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.008_Add_DescriptionReference_table.sql migration changes 2023-11-24 18:19:22 +02:00
00.01.009_Drop_old_dataset_related_tables.sql Drop old unused dataset related tables, small fix to migration script 2023-10-27 17:29:22 +03:00
00.01.010_Align_DescriptionTemplate_table.sql migration changes 2024-03-12 16:28:07 +02:00
00.01.011_Align_UserDescriptionTemplate_table.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.012_Add_Dmp_description_template_table.sql add description template to description 2023-11-24 12:39:26 +02:00
00.01.013_Add_Dmp_User_table.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.014_sync_Description.sql add description template to description 2023-11-24 12:39:26 +02:00
00.01.015_addTag.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.016_addDescriptionTag.sql sync db tables for description 2023-11-20 17:08:43 +02:00
00.01.017_addUserTable.sql user table sql scripts 2023-11-20 17:18:12 +02:00
00.01.018_addUserCredentialTable.sql add CredentialData 2024-01-16 12:26:29 +02:00
00.01.019_addUserContactInfoTable.sql user table sql scripts 2023-11-20 17:18:12 +02:00
00.01.020_updateUserRoleTable.sql user table sql scripts 2023-11-20 17:18:12 +02:00
00.01.021_syncUserData.sql add user contact migration 2023-11-24 17:18:28 +02:00
00.01.022_updateUserFKs.sql fix sql scripts 2023-11-22 13:31:00 +02:00
00.01.023_addTenant.sql addTenant.sql script 2023-11-22 16:39:14 +02:00
00.01.024_addLanguage.sql add language file fallback method 2023-11-28 19:10:04 +02:00
00.01.025_addStorageFile.sql script fix 2023-11-29 15:31:51 +02:00
00.01.026_addLanguage.sql fix sql script 2023-11-29 17:07:40 +02:00
00.01.027_renameOldNotification.sql add sql scripts 2023-12-05 11:56:25 +02:00
00.01.028_addQueueOutbox.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.029_addQueueInbox.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.030_add_ntf_Tenant_and_ntf_TenantConfiguration.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.031_Add_ntf_User.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.032_add_ntf_Notification.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.033_Add_ntf_User_ContactInfo.sql db script changes 2024-04-10 16:48:12 +03:00
00.01.034_Add_ntf_User_Credential.sql remove tenant from UserContactInfo UserCredential 2024-04-03 11:36:31 +03:00
00.01.035_Add_ntf_TenantUser.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.036_add_ntf_NotificationTemplate.sql multitenant changes 2024-04-04 16:39:40 +03:00
00.01.037_add_ntf_QueueInbox.sql multitenant changes 2024-04-04 16:39:40 +03:00
00.01.038_add_ntf_QueueOutbox.sql multitenant changes 2024-04-04 16:39:40 +03:00
00.01.039_add_ntf_InAppNotification.sql fix sql script order 2024-04-04 18:27:18 +03:00
00.01.040_add_ntf_UserNotificationPreference.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.041_addTenantUser.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.042_rename_user_settings.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.043_addTenant_Id_to_Tables.sql remove tenant from UserContactInfo UserCredential 2024-04-03 11:36:31 +03:00
00.01.044_drop_old_Lock_and_add_new.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.045_addActionConfirmation.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.046_Change_Entity_Type_To_Enum.sql reorder sql scripts 2024-02-21 18:37:24 +02:00
00.01.047_Add_versioning_on_dmp_blueprint.sql Added versioning migration script for DmpBlueprintEntity 2024-02-02 15:10:02 +02:00
00.01.048_Add_ant_Tenant_and_ant_TenantConfiguration.sql Resolving migration scripts issues for annotation service tables regarding queue messages 2024-02-21 17:53:28 +02:00
00.01.049_Add_ant_QueueInbox.sql update queues to use smallint enums 2024-03-29 14:32:47 +02:00
00.01.050_Add_ant_QueueOutbox.sql update queues to use smallint enums 2024-03-29 14:32:47 +02:00
00.01.051_Add_ant_User.sql reference type ui fixes 2024-02-15 18:36:46 +02:00
00.01.052_Add_ant_User_Credential.sql remove tenant from UserContactInfo UserCredential 2024-04-03 11:36:31 +03:00
00.01.053_Add_ant_TenantUser.sql reference type ui fixes 2024-02-15 18:36:46 +02:00
00.01.054_Add_Section_Id_to_DmpUser.sql add section id to DmpUser 2024-02-21 12:46:24 +02:00
00.01.055_Add_ant_Annotation_table.sql script changes 2024-04-04 12:25:43 +03:00
00.01.056_Add_ant_EntityUser_table.sql script changes 2024-04-04 12:25:43 +03:00
00.01.057_Add_PrefillingSource_table.sql Add Prefilling Source Entity backend stack 2024-02-22 19:01:23 +02:00
00.01.058_Add_ant_UserContactInfo_table.sql db script changes 2024-04-10 16:48:12 +03:00
00.01.059_Update_ant_Annotation_table_columns.sql Updating db script 00.01.058, adding 00.01.059 2024-03-07 13:34:56 +02:00
00.01.060_Insert_values.sql migration changes 2024-04-10 12:10:35 +03:00
00.01.061_Remove_DMP_Fkey_from_EntityDoi.sql remove dmp fkey from Entity Doi table script 2024-03-27 16:03:50 +02:00
00.01.062_add_currency_referenceType.sql update sql currency script 2024-04-09 16:44:22 +03:00