| 
      
            Lines 1271-1276
          CREATE TABLE `borrower_modifications` (
      
      
        Link Here
      
     | 
  
        
          | 1271 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1271 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1272 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1272 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1273 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1273 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
            
               | 
               | 
              1274 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 1274 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1275 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1275 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1276 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 1276 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          1277 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
  
    | 
      
            Lines 1389-1394
          CREATE TABLE `borrowers` (
      
      
        Link Here
      
     | 
  
        
          | 1389 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
          1390 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
        
        
          | 1390 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
          1391 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
        
        
          | 1391 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
          1392 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
        
            
               | 
               | 
              1393 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 1392 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
          1394 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
        
        
          | 1393 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
          1395 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
        
        
          | 1394 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
          1396 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
        
  
    | 
      
            Lines 2401-2406
          CREATE TABLE `deletedborrowers` (
      
      
        Link Here
      
     | 
  
        
          | 2401 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
          2403 | 
            `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers',  | 
        
        
          | 2402 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
          2404 | 
            `surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)',  | 
        
        
          | 2403 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
          2405 | 
            `firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name',  | 
        
            
               | 
               | 
              2406 | 
                `middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name',  | 
            
        
          | 2404 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
          2407 | 
            `title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.',  | 
        
        
          | 2405 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
          2408 | 
            `othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower',  | 
        
        
          | 2406 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
          2409 | 
            `initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower',  | 
        
            
              | 2407 | 
              -   | 
               | 
               |