Projekt

Allgemein

Profil

Statistiken
| Zweig: | Markierung: | Revision:

kivitendo/sql/Pg-upgrade2 @ 6934a717

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,4 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 1,8 KB
accounts_tax_office_bad_homburg.sql 473 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_fk_to_gl.sql 450 Bytes
add_fkey_tax_id_to_acc_trans.sql 248 Bytes
add_makemodel_prices.sql 444 Bytes
add_more_constraints_fibu_projekt_xplace.pl 1,96 KB
add_tax_id_to_acc_trans.sql 1,13 KB
add_warehouse_client_config_default.sql 599 Bytes
add_warehouse_client_config_default2.sql 361 Bytes
add_warehouse_defaults.sql 452 Bytes
ap_add_direct_debit.sql 263 Bytes
ap_ar_orddate_quodate.sql 317 Bytes
ap_deliverydate.sql 159 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_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
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
background_job_change_create_periodic_invoices_to_daily.pl 601 Bytes
background_jobs_3.pl 346 Bytes
background_jobs_clean_auth_sessions.pl 403 Bytes
bank_accounts.sql 680 Bytes
bank_accounts_add_name.sql 175 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
chart_category_to_sgn.sql 409 Bytes
chart_names.sql 584 Bytes
chart_names2.sql 536 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,09 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
contacts_add_cp_position.pl 367 Bytes
contacts_add_street_and_zipcode_and_city.pl 532 Bytes
contacts_convert_cp_birthday_to_date.pl 1,99 KB
convert_curr_to_text.sql 3,55 KB
convert_taxzone.pl 2,64 KB
cp_greeting_migration.pl 6,19 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 351 Bytes
currencies.pl 9,29 KB
custom_variable_configs_column_type_text.pl 2,72 KB
custom_variable_partsgroups.sql 796 Bytes
custom_variables.sql 1,43 KB
custom_variables_delete_via_trigger.pl 620 Bytes
custom_variables_delete_via_trigger_2.pl 557 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_constraints.sql 724 Bytes
customer_add_taxincluded_checked.sql 227 Bytes
customer_add_taxincluded_checked_2.sql 266 Bytes
customer_long_entries.sql 379 Bytes
customer_vendor_add_currency.sql 226 Bytes
customer_vendor_phone_no_limits.sql 270 Bytes
customer_vendor_taxzone_id.sql 525 Bytes
customer_vendor_ustid_length.sql 585 Bytes
default_bin_parts.pl 5,03 KB
defaults_add_delivery_plan_config.sql 342 Bytes
defaults_add_language_id.sql 176 Bytes
defaults_add_max_future_booking_date.sql 244 Bytes
defaults_balance_startdate.sql 281 Bytes
defaults_customer_hourly_rate.sql 235 Bytes
defaults_datev_check.pl 1,52 KB
defaults_feature.pl 1,69 KB
defaults_feature2.pl 592 Bytes
defaults_global_bcc.sql 170 Bytes
defaults_only_customer_projects_in_sales.sql 466 Bytes
defaults_posting_config.pl 1,11 KB
defaults_posting_records_config.sql 522 Bytes
defaults_reqdate_interval.pl 458 Bytes
defaults_require_transaction_description.sql 465 Bytes
defaults_sales_process_limitations.sql 1,27 KB
defaults_show_bestbefore.pl 926 Bytes
defaults_show_delete_on_orders.sql 532 Bytes
defaults_show_mark_as_paid_config.sql 454 Bytes
defaults_signature.sql 914 Bytes
defaults_transport_cost_reminder.pl 506 Bytes
defaults_transport_cost_reminder_id.sql 354 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_fix1.sql 1,12 KB
delete_cvars_on_trans_deletion_fix2.sql 725 Bytes
delete_translations_on_delivery_term_delete.sql 942 Bytes
delete_translations_on_payment_term_delete.sql 944 Bytes
delete_translations_on_tax_delete.sql 825 Bytes
delivery_order_items_add_pricegroup_id.sql 207 Bytes
delivery_orders.sql 3,94 KB
delivery_orders_fields_for_invoices.sql 458 Bytes
delivery_terms.sql 1,59 KB
department_drop_role.sql 367 Bytes
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 184 Bytes
drop_rma.sql 157 Bytes
drop_sic_code.sql 349 Bytes
drop_yearend.sql 189 Bytes
dunning_config_interest_rate.sql 202 Bytes
dunning_dunning_id.sql 883 Bytes
dunning_invoices_for_fees.sql 707 Bytes
dunning_invoices_per_dunning_level.sql 602 Bytes
emmvee_background_jobs.sql 678 Bytes
emmvee_background_jobs_2.pl 362 Bytes
employee_deleted.sql 158 Bytes
employee_drop_columns.sql 833 Bytes
employee_no_limits.sql 1,32 KB
erzeugnisnummern.pl 2,98 KB
finanzamt_update_fa_bufa_nr_hamburg.pl 753 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_ups.sql 1,99 KB
generic_translations.sql 470 Bytes
gewichte.sql 264 Bytes
gl_add_employee_foreign_key.sql 209 Bytes
gl_storno.sql 1,33 KB
globalprojectnumber_ap_ar_oe.pl 886 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
invoice_add_donumber.sql 141 Bytes
language_output_formatting.sql 321 Bytes
lastschrift.sql 316 Bytes
license_invoice_drop.sql 365 Bytes
marge_initial.sql 707 Bytes
oe_customer_vendor_fkeys.sql 400 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
orderitems_delivery_order_items_invoice_foreign_keys.sql 1,53 KB
orderitems_delivery_order_items_positions.pl 1,41 KB
parts_add_unit_foreign_key.sql 241 Bytes
parts_ean.sql 131 Bytes
parts_has_sernumber.sql 215 Bytes
parts_translation_foreign_keys.sql 876 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.pl 395 Bytes
periodic_invoices_first_billing_date.sql 246 Bytes
price_factors.sql 1,37 KB
price_rules.sql 1,19 KB
price_rules_cascade_delete.sql 332 Bytes
price_rules_discount.sql 268 Bytes
price_source_client_config.sql 209 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_flag_active.sql 256 Bytes
project_status_default_entries.sql 769 Bytes
project_types.sql 1,1 KB
record_links.sql 620 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
recorditem_active_dicount_source.sql 438 Bytes
recorditem_active_price_source.sql 737 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
remove_redundant_customer_vendor_delete_triggers.sql 423 Bytes
remove_redundant_cvar_delete_triggers.sql 1,35 KB
remove_role_from_employee.sql 158 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 1,56 KB
requirement_spec_items_item_type_index.sql 245 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_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 440 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.pl 334 Bytes
sepa.sql 1,13 KB
sepa_in.sql 501 Bytes
shipto_add_cp_gender.sql 190 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 4,56 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_primary_key_taxkeys_foreign_keys.sql 362 Bytes
tax_report_table_name.sql 209 Bytes
tax_zones_obsolete.sql 184 Bytes
taxzone_default_id.sql 243 Bytes
taxzone_id_in_oe_delivery_orders.sql 1,33 KB
taxzone_sortkey.pl 884 Bytes
taxzones.sql 660 Bytes
todo_user_config.sql 586 Bytes
transaction_description.sql 339 Bytes
transaction_description_not_null.sql 523 Bytes
transfer_type_shipped.sql 272 Bytes
trigger_assembly_update_lastcost.sql 2,01 KB
umstellung_eur.pl 2,08 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
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
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 576 Bytes
warehouse_alter_chargenumber.sql 320 Bytes

