Re: Query times out when I add extra Where Condition

[John Noble]

Hi Peter,

Im using Win 7 Pro with 8 Gb Ram

I have added in the extra group by clauses

I have changed the innodb_buffer_pool_size to 428 and it has took a second off the query time.

Im not sure how to read the Explain statement. How can I tell where I need to put my indexes ?

Here are the Create Table results....

'salesLedger', 'CREATE TABLE `salesledger` (\n  `accountManagerID` varchar(3) NOT NULL DEFAULT \'\',\n  `AOLP` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `balance` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `bankCharges` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `cash` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `CCmanagerID` varchar(3) NOT NULL DEFAULT \'\',\n  `conversionRate` decimal(10,3) NOT NULL DEFAULT \'0.000\',\n  `costcentre` varchar(1) NOT NULL DEFAULT \'\',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `creditDaysTaken` int(11) NOT NULL DEFAULT \'0\',\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `dateExported` date NOT NULL DEFAULT \'0000-00-00\',\n  `daybook` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `docType` varchar(3) NOT NULL DEFAULT \'\',\n  `discount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `DOLP` date NOT NULL DEFAULT \'0000-00-00\',\n  `dueDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `exportedToSage` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `groupID` varchar(3) NOT NULL DEFAULT \'\',\n  `invNum` int(11) NOT NULL DEFAULT \'0\',\n  `invoiceCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `net` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `netWeight` decimal(14,3) NOT NULL DEFAULT \'0.000\',\n  `orderref` int(11) NOT NULL DEFAULT \'0\',\n  `payable` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `paymentStatus` varchar(1) NOT NULL DEFAULT \' \',\n  `paidToDate` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `PDF` varchar(100) NOT NULL DEFAULT \'\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `receiptNo` int(11) NOT NULL DEFAULT \'0\',\n  `taxCode` varchar(2) NOT NULL DEFAULT \'\',\n  `transactionType` varchar(2) NOT NULL DEFAULT \' \',\n  `userID` varchar(3) NOT NULL DEFAULT \'\',\n  `vat` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `lastUpdated` date NOT NULL DEFAULT \'0001-01-01\',\n  `boxes` int(11) NOT NULL DEFAULT \'0\',\n  `freshFrozen` varchar(1) NOT NULL DEFAULT \'F\',\n  `monthPeriodEndFlag` enum(\'F\',\'T\') NOT NULL DEFAULT \'F\',\n  `comment` varchar(250) NOT NULL DEFAULT \'\',\n  `invoiceLogFlag` enum(\'F\',\'T\') NOT NULL DEFAULT \'F\',\n  `agentID` varchar(3) NOT NULL DEFAULT \'NON\',\n  `accountID` varchar(10) NOT NULL DEFAULT \'\',\n  `daybookNo` int(11) NOT NULL DEFAULT \'0\',\n  `paymentNo` int(12) NOT NULL DEFAULT \'0\',\n  `balAccType` varchar(10) NOT NULL DEFAULT \'\',\n  `ediSent` date NOT NULL DEFAULT \'0001-01-01\',\n  `ediFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `dayBookNo2` int(11) NOT NULL DEFAULT \'0\',\n  `paidInFullDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `businessGroup` varchar(4) NOT NULL DEFAULT \'\',\n  `vatCode` varchar(10) NOT NULL DEFAULT \'\',\n  `nomCode` varchar(4) NOT NULL DEFAULT \'\',\n  `vatReportFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `vatReportDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `bankAmount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `entryDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `unallocatedNo` int(10) NOT NULL DEFAULT \'0\',\n  PRIMARY KEY (`pkey`),\n  KEY `countryID` (`countryID`) USING BTREE,\n  KEY `invNum` (`invNum`) USING BTREE,\n  KEY `customerID` (`customerID`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=3207448 DEFAULT CHARSET=latin1'

'receipts', 'CREATE TABLE `receipts` (\n  `receiptNo` int(12) NOT NULL DEFAULT \'0\',\n  `invNum` int(11) NOT NULL DEFAULT \'0\',\n  `invoiceDate` date NOT NULL,\n  `receiptDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `payInvoiceDate` date NOT NULL,\n  `invoiceamount` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `allocationAmount` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `receiptAmount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `docType` varchar(3) NOT NULL DEFAULT \'\',\n  `comment` varchar(75) DEFAULT NULL,\n  `paymentNo` int(12) NOT NULL DEFAULT \'0\',\n  `creditDaysTaken` int(11) NOT NULL DEFAULT \'0\',\n  `dayBookNo` int(11) NOT NULL DEFAULT \'0\',\n  `unallocatedNo` int(10) NOT NULL DEFAULT \'0\',\n  `masterUnallocated` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  PRIMARY KEY (`pkey`),\n  KEY `invNum` (`invNum`) USING BTREE,\n  KEY `invoiceDate` (`invoiceDate`) USING BTREE,\n  KEY `receiptDate` (`receiptDate`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=310491 DEFAULT CHARSET=latin1'

