| 
      
            Lines 2848-2853
          CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
      
      
        Link Here
      
     | 
  
        
          | 2848 | 
            KEY `booksellerid` (`booksellerid`),  | 
          2848 | 
            KEY `booksellerid` (`booksellerid`),  | 
        
        
          | 2849 | 
            KEY `basketgroupid` (`basketgroupid`),  | 
          2849 | 
            KEY `basketgroupid` (`basketgroupid`),  | 
        
        
          | 2850 | 
            KEY `contractnumber` (`contractnumber`),  | 
          2850 | 
            KEY `contractnumber` (`contractnumber`),  | 
        
            
               | 
               | 
              2851 | 
                KEY `authorisedby` (`authorisedby`),  | 
            
        
          | 2851 | 
            CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,  | 
          2852 | 
            CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,  | 
        
        
          | 2852 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
          2853 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
        
        
          | 2853 | 
            CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,  | 
          2854 | 
            CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,  | 
        
  
    | 
      
            Lines 2902-2907
          CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
      
      
        Link Here
      
     | 
  
        
          | 2902 | 
            PRIMARY KEY  (`id`),  | 
          2903 | 
            PRIMARY KEY  (`id`),  | 
        
        
          | 2903 | 
            KEY `listprice` (`listprice`),  | 
          2904 | 
            KEY `listprice` (`listprice`),  | 
        
        
          | 2904 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
          2905 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
        
            
               | 
               | 
              2906 | 
                KEY `name` (`name`(255)),  | 
            
        
          | 2905 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          2907 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 2906 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2908 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2907 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2909 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
  
    | 
      
            Lines 2927-2933
          CREATE TABLE `aqbudgets` ( -- information related to Funds
      
      
        Link Here
      
     | 
  
        
          | 2927 | 
            `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund  | 
          2929 | 
            `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund  | 
        
        
          | 2928 | 
            `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)  | 
          2930 | 
            `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)  | 
        
        
          | 2929 | 
            `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)  | 
          2931 | 
            `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)  | 
        
          
            
              | 2930 | 
                PRIMARY KEY  (`budget_id`)  | 
              2932 | 
                PRIMARY KEY  (`budget_id`),  | 
            
            
               | 
               | 
              2933 | 
                KEY `budget_parent_id` (`budget_parent_id`),  | 
            
            
              | 2934 | 
                KEY `budget_code` (`budget_code`),  | 
            
            
              | 2935 | 
                KEY `budget_branchcode` (`budget_branchcode`),  | 
            
            
              | 2936 | 
                KEY `budget_period_id` (`budget_period_id`),  | 
            
            
              | 2937 | 
                KEY `budget_owner_id` (`budget_owner_id`),  | 
            
        
          | 2931 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2938 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2932 | 
           | 
          2939 | 
           | 
        
        
          | 2933 | 
          --  | 
          2940 | 
          --  | 
        
  
    | 
      
            Lines 2980-2985
          CREATE TABLE `aqbudgets_planning` (
      
      
        Link Here
      
     | 
  
        
          | 2980 | 
            `authvalue` varchar(30) NOT NULL,  | 
          2987 | 
            `authvalue` varchar(30) NOT NULL,  | 
        
        
          | 2981 | 
            `display` tinyint(1) DEFAULT 1,  | 
          2988 | 
            `display` tinyint(1) DEFAULT 1,  | 
        
        
          | 2982 | 
            PRIMARY KEY  (`plan_id`),  | 
          2989 | 
            PRIMARY KEY  (`plan_id`),  | 
        
            
               | 
               | 
              2990 | 
                KEY `budget_period_id` (`budget_period_id`),  | 
            
        
          | 2983 | 
            CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2991 | 
            CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2984 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2992 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2985 | 
           | 
          2993 | 
           | 
        
  
    | 
      
            Lines 3070-3075
          CREATE TABLE `aqorders` ( -- information related to the basket line items
      
      
        Link Here
      
     | 
  
        
          | 3070 | 
            KEY `basketno` (`basketno`),  | 
          3078 | 
            KEY `basketno` (`basketno`),  | 
        
        
          | 3071 | 
            KEY `biblionumber` (`biblionumber`),  | 
          3079 | 
            KEY `biblionumber` (`biblionumber`),  | 
        
        
          | 3072 | 
            KEY `budget_id` (`budget_id`),  | 
          3080 | 
            KEY `budget_id` (`budget_id`),  | 
        
            
               | 
               | 
              3081 | 
                KEY `parent_ordernumber` (`parent_ordernumber`),  | 
            
            
              | 3082 | 
                KEY `orderstatus` (`orderstatus`),  | 
            
        
          | 3073 | 
            CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3083 | 
            CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 3074 | 
            CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3084 | 
            CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 3075 | 
            CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,  | 
          3085 | 
            CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,  | 
        
            
              | 3076 | 
              -   | 
               | 
               |