Lines 1110-1115
CREATE TABLE `biblio` (
Link Here
|
1110 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
1110 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
1111 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
1111 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
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 |
PRIMARY KEY (`biblionumber`), |
1114 |
PRIMARY KEY (`biblionumber`), |
1114 |
KEY `blbnoidx` (`biblionumber`) |
1115 |
KEY `blbnoidx` (`biblionumber`) |
1115 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1116 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 2598-2603
CREATE TABLE `deletedbiblio` (
Link Here
|
2598 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
2599 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
2599 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
2600 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
2600 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
2601 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
|
|
2602 |
`opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC', |
2601 |
PRIMARY KEY (`biblionumber`), |
2603 |
PRIMARY KEY (`biblionumber`), |
2602 |
KEY `blbnoidx` (`biblionumber`) |
2604 |
KEY `blbnoidx` (`biblionumber`) |
2603 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2605 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2604 |
- |
|
|