| 
      
            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`),  | 
            
            
              | 2852 | 
                KEY `branch` (`branch`),  | 
            
        
          | 2851 | 
            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,  | 
        
        
          | 2852 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
          2854 | 
            CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),  | 
        
        
          | 2853 | 
            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 2902-2907
          CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
      
      
        Link Here
      
     | 
  
        
          | 2902 | 
            PRIMARY KEY  (`id`),  | 
          2904 | 
            PRIMARY KEY  (`id`),  | 
        
        
          | 2903 | 
            KEY `listprice` (`listprice`),  | 
          2905 | 
            KEY `listprice` (`listprice`),  | 
        
        
          | 2904 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
          2906 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
        
            
               | 
               | 
              2907 | 
                KEY `name` (`name`(255)),  | 
            
        
          | 2905 | 
            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,  | 
        
        
          | 2906 | 
            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  | 
        
        
          | 2907 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2910 | 
          ) 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  | 
          2930 | 
            `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)  | 
          2931 | 
            `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)  | 
          2932 | 
            `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`)  | 
              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`)  | 
            
        
          | 2931 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2939 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2932 | 
           | 
          2940 | 
           | 
        
        
          | 2933 | 
          --  | 
          2941 | 
          --  | 
        
  
    | 
      
            Lines 2980-2985
          CREATE TABLE `aqbudgets_planning` (
      
      
        Link Here
      
     | 
  
        
          | 2980 | 
            `authvalue` varchar(30) NOT NULL,  | 
          2988 | 
            `authvalue` varchar(30) NOT NULL,  | 
        
        
          | 2981 | 
            `display` tinyint(1) DEFAULT 1,  | 
          2989 | 
            `display` tinyint(1) DEFAULT 1,  | 
        
        
          | 2982 | 
            PRIMARY KEY  (`plan_id`),  | 
          2990 | 
            PRIMARY KEY  (`plan_id`),  | 
        
            
               | 
               | 
              2991 | 
                KEY `budget_id` (`budget_id`),  | 
            
            
              | 2992 | 
                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  | 
          2993 | 
            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;  | 
          2994 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 2985 | 
           | 
          2995 | 
           | 
        
  
    | 
      
            Lines 3003-3008
          CREATE TABLE aqcontacts (
      
      
        Link Here
      
     | 
  
        
          | 3003 | 
            serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages  | 
          3013 | 
            serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages  | 
        
        
          | 3004 | 
            booksellerid int(11) not NULL,  | 
          3014 | 
            booksellerid int(11) not NULL,  | 
        
        
          | 3005 | 
            PRIMARY KEY  (id),  | 
          3015 | 
            PRIMARY KEY  (id),  | 
        
            
               | 
               | 
              3016 | 
                KEY `booksellerid` (`booksellerid`),  | 
            
        
          | 3006 | 
            CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)  | 
          3017 | 
            CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)  | 
        
        
          | 3007 | 
                 REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE  | 
          3018 | 
                 REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 3008 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;  | 
          3019 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;  | 
        
  
    | 
      
            Lines 3020-3025
          CREATE TABLE `aqcontract` (
      
      
        Link Here
      
     | 
  
        
          | 3020 | 
            `contractdescription` mediumtext,  | 
          3031 | 
            `contractdescription` mediumtext,  | 
        
        
          | 3021 | 
            `booksellerid` int(11) not NULL,  | 
          3032 | 
            `booksellerid` int(11) not NULL,  | 
        
        
          | 3022 | 
            PRIMARY KEY  (`contractnumber`),  | 
          3033 | 
            PRIMARY KEY  (`contractnumber`),  | 
        
            
               | 
               | 
              3034 | 
                KEY `booksellerid` (`booksellerid`),  | 
            
        
          | 3023 | 
            CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)  | 
          3035 | 
            CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)  | 
        
        
          | 3024 | 
                 REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          3036 | 
                 REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 3025 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;  | 
          3037 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;  | 
        
  
    | 
      
            Lines 3070-3075
          CREATE TABLE `aqorders` ( -- information related to the basket line items
      
      
        Link Here
      
     | 
  
        
          | 3070 | 
            KEY `basketno` (`basketno`),  | 
          3082 | 
            KEY `basketno` (`basketno`),  | 
        
        
          | 3071 | 
            KEY `biblionumber` (`biblionumber`),  | 
          3083 | 
            KEY `biblionumber` (`biblionumber`),  | 
        
        
          | 3072 | 
            KEY `budget_id` (`budget_id`),  | 
          3084 | 
            KEY `budget_id` (`budget_id`),  | 
        
            
               | 
               | 
              3085 | 
                KEY `invoiceid` (`invoiceid`),  | 
            
            
              | 3086 | 
                KEY `subscriptionid` (`subscriptionid`),  | 
            
            
              | 3087 | 
                KEY `parent_ordernumber` (`parent_ordernumber`),  | 
            
            
              | 3088 | 
                KEY `orderstatus` (`orderstatus`),  | 
            
        
          | 3073 | 
            CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3089 | 
            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,  | 
          3090 | 
            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,  | 
          3091 | 
            CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,  | 
        
  
    | 
      
            Lines 3135-3140
          CREATE TABLE aqinvoices (
      
      
        Link Here
      
     | 
  
        
          | 3135 | 
            shipmentcost decimal(28,6) default NULL,  -- shipment cost  | 
          3151 | 
            shipmentcost decimal(28,6) default NULL,  -- shipment cost  | 
        
        
          | 3136 | 
            shipmentcost_budgetid int(11) default NULL,   -- foreign key to aqbudgets, link the shipment cost to a budget  | 
          3152 | 
            shipmentcost_budgetid int(11) default NULL,   -- foreign key to aqbudgets, link the shipment cost to a budget  | 
        
        
          | 3137 | 
            PRIMARY KEY (invoiceid),  | 
          3153 | 
            PRIMARY KEY (invoiceid),  | 
        
            
               | 
               | 
              3154 | 
                KEY `booksellerid` (`booksellerid`),  | 
            
            
              | 3155 | 
                KEY `shipmentcost_budgetid` (`shipmentcost_budgetid`),  | 
            
        
          | 3138 | 
            CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          3156 | 
            CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 3139 | 
            CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE  | 
          3157 | 
            CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE  | 
        
        
          | 3140 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          3158 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
            
              | 3141 | 
              -   | 
               | 
               |