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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +5 lines)
Lines 319-334 CREATE TABLE collections ( Link Here
319
  colTitle varchar(100) NOT NULL DEFAULT '',
319
  colTitle varchar(100) NOT NULL DEFAULT '',
320
  colDesc MEDIUMTEXT NOT NULL,
320
  colDesc MEDIUMTEXT NOT NULL,
321
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
321
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
322
  PRIMARY KEY (colId)
322
  PRIMARY KEY (colId),
323
  CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCAD     E ON UPDATE CASCADE
323
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
324
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
324
325
325
--
326
--
326
-- Constraints for table `collections`
327
--
328
ALTER TABLE `collections`
329
  ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
330
331
--
332
-- Table structure for table `branch_borrower_circ_rules`
327
-- Table structure for table `branch_borrower_circ_rules`
333
--
328
--
334
329
Lines 971-985 CREATE TABLE collections_tracking ( Link Here
971
  collections_tracking_id integer(11) NOT NULL auto_increment,
966
  collections_tracking_id integer(11) NOT NULL auto_increment,
972
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
967
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
973
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
968
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
974
  PRIMARY KEY (collections_tracking_id)
969
  PRIMARY KEY (collections_tracking_id),
970
  CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE      ON UPDATE CASCADE,
971
  CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CAS     CADE ON UPDATE CASCADE
975
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
972
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
976
973
977
ALTER TABLE `collections_tracking`
978
  ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;
979
980
ALTER TABLE `collections_tracking`
981
  ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
982
983
--
974
--
984
-- Table structure for table `default_branch_item_rules`
975
-- Table structure for table `default_branch_item_rules`
985
--
976
--
986
- 

Return to bug 18606