Lines 1701-1707
CREATE TABLE `branchtransfers` (
Link Here
|
1701 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1701 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1702 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1702 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1703 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1703 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1704 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer', |
1704 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','LibraryFloatLimit') DEFAULT NULL COMMENT 'what triggered the transfer', |
1705 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1705 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1706 |
PRIMARY KEY (`branchtransfer_id`), |
1706 |
PRIMARY KEY (`branchtransfer_id`), |
1707 |
KEY `frombranch` (`frombranch`), |
1707 |
KEY `frombranch` (`frombranch`), |
Lines 6418-6423
CREATE TABLE `transport_cost` (
Link Here
|
6418 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6418 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6419 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6419 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6420 |
|
6420 |
|
|
|
6421 |
DROP TABLE IF EXISTS `library_float_limits`; |
6422 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6423 |
/*!40101 SET character_set_client = utf8 */; |
6424 |
CREATE TABLE `library_float_limits` ( |
6425 |
`branchcode` varchar(10) NOT NULL, |
6426 |
`itemtype` varchar(10) NOT NULL, |
6427 |
`float_limit` int(11) NULL DEFAULT NULL, |
6428 |
PRIMARY KEY (`branchcode`,`itemtype`), |
6429 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
6430 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
6431 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6432 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6433 |
|
6421 |
-- |
6434 |
-- |
6422 |
-- Table structure for table `uploaded_files` |
6435 |
-- Table structure for table `uploaded_files` |
6423 |
-- |
6436 |
-- |