Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision d0c938cf

Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt

  • ID d0c938cfb5fbb8c1c03b94d395d6c7839a1c597e
  • Vorgänger aa0fece0
  • Nachfolger ba6a1366

Neues DB-Setup für Währungen

Für RDBO-Code wird hier das MetaSetup der DB upgedated.

Unterschiede anzeigen:

SL/DB/MetaSetup/Customer.pm
53 53
    iban                => { type => 'varchar', length => 100 },
54 54
    bic                 => { type => 'varchar', length => 100 },
55 55
    direct_debit        => { type => 'boolean', default => 'false' },
56
    curr                => { type => 'text' },
57 56
    taxincluded_checked => { type => 'boolean' },
57
    currency_id         => { type => 'integer', not_null => 1 },
58 58
  ],
59 59

  
60 60
  primary_key_columns => [ 'id' ],
61 61

  
62
  allow_inline_column_values => 1,
63

  
64 62
  foreign_keys => [
65 63
    business => {
66 64
      class       => 'SL::DB::Business',
SL/DB/MetaSetup/Default.pm
20 20
    weightunit                          => { type => 'varchar', length => 5 },
21 21
    businessnumber                      => { type => 'text' },
22 22
    version                             => { type => 'varchar', length => 8 },
23
    curr                                => { type => 'text' },
24 23
    closedto                            => { type => 'date' },
25 24
    revtrans                            => { type => 'boolean', default => 'false' },
26 25
    ponumber                            => { type => 'text' },
......
68 67
    ar_show_mark_as_paid                => { type => 'boolean', default => 'true' },
69 68
    ap_show_mark_as_paid                => { type => 'boolean', default => 'true' },
70 69
    assemblynumber                      => { type => 'text' },
70
    currency_id                         => { type => 'integer', not_null => 1 },
71 71
  ],
72 72

  
73 73
  primary_key_columns => [ 'id' ],
SL/DB/MetaSetup/DeliveryOrder.pm
39 39
    taxzone_id              => { type => 'integer' },
40 40
    taxincluded             => { type => 'boolean' },
41 41
    terms                   => { type => 'integer' },
42
    curr                    => { type => 'text' },
42
    currency_id             => { type => 'integer', not_null => 1 },
43 43
  ],
44 44

  
45 45
  primary_key_columns => [ 'id' ],
46 46

  
47
  allow_inline_column_values => 1,
48

  
49 47
  foreign_keys => [
50 48
    contact => {
51 49
      class       => 'SL::DB::Contact',
SL/DB/MetaSetup/Exchangerate.pm
10 10
  table   => 'exchangerate',
11 11

  
12 12
  columns => [
13
    curr      => { type => 'text' },
14
    transdate => { type => 'date' },
15
    buy       => { type => 'numeric', precision => 5, scale => 15 },
16
    sell      => { type => 'numeric', precision => 5, scale => 15 },
17
    itime     => { type => 'timestamp', default => 'now()' },
18
    mtime     => { type => 'timestamp' },
19
    id        => { type => 'serial', not_null => 1 },
13
    transdate   => { type => 'date' },
14
    buy         => { type => 'numeric', precision => 5, scale => 15 },
15
    sell        => { type => 'numeric', precision => 5, scale => 15 },
16
    itime       => { type => 'timestamp', default => 'now()' },
17
    mtime       => { type => 'timestamp' },
18
    id          => { type => 'serial', not_null => 1 },
19
    currency_id => { type => 'integer', not_null => 1 },
20 20
  ],
21 21

  
22 22
  primary_key_columns => [ 'id' ],
23

  
24
  allow_inline_column_values => 1,
25 23
);
26 24

  
27 25
1;
SL/DB/MetaSetup/Invoice.pm
26 26
    shippingpoint             => { type => 'text' },
27 27
    terms                     => { type => 'integer', default => '0' },
28 28
    notes                     => { type => 'text' },
29
    curr                      => { type => 'text' },
30 29
    ordnumber                 => { type => 'text' },
31 30
    employee_id               => { type => 'integer' },
32 31
    quonumber                 => { type => 'text' },
......
57 56
    donumber                  => { type => 'text' },
58 57
    invnumber_for_credit_note => { type => 'text' },
59 58
    direct_debit              => { type => 'boolean', default => 'false' },
59
    currency_id               => { type => 'integer', not_null => 1 },
60 60
  ],
61 61

  
62 62
  primary_key_columns => [ 'id' ],
63 63

  
64
  allow_inline_column_values => 1,
65

  
66 64
  foreign_keys => [
67 65
    contact => {
68 66
      class       => 'SL::DB::Contact',
SL/DB/MetaSetup/Order.pm
21 21
    taxincluded             => { type => 'boolean' },
22 22
    shippingpoint           => { type => 'text' },
23 23
    notes                   => { type => 'text' },
24
    curr                    => { type => 'character', length => 3 },
25 24
    employee_id             => { type => 'integer' },
26 25
    closed                  => { type => 'boolean', default => 'false' },
27 26
    quotation               => { type => 'boolean', default => 'false' },
......
43 42
    delivered               => { type => 'boolean', default => 'false' },
44 43
    globalproject_id        => { type => 'integer' },
45 44
    salesman_id             => { type => 'integer' },
46
    transaction_description => { type => 'text' },
47 45
    marge_total             => { type => 'numeric', precision => 5, scale => 15 },
48 46
    marge_percent           => { type => 'numeric', precision => 5, scale => 15 },
47
    transaction_description => { type => 'text' },
48
    currency_id             => { type => 'integer', not_null => 1 },
49 49
  ],
50 50

  
51 51
  primary_key_columns => [ 'id' ],
52 52

  
53
  allow_inline_column_values => 1,
54

  
55 53
  foreign_keys => [
56 54
    contact => {
57 55
      class       => 'SL::DB::Contact',
SL/DB/MetaSetup/PurchaseInvoice.pm
23 23
    duedate                 => { type => 'date' },
24 24
    invoice                 => { type => 'boolean', default => 'false' },
25 25
    ordnumber               => { type => 'text' },
26
    curr                    => { type => 'text' },
27 26
    notes                   => { type => 'text' },
28 27
    employee_id             => { type => 'integer' },
29 28
    quonumber               => { type => 'text' },
......
44 43
    transaction_description => { type => 'text' },
45 44
    storno_id               => { type => 'integer' },
46 45
    direct_debit            => { type => 'boolean', default => 'false' },
46
    currency_id             => { type => 'integer', not_null => 1 },
47 47
  ],
48 48

  
49 49
  primary_key_columns => [ 'id' ],
50 50

  
51
  allow_inline_column_values => 1,
52

  
53 51
  foreign_keys => [
54 52
    contact => {
55 53
      class       => 'SL::DB::Contact',
SL/DB/MetaSetup/Vendor.pm
52 52
    iban           => { type => 'varchar', length => 100 },
53 53
    bic            => { type => 'varchar', length => 100 },
54 54
    direct_debit   => { type => 'boolean', default => 'false' },
55
    curr           => { type => 'text' },
55
    currency_id    => { type => 'integer', not_null => 1 },
56 56
  ],
57 57

  
58 58
  primary_key_columns => [ 'id' ],
59 59

  
60
  allow_inline_column_values => 1,
61

  
62 60
  foreign_keys => [
63 61
    business => {
64 62
      class       => 'SL::DB::Business',

Auch abrufbar als: Unified diff