| 
      
            Lines 3790-3798
          CREATE TABLE `course_items` (
      
      
        Link Here
      
     | 
  
        
          | 3790 | 
            `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id  | 
          3790 | 
            `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id  | 
        
        
          | 3791 | 
            `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve  | 
          3791 | 
            `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve  | 
        
        
          | 3792 | 
            `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)  | 
          3792 | 
            `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)  | 
        
            
               | 
               | 
              3793 | 
                `itype_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if itype should be changed while on course reserve  | 
            
        
          | 3793 | 
            `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)  | 
          3794 | 
            `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)  | 
        
            
               | 
               | 
              3795 | 
                `ccode_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if ccode should be changed while on course reserve  | 
            
        
          | 3794 | 
            `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)  | 
          3796 | 
            `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)  | 
        
            
               | 
               | 
              3797 | 
                `holdingbranch_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if itype should be changed while on course reserve  | 
            
        
          | 3795 | 
            `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)  | 
          3798 | 
            `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)  | 
        
            
               | 
               | 
              3799 | 
                `location_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if itype should be changed while on course reserve  | 
            
        
          | 3796 | 
            `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' | 
          3800 | 
            `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' | 
        
        
          | 3797 | 
            `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
          3801 | 
            `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
        
        
          | 3798 | 
             PRIMARY KEY (`ci_id`),  | 
          3802 | 
             PRIMARY KEY (`ci_id`),  | 
        
            
              | 3799 | 
              -   | 
               | 
               |