| Lines 263-268
          CREATE TABLE `borrowers` ( -- this table includes information about your patrons
      
      
        Link Here | 
        
          | 263 |   `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower | 263 |   `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower | 
        
          | 264 |   `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower | 264 |   `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower | 
        
          | 265 |   `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) | 265 |   `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) | 
            
              |  |  | 266 |   `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber | 
        
          | 266 |   `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 | 
        
          | 267 |   `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 | 
        
          | 268 |   UNIQUE KEY `cardnumber` (`cardnumber`), | 269 |   UNIQUE KEY `cardnumber` (`cardnumber`), | 
  
    | Lines 274-281
          CREATE TABLE `borrowers` ( -- this table includes information about your patrons
      
      
        Link Here | 
        
          | 274 |   KEY `surname_idx` (`surname`(255)), | 275 |   KEY `surname_idx` (`surname`(255)), | 
        
          | 275 |   KEY `firstname_idx` (`firstname`(255)), | 276 |   KEY `firstname_idx` (`firstname`(255)), | 
        
          | 276 |   KEY `othernames_idx` (`othernames`(255)), | 277 |   KEY `othernames_idx` (`othernames`(255)), | 
            
              |  |  | 278 |   KEY `sms_provider_id` (`sms_provider_id`), | 
        
          | 277 |   CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), | 279 |   CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), | 
        
          | 278 |   CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) | 280 |   CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) | 
            
              |  |  | 281 |   CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) | 
        
          | 279 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 282 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 
        
          | 280 |  | 283 |  | 
        
          | 281 | -- | 284 | -- | 
  
    | Lines 1981-1986
          CREATE TABLE sessions (
      
      
        Link Here | 
        
          | 1981 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 1984 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | 
        
          | 1982 |  | 1985 |  | 
        
          | 1983 | -- | 1986 | -- | 
            
              |  |  | 1987 | -- Table structure for table `sms_providers` | 
            
              | 1988 | -- | 
            
              | 1989 |  | 
            
              | 1990 | DROP TABLE IF EXISTS sms_providers; | 
            
              | 1991 | CREATE TABLE `sms_providers` ( | 
            
              | 1992 |   `id` int(11) NOT NULL AUTO_INCREMENT, | 
            
              | 1993 |   `name` varchar(255) NOT NULL, | 
            
              | 1994 |   `domain` varchar(255) NOT NULL, | 
            
              | 1995 |   PRIMARY KEY (`id`), | 
            
              | 1996 |   UNIQUE KEY `name` (`name`) | 
            
              | 1997 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 
            
              | 1998 |  | 
            
              | 1999 | -- | 
        
          | 1984 | -- Table structure for table `special_holidays` | 2000 | -- Table structure for table `special_holidays` | 
        
          | 1985 | -- | 2001 | -- | 
        
          | 1986 |  | 2002 |  |