From 4fd22b569d4436293e0a9d364d7356b5bfc503e5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Tue, 7 Sep 2010 18:40:30 +0200 Subject: [PATCH] =?utf8?q?DBO=20Update=20-=20alle=20normalen=20Models=20hi?= =?utf8?q?nzugef=C3=BCgt.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/BankAccount.pm | 13 ++++++ SL/DB/Buchungsgruppe.pm | 13 ++++++ SL/DB/Contact.pm | 13 ++++++ SL/DB/CustomVariable.pm | 13 ++++++ SL/DB/CustomVariableConfig.pm | 13 ++++++ SL/DB/CustomVariableValidity.pm | 13 ++++++ SL/DB/Draft.pm | 13 ++++++ SL/DB/Dunning.pm | 13 ++++++ SL/DB/DunningConfig.pm | 13 ++++++ SL/DB/Employee.pm | 13 ++++++ SL/DB/FollowUp.pm | 13 ++++++ SL/DB/FollowUpLink.pm | 13 ++++++ SL/DB/GenericTranslation.pm | 13 ++++++ SL/DB/Helpers/ALL.pm | 26 ++++++++++++ SL/DB/Helpers/Mappings.pm | 32 ++++++++++++--- SL/DB/History.pm | 13 ++++++ SL/DB/Language.pm | 13 ++++++ SL/DB/Licemse.pm | 13 ++++++ SL/DB/MetaSetup/BankAccount.pm | 33 +++++++++++++++ SL/DB/MetaSetup/Buchungsgruppe.pm | 31 ++++++++++++++ SL/DB/MetaSetup/Contact.pm | 42 +++++++++++++++++++ SL/DB/MetaSetup/CustomVariable.pm | 38 +++++++++++++++++ SL/DB/MetaSetup/CustomVariableConfig.pm | 35 ++++++++++++++++ SL/DB/MetaSetup/CustomVariableValidity.pm | 32 +++++++++++++++ SL/DB/MetaSetup/DeliveryOrder.pm | 20 +++++++++ SL/DB/MetaSetup/Draft.pm | 35 ++++++++++++++++ SL/DB/MetaSetup/Dunning.pm | 45 ++++++++++++++++++++ SL/DB/MetaSetup/DunningConfig.pm | 34 +++++++++++++++ SL/DB/MetaSetup/Employee.pm | 39 ++++++++++++++++++ SL/DB/MetaSetup/FollowUp.pm | 46 +++++++++++++++++++++ SL/DB/MetaSetup/FollowUpLink.pm | 35 ++++++++++++++++ SL/DB/MetaSetup/GenericTranslation.pm | 31 ++++++++++++++ SL/DB/MetaSetup/History.pm | 35 ++++++++++++++++ SL/DB/MetaSetup/Invoice.pm | 10 +++++ SL/DB/MetaSetup/Language.pm | 30 ++++++++++++++ SL/DB/MetaSetup/Licemse.pm | 27 ++++++++++++ SL/DB/MetaSetup/Note.pm | 36 ++++++++++++++++ SL/DB/MetaSetup/Order.pm | 15 +++++++ SL/DB/MetaSetup/Part.pm | 7 ++++ SL/DB/MetaSetup/PaymentTerm.pm | 31 ++++++++++++++ SL/DB/MetaSetup/Pricegroup.pm | 21 ++++++++++ SL/DB/MetaSetup/RMA.pm | 48 ++++++++++++++++++++++ SL/DB/MetaSetup/SepaExport.pm | 33 +++++++++++++++ SL/DB/MetaSetup/SepaExportItem.pm | 50 +++++++++++++++++++++++ SL/DB/MetaSetup/Tax.pm | 29 +++++++++++++ SL/DB/MetaSetup/Taxkey.pm | 32 +++++++++++++++ SL/DB/Note.pm | 13 ++++++ SL/DB/PaymentTerm.pm | 13 ++++++ SL/DB/Pricegroup.pm | 13 ++++++ SL/DB/RMA.pm | 13 ++++++ SL/DB/SepaExport.pm | 13 ++++++ SL/DB/SepaExportItem.pm | 13 ++++++ SL/DB/Tax.pm | 13 ++++++ SL/DB/Taxkey.pm | 13 ++++++ 54 files changed, 1264 insertions(+), 6 deletions(-) create mode 100644 SL/DB/BankAccount.pm create mode 100644 SL/DB/Buchungsgruppe.pm create mode 100644 SL/DB/Contact.pm create mode 100644 SL/DB/CustomVariable.pm create mode 100644 SL/DB/CustomVariableConfig.pm create mode 100644 SL/DB/CustomVariableValidity.pm create mode 100644 SL/DB/Draft.pm create mode 100644 SL/DB/Dunning.pm create mode 100644 SL/DB/DunningConfig.pm create mode 100644 SL/DB/Employee.pm create mode 100644 SL/DB/FollowUp.pm create mode 100644 SL/DB/FollowUpLink.pm create mode 100644 SL/DB/GenericTranslation.pm create mode 100644 SL/DB/History.pm create mode 100644 SL/DB/Language.pm create mode 100644 SL/DB/Licemse.pm create mode 100644 SL/DB/MetaSetup/BankAccount.pm create mode 100644 SL/DB/MetaSetup/Buchungsgruppe.pm create mode 100644 SL/DB/MetaSetup/Contact.pm create mode 100644 SL/DB/MetaSetup/CustomVariable.pm create mode 100644 SL/DB/MetaSetup/CustomVariableConfig.pm create mode 100644 SL/DB/MetaSetup/CustomVariableValidity.pm create mode 100644 SL/DB/MetaSetup/Draft.pm create mode 100644 SL/DB/MetaSetup/Dunning.pm create mode 100644 SL/DB/MetaSetup/DunningConfig.pm create mode 100644 SL/DB/MetaSetup/Employee.pm create mode 100644 SL/DB/MetaSetup/FollowUp.pm create mode 100644 SL/DB/MetaSetup/FollowUpLink.pm create mode 100644 SL/DB/MetaSetup/GenericTranslation.pm create mode 100644 SL/DB/MetaSetup/History.pm create mode 100644 SL/DB/MetaSetup/Language.pm create mode 100644 SL/DB/MetaSetup/Licemse.pm create mode 100644 SL/DB/MetaSetup/Note.pm create mode 100644 SL/DB/MetaSetup/PaymentTerm.pm create mode 100644 SL/DB/MetaSetup/Pricegroup.pm create mode 100644 SL/DB/MetaSetup/RMA.pm create mode 100644 SL/DB/MetaSetup/SepaExport.pm create mode 100644 SL/DB/MetaSetup/SepaExportItem.pm create mode 100644 SL/DB/MetaSetup/Tax.pm create mode 100644 SL/DB/MetaSetup/Taxkey.pm create mode 100644 SL/DB/Note.pm create mode 100644 SL/DB/PaymentTerm.pm create mode 100644 SL/DB/Pricegroup.pm create mode 100644 SL/DB/RMA.pm create mode 100644 SL/DB/SepaExport.pm create mode 100644 SL/DB/SepaExportItem.pm create mode 100644 SL/DB/Tax.pm create mode 100644 SL/DB/Taxkey.pm diff --git a/SL/DB/BankAccount.pm b/SL/DB/BankAccount.pm new file mode 100644 index 000000000..c293c6c34 --- /dev/null +++ b/SL/DB/BankAccount.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::BankAccount; + +use strict; + +use SL::DB::MetaSetup::BankAccount; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Buchungsgruppe.pm b/SL/DB/Buchungsgruppe.pm new file mode 100644 index 000000000..2dffaa5a9 --- /dev/null +++ b/SL/DB/Buchungsgruppe.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Buchungsgruppe; + +use strict; + +use SL::DB::MetaSetup::Buchungsgruppe; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Contact.pm b/SL/DB/Contact.pm new file mode 100644 index 000000000..69d666fec --- /dev/null +++ b/SL/DB/Contact.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Contact; + +use strict; + +use SL::DB::MetaSetup::Contact; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/CustomVariable.pm b/SL/DB/CustomVariable.pm new file mode 100644 index 000000000..6410e3f25 --- /dev/null +++ b/SL/DB/CustomVariable.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::CustomVariable; + +use strict; + +use SL::DB::MetaSetup::CustomVariable; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/CustomVariableConfig.pm b/SL/DB/CustomVariableConfig.pm new file mode 100644 index 000000000..3410a4966 --- /dev/null +++ b/SL/DB/CustomVariableConfig.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::CustomVariableConfig; + +use strict; + +use SL::DB::MetaSetup::CustomVariableConfig; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/CustomVariableValidity.pm b/SL/DB/CustomVariableValidity.pm new file mode 100644 index 000000000..a96afdb23 --- /dev/null +++ b/SL/DB/CustomVariableValidity.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::CustomVariableValidity; + +use strict; + +use SL::DB::MetaSetup::CustomVariableValidity; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Draft.pm b/SL/DB/Draft.pm new file mode 100644 index 000000000..ea6ebd65e --- /dev/null +++ b/SL/DB/Draft.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Draft; + +use strict; + +use SL::DB::MetaSetup::Draft; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Dunning.pm b/SL/DB/Dunning.pm new file mode 100644 index 000000000..80ffd7778 --- /dev/null +++ b/SL/DB/Dunning.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Dunning; + +use strict; + +use SL::DB::MetaSetup::Dunning; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/DunningConfig.pm b/SL/DB/DunningConfig.pm new file mode 100644 index 000000000..059b79888 --- /dev/null +++ b/SL/DB/DunningConfig.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::DunningConfig; + +use strict; + +use SL::DB::MetaSetup::DunningConfig; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Employee.pm b/SL/DB/Employee.pm new file mode 100644 index 000000000..841696b6e --- /dev/null +++ b/SL/DB/Employee.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Employee; + +use strict; + +use SL::DB::MetaSetup::Employee; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/FollowUp.pm b/SL/DB/FollowUp.pm new file mode 100644 index 000000000..b50c90f2a --- /dev/null +++ b/SL/DB/FollowUp.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::FollowUp; + +use strict; + +use SL::DB::MetaSetup::FollowUp; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/FollowUpLink.pm b/SL/DB/FollowUpLink.pm new file mode 100644 index 000000000..6945bfa8f --- /dev/null +++ b/SL/DB/FollowUpLink.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::FollowUpLink; + +use strict; + +use SL::DB::MetaSetup::FollowUpLink; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/GenericTranslation.pm b/SL/DB/GenericTranslation.pm new file mode 100644 index 000000000..14b5618a5 --- /dev/null +++ b/SL/DB/GenericTranslation.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::GenericTranslation; + +use strict; + +use SL::DB::MetaSetup::GenericTranslation; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Helpers/ALL.pm b/SL/DB/Helpers/ALL.pm index d55613b04..f766d169a 100644 --- a/SL/DB/Helpers/ALL.pm +++ b/SL/DB/Helpers/ALL.pm @@ -3,29 +3,55 @@ package SL::DB::Helpers::ALL; use strict; use SL::DB::Assembly; +use SL::DB::BankAccount; use SL::DB::Bin; +use SL::DB::Buchungsgruppe; use SL::DB::Business; use SL::DB::Chart; +use SL::DB::Contact; +use SL::DB::CustomVariable; +use SL::DB::CustomVariableConfig; +use SL::DB::CustomVariableValidity; use SL::DB::Customer; use SL::DB::DeliveryOrder; use SL::DB::DeliveryOrderItem; use SL::DB::DeliveryOrderItemsStock; +use SL::DB::Draft; +use SL::DB::Dunning; +use SL::DB::DunningConfig; +use SL::DB::Employee; +use SL::DB::FollowUp; +use SL::DB::FollowUpLink; use SL::DB::GLTransaction; +use SL::DB::GenericTranslation; +use SL::DB::History; use SL::DB::Invoice; use SL::DB::InvoiceItem; +use SL::DB::Language; +use SL::DB::Licemse; +use SL::DB::Note; use SL::DB::Order; use SL::DB::OrderItem; use SL::DB::Part; +use SL::DB::PaymentTerm; use SL::DB::PriceFactor; +use SL::DB::Pricegroup; use SL::DB::Printer; use SL::DB::Project; use SL::DB::PurchaseInvoice; +use SL::DB::RMA; +use SL::DB::SepaExport; +use SL::DB::SepaExportItem; use SL::DB::Shipto; +use SL::DB::Tax; +use SL::DB::Taxkey; use SL::DB::TransferType; use SL::DB::Unit; use SL::DB::Vendor; use SL::DB::Warehouse; + + 1; __END__ diff --git a/SL/DB/Helpers/Mappings.pm b/SL/DB/Helpers/Mappings.pm index 0ba43d9f1..d4ee675e5 100644 --- a/SL/DB/Helpers/Mappings.pm +++ b/SL/DB/Helpers/Mappings.pm @@ -2,7 +2,7 @@ package SL::DB::Helpers::Mappings; use strict; -# threse will not be managed as Rose::DB models, because they are not normalized +# these will not be managed as Rose::DB models, because they are not normalized # significant changes are needed to get them done. my @lxoffice_blacklist_permanent = qw( acc_trans audittrail customertax datev defaults department dpt_trans @@ -14,11 +14,7 @@ my @lxoffice_blacklist_permanent = qw( # these are not managed _yet_, but will hopefully at some point. # if you are confident that one of these works, remove it here. my @lxoffice_blacklist_temp = qw( - bank_accounts buchungsgruppen contacts custom_variable_configs - custom_variables custom_variables_validity drafts dunning dunning_config - employee follow_up_links follow_ups generic_translations history_erp language - license notes payment_terms pricegroup rma schema_info sepa_export - sepa_export_items tax taxkeys + schema_info ); my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_temp); @@ -29,15 +25,39 @@ my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_tem my %lxoffice_package_names = ( ar => 'invoice', ap => 'purchase_invoice', + bank_accounts => 'bank_account', + buchungsgruppen => 'buchungsgruppe', + contacts => 'contact', + custom_variable_configs => 'custom_variable_config', + custom_variables => 'custom_variable', + custom_variables_validity => 'custom_variable_validity', delivery_orders => 'delivery_order', delivery_order_items => 'delivery_order_item', + drafts => 'draft', + dunning => 'dunning', + dunning_config => 'dunning_config', + employee => 'employee', + follow_up_links => 'follow_up_link', + follow_ups => 'follow_up', + generic_translations => 'generic_translation', gl => 'GLTransaction', + history_erp => 'history', invoice => 'invoice_item', + language => 'language', + license => 'licemse', + notes => 'note', orderitems => 'order_item', oe => 'order', parts => 'part', + payment_terms => 'payment_term', price_factors => 'price_factor', + pricegroup => 'pricegroup', printers => 'Printer', + rma => 'RMA', + sepa_export => 'sepa_export', + sepa_export_items => 'sepa_export_item', + tax => 'tax', + taxkeys => 'taxkey', units => 'unit', ); diff --git a/SL/DB/History.pm b/SL/DB/History.pm new file mode 100644 index 000000000..c935a8237 --- /dev/null +++ b/SL/DB/History.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::History; + +use strict; + +use SL::DB::MetaSetup::History; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Language.pm b/SL/DB/Language.pm new file mode 100644 index 000000000..abfdebce0 --- /dev/null +++ b/SL/DB/Language.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Language; + +use strict; + +use SL::DB::MetaSetup::Language; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Licemse.pm b/SL/DB/Licemse.pm new file mode 100644 index 000000000..f43ce2d03 --- /dev/null +++ b/SL/DB/Licemse.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Licemse; + +use strict; + +use SL::DB::MetaSetup::Licemse; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/MetaSetup/BankAccount.pm b/SL/DB/MetaSetup/BankAccount.pm new file mode 100644 index 000000000..5cd8e7a39 --- /dev/null +++ b/SL/DB/MetaSetup/BankAccount.pm @@ -0,0 +1,33 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::BankAccount; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'bank_accounts', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + account_number => { type => 'varchar', length => 100 }, + bank_code => { type => 'varchar', length => 100 }, + iban => { type => 'varchar', length => 100 }, + bic => { type => 'varchar', length => 100 }, + bank => { type => 'text' }, + chart_id => { type => 'integer', not_null => 1 }, + ], + + primary_key_columns => [ 'id' ], + + foreign_keys => [ + chart => { + class => 'SL::DB::Chart', + key_columns => { chart_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Buchungsgruppe.pm b/SL/DB/MetaSetup/Buchungsgruppe.pm new file mode 100644 index 000000000..8acc5a75f --- /dev/null +++ b/SL/DB/MetaSetup/Buchungsgruppe.pm @@ -0,0 +1,31 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Buchungsgruppe; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'buchungsgruppen', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + description => { type => 'text' }, + inventory_accno_id => { type => 'integer' }, + income_accno_id_0 => { type => 'integer' }, + expense_accno_id_0 => { type => 'integer' }, + income_accno_id_1 => { type => 'integer' }, + expense_accno_id_1 => { type => 'integer' }, + income_accno_id_2 => { type => 'integer' }, + expense_accno_id_2 => { type => 'integer' }, + income_accno_id_3 => { type => 'integer' }, + expense_accno_id_3 => { type => 'integer' }, + sortkey => { type => 'integer', not_null => 1 }, + ], + + primary_key_columns => [ 'id' ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Contact.pm b/SL/DB/MetaSetup/Contact.pm new file mode 100644 index 000000000..2eb4fa5e7 --- /dev/null +++ b/SL/DB/MetaSetup/Contact.pm @@ -0,0 +1,42 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Contact; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'contacts', + + columns => [ + cp_id => { type => 'integer', not_null => 1, sequence => 'id' }, + cp_cv_id => { type => 'integer' }, + cp_title => { type => 'varchar', length => 75 }, + cp_givenname => { type => 'varchar', length => 75 }, + cp_name => { type => 'varchar', length => 75 }, + cp_email => { type => 'text' }, + cp_phone1 => { type => 'varchar', length => 75 }, + cp_phone2 => { type => 'varchar', length => 75 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + cp_fax => { type => 'text' }, + cp_mobile1 => { type => 'text' }, + cp_mobile2 => { type => 'text' }, + cp_satphone => { type => 'text' }, + cp_satfax => { type => 'text' }, + cp_project => { type => 'text' }, + cp_privatphone => { type => 'text' }, + cp_privatemail => { type => 'text' }, + cp_birthday => { type => 'text' }, + cp_abteilung => { type => 'text' }, + cp_gender => { type => 'character', length => 1 }, + ], + + primary_key_columns => [ 'cp_id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/CustomVariable.pm b/SL/DB/MetaSetup/CustomVariable.pm new file mode 100644 index 000000000..bb2380a39 --- /dev/null +++ b/SL/DB/MetaSetup/CustomVariable.pm @@ -0,0 +1,38 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::CustomVariable; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'custom_variables', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'custom_variables_id' }, + config_id => { type => 'integer', not_null => 1 }, + trans_id => { type => 'integer', not_null => 1 }, + bool_value => { type => 'boolean' }, + timestamp_value => { type => 'timestamp' }, + text_value => { type => 'text' }, + number_value => { type => 'numeric', precision => 5, scale => 25 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + sub_module => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + config => { + class => 'SL::DB::CustomVariableConfig', + key_columns => { config_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/CustomVariableConfig.pm b/SL/DB/MetaSetup/CustomVariableConfig.pm new file mode 100644 index 000000000..5ee01c19d --- /dev/null +++ b/SL/DB/MetaSetup/CustomVariableConfig.pm @@ -0,0 +1,35 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::CustomVariableConfig; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'custom_variable_configs', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'custom_variable_configs_id' }, + name => { type => 'text' }, + description => { type => 'text' }, + type => { type => 'varchar', length => 20 }, + module => { type => 'varchar', length => 20 }, + default_value => { type => 'text' }, + options => { type => 'text' }, + searchable => { type => 'boolean' }, + includeable => { type => 'boolean' }, + included_by_default => { type => 'boolean' }, + sortkey => { type => 'integer' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + flags => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/CustomVariableValidity.pm b/SL/DB/MetaSetup/CustomVariableValidity.pm new file mode 100644 index 000000000..25876d748 --- /dev/null +++ b/SL/DB/MetaSetup/CustomVariableValidity.pm @@ -0,0 +1,32 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::CustomVariableValidity; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'custom_variables_validity', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + config_id => { type => 'integer', not_null => 1 }, + trans_id => { type => 'integer', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + config => { + class => 'SL::DB::CustomVariableConfig', + key_columns => { config_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/DeliveryOrder.pm b/SL/DB/MetaSetup/DeliveryOrder.pm index fc159fb7f..806c9637a 100644 --- a/SL/DB/MetaSetup/DeliveryOrder.pm +++ b/SL/DB/MetaSetup/DeliveryOrder.pm @@ -48,16 +48,36 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + contact => { + class => 'SL::DB::Contact', + key_columns => { cp_id => 'cp_id' }, + }, + customer => { class => 'SL::DB::Customer', key_columns => { customer_id => 'id' }, }, + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, }, + language => { + class => 'SL::DB::Language', + key_columns => { language_id => 'id' }, + }, + + salesman => { + class => 'SL::DB::Employee', + key_columns => { salesman_id => 'id' }, + }, + vendor => { class => 'SL::DB::Vendor', key_columns => { vendor_id => 'id' }, diff --git a/SL/DB/MetaSetup/Draft.pm b/SL/DB/MetaSetup/Draft.pm new file mode 100644 index 000000000..1a8ffc680 --- /dev/null +++ b/SL/DB/MetaSetup/Draft.pm @@ -0,0 +1,35 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Draft; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'drafts', + + columns => [ + id => { type => 'varchar', length => 50, not_null => 1 }, + module => { type => 'varchar', length => 50, not_null => 1 }, + submodule => { type => 'varchar', length => 50, not_null => 1 }, + description => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + form => { type => 'text' }, + employee_id => { type => 'integer' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Dunning.pm b/SL/DB/MetaSetup/Dunning.pm new file mode 100644 index 000000000..bc4ba879e --- /dev/null +++ b/SL/DB/MetaSetup/Dunning.pm @@ -0,0 +1,45 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Dunning; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'dunning', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + trans_id => { type => 'integer' }, + dunning_id => { type => 'integer' }, + dunning_level => { type => 'integer' }, + transdate => { type => 'date' }, + duedate => { type => 'date' }, + fee => { type => 'numeric', precision => 5, scale => 15 }, + interest => { type => 'numeric', precision => 5, scale => 15 }, + dunning_config_id => { type => 'integer' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + fee_interest_ar_id => { type => 'integer' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + dunning_config => { + class => 'SL::DB::DunningConfig', + key_columns => { dunning_config_id => 'id' }, + }, + + fee_interest_ar => { + class => 'SL::DB::Invoice', + key_columns => { fee_interest_ar_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/DunningConfig.pm b/SL/DB/MetaSetup/DunningConfig.pm new file mode 100644 index 000000000..c6702657e --- /dev/null +++ b/SL/DB/MetaSetup/DunningConfig.pm @@ -0,0 +1,34 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::DunningConfig; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'dunning_config', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + dunning_level => { type => 'integer' }, + dunning_description => { type => 'text' }, + active => { type => 'boolean' }, + auto => { type => 'boolean' }, + email => { type => 'boolean' }, + terms => { type => 'integer' }, + payment_terms => { type => 'integer' }, + fee => { type => 'numeric', precision => 5, scale => 15 }, + interest_rate => { type => 'numeric', precision => 5, scale => 15 }, + email_body => { type => 'text' }, + email_subject => { type => 'text' }, + email_attachment => { type => 'boolean' }, + template => { type => 'text' }, + create_invoices_for_fees => { type => 'boolean', default => 'true' }, + ], + + primary_key_columns => [ 'id' ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Employee.pm b/SL/DB/MetaSetup/Employee.pm new file mode 100644 index 000000000..f86174fbb --- /dev/null +++ b/SL/DB/MetaSetup/Employee.pm @@ -0,0 +1,39 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Employee; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'employee', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + login => { type => 'text' }, + startdate => { type => 'date', default => 'now' }, + enddate => { type => 'date' }, + notes => { type => 'text' }, + role => { type => 'text' }, + sales => { type => 'boolean', default => 'true' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + name => { type => 'text' }, + addr1 => { type => 'text' }, + addr2 => { type => 'text' }, + addr3 => { type => 'text' }, + addr4 => { type => 'text' }, + homephone => { type => 'text' }, + workphone => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], + + unique_key => [ 'login' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/FollowUp.pm b/SL/DB/MetaSetup/FollowUp.pm new file mode 100644 index 000000000..3e83f0e35 --- /dev/null +++ b/SL/DB/MetaSetup/FollowUp.pm @@ -0,0 +1,46 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::FollowUp; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'follow_ups', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'follow_up_id' }, + follow_up_date => { type => 'date', not_null => 1 }, + created_for_user => { type => 'integer', not_null => 1 }, + done => { type => 'boolean', default => 'false' }, + note_id => { type => 'integer', not_null => 1 }, + created_by => { type => 'integer', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { created_for_user => 'id' }, + }, + + employee_obj => { + class => 'SL::DB::Employee', + key_columns => { created_by => 'id' }, + }, + + note => { + class => 'SL::DB::Note', + key_columns => { note_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/FollowUpLink.pm b/SL/DB/MetaSetup/FollowUpLink.pm new file mode 100644 index 000000000..7bfec7ddb --- /dev/null +++ b/SL/DB/MetaSetup/FollowUpLink.pm @@ -0,0 +1,35 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::FollowUpLink; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'follow_up_links', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'follow_up_link_id' }, + follow_up_id => { type => 'integer', not_null => 1 }, + trans_id => { type => 'integer', not_null => 1 }, + trans_type => { type => 'text', not_null => 1 }, + trans_info => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + follow_up => { + class => 'SL::DB::FollowUp', + key_columns => { follow_up_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/GenericTranslation.pm b/SL/DB/MetaSetup/GenericTranslation.pm new file mode 100644 index 000000000..452222406 --- /dev/null +++ b/SL/DB/MetaSetup/GenericTranslation.pm @@ -0,0 +1,31 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::GenericTranslation; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'generic_translations', + + columns => [ + id => { type => 'serial', not_null => 1 }, + language_id => { type => 'integer' }, + translation_type => { type => 'varchar', length => 100, not_null => 1 }, + translation_id => { type => 'integer' }, + translation => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], + + foreign_keys => [ + language => { + class => 'SL::DB::Language', + key_columns => { language_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/History.pm b/SL/DB/MetaSetup/History.pm new file mode 100644 index 000000000..1146f8ff5 --- /dev/null +++ b/SL/DB/MetaSetup/History.pm @@ -0,0 +1,35 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::History; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'history_erp', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + trans_id => { type => 'integer' }, + employee_id => { type => 'integer' }, + addition => { type => 'text' }, + what_done => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + snumbers => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Invoice.pm b/SL/DB/MetaSetup/Invoice.pm index 3d7e93af9..6269da90a 100644 --- a/SL/DB/MetaSetup/Invoice.pm +++ b/SL/DB/MetaSetup/Invoice.pm @@ -68,11 +68,21 @@ __PACKAGE__->meta->setup( key_columns => { customer_id => 'id' }, }, + dunning_config => { + class => 'SL::DB::DunningConfig', + key_columns => { dunning_config_id => 'id' }, + }, + globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, }, + salesman => { + class => 'SL::DB::Employee', + key_columns => { salesman_id => 'id' }, + }, + storno_obj => { class => 'SL::DB::Invoice', key_columns => { storno_id => 'id' }, diff --git a/SL/DB/MetaSetup/Language.pm b/SL/DB/MetaSetup/Language.pm new file mode 100644 index 000000000..662abc985 --- /dev/null +++ b/SL/DB/MetaSetup/Language.pm @@ -0,0 +1,30 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Language; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'language', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + description => { type => 'text' }, + template_code => { type => 'text' }, + article_code => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + output_numberformat => { type => 'text' }, + output_dateformat => { type => 'text' }, + output_longdates => { type => 'boolean' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/Licemse.pm b/SL/DB/MetaSetup/Licemse.pm new file mode 100644 index 000000000..aea45d2d7 --- /dev/null +++ b/SL/DB/MetaSetup/Licemse.pm @@ -0,0 +1,27 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Licemse; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'license', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + parts_id => { type => 'integer' }, + customer_id => { type => 'integer' }, + comment => { type => 'text' }, + validuntil => { type => 'date' }, + issuedate => { type => 'date', default => 'now' }, + quantity => { type => 'integer' }, + licensenumber => { type => 'text' }, + ], + + primary_key_columns => [ 'id' ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Note.pm b/SL/DB/MetaSetup/Note.pm new file mode 100644 index 000000000..a055c02ab --- /dev/null +++ b/SL/DB/MetaSetup/Note.pm @@ -0,0 +1,36 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Note; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'notes', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'note_id' }, + subject => { type => 'text' }, + body => { type => 'text' }, + created_by => { type => 'integer', not_null => 1 }, + trans_id => { type => 'integer' }, + trans_module => { type => 'varchar', length => 10 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { created_by => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index e0aa5711d..914918dab 100644 --- a/SL/DB/MetaSetup/Order.pm +++ b/SL/DB/MetaSetup/Order.pm @@ -55,10 +55,25 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, }, + + project_manager => { + class => 'SL::DB::Employee', + key_columns => { project_manager_id => 'id' }, + }, + + salesman => { + class => 'SL::DB::Employee', + key_columns => { salesman_id => 'id' }, + }, ], ); diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm index f80ad78e9..d6814e8d0 100644 --- a/SL/DB/MetaSetup/Part.pm +++ b/SL/DB/MetaSetup/Part.pm @@ -53,6 +53,13 @@ __PACKAGE__->meta->setup( primary_key_columns => [ 'id' ], allow_inline_column_values => 1, + + foreign_keys => [ + buchungsgruppen => { + class => 'SL::DB::Buchungsgruppe', + key_columns => { buchungsgruppen_id => 'id' }, + }, + ], ); 1; diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm new file mode 100644 index 000000000..4e18f5df0 --- /dev/null +++ b/SL/DB/MetaSetup/PaymentTerm.pm @@ -0,0 +1,31 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::PaymentTerm; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'payment_terms', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + description => { type => 'text' }, + description_long => { type => 'text' }, + terms_netto => { type => 'integer' }, + terms_skonto => { type => 'integer' }, + percent_skonto => { type => 'float', precision => 4 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + ranking => { type => 'integer' }, + sortkey => { type => 'integer', not_null => 1 }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/Pricegroup.pm b/SL/DB/MetaSetup/Pricegroup.pm new file mode 100644 index 000000000..09ce0938e --- /dev/null +++ b/SL/DB/MetaSetup/Pricegroup.pm @@ -0,0 +1,21 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Pricegroup; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'pricegroup', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + pricegroup => { type => 'text', not_null => 1 }, + ], + + primary_key_columns => [ 'id' ], +); + +1; +; diff --git a/SL/DB/MetaSetup/RMA.pm b/SL/DB/MetaSetup/RMA.pm new file mode 100644 index 000000000..20790e360 --- /dev/null +++ b/SL/DB/MetaSetup/RMA.pm @@ -0,0 +1,48 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::RMA; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'rma', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + rmanumber => { type => 'text', not_null => 1 }, + transdate => { type => 'date', default => 'now' }, + vendor_id => { type => 'integer' }, + customer_id => { type => 'integer' }, + amount => { type => 'numeric', precision => 5, scale => 15 }, + netamount => { type => 'numeric', precision => 5, scale => 15 }, + reqdate => { type => 'date' }, + taxincluded => { type => 'boolean' }, + shippingpoint => { type => 'text' }, + notes => { type => 'text' }, + curr => { type => 'character', length => 3 }, + employee_id => { type => 'integer' }, + closed => { type => 'boolean', default => 'false' }, + quotation => { type => 'boolean', default => 'false' }, + quonumber => { type => 'text' }, + cusrmanumber => { type => 'text' }, + intnotes => { type => 'text' }, + delivery_customer_id => { type => 'integer' }, + delivery_vendor_id => { type => 'integer' }, + language_id => { type => 'integer' }, + payment_id => { type => 'integer' }, + department_id => { type => 'integer', default => '0' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + shipvia => { type => 'text' }, + cp_id => { type => 'integer' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/SepaExport.pm b/SL/DB/MetaSetup/SepaExport.pm new file mode 100644 index 000000000..943121ad4 --- /dev/null +++ b/SL/DB/MetaSetup/SepaExport.pm @@ -0,0 +1,33 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::SepaExport; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'sepa_export', + + columns => [ + id => { type => 'serial', not_null => 1 }, + employee_id => { type => 'integer', not_null => 1 }, + executed => { type => 'boolean', default => 'false' }, + closed => { type => 'boolean', default => 'false' }, + itime => { type => 'timestamp', default => 'now()' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, + + foreign_keys => [ + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/SepaExportItem.pm b/SL/DB/MetaSetup/SepaExportItem.pm new file mode 100644 index 000000000..b9899c2e5 --- /dev/null +++ b/SL/DB/MetaSetup/SepaExportItem.pm @@ -0,0 +1,50 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::SepaExportItem; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'sepa_export_items', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + sepa_export_id => { type => 'integer', not_null => 1 }, + ap_id => { type => 'integer', not_null => 1 }, + chart_id => { type => 'integer', not_null => 1 }, + amount => { type => 'numeric', precision => 5, scale => 25 }, + reference => { type => 'varchar', length => 35 }, + requested_execution_date => { type => 'date' }, + executed => { type => 'boolean', default => 'false' }, + execution_date => { type => 'date' }, + our_iban => { type => 'varchar', length => 100 }, + our_bic => { type => 'varchar', length => 100 }, + vendor_iban => { type => 'varchar', length => 100 }, + vendor_bic => { type => 'varchar', length => 100 }, + end_to_end_id => { type => 'varchar', length => 35 }, + ], + + primary_key_columns => [ 'id' ], + + foreign_keys => [ + ap => { + class => 'SL::DB::PurchaseInvoice', + key_columns => { ap_id => 'id' }, + }, + + chart => { + class => 'SL::DB::Chart', + key_columns => { chart_id => 'id' }, + }, + + sepa_export => { + class => 'SL::DB::SepaExport', + key_columns => { sepa_export_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/MetaSetup/Tax.pm b/SL/DB/MetaSetup/Tax.pm new file mode 100644 index 000000000..793b649a3 --- /dev/null +++ b/SL/DB/MetaSetup/Tax.pm @@ -0,0 +1,29 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Tax; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'tax', + + columns => [ + chart_id => { type => 'integer' }, + rate => { type => 'numeric', precision => 5, scale => 15 }, + taxnumber => { type => 'text' }, + taxkey => { type => 'integer' }, + taxdescription => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + ], + + primary_key_columns => [ 'id' ], + + allow_inline_column_values => 1, +); + +1; +; diff --git a/SL/DB/MetaSetup/Taxkey.pm b/SL/DB/MetaSetup/Taxkey.pm new file mode 100644 index 000000000..558163faa --- /dev/null +++ b/SL/DB/MetaSetup/Taxkey.pm @@ -0,0 +1,32 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Taxkey; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->setup( + table => 'taxkeys', + + columns => [ + id => { type => 'integer', not_null => 1, sequence => 'id' }, + chart_id => { type => 'integer' }, + tax_id => { type => 'integer' }, + taxkey_id => { type => 'integer' }, + pos_ustva => { type => 'integer' }, + startdate => { type => 'date' }, + ], + + primary_key_columns => [ 'id' ], + + foreign_keys => [ + tax => { + class => 'SL::DB::Tax', + key_columns => { tax_id => 'id' }, + }, + ], +); + +1; +; diff --git a/SL/DB/Note.pm b/SL/DB/Note.pm new file mode 100644 index 000000000..367829512 --- /dev/null +++ b/SL/DB/Note.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Note; + +use strict; + +use SL::DB::MetaSetup::Note; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/PaymentTerm.pm b/SL/DB/PaymentTerm.pm new file mode 100644 index 000000000..b525910e9 --- /dev/null +++ b/SL/DB/PaymentTerm.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::PaymentTerm; + +use strict; + +use SL::DB::MetaSetup::PaymentTerm; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Pricegroup.pm b/SL/DB/Pricegroup.pm new file mode 100644 index 000000000..8c9c3727e --- /dev/null +++ b/SL/DB/Pricegroup.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Pricegroup; + +use strict; + +use SL::DB::MetaSetup::Pricegroup; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/RMA.pm b/SL/DB/RMA.pm new file mode 100644 index 000000000..49c8d710a --- /dev/null +++ b/SL/DB/RMA.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::RMA; + +use strict; + +use SL::DB::MetaSetup::RMA; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/SepaExport.pm b/SL/DB/SepaExport.pm new file mode 100644 index 000000000..ab450451d --- /dev/null +++ b/SL/DB/SepaExport.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::SepaExport; + +use strict; + +use SL::DB::MetaSetup::SepaExport; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/SepaExportItem.pm b/SL/DB/SepaExportItem.pm new file mode 100644 index 000000000..3c46ee39b --- /dev/null +++ b/SL/DB/SepaExportItem.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::SepaExportItem; + +use strict; + +use SL::DB::MetaSetup::SepaExportItem; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Tax.pm b/SL/DB/Tax.pm new file mode 100644 index 000000000..58161aeff --- /dev/null +++ b/SL/DB/Tax.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Tax; + +use strict; + +use SL::DB::MetaSetup::Tax; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; diff --git a/SL/DB/Taxkey.pm b/SL/DB/Taxkey.pm new file mode 100644 index 000000000..dd442dd9a --- /dev/null +++ b/SL/DB/Taxkey.pm @@ -0,0 +1,13 @@ +# This file has been auto-generated only because it didn't exist. +# Feel free to modify it at will; it will not be overwritten automatically. + +package SL::DB::Taxkey; + +use strict; + +use SL::DB::MetaSetup::Taxkey; + +# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. +__PACKAGE__->meta->make_manager_class; + +1; -- 2.20.1