projekt kivitendo

use SL::DB::Lead;

# these will not be managed as Rose::DB models, because they are not normalized

# significant changes are needed to get them done.

  leads                          => 'lead',

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

use strict;

use SL::DB::MetaSetup::Lead;

# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.

__PACKAGE__->meta->make_manager_class;

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::Lead;

use strict;

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

__PACKAGE__->meta->setup(

  table   => 'leads',

  columns => [

    id   => { type => 'integer', not_null => 1, sequence => 'id' },

    lead => { type => 'varchar', length => 50 },

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

-- @tag: schema_normalization_2

-- @description: Datenbankschema Normalisierungen Teil 2

-- @depends: schema_normalization_1

ALTER TABLE acc_trans ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE audittrail ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE customertax ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE datev ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE defaults ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE department ADD PRIMARY KEY (id);

ALTER TABLE dpt_trans ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE exchangerate ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE finanzamt ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE follow_up_access ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE gifi ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE inventory ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE licenseinvoice ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE leads ADD PRIMARY KEY (id);

ALTER TABLE partsgroup ADD PRIMARY KEY (id);

ALTER TABLE partstax ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE prices ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE record_links ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE rmaitems ADD PRIMARY KEY (id);

ALTER TABLE status ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE tax_zones ADD PRIMARY KEY (id);

ALTER TABLE todo_user_config ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE translation ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE translation_payment_terms ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE units_language ADD COLUMN id SERIAL PRIMARY KEY;

ALTER TABLE vendortax ADD COLUMN id SERIAL PRIMARY KEY;