CREATE TABLE IF NOT EXISTS inf_tx (
	id int(11) NOT NULL AUTO_INCREMENT,
	order_no varchar(191) NOT NULL,
	inf_shift_id int(11) NOT NULL,
	sub_total int(11) NOT NULL,
	pajak int(11) NOT NULL,
	total int(11) NOT NULL,
	payment int(11) NOT NULL,
	'change' int(11) NOT NULL,
	payment_method_id int(11) NOT NULL,
	card_no int(11) NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	deleted_at timestamp NULL,
	PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS temp_inf_tx (
	id int(11) NOT NULL AUTO_INCREMENT,
	order_no varchar(191) NOT NULL,
	inf_shift_id int(11) NOT NULL,
	sub_total int(11) NOT NULL,
	pajak int(11) NOT NULL,
	total int(11) NOT NULL,
	card_no int(11) NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	deleted_at timestamp NULL,
	PRIMARY KEY (id)
)


CREATE TABLE IF NOT EXISTS tx_item (
	id int(11) NOT NULL AUTO_INCREMENT,
	inf_item_id int(11) NOT NULL,
	inf_variant_id int(11) NOT NULL,
	inf_sales_id int(11) NOT NULL,
	inf_tx_id int(11) NOT NULL,
	user_id int(11) NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	deleted_at timestamp NULL,
	PRIMARY KEY (id)
)

CREATE TABLE IF NOT EXISTS temp_tx_item (
	id int(11) NOT NULL AUTO_INCREMENT,
	inf_item_id int(11) NOT NULL,
	inf_variant_id int(11) NOT NULL,
	inf_sales_id int(11) NOT NULL,
	inf_tx_id int(11) NOT NULL,
	user_id int(11) NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	deleted_at timestamp NULL,
	PRIMARY KEY (id)
)

CREATE TABLE IF NOT EXISTS payment_method (
	id int(11) NOT NULL AUTO_INCREMENT,
	name varchar(191) NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	deleted_at timestamp NULL,
	PRIMARY KEY (id)
)