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

(-)a/installer/data/mysql/kohastructure.sql (-31 / +30 lines)
Lines 1382-1403 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1382
-- Table structure for table `old_reserves`
1382
-- Table structure for table `old_reserves`
1383
--
1383
--
1384
DROP TABLE IF EXISTS `old_reserves`;
1384
DROP TABLE IF EXISTS `old_reserves`;
1385
CREATE TABLE `old_reserves` (
1385
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have been completed (either filled or cancelled)
1386
  `borrowernumber` int(11) default NULL,
1386
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1387
  `reservedate` date default NULL,
1387
  `reservedate` date default NULL, -- the date the hold was places
1388
  `biblionumber` int(11) default NULL,
1388
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1389
  `constrainttype` varchar(1) default NULL,
1389
  `constrainttype` varchar(1) default NULL,
1390
  `branchcode` varchar(10) default NULL,
1390
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1391
  `notificationdate` date default NULL,
1391
  `notificationdate` date default NULL, -- currently unused
1392
  `reminderdate` date default NULL,
1392
  `reminderdate` date default NULL, -- currently unused
1393
  `cancellationdate` date default NULL,
1393
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1394
  `reservenotes` mediumtext,
1394
  `reservenotes` mediumtext, -- notes related to this hold
1395
  `priority` smallint(6) default NULL,
1395
  `priority` smallint(6) default NULL, -- where in the queue the patron sits
1396
  `found` varchar(1) default NULL,
1396
  `found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed
1397
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1397
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1398
  `itemnumber` int(11) default NULL,
1398
  `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
1399
  `waitingdate` date default NULL,
1399
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1400
  `expirationdate` DATE DEFAULT NULL,
1400
  `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)
1401
  `lowestPriority` tinyint(1) NOT NULL,
1401
  `lowestPriority` tinyint(1) NOT NULL,
1402
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1402
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1403
  KEY `old_reserves_biblionumber` (`biblionumber`),
1403
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 1557-1578 CREATE TABLE `reserveconstraints` ( Link Here
1557
--
1557
--
1558
1558
1559
DROP TABLE IF EXISTS `reserves`;
1559
DROP TABLE IF EXISTS `reserves`;
1560
CREATE TABLE `reserves` (
1560
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
1561
  `borrowernumber` int(11) NOT NULL default 0,
1561
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1562
  `reservedate` date default NULL,
1562
  `reservedate` date default NULL, -- the date the hold was places
1563
  `biblionumber` int(11) NOT NULL default 0,
1563
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1564
  `constrainttype` varchar(1) default NULL,
1564
  `constrainttype` varchar(1) default NULL,
1565
  `branchcode` varchar(10) default NULL,
1565
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1566
  `notificationdate` date default NULL,
1566
  `notificationdate` date default NULL, -- currently unused
1567
  `reminderdate` date default NULL,
1567
  `reminderdate` date default NULL, -- currently unused
1568
  `cancellationdate` date default NULL,
1568
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1569
  `reservenotes` mediumtext,
1569
  `reservenotes` mediumtext, -- notes related to this hold
1570
  `priority` smallint(6) default NULL,
1570
  `priority` smallint(6) default NULL, -- where in the queue the patron sits
1571
  `found` varchar(1) default NULL,
1571
  `found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed
1572
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1572
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated
1573
  `itemnumber` int(11) default NULL,
1573
  `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
1574
  `waitingdate` date default NULL,
1574
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1575
  `expirationdate` DATE DEFAULT NULL,
1575
  `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)
1576
  `lowestPriority` tinyint(1) NOT NULL,
1576
  `lowestPriority` tinyint(1) NOT NULL,
1577
  KEY priorityfoundidx (priority,found),
1577
  KEY priorityfoundidx (priority,found),
1578
  KEY `borrowernumber` (`borrowernumber`),
1578
  KEY `borrowernumber` (`borrowernumber`),
1579
- 

Return to bug 6716