Projekt

Allgemein

Profil

Statistiken
| Zweig: | Markierung: | Revision:

kivitendo/sql/Pg-upgrade2 @ 129dcc98

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_chart_link_to_acc_trans.sql 635 Bytes
add_customer_mandator_id.sql 706 Bytes
add_depositor_for_customer_vendor.sql 446 Bytes
add_emloyee_project_assignment_for_viewing_invoices.sql 654 Bytes
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_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_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_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_ar_orddate_quodate.sql 317 Bytes
ap_deliverydate.sql 159 Bytes
ap_gl.sql 545 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_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_unique_chart_constraint.sql 228 Bytes
bank_transaction_acc_trans_remove_wrong_primary_key.sql 212 Bytes
bank_transactions.sql 717 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
buchungsgruppen_forein_keys.sql 292 Bytes
buchungsgruppen_sortkey.sql 617 Bytes
cb_ob_transaction.sql 345 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
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_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_max_future_booking_date.sql 244 Bytes
defaults_add_precision.sql 226 Bytes
defaults_add_quick_search_modules.sql 266 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_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_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_variants.sql 236 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_dunning_creator.sql 300 Bytes
defaults_show_bestbefore.pl 926 Bytes
defaults_show_delete_on_orders.sql 532 Bytes
defaults_show_longdescription_select_item.sql 272 Bytes
defaults_show_mark_as_paid_config.sql 454 Bytes
defaults_signature.sql 914 Bytes
defaults_split_address.pl 1,22 KB
defaults_transfer_settings.sql 489 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_workflow_po_ap_chart_id.sql 229 Bytes
defaults_year_end_charts.sql 397 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_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_orders.sql 3,93 KB
delivery_orders_fields_for_invoices.sql 458 Bytes
delivery_terms.sql 1,57 KB
deliveryorder_transnumbers.sql 281 Bytes
deliveryorder_type.sql 424 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_journal.sql 1,6 KB
email_journal_attachments_add_fileid.sql 228 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_oe.sql 678 Bytes
file_full_texts.sql 527 Bytes
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_type_dunning_orig_invoice.sql 1,25 KB
file_storage_type_letter.sql 1,14 KB
filemanagement_feature.sql 974 Bytes
files.sql 1,52 KB
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 563 Bytes
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
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_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_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_version.sql 865 Bytes
oe_version_create_first.sql 266 Bytes
on_delete_oe_version_trigger.sql 304 Bytes
order_statuses.sql 794 Bytes
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_type_enum.sql 1,59 KB
parts_add_unit_foreign_key.sql 241 Bytes
parts_ean.sql 131 Bytes
parts_has_sernumber.sql 215 Bytes
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
re_add_sepa_export_items_foreign_keys.sql 633 Bytes
receivable_payable_default_accounts.sql 375 Bytes
record_links.sql 620 Bytes
record_links_bt_acc_trans.pl 2,76 KB
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
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
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_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_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,28 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
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
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
129dcc98 10.08.2022 11:25 Bernd Bleßmann

Wiedervorlagen: Mehr Infos über Abschluss speichern: DB-Upgrade-Skript und Rose

Gespeichert wird Benutzer und Datum des Abschlusses. Der Benutzer kann
leer sein, da diese Information in schon existierenden Wiedervorlagen nicht
vorhanden ist.
Bei der Migration existierender Wiedervorlagen wird das Abschlussdatum auf...
1b3afb17 10.08.2022 11:25 Bernd Bleßmann

Wiedervorlage für mehrere Benutzer: DB-Upgrade und Rose
3dc3b1bc 04.07.2022 15:54 Bernd Bleßmann

Angebot/Auftrag Status: Feld in Tabelle für Angebote/Aufträge: DB und Rose
5b7e8b46 04.07.2022 15:51 Bernd Bleßmann

Angebot/Auftrag Status: DB-Upgrade und Rose
d29df0d0 13.06.2022 11:32 Bernd Bleßmann

Telefonnotizen in HTML: DB-Upgrade
0af247fe 12.06.2022 10:11 Jan Büren

Unterversionierung über Mandantenkonfiguration aktivierbar
c110b264 12.06.2022 08:27 Jan Büren

Falls ein Angebot gelöscht wird, auch die Verknüpfung zu den Unterversionen entfernen
124c271d 12.06.2022 08:27 Jan Büren

oe_version: Alte Angebote/Aufträge mit Version 1 initialisieren
7a778ade 12.06.2022 08:27 Jan Büren

Hilfstabelle oe_version erweitert
b99d067d 12.06.2022 08:27 Jan Büren

Rose-DB OrderVersion - Hilfstabelle zum Versionisieren von Orders

Revisionen anzeigen

Auch abrufbar als: Atom