'countries', 'CREATE TABLE `countries` (\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `country` varchar(20) NOT NULL DEFAULT \' \',\n  `czechName` varchar(20) NOT NULL DEFAULT \' \',\n  `EUMember` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `EUTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `FrenchName` varchar(20) NOT NULL DEFAULT \' \',\n  `GermanName` varchar(20) NOT NULL DEFAULT \' \',\n  `italianName` varchar(20) NOT NULL DEFAULT \' \',\n  `localTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `taxCode` varchar(1) NOT NULL DEFAULT \' \',\n  `freeFormatVatTaxCode` varchar(2) NOT NULL DEFAULT \'\',\n  `name` varchar(30) NOT NULL DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `productSource` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `SlovakianName` varchar(20) NOT NULL DEFAULT \' \',\n  `SpanishName` varchar(20) NOT NULL DEFAULT \' \',\n  `TransportTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `lastUsedBy` varchar(45) DEFAULT \' \',\n  `inUse` varchar(45) DEFAULT \' \',\n  `customerBoardNo` int(10) NOT NULL DEFAULT \'0\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1'

'users', 'CREATE TABLE `users` (\n  `username` varchar(15) NOT NULL DEFAULT \' \',\n  `password` varchar(15) NOT NULL DEFAULT \' \',\n  `Name` varchar(30) NOT NULL DEFAULT \' \',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `entries` int(11) NOT NULL DEFAULT \'0\',\n  `userID` varchar(3) NOT NULL DEFAULT \' \',\n  `Gender` varchar(1) NOT NULL DEFAULT \' \',\n  `loggedIn` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `accountManager` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `ccmanager` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `labelPrinterName` varchar(50) NOT NULL DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `overrideFileMaintenance` enum(\'T\',\'F\') DEFAULT \'F\',\n  `presentationNames` enum(\'T\',\'F\') DEFAULT \'T\',\n  `gradeNames` enum(\'T\',\'F\') DEFAULT \'F\',\n  `customerNames` enum(\'T\',\'F\') DEFAULT \'F\',\n  `modifyOrder` enum(\'T\',\'F\') DEFAULT \'F\',\n  `lastCustomerDownload` date DEFAULT NULL,\n  `emailAddress` varchar(45) DEFAULT \' \',\n  `emailpassword` varchar(45) DEFAULT \' \',\n  `outgoingSMTP` varchar(100) DEFAULT \' \',\n  `emailPort` int(11) DEFAULT \'25\',\n  `lastSalesLedgerDownload` date DEFAULT NULL,\n  `lastBankDownload` date DEFAULT NULL,\n  `copyLocalFiles` enum(\'T\',\'F\') DEFAULT \'T\',\n  `clearProductLine` enum(\'T\',\'F\') DEFAULT \'F\',\n  `customerBoardNo` int(11) DEFAULT \'0\',\n  `currentCustomerBoard` varchar(30) DEFAULT NULL,\n  `PL` enum(\'T\',\'F\') DEFAULT \'F\',\n  `UKSales` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `location` varchar(2) NOT NULL DEFAULT \'\',\n  `generalPostingFromDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `generalPostingToDate` date NOT NULL DEFAULT \'0001-01-01\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1'

