| 
      
            Lines 678-684
          CREATE TABLE `deleteditems` (
      
      
        Link Here
      
     | 
  
        
          | 678 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered  | 
          678 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered  | 
        
        
          | 679 | 
            `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)  | 
          679 | 
            `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)  | 
        
        
          | 680 | 
            `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location  | 
          680 | 
            `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location  | 
        
          
            
              | 681 | 
                `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)  | 
              681 | 
                `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)  | 
            
        
          | 682 | 
            `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)  | 
          682 | 
            `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)  | 
        
        
          | 683 | 
            `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting  | 
          683 | 
            `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting  | 
        
        
          | 684 | 
            `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)  | 
          684 | 
            `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)  | 
        
            
              | 685 | 
              -   | 
               | 
               |