|
Lines 6491-6497
CREATE TABLE `subscription` (
Link Here
|
| 6491 |
`firstacquidate` date DEFAULT NULL COMMENT 'first issue received date', |
6491 |
`firstacquidate` date DEFAULT NULL COMMENT 'first issue received date', |
| 6492 |
`manualhistory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes or no to managing the history manually', |
6492 |
`manualhistory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes or no to managing the history manually', |
| 6493 |
`irregularity` mediumtext DEFAULT NULL COMMENT 'any irregularities in the subscription', |
6493 |
`irregularity` mediumtext DEFAULT NULL COMMENT 'any irregularities in the subscription', |
| 6494 |
`permanent_irregularity` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'permanent irregularities for renewal', |
6494 |
`permanent_irregularity` mediumtext DEFAULT NULL COMMENT 'permanent irregularities for renewal', |
| 6495 |
`skip_serialseq` tinyint(1) NOT NULL DEFAULT 0, |
6495 |
`skip_serialseq` tinyint(1) NOT NULL DEFAULT 0, |
| 6496 |
`letter` varchar(20) DEFAULT NULL, |
6496 |
`letter` varchar(20) DEFAULT NULL, |
| 6497 |
`numberpattern` int(11) DEFAULT NULL COMMENT 'the numbering pattern used links to subscription_numberpatterns.id', |
6497 |
`numberpattern` int(11) DEFAULT NULL COMMENT 'the numbering pattern used links to subscription_numberpatterns.id', |