Revision eb58f108
Von Moritz Bunkus vor fast 14 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 11 | 11 |
|
| 12 | 12 |
columns => [ |
| 13 | 13 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 14 |
name => { type => 'varchar', length => 75, not_null => 1 },
|
|
| 14 |
name => { type => 'text', not_null => 1 },
|
|
| 15 | 15 |
department_1 => { type => 'varchar', length => 75 },
|
| 16 | 16 |
department_2 => { type => 'varchar', length => 75 },
|
| 17 | 17 |
street => { type => 'varchar', length => 75 },
|
| 18 | 18 |
zipcode => { type => 'varchar', length => 10 },
|
| 19 | 19 |
city => { type => 'varchar', length => 75 },
|
| 20 | 20 |
country => { type => 'varchar', length => 75 },
|
| 21 |
contact => { type => 'varchar', length => 75 },
|
|
| 21 |
contact => { type => 'text' },
|
|
| 22 | 22 |
phone => { type => 'varchar', length => 30 },
|
| 23 | 23 |
fax => { type => 'varchar', length => 30 },
|
| 24 | 24 |
homepage => { type => 'text' },
|
| ... | ... | |
| 33 | 33 |
bcc => { type => 'text' },
|
| 34 | 34 |
business_id => { type => 'integer' },
|
| 35 | 35 |
taxnumber => { type => 'text' },
|
| 36 |
account_number => { type => 'varchar', length => 15 },
|
|
| 37 |
bank_code => { type => 'varchar', length => 10 },
|
|
| 36 |
account_number => { type => 'text' },
|
|
| 37 |
bank_code => { type => 'text' },
|
|
| 38 | 38 |
bank => { type => 'text' },
|
| 39 | 39 |
language => { type => 'varchar', length => 5 },
|
| 40 | 40 |
datevexport => { type => 'integer' },
|
| ... | ... | |
| 50 | 50 |
payment_id => { type => 'integer' },
|
| 51 | 51 |
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
|
| 52 | 52 |
greeting => { type => 'text' },
|
| 53 |
ustid => { type => 'varchar', length => 14 },
|
|
| 54 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 53 |
ustid => { type => 'text' },
|
|
| 55 | 54 |
iban => { type => 'varchar', length => 100 },
|
| 56 | 55 |
bic => { type => 'varchar', length => 100 },
|
| 56 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 57 | 57 |
], |
| 58 | 58 |
|
| 59 | 59 |
primary_key_columns => [ 'id' ], |
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 17 | 17 |
fxloss_accno_id => { type => 'integer' },
|
| 18 | 18 |
invnumber => { type => 'text' },
|
| 19 | 19 |
sonumber => { type => 'text' },
|
| 20 |
yearend => { type => 'varchar', length => 5 },
|
|
| 21 | 20 |
weightunit => { type => 'varchar', length => 5 },
|
| 22 | 21 |
businessnumber => { type => 'text' },
|
| 23 | 22 |
version => { type => 'varchar', length => 8 },
|
| ... | ... | |
| 42 | 41 |
dunning_ar => { type => 'integer' },
|
| 43 | 42 |
pdonumber => { type => 'text' },
|
| 44 | 43 |
sdonumber => { type => 'text' },
|
| 44 |
ar_paid_accno_id => { type => 'integer' },
|
|
| 45 | 45 |
id => { type => 'serial', not_null => 1 },
|
| 46 | 46 |
], |
| 47 | 47 |
|
| SL/DB/MetaSetup/MakeModel.pm | ||
|---|---|---|
| 10 | 10 |
table => 'makemodel', |
| 11 | 11 |
|
| 12 | 12 |
columns => [ |
| 13 |
parts_id => { type => 'integer' },
|
|
| 14 |
model => { type => 'text' },
|
|
| 15 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 16 |
mtime => { type => 'timestamp' },
|
|
| 17 |
make => { type => 'integer' },
|
|
| 18 |
id => { type => 'serial', not_null => 1 },
|
|
| 13 |
parts_id => { type => 'integer' },
|
|
| 14 |
model => { type => 'text' },
|
|
| 15 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 16 |
mtime => { type => 'timestamp' },
|
|
| 17 |
lastcost => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 18 |
lastupdate => { type => 'date' },
|
|
| 19 |
sortorder => { type => 'integer' },
|
|
| 20 |
make => { type => 'integer' },
|
|
| 21 |
id => { type => 'serial', not_null => 1 },
|
|
| 19 | 22 |
], |
| 20 | 23 |
|
| 21 | 24 |
primary_key_columns => [ 'id' ], |
| SL/DB/MetaSetup/SepaExport.pm | ||
|---|---|---|
| 15 | 15 |
executed => { type => 'boolean', default => 'false' },
|
| 16 | 16 |
closed => { type => 'boolean', default => 'false' },
|
| 17 | 17 |
itime => { type => 'timestamp', default => 'now()' },
|
| 18 |
vc => { type => 'varchar', length => 10 },
|
|
| 18 | 19 |
], |
| 19 | 20 |
|
| 20 | 21 |
primary_key_columns => [ 'id' ], |
| SL/DB/MetaSetup/SepaExportItem.pm | ||
|---|---|---|
| 12 | 12 |
columns => [ |
| 13 | 13 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 14 | 14 |
sepa_export_id => { type => 'integer', not_null => 1 },
|
| 15 |
ap_id => { type => 'integer', not_null => 1 },
|
|
| 15 |
ap_id => { type => 'integer' },
|
|
| 16 | 16 |
chart_id => { type => 'integer', not_null => 1 },
|
| 17 | 17 |
amount => { type => 'numeric', precision => 5, scale => 25 },
|
| 18 | 18 |
reference => { type => 'varchar', length => 35 },
|
| ... | ... | |
| 21 | 21 |
execution_date => { type => 'date' },
|
| 22 | 22 |
our_iban => { type => 'varchar', length => 100 },
|
| 23 | 23 |
our_bic => { type => 'varchar', length => 100 },
|
| 24 |
vendor_iban => { type => 'varchar', length => 100 },
|
|
| 25 |
vendor_bic => { type => 'varchar', length => 100 },
|
|
| 24 |
vc_iban => { type => 'varchar', length => 100 },
|
|
| 25 |
vc_bic => { type => 'varchar', length => 100 },
|
|
| 26 | 26 |
end_to_end_id => { type => 'varchar', length => 35 },
|
| 27 |
ar_id => { type => 'integer' },
|
|
| 27 | 28 |
], |
| 28 | 29 |
|
| 29 | 30 |
primary_key_columns => [ 'id' ], |
| ... | ... | |
| 34 | 35 |
key_columns => { ap_id => 'id' },
|
| 35 | 36 |
}, |
| 36 | 37 |
|
| 38 |
ar => {
|
|
| 39 |
class => 'SL::DB::Invoice', |
|
| 40 |
key_columns => { ar_id => 'id' },
|
|
| 41 |
}, |
|
| 42 |
|
|
| 37 | 43 |
chart => {
|
| 38 | 44 |
class => 'SL::DB::Chart', |
| 39 | 45 |
key_columns => { chart_id => 'id' },
|
| SL/DB/MetaSetup/Shipto.pm | ||
|---|---|---|
| 26 | 26 |
mtime => { type => 'timestamp' },
|
| 27 | 27 |
module => { type => 'text' },
|
| 28 | 28 |
shipto_id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 29 |
shiptocp_gender => { type => 'text' },
|
|
| 29 | 30 |
], |
| 30 | 31 |
|
| 31 | 32 |
primary_key_columns => [ 'shipto_id' ], |
Auch abrufbar als: Unified diff
Aktualisierung der RDBO-Models anhand des aktuellen Datebankschemas