From 1f0d7da266e23a443c47aaa2dbab844e6be50ee4 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 10 Oct 2017 09:59:09 +0200 Subject: [PATCH] Datenbankupgrades: unbekannte Control-Felder als Fehler werten --- SL/DBUpgrade2.pm | 9 +++++++-- locale/de/all | 1 + sql/Pg-upgrade2-auth/add_api_token.sql | 1 - .../add_batch_printing_to_full_access.sql | 1 - sql/Pg-upgrade2-auth/add_master_rights.sql | 1 - sql/Pg-upgrade2-auth/password_hashing.sql | 1 - sql/Pg-upgrade2-auth/release_3_0_0.sql | 1 - sql/Pg-upgrade2-auth/release_3_2_0.sql | 1 - sql/Pg-upgrade2-auth/release_3_3_0.sql | 1 - sql/Pg-upgrade2-auth/release_3_4_0.sql | 1 - sql/Pg-upgrade2-auth/release_3_5_0.sql | 1 - .../remove_insecurely_hashed_passwords.sql | 1 - sql/Pg-upgrade2-auth/remove_menustyle_v4.sql | 1 - sql/Pg-upgrade2-auth/remove_menustyle_xml.sql | 1 - sql/Pg-upgrade2-auth/rename_general_ledger_rights.sql | 1 - sql/Pg-upgrade2-auth/session_content_auto_restore.sql | 1 - sql/Pg-upgrade2-auth/split_transaction_rights.pl | 1 - .../bank_accounts_unique_chart_constraint.sql | 1 - sql/Pg-upgrade2/bankaccounts_reconciliation.sql | 1 - sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql | 1 - sql/Pg-upgrade2/chart_pos_er.sql | 1 - sql/Pg-upgrade2/check_bin_belongs_to_wh_trigger.sql | 1 - sql/Pg-upgrade2/csv_import_reports_add_numheaders.sql | 1 - sql/Pg-upgrade2/custom_variable_partsgroups.sql | 1 - sql/Pg-upgrade2/customer_vendor_shipto_add_gln.sql | 1 - sql/Pg-upgrade2/defaults_add_quick_search_modules.sql | 1 - ...aults_drop_delivery_plan_calculate_transferred_do.sql | 1 - sql/Pg-upgrade2/defaults_order_warn_duplicate_parts.sql | 1 - .../delete_translations_on_delivery_term_delete.sql | 1 - .../delete_translations_on_payment_term_delete.sql | 1 - sql/Pg-upgrade2/delete_translations_on_tax_delete.sql | 1 - sql/Pg-upgrade2/delivery_terms.sql | 1 - sql/Pg-upgrade2/drop_gifi_2.sql | 1 - sql/Pg-upgrade2/employee_drop_columns.sql | 1 - sql/Pg-upgrade2/files.sql | 1 - sql/Pg-upgrade2/first_aggregator.sql | 1 - sql/Pg-upgrade2/get_shipped_qty_config.sql | 1 - .../inventory_fix_shippingdate_assemblies.sql | 1 - sql/Pg-upgrade2/inventory_shippingdate_not_null.sql | 1 - sql/Pg-upgrade2/invoice_positions.pl | 1 - sql/Pg-upgrade2/invoices_amount_paid_not_null.sql | 1 - sql/Pg-upgrade2/letter_date_type.sql | 1 - sql/Pg-upgrade2/letter_vendorletter.sql | 1 - sql/Pg-upgrade2/oe_customer_vendor_fkeys.sql | 1 - .../orderitems_delivery_order_items_positions.pl | 1 - sql/Pg-upgrade2/partsgroup_sortkey_obsolete.sql | 1 - sql/Pg-upgrade2/payment_terms_obsolete.sql | 1 - sql/Pg-upgrade2/periodic_invoices_first_billing_date.sql | 1 - sql/Pg-upgrade2/price_rules.sql | 1 - sql/Pg-upgrade2/price_source_client_config.sql | 1 - sql/Pg-upgrade2/pricegroup_sortkey_obsolete.sql | 1 - sql/Pg-upgrade2/project_mtime_trigger.sql | 1 - sql/Pg-upgrade2/recorditem_active_dicount_source.sql | 1 - sql/Pg-upgrade2/recorditem_active_price_source.sql | 1 - .../remove_redundant_customer_vendor_delete_triggers.sql | 1 - .../remove_redundant_cvar_delete_triggers.sql | 1 - ...quotation_order_probability_expected_billing_date.sql | 1 - sql/Pg-upgrade2/shop_parts.sql | 1 - sql/Pg-upgrade2/shopimages.sql | 1 - sql/Pg-upgrade2/shopimages_2.sql | 1 - sql/Pg-upgrade2/shopimages_3.sql | 1 - sql/Pg-upgrade2/shops_1.sql | 1 - sql/Pg-upgrade2/shops_2.sql | 1 - sql/Pg-upgrade2/shops_3.sql | 1 - sql/Pg-upgrade2/transfer_out_sales_invoice.sql | 1 - sql/Pg-upgrade2/transfer_type_assembled.sql | 1 - sql/Pg-upgrade2/trigram_indices.sql | 1 - sql/Pg-upgrade2/trigram_indices_webshop.sql | 1 - sql/Pg-upgrade2/user_preferences.sql | 1 - 69 files changed, 8 insertions(+), 69 deletions(-) diff --git a/SL/DBUpgrade2.pm b/SL/DBUpgrade2.pm index 82bd27f25..fea216800 100644 --- a/SL/DBUpgrade2.pm +++ b/SL/DBUpgrade2.pm @@ -98,12 +98,17 @@ sub parse_dbupdate_controls { _control_error($form, $file_name, sprintf($locale->text("Missing 'description' field."))) ; } + delete @{$control}{qw(depth applied)}; + + my @unknown_keys = grep { !m{^ (?: depends | description | file | ignore | locales | may_fail | priority | tag ) $}x } keys %{ $control }; + if (@unknown_keys) { + _control_error($form, $file_name, sprintf($locale->text("Unknown control fields: #1", join(' ', sort({ lc $a cmp lc $b } @unknown_keys))))); + } + $control->{"priority"} *= 1; $control->{"priority"} ||= 1000; $control->{"file"} = $file; - delete @{$control}{qw(depth applied)}; - $all_controls{$control->{"tag"}} = $control; close(IN); diff --git a/locale/de/all b/locale/de/all index d1feb840f..ae2e56b9e 100755 --- a/locale/de/all +++ b/locale/de/all @@ -3561,6 +3561,7 @@ $self->{texts} = { 'Units that have already been used (e.g. for parts and services or in invoices or warehouse transactions) cannot be changed.' => 'Einheiten, die bereits in Benutzung sind (z.B. bei einer Warendefinition, einer Rechnung oder bei einer Lagerbuchung) können nachträglich nicht mehr verändert werden.', 'Unknown Category' => 'Unbekannte Kategorie', 'Unknown Link' => 'Unbekannte Verknüpfung', + 'Unknown control fields: #1' => 'Unbekannte Kontrollfelder: #1', 'Unknown dependency \'%s\'.' => 'Unbekannte Abhängigkeit \'%s\'.', 'Unknown module: #1' => 'Unbekanntes Modul #1', 'Unknown problem type.' => 'Unbekannter Problem-Typ', diff --git a/sql/Pg-upgrade2-auth/add_api_token.sql b/sql/Pg-upgrade2-auth/add_api_token.sql index 82375f6dc..09ef1f868 100644 --- a/sql/Pg-upgrade2-auth/add_api_token.sql +++ b/sql/Pg-upgrade2-auth/add_api_token.sql @@ -1,5 +1,4 @@ -- @tag: add_api_token -- @description: Feld 'api_token' in 'session' ergänzen -- @depends: --- @charset: utf-8 ALTER TABLE auth.session ADD COLUMN api_token text; diff --git a/sql/Pg-upgrade2-auth/add_batch_printing_to_full_access.sql b/sql/Pg-upgrade2-auth/add_batch_printing_to_full_access.sql index 66ecb26cd..5aebfca71 100644 --- a/sql/Pg-upgrade2-auth/add_batch_printing_to_full_access.sql +++ b/sql/Pg-upgrade2-auth/add_batch_printing_to_full_access.sql @@ -1,7 +1,6 @@ -- @tag: add_batch_printing_to_full_access -- @description: Gruppe "Vollzugriff" Recht auf Stapeldruck-Menü gewähren -- @depends: --- @charset: utf-8 DELETE FROM auth.group_rights WHERE ("right" = 'batch_printing') AND group_id = ( diff --git a/sql/Pg-upgrade2-auth/add_master_rights.sql b/sql/Pg-upgrade2-auth/add_master_rights.sql index 6a3c58c28..5e61ae4f6 100644 --- a/sql/Pg-upgrade2-auth/add_master_rights.sql +++ b/sql/Pg-upgrade2-auth/add_master_rights.sql @@ -1,7 +1,6 @@ -- @tag: add_master_rights -- @description: Rechte in die Datenbank migrieren -- @depends: release_3_2_0 --- @charset: utf-8 -- @locales: Master Data -- @locales: Create customers and vendors. Edit all vendors. Edit only customers where salesman equals employee (login) -- @locales: Create customers and vendors. Edit all vendors. Edit all customers diff --git a/sql/Pg-upgrade2-auth/password_hashing.sql b/sql/Pg-upgrade2-auth/password_hashing.sql index c1db61363..40956d098 100644 --- a/sql/Pg-upgrade2-auth/password_hashing.sql +++ b/sql/Pg-upgrade2-auth/password_hashing.sql @@ -1,7 +1,6 @@ -- @tag: password_hashing -- @description: Explicitely set a password hashing algorithm -- @depends: --- @charset: utf-8 UPDATE auth."user" SET password = '{CRYPT}' || password WHERE NOT (password IS NULL) diff --git a/sql/Pg-upgrade2-auth/release_3_0_0.sql b/sql/Pg-upgrade2-auth/release_3_0_0.sql index e90600916..42397cc9a 100644 --- a/sql/Pg-upgrade2-auth/release_3_0_0.sql +++ b/sql/Pg-upgrade2-auth/release_3_0_0.sql @@ -1,4 +1,3 @@ -- @tag: release_3_0_0 -- @description: Abhängigkeitsscript für Release 3.0.0 -- @depends: remove_menustyle_v4 remove_menustyle_xml add_batch_printing_to_full_access auth_schema_normalization_1 session_content_auto_restore add_api_token password_hashing --- @charset: utf-8 diff --git a/sql/Pg-upgrade2-auth/release_3_2_0.sql b/sql/Pg-upgrade2-auth/release_3_2_0.sql index 852ec011d..77dc4570e 100644 --- a/sql/Pg-upgrade2-auth/release_3_2_0.sql +++ b/sql/Pg-upgrade2-auth/release_3_2_0.sql @@ -1,5 +1,4 @@ -- @tag: release_3_2_0 -- @description: Abhängigkeitsscript für Release 3.2.0, bzw. vergessene 3.1.0 -- @depends: release_3_0_0 clients_webdav foreign_key_constraints_on_delete clients --- @charset: utf-8 diff --git a/sql/Pg-upgrade2-auth/release_3_3_0.sql b/sql/Pg-upgrade2-auth/release_3_3_0.sql index efcfa1752..c28efb6f8 100644 --- a/sql/Pg-upgrade2-auth/release_3_3_0.sql +++ b/sql/Pg-upgrade2-auth/release_3_3_0.sql @@ -1,4 +1,3 @@ -- @tag: release_3_3_0 -- @description: Abhängigkeitsscript für Release 3.3.0 -- @depends: release_3_2_0 sales_letter_rights delivery_plan_rights requirement_spec_rights delivery_process_value bank_transaction_rights details_and_report_of_parts productivity_rights rights_for_showing_ar_and_ap_transactions --- @charset: utf-8 diff --git a/sql/Pg-upgrade2-auth/release_3_4_0.sql b/sql/Pg-upgrade2-auth/release_3_4_0.sql index f0b30642e..c169c4cfa 100644 --- a/sql/Pg-upgrade2-auth/release_3_4_0.sql +++ b/sql/Pg-upgrade2-auth/release_3_4_0.sql @@ -1,5 +1,4 @@ -- @tag: release_3_4_0 -- @description: Abhängigkeitsscript für Release 3.4.0 -- @depends: release_3_3_0 client_task_server remove_insecurely_hashed_passwords session_content_primary_key --- @charset: utf-8 diff --git a/sql/Pg-upgrade2-auth/release_3_5_0.sql b/sql/Pg-upgrade2-auth/release_3_5_0.sql index 458a0e1f7..e8e797824 100644 --- a/sql/Pg-upgrade2-auth/release_3_5_0.sql +++ b/sql/Pg-upgrade2-auth/release_3_5_0.sql @@ -1,6 +1,5 @@ -- @tag: release_3_5_0 -- @description: Abhängigkeitsscript für Release 3.5.0 -- @depends: release_3_4_0 record_links_rights other_file_sources2 mail_journal_rights purchase_letter_rights rename_general_ledger_rights all_drafts_edit --- @charset: utf-8 diff --git a/sql/Pg-upgrade2-auth/remove_insecurely_hashed_passwords.sql b/sql/Pg-upgrade2-auth/remove_insecurely_hashed_passwords.sql index 8a75228bf..1ea6b449b 100644 --- a/sql/Pg-upgrade2-auth/remove_insecurely_hashed_passwords.sql +++ b/sql/Pg-upgrade2-auth/remove_insecurely_hashed_passwords.sql @@ -1,7 +1,6 @@ -- @tag: remove_insecurely_hashed_passwords -- @description: Passwörter löschen, die mit unsicheren Hash-Verfahren gehasht wurden -- @depends: release_3_3_0 --- @charset: utf-8 UPDATE auth.user SET password = '*' WHERE (password IS NOT NULL) diff --git a/sql/Pg-upgrade2-auth/remove_menustyle_v4.sql b/sql/Pg-upgrade2-auth/remove_menustyle_v4.sql index 3744bd326..b4d598a83 100644 --- a/sql/Pg-upgrade2-auth/remove_menustyle_v4.sql +++ b/sql/Pg-upgrade2-auth/remove_menustyle_v4.sql @@ -1,7 +1,6 @@ -- @tag: remove_menustyle_v4 -- @description: Menütyp "CSS (oben, neu)" wurde entfernt; also durch v3 ersetzen -- @depends: --- @charset: utf-8 UPDATE auth.user_config SET cfg_value = 'v3' WHERE ((cfg_key = 'menustyle') diff --git a/sql/Pg-upgrade2-auth/remove_menustyle_xml.sql b/sql/Pg-upgrade2-auth/remove_menustyle_xml.sql index f1e3327bb..a8ec107cb 100644 --- a/sql/Pg-upgrade2-auth/remove_menustyle_xml.sql +++ b/sql/Pg-upgrade2-auth/remove_menustyle_xml.sql @@ -1,7 +1,6 @@ -- @tag: remove_menustyle_xml -- @description: Menütyp "XUL/XML" wurde entfernt; also durch v3 ersetzen -- @depends: --- @charset: utf-8 UPDATE auth.user_config SET cfg_value = 'v3' WHERE ((cfg_key = 'menustyle') diff --git a/sql/Pg-upgrade2-auth/rename_general_ledger_rights.sql b/sql/Pg-upgrade2-auth/rename_general_ledger_rights.sql index 863f5232d..018eae8a6 100644 --- a/sql/Pg-upgrade2-auth/rename_general_ledger_rights.sql +++ b/sql/Pg-upgrade2-auth/rename_general_ledger_rights.sql @@ -1,6 +1,5 @@ -- @tag: rename_general_ledger_rights -- @description: Umbennenung des general ledger Rechts -- @depends: split_transaction_rights --- @charset: utf-8 -- @locales: AP/AR Aging & Journal UPDATE auth.master_rights SET description='AP/AR Aging & Journal' WHERE name='general_ledger'; diff --git a/sql/Pg-upgrade2-auth/session_content_auto_restore.sql b/sql/Pg-upgrade2-auth/session_content_auto_restore.sql index d0d84a59c..61cdf573a 100644 --- a/sql/Pg-upgrade2-auth/session_content_auto_restore.sql +++ b/sql/Pg-upgrade2-auth/session_content_auto_restore.sql @@ -1,6 +1,5 @@ -- @tag: session_content_auto_restore -- @description: Spalte "auto_restore" in auth.session_content -- @depends: --- @charset: utf-8 ALTER TABLE auth.session_content ADD COLUMN auto_restore boolean; UPDATE auth.session_content SET auto_restore = FALSE; diff --git a/sql/Pg-upgrade2-auth/split_transaction_rights.pl b/sql/Pg-upgrade2-auth/split_transaction_rights.pl index e0a56b362..5b2e6663b 100644 --- a/sql/Pg-upgrade2-auth/split_transaction_rights.pl +++ b/sql/Pg-upgrade2-auth/split_transaction_rights.pl @@ -1,7 +1,6 @@ # @tag: split_transaction_rights # @description: Finanzbuchhaltungsrechte für Buchungen aufspalten # @depends: release_3_4_0 master_rights_position_gaps -# @charset: utf-8 # @locales: General Ledger Transaction # @locales: AR Transactions # @locales: AP Transactions diff --git a/sql/Pg-upgrade2/bank_accounts_unique_chart_constraint.sql b/sql/Pg-upgrade2/bank_accounts_unique_chart_constraint.sql index c5eb53fa8..b997e0072 100644 --- a/sql/Pg-upgrade2/bank_accounts_unique_chart_constraint.sql +++ b/sql/Pg-upgrade2/bank_accounts_unique_chart_constraint.sql @@ -1,6 +1,5 @@ -- @tag: bank_accounts_unique_chart_constraint -- @description: Bankkonto - Constraint für eindeutiges Konto -- @depends: release_3_2_0 bank_accounts --- @encoding: utf-8 ALTER TABLE bank_accounts ADD CONSTRAINT chart_id_unique UNIQUE (chart_id); diff --git a/sql/Pg-upgrade2/bankaccounts_reconciliation.sql b/sql/Pg-upgrade2/bankaccounts_reconciliation.sql index cb9e53b97..654369ad8 100644 --- a/sql/Pg-upgrade2/bankaccounts_reconciliation.sql +++ b/sql/Pg-upgrade2/bankaccounts_reconciliation.sql @@ -1,7 +1,6 @@ -- @tag: bankaccounts_reconciliation -- @description: Kontenabgleichsststartdatum und -saldo -- @depends: release_3_2_0 --- @encoding: utf-8 ALTER TABLE bank_accounts ADD COLUMN reconciliation_starting_date DATE; ALTER TABLE bank_accounts ADD COLUMN reconciliation_starting_balance numeric(15,5); diff --git a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql index cdda4648d..b8bbd3d25 100644 --- a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql +++ b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql @@ -1,7 +1,6 @@ -- @tag: bankaccounts_sortkey_and_obsolete -- @description: Bankkonto - Sortierreihenfolge und Ungültig -- @depends: release_3_2_0 --- @encoding: utf-8 -- default false needed so that get_all_sorted( query => [ obsolete => 0 ] ) works ALTER TABLE bank_accounts ADD COLUMN obsolete BOOLEAN NOT NULL DEFAULT false; diff --git a/sql/Pg-upgrade2/chart_pos_er.sql b/sql/Pg-upgrade2/chart_pos_er.sql index 56c6f400e..adb481a12 100644 --- a/sql/Pg-upgrade2/chart_pos_er.sql +++ b/sql/Pg-upgrade2/chart_pos_er.sql @@ -1,7 +1,6 @@ -- @tag: chart_pos_er -- @description: pos_er Feld in Konten für die Position ind er Erfolgsrechnung -- @depends: release_3_3_0 --- @encoding: utf-8 -- @may_fail: 1 ALTER TABLE chart ADD COLUMN pos_er INTEGER; diff --git a/sql/Pg-upgrade2/check_bin_belongs_to_wh_trigger.sql b/sql/Pg-upgrade2/check_bin_belongs_to_wh_trigger.sql index 5b5e3d931..8a7163f92 100644 --- a/sql/Pg-upgrade2/check_bin_belongs_to_wh_trigger.sql +++ b/sql/Pg-upgrade2/check_bin_belongs_to_wh_trigger.sql @@ -1,7 +1,6 @@ -- @tag: check_bin_belongs_to_wh_trigger -- @description: Trigger, um sicher zu stellen, dass ein angegebener Lagerplatz auch zum Lager gehört. -- @depends: delivery_orders warehouse --- @encoding: utf-8 CREATE FUNCTION check_bin_belongs_to_wh() RETURNS "trigger" AS 'BEGIN diff --git a/sql/Pg-upgrade2/csv_import_reports_add_numheaders.sql b/sql/Pg-upgrade2/csv_import_reports_add_numheaders.sql index b68b668b0..e3d821497 100644 --- a/sql/Pg-upgrade2/csv_import_reports_add_numheaders.sql +++ b/sql/Pg-upgrade2/csv_import_reports_add_numheaders.sql @@ -1,7 +1,6 @@ -- @tag: csv_import_reports_add_numheaders -- @description: Anzahl der Header-Zeilen in Csv Import Report speichern -- @depends: csv_import_report_cache --- @encoding: utf-8 ALTER TABLE csv_import_reports ADD COLUMN numheaders INTEGER; UPDATE csv_import_reports SET numheaders = 1; diff --git a/sql/Pg-upgrade2/custom_variable_partsgroups.sql b/sql/Pg-upgrade2/custom_variable_partsgroups.sql index 6ba705242..44bc2a19a 100644 --- a/sql/Pg-upgrade2/custom_variable_partsgroups.sql +++ b/sql/Pg-upgrade2/custom_variable_partsgroups.sql @@ -1,7 +1,6 @@ -- @tag: custom_variable_partsgroups -- @description: Beziehung zwischen cvar configs und partsgroups für Filter nach Warengruppen -- @depends: release_3_1_0 --- @charset: utf-8 CREATE TABLE custom_variable_config_partsgroups ( custom_variable_config_id integer NOT NULL, diff --git a/sql/Pg-upgrade2/customer_vendor_shipto_add_gln.sql b/sql/Pg-upgrade2/customer_vendor_shipto_add_gln.sql index 2f591c6e4..b0d0d64d5 100644 --- a/sql/Pg-upgrade2/customer_vendor_shipto_add_gln.sql +++ b/sql/Pg-upgrade2/customer_vendor_shipto_add_gln.sql @@ -1,7 +1,6 @@ -- @tag: customer_vendor_shipto_add_gln -- @description: Spalte für GLN bei Kunde/Lieferant und Lieferadresse -- @depends: release_3_3_0 --- @encoding: utf-8 ALTER TABLE customer ADD COLUMN gln TEXT; ALTER TABLE vendor ADD COLUMN gln TEXT; diff --git a/sql/Pg-upgrade2/defaults_add_quick_search_modules.sql b/sql/Pg-upgrade2/defaults_add_quick_search_modules.sql index 737792567..94f97a5fe 100644 --- a/sql/Pg-upgrade2/defaults_add_quick_search_modules.sql +++ b/sql/Pg-upgrade2/defaults_add_quick_search_modules.sql @@ -1,7 +1,6 @@ -- @tag: defaults_add_quick_search_modules -- @description: Mandantenkonfiguration für Schnellsuche -- @depends: release_3_4_0 --- @encoding: utf-8 ALTER TABLE defaults ADD COLUMN quick_search_modules TEXT[]; diff --git a/sql/Pg-upgrade2/defaults_drop_delivery_plan_calculate_transferred_do.sql b/sql/Pg-upgrade2/defaults_drop_delivery_plan_calculate_transferred_do.sql index 9097eb8b0..5ea2124b4 100644 --- a/sql/Pg-upgrade2/defaults_drop_delivery_plan_calculate_transferred_do.sql +++ b/sql/Pg-upgrade2/defaults_drop_delivery_plan_calculate_transferred_do.sql @@ -1,6 +1,5 @@ -- @tag: defaults_drop_delivery_plan_calculate_transferred_do -- @description: Entferne Einstellung für Lieferplan, nur ausgelagerte Lieferscheine zu berücksichtigen -- @depends: defaults_add_delivery_plan_config --- @encoding: utf-8 ALTER TABLE defaults DROP COLUMN delivery_plan_calculate_transferred_do; diff --git a/sql/Pg-upgrade2/defaults_order_warn_duplicate_parts.sql b/sql/Pg-upgrade2/defaults_order_warn_duplicate_parts.sql index ba8cd662d..292661e5e 100644 --- a/sql/Pg-upgrade2/defaults_order_warn_duplicate_parts.sql +++ b/sql/Pg-upgrade2/defaults_order_warn_duplicate_parts.sql @@ -1,6 +1,5 @@ -- @tag: defaults_order_warn_duplicate_parts -- @description: Mandantenkonfiguration: Warnung bei doppelten Artikeln in Aufträgen -- @depends: release_3_3_0 --- @encoding: utf-8 ALTER TABLE defaults ADD COLUMN order_warn_duplicate_parts BOOLEAN DEFAULT TRUE; diff --git a/sql/Pg-upgrade2/delete_translations_on_delivery_term_delete.sql b/sql/Pg-upgrade2/delete_translations_on_delivery_term_delete.sql index c4a40a9a0..ff596de64 100644 --- a/sql/Pg-upgrade2/delete_translations_on_delivery_term_delete.sql +++ b/sql/Pg-upgrade2/delete_translations_on_delivery_term_delete.sql @@ -1,7 +1,6 @@ -- @tag: delete_translations_on_delivery_term_delete -- @description: Übersetzungen löschen, wenn Lieferbedingung gelöscht wird -- @depends: delivery_terms --- @encoding: utf-8 CREATE OR REPLACE FUNCTION generic_translations_delete_on_delivery_terms_delete_trigger() RETURNS TRIGGER AS $$ diff --git a/sql/Pg-upgrade2/delete_translations_on_payment_term_delete.sql b/sql/Pg-upgrade2/delete_translations_on_payment_term_delete.sql index 950245240..8bab4e024 100644 --- a/sql/Pg-upgrade2/delete_translations_on_payment_term_delete.sql +++ b/sql/Pg-upgrade2/delete_translations_on_payment_term_delete.sql @@ -1,7 +1,6 @@ -- @tag: delete_translations_on_payment_term_delete -- @description: Übersetzungen löschen, wenn Lieferbedingung gelöscht wird -- @depends: payment_terms_translation2 --- @encoding: utf-8 CREATE OR REPLACE FUNCTION generic_translations_delete_on_payment_terms_delete_trigger() RETURNS TRIGGER AS $$ diff --git a/sql/Pg-upgrade2/delete_translations_on_tax_delete.sql b/sql/Pg-upgrade2/delete_translations_on_tax_delete.sql index 5243ace63..d3c9ced06 100644 --- a/sql/Pg-upgrade2/delete_translations_on_tax_delete.sql +++ b/sql/Pg-upgrade2/delete_translations_on_tax_delete.sql @@ -1,7 +1,6 @@ -- @tag: delete_translations_on_tax_delete -- @description: Übersetzungen löschen, wenn Steuer gelöscht wird -- @depends: release_3_0_0 --- @encoding: utf-8 CREATE OR REPLACE FUNCTION generic_translations_delete_on_tax_delete_trigger() RETURNS TRIGGER AS $$ diff --git a/sql/Pg-upgrade2/delivery_terms.sql b/sql/Pg-upgrade2/delivery_terms.sql index fa7400c4b..9f9e42d3a 100644 --- a/sql/Pg-upgrade2/delivery_terms.sql +++ b/sql/Pg-upgrade2/delivery_terms.sql @@ -1,7 +1,6 @@ -- @tag: delivery_terms -- @description: Neue Tabelle und Spalten für Lieferbedingungen -- @depends: release_3_0_0 --- @encoding: utf-8 CREATE TABLE delivery_terms ( id integer NOT NULL DEFAULT nextval('id'), diff --git a/sql/Pg-upgrade2/drop_gifi_2.sql b/sql/Pg-upgrade2/drop_gifi_2.sql index 53c2ec7fa..de4f27e2c 100644 --- a/sql/Pg-upgrade2/drop_gifi_2.sql +++ b/sql/Pg-upgrade2/drop_gifi_2.sql @@ -1,6 +1,5 @@ -- @tag: drop_gifi_2 -- @description: Spalte gifi_accno vollständig entfernen -- @depends: release_3_0_0 drop_gifi --- @encoding: utf-8 ALTER TABLE "vendor" DROP COLUMN "gifi_accno"; diff --git a/sql/Pg-upgrade2/employee_drop_columns.sql b/sql/Pg-upgrade2/employee_drop_columns.sql index a87cf05a7..98585f707 100644 --- a/sql/Pg-upgrade2/employee_drop_columns.sql +++ b/sql/Pg-upgrade2/employee_drop_columns.sql @@ -2,7 +2,6 @@ -- @description: Obsolete Felder in employee entfernt und Datenfelder zum Speichern für die Historie der Mitarbeiter (nach Löschen eines Benutzer) hinzugefügt. Aktuell alle Felder die der Benutzer unter persönliche Einstellungen ändern kann -- @depends: release_3_0_0 -- @ignore: 0 --- @charset: utf-8 ALTER TABLE employee DROP COLUMN addr1; ALTER TABLE employee DROP COLUMN addr2; ALTER TABLE employee DROP COLUMN addr3; diff --git a/sql/Pg-upgrade2/files.sql b/sql/Pg-upgrade2/files.sql index 2209cf7bb..c5a9cf0ec 100644 --- a/sql/Pg-upgrade2/files.sql +++ b/sql/Pg-upgrade2/files.sql @@ -1,6 +1,5 @@ -- @tag: files -- @description: Tabelle für Files --- @charset: UTF-8 -- @depends: release_3_4_1 CREATE TABLE files( id SERIAL PRIMARY KEY, diff --git a/sql/Pg-upgrade2/first_aggregator.sql b/sql/Pg-upgrade2/first_aggregator.sql index 9803988a0..a0465b592 100644 --- a/sql/Pg-upgrade2/first_aggregator.sql +++ b/sql/Pg-upgrade2/first_aggregator.sql @@ -1,7 +1,6 @@ -- @tag: first_aggregator -- @description: SQL Aggregat Funktion FIRST -- @depends: release_3_0_0 --- @encoding: utf-8 CREATE OR REPLACE FUNCTION public.first_agg ( anyelement, anyelement ) RETURNS anyelement LANGUAGE SQL IMMUTABLE STRICT AS $$ diff --git a/sql/Pg-upgrade2/get_shipped_qty_config.sql b/sql/Pg-upgrade2/get_shipped_qty_config.sql index 5c1e1d67a..fb2494dc7 100644 --- a/sql/Pg-upgrade2/get_shipped_qty_config.sql +++ b/sql/Pg-upgrade2/get_shipped_qty_config.sql @@ -1,7 +1,6 @@ -- @tag: get_shipped_qty_config -- @description: Mandantenweite Konfiguration für das Verhalten von Liefermengenabgleich -- @depends: release_3_4_1 --- @encoding: utf-8 ALTER TABLE defaults ADD COLUMN shipped_qty_require_stock_out BOOLEAN NOT NULL DEFAULT FALSE; ALTER TABLE defaults ADD COLUMN shipped_qty_fill_up BOOLEAN NOT NULL DEFAULT TRUE; diff --git a/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql b/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql index 64fbc7571..246292afd 100644 --- a/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql +++ b/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql @@ -1,6 +1,5 @@ -- @tag: inventory_fix_shippingdate_assemblies -- @description: Shippingdate für assemblies und assembly_items nachträglich wie itime setzen. -- @depends: release_3_4_0 warehouse transfer_type_assembled --- @encoding: utf-8 update inventory set shippingdate = itime where comment ilike 'Verbraucht %' and shippingdate is null; update inventory set shippingdate = itime where shippingdate is null and parts_id in (select id from parts where assembly); diff --git a/sql/Pg-upgrade2/inventory_shippingdate_not_null.sql b/sql/Pg-upgrade2/inventory_shippingdate_not_null.sql index afb061705..a3fa3f902 100644 --- a/sql/Pg-upgrade2/inventory_shippingdate_not_null.sql +++ b/sql/Pg-upgrade2/inventory_shippingdate_not_null.sql @@ -1,7 +1,6 @@ -- @tag: inventory_shippingdate_not_null -- @description: shippingdate not null, leeres shippingdate für nachträglich wie itime setzen -- @depends: release_3_4_0 inventory_fix_shippingdate_assemblies --- @encoding: utf-8 UPDATE inventory SET shippingdate = itime WHERE shippingdate IS NULL; ALTER TABLE inventory ALTER COLUMN shippingdate SET NOT NULL; diff --git a/sql/Pg-upgrade2/invoice_positions.pl b/sql/Pg-upgrade2/invoice_positions.pl index d92daca6e..fea63da26 100644 --- a/sql/Pg-upgrade2/invoice_positions.pl +++ b/sql/Pg-upgrade2/invoice_positions.pl @@ -1,7 +1,6 @@ # @tag: invoice_positions # @description: Spalte für Positionen der Einträge in Rechnungen # @depends: release_3_1_0 -# @encoding: utf-8 package SL::DBUpgrade2::invoice_positions; use strict; diff --git a/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql b/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql index 9add1418a..b5e5567c3 100644 --- a/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql +++ b/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql @@ -1,7 +1,6 @@ -- @tag: invoices_amount_paid_not_null -- @description: Bei Rechnungen die drei Spalten "amount", "netamount" und "paid" auf NOT NULL setzen -- @depends: release_3_2_0 --- @encoding: utf-8 UPDATE ar SET amount = 0 WHERE amount IS NULL; ALTER TABLE ar ALTER COLUMN amount SET NOT NULL; diff --git a/sql/Pg-upgrade2/letter_date_type.sql b/sql/Pg-upgrade2/letter_date_type.sql index 8c6293a6d..931e8f068 100644 --- a/sql/Pg-upgrade2/letter_date_type.sql +++ b/sql/Pg-upgrade2/letter_date_type.sql @@ -1,7 +1,6 @@ -- @tag: letter_date_type -- @description: Briefe: Datumsfeld als Datum speichern -- @depends: release_3_2_0 letter --- @encoding: utf-8 ALTER TABLE letter ADD column date_date DATE; UPDATE letter SET date_date = date::DATE; ALTER TABLE letter DROP COLUMN date; diff --git a/sql/Pg-upgrade2/letter_vendorletter.sql b/sql/Pg-upgrade2/letter_vendorletter.sql index f673f55de..8c33edf79 100644 --- a/sql/Pg-upgrade2/letter_vendorletter.sql +++ b/sql/Pg-upgrade2/letter_vendorletter.sql @@ -1,7 +1,6 @@ -- @tag: letter_vendorletter -- @description: Briefe jetzt auch für Lieferanten -- @depends: release_3_4_1 --- @encoding: utf-8 ALTER TABLE letter ALTER COLUMN customer_id DROP NOT NULL; ALTER TABLE letter ADD COLUMN vendor_id INTEGER REFERENCES vendor(id); diff --git a/sql/Pg-upgrade2/oe_customer_vendor_fkeys.sql b/sql/Pg-upgrade2/oe_customer_vendor_fkeys.sql index 47bdea9f6..dcb3107e2 100644 --- a/sql/Pg-upgrade2/oe_customer_vendor_fkeys.sql +++ b/sql/Pg-upgrade2/oe_customer_vendor_fkeys.sql @@ -1,7 +1,6 @@ -- @tag: oe_customer_vendor_fkeys -- @description: Foreign Keys für customer und vendor in oe -- @depends: release_2_6_3 --- @timestamp: 1317380460 UPDATE oe SET customer_id = NULL WHERE customer_id = 0; UPDATE oe SET vendor_id = NULL WHERE vendor_id = 0; diff --git a/sql/Pg-upgrade2/orderitems_delivery_order_items_positions.pl b/sql/Pg-upgrade2/orderitems_delivery_order_items_positions.pl index 712ce835e..97d1a31aa 100644 --- a/sql/Pg-upgrade2/orderitems_delivery_order_items_positions.pl +++ b/sql/Pg-upgrade2/orderitems_delivery_order_items_positions.pl @@ -1,7 +1,6 @@ # @tag: orderitems_delivery_order_items_positions # @description: Spalte für Positionen der Einträge in Angeboten/Auftträgen und Lieferscheinen. # @depends: release_3_1_0 -# @encoding: utf-8 package SL::DBUpgrade2::orderitems_delivery_order_items_positions; use strict; diff --git a/sql/Pg-upgrade2/partsgroup_sortkey_obsolete.sql b/sql/Pg-upgrade2/partsgroup_sortkey_obsolete.sql index 6b9ec79fd..b148d6137 100644 --- a/sql/Pg-upgrade2/partsgroup_sortkey_obsolete.sql +++ b/sql/Pg-upgrade2/partsgroup_sortkey_obsolete.sql @@ -1,6 +1,5 @@ -- @tag: partsgroup_sortkey_obsolete -- @description: Sortierreihenfolge und ungültig für Warengruppen --- @charset: UTF-8 -- @depends: release_3_4_1 -- @ignore: 0 diff --git a/sql/Pg-upgrade2/payment_terms_obsolete.sql b/sql/Pg-upgrade2/payment_terms_obsolete.sql index a72ab45a9..90a7740a4 100644 --- a/sql/Pg-upgrade2/payment_terms_obsolete.sql +++ b/sql/Pg-upgrade2/payment_terms_obsolete.sql @@ -1,6 +1,5 @@ -- @tag: payment_terms_obsolete -- @description: Zahlungsbedingungen ungültig setzen --- @charset: UTF-8 -- @depends: release_3_4_1 -- @ignore: 0 diff --git a/sql/Pg-upgrade2/periodic_invoices_first_billing_date.sql b/sql/Pg-upgrade2/periodic_invoices_first_billing_date.sql index 8487982f4..ffabb9da8 100644 --- a/sql/Pg-upgrade2/periodic_invoices_first_billing_date.sql +++ b/sql/Pg-upgrade2/periodic_invoices_first_billing_date.sql @@ -1,5 +1,4 @@ -- @tag: periodic_invoices_first_billing_date -- @description: Wiederkehrende Rechnungen: Feld für erstes Rechnungsdatum -- @depends: periodic_invoices --- @charset: utf-8 ALTER TABLE periodic_invoices_configs ADD COLUMN first_billing_date DATE; diff --git a/sql/Pg-upgrade2/price_rules.sql b/sql/Pg-upgrade2/price_rules.sql index 3f62fd203..63d3834d4 100644 --- a/sql/Pg-upgrade2/price_rules.sql +++ b/sql/Pg-upgrade2/price_rules.sql @@ -1,7 +1,6 @@ -- @tag: price_rules -- @description: Preismatrix Tabellen -- @depends: release_3_1_0 --- @encoding: utf-8 CREATE TABLE price_rules ( id SERIAL PRIMARY KEY, diff --git a/sql/Pg-upgrade2/price_source_client_config.sql b/sql/Pg-upgrade2/price_source_client_config.sql index 7bcac1aee..affba473f 100644 --- a/sql/Pg-upgrade2/price_source_client_config.sql +++ b/sql/Pg-upgrade2/price_source_client_config.sql @@ -1,6 +1,5 @@ -- @tag: price_source_client_config -- @description: Preisquellen: Preisquellen ausschaltbar per Mandant -- @depends: release_3_1_0 --- @encoding: utf-8 ALTER TABLE defaults ADD disabled_price_sources TEXT[]; diff --git a/sql/Pg-upgrade2/pricegroup_sortkey_obsolete.sql b/sql/Pg-upgrade2/pricegroup_sortkey_obsolete.sql index dc6b33166..684bf375d 100644 --- a/sql/Pg-upgrade2/pricegroup_sortkey_obsolete.sql +++ b/sql/Pg-upgrade2/pricegroup_sortkey_obsolete.sql @@ -1,6 +1,5 @@ -- @tag: pricegroup_sortkey_obsolete -- @description: Sortierreihenfolge und ungültig für Preisgruppen --- @charset: UTF-8 -- @depends: release_3_4_1 -- @ignore: 0 diff --git a/sql/Pg-upgrade2/project_mtime_trigger.sql b/sql/Pg-upgrade2/project_mtime_trigger.sql index 7b90764fb..a2110f733 100644 --- a/sql/Pg-upgrade2/project_mtime_trigger.sql +++ b/sql/Pg-upgrade2/project_mtime_trigger.sql @@ -1,6 +1,5 @@ -- @tag: project_mtime_trigger -- @description: mtime-Trigger für Tabelle project hinzufügen. -- @depends: release_3_3_0 --- @encoding: utf-8 CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); diff --git a/sql/Pg-upgrade2/recorditem_active_dicount_source.sql b/sql/Pg-upgrade2/recorditem_active_dicount_source.sql index aea966a12..acb713cc1 100644 --- a/sql/Pg-upgrade2/recorditem_active_dicount_source.sql +++ b/sql/Pg-upgrade2/recorditem_active_dicount_source.sql @@ -1,7 +1,6 @@ -- @tag: recorditem_active_record_source -- @description: Preisquellen: Rabatte -- @depends: release_3_1_0 recorditem_active_price_source --- @encoding: utf-8 ALTER TABLE orderitems ADD COLUMN active_discount_source TEXT NOT NULL DEFAULT ''; ALTER TABLE delivery_order_items ADD COLUMN active_discount_source TEXT NOT NULL DEFAULT ''; diff --git a/sql/Pg-upgrade2/recorditem_active_price_source.sql b/sql/Pg-upgrade2/recorditem_active_price_source.sql index e8f502b77..4b2c5db8e 100644 --- a/sql/Pg-upgrade2/recorditem_active_price_source.sql +++ b/sql/Pg-upgrade2/recorditem_active_price_source.sql @@ -1,7 +1,6 @@ -- @tag: recorditem_active_price_source -- @description: Preisquelle in Belegpositionen -- @depends: release_3_1_0 --- @encoding: utf-8 ALTER TABLE orderitems ADD COLUMN active_price_source TEXT NOT NULL DEFAULT ''; ALTER TABLE delivery_order_items ADD COLUMN active_price_source TEXT NOT NULL DEFAULT ''; diff --git a/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql b/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql index 39c87dc90..261aa3512 100644 --- a/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql +++ b/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql @@ -1,7 +1,6 @@ -- @tag: remove_redundant_customer_vendor_delete_triggers -- @description: Entfernt doppelte/falsche Trigger zum Aufräumen nach dem Löschen von Kunden/Lieferanten -- @depends: release_3_1_0 --- @encoding: utf-8 -- drop triggers DROP TRIGGER IF EXISTS del_customer ON customer; diff --git a/sql/Pg-upgrade2/remove_redundant_cvar_delete_triggers.sql b/sql/Pg-upgrade2/remove_redundant_cvar_delete_triggers.sql index dfefa1c7e..c7a0f5383 100644 --- a/sql/Pg-upgrade2/remove_redundant_cvar_delete_triggers.sql +++ b/sql/Pg-upgrade2/remove_redundant_cvar_delete_triggers.sql @@ -1,7 +1,6 @@ -- @tag: remove_redundant_cvar_delete_triggers -- @description: Entfernt doppelte Trigger zum Löschen von benutzerdefinierten Variablen -- @depends: custom_variables_delete_via_trigger custom_variables_delete_via_trigger_2 delete_cvars_on_trans_deletion --- @encoding: utf-8 -- drop triggers DROP TRIGGER IF EXISTS delete_orderitems_dependencies ON orderitems; diff --git a/sql/Pg-upgrade2/sales_quotation_order_probability_expected_billing_date.sql b/sql/Pg-upgrade2/sales_quotation_order_probability_expected_billing_date.sql index 5c3716860..25db854fc 100644 --- a/sql/Pg-upgrade2/sales_quotation_order_probability_expected_billing_date.sql +++ b/sql/Pg-upgrade2/sales_quotation_order_probability_expected_billing_date.sql @@ -1,5 +1,4 @@ -- @tag: sales_quotation_order_probability_expected_billing_date --- @charset: utf-8 -- @description: Weitere Felder im Angebot: Angebotswahrscheinlichkeit, voraussichtliches Abrechnungsdatum ALTER TABLE oe ADD COLUMN order_probability INTEGER, diff --git a/sql/Pg-upgrade2/shop_parts.sql b/sql/Pg-upgrade2/shop_parts.sql index 8c627cd65..7d509ad61 100644 --- a/sql/Pg-upgrade2/shop_parts.sql +++ b/sql/Pg-upgrade2/shop_parts.sql @@ -1,6 +1,5 @@ -- @tag: shop_parts -- @description: Add tables for part information for shop --- @charset: UTF-8 -- @depends: release_3_5_0 shops -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shopimages.sql b/sql/Pg-upgrade2/shopimages.sql index 8a61bb9c2..767429efa 100644 --- a/sql/Pg-upgrade2/shopimages.sql +++ b/sql/Pg-upgrade2/shopimages.sql @@ -1,6 +1,5 @@ -- @tag:shopimages -- @description: Tabelle für Shopbilder und zusätzliche Konfiguration und valid_type für Filemanagement --- @charset: UTF-8 -- @depends: release_3_5_0 files shop_parts -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shopimages_2.sql b/sql/Pg-upgrade2/shopimages_2.sql index 153a9d04a..0ff4d1c83 100644 --- a/sql/Pg-upgrade2/shopimages_2.sql +++ b/sql/Pg-upgrade2/shopimages_2.sql @@ -1,6 +1,5 @@ -- @tag:shopimages_2 -- @description: Umbennung der Spalten für Weite und Breite in die Weite und Breite des orginal Bildes --- @charset: UTF-8 -- @depends: release_3_5_0 files shop_parts shopimages -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shopimages_3.sql b/sql/Pg-upgrade2/shopimages_3.sql index 7ffd86748..84a3481e8 100644 --- a/sql/Pg-upgrade2/shopimages_3.sql +++ b/sql/Pg-upgrade2/shopimages_3.sql @@ -1,6 +1,5 @@ -- @tag:shopimages_3 -- @description: Neue Spalte object_id um eine group_by Klausel zu haben für act_as_list --- @charset: UTF-8 -- @depends: release_3_5_0 files shop_parts shopimages -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shops_1.sql b/sql/Pg-upgrade2/shops_1.sql index 0b2c5a2f3..89e69a5bd 100644 --- a/sql/Pg-upgrade2/shops_1.sql +++ b/sql/Pg-upgrade2/shops_1.sql @@ -1,6 +1,5 @@ -- @tag: shop_1 -- @description: Add tables for part information for shop --- @charset: UTF-8 -- @depends: shops -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shops_2.sql b/sql/Pg-upgrade2/shops_2.sql index b6828436b..28cf60229 100644 --- a/sql/Pg-upgrade2/shops_2.sql +++ b/sql/Pg-upgrade2/shops_2.sql @@ -1,6 +1,5 @@ -- @tag: shop_2 -- @description: Add tables for part information for shop --- @charset: UTF-8 -- @depends: shops -- @ignore: 0 diff --git a/sql/Pg-upgrade2/shops_3.sql b/sql/Pg-upgrade2/shops_3.sql index 1be783055..9bfcc733f 100644 --- a/sql/Pg-upgrade2/shops_3.sql +++ b/sql/Pg-upgrade2/shops_3.sql @@ -1,6 +1,5 @@ -- @tag: shop_3 -- @description: Add columns itime and mtime and transaction_description for table shops --- @charset: UTF-8 -- @depends: shops -- @ignore: 0 diff --git a/sql/Pg-upgrade2/transfer_out_sales_invoice.sql b/sql/Pg-upgrade2/transfer_out_sales_invoice.sql index e3bfe4175..07eceb8d1 100644 --- a/sql/Pg-upgrade2/transfer_out_sales_invoice.sql +++ b/sql/Pg-upgrade2/transfer_out_sales_invoice.sql @@ -1,7 +1,6 @@ -- @tag: transfer_out_sales_invoice -- @description: Felder für das Feature "Auslagern beim Buchen von Verkaufsrechnungen". -- @depends: warehouse_add_delivery_order_items_stock_id --- @encoding: utf-8 ALTER TABLE inventory ADD COLUMN invoice_id INTEGER REFERENCES invoice(id); ALTER TABLE defaults ADD COLUMN is_transfer_out BOOLEAN NOT NULL DEFAULT FALSE; diff --git a/sql/Pg-upgrade2/transfer_type_assembled.sql b/sql/Pg-upgrade2/transfer_type_assembled.sql index 790002ac2..5a402fe35 100644 --- a/sql/Pg-upgrade2/transfer_type_assembled.sql +++ b/sql/Pg-upgrade2/transfer_type_assembled.sql @@ -1,6 +1,5 @@ -- @tag: transfer_type_assembled -- @description: Transfertyp "gefertigt" wird benötigt. -- @depends: release_3_4_0 warehouse --- @encoding: utf-8 INSERT INTO transfer_type (direction, description, sortkey) VALUES ('in', 'assembled', (SELECT COALESCE(MAX(sortkey), 0) + 1 FROM transfer_type)); diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql index c8b58e5e9..e83855b5f 100644 --- a/sql/Pg-upgrade2/trigram_indices.sql +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -1,7 +1,6 @@ -- @tag: trigram_indices -- @description: Trigram Indizes für häufig durchsuchte Spalten -- @depends: release_3_5_0 shops --- @encoding: utf-8 -- @ignore: 1 diff --git a/sql/Pg-upgrade2/trigram_indices_webshop.sql b/sql/Pg-upgrade2/trigram_indices_webshop.sql index e008927d4..24270d852 100644 --- a/sql/Pg-upgrade2/trigram_indices_webshop.sql +++ b/sql/Pg-upgrade2/trigram_indices_webshop.sql @@ -1,7 +1,6 @@ -- @tag: trigram_indices_webshop -- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul -- @depends: release_3_5_0 shops --- @encoding: utf-8 -- @ignore: 1 CREATE INDEX customer_street_gin_trgm_idx ON customer USING gin (street gin_trgm_ops); diff --git a/sql/Pg-upgrade2/user_preferences.sql b/sql/Pg-upgrade2/user_preferences.sql index d20beea5f..d6a16407b 100644 --- a/sql/Pg-upgrade2/user_preferences.sql +++ b/sql/Pg-upgrade2/user_preferences.sql @@ -1,7 +1,6 @@ -- @tag: user_preferences -- @description: Benutzereinstellungen -- @depends: release_3_4_1 --- @encoding: utf-8 CREATE TABLE user_preferences ( id SERIAL PRIMARY KEY, -- 2.20.1