Lines 1346-1352
CREATE TABLE `letter` ( -- table for all notice templates in Koha
Link Here
|
1346 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
1346 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
1347 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
1347 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
1348 |
`content` text, -- body text for the notice or slip |
1348 |
`content` text, -- body text for the notice or slip |
1349 |
PRIMARY KEY (`module`,`code`, `branchcode`) |
1349 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
|
|
1350 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`), |
1351 |
CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) |
1352 |
REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE |
1350 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1353 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1351 |
|
1354 |
|
1352 |
-- |
1355 |
-- |
Lines 2549-2554
CREATE TABLE `message_transport_types` (
Link Here
|
2549 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2552 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2550 |
|
2553 |
|
2551 |
-- |
2554 |
-- |
|
|
2555 |
-- Table structure for table `overduerules_transport_types` |
2556 |
-- |
2557 |
|
2558 |
DROP TABLE IF EXISTS `overduerules_transport_types`; |
2559 |
CREATE TABLE overduerules_transport_types( |
2560 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
2561 |
`branchcode` varchar(10) NOT NULL DEFAULT '', |
2562 |
`categorycode` VARCHAR(10) NOT NULL DEFAULT '', |
2563 |
`letternumber` INT(1) NOT NULL DEFAULT 1, |
2564 |
`message_transport_type` VARCHAR(20) NOT NULL DEFAULT 'email', |
2565 |
PRIMARY KEY (id), |
2566 |
CONSTRAINT overduerules_fk FOREIGN KEY (branchcode, categorycode) REFERENCES overduerules (branchcode, categorycode) ON DELETE CASCADE ON UPDATE CASCADE, |
2567 |
CONSTRAINT mtt_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types (message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE |
2568 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2569 |
|
2570 |
-- |
2552 |
-- Table structure for table `message_attributes` |
2571 |
-- Table structure for table `message_attributes` |
2553 |
-- |
2572 |
-- |
2554 |
|
2573 |
|