Revision 5449329c
Von Werner Hahn vor mehr als 6 Jahren hinzugefügt
| sql/Pg-upgrade2/shop_parts.sql | ||
|---|---|---|
| 16 | 16 |
sortorder INTEGER, |
| 17 | 17 |
front_page BOOLEAN NOT NULL DEFAULT false, |
| 18 | 18 |
active BOOLEAN NOT NULL DEFAULT false, -- rather than obsolete |
| 19 |
shop_category TYPE TEXT[] USING array[shop_category;
|
|
| 19 |
shop_category TEXT[][],
|
|
| 20 | 20 |
active_price_source TEXT, |
| 21 | 21 |
metatag_keywords TEXT, |
| 22 |
metatag_keywords TEXT,
|
|
| 22 |
metatag_description TEXT,
|
|
| 23 | 23 |
metatag_title TEXT, |
| 24 | 24 |
UNIQUE (part_id, shop_id) -- make sure a shop_part appears only once per shop and part |
| 25 | 25 |
); |
Auch abrufbar als: Unified diff
Shopmodul: sql-Updatesfiles Fehlerbehebung