Lines 1692-1698
CREATE TABLE `branchtransfers` (
Link Here
|
1692 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1692 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1693 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1693 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1694 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1694 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1695 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer', |
1695 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','LibraryFloatLimit') DEFAULT NULL COMMENT 'what triggered the transfer', |
1696 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1696 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1697 |
PRIMARY KEY (`branchtransfer_id`), |
1697 |
PRIMARY KEY (`branchtransfer_id`), |
1698 |
KEY `frombranch` (`frombranch`), |
1698 |
KEY `frombranch` (`frombranch`), |
Lines 6357-6362
CREATE TABLE `transport_cost` (
Link Here
|
6357 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6357 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6358 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6358 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6359 |
|
6359 |
|
|
|
6360 |
DROP TABLE IF EXISTS `library_float_limits`; |
6361 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6362 |
/*!40101 SET character_set_client = utf8 */; |
6363 |
CREATE TABLE `library_float_limits` ( |
6364 |
`branchcode` varchar(10) NOT NULL, |
6365 |
`itemtype` varchar(10) NOT NULL, |
6366 |
`float_limit` int(11) NULL DEFAULT NULL, |
6367 |
PRIMARY KEY (`branchcode`,`itemtype`), |
6368 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
6369 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
6370 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6371 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6372 |
|
6360 |
-- |
6373 |
-- |
6361 |
-- Table structure for table `uploaded_files` |
6374 |
-- Table structure for table `uploaded_files` |
6362 |
-- |
6375 |
-- |