| Lines 3035-3041
          CREATE TABLE aqbasketusers (
      
      
        Link Here | 
        
          | 3035 | DROP TABLE IF EXISTS `suggestions`; | 3035 | DROP TABLE IF EXISTS `suggestions`; | 
        
          | 3036 | CREATE TABLE `suggestions` ( -- purchase suggestions | 3036 | CREATE TABLE `suggestions` ( -- purchase suggestions | 
        
          | 3037 |   `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha | 3037 |   `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha | 
          
            
              | 3038 |   `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table | 3038 |   `suggestedby` int(11) DEFAULT NULL, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table | 
        
          | 3039 |   `suggesteddate` date NOT NULL, -- date the suggestion was submitted | 3039 |   `suggesteddate` date NOT NULL, -- date the suggestion was submitted | 
        
          | 3040 |   `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table | 3040 |   `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table | 
        
          | 3041 |   `manageddate` date default NULL, -- date the suggestion was updated | 3041 |   `manageddate` date default NULL, -- date the suggestion was updated | 
  
    | Lines 3068-3077
          CREATE TABLE `suggestions` ( -- purchase suggestions
      
      
        Link Here | 
        
          | 3068 |   PRIMARY KEY  (`suggestionid`), | 3068 |   PRIMARY KEY  (`suggestionid`), | 
        
          | 3069 |   KEY `suggestedby` (`suggestedby`), | 3069 |   KEY `suggestedby` (`suggestedby`), | 
        
          | 3070 |   KEY `managedby` (`managedby`), | 3070 |   KEY `managedby` (`managedby`), | 
          
            
              | 3071 |   KEY `status` (`STATUS`), | 3071 |   KEY `acceptedby` (`acceptedby`), | 
            
              |  |  | 3072 |   KEY `rejectedby` (`rejectedby`), | 
        
          | 3072 |   KEY `biblionumber` (`biblionumber`), | 3073 |   KEY `biblionumber` (`biblionumber`), | 
            
              |  |  | 3074 |   KEY `budgetid` (`budgetid`), | 
        
          | 3073 |   KEY `branchcode` (`branchcode`), | 3075 |   KEY `branchcode` (`branchcode`), | 
            
              |  |  | 3076 |   KEY `status` (`STATUS`), | 
            
              | 3077 |   CONSTRAINT `suggestions_ibfk_suggestedby` FOREIGN KEY (`suggestedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3078 |   CONSTRAINT `suggestions_ibfk_managedby` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3079 |   CONSTRAINT `suggestions_ibfk_acceptedby` FOREIGN KEY (`acceptedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3080 |   CONSTRAINT `suggestions_ibfk_rejectedby` FOREIGN KEY (`rejectedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3081 |   CONSTRAINT `suggestions_ibfk_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
        
          | 3074 |   CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE | 3082 |   CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE | 
            
              |  |  | 3083 |   CONSTRAINT `suggestions_ibfk_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, | 
        
          | 3075 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 3084 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 3076 |  | 3085 |  | 
        
          | 3077 | -- | 3086 | -- | 
            
              | 3078 | -  |  |  |