Lines 1714-1720
CREATE TABLE `branchtransfers` (
Link Here
|
1714 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1714 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1715 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1715 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1716 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1716 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1717 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer', |
1717 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','LibraryFloatLimit') DEFAULT NULL COMMENT 'what triggered the transfer', |
1718 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1718 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1719 |
PRIMARY KEY (`branchtransfer_id`), |
1719 |
PRIMARY KEY (`branchtransfer_id`), |
1720 |
KEY `frombranch` (`frombranch`), |
1720 |
KEY `frombranch` (`frombranch`), |
Lines 6580-6585
CREATE TABLE `transport_cost` (
Link Here
|
6580 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6580 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6581 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6581 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6582 |
|
6582 |
|
|
|
6583 |
DROP TABLE IF EXISTS `library_float_limits`; |
6584 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6585 |
/*!40101 SET character_set_client = utf8 */; |
6586 |
CREATE TABLE `library_float_limits` ( |
6587 |
`branchcode` varchar(10) NOT NULL, |
6588 |
`itemtype` varchar(10) NOT NULL, |
6589 |
`float_limit` int(11) NULL DEFAULT NULL, |
6590 |
PRIMARY KEY (`branchcode`,`itemtype`), |
6591 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
6592 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
6593 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6594 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6595 |
|
6583 |
-- |
6596 |
-- |
6584 |
-- Table structure for table `uploaded_files` |
6597 |
-- Table structure for table `uploaded_files` |
6585 |
-- |
6598 |
-- |