projekt kivitendo

# 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::ContactTitle;

use strict;

use SL::DB::MetaSetup::ContactTitle;

use SL::DB::Manager::ContactTitle;

__PACKAGE__->meta->initialize;

1;

use SL::DB::ContactTitle;

  contact_titles                 => 'contact_title',

# 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::ContactTitle;

use strict;

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

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

__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::ContactTitle;

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->unique_keys([ 'description' ]);

1;

;

-- @tag: contact_titles_own_table

-- @description: Eigene Tabelle für Titel bei Ansprechpersonen

-- @depends: release_3_5_5

CREATE TABLE contact_titles (

  id          SERIAL,

  description TEXT      NOT NULL,

  PRIMARY KEY (id),

  UNIQUE (description)

);

UPDATE contacts SET cp_title = trim(cp_title) WHERE cp_title NOT LIKE trim(cp_title);

INSERT INTO contact_titles (description)

  SELECT DISTINCT cp_title FROM contacts WHERE cp_title IS NOT NULL AND cp_title NOT LIKE '' ORDER BY cp_title;