Revision 1fc583c0
Von Kivitendo Admin vor fast 9 Jahren hinzugefügt
| SL/DB/MetaSetup/ShopPart.pm | ||
|---|---|---|
|
id => { type => 'serial', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
last_update => { type => 'timestamp' },
|
||
|
meta_tags => { type => 'text' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
part_id => { type => 'integer' },
|
||
|
part_id => { type => 'integer', not_null => 1 },
|
||
|
shop_category => { type => 'text' },
|
||
|
shop_description => { type => 'text' },
|
||
|
shop_id => { type => 'integer' },
|
||
|
shop_id => { type => 'integer', not_null => 1 },
|
||
|
show_date => { type => 'date' },
|
||
|
sortorder => { type => 'integer' },
|
||
|
);
|
||
| sql/Pg-upgrade2/shop_parts.sql | ||
|---|---|---|
|
|
||
|
CREATE TABLE shop_parts (
|
||
|
id SERIAL PRIMARY KEY,
|
||
|
shop_id INTEGER REFERENCES shops(id),
|
||
|
part_id INTEGER REFERENCES parts(id),
|
||
|
shop_id INTEGER NOT NULL REFERENCES shops(id),
|
||
|
part_id INTEGER NOT NULL REFERENCES parts(id),
|
||
|
shop_description TEXT,
|
||
|
itime TIMESTAMP DEFAULT now(),
|
||
|
mtime TIMESTAMP,
|
||
| ... | ... | |
|
front_page BOOLEAN NOT NULL DEFAULT false,
|
||
|
active BOOLEAN NOT NULL DEFAULT false, -- rather than obsolete
|
||
|
shop_category TEXT,
|
||
|
meta_tags TEXT,
|
||
|
UNIQUE (part_id, shop_id) -- make sure a shop_part appears only once per shop and part
|
||
|
);
|
||
|
|
||
Auch abrufbar als: Unified diff
ShopPart - part_id und shop_id NOT NULL, metatags