Revision fed28e9e
Von Werner Hahn vor mehr als 6 Jahren hinzugefügt
| sql/Pg-upgrade2/shop_parts.sql | ||
|---|---|---|
| 1 | 1 |
-- @tag: shop_parts |
| 2 | 2 |
-- @description: Add tables for part information for shop |
| 3 | 3 |
-- @charset: UTF-8 |
| 4 |
-- @depends: release_3_3_0 shops
|
|
| 4 |
-- @depends: release_3_4_1 shops
|
|
| 5 | 5 |
-- @ignore: 0 |
| 6 | 6 |
|
| 7 | 7 |
CREATE TABLE shop_parts ( |
| ... | ... | |
| 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 TEXT, |
|
| 20 |
meta_tags TEXT, |
|
| 19 |
shop_category TYPE TEXT[] USING array[shop_category; |
|
| 20 |
active_price_source TEXT, |
|
| 21 |
metatag_keywords TEXT, |
|
| 22 |
metatag_keywords TEXT, |
|
| 23 |
metatag_title TEXT, |
|
| 21 | 24 |
UNIQUE (part_id, shop_id) -- make sure a shop_part appears only once per shop and part |
| 22 | 25 |
); |
| 23 | 26 |
|
| 24 | 27 |
CREATE TRIGGER mtime_shop_parts BEFORE UPDATE ON shop_parts |
| 25 | 28 |
FOR EACH ROW EXECUTE PROCEDURE set_mtime(); |
| 26 |
|
|
| 27 |
-- CREATE TABLE shop_meta_tags ( |
|
| 28 |
-- id integer NOT NULL DEFAULT nextval('shop_parts_id'),
|
|
| 29 |
-- description |
|
| 30 |
-- ); |
|
| 31 |
|
|
| 32 |
-- CREATE TABLE shop_categories ( |
|
| 33 |
-- ); |
|
Auch abrufbar als: Unified diff
Shopmodul: sql-Updatesfiles für das Shopmodul.
Beinhaltet auch ein hinzufügen der Spalte Auftragssperre in der Tabelle customer sowie das webtemplate billing beim Kunden wo die Auftragssperre eingegeben werden kann