Attachment #79331 for bug #5458

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_5458.sql (+4 lines)
	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;




  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out)
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
  `materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3)
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

  `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
  `associatedborrower` int(11) default NULL, -- unused in Koha
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
  KEY `timeidx` (`datetime`),
  KEY `branch_idx` (`branch`),
  KEY `proccode_idx` (`proccode`),

    toBranch varchar(10) NOT NULL,
    fromBranch varchar(10) NOT NULL,
    itemtype varchar(10) NULL,
    ccode varchar(80) NULL,
    PRIMARY KEY  (limitId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
  `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'
- 

Return to bug 5458

Lines 662-668 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
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	-