Lines 2542-2548
CREATE TABLE `letter` ( -- table for all notice templates in Koha
Link Here
|
2542 |
`content` text, -- body text for the notice or slip |
2542 |
`content` text, -- body text for the notice or slip |
2543 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
2543 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
2544 |
`lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice |
2544 |
`lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice |
2545 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`), |
2545 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`, `lang`), |
2546 |
CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) |
2546 |
CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) |
2547 |
REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE |
2547 |
REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE |
2548 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2548 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2549 |
- |
|
|