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