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