Lines 201-206
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
201 |
KEY `isbn` (`isbn`(255)), |
201 |
KEY `isbn` (`isbn`(255)), |
202 |
KEY `issn` (`issn`(255)), |
202 |
KEY `issn` (`issn`(255)), |
203 |
KEY `publishercode` (`publishercode`), |
203 |
KEY `publishercode` (`publishercode`), |
|
|
204 |
KEY `timestamp` (`timestamp`), |
204 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
205 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
205 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
206 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
206 |
|
207 |
|
Lines 553-559
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
553 |
KEY `bibnoidx` (`biblionumber`), |
554 |
KEY `bibnoidx` (`biblionumber`), |
554 |
KEY `itemtype_idx` (`itemtype`), |
555 |
KEY `itemtype_idx` (`itemtype`), |
555 |
KEY `isbn` (`isbn`(255)), |
556 |
KEY `isbn` (`isbn`(255)), |
556 |
KEY `publishercode` (`publishercode`) |
557 |
KEY `publishercode` (`publishercode`), |
|
|
558 |
KEY `timestamp` (`timestamp`) |
557 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
559 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
558 |
|
560 |
|
559 |
-- |
561 |
-- |
Lines 694-700
CREATE TABLE `deleteditems` (
Link Here
|
694 |
KEY `delitembibnoidx` (`biblionumber`), |
696 |
KEY `delitembibnoidx` (`biblionumber`), |
695 |
KEY `delhomebranch` (`homebranch`), |
697 |
KEY `delhomebranch` (`homebranch`), |
696 |
KEY `delholdingbranch` (`holdingbranch`), |
698 |
KEY `delholdingbranch` (`holdingbranch`), |
697 |
KEY `itype_idx` (`itype`) |
699 |
KEY `itype_idx` (`itype`), |
|
|
700 |
KEY `timestamp` (`timestamp`) |
698 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
701 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
699 |
|
702 |
|
700 |
-- |
703 |
-- |
Lines 899-905
CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale
Link Here
|
899 |
-- |
902 |
-- |
900 |
|
903 |
|
901 |
DROP TABLE IF EXISTS `items`; |
904 |
DROP TABLE IF EXISTS `items`; |
902 |
CREATE TABLE `items` ( -- holdings/item information |
905 |
CREATE TABLE `items` ( -- holdings/item information |
903 |
`itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha |
906 |
`itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha |
904 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record |
907 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record |
905 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
908 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
Lines 955-960
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
955 |
KEY `items_location` (`location`), |
958 |
KEY `items_location` (`location`), |
956 |
KEY `items_ccode` (`ccode`), |
959 |
KEY `items_ccode` (`ccode`), |
957 |
KEY `itype_idx` (`itype`), |
960 |
KEY `itype_idx` (`itype`), |
|
|
961 |
KEY `timestamp` (`timestamp`), |
958 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
962 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
959 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
963 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
960 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
964 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
Lines 2236-2242
CREATE TABLE `userflags` (
Link Here
|
2236 |
-- |
2240 |
-- |
2237 |
|
2241 |
|
2238 |
DROP TABLE IF EXISTS `virtualshelves`; |
2242 |
DROP TABLE IF EXISTS `virtualshelves`; |
2239 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
2243 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
2240 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
2244 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
2241 |
`shelfname` varchar(255) default NULL, -- name of the list |
2245 |
`shelfname` varchar(255) default NULL, -- name of the list |
2242 |
`owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |
2246 |
`owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |
Lines 2431-2442
CREATE TABLE `permissions` (
Link Here
|
2431 |
|
2435 |
|
2432 |
DROP TABLE IF EXISTS `serialitems`; |
2436 |
DROP TABLE IF EXISTS `serialitems`; |
2433 |
CREATE TABLE `serialitems` ( |
2437 |
CREATE TABLE `serialitems` ( |
2434 |
`itemnumber` int(11) NOT NULL, |
2438 |
`itemnumber` int(11) NOT NULL, |
2435 |
`serialid` int(11) NOT NULL, |
2439 |
`serialid` int(11) NOT NULL, |
2436 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2440 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2437 |
KEY `serialitems_sfk_1` (`serialid`), |
2441 |
KEY `serialitems_sfk_1` (`serialid`), |
2438 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2442 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2439 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2443 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2440 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2444 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2441 |
|
2445 |
|
2442 |
-- |
2446 |
-- |
2443 |
- |
|
|