projekt kivitendo

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

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

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

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

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

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

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

  obsolete                 => { type => 'boolean', default => 'false', not_null => 1 },

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

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

  path                     => { type => 'text', default => '/', not_null => 1 },

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

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

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

  protocol                 => { type => 'text', default => 'http', not_null => 1 },

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

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

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

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

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

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

  use_part_longdescription => { type => 'boolean', default => 'false' },

-- @tag: shops_5

-- @description: Shop-Config um Option zur direkten Beschreibungsübernahme erweitern

-- @depends: shop_4

-- @ignore: 0

ALTER TABLE shops ADD COLUMN use_part_longdescription BOOLEAN default false;