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 661-667 CREATE TABLE `deleteditems` ( Link Here
661
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
661
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
662
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
662
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
663
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
663
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
664
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
664
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
665
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
665
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
666
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
666
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
667
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
667
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 923-929 CREATE TABLE `items` ( -- holdings/item information Link Here
923
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
923
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
924
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
924
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
925
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
925
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
926
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
926
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
927
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
927
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
928
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
928
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
929
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
929
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 1988-1994 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1988
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
1988
  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
1989
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1989
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1990
  `associatedborrower` int(11) default NULL, -- unused in Koha
1990
  `associatedborrower` int(11) default NULL, -- unused in Koha
1991
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1991
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1992
  KEY `timeidx` (`datetime`),
1992
  KEY `timeidx` (`datetime`),
1993
  KEY `branch_idx` (`branch`),
1993
  KEY `branch_idx` (`branch`),
1994
  KEY `proccode_idx` (`proccode`),
1994
  KEY `proccode_idx` (`proccode`),
Lines 2640-2646 CREATE TABLE branch_transfer_limits ( Link Here
2640
    toBranch varchar(10) NOT NULL,
2640
    toBranch varchar(10) NOT NULL,
2641
    fromBranch varchar(10) NOT NULL,
2641
    fromBranch varchar(10) NOT NULL,
2642
    itemtype varchar(10) NULL,
2642
    itemtype varchar(10) NULL,
2643
    ccode varchar(10) NULL,
2643
    ccode varchar(80) NULL,
2644
    PRIMARY KEY  (limitId)
2644
    PRIMARY KEY  (limitId)
2645
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2645
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2646
2646
Lines 3794-3800 CREATE TABLE `course_items` ( Link Here
3794
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3794
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3795
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3795
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3796
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3796
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3797
  `ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3797
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3798
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3798
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3799
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3799
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3800
  `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'
3800
  `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'
3801
- 

Return to bug 5458