Re: Partitioning not working need primary key?

[newbie Shai]

Dear Rick,
Yes I read your link is very good and useful information. Below is the show create table.

CREATE TABLE `tblreceipt` (
`receiptID` int(10) NOT NULL,
`previousReceiptID` int(10) NOT NULL default '0',
`outletID` int(2) NOT NULL default '0',
`employeeID` int(2) NOT NULL default '0',
`customerName` varchar(100) NOT NULL default 'Cash',
`customerPhone` varchar(10) default NULL,
`totalCostAmount` double(10,2) NOT NULL,
`totalSellingAmount` double(10,2) NOT NULL,
`totalProfitAmount` double(10,2) NOT NULL,
`changeAmount` double(5,2) NOT NULL,
`profit` enum('y','n') NOT NULL,
`receiptDate` date NOT NULL,
`receiptTime` time NOT NULL,
`receiptType` enum('n','e','f','p') NOT NULL default 'n',
PRIMARY KEY (`receiptID`,`outletID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;