Lines 127-132
CREATE TABLE `biblio` ( -- table that stores bibliographic information
Link Here
|
127 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
127 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
128 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
128 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
129 |
`abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) |
129 |
`abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) |
|
|
130 |
`force_item_holds` tinyint, -- works if pref OPACItemHolds is set to 'Selectively force' |
130 |
PRIMARY KEY (`biblionumber`), |
131 |
PRIMARY KEY (`biblionumber`), |
131 |
KEY `blbnoidx` (`biblionumber`) |
132 |
KEY `blbnoidx` (`biblionumber`) |
132 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
133 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |