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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 117-123 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
117
DROP TABLE IF EXISTS `biblio`;
117
DROP TABLE IF EXISTS `biblio`;
118
CREATE TABLE `biblio` ( -- table that stores bibliographic information
118
CREATE TABLE `biblio` ( -- table that stores bibliographic information
119
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
119
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
120
  `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
120
  `frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record
121
  `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21)
121
  `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21)
122
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
122
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
123
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
123
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
124
- 

Return to bug 14397