|
Lines 1354-1360
CREATE TABLE `letter` ( -- table for all notice templates in Koha
Link Here
|
| 1354 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
1354 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
| 1355 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
1355 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
| 1356 |
`content` text, -- body text for the notice or slip |
1356 |
`content` text, -- body text for the notice or slip |
| 1357 |
PRIMARY KEY (`module`,`code`, `branchcode`) |
1357 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
|
|
1358 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`), |
| 1359 |
CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) |
| 1360 |
REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1358 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1361 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 1359 |
|
1362 |
|
| 1360 |
-- |
1363 |
-- |
|
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 |
|