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

(-)a/installer/data/mysql/atomicupdate/bug_10455.sql (+2 lines)
Line 0 Link Here
1
ALTER TABLE biblioitems DROP COLUMN marc;
2
ALTER TABLE deletedbiblioitems DROP COLUMN marc;
(-)a/installer/data/mysql/kohastructure.sql (-3 lines)
Lines 173-179 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
173
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
173
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
174
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
174
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
175
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
175
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
176
  `marc` longblob, -- full bibliographic MARC record
177
  `url` text default NULL, -- url (MARC21 856$u)
176
  `url` text default NULL, -- url (MARC21 856$u)
178
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
177
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
179
  `cn_class` varchar(30) default NULL,
178
  `cn_class` varchar(30) default NULL,
Lines 528-534 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
528
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
527
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
529
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
528
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
530
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
529
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
531
  `marc` longblob, -- full bibliographic MARC record
532
  `url` text default NULL, -- url (MARC21 856$u)
530
  `url` text default NULL, -- url (MARC21 856$u)
533
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
531
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
534
  `cn_class` varchar(30) default NULL,
532
  `cn_class` varchar(30) default NULL,
535
- 

Return to bug 10455