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 1653-1659 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1653
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1653
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1654
  `reservedate` date default NULL, -- the date the hold was places
1654
  `reservedate` date default NULL, -- the date the hold was places
1655
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1655
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1656
  `constrainttype` varchar(1) default NULL,
1657
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1656
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1658
  `notificationdate` date default NULL, -- currently unused
1657
  `notificationdate` date default NULL, -- currently unused
1659
  `reminderdate` date default NULL, -- currently unused
1658
  `reminderdate` date default NULL, -- currently unused
Lines 1818-1836 CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for Link Here
1818
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1817
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1819
1818
1820
--
1819
--
1821
-- Table structure for table `reserveconstraints`
1822
--
1823
1824
DROP TABLE IF EXISTS `reserveconstraints`;
1825
CREATE TABLE `reserveconstraints` (
1826
  `borrowernumber` int(11) NOT NULL default 0,
1827
  `reservedate` date default NULL,
1828
  `biblionumber` int(11) NOT NULL default 0,
1829
  `biblioitemnumber` int(11) default NULL,
1830
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1831
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1832
1833
--
1834
-- Table structure for table `reserves`
1820
-- Table structure for table `reserves`
1835
--
1821
--
1836
1822
Lines 1840-1846 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1840
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1826
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1841
  `reservedate` date default NULL, -- the date the hold was places
1827
  `reservedate` date default NULL, -- the date the hold was places
1842
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1828
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1843
  `constrainttype` varchar(1) default NULL,
1844
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1829
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1845
  `notificationdate` date default NULL, -- currently unused
1830
  `notificationdate` date default NULL, -- currently unused
1846
  `reminderdate` date default NULL, -- currently unused
1831
  `reminderdate` date default NULL, -- currently unused
1847
- 

Return to bug 9809