docker compose exec postgres sh -lc 'psql -U jpt -d jptdb <<''SQL''
CREATE TABLE IF NOT EXISTS public.dt_print_job (
print_job_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
tenant_id BIGINT NOT NULL,
print_type VARCHAR(20) NOT NULL DEFAULT ''PRODUK'',
product_code VARCHAR(100),
product_name TEXT,
barcode_koli VARCHAR(200),
qty_product INTEGER,
total_product INTEGER,
speed INTEGER DEFAULT 3,
darkness INTEGER DEFAULT 10,
qty INTEGER NOT NULL DEFAULT 0,
printer VARCHAR(50),
status VARCHAR(50) NOT NULL DEFAULT ''PENDING'',
file_path TEXT,
file_size BIGINT,
request_id VARCHAR(100) NOT NULL,
batch_id VARCHAR(100),
error_message TEXT,
started_at VARCHAR(14),
completed_at VARCHAR(14),
wrap INTEGER DEFAULT 15,
line INTEGER DEFAULT 2,
version BIGINT,
create_datetime VARCHAR(14),
create_user_id BIGINT,
update_datetime VARCHAR(14),
update_user_id BIGINT
);
SQL'






docker compose exec postgres sh -lc 'psql -U jpt -d jptdb <<''SQL''
CREATE SEQUENCE IF NOT EXISTS public.dt_print_job_seq;
CREATE TABLE IF NOT EXISTS public.dt_print_job (
print_job_id BIGINT NOT NULL DEFAULT nextval(''public.dt_print_job_seq''),
tenant_id BIGINT NOT NULL,
print_type VARCHAR(20) NOT NULL DEFAULT ''PRODUK'',
product_code VARCHAR(100),
product_name TEXT,
barcode_koli VARCHAR(200),
qty_product INTEGER,
total_product INTEGER,
speed INTEGER DEFAULT 3,
darkness INTEGER DEFAULT 10,
qty INTEGER NOT NULL DEFAULT 0,
printer VARCHAR(50),
status VARCHAR(50) NOT NULL DEFAULT ''PENDING'',
file_path TEXT,
file_size BIGINT,
request_id VARCHAR(100) NOT NULL,
batch_id VARCHAR(100),
error_message TEXT,
started_at VARCHAR(14),
completed_at VARCHAR(14),
wrap INTEGER DEFAULT 15,
line INTEGER DEFAULT 2,
version BIGINT,
create_datetime VARCHAR(14),
create_user_id BIGINT,
update_datetime VARCHAR(14),
update_user_id BIGINT,
CONSTRAINT dt_print_job_pkey PRIMARY KEY (print_job_id)
);
ALTER SEQUENCE public.dt_print_job_seq OWNED BY public.dt_print_job.print_job_id;
SQL'