CREATE TABLE `plus2_invoice_dtl` ( `dtl_id` int(11) NOT NULL, `inv_id` int(6) NOT NULL, `p_id` int(4) NOT NULL, `product` varchar(50) NOT NULL, `qty` int(3) NOT NULL, `price` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `plus2_invoice_dtl` -- INSERT INTO `plus2_invoice_dtl` (`dtl_id`, `inv_id`, `p_id`, `product`, `qty`, `price`) VALUES (1, 4, 5, 'Pen Drive', 3, 12.3), (2, 4, 4, 'CPU', 4, 56), (3, 4, 7, 'Power Unit', 6, 12.36), (4, 5, 3, 'Moniter', 2, 20.45), (5, 5, 5, 'Pen Drive', 3, 8.5), (6, 6, 4, 'CPU', 2, 20.35), (7, 6, 6, 'Operating System', 3, 10.23); -- -------------------------------------------------------- -- -- Table structure for table `plus2_product` -- CREATE TABLE `plus2_product` ( `p_id` int(11) NOT NULL, `p_name` varchar(25) NOT NULL, `price` float(8,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `plus2_product` -- INSERT INTO `plus2_product` (`p_id`, `p_name`, `price`) VALUES (1, 'Mouse', 12.34), (2, 'Key Board', 18.76), (3, 'Moniter', 20.45), (4, 'CPU', 20.35), (5, 'Pen Drive', 8.50), (6, 'Operating System', 10.23), (7, 'Power Unit', 20.35); -- -------------------------------------------------------- -- -- Table structure for table `plus2_product_receive` -- CREATE TABLE `plus2_product_receive` ( `id` int(11) NOT NULL, `p_id` int(3) NOT NULL, `product` varchar(20) NOT NULL, `price` float NOT NULL, `qty` int(3) NOT NULL, `dt` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `plus2_product_receive` -- INSERT INTO `plus2_product_receive` (`id`, `p_id`, `product`, `price`, `qty`, `dt`) VALUES (1, 3, 'Moniter', 32.25, 5, '2023-01-03'), (2, 1, 'Mouse', 20.35, 10, '2023-01-02'), (3, 4, 'CPU', 45.56, 8, '2023-01-01'), (4, 5, 'Pen Drive', 35.65, 21, '2023-01-01'), (5, 6, 'Operating System', 12.35, 8, '2023-01-02'), (6, 7, 'Power Unit', 12.54, 8, '2023-01-02'), (7, 2, 'Key Board', 12.54, 8, '2023-01-02'), (8, 4, 'CPU', 12.35, 8, '2023-01-02'), (9, 5, 'Pen Drive', 12.36, 4, '2023-01-02'), (10, 3, 'Moniter', 35.68, 9, '2023-01-03'); -- -- Indexes for dumped tables -- -- -- Indexes for table `plus2_invoice_dtl` -- ALTER TABLE `plus2_invoice_dtl` ADD PRIMARY KEY (`dtl_id`); -- -- Indexes for table `plus2_product` -- ALTER TABLE `plus2_product` ADD PRIMARY KEY (`p_id`); -- -- Indexes for table `plus2_product_receive` -- ALTER TABLE `plus2_product_receive` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `plus2_invoice_dtl` -- ALTER TABLE `plus2_invoice_dtl` MODIFY `dtl_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `plus2_product` -- ALTER TABLE `plus2_product` MODIFY `p_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `plus2_product_receive` -- ALTER TABLE `plus2_product_receive` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; COMMIT;