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

(-)a/installer/data/mysql/kohastructure.sql (-31 / +30 lines)
Lines 1369-1390 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1369
-- Table structure for table `old_reserves`
1369
-- Table structure for table `old_reserves`
1370
--
1370
--
1371
DROP TABLE IF EXISTS `old_reserves`;
1371
DROP TABLE IF EXISTS `old_reserves`;
1372
CREATE TABLE `old_reserves` (
1372
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have been completed (either filled or cancelled)
1373
  `borrowernumber` int(11) default NULL,
1373
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1374
  `reservedate` date default NULL,
1374
  `reservedate` date default NULL, -- the date the hold was places
1375
  `biblionumber` int(11) default NULL,
1375
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1376
  `constrainttype` varchar(1) default NULL,
1376
  `constrainttype` varchar(1) default NULL,
1377
  `branchcode` varchar(10) default NULL,
1377
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1378
  `notificationdate` date default NULL,
1378
  `notificationdate` date default NULL, -- currently unused
1379
  `reminderdate` date default NULL,
1379
  `reminderdate` date default NULL, -- currently unused
1380
  `cancellationdate` date default NULL,
1380
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1381
  `reservenotes` mediumtext,
1381
  `reservenotes` mediumtext, -- notes related to this hold
1382
  `priority` smallint(6) default NULL,
1382
  `priority` smallint(6) default NULL, -- where in the queue the patron sits
1383
  `found` varchar(1) default NULL,
1383
  `found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed
1384
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1384
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1385
  `itemnumber` int(11) default NULL,
1385
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1386
  `waitingdate` date default NULL,
1386
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1387
  `expirationdate` DATE DEFAULT NULL,
1387
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1388
  `lowestPriority` tinyint(1) NOT NULL,
1388
  `lowestPriority` tinyint(1) NOT NULL,
1389
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1389
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1390
  KEY `old_reserves_biblionumber` (`biblionumber`),
1390
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 1544-1565 CREATE TABLE `reserveconstraints` ( Link Here
1544
--
1544
--
1545
1545
1546
DROP TABLE IF EXISTS `reserves`;
1546
DROP TABLE IF EXISTS `reserves`;
1547
CREATE TABLE `reserves` (
1547
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
1548
  `borrowernumber` int(11) NOT NULL default 0,
1548
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1549
  `reservedate` date default NULL,
1549
  `reservedate` date default NULL, -- the date the hold was places
1550
  `biblionumber` int(11) NOT NULL default 0,
1550
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1551
  `constrainttype` varchar(1) default NULL,
1551
  `constrainttype` varchar(1) default NULL,
1552
  `branchcode` varchar(10) default NULL,
1552
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1553
  `notificationdate` date default NULL,
1553
  `notificationdate` date default NULL, -- currently unused
1554
  `reminderdate` date default NULL,
1554
  `reminderdate` date default NULL, -- currently unused
1555
  `cancellationdate` date default NULL,
1555
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1556
  `reservenotes` mediumtext,
1556
  `reservenotes` mediumtext, -- notes related to this hold
1557
  `priority` smallint(6) default NULL,
1557
  `priority` smallint(6) default NULL, -- where in the queue the patron sits
1558
  `found` varchar(1) default NULL,
1558
  `found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed
1559
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1559
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1560
  `itemnumber` int(11) default NULL,
1560
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1561
  `waitingdate` date default NULL,
1561
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1562
  `expirationdate` DATE DEFAULT NULL,
1562
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1563
  `lowestPriority` tinyint(1) NOT NULL,
1563
  `lowestPriority` tinyint(1) NOT NULL,
1564
  KEY priorityfoundidx (priority,found),
1564
  KEY priorityfoundidx (priority,found),
1565
  KEY `borrowernumber` (`borrowernumber`),
1565
  KEY `borrowernumber` (`borrowernumber`),
1566
- 

Return to bug 6716