=============================================================================== ORIGINAL TABLE DATA =============================================================================== -- -- Table structure for table `circulation_rules` -- DROP TABLE IF EXISTS `circulation_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `circulation_rules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `branchcode` varchar(10) DEFAULT NULL, `categorycode` varchar(10) DEFAULT NULL, `itemtype` varchar(10) DEFAULT NULL, `rule_name` varchar(32) NOT NULL, `rule_value` varchar(32) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `branchcode` (`branchcode`,`categorycode`,`itemtype`,`rule_name`), KEY `circ_rules_ibfk_2` (`categorycode`), KEY `circ_rules_ibfk_3` (`itemtype`), KEY `rule_name` (`rule_name`), CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `circulation_rules` -- LOCK TABLES `circulation_rules` WRITE; /*!40000 ALTER TABLE `circulation_rules` DISABLE KEYS */; INSERT INTO `circulation_rules` VALUES (1,'FCC',NULL,NULL,'no_auto_renewal_after',''),(2,'FCC',NULL,NULL,'maxonsiteissueqty',''),(3,'FCC',NULL,NULL,'maxissueqty',''),(4,'FCC',NULL,NULL,'issuelength','21'),(5,'FCC',NULL,NULL,'cap_fine_to_replacement_price',''),(6,'FCC',NULL,NULL,'overduefinescap',''),(7,'FCC',NULL,NULL,'hardduedatecompare','-1'),(8,'FCC',NULL,NULL,'auto_renew','0'),(9,'FCC',NULL,NULL,'maxsuspensiondays',''),(11,'FCC',NULL,NULL,'finedays',''),(12,'FCC',NULL,NULL,'holds_per_day',''),(13,'FCC',NULL,NULL,'onshelfholds','1'),(14,'FCC',NULL,NULL,'lengthunit','days'),(15,'FCC',NULL,NULL,'firstremind',''),(16,'FCC',NULL,NULL,'renewalsallowed',''),(17,'FCC',NULL,NULL,'chargeperiod',''),(18,'FCC',NULL,NULL,'article_requests','no'),(19,'FCC',NULL,NULL,'no_auto_renewal_after_hard_limit',''),(20,'FCC',NULL,NULL,'opacitemholds','N'),(21,'FCC',NULL,NULL,'reservesallowed',''),(22,'FCC',NULL,NULL,'renewalperiod',''),(23,'FCC',NULL,NULL,'chargeperiod_charge_at','0'),(25,'FCC',NULL,NULL,'norenewalbefore',''),(26,'FCC',NULL,NULL,'holds_per_record',''),(27,'FCC',NULL,NULL,'fine',''),(55,NULL,NULL,NULL,'onshelfholds','1'),(56,NULL,NULL,NULL,'firstremind',''),(57,NULL,NULL,NULL,'renewalsallowed','4'),(58,NULL,NULL,NULL,'hardduedatecompare','-1'),(60,NULL,NULL,NULL,'chargeperiod',''),(61,NULL,NULL,NULL,'lengthunit','days'),(62,NULL,NULL,NULL,'fine',''),(63,NULL,NULL,NULL,'auto_renew','1'),(64,NULL,NULL,NULL,'article_requests','no'),(65,NULL,NULL,NULL,'renewalperiod','15'),(66,NULL,NULL,NULL,'overduefinescap','0.00'),(67,NULL,NULL,NULL,'cap_fine_to_replacement_price',''),(68,NULL,NULL,NULL,'opacitemholds','N'),(69,NULL,NULL,NULL,'note',''),(70,NULL,NULL,NULL,'norenewalbefore',''),(71,NULL,NULL,NULL,'holds_per_record',''),(72,NULL,NULL,NULL,'no_auto_renewal_after',''),(73,NULL,NULL,NULL,'chargeperiod_charge_at','0'),(74,NULL,NULL,NULL,'finedays',''),(75,NULL,NULL,NULL,'suspension_chargeperiod','1'),(76,NULL,NULL,NULL,'reservesallowed',''),(77,NULL,NULL,NULL,'no_auto_renewal_after_hard_limit',''),(78,NULL,NULL,NULL,'maxsuspensiondays',''),(79,NULL,NULL,NULL,'holds_per_day',''),(80,NULL,NULL,NULL,'maxonsiteissueqty',''),(81,NULL,NULL,NULL,'maxissueqty',''),(82,'FCC',NULL,NULL,'lostreturn','refund'),(83,NULL,'CHURCH',NULL,'suspension_chargeperiod','1'),(84,NULL,'CHURCH',NULL,'maxissueqty',''),(85,NULL,'CHURCH',NULL,'finedays',''),(86,NULL,'CHURCH',NULL,'renewalperiod','14'),(87,NULL,'CHURCH',NULL,'note',''),(88,NULL,'CHURCH',NULL,'opacitemholds','N'),(89,NULL,'CHURCH',NULL,'maxonsiteissueqty',''),(90,NULL,'CHURCH',NULL,'hardduedatecompare','-1'),(91,NULL,'CHURCH',NULL,'holds_per_record',''),(92,NULL,'CHURCH',NULL,'norenewalbefore',''),(93,NULL,'CHURCH',NULL,'holds_per_day',''),(94,NULL,'CHURCH',NULL,'overduefinescap','0.00'),(96,NULL,'CHURCH',NULL,'onshelfholds','1'),(97,NULL,'CHURCH',NULL,'maxsuspensiondays',''),(98,NULL,'CHURCH',NULL,'article_requests','no'),(99,NULL,'CHURCH',NULL,'chargeperiod_charge_at','0'),(100,NULL,'CHURCH',NULL,'no_auto_renewal_after',''),(101,NULL,'CHURCH',NULL,'lengthunit','days'),(102,NULL,'CHURCH',NULL,'reservesallowed',''),(103,NULL,'CHURCH',NULL,'cap_fine_to_replacement_price',''),(104,NULL,'CHURCH',NULL,'fine','0.00'),(105,NULL,'CHURCH',NULL,'no_auto_renewal_after_hard_limit',''),(106,NULL,'CHURCH',NULL,'renewalsallowed','3'),(107,NULL,'CHURCH',NULL,'firstremind',''),(108,NULL,'CHURCH',NULL,'auto_renew','1'),(109,NULL,'CHURCH',NULL,'chargeperiod',''),(110,NULL,NULL,NULL,'decreaseloanholds',''),(111,NULL,NULL,NULL,'unseen_renewals_allowed',''),(112,NULL,'CHURCH',NULL,'daysmode',''),(113,'FCC',NULL,NULL,'daysmode',''),(114,'FCC',NULL,NULL,'suspension_chargeperiod','1'),(115,'FCC',NULL,NULL,'note',''),(116,NULL,'CHURCH',NULL,'issuelength','21'),(117,NULL,NULL,NULL,'waiting_hold_cancellation','0'),(118,NULL,NULL,NULL,'issuelength','21'),(119,NULL,'CHURCH',NULL,'decreaseloanholds',''),(120,'FCC',NULL,NULL,'decreaseloanholds',''),(122,NULL,NULL,NULL,'rentaldiscount','0'),(123,NULL,'CHURCH',NULL,'rentaldiscount','0'),(124,'FCC',NULL,NULL,'rentaldiscount','0'),(125,NULL,NULL,NULL,'hardduedate',''),(126,NULL,'CHURCH',NULL,'hardduedate',''),(127,'FCC',NULL,NULL,'hardduedate',''),(128,NULL,'CHURCH',NULL,'unseen_renewals_allowed',''),(129,'FCC',NULL,NULL,'unseen_renewals_allowed',''),(130,NULL,NULL,NULL,'daysmode',''),(131,NULL,'ADMIN',NULL,'norenewalbefore',''),(132,NULL,'ADMIN',NULL,'no_auto_renewal_after_hard_limit',''),(133,NULL,'ADMIN',NULL,'cap_fine_to_replacement_price',''),(134,NULL,'ADMIN',NULL,'lengthunit','days'),(135,NULL,'ADMIN',NULL,'onshelfholds','1'),(136,NULL,'ADMIN',NULL,'renewalperiod','15'),(137,NULL,'ADMIN',NULL,'chargeperiod',''),(138,NULL,'ADMIN',NULL,'holds_per_day',''),(139,NULL,'ADMIN',NULL,'maxonsiteissueqty',''),(140,NULL,'ADMIN',NULL,'maxissueqty',''),(141,NULL,'ADMIN',NULL,'suspension_chargeperiod','1'),(142,NULL,'ADMIN',NULL,'issuelength','21'),(143,NULL,'ADMIN',NULL,'hardduedatecompare','-1'),(144,NULL,'ADMIN',NULL,'opacitemholds','N'),(145,NULL,'ADMIN',NULL,'article_requests','no'),(146,NULL,'ADMIN',NULL,'auto_renew','1'),(147,NULL,'ADMIN',NULL,'holds_per_record',''),(148,NULL,'ADMIN',NULL,'hardduedate',''),(149,NULL,'ADMIN',NULL,'overduefinescap','0.00'),(150,NULL,'ADMIN',NULL,'reservesallowed',''),(151,NULL,'ADMIN',NULL,'decreaseloanholds',''),(152,NULL,'ADMIN',NULL,'rentaldiscount','0'),(153,NULL,'ADMIN',NULL,'firstremind',''),(154,NULL,'ADMIN',NULL,'renewalsallowed','4'),(155,NULL,'ADMIN',NULL,'unseen_renewals_allowed',''),(156,NULL,'ADMIN',NULL,'chargeperiod_charge_at','0'),(157,NULL,'ADMIN',NULL,'daysmode',''),(158,NULL,'ADMIN',NULL,'fine',''),(159,NULL,'ADMIN',NULL,'no_auto_renewal_after',''),(160,NULL,'ADMIN',NULL,'note',''),(161,NULL,'ADMIN',NULL,'maxsuspensiondays',''),(162,NULL,'ADMIN',NULL,'finedays',''); /*!40000 ALTER TABLE `circulation_rules` ENABLE KEYS */; UNLOCK TABLES; =============================================================================== POST CORRECTION =============================================================================== -- MySQL dump 10.13 Distrib 8.0.37, for Linux (x86_64) -- -- Host: 127.0.0.1 Database: koha_fcclibrary -- ------------------------------------------------------ -- Server version 8.0.37-0ubuntu0.22.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `circulation_rules` -- DROP TABLE IF EXISTS `circulation_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `circulation_rules` ( `id` int NOT NULL AUTO_INCREMENT, `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rule_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `rule_value` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `branchcode` (`branchcode`,`categorycode`,`itemtype`,`rule_name`), KEY `circ_rules_ibfk_2` (`categorycode`), KEY `circ_rules_ibfk_3` (`itemtype`), KEY `rule_name` (`rule_name`), CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `circulation_rules` -- LOCK TABLES `circulation_rules` WRITE; /*!40000 ALTER TABLE `circulation_rules` DISABLE KEYS */; INSERT INTO `circulation_rules` VALUES (1,'FCC',NULL,NULL,'no_auto_renewal_after',''),(2,'FCC',NULL,NULL,'maxonsiteissueqty',''),(3,'FCC',NULL,NULL,'maxissueqty',''),(4,'FCC',NULL,NULL,'issuelength','21'),(5,'FCC',NULL,NULL,'cap_fine_to_replacement_price',''),(6,'FCC',NULL,NULL,'overduefinescap',''),(7,'FCC',NULL,NULL,'hardduedatecompare','-1'),(8,'FCC',NULL,NULL,'auto_renew','0'),(9,'FCC',NULL,NULL,'maxsuspensiondays',''),(11,'FCC',NULL,NULL,'finedays',''),(12,'FCC',NULL,NULL,'holds_per_day',''),(13,'FCC',NULL,NULL,'onshelfholds','1'),(14,'FCC',NULL,NULL,'lengthunit','days'),(15,'FCC',NULL,NULL,'firstremind',''),(16,'FCC',NULL,NULL,'renewalsallowed',''),(17,'FCC',NULL,NULL,'chargeperiod',''),(18,'FCC',NULL,NULL,'article_requests','no'),(19,'FCC',NULL,NULL,'no_auto_renewal_after_hard_limit',''),(20,'FCC',NULL,NULL,'opacitemholds','N'),(21,'FCC',NULL,NULL,'reservesallowed',''),(22,'FCC',NULL,NULL,'renewalperiod',''),(23,'FCC',NULL,NULL,'chargeperiod_charge_at','0'),(25,'FCC',NULL,NULL,'norenewalbefore',''),(26,'FCC',NULL,NULL,'holds_per_record',''),(27,'FCC',NULL,NULL,'fine',''),(55,'FCC',NULL,NULL,'onshelfholds','1'),(56,'FCC',NULL,NULL,'firstremind',''),(57,'FCC',NULL,NULL,'renewalsallowed','4'),(58,'FCC',NULL,NULL,'hardduedatecompare','-1'),(60,'FCC',NULL,NULL,'chargeperiod',''),(61,'FCC',NULL,NULL,'lengthunit','days'),(62,'FCC',NULL,NULL,'fine',''),(63,'FCC',NULL,NULL,'auto_renew','1'),(64,'FCC',NULL,NULL,'article_requests','no'),(65,'FCC',NULL,NULL,'renewalperiod','15'),(66,'FCC',NULL,NULL,'overduefinescap','0.00'),(67,'FCC',NULL,NULL,'cap_fine_to_replacement_price',''),(68,'FCC',NULL,NULL,'opacitemholds','N'),(69,'FCC',NULL,NULL,'note',''),(70,'FCC',NULL,NULL,'norenewalbefore',''),(71,'FCC',NULL,NULL,'holds_per_record',''),(72,'FCC',NULL,NULL,'no_auto_renewal_after',''),(73,'FCC',NULL,NULL,'chargeperiod_charge_at','0'),(74,'FCC',NULL,NULL,'finedays',''),(75,'FCC',NULL,NULL,'suspension_chargeperiod','1'),(76,'FCC',NULL,NULL,'reservesallowed',''),(77,'FCC',NULL,NULL,'no_auto_renewal_after_hard_limit',''),(78,'FCC',NULL,NULL,'maxsuspensiondays',''),(79,'FCC',NULL,NULL,'holds_per_day',''),(80,'FCC',NULL,NULL,'maxonsiteissueqty',''),(81,'FCC',NULL,NULL,'maxissueqty',''),(82,'FCC',NULL,NULL,'lostreturn','refund'),(83,'FCC','CHURCH',NULL,'suspension_chargeperiod','1'),(84,'FCC','CHURCH',NULL,'maxissueqty',''),(85,'FCC','CHURCH',NULL,'finedays',''),(86,'FCC','CHURCH',NULL,'renewalperiod','14'),(87,'FCC','CHURCH',NULL,'note',''),(88,'FCC','CHURCH',NULL,'opacitemholds','N'),(89,'FCC','CHURCH',NULL,'maxonsiteissueqty',''),(90,'FCC','CHURCH',NULL,'hardduedatecompare','-1'),(91,'FCC','CHURCH',NULL,'holds_per_record',''),(92,'FCC','CHURCH',NULL,'norenewalbefore',''),(93,'FCC','CHURCH',NULL,'holds_per_day',''),(94,'FCC','CHURCH',NULL,'overduefinescap',''),(96,'FCC','CHURCH',NULL,'onshelfholds','1'),(97,'FCC','CHURCH',NULL,'maxsuspensiondays',''),(98,'FCC','CHURCH',NULL,'article_requests','no'),(99,'FCC','CHURCH',NULL,'chargeperiod_charge_at','0'),(100,'FCC','CHURCH',NULL,'no_auto_renewal_after',''),(101,'FCC','CHURCH',NULL,'lengthunit','days'),(102,'FCC','CHURCH',NULL,'reservesallowed',''),(103,'FCC','CHURCH',NULL,'cap_fine_to_replacement_price',''),(104,'FCC','CHURCH',NULL,'fine','0.00'),(105,'FCC','CHURCH',NULL,'no_auto_renewal_after_hard_limit',''),(106,'FCC','CHURCH',NULL,'renewalsallowed','5'),(107,'FCC','CHURCH',NULL,'firstremind',''),(108,'FCC','CHURCH',NULL,'auto_renew','1'),(109,'FCC','CHURCH',NULL,'chargeperiod',''),(110,'FCC',NULL,NULL,'decreaseloanholds',''),(111,'FCC',NULL,NULL,'unseen_renewals_allowed',''),(112,'FCC','CHURCH',NULL,'daysmode',''),(113,'FCC',NULL,NULL,'daysmode',''),(114,'FCC',NULL,NULL,'suspension_chargeperiod','1'),(115,'FCC',NULL,NULL,'note',''),(116,'FCC','CHURCH',NULL,'issuelength','21'),(117,'FCC',NULL,NULL,'waiting_hold_cancellation','0'),(118,'FCC',NULL,NULL,'issuelength','21'),(119,'FCC','CHURCH',NULL,'decreaseloanholds',''),(120,'FCC',NULL,NULL,'decreaseloanholds',''),(122,'FCC',NULL,NULL,'rentaldiscount','0'),(123,'FCC','CHURCH',NULL,'rentaldiscount','0'),(124,'FCC',NULL,NULL,'rentaldiscount','0'),(125,'FCC',NULL,NULL,'hardduedate',''),(126,'FCC','CHURCH',NULL,'hardduedate',''),(127,'FCC',NULL,NULL,'hardduedate',''),(128,'FCC','CHURCH',NULL,'unseen_renewals_allowed',''),(129,'FCC',NULL,NULL,'unseen_renewals_allowed',''),(130,'FCC',NULL,NULL,'daysmode',''),(131,'FCC','ADMIN',NULL,'norenewalbefore',''),(132,'FCC','ADMIN',NULL,'no_auto_renewal_after_hard_limit',''),(133,'FCC','ADMIN',NULL,'cap_fine_to_replacement_price',''),(134,'FCC','ADMIN',NULL,'lengthunit','days'),(135,'FCC','ADMIN',NULL,'onshelfholds','1'),(136,'FCC','ADMIN',NULL,'renewalperiod','15'),(137,'FCC','ADMIN',NULL,'chargeperiod',''),(138,'FCC','ADMIN',NULL,'holds_per_day',''),(139,'FCC','ADMIN',NULL,'maxonsiteissueqty',''),(140,'FCC','ADMIN',NULL,'maxissueqty',''),(141,'FCC','ADMIN',NULL,'suspension_chargeperiod','1'),(142,'FCC','ADMIN',NULL,'issuelength','21'),(143,'FCC','ADMIN',NULL,'hardduedatecompare','-1'),(144,'FCC','ADMIN',NULL,'opacitemholds','N'),(145,'FCC','ADMIN',NULL,'article_requests','no'),(146,'FCC','ADMIN',NULL,'auto_renew','1'),(147,'FCC','ADMIN',NULL,'holds_per_record',''),(148,'FCC','ADMIN',NULL,'hardduedate',''),(149,'FCC','ADMIN',NULL,'overduefinescap','0.00'),(150,'FCC','ADMIN',NULL,'reservesallowed',''),(151,'FCC','ADMIN',NULL,'decreaseloanholds',''),(152,'FCC','ADMIN',NULL,'rentaldiscount','0'),(153,'FCC','ADMIN',NULL,'firstremind',''),(154,'FCC','ADMIN',NULL,'renewalsallowed','4'),(155,'FCC','ADMIN',NULL,'unseen_renewals_allowed',''),(156,'FCC','ADMIN',NULL,'chargeperiod_charge_at','0'),(157,'FCC','ADMIN',NULL,'daysmode',''),(158,'FCC','ADMIN',NULL,'fine',''),(159,'FCC','ADMIN',NULL,'no_auto_renewal_after',''),(160,'FCC','ADMIN',NULL,'note',''),(161,'FCC','ADMIN',NULL,'maxsuspensiondays',''),(162,'FCC','ADMIN',NULL,'finedays',''),(163,'FCC',NULL,NULL,'noautorenewalbefore',''),(164,'FCC',NULL,NULL,'noautorenewalbefore',''),(165,'FCC','CHURCH',NULL,'noautorenewalbefore',''),(166,'FCC','ADMIN',NULL,'noautorenewalbefore',''),(167,'FCC',NULL,NULL,'holds_pickup_period',''),(168,'FCC','CHURCH',NULL,'holds_pickup_period',''); /*!40000 ALTER TABLE `circulation_rules` ENABLE KEYS */; UNLOCK TABLES;