Index of /servicesystem-staging/servicesystem/db/migrate

	Name	Last modified	Size	Description
	Parent Directory		-
	20170802101314_initial.rb	2017-11-14 13:22	30K
	20170807095724_remove_unwanted_columns_from_work_orders.rb	2017-11-14 13:22	957
	20170807101657_remove_payroll_status_from_technician_trips.rb	2017-11-14 13:22	161
	20170807112114_add_column_completed_at_in_trips.rb	2017-11-14 13:22	136
	20170807113314_add_column_issue_reported_in_trips.rb	2017-11-14 13:22	155
	20170807125107_add_column_status_in_technician_trips.rb	2017-11-14 13:22	144
	20170807142452_add_position_to_trip.rb	2017-11-14 13:22	121
	20170807144742_update_work_order_services_to_version_2.rb	2017-11-14 13:22	160
	20170807154011_update_technician_trip_statuses_to_version_2.rb	2017-11-14 13:22	525
	20170809144818_add_proposal_id_to_work_order_log.rb	2017-11-14 13:22	144
	20170810160606_remove_email_first_name_last_name_and_picture_from_tradesmen.rb	2017-11-14 13:22	498
	20170810161206_add_uniq_index_on_ftc_user_name_in_tradesmen.rb	2017-11-14 13:22	152
	20170814093415_add_column_access_key_in_companies.rb	2017-11-14 13:22	142
	20170814105527_create_tradesmen_locations.rb	2017-11-14 13:22	216
	20170814112622_add_column_supervisor_id_in_tradesmen.rb	2017-11-14 13:22	158
	20170814112624_update_work_order_services_to_version_3.rb	2017-11-14 13:22	863
	20170821121212_create_services.rb	2017-11-14 13:22	401
	20170823095309_create_service_exceptions.rb	2017-11-14 13:22	332
	20170823113109_add_supervisor_id_to_location.rb	2017-11-14 13:22	138
	20170823132327_remove_start_and_end_time_tradesmen_invoice_settings.rb	2017-11-14 13:22	382
	20170824082319_remove_ftc_work_order_id_from_trips.rb	2017-11-14 13:22	144
	20170824082359_add_ftc_work_order_id_status_to_technician_trip.rb	2017-11-14 13:22	271
	20170824111709_add_ftc_work_order_id_to_trip.rb	2017-11-14 13:22	200
	20170824160818_change_contracts_start_and_end_dates_type.rb	2017-11-14 13:22	232
	20170825085505_add_columns_service_id_and_exception_reasons_in_service_exceptions.rb	2017-11-14 13:22	264
	20170825092342_add_columns_scheculed_start_time_scheduled_end_time_in_service_exceptions.rb	2017-11-14 13:22	260
	20170825105814_add_supervisor_id_to_invoice_settings.rb	2017-11-14 13:22	207
	20170825110622_move_scheduled_start_time_and_scheduled_end_time_in_services_from_service_exceptions.rb	2017-11-14 13:22	391
	20170825112628_remove_column_technician_trip_id_from_service_exceptions.rb	2017-11-14 13:22	179
	20170825153619_add_columns_check_in_time_and_check_out_time_in_service_exceptions.rb	2017-11-14 13:22	241
	20170830082040_add_suppressed_by_type_to_service_exceptions.rb	2017-11-14 13:22	164
	20170831154159_add_days_to_tradesmen_invoice_settings.rb	2017-11-14 13:22	164
	20170906135336_add_first_and_last_name_to_tradesmen.rb	2017-11-14 13:22	186
	20170911142848_add_ftc_affiliate_id_to_company.rb	2017-11-14 13:22	141
	20170914092222_create_daily_schedules.rb	2017-11-14 13:22	275
	20170914092513_add_ftc_id_to_work_order.rb	2017-11-14 13:22	126
	20170918142930_add_manually_changed_to_schedules.rb	2017-11-14 13:22	167
	20170919101253_add_column_company_id_in_company_related_tables.rb	2017-11-14 13:22	507
	20170920124552_remove_column_type_from_users.rb	2018-11-28 08:13	243
	20170920134913_create_company_users.rb	2018-11-28 08:13	1.0K
	20170927094150_remove_contanct_people.rb	2018-11-28 08:13	440
	20171004072333_create_company_clients.rb	2018-11-28 08:13	401
	20171004073146_move_clients_to_company.rb	2018-11-28 08:13	3.0K
	20171030115619_change_invoice_settings_to_contracts.rb	2018-11-28 08:13	140
	20171030123405_remove_foreign_key_reference_for_invoice_settings.rb	2018-11-28 08:13	793
	20171030131644_change_status_and_version_column_types.rb	2018-11-28 08:13	222
	20171030154824_rename_tables_related_to_invoice_settings.rb	2018-11-28 08:13	373
	20171101070122_change_tradesmen_invoice_setting_id_to_contract_id_in_daily_schedules.rb	2018-11-28 08:13	210
	20171101113604_add_single_mode_to_work_order.rb	2018-11-28 08:13	152
	20171102125822_create_tax.rb	2018-11-28 08:13	251
	20171108075326_add_quick_book_credentials.rb	2018-11-28 08:13	257
	20171108083752_create_identities.rb	2018-11-28 08:13	275
	20171108121000_add_company_id_and_vendor_id_to_contracts.rb	2018-11-28 08:13	192
	20171109105711_add_column_quickbook_id_to_invoice.rb	2018-11-28 08:13	140
	20171109114701_create_quickbook_customer.rb	2018-11-28 08:13	241
	20171109114712_create_quickbook_subcustomer.rb	2018-11-28 08:13	276
	20171110142923_change_invoice_scheduler_to_scheduler.rb	2018-11-28 08:13	144
	20171113090344_create_integrations.rb	2018-11-28 08:13	1.8K
	20171113091548_change_invoice_type_to_schedule_type_invoice_schedulers.rb	2018-11-28 08:13	231
	20171113120841_change_scheduler_type_in_scheduler.rb	2018-11-28 08:13	191
	20171116103056_add_column_vendor_id_to_area.rb	2018-11-28 08:13	128
	20171117092136_add_work_order_service_fields_to_services.rb	2018-11-28 08:13	405
	20171117094402_change_association_from_work_order_log_to_service.rb	2018-11-28 08:13	171
	20171120081947_add_column_extended_status_code_in_technician_trips.rb	2018-11-28 08:13	494
	20171120100355_add_column_extended_status_code_in_trips.rb	2018-11-28 08:13	396
	20171120110746_add_column_extended_status_code_in_work_orders.rb	2018-11-28 08:13	449
	20171120113533_add_column_extended_status_code_in_locations.rb	2018-11-28 08:13	432
	20171121071043_add_column_expected_status_change_at_in_technician_trips.rb	2018-11-28 08:13	181
	20171121071101_add_column_expected_status_change_at_in_trips.rb	2018-11-28 08:13	160
	20171121071117_add_column_expected_status_change_at_in_work_orders.rb	2018-11-28 08:13	171
	20171121093642_create_company_location_statuses.rb	2018-11-28 08:13	307
	20171121120125_remove_column_extended_status_code_from_locations.rb	2018-11-28 08:13	166
	20171122150834_add_column_last_sign_in_company_id_in_users.rb	2018-11-28 08:13	454
	20171124065858_create_image.rb	2018-11-28 08:13	259
	20171124131242_remove_attachment_column.rb	2018-11-28 08:13	4.7K
	20171127115951_add_past_company_id_to_contracts.rb	2018-11-28 08:13	142
	20171206140136_remove_unwanted_columns_from_agreements.rb	2018-11-28 08:13	1.1K
	20171218140459_create_tradesmen_trips.rb	2018-11-28 08:13	264
	20171219075813_rename_technician_trip_id_to_tradesmen_trip_id.rb	2018-11-28 08:13	169
	20171219115839_add_type_to_tradesmen_contract.rb	2018-11-28 08:13	1.1K
	20171220074048_rename_technician_trip_id_to_tradesmen_trip_id_in_work_order_services.rb	2018-11-28 08:13	199
	20171220114722_create_agreement_contracts.rb	2018-11-28 08:13	3.2K
	20180101064334_create_monthly_schedules.rb	2018-11-28 08:13	944
	20180101064335_update_money_fields.rb	2018-11-28 08:13	670
	20180104102827_add_columns_resource_id_and_resource_type_in_invoices.rb	2018-11-28 08:13	698
	20180105095340_change_table_daily_schedules_v1.rb	2018-11-28 08:13	3.2K
	20180110095859_add_equipments_to_contracts.rb	2018-11-28 08:13	145
	20180111105807_move_past_company_id_from_contract_agreement_contract.rb	2018-11-28 08:13	228
	20180111152717_add_column_deleted_at_to_agreement_contract_and_tradesmen_contract.rb	2018-11-28 08:13	288
	20180116124810_create_area_inspections.rb	2018-11-28 08:13	200
	20180116132957_create_area_inspection_items.rb	2018-11-28 08:13	218
	20180116140752_create_area_ratings.rb	2018-11-28 08:13	204
	20180116141106_create_area_rating_items.rb	2018-11-28 08:13	303
	20180117083542_remove_supervisor_id_from_tradesmen.rb	2018-11-28 08:13	147
	20180123083506_rename_invoice_date_to_due_date_in_invoice.rb	2018-11-28 08:13	150
	20180123111902_add_column_resource_and_target_to_work_order_note.rb	2018-11-28 08:13	901
	20180130103952_add_fax_to_contacts.rb	2018-11-28 08:13	117
	20180201134546_add_closed_and_closed_by_id_to_technician_trips.rb	2018-11-28 08:13	226
	20180212121206_add_column_location_id_and_vendor_id_in_area_ratings.rb	2018-11-28 08:13	323
	20180213123047_add_details_company_type_to_companies.rb	2018-11-28 08:13	660
	20180213133820_create_documents.rb	2018-11-28 08:13	265
	20180214114549_add_approved_at_to_company_user.rb	2018-11-28 08:13	142
	20180215082646_create_regions.rb	2018-11-28 08:13	389
	20180216160944_add_ftc_tag_area_id_to_area_rating.rb	2018-11-28 08:13	144
	20180220160304_create_licenses.rb	2018-11-28 08:13	244
	20180220161042_create_rates.rb	2018-11-28 08:13	279
	20180221155303_change_after_hours_phone_type_in_company.rb	2018-11-28 08:13	153
	20180222123110_update_index_on_ftc_user_name_in_tradesmen.rb	2018-11-28 08:13	226
	20180226120723_rename_column_closed_to_closed_at_in_technician_trip.rb	2018-11-28 08:13	579
	20180305083849_create_region_trades.rb	2018-11-28 08:13	328
	20180305092040_create_region_licenses.rb	2018-11-28 08:13	348
	20180305105430_create_region_assigned_rates.rb	2018-11-28 08:13	289
	20180305141430_add_company_id_to_trade_material_rate_licenses.rb	2018-11-28 08:13	240
	20180308093253_add_locations_count.rb	2018-11-28 08:13	291
	20180308101002_change_deleted_column_to_deleted_at_in_location.rb	2018-11-28 08:13	456
	20180312072127_add_column_paid_to_scheduler_event.rb	2018-11-28 08:13	156
	20180313081436_add_duration_to_services.rb	2018-11-28 08:13	153
	20180315121439_add_website_to_company.rb	2018-11-28 08:13	125
	20180319082020_create_states.rb	2018-11-28 08:13	369
	20180319082021_create_counties.rb	2018-11-28 08:13	325
	20180319100405_create_company_materials.rb	2018-11-28 08:13	484
	20180321105147_create_service_request.rb	2018-11-28 08:13	252
	20180322080921_add_column_geometry_in_regions.rb	2018-11-28 08:13	221
	20180322134656_create_company_work_order_statuses.rb	2018-11-28 08:13	345
	20180322145057_create_trigger_regions_insert_update.rb	2018-11-28 08:13	636
	20180323111428_change_invoice_item_quantity_datatype.rb	2018-11-28 08:13	214
	20180323125931_add_column_county_code_and_state_in_regions.rb	2018-11-28 08:13	228
	20180327084905_add_name_to_documents.rb	2018-11-28 08:13	121
	20180327085846_create_material_locks.rb	2018-11-28 08:13	361
	20180327124844_add_column_added_by_id_area_ratings.rb	2018-11-28 08:13	147
	20180327155858_add_field_for_company_details_to_company.rb	2018-11-28 08:13	173
	20180328104512_add_column_external_id_in_company_clients.rb	2018-11-28 08:13	316
	20180328140847_add_fields_to_license.rb	2018-11-28 08:13	265
	20180328140913_add_fields_to_trades.rb	2018-11-28 08:13	260
	20180328143510_remove_fields_from_region_trade.rb	2018-11-28 08:13	1.0K
	20180328144002_remove_fields_from_region_licenses.rb	2018-11-28 08:13	1.0K
	20180329072700_add_archived_field_to_rate.rb	2018-11-28 08:13	142
	20180402085524_create_report_settings.rb	2018-11-28 08:13	415
	20180402123242_create_company_trip_statuses.rb	2018-11-28 08:13	328
	20180402171415_add_deleted_at_to_company_location_statuses.rb	2018-11-28 08:13	164
	20180403120418_add_fields_to_rate.rb	2018-11-28 08:13	183
	20180403120529_rename_company_material_columns.rb	2018-11-28 08:13	562
	20180403123644_create_company_material_log.rb	2018-11-28 08:13	370
	20180403160938_create_special_area_rates.rb	2018-11-28 08:13	372
	20180404115413_change_column_type_amount_in_stock_in_companpany_material.rb	2018-11-28 08:13	231
	20180405102502_add_active_column_to_technician_trip.rb	2018-11-28 08:13	158
	20180406155934_add_state_to_special_area_rate.rb	2018-11-28 08:13	151
	20180409140102_add_accepted_to_company_client.rb	2018-11-28 08:13	211
	20180409145216_add_term_fields_to_company.rb	2018-11-28 08:13	225
	20180409155504_create_vendor_contracts.rb	2018-11-28 08:13	262
	20180409160439_add_fields_for_term_added_by_to_company.rb	2018-11-28 08:13	455
	20180410091732_change_unit_column_type_in_company_material.rb	2018-11-28 08:13	151
	20180411072805_add_authorized_representative_field_to_company.rb	2018-11-28 08:13	182
	20180411104454_create_coi_infos.rb	2018-11-28 08:13	645
	20180411104512_create_vendor_trips.rb	2018-11-28 08:13	406
	20180411105025_create_w9_infos.rb	2018-11-28 08:13	275
	20180412084558_add_doing_business_as_field_to_company.rb	2018-11-28 08:13	148
	20180412141038_remove_dba_from_company.rb	2018-11-28 08:13	139
	20180413072545_add_double_holiday_amount_to_rate.rb	2018-11-28 08:13	145
	20180413093857_add_bussiness_name_to_w9_info.rb	2018-11-28 08:13	200
	20180413102122_create_policies.rb	2018-11-28 08:13	637
	20180413121305_remove_unused_columns_from_coi_info.rb	2018-11-28 08:13	934
	20180416082753_create_contract_categories.rb	2018-11-28 08:13	317
	20180416083214_create_contract_service_types.rb	2018-11-28 08:13	306
	20180416103028_add_trip_id_to_vendor_trip.rb	2018-11-28 08:13	234
	20180416103708_create_vendor_work_orders.rb	2018-11-28 08:13	242
	20180416112808_change_column_type_of_external_id_in_company_client.rb	2018-11-28 08:13	199
	20180416115853_create_purchase_order.rb	2018-11-28 08:13	586
	20180416115910_create_purchase_order_item.rb	2018-11-28 08:13	406
	20180416115920_create_purchase_order_email.rb	2018-11-28 08:13	381
	20180416135800_add_contract_categroy_name_and_contract_service_type_name_to_contracts.rb	2018-11-28 08:13	222
	20180417081543_create_tag_areas.rb	2018-11-28 08:13	432
	20180417095606_create_company_contractors.rb	2018-11-28 08:13	301
	20180418080958_add_column_unit_sell_to_company_material.rb	2018-11-28 08:13	149
	20180418081449_create_tag_area_contracts.rb	2018-11-28 08:13	215
	20180418082109_add_name_field_to_work_order.rb	2018-11-28 08:13	191
	20180418091803_remove_foreignkey_reference_form_purchase_order_item.rb	2018-11-28 08:13	164
	20180418135252_add_generic_to_tag_area.rb	2018-11-28 08:13	142
	20180419082028_add_time_card_tag_to_tag_area.rb	2018-11-28 08:13	217
	20180419152955_add_contract_service_type_id_to_contracts.rb	2018-11-28 08:13	159
	20180419153935_add_we_are_a_field_to_company.rb	2018-11-28 08:13	130
	20180420074428_add_background_check_field_to_company.rb	2018-11-28 08:13	164
	20180420104812_create_line_items.rb	2018-11-28 08:13	335
	20180420112157_add_line_item_id_to_contract.rb	2018-11-28 08:13	135
	20180423081343_add_billable_code_field_to_work_order.rb	2018-11-28 08:13	145
	20180423105541_change_columntype_of_start_and_end_date_in_policy.rb	2018-11-28 08:13	196
	20180424134844_create_work_order_materials.rb	2018-11-28 08:13	247
	20180424140550_add_other_rate_type_field_to_rate.rb	2018-11-28 08:13	137
	20180425124558_add_column_tax_exempt_to_company_and_location.rb	2018-11-28 08:13	345
	20180425141945_add_extension_field_to_contact.rb	2018-11-28 08:13	133
	20180426120025_remove_column_owned_company_from_company.rb	2018-11-28 08:13	151
	20180426130537_add_column_part_and_manufacturer_to_company_material.rb	2018-11-28 08:13	214
	20180427083610_add_column_email_to_tradesmen.rb	2018-11-28 08:13	129
	20180427163751_add_use_other_subcontractor_to_company.rb	2018-11-28 08:13	173
	20180430081237_add_field_coverage_amount_to_policy.rb	2018-11-28 08:13	143
	20180430120539_create_regions_boundaries.rb	2018-11-28 08:13	587
	20180430132732_add_field_picture_url_to_tradesmen.rb	2018-11-28 08:13	139
	20180502114646_create_compliance_requirments.rb	2018-11-28 08:13	371
	20180503120233_add_name_of_person_field_to_license.rb	2018-11-28 08:13	141
	20180503125224_add_documents_to_licenses.rb	2018-11-28 08:13	127
	20180503151139_add_unit_of_measure_field_to_rate.rb	2018-11-28 08:13	137
	20180504080402_add_issue_date_field_to_license.rb	2018-11-28 08:13	136
	20180504125555_create_contract_managers.rb	2018-11-28 08:13	208
	20180507131111_create_contract_locations.rb	2018-11-28 08:13	1.0K
	20180508133139_remove_column_active_from_tag_areas.rb	2018-11-28 08:13	139
	20180508155557_add_field_phone_to_tradesmen.rb	2018-11-28 08:13	128
	20180509084056_create_work_order_locations.rb	2018-11-28 08:13	521
	20180509085454_create_invoice_locations.rb	2018-11-28 08:13	505
	20180509122254_add_field_no_schedule_to_scheduler.rb	2018-11-28 08:13	157
	20180509123308_remove_location_id_from_invoice_and_work_orders.rb	2018-11-28 08:13	487
	20180509155510_add_auto_approved_exceptions_to_scheduler.rb	2018-11-28 08:13	176
	20180514075933_add_field_meal_deduction_to_scheduler.rb	2018-11-28 08:13	218
	20180515112343_create_service_adjustment.rb	2018-11-28 08:13	1.6K
	20180515154304_add_custom_agreement_number_and_name_to_agreement_contracts.rb	2018-11-28 08:13	313
	20180517084207_create_trigger_service_adjustments_insert.rb	2018-11-28 08:13	708
	20180517122318_create_payment_receipts.rb	2018-11-28 08:13	391
	20180517122331_create_payments.rb	2018-11-28 08:13	263
	20180517123016_add_paid_amount_cents_to_invoices.rb	2018-11-28 08:13	144
	20180521090756_add_column_lock_to_service.rb	2018-11-28 08:13	141
	20180525151925_add_no_schedule_field_to_service.rb	2018-11-28 08:13	153
	20180528090451_add_deleted_at_to_services_service_exception_service_review_service_adjustments.rb	2018-11-28 08:13	354
	20180529091333_create_job_numbers.rb	2018-11-28 08:13	199
	20180529091349_create_job_categories.rb	2018-11-28 08:13	170
	20180529091358_create_adjustment_reasons.rb	2018-11-28 08:13	213
	20180529115710_add_no_schedule_field_to_tradesmen_trip.rb	2018-11-28 08:13	511
	20180529120206_add_job_number_and_job_category_id_to_agreement_contracts.rb	2018-11-28 08:13	373
	20180530083804_add_hours_type_id_to_adjustment_reasons.rb	2018-11-28 08:13	155
	20180531151717_add_field_deleted_by_id_to_service.rb	2018-11-28 08:13	140
	20180601035145_add_role_id_to_company_users.rb	2018-11-28 08:13	134
	20180601051000_create_roles.rb	2018-11-28 08:13	253
	20180601081408_add_field_deleted_at_to_scheduler.rb	2018-11-28 08:13	140
	20180606124922_add_admin_to_roles.rb	2018-11-28 08:13	132
	20180606131332_create_whitelisted_jwts.rb	2018-11-28 08:13	447
	20180614114820_add_deleted_by_id_field_to_tradesmen_trip.rb	2018-11-28 08:13	153
	20180629112800_create_attachments.rb	2018-11-28 08:13	281
	20180629124703_add_default_quantity_to_work_order_material.rb	2018-11-28 08:13	169
	20180705084842_add_annexed_to_proposal_and_purchase_order.rb	2018-11-28 08:13	229
	20180709115655_add_column_aud_in_whitelisted_jwts.rb	2018-11-28 08:13	138
	20180718130848_create_payment_accounts.rb	2018-11-28 08:13	404
	20180718161243_change_column_name_to_company_contractor.rb	2018-11-28 08:13	392
	20180720111332_add_notes_field_to_payment_account.rb	2018-11-28 08:13	137
	20180720124337_add_business_hours_and_tax_id_field_to_company.rb	2018-11-28 08:13	194
	20180723105139_rename_company_client_to_company_engagement.rb	2018-11-28 08:13	2.6K
	20180726075549_create_external_connections.rb	2018-11-28 08:13	532
	20180726142049_add_vendor_trips_count_to_work_order.rb	2018-11-28 08:13	162
	20180731142032_add_default_scheduler_to_contracts.rb	2018-11-28 08:13	163
	20180801075224_add_comment_column_to_documnet_and_license.rb	2018-11-28 08:13	232
	20180801081321_create_zip_codes.rb	2018-11-28 08:13	209
	20180801090930_add_tag_number_to_tradesmen.rb	2018-11-28 08:13	132
	20180801142926_create_api_keys.rb	2018-11-28 08:13	226
	20180806115626_create_prefixes.rb	2018-11-28 08:13	233
	20180806145545_add_locked_by_id_to_services.rb	2018-11-28 08:13	134
	20180813125743_add_index_to_service_exceptions.rb	2018-11-28 08:13	204
	20180829113455_add_deleted_at_to_agreement_trades.rb	2018-11-28 08:13	147
	20180903084901_create_thresholds.rb	2018-11-28 08:13	453
	20180903110617_create_area_exceptions.rb	2018-11-28 08:13	456
	20180903142519_add_region_id_to_area_exceptions.rb	2018-11-28 08:13	200
	20180907130036_add_can_add_travel_time_to_work_orders.rb	2018-11-28 08:13	168
	20180910075426_create_travel_time_logs.rb	2018-11-28 08:13	380
	20180910091411_add_column_service_system_in_work_orders.rb	2018-11-28 08:13	149
	20180910120727_create_ivrs.rb	2018-11-28 08:13	274
	20180910140121_create_travel_time_adjustments.rb	2018-11-28 08:13	369
	20180917134119_add_external_reference_in_locations.rb	2018-11-28 08:13	148
	20180919075229_add_item_name_to_purchase_order_items.rb	2018-11-28 08:13	150
	20180919132355_create_labor_schedules.rb	2018-11-28 08:13	392
	20180919133424_create_agreement_labor_rates.rb	2018-11-28 08:13	278
	20180920085325_create_company_sequences.rb	2018-11-28 08:13	1.2K
	20180924131711_change_columns_in_invoices_v1.rb	2018-11-28 08:13	418
	20180929145353_add_dispatched_by_and_dispatched_date_to_vendor_trips.rb	2018-11-28 08:13	220
	20180929154655_add_contractor_id_to_trips.rb	2018-11-28 08:13	131
	20181003111121_create_labor_rate_types.rb	2018-11-28 08:13	449
	20181004082847_create_labor_types.rb	2018-11-28 08:13	313
	20181004084123_create_labor_rate_rates.rb	2018-11-28 08:13	480
	20181004084525_create_labor_rates.rb	2018-11-28 08:13	549
	20181005112510_add_material_mark_up_to_invoices.rb	2018-11-28 08:13	142
	20181008085149_create_labor_rate_regions.rb	2018-11-28 08:13	405
	20181009070059_add_material_markup_percent_to_agreement.rb	2018-11-28 08:13	157
	20181009074726_add_material_markup_percent_to_work_orders.rb	2018-11-28 08:13	269
	20181011091414_remove_rates.rb	2018-11-28 08:13	801
	20181011091435_remove_special_area_rates.rb	2018-11-28 08:13	468
	20181011132948_add_labor_rate_id_to_tradesmen_trip_id.rb	2018-11-28 08:13	150
	20181016113641_add_column_description_in_trips.rb	2018-11-28 08:13	691
	20181016135642_add_column_trip_id_in_ivrs.rb	2018-11-28 08:13	910
	20181016151635_add_column_tradesmen.rb	2018-11-28 08:13	156
	20181017063255_add_columns_nte_and_equipments_in_trips.rb	2018-11-28 08:13	208
	20181017083714_add_column_parent_id_in_trades.rb	2018-11-28 08:13	555
	20181017180650_add_column_trade_id_in_trips.rb	2018-11-28 08:13	117
	20181019090448_create_labor_rate_schedules.rb	2018-11-28 08:13	300
	20181019090559_drop_labor_schedules.rb	2018-11-28 08:13	388
	20181019132135_create_material_murkups.rb	2018-11-28 08:13	312
	20181019133928_add_column_ragular_time_start_and_regular_time_end_in_trips.rb	2018-11-28 08:13	216
	20181022055334_add_rate_columns_in_labor_rates.rb	2018-11-28 08:13	1.9K
	20181022073516_add_column_labor_rate_schedule_type_in_trips.rb	2018-11-28 08:13	156
	20181022180021_change_index_for_unique_fields_in_labor_rates.rb	2018-11-28 08:13	610
	20181023092654_add_column_is_beta_test_on_in_company_engagements.rb	2018-11-28 08:13	182
	20181026153704_add_column_deleted_at_in_zip_codes.rb	2018-11-28 08:13	139
	20181026155935_add_column_deleted_at_in_contacts.rb	2018-11-28 08:13	138
	20181026160708_change_index_for_unique_fields_in_external_c_onnections.rb	2018-11-28 08:13	703
	20181029125109_add_formatted_address_to_addresses.rb	2018-11-28 08:13	146
	20181030105020_add_column_invoice.rb	2018-11-28 08:13	136
	20181030133848_change_column_invoice_table.rb	2018-11-28 08:13	283
	20181031172218_add_column_no_equipment_in_trades.rb	2018-11-28 08:13	153
	20181102160415_add_column_no_of_techs_checked_in_in_services.rb	2018-11-28 08:13	170
	20181109083803_add_column_priority_in_trips.rb	2018-11-28 08:13	139
	20181109103938_add_column_return_visit_in_services.rb	2018-11-28 08:13	140
	20181112113256_change_column_default_to_true_for_no_equipment_in_trades.rb	2018-11-28 08:13	453
	20181114083352_add_column_tax_exempt_in_invoice.rb	2018-11-28 08:13	151
	20181119080830_create_rael_location_references.rb	2018-11-28 08:13	1.7K
	20181120170300_add_uniq_index_on_name_in_companies.rb	2018-11-28 08:13	176
	20181128095111_add_column_area_name_in_labor_rates.rb	2018-11-28 14:12	754
	20181203083442_add_external_status_to_trip.rb	2018-12-03 14:41	133
	20181127170021_add_columns_resource_id_and_resource_type_in_purchase_orders.rb	2018-12-03 16:57	223
	20181129194753_add_columns_equip_id_and_call_type_in_work_orders.rb	2018-12-03 16:57	196
	20181129194938_add_columns_agreement_number_and_payment_method_in_work_orders.rb	2018-12-03 16:57	222
	20181129195040_add_columns_not_to_exceed_and_accept_or_reject_in_work_orders.rb	2018-12-03 16:57	236
	20181130193602_add_column_vendor_acceptance_required_in_trips.rb	2018-12-03 16:57	178
	20181201134656_create_annexed_purchase_orders.rb	2018-12-03 16:57	235
	20181203110923_create_annexed_proposals.rb	2018-12-03 16:57	246
	20181203120913_add_column_tax_exempt_to_work_orders.rb	2018-12-03 16:57	158
	20181203122645_change_column_not_to_exceed_to_work_orders.rb	2018-12-03 16:57	155
	20181204074412_create_purchase_order_assignments.rb	2018-12-04 17:42	775
	20181204083056_create_proposal_assignments.rb	2018-12-04 17:42	706
	20181204092913_add_column_status_in_annexed_purchase_orders.rb	2018-12-04 17:42	170
	20181205103943_change_resource_to_work_order_id_and_trip_id.rb	2018-12-05 17:03	1.7K
	20181207085221_move_annexed_purchase_orders_to_annexed_purchase_orders_model.rb	2018-12-07 16:27	2.0K
	20181207120437_move_annexed_proposals_to_annexed_proposal_model.rb	2018-12-07 16:27	2.6K
	20181211132232_add_unique_index_on_po_number_in_purchase_orders.rb	2018-12-12 13:37	3.4K
	20181212134851_add_type_to_annexed_proposal_and_annexed_purchase_orders.rb	2018-12-17 13:48	475
	20181211133543_create_work_order_users.rb	2018-12-17 16:37	320
	20181219130059_add_column_addition_info_in_external_connections.rb	2018-12-20 17:10	179
	20181214114516_create_site_timings.rb	2018-12-21 11:09	286
	20181219121813_add_tax_exempt_to_purchase_orders.rb	2018-12-21 14:33	160
	20181213111726_add_column_added_by_on_work_order.rb	2018-12-24 15:00	140
	20181225120532_create_location_histories.rb	2018-12-25 13:03	251
	20181217133754_add_code_to_licenses.rb	2018-12-28 15:45	131
	20181217134920_create_license_codes.rb	2018-12-28 15:45	301
	20181218102225_add_additional_fields_to_company.rb	2018-12-28 15:45	657
	20181218120056_create_payment_terms.rb	2018-12-28 15:45	355
	20181218130657_create_terminations.rb	2018-12-28 15:45	331
	20181218145436_add_account_type_to_payment_accounts.rb	2018-12-28 15:45	468
	20181220095901_create_trip_activities.rb	2018-12-28 15:45	320
	20181220100623_add_vendor_status_to_trips.rb	2018-12-28 15:45	143
	20181224091213_add_state_id_to_company.rb	2018-12-28 15:45	127
	20181226100420_add_dispatch_now_to_work_order.rb	2018-12-28 15:45	155
	20190104092930_create_equipment_attachments.rb	2019-01-04 17:14	344
	20190108142935_add_send_updates_to_vendor_to_trips.rb	2019-01-10 10:05	162
	20190108143541_change_vendor_acceptence_required_default_true.rb	2019-01-10 10:05	187
	20190107133106_add_accept_reject_wo_globally_to_company.rb	2019-01-11 16:27	173
	20190110122425_remove_equipment_attachment.rb	2019-01-11 16:27	124
	20190115105223_add_item_type_to_invoice_items.rb	2019-01-15 16:31	138
	20181227100349_remove.rb	2019-01-22 14:27	249
	20190108104020_update_settings_in_integrations.rb	2019-01-22 14:27	548
	20190117122618_add_column_vendor_id_in_external_connections.rb	2019-01-22 14:27	875
	20190122125925_drop_quickbook_customers.rb	2019-01-22 14:27	1.0K
	20190122131144_drop_quickbook_subcustomer.rb	2019-01-22 14:27	1.1K
	20190122095104_create_location_tradesmen.rb	2019-01-23 15:18	242
	20190125122400_add_column_connection_type_in_external_connections.rb	2019-01-31 14:23	1.2K
	20190129125735_create_po_selectable_items.rb	2019-01-31 14:23	264
	20190130134927_add_column_active_in_integrations.rb	2019-01-31 14:23	529
	20190130100021_addcolumn_description_on_annexed_proposal.rb	2019-02-04 14:33	153
	20190131073232_add_column_position_on_invoice.rb	2019-02-04 14:33	454
	20190204092258_create_settings_vendors.rb	2019-02-07 17:37	428
	20190204094507_create_settings_work_orders.rb	2019-02-07 17:37	537
	20190207123340_add_columns_tax_exempt_by_state_ids_on_settings_vendor.rb	2019-02-07 17:37	186
	20190208104554_create_tradesmen_trades.rb	2019-02-13 17:08	266
	20190213162611_add_index_on_tradesmen_trade.rb	2019-02-13 17:08	190
	20190214122733_default_value_remove_in_vendor_acceptance_required_on_trip.rb	2019-02-14 12:58	263
	20190206120739_add_restricted_access_to_roles.rb	2019-02-15 10:13	155
	20190218092154_add_column_custom_invoice_number_on_invoice.rb	2019-02-19 16:44	156
	20190219100706_add_columns_auto_assign_attribute_on_settings_work_order.rb	2019-02-26 13:13	192
	20190221085730_add_column_place_id_on_address.rb	2019-02-26 13:13	132
	20190215125544_add_item_type_and_unit_of_measure_to_purchase_order_item.rb	2019-02-26 15:11	310
	20190226102625_add_column_trade_name_on_setting_work_order.rb	2019-02-27 12:51	284
	20190227075025_add_column_work_order_external_name_on_work_order_settings.rb	2019-02-27 13:58	201
	20190222150015_create_work_order_tag_areas.rb	2019-02-28 08:32	670
	20190228081904_add_request_approval_to_work_order_settings.rb	2019-02-28 15:11	179
	20190305145116_add_default_as_array_to_tax_exempted_state_ids_in_vendor_settings.rb	2019-03-05 16:12	433
	20190305143909_add_column_jon_number_on_work_order.rb	2019-03-05 16:50	932
	20190301093221_create_tradesmen_trip_activities.rb	2019-03-05 17:04	259
	20190306114049_change_default_value_for_no_equipment_in_trades.rb	2019-03-06 12:42	173
	20190312103827_add_deactivation_date_to_agreement_contract.rb	2019-03-15 17:10	451
	20190228081719_add_column_material_on_invoice_item.rb	2019-03-15 17:11	150
	20190204131632_create_invoice_trips.rb	2019-03-15 17:15	230
	20190207143134_add_invoice_status_code_to_company_trip_status.rb	2019-03-15 17:15	182
	20190208080450_add_column_invoice_per_trip_to_settings_vendors.rb	2019-03-15 17:15	179
	20190319150003_add_column_remit_payments_to_on_invoice.rb	2019-03-20 16:25	146
	20190329115533_add_column_draft_sent_at_to_invoices.rb	2019-03-29 18:01	461
	20190328111912_add_column_department_on_work_order.rb	2019-04-03 13:51	145
	20190328122054_create_departments.rb	2019-04-03 13:51	343
	20190328132950_add_column_department_id_on_invoice.rb	2019-04-03 13:51	142
	20190328141052_add_column_department_id_on_agreement_contract.rb	2019-04-03 13:51	163
	20190404141444_rename_column_active_to_activated_at_in_integrations.rb	2019-04-04 14:47	569
	20190405124526_add_column_featured_on_department.rb	2019-04-05 15:08	155
	20190409121953_change_column_status_default_in_purchase_orders.rb	2019-04-11 17:23	275
	20190409122833_change_column_department_id_in_purchase_orders.rb	2019-04-11 17:23	159
	20190411100147_drop_po_selectable_items.rb	2019-04-11 17:23	202
	20190410065726_change_column_on_purchase_order_item.rb	2019-04-16 15:10	1.1K
	20190410080047_change_column_on_purchase_order.rb	2019-04-16 15:10	1.0K
	20190410101712_rename_payments_to_payment_invoices.rb	2019-04-23 10:07	208
	20190410103125_rename_payment_recepits_to_payments.rb	2019-04-23 10:07	251
	20190410132757_add_payment_status_to_invoices.rb	2019-04-23 10:07	151
	20190411105917_rename_paid_amount_cents_to_balance_cents_in_invoice.rb	2019-04-23 10:07	169
	20190417151156_add_status_to_payments.rb	2019-04-23 10:07	252
	20190420124211_create_ledger_accounts.rb	2019-04-23 14:52	1.1K
	20190422100607_add_columns_income_account_id_and_expense_account_id_in_departments.rb	2019-04-23 14:52	1.5K
	20190424092653_remove_column_active_on_technician_trip.rb	2019-04-24 10:30	149
	20190423081540_change_column_on_invoices.rb	2019-04-25 17:10	518
	20190423150935_change_columns_on_invoice_items.rb	2019-04-25 17:10	1.0K
	20190424095249_create_bill_payments.rb	2019-04-25 17:10	477
	20190424111620_create_bill_payment_items.rb	2019-04-25 17:10	278
	20190430091108_add_account_sub_type_to_ledger_accounts.rb	2019-04-30 12:40	154
	20190501142021_add_column_zip_code_in_taxes.rb	2019-05-02 08:54	126
	20190418075025_create_trade_services.rb	2019-05-03 19:09	458
	20190420144939_create_service_rates.rb	2019-05-03 19:09	760
	20190425104602_add_column_trade_sub_trades_count.rb	2019-05-03 19:09	153
	20190227101300_add_purchase_order_id_to_invoice.rb	2019-05-03 19:15	143
	20190426152650_add_payment_method_to_bill_payments.rb	2019-05-06 18:33	209
	20190427102108_add_account_holder_name_to_payment_account.rb	2019-05-06 18:33	161
	20190425081312_create_item_types.rb	2019-05-08 12:26	927
	20190425101029_create_item_type_accounts.rb	2019-05-08 12:26	1.1K
	20190426083338_create_items.rb	2019-05-08 12:26	961
	20190501142952_add_column_item_id_in_invoice_items.rb	2019-05-08 12:26	2.4K
	20190326153207_add_column_dob_on_tradesmen.rb	2019-05-09 15:05	127
	20190326154419_create_emergency_contacts.rb	2019-05-09 15:05	297
	20190402102806_create_employment_details.rb	2019-05-09 15:05	333
	20190502132425_add_send_by_to_report_setting.rb	2019-05-09 15:05	291
	20190507142821_add_paycom_id_to_tradesmens.rb	2019-05-09 15:05	131
	20190510140207_change_column_dob_from_datetimeto_date_in_tradesmens.rb	2019-05-10 17:53	208
	20190510140701_change_column_hire_date_rehire_date_and_termination_date_from_datetimeto_date_in_employment_details.rb	2019-05-10 17:53	532
	20190513130500_add_department_code_to_tradesmen.rb	2019-05-14 07:55	142
	20190513133241_add_send_payroll_to_work_order.rb	2019-05-14 07:55	155
	20190514121033_add_send_payroll_to_contract.rb	2019-05-15 16:48	152
	20190411114741_add_column_discount_enabled_on_setting_vendor.rb	2019-05-21 07:46	187
	20190520134747_create_scheduler_event_invoices.rb	2019-05-21 13:26	302
	20190520161718_add_deleted_at_to_scheduler_events.rb	2019-05-21 13:26	147
	20190520163415_add_column_donot_allow_sent_invoice_on_setting_vendor.rb	2019-05-22 15:41	193
	20190528160230_create_sister_companies.rb	2019-05-31 08:20	382
	20190508083406_create_call_types.rb	2019-06-19 13:28	260
	20190508084310_add_company_id_to_priorities.rb	2019-06-19 13:28	197
	20190522163227_add_job_number_to_agreement_contracts.rb	2019-06-19 13:28	694
	20190522163259_add_job_number_to_work_orders.rb	2019-06-19 13:28	638
	20190529124946_add_column_trip_id_on_invoice_item.rb	2019-06-19 13:28	139
	20190530140338_add_tradesmens_count_to_companies.rb	2019-06-19 13:28	551
	20190531101848_add_column_category_on_work_orders.rb	2019-06-19 13:28	138
	20190531102732_create_work_order_categories.rb	2019-06-19 13:28	252
	20190531134454_create_app_versions.rb	2019-06-19 13:28	334
	20190601120512_create_mobile_apps.rb	2019-06-19 13:28	340
	20190603124220_add_accept_or_rejected_at_to_invoice.rb	2019-06-19 13:28	151
	20190604120257_add_to_emails_bcc_cc_invoices.rb	2019-06-19 13:28	247
	20190606070144_add_column_display_on_invoice_and_display_on_purchase_order_in_item_types.rb	2019-06-19 13:28	1.2K
	20190606084345_add_po_number_to_agreement_contracts.rb	2019-06-19 13:28	149
	20190607072304_add_column_item_id_in_purchase_order_items.rb	2019-06-19 13:28	2.3K
	20190607105531_add_column_display_on_vendor_invoice_in_item_types.rb	2019-06-19 13:28	352
	20190612095419_add_account_product_line_to_company_materials.rb	2019-06-19 13:28	211
	20190613095836_add_column_file_url_in_attachment.rb	2019-06-19 13:28	402
	20190613124019_add_autogenerate_trips_to_settings_work_orders.rb	2019-06-19 13:28	185
	20190627123705_add_columns_location_id_and_site_address_to_purchase_orders.rb	2019-07-19 17:16	294
	20190628082456_add_columns_marked_up_to_invoice_items.rb	2019-07-19 17:16	331
	20190628092001_add_time_slots_to_settings_work_order.rb	2019-07-19 17:16	168
	20190628113836_add_time_slot_to_work_orders.rb	2019-07-19 17:16	134
	20190628154143_rename_tradesmens_count_to_tradesmen_count.rb	2019-07-19 17:16	164
	20190704141428_add_column_client_department_id_in_invoices.rb	2019-07-19 17:16	146
	20190704141746_add_column_client_item_id_in_invoice_items.rb	2019-07-19 17:16	312
	20190713120812_add_deleted_at_to_priority.rb	2019-07-19 17:16	173
	20190713120940_rename_column_priority_type_on_priorites.rb	2019-07-19 17:16	564