/sql/Pg-upgrade2 - Repository - projekt kivitendo - wissen

kivitendo/sql/Pg-upgrade2 @ fac1a317

Name	Größe
COA_Account_Settings001.sql	437 Bytes
COA_Account_Settings002.sql	305 Bytes
PgCommaAggregateFunction.sql	681 Bytes
README	109 Bytes
SKR04-3804-addition.pl	4,17 KB
USTVA_abstraction.pl	7,45 KB
USTVA_at.pl	48,7 KB
acc_trans_booleans_not_null.sql	665 Bytes
acc_trans_constraints.pl	4,98 KB
acc_trans_id_uniqueness.pl	1,4 KB
acc_trans_without_oid.sql	2,17 KB
accounts_tax_office_bad_homburg.sql	473 Bytes
accounts_tax_office_leonberg.sql	642 Bytes
add_ar_paid_defaults.sql	229 Bytes
add_business_models.sql	716 Bytes
add_business_models_position.sql	201 Bytes
add_chart_link_to_acc_trans.sql	635 Bytes
add_charts_and_taxkey_to_invoice_items.sql	540 Bytes
add_customer_dunning_lock.sql	197 Bytes
add_customer_mandator_id.sql	706 Bytes
add_depositor_for_customer_vendor.sql	446 Bytes
add_description_to_backgroundjob_and_backgroundjobhistory.sql	300 Bytes
add_emloyee_project_assignment_for_viewing_invoices.sql	654 Bytes
add_file_version.pl	4,6 KB
add_fk_to_gl.sql	450 Bytes
add_fkey_tax_id_to_acc_trans.sql	248 Bytes
add_gl_imported.sql	167 Bytes
add_gl_transaction_description.sql	175 Bytes
add_link_for_fx_gain_loss_charts.sql	708 Bytes
add_makemodel_prices.sql	444 Bytes
add_more_constraints_fibu_projekt_xplace.pl	1,96 KB
add_node_id_to_background_jobs.sql	175 Bytes
add_orderer.sql	308 Bytes
add_parts_order_qty.sql	190 Bytes
add_parts_price_history.sql	1,38 KB
add_parts_price_history2.sql	815 Bytes
add_record_templates_transaction_description.sql	247 Bytes
add_stocktaking_preselects_client_config_default.sql	393 Bytes
add_stocktaking_qty_threshold_client_config_default.sql	283 Bytes
add_tax_chart_type_to_invoice_items.sql	208 Bytes
add_tax_id_to_acc_trans.sql	1,13 KB
add_test_mode_to_csv_import_report.sql	327 Bytes
add_transfer_doc_interval.sql	248 Bytes
add_warehouse_client_config_default.sql	599 Bytes
add_warehouse_client_config_default2.sql	361 Bytes
add_warehouse_defaults.sql	452 Bytes
add_warehouse_for_assembly.sql	313 Bytes
alter_default_shipped_qty.sql	208 Bytes
alter_record_template_tables.sql	250 Bytes
ap_add_direct_debit.sql	263 Bytes
ap_add_qrbill_data.sql	168 Bytes
ap_ar_orddate_quodate.sql	317 Bytes
ap_deliverydate.sql	159 Bytes
ap_gl.sql	545 Bytes
ap_is_sepa_blocked.sql	185 Bytes
ap_set_payment_term_from_vendor.sql	348 Bytes
ap_storno.sql	279 Bytes
ar_add_direct_debit.sql	263 Bytes
ar_add_donumber.sql	334 Bytes
ar_add_invnumber_for_credit_note.sql	384 Bytes
ar_add_qr_reference.sql	142 Bytes
ar_add_qr_unstructured_message.sql	217 Bytes
ar_add_qrbill_without_amount.sql	289 Bytes
ar_ap_fix_notes_as_html_for_non_invoices.pl	1,33 KB
ar_ap_foreign_keys.sql	2,5 KB
ar_ap_gl_delete_triggers_deletion_from_acc_trans.sql	792 Bytes
ar_ap_storno_id.sql	705 Bytes
ar_storno.sql	278 Bytes
assembly_parts_foreign_key.sql	295 Bytes
assembly_parts_foreign_key2.sql	299 Bytes
assembly_position.sql	188 Bytes
assortment.sql	850 Bytes
assortment_charge.sql	230 Bytes
auth_enable_ct_all_edit.pl	1,26 KB
auth_enable_edit_prices.pl	1,17 KB
auth_enable_sales_all_edit.pl	1,26 KB
auto_delete_reconciliation_links_on_acc_trans_deletion.pl	927 Bytes
auto_delete_sepa_export_items_on_ap_ar_deletion.pl	785 Bytes
automatic_reconciliation.sql	584 Bytes
background_job_change_create_periodic_invoices_to_daily.sql	598 Bytes
background_jobs_3.sql	482 Bytes
background_jobs_clean_auth_sessions.sql	526 Bytes
bank_account_flag_for_zugferd_usage.sql	410 Bytes
bank_account_informations_for_swiss_qrbill.sql	492 Bytes
bank_accounts.sql	680 Bytes
bank_accounts_add_name.sql	175 Bytes
bank_accounts_flag_for_use_with_bank_import.sql	243 Bytes
bank_accounts_unique_chart_constraint.sql	228 Bytes
bank_transaction_acc_trans_remove_wrong_primary_key.sql	212 Bytes
bank_transactions.sql	717 Bytes
bank_transactions_add_qr_reference.sql	217 Bytes
bank_transactions_check_constraint_invoice_amount.sql	330 Bytes
bank_transactions_nuke_trailing_spaces_in_purpose.sql	286 Bytes
bank_transactions_type.sql	272 Bytes
bank_transactions_type2.sql	299 Bytes
bankaccounts_reconciliation.sql	277 Bytes
bankaccounts_sortkey_and_obsolete.sql	525 Bytes
booking_group_obsolete.sql	311 Bytes
buchungsgruppen_forein_keys.sql	292 Bytes
buchungsgruppen_sortkey.sql	617 Bytes
cb_ob_transaction.sql	345 Bytes
change_file_backend_to_enum.sql	539 Bytes
change_makemodel_vendor_id.sql	427 Bytes
change_taxzone_id_0.pl	2,27 KB
change_warehouse_client_config_default.sql	254 Bytes
chart_category_to_sgn.sql	409 Bytes
chart_names.sql	584 Bytes
chart_names2.sql	536 Bytes
chart_pos_er.sql	226 Bytes
chart_taxkey_id_from_taxkeys.sql	264 Bytes
chart_type_skonto.sql	1,25 KB
charts_without_taxkey.pl	1,23 KB
check_bin_belongs_to_wh_trigger.sql	1,07 KB
clean_tax_18_19.pl	1,67 KB
clean_up_record_links_before_delete_trigger.sql	432 Bytes
cleanup_after_customer_vendor_deletion.sql	748 Bytes
clients.pl	713 Bytes
column_type_text_instead_of_varchar.sql	1,36 KB
column_type_text_instead_of_varchar2.sql	677 Bytes
column_type_text_instead_of_varchar3.sql	243 Bytes
contact_departments_own_table.sql	550 Bytes
contact_titles_own_table.sql	499 Bytes
contacts_add_cp_position.pl	367 Bytes
contacts_add_main_contact.pl	437 Bytes
contacts_add_street_and_zipcode_and_city.pl	532 Bytes
contacts_convert_cp_birthday_to_date.pl	1,99 KB
convert_columns_to_html_for_sending_html_emails.pl	1,79 KB
convert_columns_to_html_for_sending_html_emails2.pl	1,28 KB
convert_curr_to_text.sql	3,55 KB
convert_drafts_to_record_templates.pl	9,66 KB
convert_real_qty.sql	242 Bytes
convert_taxzone.pl	2,75 KB
cp_greeting_migration.pl	6,19 KB
create_part_customerprices.sql	727 Bytes
create_part_if_not_found.sql	275 Bytes
create_record_template_tables.sql	3,12 KB
csv_import_profiles.sql	692 Bytes
csv_import_profiles_2.sql	169 Bytes
csv_import_report_cache.sql	1,09 KB
csv_import_reports_add_numheaders.sql	331 Bytes
csv_mt940_add_profile.sql	2 KB
currencies.pl	9,33 KB
custom_data_export.sql	1,24 KB
custom_data_export_default_values_for_parameters.sql	654 Bytes
custom_variable_configs_column_type_text.pl	2,72 KB
custom_variable_partsgroups.sql	777 Bytes
custom_variables.sql	1,43 KB
custom_variables_add_edit_position.sql	227 Bytes
custom_variables_convert_width_height_to_pixels.pl	1,28 KB
custom_variables_delete_via_trigger.pl	620 Bytes
custom_variables_delete_via_trigger_2.pl	557 Bytes
custom_variables_delete_via_trigger_requirement_specs.sql	895 Bytes
custom_variables_indices.sql	278 Bytes
custom_variables_indices_2.sql	233 Bytes
custom_variables_parts_services_assemblies.sql	329 Bytes
custom_variables_sub_module_not_null.sql	350 Bytes
custom_variables_valid.sql	460 Bytes
custom_variables_validity_index.sql	340 Bytes
customer_add_commercial_court.sql	217 Bytes
customer_add_constraints.sql	724 Bytes
customer_add_dunning_mail.sql	237 Bytes
customer_add_fields.sql	251 Bytes
customer_add_generic_mail_delivery.sql	192 Bytes
customer_add_postal_invoice.sql	221 Bytes
customer_add_taxincluded_checked.sql	227 Bytes
customer_add_taxincluded_checked_2.sql	266 Bytes
customer_additional_billing_addresses.sql	1,32 KB
customer_create_zugferd_invoices.sql	227 Bytes
customer_klass_rename_to_pricegroup_id_and_foreign_key.sql	340 Bytes
customer_long_entries.sql	379 Bytes
customer_orderlock.sql	204 Bytes
customer_remove_empty_additional_billing_addresses.sql	661 Bytes
customer_vendor_add_currency.sql	226 Bytes
customer_vendor_add_natural_person.sql	290 Bytes
customer_vendor_phone_no_limits.sql	270 Bytes
customer_vendor_routing_id.sql	195 Bytes
customer_vendor_shipto_add_gln.sql	283 Bytes
customer_vendor_taxzone_id.sql	525 Bytes
customer_vendor_ustid_length.sql	585 Bytes
cvars_remove_dublicate_entries.pl	1,46 KB
datev_export_format.sql	317 Bytes
default_bin_parts.pl	5,03 KB
defaults_add_delivery_plan_config.sql	342 Bytes
defaults_add_feature_experimental.sql	247 Bytes
defaults_add_feature_experimental2.sql	424 Bytes
defaults_add_features.sql	530 Bytes
defaults_add_finanzamt_data.sql	521 Bytes
defaults_add_language_id.sql	176 Bytes
defaults_add_layout_style.sql	204 Bytes
defaults_add_max_future_booking_date.sql	244 Bytes
defaults_add_precision.sql	226 Bytes
defaults_add_quick_search_modules.sql	266 Bytes
defaults_add_reclamation.sql	585 Bytes
defaults_add_rnd_accno_ids.sql	504 Bytes
defaults_advance_payment_clearing_chart_id.sql	984 Bytes
defaults_advance_payment_transfer_charts.sql	1,89 KB
defaults_allowed_documents_with_no_positions.sql	258 Bytes
defaults_balance_startdate.sql	281 Bytes
defaults_bcc_to_login.sql	185 Bytes
defaults_contact_departments_use_textfield.sql	341 Bytes
defaults_contact_titles_use_textfield.sql	320 Bytes
defaults_create_qrbill_data.sql	254 Bytes
defaults_create_zugferd_data.sql	246 Bytes
defaults_customer_hourly_rate.sql	235 Bytes
defaults_customer_vendor_ustid_taxnummer_unique.sql	335 Bytes
defaults_datev_check.pl	1,55 KB
defaults_delivery_date_interval.pl	485 Bytes
defaults_delivery_orders_check_stocked.sql	388 Bytes
defaults_doc_email_attachment.pl	675 Bytes
defaults_drop_delivery_plan_calculate_transferred_do.sql	289 Bytes
defaults_drop_delivery_plan_config.sql	314 Bytes
defaults_enable_email_journal.sql	225 Bytes
defaults_feature.pl	1,69 KB
defaults_feature2.pl	592 Bytes
defaults_filemanagement_remove_doc_database.sql	226 Bytes
defaults_fuzzy_skonto.sql	306 Bytes
defaults_global_bcc.sql	170 Bytes
defaults_invoice_mail_priority.pl	608 Bytes
defaults_invoice_prevent_browser_back.sql	258 Bytes
defaults_invoice_warn_no_delivery_order.sql	271 Bytes
defaults_oe_subversion.sql	218 Bytes
defaults_only_customer_projects_in_sales.sql	466 Bytes

Projekt

Allgemein

Profil