1 -- @tag: assortment_items
2 -- @description: Sortimentsartikel eingeführt
3 -- @depends: release_3_4_1 part_type_enum
5 -- adding a new value isn't allowed inside a transaction, which is what DBUpgrade automatically does
6 -- run this afterwards manually for now
7 -- ALTER TYPE part_type_enum ADD VALUE 'assortment';
9 CREATE TABLE assortment_items (
10 assortment_id INTEGER REFERENCES parts(id) ON DELETE CASCADE, -- the part id of the assortment
11 parts_id INTEGER REFERENCES parts(id),
12 itime timestamp without time zone default now(),
13 mtime timestamp without time zone,
15 position INTEGER NOT NULL,
16 unit character varying(20) NOT NULL REFERENCES units(name),
17 CONSTRAINT assortment_part_pkey PRIMARY KEY (assortment_id, parts_id)
20 ALTER TABLE defaults ADD assortmentnumber TEXT;