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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 99-106 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
99 
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
 99 
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
100 
  `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category
 100 
  `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category
101 
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
 101 
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
102 
  `lib` varchar(80) default NULL, -- authorized value description as printed in the staff client
 102 
  `lib` varchar(200) default NULL, -- authorized value description as printed in the staff client
103 
  `lib_opac` VARCHAR(80) default NULL, -- authorized value description as printed in the OPAC
 103 
  `lib_opac` varchar(200) default NULL, -- authorized value description as printed in the OPAC
104 
  `imageurl` varchar(200) default NULL, -- authorized value URL
 104 
  `imageurl` varchar(200) default NULL, -- authorized value URL
105 
  PRIMARY KEY  (`id`),
 105 
  PRIMARY KEY  (`id`),
106 
  KEY `name` (`category`),
 106 
  KEY `name` (`category`),
(-)a/installer/data/mysql/updatedatabase.pl (+9 lines)
Lines 5696-5701 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
5696 
    SetVersion($DBversion);
 5696 
    SetVersion($DBversion);
5697 
}
 5697 
}
5698 

          5698
          

        

            

              
              
              5699
              
$DBversion = "3.09.00.XXX";

            

            

              5700
              
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {

            

            

              5701
              
    $dbh->do("ALTER TABLE authorised_values MODIFY lib varchar(200)");

            

            

              5702
              
    $dbh->do("ALTER TABLE authorised_values MODIFY lib_opac varchar(200)");

            

            

              5703
              

            

            

              5704
              
    print "Upgrade to $DBversion done (Raise the length of Authorised Values descriptions)\n";

            

            

              5705
              
    SetVersion($DBversion);

            

            

              5706
              
}

            

            

              5707
              

            

        

          5699
          
=head1 FUNCTIONS

          5708
          
=head1 FUNCTIONS

        

        

          5700
          

          5709
          

        

        

          5701
          
=head2 TableExists($table)

          5710
          
=head2 TableExists($table)

        



(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt
      (-3 / +2 lines)




  

    
      
            Lines 72-82
          
      
      
        Link Here
      
    
  

        

          72
          
        </li>

          72
          
        </li>

        

        

          73
          
        <li>

          73
          
        <li>

        

        

          74
          
            <label for="lib">Description</label>

          74
          
            <label for="lib">Description</label>

        

          
            

              75
              
            <input type="text" name="lib" id="lib" value="[% lib %]" maxlength="80" />


              75
              
            <input type="text" name="lib" id="lib" value="[% lib %]" maxlength="200" />

            

        

          76
          
        </li>

          76
          
        </li>

        

        

          77
          
	<li>

          77
          
	<li>

        

        

          78
          
            <label for="lib_opac">Description (OPAC)</label>

          78
          
            <label for="lib_opac">Description (OPAC)</label>

        

          
            

              79
              
            <input type="text" name="lib_opac" id="lib_opac" value="[% lib_opac %]" maxlength="80" />


              79
              
            <input type="text" name="lib_opac" id="lib_opac" value="[% lib_opac %]" maxlength="200" />

            

        

          80
          
        </li>

          80
          
        </li>

        

        

          81
          
		</ol>

          81
          
		</ol>

        

        

          82
          
        <div id="icons" class="toptabs" style="clear:both">

          82
          
        <div id="icons" class="toptabs" style="clear:both">

        

            

              83
              
- 

              
              
            






  

  Return to bug 8757