View | Details | Raw Unified | Return to bug 19469
Collapse All | Expand All

(-)a/reserves_bug19469.sql (-1 / +79 lines)
Line 0 Link Here
0
- 
1
-- MySQL dump 10.15  Distrib 10.0.32-MariaDB, for debian-linux-gnu (x86_64)
2
--
3
-- Host: localhost    Database: koha_kohadev
4
-- ------------------------------------------------------
5
-- Server version	10.0.32-MariaDB-0+deb8u1
6
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES utf8 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18
--
19
-- Table structure for table `reserves`
20
--
21
22
DROP TABLE IF EXISTS `reserves`;
23
/*!40101 SET @saved_cs_client     = @@character_set_client */;
24
/*!40101 SET character_set_client = utf8 */;
25
CREATE TABLE `reserves` (
26
  `reserve_id` int(11) NOT NULL AUTO_INCREMENT,
27
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
28
  `reservedate` date DEFAULT NULL,
29
  `biblionumber` int(11) NOT NULL DEFAULT '0',
30
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
31
  `notificationdate` date DEFAULT NULL,
32
  `reminderdate` date DEFAULT NULL,
33
  `cancellationdate` date DEFAULT NULL,
34
  `reservenotes` longtext COLLATE utf8mb4_unicode_ci,
35
  `priority` smallint(6) DEFAULT NULL,
36
  `found` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
37
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
38
  `itemnumber` int(11) DEFAULT NULL,
39
  `waitingdate` date DEFAULT NULL,
40
  `expirationdate` date DEFAULT NULL,
41
  `lowestPriority` tinyint(1) NOT NULL DEFAULT '0',
42
  `suspend` tinyint(1) NOT NULL DEFAULT '0',
43
  `suspend_until` datetime DEFAULT NULL,
44
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
45
  PRIMARY KEY (`reserve_id`),
46
  KEY `priorityfoundidx` (`priority`,`found`),
47
  KEY `borrowernumber` (`borrowernumber`),
48
  KEY `biblionumber` (`biblionumber`),
49
  KEY `itemnumber` (`itemnumber`),
50
  KEY `branchcode` (`branchcode`),
51
  KEY `itemtype` (`itemtype`),
52
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
53
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
54
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
55
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
56
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
57
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
58
/*!40101 SET character_set_client = @saved_cs_client */;
59
60
--
61
-- Dumping data for table `reserves`
62
--
63
64
LOCK TABLES `reserves` WRITE;
65
/*!40000 ALTER TABLE `reserves` DISABLE KEYS */;
66
INSERT INTO `reserves` VALUES (16,4,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',5,NULL,'2018-04-16 19:07:47',875,NULL,NULL,0,0,NULL,NULL),(17,18,'2018-04-16',394,'FRL',NULL,NULL,NULL,'',4,NULL,'2018-04-16 19:07:47',876,NULL,NULL,0,0,NULL,NULL),(18,31,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',3,NULL,'2018-04-16 18:54:35',877,NULL,NULL,0,0,NULL,NULL),(19,21,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',8,NULL,'2018-04-16 19:07:47',878,NULL,NULL,1,0,NULL,NULL),(20,45,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',2,NULL,'2018-04-16 18:54:35',876,NULL,NULL,0,0,NULL,NULL),(21,5,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',1,NULL,'2018-04-16 18:54:35',876,NULL,NULL,0,0,NULL,NULL),(22,15,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',9,NULL,'2018-04-16 19:07:47',NULL,NULL,NULL,1,0,NULL,'BK'),(23,7,'2018-04-16',394,'FRL',NULL,NULL,NULL,'',6,NULL,'2018-04-16 19:07:47',877,NULL,NULL,0,0,NULL,NULL),(24,46,'2018-04-16',394,'CPL',NULL,NULL,NULL,'',7,NULL,'2018-04-16 19:07:47',875,NULL,NULL,0,0,NULL,NULL);
67
/*!40000 ALTER TABLE `reserves` ENABLE KEYS */;
68
UNLOCK TABLES;
69
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
70
71
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
72
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
73
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
74
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
75
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
76
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
77
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
78
79
-- Dump completed on 2018-04-16 16:10:26

Return to bug 19469