package LinuxRulz::Schema::Result::Job;

use utf8;
use strict;
use warnings;
use Carp;
use base 'DBIx::Class';

__PACKAGE__->load_components(qw/ForceUTF8 TimeStamp InflateColumn::Serializer InflateColumn::DateTime Core/);
__PACKAGE__->table("job");
__PACKAGE__->add_columns(
	"id",
	{ 
		data_type => "INT", 
		default_value => undef, 
		is_nullable => 0, 
		size => 11, 
		is_auto_increment => 1
	},
	"status",
	{
		data_type => "INT",
		default_value => 0,
		is_nullable => 1,
		size => 1,
	},
	"method",
	{
		data_type => "VARCHAR",
		default_value => undef,
		is_nullable => 0,
		size => 255,
	},
	"destination",
	{
		data_type => "VARCHAR",
		default_value => undef,
		is_nullable => 0,
		size => 255,
	},
	"owner",
	{
		data_type => "VARCHAR",
		default_value => undef,
		is_nullable => 0,
		size => 255,
	},
	"arg" => {
		data_type => "bytea",
		default_value => "{}",
		is_nullable => 0,
		size => 255,
		serializer_class => 'JSON',
	},
	"uniqkey",
        {
                data_type => "VARCHAR",
                default_value => undef,
                is_nullable => 0,
                size => 255,
        },
	"created_on",
	{
		data_type => 'timestamp with time zone',
		default_value => undef,
		is_nullable => 0,
		timezone => "Europe/Berlin",
		locale => "de_DE",
		set_on_create => 1,
		set_on_update => 0,
		renamed_from  => "insert",
	},
	"finish",
	{
		data_type => 'timestamp with time zone',
		default_value => undef,
		is_nullable => 1,
		timezone => "Europe/Berlin",
		locale => "de_DE",
		set_on_create => 0,
		set_on_update => 0,
	},
	"return" => {
                data_type => "bytea",
                default_value => undef,
                is_nullable => 1,
                size => 255,
		serializer_class => 'JSON'
        },

);

__PACKAGE__->add_unique_constraint("job_method_uniqkey", ["method","uniqkey"]);
__PACKAGE__->set_primary_key("id");

1;