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 2544-2549
CREATE TABLE `message_transport_types` (
Link Here
|
2544 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2547 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2545 |
|
2548 |
|
2546 |
-- |
2549 |
-- |
|
|
2550 |
-- Table structure for table `overduerules_transport_types` |
2551 |
-- |
2552 |
|
2553 |
DROP TABLE IF EXISTS `overduerules_transport_types`; |
2554 |
CREATE TABLE overduerules_transport_types( |
2555 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
2556 |
`branchcode` varchar(10) NOT NULL DEFAULT '', |
2557 |
`categorycode` VARCHAR(10) NOT NULL DEFAULT '', |
2558 |
`letternumber` INT(1) NOT NULL DEFAULT 1, |
2559 |
`message_transport_type` VARCHAR(20) NOT NULL DEFAULT 'email', |
2560 |
PRIMARY KEY (id), |
2561 |
CONSTRAINT overduerules_fk FOREIGN KEY (branchcode, categorycode) REFERENCES overduerules (branchcode, categorycode) ON DELETE CASCADE ON UPDATE CASCADE, |
2562 |
CONSTRAINT mtt_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types (message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE |
2563 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2564 |
|
2565 |
-- |
2547 |
-- Table structure for table `message_attributes` |
2566 |
-- Table structure for table `message_attributes` |
2548 |
-- |
2567 |
-- |
2549 |
|
2568 |
|