| 
      
            Lines 1140-1145
          CREATE TABLE `import_items` (
      
      
        Link Here
      
     | 
  
        
          | 1140 | 
           | 
          1140 | 
           | 
        
        
          | 1141 | 
          DROP TABLE IF EXISTS `issues`;  | 
          1141 | 
          DROP TABLE IF EXISTS `issues`;  | 
        
        
          | 1142 | 
          CREATE TABLE `issues` ( -- information related to check outs or issues  | 
          1142 | 
          CREATE TABLE `issues` ( -- information related to check outs or issues  | 
        
            
               | 
               | 
              1143 | 
                `issue_id` int(11) NOT NULL AUTO_INCREMENT, -- primary key for issues table  | 
            
        
          | 1143 | 
            `borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to  | 
          1144 | 
            `borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to  | 
        
        
          | 1144 | 
            `itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out  | 
          1145 | 
            `itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out  | 
        
        
          | 1145 | 
            `date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)  | 
          1146 | 
            `date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)  | 
        
  
    | 
      
            Lines 1152-1157
          CREATE TABLE `issues` ( -- information related to check outs or issues
      
      
        Link Here
      
     | 
  
        
          | 1152 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1153 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
        
          | 1153 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
          1154 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
        
        
          | 1154 | 
            `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag  | 
          1155 | 
            `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag  | 
        
            
               | 
               | 
              1156 | 
                PRIMARY KEY (`issue_id`),  | 
            
        
          | 1155 | 
            KEY `issuesborridx` (`borrowernumber`),  | 
          1157 | 
            KEY `issuesborridx` (`borrowernumber`),  | 
        
        
          | 1156 | 
            KEY `itemnumber_idx` (`itemnumber`),  | 
          1158 | 
            KEY `itemnumber_idx` (`itemnumber`),  | 
        
        
          | 1157 | 
            KEY `branchcode_idx` (`branchcode`),  | 
          1159 | 
            KEY `branchcode_idx` (`branchcode`),  | 
        
  
    | 
      
            Lines 1614-1619
          CREATE TABLE `oai_sets_biblios` (
      
      
        Link Here
      
     | 
  
        
          | 1614 | 
           | 
          1616 | 
           | 
        
        
          | 1615 | 
          DROP TABLE IF EXISTS `old_issues`;  | 
          1617 | 
          DROP TABLE IF EXISTS `old_issues`;  | 
        
        
          | 1616 | 
          CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned  | 
          1618 | 
          CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned  | 
        
            
               | 
               | 
              1619 | 
                `issue_id` int(11) NOT NULL, -- primary key for issues table  | 
            
        
          | 1617 | 
            `borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to  | 
          1620 | 
            `borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to  | 
        
        
          | 1618 | 
            `itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out  | 
          1621 | 
            `itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out  | 
        
        
          | 1619 | 
            `date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)  | 
          1622 | 
            `date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)  | 
        
  
    | 
      
            Lines 1626-1631
          CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
      
      
        Link Here
      
     | 
  
        
          | 1626 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1629 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
        
          | 1627 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
          1630 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
        
        
          | 1628 | 
            `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag  | 
          1631 | 
            `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag  | 
        
            
               | 
               | 
              1632 | 
                PRIMARY KEY (`issue_id`),  | 
            
        
          | 1629 | 
            KEY `old_issuesborridx` (`borrowernumber`),  | 
          1633 | 
            KEY `old_issuesborridx` (`borrowernumber`),  | 
        
        
          | 1630 | 
            KEY `old_issuesitemidx` (`itemnumber`),  | 
          1634 | 
            KEY `old_issuesitemidx` (`itemnumber`),  | 
        
        
          | 1631 | 
            KEY `branchcode_idx` (`branchcode`),  | 
          1635 | 
            KEY `branchcode_idx` (`branchcode`),  |