projekt kivitendo

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

  itime            => { type => 'timestamp', default => 'now()' },

  lastcost         => { type => 'numeric', precision => 15, scale => 5 },

  lastupdate       => { type => 'date' },

  make             => { type => 'integer' },

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

  mtime            => { type => 'timestamp' },

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

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

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

-- @tag: makemodel_add_part_description

-- @description: Artikelbezeichnung zu jedem Lieferanten speichern können

-- @depends: release_3_7_0

ALTER TABLE makemodel ADD COLUMN part_description TEXT;