Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 05ec372b

Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt

  • ID 05ec372b864a96ba7e079707ff1e534840756f8a
  • Vorgänger 5d57855d
  • Nachfolger 70fedc9f

EmailJournal: DB-Tabelle für feste Verknüpfung von Email mit Kreditorenbuchung

und Einkaufsrechnung

Unterschiede anzeigen:

SL/DB/HardRecordLinksEmailJournalAndAP.pm
1
# This file has been auto-generated only because it didn't exist.
2
# Feel free to modify it at will; it will not be overwritten automatically.
3

  
4
package SL::DB::HardRecordLinksEmailJournalAndAP;
5

  
6
use strict;
7

  
8
use SL::DB::MetaSetup::HardRecordLinksEmailJournalAndAP;
9
use SL::DB::Manager::HardRecordLinksEmailJournalAndAP;
10

  
11
__PACKAGE__->meta->initialize;
12

  
13
1;
SL/DB/Helper/ALL.pm
74 74
use SL::DB::GenericTranslation;
75 75
use SL::DB::Greeting;
76 76
use SL::DB::HardRecordLinksEmailJournalAndOrder;
77
use SL::DB::HardRecordLinksEmailJournalAndAP;
77 78
use SL::DB::History;
78 79
use SL::DB::Inventory;
79 80
use SL::DB::Invoice;
SL/DB/Helper/Mappings.pm
155 155
  generic_translations           => 'generic_translation',
156 156
  gl                             => 'GLTransaction',
157 157
  greetings                      => 'greeting',
158
  hard_record_links_email_journal_and_ap => 'HardRecordLinksEmailJournalAndAP',
158 159
  hard_record_links_email_journal_and_order => 'HardRecordLinksEmailJournalAndOrder',
159 160
  history_erp                    => 'history',
160 161
  inventory                      => 'inventory',
SL/DB/Manager/HardRecordLinksEmailJournalAndAP.pm
1
# This file has been auto-generated only because it didn't exist.
2
# Feel free to modify it at will; it will not be overwritten automatically.
3

  
4
package SL::DB::Manager::HardRecordLinksEmailJournalAndAP;
5

  
6
use strict;
7

  
8
use parent qw(SL::DB::Helper::Manager);
9

  
10
sub object_class { 'SL::DB::HardRecordLinksEmailJournalAndAP' }
11

  
12
__PACKAGE__->make_manager_methods;
13

  
14
1;
SL/DB/MetaSetup/HardRecordLinksEmailJournalAndAP.pm
1
# This file has been auto-generated. Do not modify it; it will be overwritten
2
# by rose_auto_create_model.pl automatically.
3
package SL::DB::HardRecordLinksEmailJournalAndAP;
4

  
5
use strict;
6

  
7
use parent qw(SL::DB::Object);
8

  
9
__PACKAGE__->meta->table('hard_record_links_email_journal_and_ap');
10

  
11
__PACKAGE__->meta->columns(
12
  ap_id            => { type => 'integer', not_null => 1 },
13
  email_journal_id => { type => 'integer', not_null => 1 },
14
  itime            => { type => 'timestamp', default => 'now()' },
15
);
16

  
17
__PACKAGE__->meta->primary_key_columns([ 'email_journal_id', 'ap_id' ]);
18

  
19
__PACKAGE__->meta->allow_inline_column_values(1);
20

  
21
__PACKAGE__->meta->foreign_keys(
22
  ap => {
23
    class       => 'SL::DB::PurchaseInvoice',
24
    key_columns => { ap_id => 'id' },
25
  },
26

  
27
  email_journal => {
28
    class       => 'SL::DB::EmailJournal',
29
    key_columns => { email_journal_id => 'id' },
30
  },
31
);
32

  
33
1;
34
;
sql/Pg-upgrade2/hard_record_links_email_journal_and_ap_transaction.sql
1
-- @tag: hard_record_links_email_journal_and_ap
2
-- @description: Add hard record links for email journal and ap transaction / purchase invoice
3
-- @depends: release_3_8_0
4
-- @ignore: 0
5

  
6
CREATE TABLE hard_record_links_email_journal_and_ap (
7
  email_journal_id INTEGER NOT NULL REFERENCES email_journal(id),
8
  ap_id INTEGER NOT NULL REFERENCES ap(id),
9
  itime TIMESTAMP without time zone DEFAULT now(),
10
  PRIMARY KEY (email_journal_id, ap_id)
11
);

Auch abrufbar als: Unified diff