Projekt

Allgemein

Profil

Statistiken
| Zweig: | Markierung: | Revision:

kivitendo/sql/Pg-upgrade2 @ master

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_end_to_end_id.sql 203 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_bank_config.sql 250 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_endtoend.sql 254 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
defaults_order_controller.sql 192 Bytes
defaults_order_warn_duplicate_parts.sql 240 Bytes
defaults_order_warn_no_cusordnumber.sql 260 Bytes
defaults_order_warn_no_deliverydate.sql 246 Bytes
defaults_partsgroup_required.sql 229 Bytes
defaults_posting_config.pl 1,11 KB
defaults_posting_records_add.sql 454 Bytes
defaults_posting_records_config.sql 522 Bytes
defaults_posting_records_default_false.sql 614 Bytes
defaults_print_interpolate_variables_in_positions.sql 300 Bytes
defaults_produce_assembly_transfer_service.sql 281 Bytes
defaults_qrbill_copy_invnumber_to_message.sql 239 Bytes
defaults_qrbill_variants.sql 236 Bytes
defaults_record_sender_emails.sql 907 Bytes
defaults_remove_invoice_prevent_browser_back.sql 273 Bytes
defaults_req_delivery_date.pl 569 Bytes
defaults_reqdate_interval.pl 458 Bytes
defaults_require_transaction_description.sql 465 Bytes
defaults_sales_process_limitations.sql 1,27 KB
defaults_sales_purchase_order_show_ship_missing_column.sql 475 Bytes
defaults_sales_purchase_record_numbers_changeable.sql 257 Bytes
defaults_set_ARAP.sql 678 Bytes
defaults_set_dunning_creator.sql 300 Bytes
defaults_set_invoice_creation_mode_for_dunning_attachment.sql 379 Bytes
defaults_show_bestbefore.pl 926 Bytes
defaults_show_delete_on_orders.sql 532 Bytes
defaults_show_invoice_for_advance_payment.sql 281 Bytes
defaults_show_longdescription_select_item.sql 272 Bytes
defaults_show_mark_as_paid_config.sql 454 Bytes
defaults_show_new_docs.sql 681 Bytes
defaults_signature.sql 914 Bytes
defaults_split_address.pl 1,22 KB
defaults_transfer_settings.sql 489 Bytes
defaults_transit_items_account.sql 316 Bytes
defaults_transport_cost_reminder.pl 506 Bytes
defaults_transport_cost_reminder_id.sql 354 Bytes
defaults_vc_greetings_use_textfield.sql 294 Bytes
defaults_view_record_links.sql 238 Bytes
defaults_view_record_links_options.sql 363 Bytes
defaults_webdav.sql 372 Bytes
defaults_workflow_po_ap_chart_id.sql 229 Bytes
defaults_year_end_charts.sql 397 Bytes
defaults_yearend_method.sql 206 Bytes
defaults_zugferd_test_mode.sql 241 Bytes
del_exchangerate.sql 408 Bytes
delete_close_follow_ups_when_order_is_deleted_closed.sql 3,57 KB
delete_close_follow_ups_when_order_is_deleted_closed_fkey_deletion.pl 499 Bytes
delete_cust_vend_tax.sql 451 Bytes
delete_customertax_vendortax_partstax.sql 181 Bytes
delete_cvars_on_trans_deletion.sql 5,57 KB
delete_cvars_on_trans_deletion_add_reclamation_items.sql 1,32 KB
delete_cvars_on_trans_deletion_add_shipto.sql 1,93 KB
delete_cvars_on_trans_deletion_fix1.sql 1,12 KB
delete_cvars_on_trans_deletion_fix2.sql 725 Bytes
delete_from_generic_translations_on_language_deletion.pl 790 Bytes
delete_invalidated_custom_variables_for_parts.sql 477 Bytes
delete_translations_on_delivery_term_delete.sql 922 Bytes
delete_translations_on_payment_term_delete.sql 924 Bytes
delete_translations_on_tax_delete.sql 805 Bytes
delete_warehouse_for_assembly.sql 251 Bytes
delete_wrong_charts_for_taxkeys.pl 1,45 KB
delete_wrong_charts_for_taxkeys_04.pl 1,47 KB
delivery_order_items_add_pricegroup_id.sql 207 Bytes
delivery_order_remove_is_sales_in_db.sql 189 Bytes
delivery_orders.sql 3,93 KB
delivery_orders_fields_for_invoices.sql 458 Bytes
delivery_terms.sql 1,57 KB
delivery_terms_markable_as_obsolete.sql 210 Bytes
deliveryorder_transnumbers.sql 281 Bytes
deliveryorder_type.sql 424 Bytes
deliveryorder_type_to_record_type.sql 932 Bytes
department_drop_role.sql 367 Bytes
displayable_name_prefs_defaults.sql 1,15 KB
drafts.sql 431 Bytes
drop_audittrail.sql 194 Bytes
drop_datevexport.sql 418 Bytes
drop_dpt_trans.sql 611 Bytes
drop_gifi.sql 374 Bytes
drop_gifi_2.sql 164 Bytes
drop_payment_terms_ranking.sql 169 Bytes
drop_rma.sql 157 Bytes
drop_shipped_qty_config.sql 229 Bytes
drop_sic_code.sql 349 Bytes
drop_yearend.sql 189 Bytes
dunning_config_interest_rate.sql 202 Bytes
dunning_config_print_original_invoice.sql 228 Bytes
dunning_dunning_id.sql 883 Bytes
dunning_foreign_key_for_trans_id.sql 387 Bytes
dunning_invoices_for_fees.sql 707 Bytes
dunning_invoices_per_dunning_level.sql 602 Bytes
dunning_original_invoice_printed.sql 254 Bytes
email_import.sql 1,21 KB
email_journal.sql 1,6 KB
email_journal_add_obsolete.sql 196 Bytes
email_journal_add_uidvalidity.sql 190 Bytes
email_journal_attachments_add_fileid.sql 228 Bytes
email_journal_extend_status.sql 244 Bytes
email_journal_record_import_types.sql 1,73 KB
email_journal_record_types_add_chatall.sql 245 Bytes
email_journal_record_types_add_purchase_order_confirmation.sql 296 Bytes
emmvee_background_jobs.sql 678 Bytes
emmvee_background_jobs_2.sql 486 Bytes
employee_deleted.sql 158 Bytes
employee_drop_columns.sql 814 Bytes
employee_no_limits.sql 1,32 KB
erzeugnisnummern.pl 2,89 KB
eur_bwa_category_views.sql 1,75 KB
exchangerate_in_arap.sql 346 Bytes
exchangerate_in_oe.sql 678 Bytes
file_full_texts.sql 527 Bytes
file_object_type_as_enum.sql 1,2 KB
file_storage_dunning_documents.sql 1,22 KB
file_storage_dunning_invoice.sql 1,4 KB
file_storage_partial_invoices.sql 1,41 KB
file_storage_project.sql 1,31 KB
file_storage_purchase_order_confirmation.sql 1,96 KB
file_storage_purchase_quotation_intake.sql 1,88 KB
file_storage_reclamation.sql 1,69 KB
file_storage_rma_delivery_order.sql 1,74 KB
file_storage_sales_order_intake.sql 1,79 KB
file_storage_supplier_delivery_order.sql 1,59 KB
file_storage_type_dunning_orig_invoice.sql 1,25 KB
file_storage_type_letter.sql 1,14 KB
file_version.sql 668 Bytes
file_versions_guid_as_primary_key.sql 257 Bytes
filemanagement_feature.sql 974 Bytes
files.sql 1,52 KB
files_add_uid.sql 147 Bytes
files_add_variant.sql 147 Bytes
finanzamt_update_fa_bufa_nr_hamburg.pl 753 Bytes
first_aggregator.sql 358 Bytes
fix_acc_trans_ap_taxkey_bug.pl 3,39 KB
fix_datepaid.sql 864 Bytes
fix_datepaid_for_sepa_transfers.sql 516 Bytes
fix_taxdescription.sql 3,72 KB
follow_up_created_for_employees.sql 556 Bytes
follow_up_done.sql 580 Bytes
follow_up_done_close_follow_ups_when_order_is_closed.sql 1,01 KB
follow_ups.sql 1,99 KB
full_texts_background_job.sql 544 Bytes
generic_translations.sql 470 Bytes
get_shipped_qty_config.sql 448 Bytes
gewichte.sql 264 Bytes
gl_add_deliverydate.sql 161 Bytes
gl_add_employee_foreign_key.sql 209 Bytes
gl_storno.sql 1,33 KB
globalprojectnumber_ap_ar_oe.pl 886 Bytes
greetings_own_table.sql 614 Bytes
history_erp.sql 646 Bytes
history_erp_snumbers.sql 171 Bytes
index_for_record_types.sql 372 Bytes
invalid_chart.sql 168 Bytes
invalid_entries_in_custom_variables_validity.sql 249 Bytes
invalid_taxkeys.sql 452 Bytes
invalid_taxkeys_2.sql 455 Bytes
inventory_fix_shippingdate_assemblies.sql 432 Bytes
inventory_itime_parts_id_index.sql 512 Bytes
inventory_parts_id_index.sql 466 Bytes
inventory_shippingdate_not_null.sql 335 Bytes
invoice_add_donumber.sql 141 Bytes
invoice_positions.pl 1,09 KB
invoices_amount_paid_not_null.sql 1,09 KB
konjunkturpaket_2020.sql 9,78 KB
konjunkturpaket_2020_SKR03-korrekturen.sql 2,15 KB
konjunkturpaket_2020_SKR03.sql 6,91 KB
konjunkturpaket_2020_SKR04-korrekturen.sql 1,16 KB
konjunkturpaket_2020_SKR04.sql 3,47 KB
language_obsolete.sql 176 Bytes
language_output_formatting.sql 321 Bytes
lastschrift.sql 316 Bytes
letter.sql 811 Bytes
letter_cleanup.sql 1,19 KB
letter_country_page.sql 197 Bytes
letter_cp_id.sql 212 Bytes
letter_date_type.sql 294 Bytes
letter_draft.sql 904 Bytes
letter_employee_salesman.sql 248 Bytes
letter_notes_internal.sql 160 Bytes
letter_reference.sql 130 Bytes
letter_vendorletter.sql 382 Bytes
license_invoice_drop.sql 365 Bytes
link_requirement_spec_to_orders_created_from_quotations_created_from_requirement_spec.sql 1,29 KB
makemodel_add_longdescription.sql 208 Bytes
makemodel_add_part_description.sql 199 Bytes
makemodel_add_vendor_foreign_key.sql 209 Bytes
marge_initial.sql 707 Bytes
new_chart_1593_1495.sql 1,35 KB
new_chart_3260_1711.sql 1,34 KB
new_chart_3272_1718.sql 1,34 KB
oe_add_order_status.sql 225 Bytes
oe_ar_ap_delivery_orders_edit_notes_as_html.pl 1,18 KB
oe_customer_vendor_fkeys.sql 374 Bytes
oe_delivered.sql 307 Bytes
oe_delivery_orders_add_vendor_confirmation_number.sql 326 Bytes
oe_delivery_orders_foreign_keys.sql 2,52 KB
oe_do_delete_via_trigger.pl 5,52 KB
oe_employee_id_foreignkey.sql 295 Bytes
oe_is_salesman.sql 373 Bytes
oe_purchase_order_confirmation.sql 208 Bytes
oe_purchase_order_confirmation_order_types.sql 272 Bytes
oe_purchase_quotation_intake.sql 203 Bytes
oe_sales_order_intake_type.sql 246 Bytes
oe_version.sql 865 Bytes
oe_version_create_first.sql 266 Bytes
on_delete_oe_version_trigger.sql 304 Bytes
order_statuses.sql 794 Bytes
order_type.sql 1,25 KB
orderitems_delivery_order_items_invoice_foreign_keys.sql 1,53 KB
orderitems_delivery_order_items_positions.pl 1,44 KB
orderitems_optional.sql 183 Bytes
part_classification_report_separate.sql 265 Bytes
part_classifications.sql 1,06 KB
part_customer_prices_add_description.sql 323 Bytes
part_type_enum.sql 1,59 KB
parts_add_order_locked.sql 192 Bytes
parts_add_unit_foreign_key.sql 241 Bytes
parts_add_zolltarifnr.sql 151 Bytes
parts_delete_trigger_priceupdate.sql 240 Bytes
parts_ean.sql 131 Bytes
parts_has_sernumber.sql 215 Bytes
parts_price_history_add_price_factor.sql 1,28 KB
parts_remove_unneeded_fields.sql 409 Bytes
parts_translation_foreign_keys.sql 876 Bytes
partsgroup_sortkey_obsolete.sql 435 Bytes
payment_terms_automatic_calculation.sql 360 Bytes
payment_terms_for_invoices.sql 920 Bytes
payment_terms_obsolete.sql 197 Bytes
payment_terms_sortkey.sql 369 Bytes
payment_terms_translation.sql 378 Bytes
payment_terms_translation2.sql 412 Bytes
periodic_invoices.sql 1,44 KB
periodic_invoices_background_job.sql 373 Bytes
periodic_invoices_direct_debit_flag.sql 365 Bytes
periodic_invoices_first_billing_date.sql 227 Bytes
periodic_invoices_order_value_periodicity.sql 963 Bytes
periodic_invoices_order_value_periodicity2.sql 606 Bytes
periodic_invoices_send_email.sql 989 Bytes
phone_notes_convert_to_html.pl 928 Bytes
price_factors.sql 1,37 KB
price_rules.sql 1,17 KB
price_rules_cascade_delete.sql 332 Bytes
price_rules_discount.sql 268 Bytes
price_source_client_config.sql 189 Bytes
pricegroup_sortkey_obsolete.sql 435 Bytes
prices_delete_cascade.pl 688 Bytes
prices_unique.sql 474 Bytes
project_bob_attributes.sql 3,89 KB
project_bob_attributes_fix_project_status_table_name.sql 272 Bytes
project_bob_attributes_itime_default_fix.sql 622 Bytes
project_customer_type_valid.sql 432 Bytes
project_defaults.sql 489 Bytes
project_flag_active.sql 256 Bytes
project_mtime_trigger.sql 222 Bytes
project_status_default_entries.sql 769 Bytes
project_types.sql 1,1 KB
purchase_basket_items.sql 609 Bytes
re_add_sepa_export_items_foreign_keys.sql 633 Bytes
receivable_payable_default_accounts.sql 375 Bytes
reclamation_add_additional_billing_addresses.sql 360 Bytes
reclamation_type.sql 512 Bytes
reclamations.sql 5,3 KB
record_links.sql 620 Bytes
record_links_bt_acc_trans.pl 2,76 KB
record_links_delete_triggers__reclamations__reclamation_items.sql 596 Bytes
record_links_dunning_post_delete_trigger.sql 902 Bytes
record_links_orderitems_delete_triggers.sql 1,6 KB
record_links_post_delete_triggers.sql 2,94 KB
record_links_post_delete_triggers2.sql 1,25 KB
record_links_post_delete_triggers_gl.sql 1,79 KB
record_links_remove_to_quotation.pl 1,77 KB
record_template_payment_id.sql 229 Bytes
recorditem_active_dicount_source.sql 418 Bytes
recorditem_active_price_source.sql 717 Bytes
release_2_4_1.sql 395 Bytes
release_2_4_2.sql 528 Bytes
release_2_4_3.sql 608 Bytes
release_2_6_0.sql 507 Bytes
release_2_6_1.sql 538 Bytes
release_2_6_2.sql 461 Bytes
release_2_6_3.sql 280 Bytes
release_2_7_0.sql 689 Bytes
release_3.1.0.sql 1,42 KB
release_3_0_0.sql 739 Bytes
release_3_2_0.sql 1,51 KB
release_3_3_0.sql 811 Bytes
release_3_4_0.sql 685 Bytes
release_3_4_1.sql 432 Bytes
release_3_5_0.sql 1,12 KB
release_3_5_1.sql 367 Bytes
release_3_5_2.sql 351 Bytes
release_3_5_3.sql 436 Bytes
release_3_5_4.sql 678 Bytes
release_3_5_5.sql 489 Bytes
release_3_5_6.sql 638 Bytes
release_3_5_6_1.sql 429 Bytes
release_3_5_7.sql 809 Bytes
release_3_5_8.sql 365 Bytes
release_3_6_0.sql 946 Bytes
release_3_6_1.sql 548 Bytes
release_3_7_0.sql 483 Bytes
release_3_8_0.sql 926 Bytes
release_3_9_0.sql 1,16 KB
release_3_9_1.sql 577 Bytes
remove_alternate_from_parts.sql 185 Bytes
remove_comma_aggregate_functions.sql 215 Bytes
remove_double_tax_entries_skr04.pl 1,5 KB
remove_index.sql 927 Bytes
remove_obsolete_trigger.sql 229 Bytes
remove_oids.sql 399 Bytes
remove_redundant_customer_vendor_delete_triggers.sql 403 Bytes
remove_redundant_cvar_delete_triggers.sql 1,33 KB
remove_role_from_employee.sql 158 Bytes
remove_taxkey_15_17_skr04.sql 815 Bytes
remove_terms_add_payment_id.sql 811 Bytes
remove_trigger_assembly_purchase_price.sql 276 Bytes
rename_buchungsgruppe_16_19_to_19.sql 229 Bytes
rename_buchungsgruppen_accounts_16_19_percent.sql 674 Bytes
requirement_spec_delete_trigger_fix.sql 6,69 KB
requirement_spec_delete_trigger_fix2.sql 3,77 KB
requirement_spec_edit_html.pl 852 Bytes
requirement_spec_items_item_type_index.sql 245 Bytes
requirement_spec_items_price_factor.sql 331 Bytes
requirement_spec_items_update_trigger_fix.sql 2,43 KB
requirement_spec_items_update_trigger_fix2.sql 4,78 KB
requirement_spec_parts.sql 715 Bytes
requirement_spec_parts_foreign_key_cascade.sql 428 Bytes
requirement_spec_pictures.sql 1,59 KB
requirement_spec_predefined_texts_for_sections.sql 864 Bytes
requirement_spec_type_for_template_fix.sql 334 Bytes
requirement_spec_types_number_formats.sql 1,11 KB
requirement_spec_types_template_file_name.sql 301 Bytes
requirement_specs.sql 16,9 KB
requirement_specs_orders.sql 1,68 KB
requirement_specs_print_templates.pl 512 Bytes
requirement_specs_section_templates.sql 591 Bytes
rm_whitespaces.pl 642 Bytes
rundungsfehler_korrigieren_BUG1328.pl 1,95 KB
sales_orders_recurring_billing_mode.sql 524 Bytes
sales_quotation_order_probability_expected_billing_date.sql 421 Bytes
schema_normalization_1.sql 1,43 KB
schema_normalization_2.sql 1,41 KB
schema_normalization_3.sql 242 Bytes
self_test_background_job.sql 498 Bytes
sepa.sql 1,13 KB
sepa_contained_in_message_ids.sql 393 Bytes
sepa_export_items.sql 245 Bytes
sepa_in.sql 501 Bytes
sepa_items_payment_type.sql 453 Bytes
sepa_recommended_execution_date.sql 473 Bytes
sepa_reference_add_vc_vc_id.sql 282 Bytes
shipto_add_cp_gender.sql 190 Bytes
shop_images_dont_skip_positon.sql 1 KB
shop_order_items_discount.sql 360 Bytes
shop_orders.sql 3,09 KB
shop_orders_add_active_pricesource.sql 224 Bytes
shop_orders_update_1.sql 797 Bytes
shop_orders_update_2.sql 233 Bytes
shop_orders_update_3.sql 295 Bytes
shop_orders_update_4.sql 341 Bytes
shop_parts.sql 998 Bytes
shopimages.sql 1,75 KB
shopimages_2.sql 329 Bytes
shopimages_3.sql 241 Bytes
shops.sql 617 Bytes
shops_1.sql 284 Bytes
shops_2.sql 149 Bytes
shops_3.sql 425 Bytes
shops_4.sql 172 Bytes
shops_5.sql 215 Bytes
shops_6.sql 167 Bytes
skr03_04_bwa_zuordnung_konten_4250_4610.sql 736 Bytes
skr04_fix_category_3151_3160_3170.sql 286 Bytes
status_history.sql 529 Bytes
steuerfilterung.pl 5,98 KB
stocktakings.sql 1,1 KB
tax_constraints.pl 7,52 KB
tax_description_without_percentage.sql 2,71 KB
tax_description_without_percentage_skr04.sql 2,68 KB
tax_id_if_taxkey_is_0.sql 211 Bytes
tax_point.sql 284 Bytes
tax_point2.sql 153 Bytes
tax_primary_key_taxkeys_foreign_keys.sql 362 Bytes
tax_removed_taxnumber.sql 149 Bytes
tax_report_table_name.sql 209 Bytes
tax_reverse_charge.sql 3,31 KB
tax_reverse_charge_key_18.sql 2,1 KB
tax_reverse_charge_key_19.sql 2,55 KB
tax_skonto_automatic.sql 1,74 KB
tax_zones_obsolete.sql 184 Bytes
taxzone_default_id.sql 243 Bytes
taxzone_id_in_oe_delivery_orders.sql 1,35 KB
taxzone_sortkey.pl 884 Bytes
taxzones.sql 660 Bytes
time_recordings.sql 1,21 KB
time_recordings2.sql 241 Bytes
time_recordings_add_order.sql 228 Bytes
time_recordings_articles.sql 381 Bytes
time_recordings_date_duration.sql 1,41 KB
time_recordings_remove_type.sql 214 Bytes
todo_user_config.sql 586 Bytes
transaction_description.sql 339 Bytes
transaction_description_not_null.sql 523 Bytes
transfer_out_sales_invoice.sql 345 Bytes
transfer_out_serial_charge_number.sql 240 Bytes
transfer_type_assembled.sql 289 Bytes
transfer_type_shipped.sql 272 Bytes
transfer_type_stocktaking.sql 420 Bytes
trigger_assembly_update_lastcost.sql 2,01 KB
trigram_extension.sql 193 Bytes
trigram_indices.sql 3,48 KB
trigram_indices_webshop.sql 284 Bytes
umstellung_eur.pl 2,13 KB
undo_delete_wrong_charts_for_taxkeys.sql 753 Bytes
unit_foreign_key_for_line_items.sql 411 Bytes
units_id.sql 195 Bytes
units_no_type_distinction.sql 179 Bytes
units_sortkey.sql 327 Bytes
units_translations_and_singular_plural_distinction.sql 628 Bytes
update_date_paid.sql 637 Bytes
update_employee_base_data.sql 341 Bytes
use_html_in_letter.pl 359 Bytes
user_preferences.sql 334 Bytes
ustva_2010.sql 985 Bytes
ustva_2010_fixes.sql 209 Bytes
ustva_setup_2007.sql 940 Bytes
ustva_setup_2007_update_chart_taxkeys_tax.sql 9,16 KB
ustva_setup_2007_update_chart_taxkeys_tax_add_missing_tax_accounts.sql 769 Bytes
ustva_setup_2007_update_chart_taxkeys_tax_skr04.sql 5,45 KB
validity_tokens.sql 518 Bytes
vendor_add_constraints.sql 715 Bytes
vendor_long_entries.sql 372 Bytes
warehouse.pl 6,57 KB
warehouse2.sql 246 Bytes
warehouse3.sql 305 Bytes
warehouse_add_bestbefore.sql 233 Bytes
warehouse_add_delivery_order_items_stock_id.sql 1,01 KB
warehouse_alter_chargenumber.sql 320 Bytes

