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 |
- |
|
|