View | Details | Raw Unified | Return to bug 11297
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl (+9 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    if( !column_exists( 'z3950servers', 'attributes' ) ) {
4 
        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
5 
    }
6 

            

            

              7
              
    SetVersion( $DBversion );

            

            

              8
              
    print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";

            

            

              9
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +1 lines)




  

    
      
            Lines 2204-2209
          CREATE TABLE `z3950servers` ( -- connection information for the Z39.50 targets u
      
      
        Link Here
      
    
  

        

          2204
          
  `sru_options` varchar(255) default NULL, -- options like sru=get, sru_version=1.1; will be passed to the server via ZOOM

          2204
          
  `sru_options` varchar(255) default NULL, -- options like sru=get, sru_version=1.1; will be passed to the server via ZOOM

        

        

          2205
          
  `sru_fields` LONGTEXT default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes

          2205
          
  `sru_fields` LONGTEXT default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes

        

        

          2206
          
  `add_xslt` LONGTEXT default NULL, -- zero or more paths to XSLT files to be processed on the search results

          2206
          
  `add_xslt` LONGTEXT default NULL, -- zero or more paths to XSLT files to be processed on the search results

        

            

              
              
              2207
              
  `attributes` VARCHAR(255) default NULL, -- additional attributes passed to PQF queries

            

        

          2207
          
  PRIMARY KEY  (`id`)

          2208
          
  PRIMARY KEY  (`id`)

        

        

          2208
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

          2209
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        

        

          2209
          

          2210
          

        

            

              2210
              
- 

              
              
            






  

  Return to bug 11297