|
Lines 1720-1726
CREATE TABLE `branchtransfers` (
Link Here
|
| 1720 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1720 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
| 1721 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1721 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
| 1722 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1722 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
| 1723 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer', |
1723 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','LibraryFloatLimit') DEFAULT NULL COMMENT 'what triggered the transfer', |
| 1724 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1724 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
| 1725 |
PRIMARY KEY (`branchtransfer_id`), |
1725 |
PRIMARY KEY (`branchtransfer_id`), |
| 1726 |
KEY `frombranch` (`frombranch`), |
1726 |
KEY `frombranch` (`frombranch`), |
|
Lines 6887-6892
CREATE TABLE `transport_cost` (
Link Here
|
| 6887 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6887 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6888 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6888 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6889 |
|
6889 |
|
|
|
6890 |
DROP TABLE IF EXISTS `library_float_limits`; |
| 6891 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 6892 |
/*!40101 SET character_set_client = utf8 */; |
| 6893 |
CREATE TABLE `library_float_limits` ( |
| 6894 |
`branchcode` varchar(10) NOT NULL, |
| 6895 |
`itemtype` varchar(10) NOT NULL, |
| 6896 |
`float_limit` int(11) NULL DEFAULT NULL, |
| 6897 |
PRIMARY KEY (`branchcode`,`itemtype`), |
| 6898 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 6899 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 6900 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6901 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6902 |
|
| 6890 |
-- |
6903 |
-- |
| 6891 |
-- Table structure for table `uploaded_files` |
6904 |
-- Table structure for table `uploaded_files` |
| 6892 |
-- |
6905 |
-- |