Cloudlog/application/migrations
Peter Goodhall 20c202a9cc tag 2.7.1
2025-08-25 13:10:09 +01:00
..
001_add_lotw_credentials.php Refactor migration files for code style consistency 2025-08-18 14:07:43 +01:00
002_add_config_table.php Refactor migration files for code style consistency 2025-08-18 14:07:43 +01:00
003_add_lotw_login_url.php Refactor migration files for code style consistency 2025-08-18 14:07:43 +01:00
004_add_eQSL_login_and_url.php
005_add_dxcc_enddate.php
007_add_dxcc_delete.php
008_add_dxcc_entities.php
009_add_dxcc_exceptions.php
010_add_dxcc_prefixes.php
011_add_dxcc_prefixes_start_end.php
012_add_dxcc_entities_start.php
013_add_dxcc_stored_proc.php
014_migration.php
015_extenddxccprefix.php
016_lotwusers.php
017_qslviavarchar.php
018_clubloguserfields.php
019_forceint_wrongtype.php
020_apikeydesc.php
021_latlng_wrongtype.php
022_mylatlng_wrongtype.php
023_col_email_tooshort.php
024_add_column_logbookid.php
025_create_logbook_table.php
026_addfield_to_logbooks_default.php
027_addfield_to_logbooks_active.php
028_logbooks_setkeys.php
029_delete_logbooks_table.php
030_delete_logbookid.php
031_add_station_id_to_logbook.php
032_add_station_active.php
033_log_setindex_station_id.php
034_add_eqslqthnickname_to_stationprofile.php
035_col_mode_tooshort.php
036_create_eqsl_images_table.php
037_update_lotw_url.php
038_create_iota_tables.php
039_add_state_to_stationprofile.php
040_add_qrz_api_to_stationprofile.php
041_create_modes_table.php
042_modify_modes_table.php
043_add_lotw_certs_table.php
044_add_key_to_lotw_certs.php Make it more failsafe 2024-01-20 13:57:26 +01:00
045_add_userid_to_lotw_certs.php
046_add_last_upload_to_lotw_certs.php
047_add_cert_to_lotw_certs.php
048_add_county_to_stationprofile.php
049_add_users_measurement_base.php
050_add_dateformat_to_users.php [Users] Made Date Format defineable in the user profile and changed all the code in the system to follow selection 2020-09-15 22:04:47 +01:00
051_delete_lotw_userlist_table.php Added Migration to delete the LoTW User List table and removed some unneeded coded 2020-09-21 14:10:55 +01:00
052_add_user_stylesheet.php New feature: theme is user selectable. 2020-09-23 10:59:49 +02:00
053_gridsquare_index.php Fixes Migration VUCC index to long 2020-10-29 14:52:34 +00:00
054_add_qsl_images.php Changed Migration so that it checks if qsl_images exists as i kept getting errors jumping around branches :) 2020-10-30 16:11:41 +00:00
055_add_signature_to_station_profile.php Add migration for sig and sig_info fields 2020-11-11 18:10:32 +01:00
056_add_qrz_upload_realtime_option.php QRZ Real time upload is false by default 2020-11-18 19:53:58 +00:00
057_new_stylesheet_default.php Change the way themes are processed 2020-12-07 09:55:30 +00:00
058_new_options_table.php [Options] Creates options table during install and inserts the version2 flag and migration file makes sure it doesn't exisit. 2023-08-28 15:26:48 +01:00
059_add_default_theme_to_options_table.php [Global Options] Created Migration for table "options" and added theme and default 2020-12-10 17:45:44 +00:00
060_add_tileserver_to_options.php [Config][Maps] Added Openstreetmap tile server settings to options table 2020-12-26 14:58:41 +00:00
061_add_lang_to_options.php [Migration] 061 adds language to the options table default to english 2021-01-31 13:24:25 +00:00
062_add_globalsearch_to_options.php Added Migration to allow Global Search 2021-02-09 17:33:20 +00:00
063_add_contest_table.php [Contesting] Migration file is needed as well 2021-02-12 23:28:09 +01:00
064_add_user_sota_lookup.php [QSO Dialog] Auto-fill location and locator when SOTA is chosen. This is fetched from the API. This can be turned on/off in the user settings. 2021-02-26 10:37:43 +01:00
065_changed_dxcc_tables_utf8mb4.php Change DXCC tables to UTF8mb4 this fixes #924 2021-03-09 13:52:24 +00:00
066_add_user_hide_notes.php [Main menu] And nice to include the migration script as well. 2021-03-20 22:35:51 +01:00
067_add_index_cqz_prop.php [Migration script] Typo in the script name. 2021-03-31 11:56:44 +02:00
068_add_cat_timeout_to_options.php [Global Options] Added the option to define the Radio Timeout Warning 2021-05-03 14:50:33 +01:00
069_add_user_definable_columns.php [User selectable columns] Added the possibility to configure some of the columns shown in the dashboard and in the logbook. 2021-05-05 17:52:42 +02:00
070_add_fifth_column.php [User selectable columns] Added a fifth column, used only in logbook view. Also fixed a bug when adding user accounts. 2021-05-07 08:03:25 +02:00
071_add_queries_table.php Fixed down in migration script. 2021-10-15 11:14:28 +02:00
072_create_station_logbook_table.php Changed order of migration script to not cause trouble with migration script in master. 2021-10-06 10:36:50 +02:00
073_create_station_logbook_relationship_table.php [Migration] Adds 072 to 073 to cover my muck up! 2022-01-05 22:05:50 +00:00
074_add_userid_to_station_profiles.php Changed order of migration script to not cause trouble with migration script in master. 2021-10-06 10:36:50 +02:00
075_add_active_station_logbook_to_user_table.php Changed order of migration script to not cause trouble with migration script in master. 2021-10-06 10:36:50 +02:00
076_theme_table.php Fixed down in migration script. 2021-10-15 11:14:28 +02:00
077_add_userid_to_notes.php [Migrations] Added checks to see if things exists. Done to avoid trouble when swapping branches. 2021-10-12 13:20:41 +02:00
078_add_userid_to_hardware.php [Migrations] Added checks to see if things exists. Done to avoid trouble when swapping branches. 2021-10-12 13:20:41 +02:00
079_add_userid_to_api.php [Migration] Fixes issue when user_id already exists with the api table. 2021-10-06 11:16:54 +01:00
080_update_cas9_qsos.php Update 080_update_cas9_qsos.php 2022-01-04 00:55:10 +00:00
081_update_xw2_qsos.php [SAT] Change Sat names stored as XW-3(CAS-9) to HO-113 2022-01-04 11:27:36 +00:00
082_add_reset_pass_to_users.php [Migration] Added duplicate check on columns in script 082 2022-02-09 20:05:40 +01:00
083_create_station_logbook_relationship_table2.php [Migration fix] Renames script 83 to avoid dupliate naming. Fixes script 85 with existing column and too long constraint on utf8mb4. 2022-02-05 17:15:00 +01:00
084_fix_collate.php Update 084_fix_collate.php 2022-01-26 14:53:55 +00:00
085_add_public_slug_to_stationlogbooks.php [Migration fix] Renames script 83 to avoid dupliate naming. Fixes script 85 with existing column and too long constraint on utf8mb4. 2022-02-05 17:15:00 +01:00
086_options_autoload_theme.php [Migration][Options] set the theme to auto load 2022-03-25 15:40:15 +00:00
087_add_qrz_image_option.php Add option to en-/disable showing of qrz.com images to user account menu 2022-04-04 13:17:33 +02:00
088_add_power_to_cat.php Fix typo 2022-04-07 12:07:51 +02:00
089_add_propmode_to_cat.php Add CAT support for other propmodes for CloudLogCATQt 2022-04-08 21:47:50 +02:00
090_make_mode_frequency_null.php Forgot to change description 2022-04-08 22:01:07 +02:00
091_create_thirdpartylogins_table.php Update 091_create_thirdpartylogins_table.php 2022-05-05 15:07:36 +01:00
092_add_service_username.php [Migration] Fixed script. Column name and table name were swapped. 2022-05-24 20:22:05 +02:00
093_rename_profile_images.php Only run migration when both IFs are met 2022-07-10 11:14:47 +01:00
094_update_modes_adif313.php Added more modes 2022-07-21 18:36:39 +02:00
095_cat_change_timestamp.php [CAT] Always set the timestamp data from PHP so its UTC 2022-08-03 16:50:09 +01:00
096_add_wwff_columns.php Fixed hardcoding of tables 2023-01-28 15:21:09 +01:00
097_add_qso_dates_to_lotw_certs.php Harmonize LoTW abbreviation 2023-04-26 05:44:54 +02:00
098_add_band_bandxuser.php Fix SQL insert for SAT band 2022-09-10 13:17:15 +02:00
099_add_wwff_to_bandxuser.php [Bands] Added WWFF support to bands 2022-09-20 17:25:50 +02:00
100_update_cat_table.php Update 100_update_cat_table.php 2022-09-30 16:11:30 +01:00
101_make_frequency_bigint_again.php Restore initial data type of frequency column in cat table 2022-09-30 12:05:38 +00:00
102_add_version_two_trigger_to_options.php [Options] Creates options table during install and inserts the version2 flag and migration file makes sure it doesn't exisit. 2023-08-28 15:26:48 +01:00
103_add_user_wwff_lookup.php Add lookup function for grid and name for WWFF refs 2022-10-19 14:52:43 +02:00
104_user_auto_qth_option.php No comment ... 2022-10-19 19:33:14 +02:00
105_create_dxcc_master_tables.php [Migrations] Fix in script 102 and 105 to check if things exists 2023-03-15 14:40:32 +01:00
106_add_user_previous_qsl_type.php Add option to select previous QSL type 2022-11-25 00:22:31 +01:00
107_change_greencube_to_oscar.php Bought up to date for merge 2022-11-27 17:22:51 +00:00
108_add_pota_columns.php Fixed hardcoding of tables 2023-01-28 15:21:09 +01:00
109_add_m17_and_freedv.php Add FreeDV and M17 submodes of digital voice 2022-12-07 09:06:35 +01:00
110_rename_cas5a.php Rename CAS-5A to FO-118 2022-12-18 09:21:21 +01:00
111_reupload_io117_and_fo118.php Fix typo 2022-12-21 21:27:36 +01:00
112_add_oqrs.php [OQRS] Removed default on text column 2022-12-21 22:29:04 +01:00
113_amsat_status_upload_option.php Add DB migration 2023-01-28 12:49:34 +01:00
114_create_index_for_colsubmode.php [QSO] adjustments to the DXCC Stats box 2023-02-20 15:20:16 +00:00
115_add_webadif_api_export.php Store webadif upload data in separate table 2023-03-17 13:11:04 +00:00
116_add_timestamp_to_api.php Add a column to API keys to show last usage timestamp 2023-03-21 12:26:15 +01:00
117_add_contest_session_table.php [Contest logging] Moved contest session from local storage to database 2023-04-10 18:54:24 +02:00
118_make_lotw_use_dxcc_id.php [Migration] Added an extra if check to avoid errors 2023-04-22 08:37:04 +02:00
119_remove_dxcc_name_from_station_profile.php Remove redundant country colum in station_profile 2023-04-25 00:13:49 +02:00
120_add_station_power.php Add DB migration for station_power 2023-04-27 23:09:31 +02:00
121_add_user_pota_lookup.php Add POTA lookup function 2023-05-01 21:14:30 +02:00
122_reupload_tevel.php Reupload Tevel QSOs to LOTW 2023-05-15 20:39:15 -03:00
123_add_lotw_users.php Use datetime for db column and fix typos 2023-05-26 15:22:31 +02:00
124_create_label_types_table.php [QSL Labels] Switched to tFPDF. Added font selection 2023-06-12 08:20:24 +02:00
125_lotw_enddates.php Update qso_end_date of existing certs where time is 00:00:00 2023-07-01 23:06:31 +02:00
126_mastodon_url.php Fixed header of migrationscript. Accidently there was the amsat-feature documented... 2023-07-06 08:22:44 +00:00
127_add_hrdlog_fields.php Controller, Migrationscript and View for HRDLog 2023-07-07 11:35:01 +00:00
128_user_default_map_settings.php Set default values and add All 2023-07-07 16:44:18 +02:00
129_add_public_search_option.php Add logbook setting for public search 2023-07-10 17:11:40 +02:00
130_add_version_to_config.php [Version] Store version number in the options table 2023-07-14 14:03:55 +01:00
131_reset_lotw_upload_for_ledsat.php Reset LoTW upload for LEDSAT 2023-07-25 11:18:20 +02:00
132_create_cwmacros_table.php Getting ready for merge 2023-08-01 16:22:03 +01:00
133_add_user_language.php Commented migscript, Added lang-choser to Useradd 2023-08-02 07:06:34 +00:00
134_create_label_paper_types_table.php Updated migration script to update on down, and failsafe for papertype 2023-08-03 08:16:13 +02:00
135_add_winkey.php [Account][Winkey] Allows users to enable and disable winkey via their account settings 2023-08-03 13:59:02 +01:00
136_tag_2_4_6.php Tag Cloudlog 2.4.6 2023-08-07 14:07:24 +01:00
137_tag_2_4_7.php [Migration] Sets version to 2.4.7 2023-08-17 14:01:20 +01:00
138_user_options_table.php Fix missing closing bracket 2023-08-19 10:58:35 +02:00
139_modify_eQSL_url.php Update Docker setup and improve health checks 2025-08-09 18:05:31 +01:00
140_tag_2_4_8.php Tag 2.4.8 2023-08-30 21:58:39 +01:00
141_alter_user_options_table.php And migration script 2023-08-31 08:41:59 +02:00
142_alter_lotw_user_table.php Index for lotw_users 2023-09-07 15:03:08 +00:00
143_tag_2_4_9.php Migration to tag as 2.4.9 2023-09-13 15:46:47 +01:00
144_tag_2_4_10.php Tag Cloudlog as 2.4.10 2023-10-03 13:59:37 +01:00
145_rename_gridmap_variables.php Fix typo in downgrade migration 2023-10-17 05:53:42 +02:00
146_correct_default_bandgroup.php correction of default bandgroup as migration 2023-10-18 19:31:46 +02:00
147_tag_2_4_11.php [Migration] Tag release as 2.4.11 2023-10-22 13:53:53 +01:00
148_qso_end_times.php Add option to log QSO end times separately 2023-11-01 14:24:13 +01:00
149_reupload_inspiresat7_qsos.php [Migration] Set INSPIRE-SAT 7 sat qsos to reupload to lotw 2023-11-01 16:01:18 +00:00
150_tag_2_5_0.php [Migration] Tag Cloudlog as 2.5.0 2023-11-03 12:42:56 +00:00
151_user_quicklog.php added user_quicklog_enter 2023-11-05 12:29:59 +01:00
152_tag_2_5_1.php Tag 2.5.1 2023-11-14 13:57:59 +00:00
153_tag_2_5_2.php tag 2.5.2 2023-11-20 14:29:48 +00:00
154_create_dxpedition_table.php Fixes byte issue for older mysql versions 2023-12-16 15:40:31 +00:00
155_add_clublog_realtime.php Added RT-Flag for ClubLog 2023-11-27 14:20:45 +00:00
156_add_waja_bandxuser.php Fixed migration script. Removed map button/tab and award info 2023-11-30 10:55:46 +01:00
157_wide_themes.php Fixed theme migration script 2023-12-07 11:11:43 +01:00
158_add_qrz_down.php Merge pull request #2800 from int2001/migfixqrz 2023-12-08 14:18:37 +00:00
159_extend_default_qsl.php down function was missing 2023-12-08 16:28:30 +01:00
160_tag_2_6_0.php Tag as Version 2.6 2023-12-14 14:04:20 +00:00
161_award_submitted_typo.php Only alter COL_AWARD_SUMMITED if it exists in the qso table 2023-12-23 13:36:09 +00:00
162_hrdlog_username.php added logic to auto-populate the hrd_username from station_callsign 2023-12-16 09:37:45 +01:00
163_dxcc_index.php Improved migration file to check if index exists before dropping it 2023-12-18 11:48:42 +00:00
164_removing_blue_theme.php removing blue theme 2023-12-18 21:17:23 +01:00
165_tag_2_6_1.php 2.6.1 2023-12-22 15:30:44 +00:00
166_set_oqrs_stationname_option.php set default value for additional OQRS Option 2023-12-27 11:55:01 +01:00
167_add_last_login.php comments 2024-01-01 02:44:03 +01:00
168_rename_reupload_so121.php Rename existing HADES-D QSOs and reupload to LoTW 2024-01-03 08:51:08 +01:00
169_tag_2_6_2.php Create a 2.6.2 release 2024-01-03 10:44:40 +00:00
170_tag_2_6_3.php Set migration for 2.6.3 2024-01-26 13:08:14 +00:00
171_tag_2_6_4.php Create 171_tag_2_6_4.php 2024-02-15 13:39:29 +00:00
172_tag_2_6_5.php tag '2.6.5 2024-02-20 14:17:07 +00:00
173_tag_2_6_6.php tag 2.6.6 2024-03-06 15:25:43 +00:00
174_tag_2_6_7.php Get ready for version 2.6.7 stable 2024-03-21 13:30:21 +00:00
175_add_sstv_images_table.php Make sure that sstv images table doesnt already exist 2024-03-28 15:22:01 +00:00
176_tag_2_6_8.php 2.6.8 tag 2024-04-05 22:12:00 +01:00
177_add_dxped_url_option.php Fixes issue #3247 2025-01-07 13:16:23 +00:00
178_tag_2_6_9.php Tag 2.6.9 2024-04-14 16:23:57 +01:00
179_tag_2_6_10.php stable 2.6.10 2024-04-21 13:57:40 +01:00
180_qso_table_credit_submitted_increase.php Increase COL_CREDIT_SUBMITTED to 255 2024-04-30 15:55:36 +01:00
181_tag_2_6_11.php tag 2.6.11 2024-05-05 13:33:32 +01:00
182_tag_2_6_12.php tag 2.6.12 2024-05-14 14:16:29 +01:00
183_add_wab_to_location.php [WAB] Added ability to store WAB reference in Station Locations 2024-05-14 15:25:10 +01:00
184_tag_2_6_13.php 2.6.13 2024-05-21 13:50:25 +01:00
185_tag_2_6_14.php tag 2.6.14 2024-05-29 15:29:00 +01:00
186_tag_2_6_15.php tag 2.6.15 2024-06-26 15:31:18 +01:00
187_MESAT1_to_MO122.php [Satellites] Change MESAT-1 to OSCAR MO-122 2024-10-03 13:17:26 +01:00
188_tag_2_6_16.php tag 2.6.16 2024-10-03 15:21:47 +01:00
189_set_MO122_lotw_upload.php Set MO-122 and SONATE to upload to LoTW 2024-10-24 13:45:15 +01:00
190_set_SONATE_lotw_upload.php Set MO-122 and SONATE to upload to LoTW 2024-10-24 13:45:15 +01:00
191_rename_reupload_ao123.php Update AO-123 settings for LoTW 2024-12-07 10:59:40 +00:00
192_increase_lotwpass_field_val.php Increase the lotw password size in the database 2025-01-07 13:22:08 +00:00
193_increase_qth_column_size.php Increase QTH column for logged QSOs 2025-01-07 13:27:39 +00:00
194_upload_so124_to_lotw.php Set SO-124 to upload to Lotw 2025-03-05 21:46:32 +00:00
195_tag_2_6_17.php Tag version 2.6.17 2025-03-05 21:52:19 +00:00
196_tag_2_6_18.php Lets get 2.6.18 ready 2025-05-07 14:22:56 +01:00
197_add_winkey_websocket.php add option to turn on websockets for winkey 2025-05-28 13:38:25 +01:00
198_sat_name_change_hadesicm_so125.php typo 2025-06-10 15:05:50 +01:00
199_tag_2_6_19.php tag 2..6.19 2025-06-11 15:25:08 +01:00
200_fix_brazil_dxcc_data.php Brazilian DXCC fix: Fixes indentation 2025-07-10 23:50:00 -03:00
201_tag_2_6_20.php Add migration to tag Cloudlog as version 2.6.20 2025-07-17 17:35:50 +01:00
202_set_tevel23_to_notsent.php Add migration to set TEVEL2-3 QSL sent status to N 2025-07-30 10:26:16 +01:00
203_tag_2_6_21.php Add migration to tag Cloudlog as version 2.6.21 2025-07-30 12:44:46 +01:00
204_tag_2_6_22.php Add migration to tag Cloudlog as version 2.6.22 2025-08-02 13:10:07 +01:00
205_add_workable_dxcc_indexes.php Refactor migration files for code style consistency 2025-08-18 14:07:43 +01:00
206_tag_2_7_0.php Add migration to tag Cloudlog as version 2.7.0 2025-08-15 15:47:50 +01:00
207_add_radio_panel_option_to_logbook.php Add public radio status option to logbooks 2025-08-22 14:52:07 +01:00
208_add_indexes_lotw_users.php Add indexes to lotw_users table 2025-08-22 16:29:49 +01:00
209_lotw_cert_archive_status.php Add archive status for LoTW certificates 2025-08-22 17:15:51 +01:00
210_tag_2_7_1.php tag 2.7.1 2025-08-25 13:10:09 +01:00