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' ], |
Auch abrufbar als: Unified diff
Aktualisierung der RDBO-Models anhand des aktuellen Datebankschemas