| Lines 328-335
          CREATE TABLE `categories` ( -- this table shows information related to Koha patr
      
      
        Link Here | 
        
          | 328 |   `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no) | 328 |   `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no) | 
        
          | 329 |   `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) | 329 |   `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) | 
        
          | 330 |   `BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-1', -- wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions | 330 |   `BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-1', -- wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions | 
          
            
              | 331 |   `default_privacy` ENUM( 'default', 'never', 'forever' ) NOT NULL DEFAULT 'default', -- Default privacy setting for this patron category | 331 |   `default_privacy` ENUM( 'default', 'never', 'forever' ) NOT NULL DEFAULT 'default', -- Default privacy setting for this patron category, | 
        
          | 332 |   `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'. | 332 |   `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'. | 
            
              |  |  | 333 |   `canbeguarantee` tinyint(1) NOT NULL default '0' | 
        
          | 333 |   PRIMARY KEY  (`categorycode`), | 334 |   PRIMARY KEY  (`categorycode`), | 
        
          | 334 |   UNIQUE KEY `categorycode` (`categorycode`) | 335 |   UNIQUE KEY `categorycode` (`categorycode`) | 
        
          | 335 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 336 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 
  
    | Lines 898-904
          CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale
      
      
        Link Here | 
        
          | 898 | -- | 899 | -- | 
        
          | 899 |  | 900 |  | 
        
          | 900 | DROP TABLE IF EXISTS `items`; | 901 | DROP TABLE IF EXISTS `items`; | 
          
            
              | 901 | CREATE TABLE `items` ( -- holdings/item information  | 902 | CREATE TABLE `items` ( -- holdings/item information | 
        
          | 902 |   `itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha | 903 |   `itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha | 
        
          | 903 |   `biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record | 904 |   `biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record | 
        
          | 904 |   `biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information | 905 |   `biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information | 
  
    | Lines 2239-2245
          CREATE TABLE `userflags` (
      
      
        Link Here | 
        
          | 2239 | -- | 2240 | -- | 
        
          | 2240 |  | 2241 |  | 
        
          | 2241 | DROP TABLE IF EXISTS `virtualshelves`; | 2242 | DROP TABLE IF EXISTS `virtualshelves`; | 
          
            
              | 2242 | CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)  | 2243 | CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) | 
        
          | 2243 |   `shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 2244 |   `shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 
        
          | 2244 |   `shelfname` varchar(255) default NULL, -- name of the list | 2245 |   `shelfname` varchar(255) default NULL, -- name of the list | 
        
          | 2245 |   `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) | 2246 |   `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |