Revision 5bfe4005
Von Jan Büren vor etwa 3 Jahren hinzugefügt
| SL/DB/MetaSetup/Shop.pm | ||
|---|---|---|
|
__PACKAGE__->meta->table('shops');
|
||
|
|
||
|
__PACKAGE__->meta->columns(
|
||
|
connector => { type => 'text' },
|
||
|
description => { type => 'text' },
|
||
|
id => { type => 'serial', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
last_order_number => { type => 'integer' },
|
||
|
login => { type => 'text' },
|
||
|
mtime => { type => 'timestamp', default => 'now()' },
|
||
|
obsolete => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
orders_to_fetch => { type => 'integer' },
|
||
|
password => { type => 'text' },
|
||
|
path => { type => 'text', default => '/', not_null => 1 },
|
||
|
port => { type => 'integer' },
|
||
|
price_source => { type => 'text' },
|
||
|
pricetype => { type => 'text' },
|
||
|
protocol => { type => 'text', default => 'http', not_null => 1 },
|
||
|
realm => { type => 'text' },
|
||
|
server => { type => 'text' },
|
||
|
shipping_costs_parts_id => { type => 'integer' },
|
||
|
sortkey => { type => 'integer' },
|
||
|
taxzone_id => { type => 'integer' },
|
||
|
transaction_description => { type => 'text' },
|
||
|
connector => { type => 'text' },
|
||
|
description => { type => 'text' },
|
||
|
id => { type => 'serial', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
last_order_number => { type => 'integer' },
|
||
|
login => { type => 'text' },
|
||
|
mtime => { type => 'timestamp', default => 'now()' },
|
||
|
obsolete => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
orders_to_fetch => { type => 'integer' },
|
||
|
password => { type => 'text' },
|
||
|
path => { type => 'text', default => '/', not_null => 1 },
|
||
|
port => { type => 'integer' },
|
||
|
price_source => { type => 'text' },
|
||
|
pricetype => { type => 'text' },
|
||
|
protocol => { type => 'text', default => 'http', not_null => 1 },
|
||
|
realm => { type => 'text' },
|
||
|
server => { type => 'text' },
|
||
|
shipping_costs_parts_id => { type => 'integer' },
|
||
|
sortkey => { type => 'integer' },
|
||
|
taxzone_id => { type => 'integer' },
|
||
|
transaction_description => { type => 'text' },
|
||
|
use_part_longdescription => { type => 'boolean', default => 'false' },
|
||
|
);
|
||
|
|
||
|
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
||
| sql/Pg-upgrade2/shops_5.sql | ||
|---|---|---|
|
-- @tag: shops_5
|
||
|
-- @description: Shop-Config um Option zur direkten Beschreibungsübernahme erweitern
|
||
|
-- @depends: shop_4
|
||
|
-- @ignore: 0
|
||
|
|
||
|
ALTER TABLE shops ADD COLUMN use_part_longdescription BOOLEAN default false;
|
||
Auch abrufbar als: Unified diff
Neues Feld Übernahme Beschreibung/Langtext aus Stammdaten