Cloudlog/application/migrations
Peter Goodhall 9bbda9bf4d stable 2.6.10 2024-04-21 13:57:40 +01:00
..
001_add_lotw_credentials.php Turning on migration, adding a migration to add lotw credentials to the database, and removing a sample migration. 2013-02-24 17:58:36 -06:00
002_add_config_table.php Adding a primary key just for SQL sanity sake :) 2013-02-26 22:10:14 -06:00
003_add_lotw_login_url.php Working prototype of LoTW file upload. Needs a bit of polish yet. 2013-03-05 19:19:52 -06:00
004_add_eQSL_login_and_url.php Actually, this needs to do an UPDATE, not an insert... 2013-08-17 10:26:43 -05:00
005_add_dxcc_enddate.php fixed typo 2014-03-03 22:37:51 +00:00
007_add_dxcc_delete.php automated downloading of clublog cty xml file 2014-03-03 01:26:26 +00:00
008_add_dxcc_entities.php New tables for full clublog DXCC import 2016-02-17 15:06:43 +00:00
009_add_dxcc_exceptions.php New tables for full clublog DXCC import 2016-02-17 15:06:43 +00:00
010_add_dxcc_prefixes.php New tables for full clublog DXCC import 2016-02-17 15:06:43 +00:00
011_add_dxcc_prefixes_start_end.php DXCC match on date as well as callsign. Table schema updates 2016-02-23 22:00:35 +00:00
012_add_dxcc_entities_start.php DXCC match on date as well as callsign. Table schema updates 2016-02-23 22:00:35 +00:00
013_add_dxcc_stored_proc.php Stored Proc for DXCC info 2016-02-28 14:09:08 +00:00
014_migration.php Add station_profile migration 2019-02-26 19:31:54 +01:00
015_extenddxccprefix.php dxcc tables: extend prefix/call field to 32 characters 2019-05-17 02:01:55 +01:00
016_lotwusers.php Added code to import lotw-useractivity.csv for displaying if users on lotw 2019-06-16 14:31:23 +01:00
017_qslviavarchar.php Remove static table name from migrations 2019-07-24 10:33:10 +02:00
018_clubloguserfields.php Added inputs and table columns to start supporting Clublog uploading 2019-06-19 14:14:10 +01:00
019_forceint_wrongtype.php Remove static table name from migrations 2019-07-24 10:33:10 +02:00
020_apikeydesc.php Added a migration file to create a description in the api table to start #287 2019-06-30 22:26:00 +01:00
021_latlng_wrongtype.php Lat long stored as strong type for whats expected of ADIF. 2019-09-16 21:45:59 +01:00
022_mylatlng_wrongtype.php changed my_lat and my_lng data types due to adif spec 2019-09-16 22:11:12 +01:00
023_col_email_tooshort.php Email col far to short 2019-09-16 22:15:14 +01:00
024_add_column_logbookid.php fixed migration cock up 2019-09-22 21:51:55 +01:00
025_create_logbook_table.php fixed migration cock up 2019-09-22 21:51:55 +01:00
026_addfield_to_logbooks_default.php fixed migration cock up 2019-09-22 21:51:55 +01:00
027_addfield_to_logbooks_active.php fixed migration cock up 2019-09-22 21:51:55 +01:00
028_logbooks_setkeys.php started the logbook table 2019-09-22 21:23:09 +01:00
029_delete_logbooks_table.php Removed yesterdays work decided against its method of implimentation 2019-09-23 16:27:10 +01:00
030_delete_logbookid.php Removed yesterdays work decided against its method of implimentation 2019-09-23 16:27:10 +01:00
031_add_station_id_to_logbook.php Added extra fields 2019-09-23 16:34:18 +01:00
032_add_station_active.php Added extra fields 2019-09-23 16:34:18 +01:00
033_log_setindex_station_id.php Added migration to set the station_id to indexed also created a second station model that returns qso count so that sped things up 2019-09-25 00:38:13 +01:00
034_add_eqslqthnickname_to_stationprofile.php Added a function to assign all QSOs to station profile number 1 and added table field into station profile for eqsl nickname 2019-10-03 12:56:25 +01:00
035_col_mode_tooshort.php was missing .php extention (doh) 2019-10-05 22:54:36 +01:00
036_create_eqsl_images_table.php Wrong migration numbering 2020-03-02 20:44:59 +00:00
037_update_lotw_url.php Migration file to fix LOTW url issue 2020-03-12 15:04:42 +00:00
038_create_iota_tables.php Changed migration table number 2020-03-20 20:00:36 +00:00
039_add_state_to_stationprofile.php Added US state to station profile options 2020-04-08 17:00:25 +01:00
040_add_qrz_api_to_stationprofile.php Added pushing of QSOs to QRZ. 2020-05-07 17:35:58 +02:00
041_create_modes_table.php Added Submode-Support in Logging/ADIF-Export etc. 2020-05-24 00:06:08 +02:00
042_modify_modes_table.php enlarged submodes-filed, updated cropped submodes to original content 2020-08-31 17:11:43 +02:00
043_add_lotw_certs_table.php Tried to make migs match 2020-09-01 17:45:39 +01:00
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 Tried to make migs match 2020-09-01 17:45:39 +01:00
046_add_last_upload_to_lotw_certs.php Tried to make migs match 2020-09-01 17:45:39 +01:00
047_add_cert_to_lotw_certs.php Tried to make migs match 2020-09-01 17:45:39 +01:00
048_add_county_to_stationprofile.php Tried to make migs match 2020-09-01 17:45:39 +01:00
049_add_users_measurement_base.php Class type typo in the migration class should be "add_users_measurement_base" 2020-09-15 16:30:16 +01:00
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 eSQL: Security fix, use HTTPS to send password over the internet 2023-08-29 17:58:22 +02: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 fixed typo 2024-04-09 14:24:30 +01: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