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

use strict;

use SL::DB::MetaSetup::BackgroundJob;

# 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 only because it didn't exist.

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

package SL::DB::BackgroundJobHistory;

use strict;

use SL::DB::MetaSetup::BackgroundJobHistory;

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

__PACKAGE__->meta->make_manager_class;

1;

use SL::DB::BackgroundJob;

use SL::DB::BackgroundJobHistory;

  background_jobs                => 'background_job',

  background_job_histories       => 'background_job_history',

  ap                             => 'purchase_invoice',

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

# by rose_auto_create_model.pl automatically.

package SL::DB::BackgroundJob;

use strict;

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

__PACKAGE__->meta->setup(

  table   => 'background_jobs',

  columns => [

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

    type         => { type => 'varchar', length => 255 },

    package_name => { type => 'varchar', length => 255 },

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

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

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

    active       => { type => 'boolean' },

    cron_spec    => { type => 'varchar', length => 255 },

  ],

  primary_key_columns => [ 'id' ],

);

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

use strict;

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

__PACKAGE__->meta->setup(

  table   => 'background_job_histories',

  columns => [

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

    package_name => { type => 'varchar', length => 255 },

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

    status       => { type => 'varchar', length => 255 },

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

    error        => { type => 'text', alias => 'error_col' },

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

  ],

  primary_key_columns => [ 'id' ],

);

1;

;

-- @tag: emmvee_background_jobs

-- @description: Tabellen für Hintergrundjobs

-- @depends: release_2_6_1

-- @charset: utf-8

CREATE TABLE background_jobs (

    id serial NOT NULL,

    type character varying(255),

    package_name character varying(255),

    last_run_at timestamp without time zone,

    next_run_at timestamp without time zone,

    data text,

    active boolean,

    cron_spec character varying(255),

    PRIMARY KEY (id)

);

CREATE TABLE background_job_histories (

    id serial NOT NULL,

    package_name character varying(255),

    run_at timestamp without time zone,

    status character varying(255),

    result text,

    error text,

    data text,

    PRIMARY KEY (id)

);