Lines 190-195
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
190 |
KEY `isbn` (`isbn`(255)), |
190 |
KEY `isbn` (`isbn`(255)), |
191 |
KEY `issn` (`issn`(255)), |
191 |
KEY `issn` (`issn`(255)), |
192 |
KEY `publishercode` (`publishercode`), |
192 |
KEY `publishercode` (`publishercode`), |
|
|
193 |
KEY `timestamp` (`timestamp`), |
193 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
194 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
194 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
195 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
195 |
|
196 |
|
Lines 543-549
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
543 |
KEY `bibnoidx` (`biblionumber`), |
544 |
KEY `bibnoidx` (`biblionumber`), |
544 |
KEY `itemtype_idx` (`itemtype`), |
545 |
KEY `itemtype_idx` (`itemtype`), |
545 |
KEY `isbn` (`isbn`(255)), |
546 |
KEY `isbn` (`isbn`(255)), |
546 |
KEY `publishercode` (`publishercode`) |
547 |
KEY `publishercode` (`publishercode`), |
|
|
548 |
KEY `timestamp` (`timestamp`) |
547 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
549 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
548 |
|
550 |
|
549 |
-- |
551 |
-- |
Lines 683-689
CREATE TABLE `deleteditems` (
Link Here
|
683 |
KEY `delitembibnoidx` (`biblionumber`), |
685 |
KEY `delitembibnoidx` (`biblionumber`), |
684 |
KEY `delhomebranch` (`homebranch`), |
686 |
KEY `delhomebranch` (`homebranch`), |
685 |
KEY `delholdingbranch` (`holdingbranch`), |
687 |
KEY `delholdingbranch` (`holdingbranch`), |
686 |
KEY `itype_idx` (`itype`) |
688 |
KEY `itype_idx` (`itype`), |
|
|
689 |
KEY `timestamp` (`timestamp`) |
687 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
690 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
688 |
|
691 |
|
689 |
-- |
692 |
-- |
Lines 885-891
CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale
Link Here
|
885 |
-- |
888 |
-- |
886 |
|
889 |
|
887 |
DROP TABLE IF EXISTS `items`; |
890 |
DROP TABLE IF EXISTS `items`; |
888 |
CREATE TABLE `items` ( -- holdings/item information |
891 |
CREATE TABLE `items` ( -- holdings/item information |
889 |
`itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha |
892 |
`itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier added by Koha |
890 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record |
893 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record |
891 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
894 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
Lines 941-946
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
941 |
KEY `items_location` (`location`), |
944 |
KEY `items_location` (`location`), |
942 |
KEY `items_ccode` (`ccode`), |
945 |
KEY `items_ccode` (`ccode`), |
943 |
KEY `itype_idx` (`itype`), |
946 |
KEY `itype_idx` (`itype`), |
|
|
947 |
KEY `timestamp` (`timestamp`), |
944 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
948 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
945 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
949 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
946 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
950 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
Lines 2218-2224
CREATE TABLE `userflags` (
Link Here
|
2218 |
-- |
2222 |
-- |
2219 |
|
2223 |
|
2220 |
DROP TABLE IF EXISTS `virtualshelves`; |
2224 |
DROP TABLE IF EXISTS `virtualshelves`; |
2221 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
2225 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
2222 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
2226 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
2223 |
`shelfname` varchar(255) default NULL, -- name of the list |
2227 |
`shelfname` varchar(255) default NULL, -- name of the list |
2224 |
`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) |
2228 |
`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 2413-2424
CREATE TABLE `permissions` (
Link Here
|
2413 |
|
2417 |
|
2414 |
DROP TABLE IF EXISTS `serialitems`; |
2418 |
DROP TABLE IF EXISTS `serialitems`; |
2415 |
CREATE TABLE `serialitems` ( |
2419 |
CREATE TABLE `serialitems` ( |
2416 |
`itemnumber` int(11) NOT NULL, |
2420 |
`itemnumber` int(11) NOT NULL, |
2417 |
`serialid` int(11) NOT NULL, |
2421 |
`serialid` int(11) NOT NULL, |
2418 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2422 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2419 |
KEY `serialitems_sfk_1` (`serialid`), |
2423 |
KEY `serialitems_sfk_1` (`serialid`), |
2420 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2424 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2421 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2425 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2422 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2426 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2423 |
|
2427 |
|
2424 |
-- |
2428 |
-- |
2425 |
- |
|
|