Lines 3856-3861
CREATE TABLE `letter` (
Link Here
|
3856 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
3856 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
3857 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
3857 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
3858 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
3858 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
|
|
3859 |
`font_size` int(4) NOT NULL DEFAULT 10 COMMENT 'font size used when notice is printed', |
3860 |
`text_justify` char(1) NOT NULL DEFAULT 'L' COMMENT 'text justification used when notice is printed', |
3861 |
`units` char(20) NOT NULL DEFAULT 'INCH' COMMENT 'units to use for print measurements', |
3862 |
`notice_width` float NOT NULL DEFAULT 8.5 COMMENT 'width of notice', |
3863 |
`top_margin` float NOT NULL DEFAULT 0.5 COMMENT 'top margin for notice', |
3864 |
`left_margin` float NOT NULL DEFAULT 0.5 COMMENT 'left margin for notice', |
3859 |
PRIMARY KEY (`id`), |
3865 |
PRIMARY KEY (`id`), |
3860 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
3866 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
3861 |
KEY `message_transport_type_fk` (`message_transport_type`), |
3867 |
KEY `message_transport_type_fk` (`message_transport_type`), |
3862 |
- |
|
|