Rose DB aktualisiert inkl. ALL.pm

[kivitendo-erp.git] / SL / DB / Helper / Mappings.pm

diff --git a/SL/DB/Helper/Mappings.pm b/SL/DB/Helper/Mappings.pm
index d1f2971..022894c 100644 (file)
--- a/SL/DB/Helper/Mappings.pm
+++ b/SL/DB/Helper/Mappings.pm
@@ -22,6 +22,53 @@ my @kivitendo_blacklist_temp = qw(
 
 # tables created by crm module
 my @crm_blacklist = qw(
+  blz_data
+  bundesland
+  contmasch
+  contract
+  crm
+  crmdefaults
+  crmemployee
+  custmsg
+  docfelder
+  documents
+  documenttotc
+  docvorlage
+  extra_felder
+  geodb_changelog
+  geodb_coordinates
+  geodb_floatdata
+  geodb_hierarchies
+  geodb_intdata
+  geodb_locations
+  geodb_textdata
+  geodb_type_names
+  grpusr
+  gruppenname
+  history
+  labels
+  labeltxt
+  mailvorlage
+  maschine
+  maschmat
+  opport_status
+  opportunity
+  postit
+  repauftrag
+  telcall
+  telcallhistory
+  telnr
+  tempcsvdata
+  termdate
+  termincat
+  termine
+  terminmember
+  timetrack
+  tt_event
+  tt_parts
+  wiedervorlage
+  wissencategorie
+  wissencontent
 );
 
 # tables created by cash register
@@ -35,24 +82,29 @@ my @kivitendo_blacklist = (@kivitendo_blacklist_permanent, @kivitendo_blacklist_
 # unlike rails we have no singular<->plural magic.
 # remeber: tables should be named as the plural of the model name.
 my %kivitendo_package_names = (
+  # TABLE                           # MODEL (given in C style)
   acc_trans                      => 'acc_transaction',
-  audittrail                     => 'audit_trail',
   'auth.clients'                 => 'auth_client',
   'auth.clients_users'           => 'auth_client_user',
   'auth.clients_groups'          => 'auth_client_group',
-  'auth.group'                   => 'auth_groups',
-  'auth.group_right'             => 'auth_group_rights',
-  'auth.user'                    => 'auth_users',
-  'auth.user_config'             => 'auth_user_configs',
-  'auth.user_group'              => 'auth_user_groups',
+  'auth.group'                   => 'auth_group',
+  'auth.group_rights'            => 'auth_group_right',
+  'auth.user'                    => 'auth_user',
+  'auth.user_config'             => 'auth_user_config',
+  'auth.user_group'              => 'auth_user_group',
   ar                             => 'invoice',
   ap                             => 'purchase_invoice',
+  assembly                       => 'assembly',
   background_jobs                => 'background_job',
   background_job_histories       => 'background_job_history',
   ap                             => 'purchase_invoice',
   bank_accounts                  => 'bank_account',
   buchungsgruppen                => 'buchungsgruppe',
+  bin                            => 'bin',
+  business                       => 'business',
+  chart                          => 'chart',
   contacts                       => 'contact',
+  customer                       => 'customer',
   csv_import_profiles            => 'csv_import_profile',
   csv_import_profile_settings    => 'csv_import_profile_setting',
   csv_import_reports             => 'csv_import_report',
@@ -66,8 +118,9 @@ my %kivitendo_package_names = (
   defaults                       => 'default',
   delivery_orders                => 'delivery_order',
   delivery_order_items           => 'delivery_order_item',
+  delivery_order_items_stock     => 'delivery_order_items_stock',
+  delivery_terms                 => 'delivery_term',
   department                     => 'department',
-  dpt_trans                      => 'dpt_trans',
   drafts                         => 'draft',
   dunning                        => 'dunning',
   dunning_config                 => 'dunning_config',
@@ -95,21 +148,25 @@ my %kivitendo_package_names = (
   prices                         => 'price',
   price_factors                  => 'price_factor',
   pricegroup                     => 'pricegroup',
-  printers                       => 'Printer',
+  printers                       => 'printer',
+  project                        => 'project',
+  project_types                  => 'ProjectType',
   record_links                   => 'record_link',
   sepa_export                    => 'sepa_export',
   sepa_export_items              => 'sepa_export_item',
   schema_info                    => 'schema_info',
+  shipto                         => 'shipto',
   status                         => 'status',
   tax                            => 'tax',
   taxkeys                        => 'tax_key',
   tax_zones                      => 'tax_zone',
   todo_user_config               => 'todo_user_config',
+  transfer_type                  => 'transfer_type',
   translation                    => 'translation',
-  translation_payment_terms      => 'translation_payment_term',
   units                          => 'unit',
   units_language                 => 'units_language',
   vendor                         => 'vendor',
+  warehouse                      => 'warehouse',
 );
 
 my (%kivitendo_tables_to_packages, %kivitendo_tables_to_manager_packages, %kivitendo_packages_to_tables);