|
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 |
`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 |
-- |