-- Adminer 4.7.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `invoice_order_item`;
CREATE TABLE `invoice_order_item` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `item_code` varchar(250) NOT NULL,
  `item_name` varchar(250) NOT NULL,
  `order_item_quantity` decimal(10,2) NOT NULL,
  `order_item_price` decimal(10,2) NOT NULL,
  `order_item_final_amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `invoice_order_item` (`order_item_id`, `order_id`, `item_code`, `item_name`, `order_item_quantity`, `order_item_price`, `order_item_final_amount`) VALUES
(4100,	2,	'13555',	'Face Mask',	120.00,	2000.00,	240000.00),
(4101,	2,	'34',	'mobile',	10.00,	10000.00,	100000.00),
(4102,	2,	'34',	'mobile battery',	1.00,	34343.00,	34343.00),
(4103,	2,	'34',	'mobile cover',	10.00,	200.00,	2000.00),
(4104,	2,	'36',	'testing',	1.00,	2400.00,	2400.00),
(4364,	682,	'123456',	'iphone 6s',	12.00,	25000.00,	300000.00),
(4365,	682,	'345678',	'one plus',	10.00,	45000.00,	450000.00),
(4368,	683,	'00123',	'iphone 12',	10.00,	80000.00,	800000.00),
(4369,	683,	'00124',	'iphone 8',	13.00,	40000.00,	520000.00),
(4384,	689,	'123',	'kabek',	33.00,	3.00,	99.00),
(4385,	690,	'456',	'radio',	3.00,	345.88,	1037.64),
(4386,	691,	'5678',	'Motor',	3.00,	3456.88,	10370.64);

-- 2024-03-04 18:03:47