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

use strict;

use SL::DB::MetaSetup::FileFullText;

use SL::DB::Manager::FileFullText;

__PACKAGE__->meta->initialize;

1;

use SL::DB::FileFullText;

  file_full_texts                => 'file_full_text',

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

use strict;

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

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

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

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

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

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

);

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

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  file => {

    class       => 'SL::DB::File',

    key_columns => { file_id => 'id' },

  },

);

1;

;

-- @tag: file_full_texts

-- @description: Tabelle f. Volltext-Suche anlegen

-- @depends: release_3_6_0

CREATE TABLE IF NOT EXISTS file_full_texts (

   id           SERIAL,

   file_id      INTEGER            NOT NULL REFERENCES files(id) ON DELETE CASCADE,

   full_text    TEXT               NOT NULL,

   itime        TIMESTAMP          NOT NULL DEFAULT now(),

   mtime        TIMESTAMP,

   PRIMARY KEY (id)

);

CREATE TRIGGER mtime_file_full_texts BEFORE UPDATE ON file_full_texts FOR EACH ROW EXECUTE PROCEDURE set_mtime();