| 
      
            Lines 2853-2858
          CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
      
      
        Link Here
      
     | 
  
        
          | 2853 | 
            KEY `booksellerid` (`booksellerid`),  | 
          2853 | 
            KEY `booksellerid` (`booksellerid`),  | 
        
        
          | 2854 | 
            KEY `basketgroupid` (`basketgroupid`),  | 
          2854 | 
            KEY `basketgroupid` (`basketgroupid`),  | 
        
        
          | 2855 | 
            KEY `contractnumber` (`contractnumber`),  | 
          2855 | 
            KEY `contractnumber` (`contractnumber`),  | 
        
            
               | 
               | 
              2856 | 
                KEY `authorisedby` (`authorisedby`),  | 
            
        
          | 2856 | 
            CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,  | 
          2857 | 
            CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,  | 
        
        
          | 2857 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
          2858 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
        
        
          | 2858 | 
            CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,  | 
          2859 | 
            CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,  | 
        
  
    | 
      
            Lines 2907-2912
          CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
      
      
        Link Here
      
     | 
  
        
          | 2907 | 
            PRIMARY KEY  (`id`),  | 
          2908 | 
            PRIMARY KEY  (`id`),  | 
        
        
          | 2908 | 
            KEY `listprice` (`listprice`),  | 
          2909 | 
            KEY `listprice` (`listprice`),  | 
        
        
          | 2909 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
          2910 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
        
            
               | 
               | 
              2911 | 
                KEY `name` (`name`(255)),  | 
            
        
          | 2910 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          2912 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 2911 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2913 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2912 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2914 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
  
    | 
      
            Lines 2932-2938
          CREATE TABLE `aqbudgets` ( -- information related to Funds
      
      
        Link Here
      
     | 
  
        
          | 2932 | 
            `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund  | 
          2934 | 
            `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund  | 
        
        
          | 2933 | 
            `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)  | 
          2935 | 
            `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)  | 
        
        
          | 2934 | 
            `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)  | 
          2936 | 
            `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)  | 
        
          
            
              | 2935 | 
                PRIMARY KEY  (`budget_id`)  | 
              2937 | 
                PRIMARY KEY  (`budget_id`),  | 
            
            
               | 
               | 
              2938 | 
                KEY `budget_parent_id` (`budget_parent_id`),  | 
            
            
              | 2939 | 
                KEY `budget_code` (`budget_code`),  | 
            
            
              | 2940 | 
                KEY `budget_branchcode` (`budget_branchcode`),  | 
            
            
              | 2941 | 
                KEY `budget_period_id` (`budget_period_id`),  | 
            
            
              | 2942 | 
                KEY `budget_owner_id` (`budget_owner_id`)  | 
            
        
          | 2936 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2943 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2937 | 
           | 
          2944 | 
           | 
        
        
          | 2938 | 
          --  | 
          2945 | 
          --  | 
        
  
    | 
      
            Lines 2985-2990
          CREATE TABLE `aqbudgets_planning` (
      
      
        Link Here
      
     | 
  
        
          | 2985 | 
            `authvalue` varchar(30) NOT NULL,  | 
          2992 | 
            `authvalue` varchar(30) NOT NULL,  | 
        
        
          | 2986 | 
            `display` tinyint(1) DEFAULT 1,  | 
          2993 | 
            `display` tinyint(1) DEFAULT 1,  | 
        
        
          | 2987 | 
            PRIMARY KEY  (`plan_id`),  | 
          2994 | 
            PRIMARY KEY  (`plan_id`),  | 
        
            
               | 
               | 
              2995 | 
                KEY `budget_period_id` (`budget_period_id`),  | 
            
        
          | 2988 | 
            CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2996 | 
            CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2989 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2997 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2990 | 
           | 
          2998 | 
           | 
        
  
    | 
      
            Lines 3074-3079
          CREATE TABLE `aqorders` ( -- information related to the basket line items
      
      
        Link Here
      
     | 
  
        
          | 3074 | 
            KEY `basketno` (`basketno`),  | 
          3082 | 
            KEY `basketno` (`basketno`),  | 
        
        
          | 3075 | 
            KEY `biblionumber` (`biblionumber`),  | 
          3083 | 
            KEY `biblionumber` (`biblionumber`),  | 
        
        
          | 3076 | 
            KEY `budget_id` (`budget_id`),  | 
          3084 | 
            KEY `budget_id` (`budget_id`),  | 
        
            
               | 
               | 
              3085 | 
                KEY `parent_ordernumber` (`parent_ordernumber`),  | 
            
            
              | 3086 | 
                KEY `orderstatus` (`orderstatus`),  | 
            
        
          | 3077 | 
            CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3087 | 
            CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 3078 | 
            CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3088 | 
            CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 3079 | 
            CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,  | 
          3089 | 
            CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,  | 
        
            
              | 3080 | 
              -   | 
               | 
               |