projekt kivitendo

use SL::DB::PartLabelPrint;

  part_label_prints              => 'PartLabelPrint',

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Manager::PartLabelPrint;

use strict;

use parent qw(SL::DB::Helper::Manager);

sub object_class { 'SL::DB::PartLabelPrint' }

__PACKAGE__->make_manager_methods;

1;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::PartLabelPrint;

use strict;

use parent qw(SL::DB::Object);

__PACKAGE__->meta->table('part_label_prints');

__PACKAGE__->meta->columns(

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

  print_type       => { type => 'enum', check_in => [ 'single', 'stock' ], db_type => 'part_label_print_types', not_null => 1 },

  template         => { type => 'text', not_null => 1 },

);

__PACKAGE__->meta->primary_key_columns([ 'price_history_id', 'print_type', 'template' ]);

__PACKAGE__->meta->foreign_keys(

  price_history => {

    class       => 'SL::DB::PartsPriceHistory',

    key_columns => { price_history_id => 'id' },

  },

);

1;

;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::PartLabelPrint;

use strict;

use SL::DB::MetaSetup::PartLabelPrint;

use SL::DB::Manager::PartLabelPrint;

__PACKAGE__->meta->initialize;

1;

__PACKAGE__->meta->add_relationships(

  part_label_prints => {

    type         => 'many to one',

    class        => 'SL::DB::PartLabelPrint',

    column_map   => { id => 'price_history_id' },

  },

);

-- @tag: create_part_label_prints

-- @description: Tabelle für automatischen Edikettendruck

-- @depends: release_3_9_1

CREATE TYPE part_label_print_types AS ENUM (

  'single',

  'stock'

);

CREATE TABLE part_label_prints (

  price_history_id INTEGER REFERENCES parts_price_history(id) NOT NULL,

  print_type       part_label_print_types                     NOT NULL,

  template         TEXT                                       NOT NULL,

  PRIMARY KEY (price_history_id, print_type, template)

);