# 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
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.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',
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',
prices => 'price',
price_factors => 'price_factor',
pricegroup => 'pricegroup',
- printers => 'Printer',
+ printers => 'printer',
+ project => 'project',
+ project_participants => 'project_participant',
+ project_phase_participants => 'project_phase_participant',
+ project_phases => 'project_phase',
+ project_roles => 'project_role',
+ project_statuses => 'project_status',
+ project_types => 'project_type',
record_links => 'record_link',
+ requirement_spec_acceptance_statuses => 'RequirementSpecAcceptanceStatus',
+ requirement_spec_complexities => 'RequirementSpecComplexity',
+ requirement_spec_item_dependencies => 'RequirementSpecDependency',
+ requirement_spec_items => 'RequirementSpecItem',
+ requirement_spec_orders => 'RequirementSpecOrder',
+ requirement_spec_pictures => 'RequirementSpecPicture',
+ requirement_spec_predefined_texts => 'RequirementSpecPredefinedText',
+ requirement_spec_risks => 'RequirementSpecRisk',
+ requirement_spec_statuses => 'RequirementSpecStatus',
+ requirement_spec_text_blocks => 'RequirementSpecTextBlock',
+ requirement_spec_types => 'RequirementSpecType',
+ requirement_spec_versions => 'RequirementSpecVersion',
+ requirement_specs => 'RequirementSpec',
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',
+ trigger_information => 'trigger_information',
units => 'unit',
units_language => 'units_language',
vendor => 'vendor',
+ warehouse => 'warehouse',
);
my (%kivitendo_tables_to_packages, %kivitendo_tables_to_manager_packages, %kivitendo_packages_to_tables);