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

(-)a/installer/data/mysql/atomicupdate/bug_9809-drop_table_reserveconstraints.sql (+5 lines)
Line 0 Link Here
1
DROP TABLE IF EXISTS reserveconstraints;
2
3
ALTER TABLE reserves DROP constrainttype;
4
5
ALTER TABLE old_reserves DROP constrainttype;
(-)a/installer/data/mysql/kohastructure.sql (-16 lines)
Lines 1652-1658 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1652
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1652
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1653
  `reservedate` date default NULL, -- the date the hold was places
1653
  `reservedate` date default NULL, -- the date the hold was places
1654
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1654
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1655
  `constrainttype` varchar(1) default NULL,
1656
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1655
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1657
  `notificationdate` date default NULL, -- currently unused
1656
  `notificationdate` date default NULL, -- currently unused
1658
  `reminderdate` date default NULL, -- currently unused
1657
  `reminderdate` date default NULL, -- currently unused
Lines 1817-1835 CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for Link Here
1817
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1816
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1818
1817
1819
--
1818
--
1820
-- Table structure for table `reserveconstraints`
1821
--
1822
1823
DROP TABLE IF EXISTS `reserveconstraints`;
1824
CREATE TABLE `reserveconstraints` (
1825
  `borrowernumber` int(11) NOT NULL default 0,
1826
  `reservedate` date default NULL,
1827
  `biblionumber` int(11) NOT NULL default 0,
1828
  `biblioitemnumber` int(11) default NULL,
1829
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1830
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1831
1832
--
1833
-- Table structure for table `reserves`
1819
-- Table structure for table `reserves`
1834
--
1820
--
1835
1821
Lines 1839-1845 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1839
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1825
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1840
  `reservedate` date default NULL, -- the date the hold was places
1826
  `reservedate` date default NULL, -- the date the hold was places
1841
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1827
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1842
  `constrainttype` varchar(1) default NULL,
1843
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1828
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1844
  `notificationdate` date default NULL, -- currently unused
1829
  `notificationdate` date default NULL, -- currently unused
1845
  `reminderdate` date default NULL, -- currently unused
1830
  `reminderdate` date default NULL, -- currently unused
1846
- 

Return to bug 9809