Attachment 168039 Details for Bug 37174 – Data before (which fails) and after (which works) assigning branchcode to all records

Data before (which fails) and after (which works) assigning branchcode to all records

Table circulation_rules (Original and corrected).txt (text/plain), 15.77 KB, created by Michael Zore on 2024-06-24 19:23:17 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Michael Zore

Created: 2024-06-24 19:23:17 UTC

Size: 15.77 KB

patch

obsolete

>===============================================================================
>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;

Actions: View

Attachments on bug 37174: 168039