projekt kivitendo

  customer_id          => { type => 'integer', not_null => 1 },

  customer_partnumber  => { type => 'text', default => '' },

  id                   => { type => 'serial', not_null => 1 },

  lastupdate           => { type => 'date', default => 'now()' },

  part_description     => { type => 'text' },

  part_longdescription => { type => 'text' },

  parts_id             => { type => 'integer', not_null => 1 },

  price                => { type => 'numeric', default => '0', precision => 15, scale => 5 },

  sortorder            => { type => 'integer', default => '0' },

-- @tag: part_customer_prices_add_description

-- @description: Kundenspezifischen Preisen Beschreibung und Bemerkungen/Langtext hinzufügen

-- @depends: create_part_customerprices

ALTER TABLE part_customer_prices ADD COLUMN part_description     TEXT;

ALTER TABLE part_customer_prices ADD COLUMN part_longdescription TEXT;