| 
      
            Lines 1264-1269
          CREATE TABLE `borrower_modifications` (
      
      
        Link Here
      
     | 
  
        
          | 1264 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1264 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1265 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1265 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1266 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1266 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
            
               | 
               | 
              1267 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 1267 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1268 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1268 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1269 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1269 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1270 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
  
    | 
      
            Lines 1382-1387
          CREATE TABLE `borrowers` (
      
      
        Link Here
      
     | 
  
        
          | 1382 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
          1383 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
        
        
          | 1383 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
          1384 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
        
        
          | 1384 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
          1385 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
        
            
               | 
               | 
              1386 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 1385 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
          1387 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
        
        
          | 1386 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
          1388 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
        
        
          | 1387 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
          1389 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
        
  
    | 
      
            Lines 2390-2395
          CREATE TABLE `deletedborrowers` (
      
      
        Link Here
      
     | 
  
        
          | 2390 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
          2392 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
        
        
          | 2391 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
          2393 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
        
        
          | 2392 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
          2394 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
        
            
               | 
               | 
              2395 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 2393 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
          2396 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
        
        
          | 2394 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
          2397 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
        
        
          | 2395 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
          2398 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
        
            
              | 2396 | 
              -   | 
               | 
               |