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

(-)a/installer/data/mysql/atomicupdate/bug_19532_-_add_old_recalls_table.sql (-27 lines)
Lines 1-27 Link Here
1 
DROP TABLE IF EXISTS `old_recalls`;
2 
CREATE TABLE `old_recalls` ( -- information related to old recalls in Koha for statistics purposes
3 
    `recall_id` int(11) NOT NULL auto_increment, -- primary key
4 
    `borrowernumber` int(11) NULL default 0, -- foreign key from the borrowers table defining which patron requested a recall
5 
    `recalldate` date default NULL, -- the date the recall request was placed
6 
    `biblionumber` int(11) NULL default 0, -- foreign key from the biblio table defining which bib record this request is for
7 
    `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick up their recall from
8 
    `cancellationdate` date default NULL, -- the date this recall was cancelled
9 
    `recallnotes` mediumtext, -- notes related to this recall
10 
    `priority` smallint(6) default NULL, -- where in the queue the patron sits
11 
    `found` varchar(1) default NULL, -- a one letter code defining what the status is of the recall is after it has been requested. R=requested, O=overdue, W=awaiting pickup, E=expired
12 
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this recall was last updated
13 
    `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the recall request was placed on
14 
    `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
15 
    `expirationdate` DATE DEFAULT NULL, -- the date the recall expires
16 
    `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- the optional itemtype of the item the patron is requesting
17 
    PRIMARY KEY (`recall_id`),
18 
    KEY `old_recalls_borrowernumber` (`borrowernumber`),
19 
    KEY `old_recalls_biblionumber` (`biblionumber`),
20 
    KEY `old_recalls_itemnumber` (`itemnumber`),
21 
    KEY `old_recalls_branchcode` (`branchcode`),
22 
    KEY `old_recalls_itemtype` (`itemtype`),
23 
    CONSTRAINT `old_recalls_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
24 
    CONSTRAINT `old_recalls_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
25 
    CONSTRAINT `old_recalls_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
26 
    CONSTRAINT `old_recalls_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL
27 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/atomicupdate/bug_19532_-_add_recalls_table.sql (-3 / +4 lines)
Lines 1-3 Link Here
1 
DROP TABLE IF EXISTS `old_recalls`;
1 
DROP TABLE IF EXISTS `recalls`;
 2 
DROP TABLE IF EXISTS `recalls`;
2 
CREATE TABLE `recalls` ( -- information related to recalls in Koha
 3 
CREATE TABLE `recalls` ( -- information related to recalls in Koha
3 
    `recall_id` int(11) NOT NULL auto_increment, -- primary key
 4 
    `recall_id` int(11) NOT NULL auto_increment, -- primary key
Lines 8-21 CREATE TABLE `recalls` ( -- information related to recalls in Koha Link Here
8 
    `cancellationdate` date default NULL, -- the date this recall was cancelled
 9 
    `cancellationdate` date default NULL, -- the date this recall was cancelled
9 
    `recallnotes` mediumtext, -- notes related to this recall
 10 
    `recallnotes` mediumtext, -- notes related to this recall
10 
    `priority` smallint(6) default NULL, -- where in the queue the patron sits
 11 
    `priority` smallint(6) default NULL, -- where in the queue the patron sits
11 
    `found` varchar(1) default NULL, -- a one letter code defining what the status is of the recall is after it has been requested. R=requested, O=overdue, W=awaiting pickup, E=expired
 12 
    `status` varchar(1) default NULL, -- a one letter code defining what the status is of the recall is after it has been requested. R=requested, O=overdue, W=awaiting pickup, E=expired, C=cancelled
12 
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this recall was last updated
 13 
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this recall was last updated
13 
    `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the recall request was placed on
 14 
    `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the recall request was placed on
14 
    `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
 15 
    `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
15 
    `expirationdate` DATE DEFAULT NULL, -- the date the recall expires
 16 
    `expirationdate` DATE DEFAULT NULL, -- the date the recall expires
16 
    `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- the optional itemtype of the item the patron is requesting
 17 
    `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- the optional itemtype of the item the patron is requesting
18 
    `old` int(1) default null, -- flag if the recall is old and no longer active, i.e. expired or cancelled
17 
    PRIMARY KEY (`recall_id`),
 19 
    PRIMARY KEY (`recall_id`),
18 
    KEY `priorityfoundidx` (priority,found),
 20 
    KEY `prioritystatusidx` (priority,status),
19 
    KEY `borrowernumber` (`borrowernumber`),
 21 
    KEY `borrowernumber` (`borrowernumber`),
20 
    KEY `biblionumber` (`biblionumber`),
 22 
    KEY `biblionumber` (`biblionumber`),
21 
    KEY `itemnumber` (`itemnumber`),
 23 
    KEY `itemnumber` (`itemnumber`),
22 
-

Return to bug 19532