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 |
- |
|
|