From 4b7f17c8d92bff2e9f495d476a650dc3897c3097 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Mon, 4 May 2015 17:04:08 +0200 Subject: [PATCH] =?utf8?q?DB=20und=20MetaSetup=20f=C3=BCr=20Letter=20Tabel?= =?utf8?q?len?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/Letter.pm | 15 ++++++++ SL/DB/LetterDraft.pm | 15 ++++++++ SL/DB/MetaSetup/Letter.pm | 59 +++++++++++++++++++++++++++++++ SL/DB/MetaSetup/LetterDraft.pm | 64 ++++++++++++++++++++++++++++++++++ 4 files changed, 153 insertions(+) create mode 100644 SL/DB/Letter.pm create mode 100644 SL/DB/LetterDraft.pm create mode 100644 SL/DB/MetaSetup/Letter.pm create mode 100644 SL/DB/MetaSetup/LetterDraft.pm diff --git a/SL/DB/Letter.pm b/SL/DB/Letter.pm new file mode 100644 index 000000000..08657bde4 --- /dev/null +++ b/SL/DB/Letter.pm @@ -0,0 +1,15 @@ +# 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::Letter; + +use strict; + +use SL::DB::MetaSetup::Letter; + +__PACKAGE__->meta->initialize; + +# 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/LetterDraft.pm b/SL/DB/LetterDraft.pm new file mode 100644 index 000000000..eb4a4b65f --- /dev/null +++ b/SL/DB/LetterDraft.pm @@ -0,0 +1,15 @@ +# 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::LetterDraft; + +use strict; + +use SL::DB::MetaSetup::LetterDraft; + +__PACKAGE__->meta->initialize; + +# 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/Letter.pm b/SL/DB/MetaSetup/Letter.pm new file mode 100644 index 000000000..a04c4f159 --- /dev/null +++ b/SL/DB/MetaSetup/Letter.pm @@ -0,0 +1,59 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::Letter; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->table('letter'); + +__PACKAGE__->meta->columns( + id => { type => 'integer', not_null => 1, sequence => 'id' }, + vc_id => { type => 'integer', not_null => 1 }, + rcv_name => { type => 'text' }, + rcv_contact => { type => 'text' }, + rcv_address => { type => 'text' }, + rcv_countrycode => { type => 'text' }, + rcv_zipcode => { type => 'text' }, + rcv_city => { type => 'text' }, + letternumber => { type => 'text' }, + jobnumber => { type => 'text' }, + text_created_for => { type => 'text' }, + date => { type => 'text' }, + subject => { type => 'text' }, + greeting => { type => 'text' }, + body => { type => 'text' }, + close => { type => 'text' }, + company_name => { type => 'text' }, + employee_id => { type => 'integer' }, + employee_position => { type => 'text' }, + salesman_id => { type => 'integer' }, + salesman_position => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + rcv_country => { type => 'text' }, + page_created_for => { type => 'text' }, + cp_id => { type => 'integer' }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +__PACKAGE__->meta->foreign_keys( + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + + salesman => { + class => 'SL::DB::Employee', + key_columns => { salesman_id => 'id' }, + }, +); + +# __PACKAGE__->meta->initialize; + +1; +; diff --git a/SL/DB/MetaSetup/LetterDraft.pm b/SL/DB/MetaSetup/LetterDraft.pm new file mode 100644 index 000000000..6b450d09d --- /dev/null +++ b/SL/DB/MetaSetup/LetterDraft.pm @@ -0,0 +1,64 @@ +# This file has been auto-generated. Do not modify it; it will be overwritten +# by rose_auto_create_model.pl automatically. +package SL::DB::LetterDraft; + +use strict; + +use base qw(SL::DB::Object); + +__PACKAGE__->meta->table('letter_draft'); + +__PACKAGE__->meta->columns( + body => { type => 'text' }, + close => { type => 'text' }, + company_name => { type => 'text' }, + cp_id => { type => 'integer' }, + date => { type => 'date' }, + employee_id => { type => 'integer' }, + employee_position => { type => 'text' }, + greeting => { type => 'text' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + intnotes => { type => 'text' }, + itime => { type => 'timestamp', default => 'now()' }, + jobnumber => { type => 'text' }, + letternumber => { type => 'text' }, + mtime => { type => 'timestamp' }, + page_created_for => { type => 'text' }, + rcv_address => { type => 'text' }, + rcv_city => { type => 'text' }, + rcv_contact => { type => 'text' }, + rcv_country => { type => 'text' }, + rcv_countrycode => { type => 'text' }, + rcv_name => { type => 'text' }, + rcv_zipcode => { type => 'text' }, + reference => { type => 'text' }, + salesman_id => { type => 'integer' }, + salesman_position => { type => 'text' }, + subject => { type => 'text' }, + text_created_for => { type => 'text' }, + vc_id => { type => 'integer', not_null => 1 }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +__PACKAGE__->meta->foreign_keys( + contact => { + class => 'SL::DB::Contact', + key_columns => { cp_id => 'cp_id' }, + }, + + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + + salesman => { + class => 'SL::DB::Employee', + key_columns => { salesman_id => 'id' }, + }, +); + +1; +; -- 2.20.1