| 
      
            Lines 201-206
          CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
      
      
        Link Here
      
     | 
  
        
          | 201 | 
            KEY `isbn` (`isbn`(255)),  | 
          201 | 
            KEY `isbn` (`isbn`(255)),  | 
        
        
          | 202 | 
            KEY `issn` (`issn`(255)),  | 
          202 | 
            KEY `issn` (`issn`(255)),  | 
        
        
          | 203 | 
            KEY `publishercode` (`publishercode`),  | 
          203 | 
            KEY `publishercode` (`publishercode`),  | 
        
            
               | 
               | 
              204 | 
                KEY `timestamp` (`timestamp`),  | 
            
        
          | 204 | 
            CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          205 | 
            CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 205 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          206 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 206 | 
           | 
          207 | 
           | 
        
  
    | 
      
            Lines 553-559
          CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
      
      
        Link Here
      
     | 
  
        
          | 553 | 
            KEY `bibnoidx` (`biblionumber`),  | 
          554 | 
            KEY `bibnoidx` (`biblionumber`),  | 
        
        
          | 554 | 
            KEY `itemtype_idx` (`itemtype`),  | 
          555 | 
            KEY `itemtype_idx` (`itemtype`),  | 
        
        
          | 555 | 
            KEY `isbn` (`isbn`(255)),  | 
          556 | 
            KEY `isbn` (`isbn`(255)),  | 
        
          
            
              | 556 | 
                KEY `publishercode` (`publishercode`)  | 
              557 | 
                KEY `publishercode` (`publishercode`),  | 
            
            
               | 
               | 
              558 | 
                KEY `timestamp` (`timestamp`)  | 
            
        
          | 557 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          559 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 558 | 
           | 
          560 | 
           | 
        
        
          | 559 | 
          --  | 
          561 | 
          --  | 
        
  
    | 
      
            Lines 694-700
          CREATE TABLE `deleteditems` (
      
      
        Link Here
      
     | 
  
        
          | 694 | 
            KEY `delitembibnoidx` (`biblionumber`),  | 
          696 | 
            KEY `delitembibnoidx` (`biblionumber`),  | 
        
        
          | 695 | 
            KEY `delhomebranch` (`homebranch`),  | 
          697 | 
            KEY `delhomebranch` (`homebranch`),  | 
        
        
          | 696 | 
            KEY `delholdingbranch` (`holdingbranch`),  | 
          698 | 
            KEY `delholdingbranch` (`holdingbranch`),  | 
        
          
            
              | 697 | 
                KEY `itype_idx` (`itype`)  | 
              699 | 
                KEY `itype_idx` (`itype`),  | 
            
            
               | 
               | 
              700 | 
                KEY `timestamp` (`timestamp`)  | 
            
        
          | 698 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          701 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 699 | 
           | 
          702 | 
           | 
        
        
          | 700 | 
          --  | 
          703 | 
          --  | 
        
  
    | 
      
            Lines 899-905
          CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale
      
      
        Link Here
      
     | 
  
        
          | 899 | 
          --  | 
          902 | 
          --  | 
        
        
          | 900 | 
           | 
          903 | 
           | 
        
        
          | 901 | 
          DROP TABLE IF EXISTS `items`;  | 
          904 | 
          DROP TABLE IF EXISTS `items`;  | 
        
          
            
              | 902 | 
              CREATE TABLE `items` ( -- holdings/item information   | 
              905 | 
              CREATE TABLE `items` ( -- holdings/item information  | 
            
        
          | 903 | 
            `itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha  | 
          906 | 
            `itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha  | 
        
        
          | 904 | 
            `biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record  | 
          907 | 
            `biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record  | 
        
        
          | 905 | 
            `biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information  | 
          908 | 
            `biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information  | 
        
  
    | 
      
            Lines 955-960
          CREATE TABLE `items` ( -- holdings/item information
      
      
        Link Here
      
     | 
  
        
          | 955 | 
            KEY `items_location` (`location`),  | 
          958 | 
            KEY `items_location` (`location`),  | 
        
        
          | 956 | 
            KEY `items_ccode` (`ccode`),  | 
          959 | 
            KEY `items_ccode` (`ccode`),  | 
        
        
          | 957 | 
            KEY `itype_idx` (`itype`),  | 
          960 | 
            KEY `itype_idx` (`itype`),  | 
        
            
               | 
               | 
              961 | 
                KEY `timestamp` (`timestamp`),  | 
            
        
          | 958 | 
            CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          962 | 
            CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 959 | 
            CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
          963 | 
            CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
        
        
          | 960 | 
            CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
          964 | 
            CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
        
  
    | 
      
            Lines 2236-2242
          CREATE TABLE `userflags` (
      
      
        Link Here
      
     | 
  
        
          | 2236 | 
          --  | 
          2240 | 
          --  | 
        
        
          | 2237 | 
           | 
          2241 | 
           | 
        
        
          | 2238 | 
          DROP TABLE IF EXISTS `virtualshelves`;  | 
          2242 | 
          DROP TABLE IF EXISTS `virtualshelves`;  | 
        
          
            
              | 2239 | 
              CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)   | 
              2243 | 
              CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)  | 
            
        
          | 2240 | 
            `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  | 
        
        
          | 2241 | 
            `shelfname` varchar(255) default NULL, -- name of the list  | 
          2245 | 
            `shelfname` varchar(255) default NULL, -- name of the list  | 
        
        
          | 2242 | 
            `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)  | 
        
  
    | 
      
            Lines 2431-2442
          CREATE TABLE `permissions` (
      
      
        Link Here
      
     | 
  
        
          | 2431 | 
           | 
          2435 | 
           | 
        
        
          | 2432 | 
          DROP TABLE IF EXISTS `serialitems`;  | 
          2436 | 
          DROP TABLE IF EXISTS `serialitems`;  | 
        
        
          | 2433 | 
          CREATE TABLE `serialitems` (  | 
          2437 | 
          CREATE TABLE `serialitems` (  | 
        
          
            
              | 2434 | 
              	`itemnumber` int(11) NOT NULL,  | 
              2438 | 
                `itemnumber` int(11) NOT NULL,  | 
            
            
              | 2435 | 
              	`serialid` int(11) NOT NULL,  | 
              2439 | 
                `serialid` int(11) NOT NULL,  | 
            
            
              | 2436 | 
              	UNIQUE KEY `serialitemsidx` (`itemnumber`),  | 
              2440 | 
                UNIQUE KEY `serialitemsidx` (`itemnumber`),  | 
            
            
              | 2437 | 
              	KEY `serialitems_sfk_1` (`serialid`),  | 
              2441 | 
                KEY `serialitems_sfk_1` (`serialid`),  | 
            
            
              | 2438 | 
              	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
              2442 | 
                CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
            
            
              | 2439 | 
              	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE  | 
              2443 | 
                CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE  | 
            
        
          | 2440 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2444 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2441 | 
           | 
          2445 | 
           | 
        
        
          | 2442 | 
          --  | 
          2446 | 
          --  | 
        
            
              | 2443 | 
              -   | 
               | 
               |