Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 754ef842

Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt

  • ID 754ef842e3bd40305cacb6e50420acfc3a2b381e
  • Vorgänger 30a815e3
  • Nachfolger 0631649c

Files: Druckvariante abspeichern können: sql und rose

Unterschiede anzeigen:

SL/DB/MetaSetup/File.pm
9 9 
__PACKAGE__->meta->table('files');
10 10 

  		




  11
  11
  
    
__PACKAGE__->meta->columns(


  		




  12
  
  
    
  backend      => { type => 'text' },


  		




  13
  
  
    
  backend_data => { type => 'text' },


  		




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


  		




  15
  
  
    
  file_name    => { type => 'text', not_null => 1 },


  		




  16
  
  
    
  file_type    => { type => 'text', not_null => 1 },


  		




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


  		




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


  		




  19
  
  
    
  mime_type    => { type => 'text', not_null => 1 },


  		




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


  		




  21
  
  
    
  object_id    => { type => 'integer', not_null => 1 },


  		




  22
  
  
    
  object_type  => { type => 'text', not_null => 1 },


  		




  23
  
  
    
  source       => { type => 'text', not_null => 1 },


  		




  24
  
  
    
  title        => { type => 'varchar', length => 45 },


  		




  
  12
  
    
  backend       => { type => 'text' },


  		




  
  13
  
    
  backend_data  => { type => 'text' },


  		




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


  		




  
  15
  
    
  file_name     => { type => 'text', not_null => 1 },


  		




  
  16
  
    
  file_type     => { type => 'text', not_null => 1 },


  		




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


  		




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


  		




  
  19
  
    
  mime_type     => { type => 'text', not_null => 1 },


  		




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


  		




  
  21
  
    
  object_id     => { type => 'integer', not_null => 1 },


  		




  
  22
  
    
  object_type   => { type => 'text', not_null => 1 },


  		




  
  23
  
    
  print_variant => { type => 'text' },


  		




  
  24
  
    
  source        => { type => 'text', not_null => 1 },


  		




  
  25
  
    
  title         => { type => 'varchar', length => 45 },


  		




  25
  26
  
    
);


  		




  26
  27
  
    

  		




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


  		












  

    
      sql/Pg-upgrade2/files_add_variant.sql
    
  





  
  1
  
    
-- @tag: files_add_variant


  		




  
  2
  
    
-- @description: Varianten für DMS System


  		




  
  3
  
    
-- @depends: release_3_5_8


  		




  
  4
  
    

  		




  
  5
  
    
ALTER TABLE files ADD COLUMN print_variant text;


  		












Auch abrufbar als:  Unified diff