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