projekt kivitendo

use SL::DB::OrderStatus;

  order_statuses                 => 'order_status',

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

use strict;

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

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

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

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

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

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

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

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

);

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

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

__PACKAGE__->meta->allow_inline_column_values(1);

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

use strict;

use SL::DB::MetaSetup::OrderStatus;

use SL::DB::Manager::OrderStatus;

__PACKAGE__->meta->initialize;

1;

-- @tag: order_statuses

-- @description: Status für Angebote und Aufträge

-- @depends: release_3_6_1

-- table

CREATE TABLE order_statuses (

       id            SERIAL         NOT NULL PRIMARY KEY,

       name          TEXT           UNIQUE NOT NULL,

       description   TEXT,

       position      INTEGER        NOT NULL,

       obsolete      BOOLEAN        NOT NULL DEFAULT FALSE,

       itime         TIMESTAMP      DEFAULT now(),

       mtime         TIMESTAMP

);

CREATE TRIGGER mtime_order_statuses

    BEFORE UPDATE ON order_statuses

    FOR EACH ROW

    EXECUTE PROCEDURE set_mtime();

-- default entry

INSERT INTO order_statuses (name,         description,                           position)

                    VALUES ('bestätigt',  'Auftrag von Kunde bestätigt',         1);