Lines 1111-1116
CREATE TABLE `biblio` (
Link Here
|
1111 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
1111 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
1112 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
1112 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
1113 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
1113 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
|
|
1114 |
`opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC', |
1114 |
PRIMARY KEY (`biblionumber`), |
1115 |
PRIMARY KEY (`biblionumber`), |
1115 |
KEY `blbnoidx` (`biblionumber`) |
1116 |
KEY `blbnoidx` (`biblionumber`) |
1116 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1117 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 2575-2580
CREATE TABLE `deletedbiblio` (
Link Here
|
2575 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
2576 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', |
2576 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
2577 |
`datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', |
2577 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
2578 |
`abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', |
|
|
2579 |
`opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC', |
2578 |
PRIMARY KEY (`biblionumber`), |
2580 |
PRIMARY KEY (`biblionumber`), |
2579 |
KEY `blbnoidx` (`biblionumber`) |
2581 |
KEY `blbnoidx` (`biblionumber`) |
2580 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2582 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2581 |
- |
|
|