4PBSVD5h

1CREATE TABLE IF NOT EXISTS inf_tx (
2	id int(11) NOT NULL AUTO_INCREMENT,
3	order_no varchar(191) NOT NULL,
4	inf_shift_id int(11) NOT NULL,
5	sub_total int(11) NOT NULL,
6	pajak int(11) NOT NULL,
7	total int(11) NOT NULL,
8	payment int(11) NOT NULL,
9	'change' int(11) NOT NULL,
10	payment_method_id int(11) NOT NULL,
11	card_no int(11) NULL,
12	created_at timestamp NULL,
13	updated_at timestamp NULL,
14	deleted_at timestamp NULL,
15	PRIMARY KEY (id)
16);
17
18CREATE TABLE IF NOT EXISTS temp_inf_tx (
19	id int(11) NOT NULL AUTO_INCREMENT,
20	order_no varchar(191) NOT NULL,
21	inf_shift_id int(11) NOT NULL,
22	sub_total int(11) NOT NULL,
23	pajak int(11) NOT NULL,
24	total int(11) NOT NULL,
25	card_no int(11) NULL,
26	created_at timestamp NULL,
27	updated_at timestamp NULL,
28	deleted_at timestamp NULL,
29	PRIMARY KEY (id)
30)
31
32
33CREATE TABLE IF NOT EXISTS tx_item (
34	id int(11) NOT NULL AUTO_INCREMENT,
35	inf_item_id int(11) NOT NULL,
36	inf_variant_id int(11) NOT NULL,
37	inf_sales_id int(11) NOT NULL,
38	inf_tx_id int(11) NOT NULL,
39	user_id int(11) NOT NULL,
40	created_at timestamp NULL,
41	updated_at timestamp NULL,
42	deleted_at timestamp NULL,
43	PRIMARY KEY (id)
44)
45
46CREATE TABLE IF NOT EXISTS temp_tx_item (
47	id int(11) NOT NULL AUTO_INCREMENT,
48	inf_item_id int(11) NOT NULL,
49	inf_variant_id int(11) NOT NULL,
50	inf_sales_id int(11) NOT NULL,
51	inf_tx_id int(11) NOT NULL,
52	user_id int(11) NOT NULL,
53	created_at timestamp NULL,
54	updated_at timestamp NULL,
55	deleted_at timestamp NULL,
56	PRIMARY KEY (id)
57)
58
59CREATE TABLE IF NOT EXISTS payment_method (
60	id int(11) NOT NULL AUTO_INCREMENT,
61	name varchar(191) NOT NULL,
62	created_at timestamp NULL,
63	updated_at timestamp NULL,
64	deleted_at timestamp NULL,
65	PRIMARY KEY (id)
66)