Lines 4231-4236
CREATE TABLE `letter` (
Link Here
|
4231 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
4231 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
4232 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
4232 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
4233 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
4233 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
|
|
4234 |
`font_size` int(4) NOT NULL DEFAULT 14 COMMENT 'font size used when notice is printed', |
4235 |
`text_justify` enum('L','C','R') NOT NULL DEFAULT 'L' COMMENT 'text justification used when notice is printed', |
4236 |
`units` enum('POINT','INCH','MM','CM') NOT NULL DEFAULT 'INCH' COMMENT 'units to use for print measurements', |
4237 |
`notice_width` float NOT NULL DEFAULT 8.5 COMMENT 'width of notice', |
4238 |
`top_margin` float NOT NULL DEFAULT 0 COMMENT 'top margin for notice', |
4239 |
`left_margin` float NOT NULL DEFAULT 0 COMMENT 'left margin for notice', |
4234 |
PRIMARY KEY (`id`), |
4240 |
PRIMARY KEY (`id`), |
4235 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
4241 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
4236 |
KEY `message_transport_type_fk` (`message_transport_type`), |
4242 |
KEY `message_transport_type_fk` (`message_transport_type`), |
4237 |
- |
|
|