Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
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'
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)