svc-admin01/snipe-it
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
form-row-component-evolved
snipe-it/database/migrations
T
History
snipe 1396c597ef Move files
2025-10-13 11:19:25 +01:00
..
.gitkeep
…
2012_12_06_225921_migration_cartalyst_sentry_install_users.php
…
2012_12_06_225929_migration_cartalyst_sentry_install_groups.php
Drop tables that may exist in down methods
2023-01-23 15:42:45 -08:00
2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot.php
…
2012_12_06_225988_migration_cartalyst_sentry_install_throttle.php
…
2013_03_23_193214_update_users_table.php
…
2013_11_13_075318_create_models_table.php
…
2013_11_13_075335_create_categories_table.php
…
2013_11_13_075347_create_manufacturers_table.php
…
2013_11_15_015858_add_user_id_to_categories.php
…
2013_11_15_112701_add_user_id_to_manufacturers.php
…
2013_11_15_190327_create_assets_table.php
…
2013_11_15_190357_create_temp_licenses_table.php
…
2013_11_15_201848_add_license_name_to_licenses.php
…
2013_11_16_040323_create_depreciations_table.php
…
2013_11_16_042851_add_depreciation_id_to_models.php
…
2013_11_16_084923_add_user_id_to_models.php
…
2013_11_16_103258_create_locations_table.php
…
2013_11_16_103336_add_location_id_to_assets.php
…
2013_11_16_103407_add_checkedout_to_to_assets.php
…
2013_11_16_103425_create_history_table.php
…
2013_11_17_054359_drop_licenses_table.php
…
2013_11_17_054526_add_physical_to_assets.php
Comment out migration's down method to match its up method
2023-01-10 17:25:25 -08:00
2013_11_17_055126_create_settings_table.php
…
2013_11_17_062634_add_license_to_assets.php
…
2013_11_18_134332_add_contacts_to_users.php
…
2013_11_18_142847_add_info_to_locations.php
…
2013_11_18_152942_remove_location_id_from_asset.php
…
2013_11_18_164423_set_nullvalues_for_user.php
…
2013_11_19_013337_create_asset_logs_table.php
…
2013_11_19_061409_edit_added_on_asset_logs_table.php
…
2013_11_19_062250_edit_location_id_asset_logs_table.php
…
2013_11_20_055822_add_soft_delete_on_assets.php
…
2013_11_20_121404_add_soft_delete_on_locations.php
…
2013_11_20_123137_add_soft_delete_on_manufacturers.php
…
2013_11_20_123725_add_soft_delete_on_categories.php
…
2013_11_20_130248_create_status_labels.php
…
2013_11_20_130830_add_status_id_on_assets_table.php
…
2013_11_20_131544_add_status_type_on_status_labels.php
…
2013_11_20_134103_add_archived_to_assets.php
…
2013_11_21_002321_add_uploads_table.php
…
2013_11_21_024531_remove_deployable_boolean_from_status_labels.php
…
2013_11_22_075308_add_option_label_to_settings_table.php
…
2013_11_22_213400_edits_to_settings_table.php
…
2013_11_25_013244_recreate_licenses_table.php
Conditionally drop table
2023-01-10 17:24:38 -08:00
2013_11_25_031458_create_license_seats_table.php
Drop tables that may exist in down methods
2023-01-23 15:42:45 -08:00
2013_11_25_032022_add_type_to_actionlog_table.php
…
2013_11_25_033008_delete_bad_licenses_table.php
…
2013_11_25_033131_create_new_licenses_table.php
…
2013_11_25_033534_add_licensed_to_licenses_table.php
…
2013_11_25_101308_add_warrantee_to_assets_table.php
…
2013_11_25_104343_alter_warranty_column_on_assets.php
Reverse column rename in migration's down method
2023-01-10 17:22:29 -08:00
2013_11_25_150450_drop_parent_from_categories.php
…
2013_11_25_151920_add_depreciate_to_assets.php
…
2013_11_25_152903_add_depreciate_to_licenses_table.php
…
2013_11_26_211820_drop_license_from_assets_table.php
…
2013_11_27_062510_add_note_to_asset_logs_table.php
…
2013_12_01_113426_add_filename_to_asset_log.php
…
2013_12_06_094618_add_nullable_to_licenses_table.php
…
2013_12_10_084038_add_eol_on_models_table.php
Fix column name typo
2023-01-10 17:21:46 -08:00
2013_12_12_055218_add_manager_to_users_table.php
…
2014_01_28_031200_add_qr_code_to_settings_table.php
…
2014_02_13_183016_add_qr_text_to_settings_table.php
…
2014_05_24_093839_alter_default_license_depreciation_id.php
…
2014_05_27_231658_alter_default_values_licenses.php
…
2014_06_19_191508_add_asset_name_to_settings.php
…
2014_06_20_004847_make_asset_log_checkedout_to_nullable.php
…
2014_06_20_005050_make_asset_log_purchasedate_to_nullable.php
…
2014_06_24_003011_add_suppliers.php
…
2014_06_24_010742_add_supplier_id_to_asset.php
…
2014_06_24_012839_add_zip_to_supplier.php
…
2014_06_24_033908_add_url_to_supplier.php
…
2014_07_08_054116_add_employee_id_to_users.php
…
2014_07_09_134316_add_requestable_to_assets.php
…
2014_07_17_085822_add_asset_to_software.php
…
2014_07_17_161625_make_asset_id_in_logs_nullable.php
…
2014_08_12_053504_alpha_0_4_2_release.php
…
2014_08_17_083523_make_location_id_nullable.php
…
2014_10_16_200626_add_rtd_location_to_assets.php
…
2014_10_24_000417_alter_supplier_state_to_32.php
…
2014_10_24_015641_add_display_checkout_date.php
…
2014_10_28_222654_add_avatar_field_to_users_table.php
…
2014_10_29_045924_add_image_field_to_models_table.php
…
2014_11_01_214955_add_eol_display_to_settings.php
…
2014_11_04_231416_update_group_field_for_reporting.php
…
2014_11_05_212408_add_fields_to_licenses.php
…
2014_11_07_021042_add_image_to_supplier.php
…
2014_11_20_203007_add_username_to_user.php
…
2014_11_20_223947_add_auto_to_settings.php
…
2014_11_20_224421_add_prefix_to_settings.php
…
2014_11_21_104401_change_licence_type.php
…
2014_12_09_082500_add_fields_maintained_term_to_licenses.php
…
2015_02_04_155757_increase_user_field_lengths.php
…
2015_02_07_013537_add_soft_deleted_to_log.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2015_02_10_040958_fix_bad_assigned_to_ids.php
…
2015_02_10_053310_migrate_data_to_new_statuses.php
…
2015_02_11_044104_migrate_make_license_assigned_null.php
…
2015_02_11_104406_migrate_create_requests_table.php
…
2015_02_12_001312_add_mac_address_to_asset.php
…
2015_02_12_024100_change_license_notes_type.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2015_02_17_231020_add_localonly_to_settings.php
…
2015_02_19_222322_add_logo_and_colors_to_settings.php
…
2015_02_24_072043_add_alerts_to_settings.php
…
2015_02_25_022931_add_eula_fields.php
…
2015_02_25_204513_add_accessories_table.php
…
2015_02_26_091228_add_accessories_user_table.php
…
2015_02_26_115128_add_deleted_at_models.php
…
2015_02_26_233005_add_category_type.php
…
2015_03_01_231912_update_accepted_at_to_acceptance_id.php
…
2015_03_05_011929_add_qr_type_to_settings.php
…
2015_03_18_055327_add_note_to_user.php
…
2015_04_29_234704_add_slack_to_settings.php
…
2015_05_04_085151_add_parent_id_to_locations_table.php
…
2015_05_22_124421_add_reassignable_to_licenses.php
…
2015_06_10_003314_fix_default_for_user_notes.php
…
2015_06_10_003554_create_consumables.php
…
2015_06_15_183253_move_email_to_username.php
…
2015_06_23_070346_make_email_nullable.php
…
2015_06_26_213716_create_asset_maintenances_table.php
Added migrations
2025-08-10 12:27:59 +01:00
2015_07_04_212443_create_custom_fields_table.php
…
2015_07_09_014359_add_currency_to_settings_and_locations.php
…
2015_07_21_122022_add_expected_checkin_date_to_asset_logs.php
…
2015_07_24_093845_add_checkin_email_to_category_table.php
…
2015_07_25_055415_remove_email_unique_constraint.php
…
2015_07_29_230054_add_thread_id_to_asset_logs_table.php
Comment out migration's down method to match its up method
2023-01-10 17:20:20 -08:00
2015_07_31_015430_add_accepted_to_assets.php
…
2015_09_09_195301_add_custom_css_to_settings.php
…
2015_09_21_235926_create_custom_field_custom_fieldset.php
Remove extraneous { in migration
2022-05-09 11:56:05 -07:00
2015_09_22_000104_create_custom_fieldsets.php
…
2015_09_22_003321_add_fieldset_id_to_assets.php
…
2015_09_22_003413_migrate_mac_address.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2015_09_28_003314_fix_default_purchase_order.php
…
2015_10_01_024551_add_accessory_consumable_price_info.php
…
2015_10_12_192706_add_brand_to_settings.php
…
2015_10_22_003314_fix_defaults_accessories.php
…
2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets.php
…
2015_11_05_061015_create_companies_table.php
…
2015_11_05_061115_add_company_id_to_consumables_table.php
…
2015_11_05_183749_add_image_to_assets.php
Drop the down()
2023-12-19 18:25:21 +00:00
2015_11_06_092038_add_company_id_to_accessories_table.php
…
2015_11_06_100045_add_company_id_to_users_table.php
…
2015_11_06_134742_add_company_id_to_licenses_table.php
…
2015_11_08_035832_add_company_id_to_assets_table.php
…
2015_11_08_222305_add_ldap_fields_to_settings.php
…
2015_11_15_151803_add_full_multiple_companies_support_to_settings_table.php
…
2015_11_26_195528_import_ldap_settings.php
…
2015_11_30_191504_remove_fk_company_id.php
…
2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table.php
…
2015_12_30_233509_add_timestamp_and_userId_to_custom_fields.php
…
2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets.php
…
2016_01_28_041048_add_notes_to_models.php
…
2016_02_19_070119_add_remember_token_to_users_table.php
…
2016_02_19_073625_create_password_resets_table.php
…
2016_03_02_193043_add_ldap_flag_to_users.php
…
2016_03_02_220517_update_ldap_filter_to_longer_field.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2016_03_08_225351_create_components_table.php
…
2016_03_09_024038_add_min_stock_to_tables.php
…
2016_03_10_133849_add_locale_to_users.php
…
2016_03_10_135519_add_locale_to_settings.php
…
2016_03_11_185621_add_label_settings_to_settings.php
…
2016_03_22_125911_fix_custom_fields_regexes.php
…
2016_04_28_141554_add_show_to_users.php
…
2016_05_16_164733_add_model_mfg_to_consumable.php
…
2016_05_19_180351_add_alt_barcode_settings.php
…
2016_05_19_191146_add_alter_interval.php
…
2016_05_19_192226_add_inventory_threshold.php
…
2016_05_20_024859_remove_option_keys_from_settings_table.php
…
2016_05_20_143758_remove_option_value_from_settings_table.php
…
2016_06_01_000001_create_oauth_auth_codes_table.php
…
2016_06_01_000002_create_oauth_access_tokens_table.php
…
2016_06_01_000003_create_oauth_refresh_tokens_table.php
…
2016_06_01_000004_create_oauth_clients_table.php
…
2016_06_01_000005_create_oauth_personal_access_clients_table.php
…
2016_06_01_140218_add_email_domain_and_format_to_settings.php
…
2016_06_22_160725_add_user_id_to_maintenances.php
…
2016_07_13_150015_add_is_ad_to_settings.php
…
2016_07_14_153609_add_ad_domain_to_settings.php
…
2016_07_22_003348_fix_custom_fields_regex_stuff.php
…
2016_07_22_054850_one_more_mac_addr_fix.php
…
2016_07_22_143045_add_port_to_ldap_settings.php
…
2016_07_22_153432_add_tls_to_ldap_settings.php
…
2016_07_27_211034_add_zerofill_to_settings.php
…
2016_08_02_124944_add_color_to_statuslabel.php
…
2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings.php
…
2016_08_09_002225_add_manufacturer_to_licenses.php
…
2016_08_12_121613_add_manufacturer_to_accessories_table.php
…
2016_08_23_143353_add_new_fields_to_custom_fields.php
…
2016_08_23_145619_add_show_in_nav_to_status_labels.php
Move drop column command to correct migration
2023-01-10 17:06:16 -08:00
2016_08_30_084634_make_purchase_cost_nullable.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2016_09_01_141051_add_requestable_to_asset_model.php
…
2016_09_02_001448_create_checkout_requests_table.php
…
2016_09_04_180400_create_actionlog_table.php
…
2016_09_04_182149_migrate_asset_log_to_action_log.php
…
2016_09_19_235935_fix_fieldtype_for_target_type.php
…
2016_09_23_140722_fix_modelno_in_consumables_to_string.php
…
2016_09_28_231359_add_company_to_logs.php
…
2016_10_14_130709_fix_order_number_to_varchar.php
…
2016_10_16_015024_rename_modelno_to_model_number.php
…
2016_10_16_015211_rename_consumable_modelno_to_model_number.php
…
2016_10_16_143235_rename_model_note_to_notes.php
…
2016_10_16_165052_rename_component_total_qty_to_qty.php
…
2016_10_19_145520_fix_order_number_in_components_to_string.php
…
2016_10_27_151715_add_serial_to_components.php
…
2016_10_27_213251_increase_serial_field_capacity.php
…
2016_10_29_002724_enable_2fa_fields.php
…
2016_10_29_082408_add_signature_to_acceptance.php
…
2016_11_01_030818_fix_forgotten_filename_in_action_logs.php
…
2016_11_13_020954_rename_component_serial_number_to_serial.php
…
2016_11_16_172119_increase_purchase_cost_size.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2016_11_17_161317_longer_state_field_in_location.php
…
2016_11_17_193706_add_model_number_to_accessories.php
…
2016_11_24_160405_add_missing_target_type_to_logs_table.php
…
2016_12_07_173720_increase_size_of_state_in_suppliers.php
…
2016_12_19_004212_adjust_locale_length_to_10.php
…
2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere.php
…
2016_12_27_212631_make_asset_assigned_to_polymorphic.php
…
2017_01_09_040429_create_locations_ldap_query_field.php
…
2017_01_14_002418_create_imports_table.php
…
2017_01_25_063357_fix_utf8_custom_field_column_names.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2017_03_03_154632_add_time_date_display_to_settings.php
…
2017_03_10_210807_add_fields_to_manufacturer.php
Reference the correct table in migration down method
2023-01-10 17:04:21 -08:00
2017_05_08_195520_increase_size_of_field_values_in_custom_fields.php
…
2017_05_22_204422_create_departments.php
…
2017_05_22_233509_add_manager_to_locations_table.php
…
2017_06_14_122059_add_next_autoincrement_to_settings.php
…
2017_06_18_151753_add_header_and_first_row_to_importer_table.php
…
2017_07_07_191533_add_login_text.php
…
2017_07_25_130710_add_thumbsize_to_settings.php
…
2017_08_03_160105_set_asset_archived_to_zero_default.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2017_08_22_180636_add_secure_password_options.php
…
2017_08_25_074822_add_auditing_tables.php
…
2017_08_25_101435_add_auditing_to_settings.php
…
2017_09_18_225619_fix_assigned_type_not_being_nulled.php
…
2017_10_03_015503_drop_foreign_keys.php
…
2017_10_10_123504_allow_nullable_depreciation_id_in_models.php
…
2017_10_17_133709_add_display_url_to_settings.php
…
2017_10_19_120002_add_custom_forgot_password_url.php
…
2017_10_19_130406_add_image_and_supplier_to_accessories.php
…
2017_10_20_234129_add_location_indices_to_assets.php
…
2017_10_25_202930_add_images_uploads_to_locations_manufacturers_etc.php
…
2017_10_27_180947_denorm_asset_locations.php
…
2017_10_27_192423_migrate_denormed_asset_locations.php
…
2017_10_30_182938_add_address_to_user.php
…
2017_11_08_025918_add_alert_menu_setting.php
…
2017_11_08_123942_labels_display_company_name.php
…
2017_12_12_010457_normalize_asset_last_audit_date.php
…
2017_12_12_033618_add_actionlog_meta.php
…
2017_12_26_170856_re_normalize_last_audit.php
…
2018_01_17_184354_add_archived_in_list_setting.php
…
2018_01_19_203121_add_dashboard_message_to_settings.php
…
2018_01_24_062633_add_footer_settings_to_settings.php
…
2018_01_24_093426_add_modellist_preferenc.php
…
2018_02_22_160436_add_remote_user_settings.php
…
2018_03_03_011032_add_theme_to_settings.php
…
2018_03_06_054937_add_default_flag_on_statuslabels.php
…
2018_03_23_212048_add_display_in_email_to_custom_fields.php
…
2018_03_24_030738_add_show_images_in_email_setting.php
…
2018_03_24_050108_add_cc_alerts.php
…
2018_03_29_053618_add_canceled_at_and_fulfilled_at_in_requests.php
…
2018_03_29_070121_add_drop_unique_requests.php
…
2018_03_29_070511_add_new_index_requestable.php
…
2018_04_02_150700_labels_display_model_name.php
…
2018_04_16_133902_create_custom_field_default_values_table.php
…
2018_05_04_073223_add_category_to_licenses.php
…
2018_05_04_075235_add_update_license_category.php
…
2018_05_08_031515_add_gdpr_privacy_footer.php
…
2018_05_14_215229_add_indexes.php
…
2018_05_14_223646_add_indexes_to_assets.php
…
2018_05_14_233638_denorm_counters_on_assets.php
…
2018_05_16_153409_add_first_counter_totals_to_assets.php
…
2018_06_21_134622_add_version_footer.php
…
2018_07_05_215440_add_unique_serial_option_to_settings.php
…
2018_07_17_005911_create_login_attempts_table.php
…
2018_07_24_154348_add_logo_to_print_assets.php
…
2018_07_28_023826_create_checkout_acceptances_table.php
Merging master down into develop
2022-03-16 18:02:07 +00:00
2018_08_08_100000_create_telescope_entries_table.php
Check if telescope tables already exist
2025-10-01 11:24:20 +01:00
2018_08_20_204842_add_depreciation_option_to_settings.php
…
2018_09_10_082212_create_checkout_acceptances_for_unaccepted_assets.php
…
2018_10_18_191228_add_kits_licenses_table.php
Merge master back down into develop
2022-03-29 16:28:43 +01:00
2018_10_19_153910_add_kits_table.php
Merge master back down into develop
2022-03-29 16:28:43 +01:00
2018_10_19_154013_add_kits_models_table.php
Merge master back down into develop
2022-03-29 16:28:43 +01:00
2018_12_05_211936_add_favicon_to_settings.php
…
2018_12_05_212119_add_email_logo_to_settings.php
…
2019_02_07_185953_add_kits_consumables_table.php
Merge master back down into develop
2022-03-29 16:28:43 +01:00
2019_02_07_190030_add_kits_accessories_table.php
Merge master back down into develop
2022-03-29 16:28:43 +01:00
2019_02_12_182750_add_actiondate_to_actionlog.php
…
2019_02_14_154310_change_auto_increment_prefix_to_nullable.php
…
2019_02_16_143518_auto_increment_back_to_string.php
…
2019_02_17_205048_add_label_logo_to_settings.php
…
2019_02_20_234421_make_serial_nullable.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2019_02_21_224703_make_fields_nullable_for_integrity.php
…
2019_04_06_060145_add_user_skin_setting.php
…
2019_04_06_205355_add_setting_allow_user_skin.php
…
2019_06_12_184327_rename_groups_table.php
…
2019_07_23_140906_add_show_assigned_assets_to_settings.php
…
2019_08_20_084049_add_custom_remote_user_header.php
…
2019_12_04_223111_passport_upgrade.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2020_02_04_172100_add_ad_append_domain_settings.php
…
2020_04_29_222305_add_saml_fields_to_settings.php
…
2020_08_11_200712_add_saml_key_rollover.php
…
2020_10_22_233743_move_accessory_checkout_note_to_join_table.php
…
2020_10_23_161736_fix_zero_values_for_locations.php
…
2020_11_18_214827_widen_license_serial_field.php
…
2020_12_14_233815_add_digit_separator_to_settings.php
…
2020_12_18_090026_swap_target_type_index_order.php
…
2020_12_21_153235_update_min_password.php
…
2020_12_21_210105_fix_bad_ldap_server_url_for_v5.php
…
2021_02_05_172502_add_provider_to_oauth_table.php
…
2021_03_18_184102_adds_several_ldap_fields.php
…
2021_04_07_001811_add_ldap_dept.php
…
2021_04_14_180125_add_ids_to_tables.php
Allow the migration of sqlite databases
2023-03-23 17:40:03 -07:00
2021_06_07_155421_add_serial_number_indexes.php
…
2021_06_07_155436_add_company_id_indexes.php
…
2021_07_28_031345_add_client_side_l_d_a_p_cert_to_settings.php
…
2021_07_28_040554_add_client_side_l_d_a_p_key_to_settings.php
…
2021_08_11_005206_add_depreciation_minimum_value.php
…
2021_08_24_124354_make_ldap_client_certs_nullable.php
…
2021_09_20_183216_change_default_label_to_nullable.php
…
2021_12_27_151849_change_supplier_address_length.php
…
2022_01_10_182548_add_license_id_index_to_license_seats.php
Backport the license index fix from Develop onto the v5 branch
2022-04-12 20:11:25 +01:00
2022_02_03_214958_blank_out_ldap_active_flag.php
…
2022_02_10_110210_add_company_id_to_locations.php
Add ability to tie locations to companies
2024-11-04 10:03:37 +01:00
2022_02_16_152431_add_unique_constraint_to_custom_field.php
…
2022_03_03_225655_add_notes_to_accessories.php
Added notes migration
2022-03-03 20:30:58 -08:00
2022_03_03_225754_add_notes_to_components.php
Added notes migration
2022-03-03 20:30:58 -08:00
2022_03_03_225824_add_notes_to_consumables.php
Added notes migration
2022-03-03 20:30:58 -08:00
2022_03_04_080836_add_remote_to_user.php
Add remote option to user
2022-03-04 05:35:26 -08:00
2022_03_09_001334_add_eula_to_checkout_acceptance.php
Check for column
2022-07-08 16:46:00 -07:00
2022_03_10_175740_add_eula_to_action_logs.php
adds translation for accept_eula, a bit more logic on the Acceptance Controller that is not working yet
2022-03-10 12:15:50 -08:00
2022_03_21_162724_adds_ldap_manager.php
WIP: needs to be tested. adds ldap_manager field to ldap sync
2022-03-21 11:15:39 -07:00
2022_04_05_135340_add_primary_key_to_custom_fields_pivot.php
Update migration back in time
2022-04-05 20:31:17 +01:00
2022_05_16_235350_remove_stored_eula_field.php
Migration to drop stored_eula_column
2022-05-19 17:55:59 -07:00
2022_06_23_164407_add_user_id_to_users.php
Added migration to store admin ID
2022-06-23 17:17:38 -07:00
2022_06_28_234539_add_username_index_to_users.php
Add index across username and deleted_at to improve large directory sync performance
2022-06-28 17:12:14 -07:00
2022_07_07_010406_add_indexes_to_license_seats.php
This adds some indexes for performance on license_seats
2022-07-06 18:10:48 -07:00
2022_08_10_141328_add_notes_denorm_to_consumables_users.php
Added DB migration
2022-08-10 14:54:33 -07:00
2022_08_25_213308_adds_ldap_default_group_to_settings_table.php
redid a few things. should be good now :)
2022-12-15 10:45:42 -08:00
2022_09_29_040231_add_chart_type_to_settings.php
Added setting to choose dashboard type
2022-09-29 04:16:46 -07:00
2022_10_05_163044_add_start_termination_date_to_users.php
Added start_date and end_date migration to users table
2022-10-05 16:55:59 -07:00
2022_10_25_193823_add_externalid_to_users.php
Set scim_externalid to nullable, default null
2022-10-25 14:38:19 -07:00
2022_10_25_215520_add_label2_settings.php
Remove trans() from default values
2023-08-23 08:19:05 +01:00
2022_11_07_134348_add_display_to_user_in_custom_fields.php
Migration to add the field to the custom_fields table
2022-11-08 15:27:34 +00:00
2022_11_15_232525_adds_should_autoassign_bool_to_users_table.php
missed a few renames
2023-01-18 08:57:59 -08:00
2022_12_20_171851_fix_nullable_migration_for_settings.php
Sets the ldap_default_group field to nullable and default null
2022-12-20 17:24:01 -08:00
2023_01_18_122534_add_byod_to_assets.php
BYOD migration
2023-01-18 13:10:39 -08:00
2023_01_21_225350_add_eol_date_on_assets_table.php
Added the temp column back in
2023-10-13 12:39:28 +01:00
2023_01_23_232933_add_vip_to_users.php
vipuser label updated to vip
2023-01-25 15:58:44 -05:00
2023_02_12_224353_fix_unescaped_customfields_format.php
Add migration to fix already escaped formats in the database
2023-02-12 17:40:04 -06:00
2023_02_27_092130_add_scope_locations_setting.php
Add a backward compatibility setting for locations with companies
2024-11-04 10:03:38 +01:00
2023_02_28_173527_adds_webhook_option_to_settings_table.php
Allow the migration of sqlite databases
2023-03-23 17:40:03 -07:00
2023_03_21_215218_update_slack_setting.php
Trying other save method, I guess?
2023-03-21 22:10:30 -07:00
2023_04_12_135822_add_supplier_to_components.php
Migration to add supplier ID to components and consumables
2023-04-13 11:06:49 -07:00
2023_04_25_085912_add_autoadd_to_customfields.php
Added auto_add_to_fieldsets field
2023-04-25 15:51:36 -07:00
2023_04_25_181817_adds_ldap_location_to_settings_table.php
added ldap_location to settings
2023-04-25 11:44:04 -07:00
2023_04_26_160235_add_warranty_url_to_manufacturers.php
Added dynamic warranty URL to manufacturers
2023-04-26 16:39:15 -07:00
2023_05_08_132921_increase_state_to_more_than_3.php
Migration to embiggen state fields
2023-05-08 14:13:06 -07:00
2023_05_10_001836_add_google_auth_to_settings.php
Removed redirect option
2023-05-10 00:54:46 -07:00
2023_07_05_092237_change_settings_table_increase_saml_idp_metadata_size.php
Change settings table saml_idp_metadata to MEDIUMTEXT
2023-07-05 17:28:08 +01:00
2023_07_06_092507_add_phone_fax_to_locations.php
Added phone, fax to departments, locations, companies
2023-07-10 19:44:21 +01:00
2023_07_13_052204_denormalized_eol_and_add_column_for_explicit_date_to_assets.php
use query builder instead of model for update to skip observer
2024-01-03 18:32:13 -06:00
2023_07_14_004221_add_show_in_list_view_to_custom_fields.php
Added ability to show/hide custom fields in list views by default
2023-07-14 09:09:43 +01:00
2023_08_01_174150_change_webhook_settings_variable_type.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2023_08_13_172600_add_email_to_companies.php
Create 2023_08_13_172600_add_email_to_companies.php
2023-08-13 17:25:33 +02:00
2023_08_17_202638_add_last_checkin_to_assets.php
Fix update statement
2023-08-17 18:33:01 -07:00
2023_08_21_064609_add_name_ordering_to_settings.php
Added migration to add name order to settings
2023-08-21 20:09:48 +01:00
2023_08_21_181742_add_min_amt_to_models_table.php
adds min_amt to asset model edit, index, and table
2023-08-24 10:30:07 -07:00
2023_08_23_232739_create_report_templates_table.php
Update remaining comments from snipe/snipe-it to grokability/snipe-it
2025-04-03 12:07:05 -07:00
2023_09_13_200913_fix_asset_model_min_qty_nullability.php
changed the down method change
2023-09-13 13:24:26 -07:00
2023_10_25_064324_add_show_in_requestable_to_custom_fields.php
Make field nullable
2023-10-25 17:26:31 +01:00
2023_12_14_032522_add_remote_ip_and_action_source_to_action_logs.php
Added DB migration for remote_ip, action_source, user_agent in logs
2023-12-14 14:32:26 +00:00
2023_12_15_024643_add_indexes_to_new_activity_report_fields.php
Added indexes for reports
2023-12-15 13:24:01 +00:00
2023_12_19_081112_fix_language_dirs.php
Import DB facade
2025-07-28 16:17:11 +01:00
2024_01_24_145544_create_saml_nonce_table.php
Remove commented-out timestamps on the saml_nonces table
2024-01-25 20:13:49 +00:00
2024_02_28_080016_add_created_by_to_permission_groups.php
Added created_by to groups table
2024-02-28 08:15:59 +00:00
2024_02_28_093807_add_min_qty_to_licenses.php
Migration for min_amt on licenses
2024-02-28 11:06:01 +00:00
2024_03_18_164714_add_note_to_checkout_acceptance_table.php
fix class name in migration
2024-04-03 11:47:08 -07:00
2024_03_18_221612_update_legacy_locale.php
adding in change to settings table
2024-03-26 16:50:39 -04:00
2024_05_27_143554_add_parent_id_index_to_locations.php
Add index to 'parent_id' for users with large number of locations
2024-05-27 15:38:42 +01:00
2024_06_24_130348_add_profile_edit_to_settings.php
Added migration
2024-06-24 14:01:31 +01:00
2024_07_04_103729_add_default_avatar_to_settings.php
Added migration
2024-07-04 13:24:11 +01:00
2024_07_16_184145_add_deprecitation_type_to_depreciations_table.php
battling with handling depreciation percentage and amount
2024-07-16 12:25:19 -07:00
2024_07_23_172032_change_no__n_o_to_nb__n_o.php
Migration
2024-07-23 17:35:06 +01:00
2024_07_26_143301_add_checkout_for_all_types_to_accessories.php
Adjusted missing down on migration and code smells
2024-07-29 19:04:10 +02:00
2024_08_01_201721_add_required_notes_setting.php
front end changes/updates from gh
2024-10-02 18:15:52 -04:00
2024_08_06_175114_add_shortcuts_enabled_to_settings_table.php
adds migration and translations
2024-08-06 11:07:39 -07:00
2024_08_07_204014_add_play_sounds_to_profile.php
Added migration
2024-08-07 20:41:13 +01:00
2024_08_15_111816_add_confetti_to_users.php
Added confetti option
2024-08-15 11:32:42 +01:00
2024_08_16_104137_add_due_checkin_days_to_settings.php
Added missing migration from #15314
2024-08-16 10:44:28 +01:00
2024_09_17_204302_change_user_id_to_created_by.php
Fix rollback for created_by
2024-11-18 12:24:47 -08:00
2024_10_23_162301_add_manufacturer_id_model_number_to_consumables.php
Added manufacturer and model_number to components
2024-10-23 17:50:22 +01:00
2024_10_31_212512_update_new_and_drop_old_barcode_settings.php
adds migration to update new with old if blank and remove old barcod variables
2024-10-31 14:35:13 -07:00
2024_11_06_211457_add_manager_indexes_to_location_and_user.php
Add new indexes to locations and users for faster manager lookups
2024-11-06 21:19:41 +00:00
2024_11_07_113631_improve_manager_indexes_on_users_and_locations.php
Improved indexes on manager_id for locations and users, including deleted_at
2024-11-07 11:39:27 +00:00
2025_01_06_210534_change_report_templates_options_to_column_text_field.php
Update remaining comments from snipe/snipe-it to grokability/snipe-it
2025-04-03 12:07:05 -07:00
2025_01_07_172419_fix_label_types_on_settings_table.php
Fix tests and fix migrations to always explicitly include nullable()
2025-02-22 12:15:12 +00:00
2025_01_15_190348_adds_unavailable_to_license_seats_tables.php
removed unused models, castged unreassignable_seat, clean up in general
2025-01-21 11:43:47 -08:00
2025_02_10_230155_add_notes_to_locations_companies_categories_manufacturers_groups.php
Pointless rename
2025-02-11 18:32:51 +00:00
2025_02_22_144518_add_checkin_checkout_to_customfields.php
Added migration
2025-02-22 18:11:35 +00:00
2025_02_26_153413_add_ldap_invert_active_flag_to_setting_table.php
Set default to 0
2025-03-04 20:38:22 +00:00
2025_03_04_231256_purge_action_logs_of_report_template_activity.php
Purge activity log of report template data
2025-03-04 15:20:23 -08:00
2025_03_06_152922_copy_created_at_to_action_date_in_action_logs.php
Add index on action_date, copy from created_at
2025-03-06 16:01:46 +00:00
2025_03_12_184851_purge_action_logs_table_of_consumable_checkin_entries.php
Purge activity log of consumable bulk checkins
2025-03-12 11:57:18 -07:00
2025_04_02_113438_add_acceptance_pdf_logo_to_settings.php
Added migration
2025-04-02 12:09:57 +01:00
2025_04_07_145418_add_custom_fields_to_audit.php
Added migration
2025-04-07 22:10:18 +01:00
2025_04_22_170731_add_empty_row_count_to_settings_table.php
adds Field offset option to labels
2025-04-22 10:50:20 -07:00
2025_05_12_183803_add_req_serial_bool_to_models_table.php
added require_serial to model factory
2025-05-20 09:53:51 -07:00
2025_05_20_190317_repopulate_webhook_selected_setting.php
Check to make sure settings exist before attempting to update them
2025-05-20 12:45:23 -07:00
2025_06_02_233556_add_admin_cc_always_to_settings_table.php
Add migration for admin_cc_always
2025-06-02 17:03:14 -07:00
2025_06_03_000000_add_manager_view_enabled_to_settings_table.php
Manager View Feature
2025-06-04 09:07:26 +02:00
2025_06_03_053438_fix_assigned_type_without_assigned_to.php
Added migration to fix existing wonky data
2025-06-03 05:37:37 +01:00
2025_06_04_101736_add_deleted_at_index_to_action_logs.php
Allow Laravel to calculate index name
2025-10-07 16:04:12 -07:00
2025_06_05_200518_add_alert_on_response_id_to_checkout_acceptances_table.php
Add alert_on_response_id to CheckoutAcceptance
2025-06-05 13:10:18 -07:00
2025_06_05_204139_add_alert_on_response_to_categories_table.php
Add alert_on_response to Category
2025-06-05 13:43:20 -07:00
2025_06_06_155058_make_supplier_id_nullable.php
Make supplier_id nullable
2025-06-06 15:55:54 +01:00
2025_07_16_142036_clean_checkout_acceptances.php
New Artisan command to clean checkout acceptances and a migration that runs it
2025-07-16 16:06:23 +01:00
2025_08_06_192954_add_image_to_maintenances.php
Added migration
2025-08-07 15:37:16 +01:00
2025_08_10_111553_rename_title_to_name_on_asset_maintenances.php
Added migrations
2025-08-10 12:27:59 +01:00
2025_08_10_113444_rename_asset_maintenances_to_maintenances.php
Added migrations
2025-08-10 12:27:59 +01:00
2025_08_10_114135_change_asset_maintenance_in_logs_to_maintenance.php
Added migrations
2025-08-10 12:27:59 +01:00
2025_08_11_181519_add_mobile_number_to_users_table.php
Fixed #10284: Added mobile phone to users
2025-08-11 18:38:22 +01:00
2025_08_12_225214_add_qty_to_checkout_acceptances_table.php
Wrap migration in check
2025-09-03 12:52:46 -07:00
2025_08_19_114742_add_display_name_to_users.php
Are you KIDDING ME, Github??
2025-08-25 15:56:28 +01:00
2025_08_19_122533_add_category_indexes.php
Add new indexes to category_id and deleted_at
2025-08-19 14:20:36 +01:00
2025_08_19_174823_add_display_name_to_ldap_settings.php
Are you KIDDING ME, Github??
2025-08-25 15:56:28 +01:00
2025_08_20_190617_add_created_at_index_to_models.php
Adds a 'created_at' index to the models table
2025-08-21 13:44:14 +01:00
2025_09_16_104604_create_users_deleted_at_location_id_index.php
Add new index to users over deleted_at and location_id
2025-09-16 11:54:24 +01:00
2025_10_07_113331_add_url_to_maintenances.php
Fixed #17924 - added url to maintenances
2025-10-07 11:49:10 +01:00
2025_10_13_102956_move_assetmodels_files.php
Move files
2025-10-13 11:19:25 +01:00