X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FPeriodicInvoicesConfig.pm;h=0c0545384140935613fa0d512414401754f34754;hb=2ea07c13e111b88478827bf621d41df3eec19dac;hp=8860e8c8054104ec6563ac5335839b18d1747775;hpb=21daf701fac24bbc753abae8d8f5f6b8bcf984f7;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm index 8860e8c80..0c0545384 100644 --- a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm +++ b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm @@ -4,44 +4,45 @@ package SL::DB::PeriodicInvoicesConfig; use strict; -use base qw(SL::DB::Object); - -__PACKAGE__->meta->setup( - table => 'periodic_invoices_configs', - - columns => [ - id => { type => 'integer', not_null => 1, sequence => 'id' }, - oe_id => { type => 'integer', not_null => 1 }, - periodicity => { type => 'varchar', length => 10, not_null => 1 }, - print => { type => 'boolean', default => 'false' }, - printer_id => { type => 'integer' }, - copies => { type => 'integer' }, - active => { type => 'boolean', default => 'true' }, - start_date => { type => 'date' }, - ar_chart_id => { type => 'integer', not_null => 1 }, - terminated => { type => 'boolean', default => 'false' }, - end_date => { type => 'date' }, - extend_automatically_by => { type => 'integer' }, - ], - - primary_key_columns => [ 'id' ], - - foreign_keys => [ - ar_chart => { - class => 'SL::DB::Chart', - key_columns => { ar_chart_id => 'id' }, - }, - - order => { - class => 'SL::DB::Order', - key_columns => { oe_id => 'id' }, - }, - - printer => { - class => 'SL::DB::Printer', - key_columns => { printer_id => 'id' }, - }, - ], +use parent qw(SL::DB::Object); + +__PACKAGE__->meta->table('periodic_invoices_configs'); + +__PACKAGE__->meta->columns( + active => { type => 'boolean', default => 'true' }, + ar_chart_id => { type => 'integer', not_null => 1 }, + copies => { type => 'integer' }, + direct_debit => { type => 'boolean', default => 'false', not_null => 1 }, + end_date => { type => 'date' }, + extend_automatically_by => { type => 'integer' }, + first_billing_date => { type => 'date' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + oe_id => { type => 'integer', not_null => 1 }, + order_value_periodicity => { type => 'varchar', length => 1, not_null => 1 }, + periodicity => { type => 'varchar', length => 1, not_null => 1 }, + print => { type => 'boolean', default => 'false' }, + printer_id => { type => 'integer' }, + start_date => { type => 'date' }, + terminated => { type => 'boolean', default => 'false' }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->foreign_keys( + ar_chart => { + class => 'SL::DB::Chart', + key_columns => { ar_chart_id => 'id' }, + }, + + order => { + class => 'SL::DB::Order', + key_columns => { oe_id => 'id' }, + }, + + printer => { + class => 'SL::DB::Printer', + key_columns => { printer_id => 'id' }, + }, ); 1;