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