| 
      
            Lines 266-271
          CREATE TABLE `borrowers` ( -- this table includes information about your patrons
      
      
        Link Here
      
     | 
  
        
          | 266 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
          266 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
        
        
          | 267 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  | 
          267 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  | 
        
        
          | 268 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
          268 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
        
            
               | 
               | 
              269 | 
                `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)  | 
            
        
          | 269 | 
            UNIQUE KEY `cardnumber` (`cardnumber`),  | 
          270 | 
            UNIQUE KEY `cardnumber` (`cardnumber`),  | 
        
        
          | 270 | 
            PRIMARY KEY `borrowernumber` (`borrowernumber`),  | 
          271 | 
            PRIMARY KEY `borrowernumber` (`borrowernumber`),  | 
        
        
          | 271 | 
            KEY `categorycode` (`categorycode`),  | 
          272 | 
            KEY `categorycode` (`categorycode`),  | 
        
  
    | 
      
            Lines 918-923
          CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
      
      
        Link Here
      
     | 
  
        
          | 918 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
          919 | 
            `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber  | 
        
        
          | 919 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),  | 
          920 | 
            `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),  | 
        
        
          | 920 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
          921 | 
            `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts  | 
        
            
               | 
               | 
              922 | 
                `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)  | 
            
        
          | 921 | 
            KEY borrowernumber (borrowernumber),  | 
          923 | 
            KEY borrowernumber (borrowernumber),  | 
        
        
          | 922 | 
            KEY `cardnumber` (`cardnumber`),  | 
          924 | 
            KEY `cardnumber` (`cardnumber`),  | 
        
        
          | 923 | 
            KEY `sms_provider_id` (`sms_provider_id`)  | 
          925 | 
            KEY `sms_provider_id` (`sms_provider_id`)  |