X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d14a38bbaa7fcd371998b43bf389f56908575c7c..64b49f6c38c2c5763f21df00c7b4580ff70893be:/SL/DB/MetaSetup/Shipto.pm diff --git a/SL/DB/MetaSetup/Shipto.pm b/SL/DB/MetaSetup/Shipto.pm index cde5a320d..f7b90d825 100644 --- a/SL/DB/MetaSetup/Shipto.pm +++ b/SL/DB/MetaSetup/Shipto.pm @@ -6,33 +6,33 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'shipto', - - columns => [ - trans_id => { type => 'integer' }, - shiptoname => { type => 'varchar', length => 75 }, - shiptodepartment_1 => { type => 'varchar', length => 75 }, - shiptodepartment_2 => { type => 'varchar', length => 75 }, - shiptostreet => { type => 'varchar', length => 75 }, - shiptozipcode => { type => 'varchar', length => 75 }, - shiptocity => { type => 'varchar', length => 75 }, - shiptocountry => { type => 'varchar', length => 75 }, - shiptocontact => { type => 'varchar', length => 75 }, - shiptophone => { type => 'varchar', length => 30 }, - shiptofax => { type => 'varchar', length => 30 }, - shiptoemail => { type => 'text' }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - module => { type => 'text' }, - shipto_id => { type => 'integer', not_null => 1, sequence => 'id' }, - shiptocp_gender => { type => 'text' }, - ], - - primary_key_columns => [ 'shipto_id' ], - - allow_inline_column_values => 1, +__PACKAGE__->meta->table('shipto'); + +__PACKAGE__->meta->columns( + trans_id => { type => 'integer' }, + shiptoname => { type => 'varchar', length => 75 }, + shiptodepartment_1 => { type => 'varchar', length => 75 }, + shiptodepartment_2 => { type => 'varchar', length => 75 }, + shiptostreet => { type => 'varchar', length => 75 }, + shiptozipcode => { type => 'varchar', length => 75 }, + shiptocity => { type => 'varchar', length => 75 }, + shiptocountry => { type => 'varchar', length => 75 }, + shiptocontact => { type => 'varchar', length => 75 }, + shiptophone => { type => 'varchar', length => 30 }, + shiptofax => { type => 'varchar', length => 30 }, + shiptoemail => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + module => { type => 'text' }, + shipto_id => { type => 'integer', not_null => 1, sequence => 'id' }, + shiptocp_gender => { type => 'text' }, ); +__PACKAGE__->meta->primary_key_columns([ 'shipto_id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +# __PACKAGE__->meta->initialize; + 1; ;