CREATE TABLE gen_invoice_item (
`id` int(11),
`invoice_id` varchar(50),
`item_name` varchar(500),
`item_price` float,
`item_unit` varchar(50),
`item_qty` float
);

INSERT INTO gen_invoice_item VALUES (N'3',N'3',N'VINYL FLEX',N'8',N'UNT',N'10');
INSERT INTO gen_invoice_item VALUES (N'4',N'3',N'VINYL FLEX',N'8',N'BOX',N'5');
INSERT INTO gen_invoice_item VALUES (N'5',N'3',N'VINYL FLEX',N'8',N'SQF',N'100');
INSERT INTO gen_invoice_item VALUES (N'6',N'4',N'FLEX NORMAL',N'8',N'SQF',N'50');
INSERT INTO gen_invoice_item VALUES (N'7',N'4',N'FLEX NORMAL',N'8',N'SQF',N'45');
INSERT INTO gen_invoice_item VALUES (N'8',N'5',N'wall painting',N'45',N'SQF',N'200');
INSERT INTO gen_invoice_item VALUES (N'9',N'5',N'LABOUR AND MAINTENANCE',N'3500',N'OTH',N'1');
INSERT INTO gen_invoice_item VALUES (N'10',N'5',N'VINYL FLEX',N'8',N'SQF',N'10');
INSERT INTO gen_invoice_item VALUES (N'11',N'6',N'LABOUR AND MAINTENANCE',N'500',N'OTH',N'2');
INSERT INTO gen_invoice_item VALUES (N'12',N'7',N'LABOUR AND MAINTENANCE',N'500',N'OTH',N'2');
INSERT INTO gen_invoice_item VALUES (N'13',N'7',N'VINYL FLEX',N'5',N'SQF',N'50');
INSERT INTO gen_invoice_item VALUES (N'14',N'7',N'wall painting',N'45',N'SQF',N'5');
