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

(-)a/installer/data/mysql/atomicupdate/bug_5458.sql (+4 lines)
Line 0 Link Here
1
ALTER TABLE items                   CHANGE COLUMN ccode ccode varchar(80) default NULL;
2
ALTER TABLE deleteditems            CHANGE COLUMN ccode ccode varchar(80) default NULL;
3
ALTER TABLE branch_transfer_limits  CHANGE COLUMN ccode ccode varchar(80) default NULL;
4
ALTER TABLE course_items            CHANGE COLUMN ccode ccode varchar(80) default NULL;
(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
Lines 662-668 CREATE TABLE `deleteditems` ( Link Here
662
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
662
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
663
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
663
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
664
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
664
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
665
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
665
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
666
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
666
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
667
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
667
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
668
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
668
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 924-930 CREATE TABLE `items` ( -- holdings/item information Link Here
924
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
924
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
925
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
925
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
926
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
926
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
927
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
927
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
928
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
928
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
929
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
929
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
930
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
930
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 1989-1995 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1989
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
1989
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
1990
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1990
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1991
  `associatedborrower` int(11) default NULL, -- unused in Koha
1991
  `associatedborrower` int(11) default NULL, -- unused in Koha
1992
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1992
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1993
  KEY `timeidx` (`datetime`),
1993
  KEY `timeidx` (`datetime`),
1994
  KEY `branch_idx` (`branch`),
1994
  KEY `branch_idx` (`branch`),
1995
  KEY `proccode_idx` (`proccode`),
1995
  KEY `proccode_idx` (`proccode`),
Lines 2631-2637 CREATE TABLE branch_transfer_limits ( Link Here
2631
    toBranch varchar(10) NOT NULL,
2631
    toBranch varchar(10) NOT NULL,
2632
    fromBranch varchar(10) NOT NULL,
2632
    fromBranch varchar(10) NOT NULL,
2633
    itemtype varchar(10) NULL,
2633
    itemtype varchar(10) NULL,
2634
    ccode varchar(10) NULL,
2634
    ccode varchar(80) NULL,
2635
    PRIMARY KEY  (limitId)
2635
    PRIMARY KEY  (limitId)
2636
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2636
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2637
2637
Lines 3800-3806 CREATE TABLE `course_items` ( Link Here
3800
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3800
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3801
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3801
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3802
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3802
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3803
  `ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3803
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3804
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3804
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3805
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3805
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3806
  `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
3806
  `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
3807
- 

Return to bug 5458