View | Details | Raw Unified | Return to bug 38330
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_38330.pl (-1 / +2 lines)
Lines 12-18 return { Link Here
12
            $dbh->do(
12
            $dbh->do(
13
                q{
13
                q{
14
                ALTER TABLE `biblio`
14
                ALTER TABLE `biblio`
15
                    ADD COLUMN `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC' AFTER `abstract`;
15
                    ADD COLUMN `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC' AFTER `abstract`
16
                    ADD INDEX `suppressedidx` (`opac_suppressed`);
16
                }
17
                }
17
            );
18
            );
18
19
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1112-1118 CREATE TABLE `biblio` ( Link Here
1112
  `abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)',
1112
  `abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)',
1113
  `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC',
1113
  `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC',
1114
  PRIMARY KEY (`biblionumber`),
1114
  PRIMARY KEY (`biblionumber`),
1115
  KEY `blbnoidx` (`biblionumber`)
1115
  KEY `blbnoidx` (`biblionumber`),
1116
  KEY `suppressedidx` (`opac_suppressed`)
1116
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1117
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1117
/*!40101 SET character_set_client = @saved_cs_client */;
1118
/*!40101 SET character_set_client = @saved_cs_client */;
1118
1119
1119
- 

Return to bug 38330