CREATE TABLE tbltc (
id INT AUTO_INCREMENT PRIMARY KEY,
pn INT NOT NULL,
y INT NOT NULL,
scenario VARCHAR(50) NOT NULL,
billed DATE NOT NULL,
cat CHAR(1) NOT NULL
);
INSERT INTO tbltc (pn, y, scenario, billed, cat) VALUES
(1, 2011, 'Scenario1', '2011-11-18', 'C'),
(1, 2011, 'Scenario1', '2011-11-18', 'C'),
(1, 2011, 'Scenario1', '2011-11-18', 'I'),
(1, 2011, 'Scenario1', '2011-11-22', 'C'),
(1, 2011, 'Scenario1', '2011-11-22', 'C');