projects
/
kivitendo-erp.git
/ tree
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
| tree
history
|
HEAD
|
snapshot
Refactoring
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
drwxr-xr-x
..
-rw-r--r--
437
COA_Account_Settings001.sql
blob
|
history
|
raw
-rw-r--r--
305
COA_Account_Settings002.sql
blob
|
history
|
raw
-rw-r--r--
681
PgCommaAggregateFunction.sql
blob
|
history
|
raw
-rw-r--r--
109
README
blob
|
history
|
raw
-rw-r--r--
4506
SKR04-3804-addition.pl
blob
|
history
|
raw
-rw-r--r--
7627
USTVA_abstraction.pl
blob
|
history
|
raw
-rw-r--r--
49829
USTVA_at.pl
blob
|
history
|
raw
-rw-r--r--
665
acc_trans_booleans_not_null.sql
blob
|
history
|
raw
-rw-r--r--
5096
acc_trans_constraints.pl
blob
|
history
|
raw
-rw-r--r--
1433
acc_trans_id_uniqueness.pl
blob
|
history
|
raw
-rw-r--r--
1842
acc_trans_without_oid.sql
blob
|
history
|
raw
-rw-r--r--
473
accounts_tax_office_bad_homburg.sql
blob
|
history
|
raw
-rw-r--r--
229
add_ar_paid_defaults.sql
blob
|
history
|
raw
-rw-r--r--
635
add_chart_link_to_acc_trans.sql
blob
|
history
|
raw
-rw-r--r--
706
add_customer_mandator_id.sql
blob
|
history
|
raw
-rw-r--r--
446
add_depositor_for_customer_vendor.sql
blob
|
history
|
raw
-rw-r--r--
450
add_fk_to_gl.sql
blob
|
history
|
raw
-rw-r--r--
248
add_fkey_tax_id_to_acc_trans.sql
blob
|
history
|
raw
-rw-r--r--
444
add_makemodel_prices.sql
blob
|
history
|
raw
-rw-r--r--
2005
add_more_constraints_fibu_projekt_xplace.pl
blob
|
history
|
raw
-rw-r--r--
1154
add_tax_id_to_acc_trans.sql
blob
|
history
|
raw
-rw-r--r--
599
add_warehouse_client_config_default.sql
blob
|
history
|
raw
-rw-r--r--
452
add_warehouse_defaults.sql
blob
|
history
|
raw
-rw-r--r--
263
ap_add_direct_debit.sql
blob
|
history
|
raw
-rw-r--r--
317
ap_ar_orddate_quodate.sql
blob
|
history
|
raw
-rw-r--r--
159
ap_deliverydate.sql
blob
|
history
|
raw
-rw-r--r--
279
ap_storno.sql
blob
|
history
|
raw
-rw-r--r--
263
ar_add_direct_debit.sql
blob
|
history
|
raw
-rw-r--r--
334
ar_add_donumber.sql
blob
|
history
|
raw
-rw-r--r--
384
ar_add_invnumber_for_credit_note.sql
blob
|
history
|
raw
-rw-r--r--
2559
ar_ap_foreign_keys.sql
blob
|
history
|
raw
-rw-r--r--
792
ar_ap_gl_delete_triggers_deletion_from_acc_trans.sql
blob
|
history
|
raw
-rw-r--r--
705
ar_ap_storno_id.sql
blob
|
history
|
raw
-rw-r--r--
278
ar_storno.sql
blob
|
history
|
raw
-rw-r--r--
1288
auth_enable_ct_all_edit.pl
blob
|
history
|
raw
-rw-r--r--
1201
auth_enable_edit_prices.pl
blob
|
history
|
raw
-rw-r--r--
1293
auth_enable_sales_all_edit.pl
blob
|
history
|
raw
-rw-r--r--
601
background_job_change_create_periodic_invoices_to_daily.pl
blob
|
history
|
raw
-rwxr-xr-x
346
background_jobs_3.pl
blob
|
history
|
raw
-rw-r--r--
680
bank_accounts.sql
blob
|
history
|
raw
-rw-r--r--
617
buchungsgruppen_sortkey.sql
blob
|
history
|
raw
-rw-r--r--
345
cb_ob_transaction.sql
blob
|
history
|
raw
-rw-r--r--
427
change_makemodel_vendor_id.sql
blob
|
history
|
raw
-rw-r--r--
409
chart_category_to_sgn.sql
blob
|
history
|
raw
-rw-r--r--
584
chart_names.sql
blob
|
history
|
raw
-rw-r--r--
536
chart_names2.sql
blob
|
history
|
raw
-rw-r--r--
264
chart_taxkey_id_from_taxkeys.sql
blob
|
history
|
raw
-rw-r--r--
1285
chart_type_skonto.sql
blob
|
history
|
raw
-rw-r--r--
1259
charts_without_taxkey.pl
blob
|
history
|
raw
-rw-r--r--
748
cleanup_after_customer_vendor_deletion.sql
blob
|
history
|
raw
-rw-r--r--
713
clients.pl
blob
|
history
|
raw
-rw-r--r--
367
contacts_add_cp_position.pl
blob
|
history
|
raw
-rw-r--r--
532
contacts_add_street_and_zipcode_and_city.pl
blob
|
history
|
raw
-rw-r--r--
2042
contacts_convert_cp_birthday_to_date.pl
blob
|
history
|
raw
-rw-r--r--
3639
convert_curr_to_text.sql
blob
|
history
|
raw
-rw-r--r--
6334
cp_greeting_migration.pl
blob
|
history
|
raw
-rw-r--r--
692
csv_import_profiles.sql
blob
|
history
|
raw
-rw-r--r--
169
csv_import_profiles_2.sql
blob
|
history
|
raw
-rw-r--r--
1115
csv_import_report_cache.sql
blob
|
history
|
raw
-rw-r--r--
351
csv_import_reports_add_numheaders.sql
blob
|
history
|
raw
-rw-r--r--
9511
currencies.pl
blob
|
history
|
raw
-rw-r--r--
2784
custom_variable_configs_column_type_text.pl
blob
|
history
|
raw
-rw-r--r--
1462
custom_variables.sql
blob
|
history
|
raw
-rw-r--r--
2548
custom_variables_delete_via_trigger.pl
blob
|
history
|
raw
-rw-r--r--
4759
custom_variables_delete_via_trigger_2.pl
blob
|
history
|
raw
-rw-r--r--
278
custom_variables_indices.sql
blob
|
history
|
raw
-rw-r--r--
233
custom_variables_indices_2.sql
blob
|
history
|
raw
-rw-r--r--
329
custom_variables_parts_services_assemblies.sql
blob
|
history
|
raw
-rw-r--r--
350
custom_variables_sub_module_not_null.sql
blob
|
history
|
raw
-rw-r--r--
460
custom_variables_valid.sql
blob
|
history
|
raw
-rw-r--r--
340
custom_variables_validity_index.sql
blob
|
history
|
raw
-rw-r--r--
724
customer_add_constraints.sql
blob
|
history
|
raw
-rw-r--r--
227
customer_add_taxincluded_checked.sql
blob
|
history
|
raw
-rw-r--r--
266
customer_add_taxincluded_checked_2.sql
blob
|
history
|
raw
-rw-r--r--
379
customer_long_entries.sql
blob
|
history
|
raw
-rw-r--r--
226
customer_vendor_add_currency.sql
blob
|
history
|
raw
-rw-r--r--
270
customer_vendor_phone_no_limits.sql
blob
|
history
|
raw
-rw-r--r--
525
customer_vendor_taxzone_id.sql
blob
|
history
|
raw
-rw-r--r--
585
customer_vendor_ustid_length.sql
blob
|
history
|
raw
-rw-r--r--
5146
default_bin_parts.pl
blob
|
history
|
raw
-rw-r--r--
176
defaults_add_language_id.sql
blob
|
history
|
raw
-rw-r--r--
244
defaults_add_max_future_booking_date.sql
blob
|
history
|
raw
-rw-r--r--
281
defaults_balance_startdate.sql
blob
|
history
|
raw
-rw-r--r--
235
defaults_customer_hourly_rate.sql
blob
|
history
|
raw
-rw-r--r--
1559
defaults_datev_check.pl
blob
|
history
|
raw
-rw-r--r--
1733
defaults_feature.pl
blob
|
history
|
raw
-rw-r--r--
592
defaults_feature2.pl
blob
|
history
|
raw
-rw-r--r--
1136
defaults_posting_config.pl
blob
|
history
|
raw
-rw-r--r--
522
defaults_posting_records_config.sql
blob
|
history
|
raw
-rw-r--r--
926
defaults_show_bestbefore.pl
blob
|
history
|
raw
-rw-r--r--
532
defaults_show_delete_on_orders.sql
blob
|
history
|
raw
-rw-r--r--
454
defaults_show_mark_as_paid_config.sql
blob
|
history
|
raw
-rw-r--r--
914
defaults_signature.sql
blob
|
history
|
raw
-rw-r--r--
408
del_exchangerate.sql
blob
|
history
|
raw
-rw-r--r--
3652
delete_close_follow_ups_when_order_is_deleted_closed.sql
blob
|
history
|
raw
-rw-r--r--
499
delete_close_follow_ups_when_order_is_deleted_closed_fkey_deletion.pl
blob
|
history
|
raw
-rw-r--r--
451
delete_cust_vend_tax.sql
blob
|
history
|
raw
-rw-r--r--
181
delete_customertax_vendortax_partstax.sql
blob
|
history
|
raw
-rw-r--r--
942
delete_translations_on_delivery_term_delete.sql
blob
|
history
|
raw
-rw-r--r--
944
delete_translations_on_payment_term_delete.sql
blob
|
history
|
raw
-rw-r--r--
825
delete_translations_on_tax_delete.sql
blob
|
history
|
raw
-rw-r--r--
207
delivery_order_items_add_pricegroup_id.sql
blob
|
history
|
raw
-rw-r--r--
4035
delivery_orders.sql
blob
|
history
|
raw
-rw-r--r--
458
delivery_orders_fields_for_invoices.sql
blob
|
history
|
raw
-rw-r--r--
1628
delivery_terms.sql
blob
|
history
|
raw
-rw-r--r--
367
department_drop_role.sql
blob
|
history
|
raw
-rw-r--r--
431
drafts.sql
blob
|
history
|
raw
-rw-r--r--
194
drop_audittrail.sql
blob
|
history
|
raw
-rw-r--r--
418
drop_datevexport.sql
blob
|
history
|
raw
-rw-r--r--
611
drop_dpt_trans.sql
blob
|
history
|
raw
-rw-r--r--
374
drop_gifi.sql
blob
|
history
|
raw
-rw-r--r--
184
drop_gifi_2.sql
blob
|
history
|
raw
-rw-r--r--
157
drop_rma.sql
blob
|
history
|
raw
-rw-r--r--
349
drop_sic_code.sql
blob
|
history
|
raw
-rw-r--r--
189
drop_yearend.sql
blob
|
history
|
raw
-rw-r--r--
202
dunning_config_interest_rate.sql
blob
|
history
|
raw
-rw-r--r--
883
dunning_dunning_id.sql
blob
|
history
|
raw
-rw-r--r--
707
dunning_invoices_for_fees.sql
blob
|
history
|
raw
-rw-r--r--
602
dunning_invoices_per_dunning_level.sql
blob
|
history
|
raw
-rw-r--r--
678
emmvee_background_jobs.sql
blob
|
history
|
raw
-rw-r--r--
362
emmvee_background_jobs_2.pl
blob
|
history
|
raw
-rw-r--r--
158
employee_deleted.sql
blob
|
history
|
raw
-rw-r--r--
833
employee_drop_columns.sql
blob
|
history
|
raw
-rw-r--r--
1352
employee_no_limits.sql
blob
|
history
|
raw
-rw-r--r--
3049
erzeugnisnummern.pl
blob
|
history
|
raw
-rw-r--r--
753
finanzamt_update_fa_bufa_nr_hamburg.pl
blob
|
history
|
raw
-rw-r--r--
3470
fix_acc_trans_ap_taxkey_bug.pl
blob
|
history
|
raw
-rw-r--r--
864
fix_datepaid.sql
blob
|
history
|
raw
-rw-r--r--
516
fix_datepaid_for_sepa_transfers.sql
blob
|
history
|
raw
-rw-r--r--
3805
fix_taxdescription.sql
blob
|
history
|
raw
-rw-r--r--
2040
follow_ups.sql
blob
|
history
|
raw
-rw-r--r--
470
generic_translations.sql
blob
|
history
|
raw
-rw-r--r--
264
gewichte.sql
blob
|
history
|
raw
-rw-r--r--
209
gl_add_employee_foreign_key.sql
blob
|
history
|
raw
-rw-r--r--
1365
gl_storno.sql
blob
|
history
|
raw
-rw-r--r--
886
globalprojectnumber_ap_ar_oe.pl
blob
|
history
|
raw
-rw-r--r--
646
history_erp.sql
blob
|
history
|
raw
-rw-r--r--
171
history_erp_snumbers.sql
blob
|
history
|
raw
-rw-r--r--
249
invalid_entries_in_custom_variables_validity.sql
blob
|
history
|
raw
-rw-r--r--
452
invalid_taxkeys.sql
blob
|
history
|
raw
-rw-r--r--
455
invalid_taxkeys_2.sql
blob
|
history
|
raw
-rw-r--r--
141
invoice_add_donumber.sql
blob
|
history
|
raw
-rw-r--r--
321
language_output_formatting.sql
blob
|
history
|
raw
-rw-r--r--
316
lastschrift.sql
blob
|
history
|
raw
-rw-r--r--
365
license_invoice_drop.sql
blob
|
history
|
raw
-rw-r--r--
707
marge_initial.sql
blob
|
history
|
raw
-rw-r--r--
400
oe_customer_vendor_fkeys.sql
blob
|
history
|
raw
-rw-r--r--
307
oe_delivered.sql
blob
|
history
|
raw
-rw-r--r--
2579
oe_delivery_orders_foreign_keys.sql
blob
|
history
|
raw
-rw-r--r--
5653
oe_do_delete_via_trigger.pl
blob
|
history
|
raw
-rw-r--r--
295
oe_employee_id_foreignkey.sql
blob
|
history
|
raw
-rw-r--r--
373
oe_is_salesman.sql
blob
|
history
|
raw
-rw-r--r--
1566
orderitems_delivery_order_items_invoice_foreign_keys.sql
blob
|
history
|
raw
-rw-r--r--
241
parts_add_unit_foreign_key.sql
blob
|
history
|
raw
-rw-r--r--
131
parts_ean.sql
blob
|
history
|
raw
-rw-r--r--
215
parts_has_sernumber.sql
blob
|
history
|
raw
-rw-r--r--
876
parts_translation_foreign_keys.sql
blob
|
history
|
raw
-rw-r--r--
369
payment_terms_sortkey.sql
blob
|
history
|
raw
-rw-r--r--
378
payment_terms_translation.sql
blob
|
history
|
raw
-rw-r--r--
412
payment_terms_translation2.sql
blob
|
history
|
raw
-rw-r--r--
1471
periodic_invoices.sql
blob
|
history
|
raw
-rw-r--r--
395
periodic_invoices_background_job.pl
blob
|
history
|
raw
-rw-r--r--
1400
price_factors.sql
blob
|
history
|
raw
-rw-r--r--
4049
project_bob_attributes.sql
blob
|
history
|
raw
-rw-r--r--
622
project_bob_attributes_itime_default_fix.sql
blob
|
history
|
raw
-rw-r--r--
432
project_customer_type_valid.sql
blob
|
history
|
raw
-rw-r--r--
256
project_flag_active.sql
blob
|
history
|
raw
-rw-r--r--
1127
project_types.sql
blob
|
history
|
raw
-rw-r--r--
620
record_links.sql
blob
|
history
|
raw
-rw-r--r--
3011
record_links_post_delete_triggers.sql
blob
|
history
|
raw
-rw-r--r--
1283
record_links_post_delete_triggers2.sql
blob
|
history
|
raw
-rw-r--r--
395
release_2_4_1.sql
blob
|
history
|
raw
-rw-r--r--
528
release_2_4_2.sql
blob
|
history
|
raw
-rw-r--r--
608
release_2_4_3.sql
blob
|
history
|
raw
-rw-r--r--
507
release_2_6_0.sql
blob
|
history
|
raw
-rw-r--r--
538
release_2_6_1.sql
blob
|
history
|
raw
-rw-r--r--
461
release_2_6_2.sql
blob
|
history
|
raw
-rw-r--r--
280
release_2_6_3.sql
blob
|
history
|
raw
-rw-r--r--
689
release_2_7_0.sql
blob
|
history
|
raw
-rw-r--r--
1458
release_3.1.0.sql
blob
|
history
|
raw
-rw-r--r--
739
release_3_0_0.sql
blob
|
history
|
raw
-rw-r--r--
158
remove_role_from_employee.sql
blob
|
history
|
raw
-rw-r--r--
229
rename_buchungsgruppe_16_19_to_19.sql
blob
|
history
|
raw
-rw-r--r--
674
rename_buchungsgruppen_accounts_16_19_percent.sql
blob
|
history
|
raw
-rw-r--r--
2487
requirement_spec_items_update_trigger_fix.sql
blob
|
history
|
raw
-rw-r--r--
17278
requirement_specs.sql
blob
|
history
|
raw
-rw-r--r--
1720
requirement_specs_orders.sql
blob
|
history
|
raw
-rw-r--r--
512
requirement_specs_print_templates.pl
blob
|
history
|
raw
-rw-r--r--
591
requirement_specs_section_templates.sql
blob
|
history
|
raw
-rw-r--r--
642
rm_whitespaces.pl
blob
|
history
|
raw
-rw-r--r--
1994
rundungsfehler_korrigieren_BUG1328.pl
blob
|
history
|
raw
-rw-r--r--
1466
schema_normalization_1.sql
blob
|
history
|
raw
-rw-r--r--
1441
schema_normalization_2.sql
blob
|
history
|
raw
-rw-r--r--
242
schema_normalization_3.sql
blob
|
history
|
raw
-rw-r--r--
334
self_test_background_job.pl
blob
|
history
|
raw
-rw-r--r--
1161
sepa.sql
blob
|
history
|
raw
-rw-r--r--
501
sepa_in.sql
blob
|
history
|
raw
-rw-r--r--
190
shipto_add_cp_gender.sql
blob
|
history
|
raw
-rw-r--r--
736
skr03_04_bwa_zuordnung_konten_4250_4610.sql
blob
|
history
|
raw
-rw-r--r--
286
skr04_fix_category_3151_3160_3170.sql
blob
|
history
|
raw
-rw-r--r--
529
status_history.sql
blob
|
history
|
raw
-rw-r--r--
4671
steuerfilterung.pl
blob
|
history
|
raw
-rw-r--r--
7698
tax_constraints.pl
blob
|
history
|
raw
-rw-r--r--
2774
tax_description_without_percentage.sql
blob
|
history
|
raw
-rw-r--r--
2749
tax_description_without_percentage_skr04.sql
blob
|
history
|
raw
-rw-r--r--
211
tax_id_if_taxkey_is_0.sql
blob
|
history
|
raw
-rw-r--r--
362
tax_primary_key_taxkeys_foreign_keys.sql
blob
|
history
|
raw
-rw-r--r--
209
tax_report_table_name.sql
blob
|
history
|
raw
-rw-r--r--
586
todo_user_config.sql
blob
|
history
|
raw
-rw-r--r--
339
transaction_description.sql
blob
|
history
|
raw
-rw-r--r--
523
transaction_description_not_null.sql
blob
|
history
|
raw
-rw-r--r--
272
transfer_type_shipped.sql
blob
|
history
|
raw
-rw-r--r--
2062
trigger_assembly_update_lastcost.sql
blob
|
history
|
raw
-rw-r--r--
2135
umstellung_eur.pl
blob
|
history
|
raw
-rw-r--r--
386
unit_foreign_key_for_line_items.sql
blob
|
history
|
raw
-rw-r--r--
195
units_id.sql
blob
|
history
|
raw
-rw-r--r--
179
units_no_type_distinction.sql
blob
|
history
|
raw
-rw-r--r--
327
units_sortkey.sql
blob
|
history
|
raw
-rw-r--r--
628
units_translations_and_singular_plural_distinction.sql
blob
|
history
|
raw
-rw-r--r--
637
update_date_paid.sql
blob
|
history
|
raw
-rw-r--r--
985
ustva_2010.sql
blob
|
history
|
raw
-rw-r--r--
209
ustva_2010_fixes.sql
blob
|
history
|
raw
-rw-r--r--
940
ustva_setup_2007.sql
blob
|
history
|
raw
-rw-r--r--
9383
ustva_setup_2007_update_chart_taxkeys_tax.sql
blob
|
history
|
raw
-rw-r--r--
769
ustva_setup_2007_update_chart_taxkeys_tax_add_missing_tax_accounts.sql
blob
|
history
|
raw
-rw-r--r--
5584
ustva_setup_2007_update_chart_taxkeys_tax_skr04.sql
blob
|
history
|
raw
-rw-r--r--
715
vendor_add_constraints.sql
blob
|
history
|
raw
-rw-r--r--
6731
warehouse.pl
blob
|
history
|
raw
-rw-r--r--
246
warehouse2.sql
blob
|
history
|
raw
-rw-r--r--
305
warehouse3.sql
blob
|
history
|
raw
-rw-r--r--
233
warehouse_add_bestbefore.sql
blob
|
history
|
raw
-rw-r--r--
320
warehouse_alter_chargenumber.sql
blob
|
history
|
raw