'customers', 'CREATE TABLE `customers` (\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `accountManagerID` varchar(3) NOT NULL DEFAULT \' \',\n  `address1` varchar(35) NOT NULL DEFAULT \' \',\n  `accountsEmail` varchar(150) NOT NULL DEFAULT \' \',\n  `address2` varchar(35) NOT NULL DEFAULT \' \',\n  `address3` varchar(35) NOT NULL DEFAULT \' \',\n  `address4` varchar(35) NOT NULL DEFAULT \' \',\n  `AccountSetUp` date NOT NULL DEFAULT \'0000-00-00\',\n  `agentFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `areaID` varchar(2) NOT NULL DEFAULT \' \',\n  `accountsContact` varchar(35) NOT NULL DEFAULT \' \',\n  `balance` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `bankID` varchar(10) NOT NULL DEFAULT \' \',\n  `bankAccount` varchar(20) NOT NULL DEFAULT \' \',\n  `baseRatePence` decimal(8,2) NOT NULL DEFAULT \'0.00\',\n  `baseRateCents` decimal(8,2) NOT NULL DEFAULT \'0.00\',\n  `baseRatePC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `creditLimit` int(11) NOT NULL DEFAULT \'0\',\n  `classification` varchar(1) NOT NULL DEFAULT \' \',\n  `CCmanagerID` varchar(3) NOT NULL DEFAULT \' \',\n  `creditreference` varchar(10) NOT NULL DEFAULT \' \',\n  `creditInfo` varchar(50) NOT NULL DEFAULT \' \',\n  `creditLimitCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `creditFlag` varchar(1) NOT NULL DEFAULT \' \',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `deliveryAddressFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `delTime` varchar(10) NOT NULL DEFAULT \' \',\n  `deliveryTerms` varchar(3) NOT NULL DEFAULT \' \',\n  `discountPC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `discount2PC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `discountPCExtra` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `DOLO` date NOT NULL DEFAULT \'0000-00-00\',\n  `EDI` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `euroCreditLimit` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `expiryDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `Excess` decimal(10,2) NOT NULL DEFAULT \'0.00\',\n  `fax` varchar(20) NOT NULL DEFAULT \' \',\n  `frozen` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `groupID` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceComm` varchar(1) NOT NULL DEFAULT \' \',\n  `invoiceLang` varchar(2) NOT NULL DEFAULT \' \',\n  `InvoiceCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceEmail` varchar(250) NOT NULL DEFAULT \' \',\n  `invoiceEmail2` varchar(250) NOT NULL DEFAULT \' \',\n  `invoiceText` varchar(250) NOT NULL DEFAULT \'\',\n  `invoiceText2` varchar(250) NOT NULL DEFAULT \'\',\n  `labelFormat` varchar(1) NOT NULL DEFAULT \' \',\n  `labelType` int(11) NOT NULL DEFAULT \'0\',\n  `number` varchar(4) NOT NULL DEFAULT \' \',\n  `name` varchar(100) NOT NULL DEFAULT \' \',\n  `name2` varchar(50) NOT NULL DEFAULT \'\',\n  `quotationComm` varchar(1) NOT NULL DEFAULT \' \',\n  `quotationLang` varchar(2) NOT NULL DEFAULT \' \',\n  `quotationEmail` varchar(254) NOT NULL DEFAULT \' \',\n  `quotationEmailFrozen` varchar(254) NOT NULL DEFAULT \'\',\n  `salesContact` varchar(35) NOT NULL DEFAULT \' \',\n  `salesContactEmail` varchar(150) NOT NULL DEFAULT \'\',\n  `searchName` varchar(50) NOT NULL DEFAULT \' \',\n  `shortName` varchar(30) NOT NULL DEFAULT \' \',\n  `salesTemp` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `telephone` varchar(20) NOT NULL DEFAULT \' \',\n  `tradingTermsID` varchar(1) NOT NULL DEFAULT \' \',\n  `transact_userID` varchar(3) NOT NULL DEFAULT \'\',\n  `transportUKID` varchar(2) NOT NULL DEFAULT \' \',\n  `transportEUID1` varchar(3) NOT NULL DEFAULT \' \',\n  `transportUKIDfri` varchar(2) NOT NULL DEFAULT \'\',\n  `transportEUIDfri` varchar(3) NOT NULL DEFAULT \'\',\n  `transportEUID2` varchar(3) NOT NULL DEFAULT \' \',\n  `transportRateEU` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `transportRateEUExtra` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `TermsDays` int(11) NOT NULL DEFAULT \'0\',\n  `transportPencePerKG` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `terms` varchar(3) NOT NULL DEFAULT \' \',\n  `VATreg` varchar(15) NOT NULL DEFAULT \'\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `warehouseID` varchar(1) NOT NULL DEFAULT \'\',\n  `inUse` varchar(25) NOT NULL DEFAULT \' \',\n  `lastUsedBy` varchar(25) NOT NULL DEFAULT \' \',\n  `town` varchar(45) NOT NULL DEFAULT \' \',\n  `postcode` varchar(12) NOT NULL DEFAULT \' \',\n  `blocked` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `customerRefFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `insuranceExcluded` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `printBonDeLivraison` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `printBonDeTransport` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `lastUpdated` date NOT NULL DEFAULT \'0001-01-01\',\n  `kebabBestBeforeDays` int(11) NOT NULL DEFAULT \'0\',\n  `smokedBestBeforeDays` int(11) NOT NULL DEFAULT \'0\',\n  `termsDaysFrozen` int(11) NOT NULL DEFAULT \'0\',\n  `agentID` varchar(8) NOT NULL DEFAULT \'NON\',\n  `quotationFaxNo` varchar(50) NOT NULL DEFAULT \'\',\n  `quotation_Mon` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Tue` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Wed` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Thu` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Fri` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `copyOver` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar01` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `bar3103` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar10` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar15` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `frozenQuotationCode` varchar(1) NOT NULL DEFAULT \'\',\n  `GLN` varchar(20) NOT NULL DEFAULT \'\',\n  `EDIEmail` varchar(50) NOT NULL DEFAULT \'\',\n  `auxID` varchar(25) NOT NULL DEFAULT \'\',\n  `quotationEUFreshCode` varchar(3) NOT NULL DEFAULT \'\',\n  `printEUFresh` varchar(1) NOT NULL DEFAULT \'F\',\n  `quotationEmailText` varchar(254) NOT NULL DEFAULT \'\',\n  `quotationEmailText2` varchar(254) NOT NULL DEFAULT \'\',\n  `quotationEmailText3` varchar(254) NOT NULL DEFAULT \'\',\n  `agentEmail` varchar(254) NOT NULL DEFAULT \'\',\n  `printHardCopy` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `printSpainFresh` varchar(1) NOT NULL DEFAULT \'\',\n  `IC_baseRatePence` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `IC_baseRatePC` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `hasOrderNum` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\' COMMENT \'customers has internal order number (NOT cust reference)\',\n  `showBestBeforeOnInvoice` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `invoiceFaxNo` varchar(20) NOT NULL DEFAULT \'\',\n  `invoiceFaxNo2` varchar(20) NOT NULL DEFAULT \'\',\n  `quotationNewlynEmail` varchar(250) NOT NULL DEFAULT \'\',\n  `newlynBaseRatePence` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `newlynBaseRatePC` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `newlynBaseRateCents` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `quotationNewlynFreshCode` varchar(3) NOT NULL DEFAULT \'\',\n  `printNewlynFresh` varchar(1) NOT NULL DEFAULT \'\',\n  `splitPDFInvoice` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `transportCompany` varchar(30) NOT NULL DEFAULT \'\',\n  `transportCompanyCode` varchar(20) NOT NULL DEFAULT \'\',\n  `hasOverDueBalance` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `lastStatementDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `GLNEDIIV` varchar(20) NOT NULL DEFAULT \'\',\n  `GLNEDIPR` varchar(20) NOT NULL DEFAULT \'\',\n  `statementEmailAddress` varchar(250) NOT NULL DEFAULT \'\',\n  `bestBeforeDateFormat` varchar(10) NOT NULL DEFAULT \'\',\n  `quotationIrishFreshCode` varchar(4) NOT NULL DEFAULT \'\',\n  `isInternal` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `isCustomerRef` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `excludeFromMailings` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  PRIMARY KEY (`pkey`),\n  KEY `customerID` (`customerID`) USING BTREE,\n  KEY `countryID` (`countryID`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=573721 DEFAULT CHARSET=latin1 COMMENT=\'fIELDS TO BE DELETED WHEN READY\\r\\n\\r\\nClassification\\r\\nCreditFlag\\r\\ndeliveryTerms\\r\\nExcess\\r\\ninvoiceLang\\r\\nlabelFormat\\r\\nquotationLang\\r\\nsalesTemp\\r\\ntradingTermsID\\r\\ntransact_userID\\r\\ncustomerRefFlag\\r\\nprintBonDeLivraison\\r\\nprintBonDeTransport\\r\\nkebabBestBeforeDays\\r\\nsmokedBestBeforeDays\\r\\ncopyOver\\r\\n\\r\\n\\r\\n\\r\\nFields to be deleted once new customerquotations is live\\r\\nbaseRatePence\\r\\nbaseRatePC\\r\\nbaseRateCents\\r\\nquotationComm\\r\\nquotationEmail\\r\\nQuotationEMailFrozen\\r\\nquotationFaxNo\\r\\nquotation_Mon\\r\\nquotation_Tue\\r\\nquotation_Wed\\r\\nquotation_Thu\\r\\nquotation_Fri\\r\\nfrozenQuotationCode\\r\\nquotationEUFreshCOde\\r\\nprintEUFresh\\r\\nquotationEmailText\\r\\nquotationEmailText2\\r\\nquotationEmailText3\\r\\nprintSpainFresh\\r\\nIC_baseRatePence\\r\\nIC_baseRatePC\\r\\nquotationNewlynEMail\\r\\nnewlynBaseRatePence\\r\\nnewlynBaseRatePC\\r\\nnewlynBaseRateCents\\r\\nquotationNewlynFreshCode\\r\\nprintNewlynFresh\\r\\n\''
'groups', 'CREATE TABLE `groups` (\n  `ID` varchar(3) NOT NULL DEFAULT \' \',\n  `name` varchar(30) NOT NULL DEFAULT \' \',\n  `invInstructions` varchar(100) NOT NULL DEFAULT \' \',\n  `inUse` varchar(25) DEFAULT \' \',\n  `lastUsedBy` varchar(25) DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `creditReference` varchar(10) DEFAULT NULL,\n  `creditLimit` decimal(12,2) DEFAULT \'0.00\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=1986 DEFAULT CHARSET=latin1'



Thanks again for your help with this. Much appreciated,





John