Lines 3959-3964
CREATE TABLE `letter` (
Link Here
|
3959 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
3959 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice', |
3960 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
3960 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice', |
3961 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
3961 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', |
|
|
3962 |
`font_size` int(4) NOT NULL DEFAULT 14 COMMENT 'font size used when notice is printed', |
3963 |
`text_justify` enum('L','C','R') NOT NULL DEFAULT 'L' COMMENT 'text justification used when notice is printed', |
3964 |
`units` enum('POINT','INCH','MM','CM') NOT NULL DEFAULT 'INCH' COMMENT 'units to use for print measurements', |
3965 |
`notice_width` float NOT NULL DEFAULT 8.5 COMMENT 'width of notice', |
3966 |
`top_margin` float NOT NULL DEFAULT 0 COMMENT 'top margin for notice', |
3967 |
`left_margin` float NOT NULL DEFAULT 0 COMMENT 'left margin for notice', |
3962 |
PRIMARY KEY (`id`), |
3968 |
PRIMARY KEY (`id`), |
3963 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
3969 |
UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), |
3964 |
KEY `message_transport_type_fk` (`message_transport_type`), |
3970 |
KEY `message_transport_type_fk` (`message_transport_type`), |
3965 |
- |
|
|