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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 121-127 CREATE TABLE `biblio` ( -- table that stores bibliographic information Link Here
121
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
121
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
122
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
122
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
123
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
123
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
124
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
124
  `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial
125
  `seriestitle` mediumtext,
125
  `seriestitle` mediumtext,
126
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
126
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
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
Lines 710-716 CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records Link Here
710
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
710
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
711
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
711
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
712
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
712
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
713
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
713
  `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial
714
  `seriestitle` mediumtext,
714
  `seriestitle` mediumtext,
715
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
715
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
716
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
716
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
717
- 

Return to bug 10889