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