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

(-)a/installer/data/mysql/kohastructure.sql (-11 / +10 lines)
Lines 116-131 DROP TABLE IF EXISTS `biblio`; Link Here
116
CREATE TABLE `biblio` ( -- table that stores bibliographic information
116
CREATE TABLE `biblio` ( -- table that stores bibliographic information
117
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
117
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
118
  `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
118
  `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
119
  `author` mediumtext, -- statement of responsibility from MARC record (100 in MARC21)
119
  `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21)
120
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245 in MARC21)
120
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
121
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240 in MARC21)
121
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
122
  `notes` mediumtext, -- values from the general notes field in the MARC record (500 in MARC21) split by bar (|)
122
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
123
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
123
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
124
  `seriestitle` mediumtext,
124
  `seriestitle` mediumtext,
125
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
125
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
126
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
126
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
127
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
127
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
128
  `abstract` mediumtext, -- summary from the MARC record (520 in MARC21)
128
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
129
  PRIMARY KEY  (`biblionumber`),
129
  PRIMARY KEY  (`biblionumber`),
130
  KEY `blbnoidx` (`biblionumber`)
130
  KEY `blbnoidx` (`biblionumber`)
131
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Lines 591-606 DROP TABLE IF EXISTS `deletedbiblio`; Link Here
591
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records that have been deleted
591
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records that have been deleted
592
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
592
  `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record
593
  `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
593
  `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
594
  `author` mediumtext, -- statement of responsibility from MARC record (100 in MARC21)
594
  `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21)
595
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245 in MARC21)
595
  `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21)
596
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240 in MARC21)
596
  `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21)
597
  `notes` mediumtext, -- values from the general notes field in the MARC record (500 in MARC21) split by bar (|)
597
  `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
598
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
598
  `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table
599
  `seriestitle` mediumtext,
599
  `seriestitle` mediumtext,
600
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
600
  `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record
601
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
601
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
602
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
602
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
603
  `abstract` mediumtext, -- summary from the MARC record (520 in MARC21)
603
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
604
  PRIMARY KEY  (`biblionumber`),
604
  PRIMARY KEY  (`biblionumber`),
605
  KEY `blbnoidx` (`biblionumber`)
605
  KEY `blbnoidx` (`biblionumber`)
606
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
606
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
607
- 

Return to bug 6716