| 
      
            Lines 2750-2756
          CREATE TABLE `deleteditems` (
      
      
        Link Here
      
     | 
  
        
          | 2750 | 
            `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',  | 
          2750 | 
            `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',  | 
        
        
          | 2751 | 
            `biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',  | 
          2751 | 
            `biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',  | 
        
        
          | 2752 | 
            `barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',  | 
          2752 | 
            `barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',  | 
        
          
            
              | 2753 | 
                `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not',  | 
              2753 | 
                `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not',  | 
            
        
          | 2754 | 
            `dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',  | 
          2754 | 
            `dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',  | 
        
        
          | 2755 | 
            `booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',  | 
          2755 | 
            `booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',  | 
        
        
          | 2756 | 
            `homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',  | 
          2756 | 
            `homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',  | 
        
  
    | 
      
            Lines 4008-4014
          CREATE TABLE `items` (
      
      
        Link Here
      
     | 
  
        
          | 4008 | 
            `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',  | 
          4008 | 
            `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',  | 
        
        
          | 4009 | 
            `biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',  | 
          4009 | 
            `biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',  | 
        
        
          | 4010 | 
            `barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',  | 
          4010 | 
            `barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',  | 
        
          
            
              | 4011 | 
                `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not',  | 
              4011 | 
                `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not',  | 
            
        
          | 4012 | 
            `dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',  | 
          4012 | 
            `dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',  | 
        
        
          | 4013 | 
            `booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',  | 
          4013 | 
            `booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',  | 
        
        
          | 4014 | 
            `homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',  | 
          4014 | 
            `homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',  |