Aktuellste Revisionen

# Datum Autor Kommentar
ded6b9c8 03.02.2025 17:38 Moritz Bunkus

Auth: regelmäßig Basiswerte in employee aus auth.user aktualisieren

Wenn Authentifizierung via HTTP-Headern aktiv ist, wird die normale
Login-Routine umgangen, in der dieses Update ansonsten gemacht
wird. Also automatisch alle fünf Minuten machen.
2259d609 23.10.2024 19:47 Bernd Bleßmann

DB-Upgrade-Skripte für 3.9.1
a4ecde0f 18.10.2024 13:25 Jan Büren

Merge branch '202408-bankconfig'
01d3a3bd 02.10.2024 12:42 Jan Büren

Duplikaterkennung beim Bankimport (EndToEnd) konfigurierbar gemacht
f30ec5f7 01.10.2024 15:44 Bernd Bleßmann

Sichtbarkeit Anzahlungs-/Schluss-Rg: In Mandantenkonfig einstellbar: Rose u. DB
4e3c32b1 30.09.2024 15:48 Cem Aydin

Fix: dbupgrade Skript steuerfilterung.pl

Neue Schweizer Mehrwertsteuersätze eintragen.

Behebt: Fehler #671
b25c0998 30.09.2024 15:15 Bernd Bleßmann

Trigger zum Aktualisieren des Preises von Erzeugnissen entfernt

Das aktualisiern wird (und wurde schon) im Perl-Code gemacht und
der Trigger arbeitete nicht rekursiv.

(cherry picked from commit 253ff0863ce86bfb6c4d82783a4c0a55345dc640)
cf6a988e 30.09.2024 14:52 Bernd Bleßmann

Sichtbarkeit neuer Belege: In Mandantenkonfig einstellbar: Rose u. DB

- Angebots-/Auftrags-Eingänge
- Lieferantenauftragsbestätigungen
- Reklamationen
3740effb 18.09.2024 14:16 Tamino Steinert

FIX: Keine Lücken in Positionen von Shopbildern

Coverbild im Shop wird auf Bild mit Position 1 gesetzt. Diese war
    nach Löschen des 1. Bildes nicht besetzt. Bild an Position 2 wurde
    nicht zu Position 1 geändert.
01caa3b1 28.08.2024 19:26 Jan Büren

db-änderungen konfig für verhalten bei SEPA/Bank

Revisionen anzeigen

Auch abrufbar als: Atom