Aktuellste Revisionen

# Datum Autor Kommentar
6934a717 26.01.2015 13:39 Jan Büren

deliver_order_items_id mit inventory verknüpft

Falls Lieferscheine Warenbewegungen auslösen, sind jetzt auch die
    einzelnen Position "rückverfolgbar" und nicht nur der Beleg.
    Entsprechende Fremdschlüssel gesetzt
38f974a2 23.01.2015 15:03 Jan Büren

Merge branch 'master' of github.com:kivitendo/kivitendo-erp
fcf445e5 23.01.2015 14:01 Jan Büren

Abhängigkeit in DB-Skript ergänzt
132592c6 23.01.2015 13:12 Bernd Bleßmann

Upgradeskript-Abhängigkeiten geändert

unit_foreign_key_for_line_items muss nach oe_do_delete_via_trigger ausgeführt
werden, sonst werden die Fremdschlüssel wieder gelöscht.
e4446309 23.01.2015 08:34 Jan Büren

typo in kommentar
6b6a2ddf 22.01.2015 15:26 Jan Büren

Angebots-Position mit Auftragsposition verknüpft (orderitems -> orderitems)

Angebot -> Workflow Auftrag

- from_table -> to_table (tabelleneintrag)     i.O.
 - delete trigger                               i.O.
 - mittlere position löschen (vor speichern)    i.O....
3954d14b 16.01.2015 11:02 Bernd Bleßmann

Item-Positionen in DB: DB-Upgrade-Skript; Rose

Positionen der Artikelzeilen für Angebote/Aufträge und Lieferscheine mit
in der Datenbank speichern.
bc8c26f3 18.12.2014 16:18 Sven Schöling

PriceRule: Preisregeln können jetzt auch Rabatte

ausserdem Doku
de53e9a8 18.12.2014 16:18 Sven Schöling

PriceRule: Löschen von Preisregeln
9589ecd7 18.12.2014 16:18 Sven Schöling

PriceRule: Erste Version

Revisionen anzeigen

Auch abrufbar als: Atom