| 
      
            Lines 2529-2535
          CREATE TABLE `letter` ( -- table for all notice templates in Koha
      
      
        Link Here
      
     | 
  
        
          | 2529 | 
            `content` text, -- body text for the notice or slip  | 
          2529 | 
            `content` text, -- body text for the notice or slip  | 
        
        
          | 2530 | 
            `message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice  | 
          2530 | 
            `message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice  | 
        
        
          | 2531 | 
            `lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice  | 
          2531 | 
            `lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice  | 
        
          
            
              | 2532 | 
                PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`),  | 
              2532 | 
                PRIMARY KEY  (`module`,`code`, `branchcode`, `message_transport_type`, `lang`),  | 
            
        
          | 2533 | 
            CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)  | 
          2533 | 
            CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`)  | 
        
        
          | 2534 | 
            REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2534 | 
            REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2535 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2535 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
            
              | 2536 | 
              -   | 
               | 
               |