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

(-)a/installer/data/mysql/kohastructure.sql (-30 / +29 lines)
Lines 1821-1858 CREATE TABLE `subscriptionroutinglist` ( Link Here
1821
--
1821
--
1822
1822
1823
DROP TABLE IF EXISTS `suggestions`;
1823
DROP TABLE IF EXISTS `suggestions`;
1824
CREATE TABLE `suggestions` (
1824
CREATE TABLE `suggestions` ( -- purchase suggestions
1825
  `suggestionid` int(8) NOT NULL auto_increment,
1825
  `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha
1826
  `suggestedby` int(11) NOT NULL default 0,
1826
  `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
1827
  `suggesteddate` date NOT NULL default 0,
1827
  `suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted
1828
  `managedby` int(11) default NULL,
1828
  `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
1829
  `manageddate` date default NULL,
1829
  `manageddate` date default NULL, -- date the suggestion was updated
1830
   acceptedby INT(11) default NULL,
1830
   acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
1831
   accepteddate date default NULL,
1831
   accepteddate date default NULL, -- date the suggestion was marked as accepted
1832
   rejectedby INT(11) default NULL,
1832
   rejectedby INT(11) default NULL, -- borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table
1833
   rejecteddate date default NULL,
1833
   rejecteddate date default NULL, -- date the suggestion was marked as rejected
1834
  `STATUS` varchar(10) NOT NULL default '',
1834
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
1835
  `note` mediumtext,
1835
  `note` mediumtext, -- note entered on the suggestion
1836
  `author` varchar(80) default NULL,
1836
  `author` varchar(80) default NULL, -- author of the suggested item
1837
  `title` varchar(80) default NULL,
1837
  `title` varchar(80) default NULL, -- title of the suggested item
1838
  `copyrightdate` smallint(6) default NULL,
1838
  `copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item
1839
  `publishercode` varchar(255) default NULL,
1839
  `publishercode` varchar(255) default NULL, -- publisher of the suggested item
1840
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1840
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  -- date and time the suggestion was updated
1841
  `volumedesc` varchar(255) default NULL,
1841
  `volumedesc` varchar(255) default NULL,
1842
  `publicationyear` smallint(6) default 0,
1842
  `publicationyear` smallint(6) default 0,
1843
  `place` varchar(255) default NULL,
1843
  `place` varchar(255) default NULL, -- publication place of the suggested item
1844
  `isbn` varchar(30) default NULL,
1844
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
1845
  `mailoverseeing` smallint(1) default 0,
1845
  `mailoverseeing` smallint(1) default 0,
1846
  `biblionumber` int(11) default NULL,
1846
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
1847
  `reason` text,
1847
  `reason` text, -- reason for making the suggestion
1848
   budgetid INT(11),
1848
   budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table
1849
   branchcode VARCHAR(10) default NULL,
1849
   branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table
1850
   collectiontitle text default NULL,
1850
   collectiontitle text default NULL, -- collection name for the suggested item
1851
   itemtype VARCHAR(30) default NULL,
1851
   itemtype VARCHAR(30) default NULL, -- suggested item type 
1852
	quantity SMALLINT(6) default NULL,
1852
	quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased
1853
	currency VARCHAR(3) default NULL,
1853
	currency VARCHAR(3) default NULL, -- suggested currency for the suggested price
1854
	price DECIMAL(28,6) default NULL,
1854
	price DECIMAL(28,6) default NULL, -- suggested price
1855
	total DECIMAL(28,6) default NULL,
1855
	total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency)
1856
  PRIMARY KEY  (`suggestionid`),
1856
  PRIMARY KEY  (`suggestionid`),
1857
  KEY `suggestedby` (`suggestedby`),
1857
  KEY `suggestedby` (`suggestedby`),
1858
  KEY `managedby` (`managedby`)
1858
  KEY `managedby` (`managedby`)
1859
- 

Return to bug 6716