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'