| 
      
            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 | 
              -   | 
               | 
               |