| 
      
            Lines 618-624
          CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
      
      
        Link Here
      
     | 
  
        
          | 618 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
          618 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
        
        
          | 619 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),  | 
          619 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),  | 
        
        
          | 620 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
          620 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
        
          
            
              | 621 | 
                `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)  | 
              621 | 
                `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)  | 
            
        
          | 622 | 
            KEY borrowernumber (borrowernumber),  | 
          622 | 
            KEY borrowernumber (borrowernumber),  | 
        
        
          | 623 | 
            KEY `cardnumber` (`cardnumber`),  | 
          623 | 
            KEY `cardnumber` (`cardnumber`),  | 
        
        
          | 624 | 
            KEY `sms_provider_id` (`sms_provider_id`)  | 
          624 | 
            KEY `sms_provider_id` (`sms_provider_id`)  | 
        
  
    | 
      
            Lines 1624-1630
          CREATE TABLE `borrowers` ( -- this table includes information about your patrons
      
      
        Link Here
      
     | 
  
        
          | 1624 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
          1624 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
        
        
          | 1625 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  | 
          1625 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  | 
        
        
          | 1626 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
          1626 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
        
          
            
              | 1627 | 
                `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)  | 
              1627 | 
                `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)  | 
            
        
          | 1628 | 
            UNIQUE KEY `cardnumber` (`cardnumber`),  | 
          1628 | 
            UNIQUE KEY `cardnumber` (`cardnumber`),  | 
        
        
          | 1629 | 
            PRIMARY KEY `borrowernumber` (`borrowernumber`),  | 
          1629 | 
            PRIMARY KEY `borrowernumber` (`borrowernumber`),  | 
        
        
          | 1630 | 
            KEY `categorycode` (`categorycode`),  | 
          1630 | 
            KEY `categorycode` (`categorycode`),  | 
        
            
              | 1631 | 
              -   | 
               | 
               |